SalesReceiptLineRet

SalesReceiptLineRet (old ->SalesReceiptLineDetail)

FIELD NAME	FIELD NAME (old)	QUERYABLE	UPDATEABLE	REQUIRED ON UPDATE	INSERTABLE	REQUIRED ON INSERT
TxnLineID		true
ItemRef_ListID		true
ItemRef_FullName		true
Desc		true
Quantity		true
UnitOfMeasure		true
OverrideUOMSetRef_ListID		true
OverrideUOMSetRef_FullName		true
Rate		true
RatePercent		true
ClassRef_ListID		true
ClassRef_FullName		true
Amount		true
TaxAmount		true
InvSiteRef_ListID		true
InvSiteRef_FullName		true
InvSiteLocRef_ListID		true
InvSiteLocRef_FullName		true
SerialNumber		true
LotNumber		true
ServiceDate		true
SalesTaxCodeRef_ListID		true
SalesTaxCodeRef_FullName		true
Other1		true
Other2		true
CCTII_CreditCardNumber		true
CCTII_ExpirationMonth		true
CCTII_ExpirationYear		true
CCTII_NameOnCard		true
CCTII_CreditCardAddress		true
CCTII_CreditCardPostalCode		true
CCTII_CommercialCardCode		true
CCTII_TransactionMode		true
CCTII_CreditCardTxnType		true
CCTRI_ResultCode		true
CCTRI_ResultMessage		true
CCTRI_CreditCardTransID		true
CCTRI_MerchantAccountNumber		true
CCTRI_AuthorizationCode		true
CCTRI_AVSStreet		true
CCTRI_AVSZip		true
CCTRI_CardSecurityCodeMatch		true
CCTRI_ReconBatchID		true
CCTRI_PaymentGroupingCode		true
CCTRI_PaymentStatus		true
CCTRI_TxnAuthorizationTime		true
CCTRI_TxnAuthorizationStamp		true
CCTRI_ClientTransID		true
CustomField1		true
CustomField2		true
CustomField3		true
CustomField4		true
CustomField5		true
CustomField6		true
CustomField7		true
CustomField8		true
CustomField9		true
CustomField10		true
CustomField11		true
CustomField12		true
CustomField13		true
CustomField14		true
CustomField15		true
PARENT_IDKEY	IDKEY
GroupPARENT_IDKEY	GroupIDKEY
SeqNum	keeps the seq

Parent tables:

Release Notes - LetSync Desktop