Updated: March 16, 2020 1:46pm

Boolean Fields

Boolean values are a common programming data type. Prism uses boolean values to indicate an "on/off" status for the field. A common example is the Active flag. If the Active checkbox is selected, the setting is "on" and the item or record is active; if not selected, the item or record is inactive. Before Prism 1.14.6, these flag fields were integer fields, with zero representing the "off" state and 1 representing the "on" state. Now, these flag fields are represented by the Boolean data type, with False representing the "off" state and True representing the "on" state.
The following table lists the Boolean fields that are available in each Prism area.

Boolean Field Description
Adjustment  
UseVat False = The store for which the adjustment was made does not use VAT.
True = The store for which the adjustment was made does use VAT.
Audited False = The document is not marked as Audited
True = The document is marked as Audited.
Cms False = The document has not been posted to the RIL Oracle database.
True = The document has been posted to the RIL Oracle database.
Verified

False = The document has not been marked as Verified.
True = The document has been marked as Verified.

Held False = The document is not on hold.
True = The document is on hold.
GL Flag False = The document has not been sent to the General Ledger for accounting purposes.
True = The document has been sent to the General Ledger for accounting purposes.
CopiedFlag False = The document has not been copied.
True = The document has been copied.
Biometrics  
Active

False = The biometric record is not active.
True = The biometric record is active.

Comment  
Active False = The comment is inactive.
True = The comment is active.
Default Value False = The comment value is not marked as the default.
True = The comment value is marked as the default.
Currency  
Active False = The currency is inactive.
True = The currency is active.
Internal Flag False = The currency is not user-defined.
True = The currency is user-defined.
CurrencyDenomination  
Active False = The currency denomination is inactive.
True = The currency denomination is active.
Customer and CustomerList  
 AcceptChecks    False = Checks are not accepted from the customer.
True = Checks are accepted from the customer.
QBLink

False = Not exported to QBLink.
True = Exported to QBLink.

Detax False = The customer is not a detax customer.
True = The customer is a detax customer.
Segmented False = The customer was not included in a customer bin and scoring or customer segmentation operation.
True = The customer was included in a customer bin and scoring or customer segmentation operation.
EmployeeAsCustomer False = The customer is not also an employee.
True = The customer is also an employee.
LtyOptIn False = The customer has not opted in to a loyalty program.
True = The customer has opted in to a loyalty program.
LtyLvlLocked False = The customer's loyalty level is not locked.
True = The customer's loyalty level is locked.
LtyOptInManual False = The customer's opt-in flag was not manually set.
True = The customer's opt-in flag was manually set.
CustomerUDF  
Required False = Field entry is not required for the UDF field.
True = Field entry is required for the UDF field.
Dcs  
Regional False = Not a regional department.
True = Regional department.
DocCoupon  
Applied False = Coupon not applied.
True = Coupon applied.
DocDeposit  
DocDepositFlag False = Deposit not required.
True = Deposit required.
DocDepositTaken False = Deposit not yet taken.
True = Deposit taken.
DocItem  
DetaxFlag    False = Item not eligible for detax.
True = Item eligible for detax.
Promotion  
GiftAddValue

False = Not a gift add value.
True = Results in gift add value.

StPrimary False = Is not Ship To Primary
True = Is Ship To Primary.
StDetaxFlag False = The Ship To Customer is not a detax customer.
True = The Ship To Customer is a detax customer.
SendSaleFlag False = The order is not a send sale.
True = The order is a send sale.
SoCancelFlag False = Is not on cancelled sales order.
True = Is on cancelled sales order.
IsCompetingComponent False = Is not competing package item component.
True = Is competing package item component.
PromoMandisc False = The promotion does not allow manual discounts.
True = The promotion allows manual discounts.
TaxPercLock False = The tax percentage is not locked.
True = The tax percentage is locked.
DocPosFlag  
IsRequired False = The POS flag is not required.
True = The POS flag is required.
DocPosFlagOption  
IsActive False = The POS Flag option is inactive.
True = The POS Flag option is active.
DocTender  
Matched False = The Non-Currency media listing on the Z-Out was not matched with its physical counterpart (e.g. credit card slip or gift certificate).
True = The Non-Currency media was matched with its physical counterpart.
Document  
 UseVat False = The store where the document was created does not use VAT.
True = The store where the document was created uses VAT.
WasAudited False = The document has not been marked as Audited.
True = The document has been marked as Audited.
IsHeld False = The document is not held.
True = The document is held.
DetaxFlag False = The document is not detaxed.
True = The document is detaxed.
BtPrimary False = Is not Bill To Primary
True = Is Bill To Primary.
StPrimary False = Is not Ship To Primary
True = Is Ship To Primary.
BtDetaxFlag False = The Bill To customer's Detax flag is not selected, indicating the customer is not eligible for detax.
True = The Bill To customer's Detax flag is selected, indicating the customer is eligible for detax.
StDetaxFlag False = The Ship To customer's Detax flag is not selected, indicating the customer is not eligible for detax.
True = The Ship To customer's Detax flag is selected, indicating the customer is eligible for detax.
FeeTaxIncluded1 - Fee Tax Included5 False = Tax is not included on the fee.
True = Tax is included on the fee.
ShippingTaxIncluded False = Tax is not included on shipping
True = Tax is included on shipping
ShipPartial

False = Partial shipments are not allowed.
True = Partial shipments are allowed.

SoCancelFlag False = The order was not flagged as canceled.
True = The order was flagged as canceled.
OrderFeeTaxIncluded1 False = Tax is not included on the order fee.
True = Tax is included on the order fee.
OrderShippingTaxIncluded

False = Tax is not included on the order shipping amount.
True = Tax is included on the order shipping amount.

OrderChangedFlag False = The order was not flagged as changed.
True = The order was flagged as changed.
PromoGdmanDisc False = The document does not have manually entered global discount.
True = The document has a manually entered global discount.
HasSale False = The document does not have a sale item.
True = The document has a sale item.
HasReturn False = The document does not have a return item.
True = The document has a return item.
HasDeposit False = The document does not have a deposit associated with it.
True = The document has a deposit associated with it.
SsFulfillment False = The document does not fulfill a send sale.
True = The document fulfills a send sale.
DocumentFeeType  
  TaxIncluded False = The fee type does not have tax included.
True = The fee type has tax included.
CustRequired False = A transaction with the fee type does not require a customer.
True = A transaction with the fee type requires a customer.
AllowTaxExemption False = The fee type may not be exempted from tax.
True = The fee type may be exempted from tax.
Active False = The fee type is inactive.
True = The fee type is active.
DrawerEvent  
Active False = The drawer event record is inactive.
True = The drawer event is active.
EmployeeSubsidiary  
 AccessAllStores False = Not able to access all stores in the subsidiary.
True - Able to access all stores in the subsidiary.
EmployeeUdf  
Required False = The employee UDF field is not required.
True = The employee UDF field is required.
EmployeeUDFOption  
Active False = The employee UDF option is inactive.
True = The employee UDF option is active.
Inventory  
ForceOrigTax

False = If the Force Orig Tax flag is NOT selected for an item on a receipt or SO, the tax amount for the item is calculated based on the discounted price. Important! The Force Orig Tax flag does not affect global (document-level) discounts or Percentage Reward programs. Default setting is False

True =  With the flag selected, when the item is listed on a transaction, Tax for the item is calculated based on the original (non-discounted price) rather than the discounted price. That is, the Price for the currently active price level in Inventory is used to calculate the Tax % and Tax Amt for the item.

InvnKit  
Active False = The Kit item is inactive.
True = The Kit item is active.
InvnLot  
Active False = The Lot Number is inactive.
True = The Lot Number is active.
InvnLoyalty  
Active False = The item is not in an item-based loyalty program.
True = The item is in an item-based loyalty program.
InvnSerialQty  
Active False = The item's serial quantity is inactive.
True = The item's serial quantity is active.
Received False = The item serial quantity was not received on a voucher.
True = The item serial quantity was received on a voucher.
Sold False = The item serial quantity was not sold on a receipt.
True = The item serial quantity was sold on a receipt.
Transferred False = The item serial quantity was not transferred on a slip.
True = The item serial quantity was transferred on a slip.
SoReserved False = The item serial quantity was listed on a sales order.
True = The item serial quantity was listed on a sales order.
Returned False = Not returned.
True = Returned.
ReturnedToVnd False = Not returned to vendor.
True = Returned to vendor.
Adjusted False = Not adjusted.
True = Adjusted.
InvnUdf  
Required False = The inventory UDF field is not required.
True = The inventory UDF field is required.
Job  
Active False = The job is inactive.
True = The job is active.
LtyCustCentral  
LtyOptIn False = Customer not opted in to loyalty.
True = Customer is opted in to loyalty.
LtyLvlLocked False = Customer's loyalty level is not locked.
True = Customer's loyalty level is locked.
LtyOptInManual False = Customer's opt-in flag was not set manually.
True = Customer's opt-in flag was set manually.
LtyCustPgmGiven  
Active False = Inactive loyalty program.
True = Active loyalty program.
LtyCustPointsHist  
Reverse False = The loyalty customer points history was not reversed.
True = The loyalty customer points history was reversed.
LtyCustPointsReward  
Reverse False = The loyalty customer points reward was not reversed.
True = The loyalty customer points reward was reversed.
LtyLevel  
Active False = The loyalty level is inactive.
True = The loyalty level is active.
LtyLevelProgram  
Active False = The loyalty level is inactive.
True = The loyalty level is active.
PriceLevel  
Secured False = The price level is not secured.
True = The price level is secured.
UseDiscPerc

False = The price level discount is not applied when using the price level.

True = The price level discount is applied when using the price level.

Active False = Inactive price level.
True = Active price level.
PrintAreaValue  
OverrideFlag False = Override is not allowed.
True = Override is allowed.
ShowPrintButton False = Print button is not displayed.
True = Print button is displayed.
ShowEmailButton False = Email button is not displayed.
True = Email button is displayed.
ShowPrintEmailButton False = Print/Email button is not displayed.
True = Print/Email button is displayed.
ShowPreviewButton False = Preview button is not displayed.
True = Preview button is displayed.
ShowPrinterSelection False = Printer selection dropdown is not displayed.
True = Printer selection dropdown is displayed.
ShowDesignSelection False = Design selection dropdown is not displayed.
True = Design selection dropdown is displayed.
Show NumberCopies False = Select number of copies dropdown is not displayed.
True = Select number of copies dropdown is displayed.
EmailPreviewFlag False = Email Preview button is not displayed.
True = Email Preview button is displayed.
PromotionsList  
Active False = The promotion is inactive.
True = The promotion is active.
PurchaseOrder  
FromSo False = The purchase order was not generated from a sales order.
True = The purchase order was generated from a sales order.
UseVat False = The store where the purchase order was created does not use VAT.
True = The store where the purchase order was created uses VAT.
Cms False = The purchase order was not created in RIL.
True = The purchase order was created in RIL.
Active False = The purchase order is inactive.
True = The purchase order is active.
Verified False = The purchase order is not verified.
True = The purchase order is verified.
Held  
Unverified False = The purchase order is verified.
True = The purchase order is unverified.
PendingPo False = The PO is not a pending PO.
True = The PO is a pending PO.
PendingOverride False = Is not a pending override.
True = Is a pending override.
PurchFeeType  
Active

False = The purchase order fee type is inactive.
True = The purchase order fee type is active.

Reason  
IsActive False = The reason is not active.
True = The reason is active.
IsDefault False = The reason is not a default reason.
True = The reason is a default reason.
IsCustRequired False = Customer not required for the fee type.
True = Customer required for the fee type.
Manual False = Is not available to be applied manually.
True = Is available to be applied manually.
Receiving  
UpdatePriceFlag False = The voucher did not result in inventory prices being updated.
True = The voucher updated inventory prices.
UseVat False = The store where the voucher was created does not use VAT.
True = The store where the voucher was created uses VAT.
Audited False = The voucher has not been marked audited.
True = The voucher is marked Audited.
Cms False = The voucher was not created in RIL.
True = The voucher was created in RIL.
Verified False = The voucher was not marked verified.
True = The voucher was marked verified.
Held False = The voucher is not held.
True = The voucher is held.
Active False = The voucher is not active.
True = The voucher is active.
PendingOverride False = Is not a pending override.
True = Is a pending override.
BrMarked  
RecvItem  
SnActive False = The voucher item's serial number is inactive.
True = The voucher item's serial number is active.
SnReceived False = The voucher item's serial number has not been received on a voucher.
True = The voucher item's serial number has been received on a voucher.
SnSold

False = The voucher item's serial number has not been sold on a receipt.
True = The voucher item's serial number has been sold on a receipt.

SnTransferred False = The voucher item's serial number is not transferred.
True = The voucher item's serial number is transferred.
SnSoReserved False = The voucher item's serial number has not been listed on a sales order and therefore is not reserved.
True = The voucher item's serial number has been listed on a sales order and therefore is reserved.
SnReturned False = The voucher item's serial number has not been returned on a return receipt.
True = The voucher item's serial number has been returned on a return receipt.
SnReturnedToVnd False = The voucher item's serial number has not been returned to vendor.
True = The voucher item's serial number has been returned to vendor.
SnAdjusted False = The voucher item's serial number has not been listed on adjustment memo.
True = The voucher item's serial number has been listed on an adjustment memo.
RecvPackage False = The voucher item's packages have not been received.
True = The voucher item's packages have been received.
VouHeld False = The voucher item is not on a held voucher.
True = The voucher item is on a held voucher.
 VouActive False = The voucher item is not on an active voucher.
True = The voucher item is on an active voucher.
Scale  
Active False = The scale is not active.
True = The scale is active.
ShippingMethod  
Active The shipping method is inactive.
The shipping method is active.
SlipItem  
SnActive False = The slip item's serial number is inactive.
True = The slip item's serial number is active.
SnReceived False - The slip item's serial number has not been listed on a voucher.
True = The slip item's serial number has been listed on a voucher.
SnSold False = The slip item's serial number has not been sold on a receipt.
True = The slip item's serial number has been sold on a receipt.
SnTransferred False = The slip item's serial number has not been listed on a transfer slip.
True = The slip item's serial number has been listed on a transfer slip. (Note: On slips, this flag will always be True)
SnSoReserved False = The slip item's serial number does not have the SO Reserved flag selected.
True = The slip item's serial number has the SO Reserved flag selected.
SnReturned False = The slip item's serial number has not been listed on a return receipt.
True = The slip item's serial number has been listed on a return receipt.
SnReturnedToVnd False = The slip item's serial number has not been listed on a return voucher.
True = The slip item's serial number has been listed on a return voucher.
SnAdjusted False = The slip item's serial number has not been listed on an adjustment memo.
True = The slip item's serial number has been listed on an adjustment memo.
Store  
IsEcommerceCatalog    False = Is not an E-commerce catalog item.
True = Is an E-commerce catalog item.
IsWebstoreCatalog False = Is not a web store catalog item.
True = Is a web store catalog item.
StoreCurrency  
Active False = The Currency is not active.
True = The currency is active.
Subsidiary  
Master False = Subsidiary is not a master subsidiary (Regional inventory feature, which is future release).
True = Subsidiary is a master subsidiary for regional inventory.
TaxCode  
IsDefault False = Tax code is not the default tax code.
True = Tax code is the default tax code.
TenderCreditCard  
IsNormalSale False = Tender is not a normal sale.
True = Tender is part of a normal sale.
IsPresent False = Credit card is not present
True = Credit card (and cardholder) is present.
TenderDebitCard  
IsCardPresent False = The debit card (and cardholder) is not physically present/
True = The debit card is physically present.
TenderGiftCard  
IsPresent

False = The gift card (and cardholder) is not physically present.
True = The gift card is physically present.

TranFeeType  
Active False = The transfer fee type is inactive.
True= The transfer fee type is active.
TransferOrder  
UseVat False = The store where the transfer order was created does not use VAT.
True = The store where the transfer order was created uses VAT.
Active False = The transfer order is inactive.
True = The transfer order is active.
Verified False = The transfer order is not verified.
True = The transfer order is verified.
Held False = The transfer order is not held
True = The transfer order is held.
Cms False = The transfer order was not created in RIL (or Retail Pro 9).
True = The transfer order was created in RIL.
TransferSlip  
UseVat False = The slip was created at a store that does not use VAT.
True = The slip was created at a store that uses VAT.
Verified False = The slip is not verified.
True = The slip is verified.
Active False = The slip is not active.
True = The slip is active.
Audited False = The slip is not audited.
True = The slip is audited.
Cms False = The slip was not created in RIL.
True = The slip was created in RIL.
Held False = The slip is not held.
True = The slip is held.
Unverified False = The slip is verified.
True = The slip is unverified.
TransformDesign  
PrintFl False = The design does not result in the Print button being enabled.
True = The design does result in the Print button being enabled.
EmailFl False = The design does not result in the Email button being enabled.
True = The design does result in the Email button being enabled.
PreviewFl False = The design does not result in the Preview button being enabled.
True = The design does result in the Preview button being enabled.
UserdefinedFlag

False = The design is a default design.
True = The design is a custom design, created by the user.

Vendor  
Regional True = Vendor is a regional vendor
False = Vendor is not a regional vendor
Vendor Invoice  
Active

True = Vendor invoice is active,
False = Vendor invoice is inactive.

Vendor UDFs  
Required

True = An entry is required for the Vendor UDF field.
False = An entry is not required for the Vendor UDF field.

Workstation  
Active

False = The workstation is inactive.
True = The workstation is active.

Auto Logout False = The workstation is not configured to auto logout the employee.
True = The workstation is configured to auto logout the employee.
CMS

False = The document was not created in RIL.
True = The document was created in RIL.

Z-Out Control  
Force Close

True = The Z-Out has been forcibly closed
False = The Z-Out has not been forcibly closed.