TABLE DETAIL REFERENCE: SalesReceiptLinkedTxn

(Online VERSION)

>>

<<

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE	RELATES TO
TxnID	12	VARCHAR	36	True	False	False	False	%s	Yes
TimeCreated	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
TimeModified	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
EditSequence	12	VARCHAR	10	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
CustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CustomerRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ClassRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ShipMethodRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ShipMethodRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	15	True	True	True	False	%11.7f
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
LinkedTxnSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
LinkedTxnTxnID	12	VARCHAR	36	True	False	False	False	%s
LinkedTxnTxnType	12	VARCHAR	21	True	False	False	False	Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer VendorCredit YTDAdjustment ARRefundCreditCard
LinkedTxnTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
LinkedTxnRefNumber	12	VARCHAR	21	True	False	False	False	%s
LinkedTxnAmount	3	DECIMAL	15	True	False	False	False	%11.2f
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
RefNumber	12	VARCHAR	21	True	True	True	False	%s
BillAddressID	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr1	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr2	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr3	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr4	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr5	12	VARCHAR	500	True	True	True	False	%s
BillAddressCity	12	VARCHAR	255	True	True	True	False	%s
BillAddressState	12	VARCHAR	255	True	True	True	False	%s
BillAddressPostalCode	12	VARCHAR	30	True	True	True	False	%s
BillAddressCountry	12	VARCHAR	255	True	True	True	False	%s
ShipAddressID	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr1	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr2	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr3	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr4	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr5	12	VARCHAR	500	True	True	True	False	%s
ShipAddressCity	12	VARCHAR	255	True	True	True	False	%s
ShipAddressState	12	VARCHAR	255	True	True	True	False	%s
ShipAddressPostalCode	12	VARCHAR	30	True	True	True	False	%s
ShipAddressCountry	12	VARCHAR	255	True	True	True	False	%s
Memo	12	VARCHAR	4000	True	True	True	False	%s
ShipDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TrackingNumber	12	VARCHAR	1000	True	True	True	False	%s
CheckNumber	12	VARCHAR	25	True	True	True	False	%s
PaymentMethodRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PaymentMethodRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
Subtotal	3	DECIMAL	13	True	False	False	False	%11.2f
SalesTaxPercentage	3	DECIMAL	15	True	True	True	False	%10.7f
SalesTaxTotal	3	DECIMAL	13	True	True	True	False	%11.2f
TotalAmount	3	DECIMAL	15	True	True	True	False	%11.2f
ApplyTaxAfterDiscount	-7	BIT	1	True	True	True	False	1 0 true false
IsToBePrinted	-7	BIT	1	True	True	True	False	1 0 true false
PrintStatus	12	VARCHAR	13	True	False	False	False	NotSet NeedToPrint PrintComplete
EmailStatus	12	VARCHAR	13	True	True	True	False	NotSet NeedToSend EmailSent
IsToBeEmailed	-7	BIT	1	True	True	True	False	1 0 true false
TxnSource	12	VARCHAR	100	True	False	False	False	%s
TransactionLocationType	12	VARCHAR	32	True	True	True	False	WithinFrance FranceOverseas OutsideFranceWithEU OutsideEU
HomeBalance	3	DECIMAL	13	True	False	False	False	%11.2f
DepositToAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepositToAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
TaxDetailDefaultTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TaxDetailDefaultTaxCodeRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
TaxDetailTxnTaxCodeRef	12	VARCHAR	11	True	True	True	False	%8.2f
TaxDetailTotalTax	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailReviewStatus	12	VARCHAR	11	True	True	True	False	Billable NotBillable HasBeenBill
DiscountLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
DiscountLineRatePercent	3	DECIMAL	15	True	True	True	False	%11.7f
DiscountLineAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
DiscountLineAccountRefFullName	12	VARCHAR	1000	True	False	True	False	%s	Yes
SalesTaxLineAmount	3	DECIMAL	15	True	False	True	False	%11.2f
SalesTaxLineRatePercent	3	DECIMAL	15	True	False	True	False	%10.7f
SalesTaxLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
SalesTaxLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
FQPrimaryKey	12	VARCHAR	73	True	True	False	False	FQPrimaryKey
CustomFieldCrew	12	VARCHAR	30	True	True	True	False	%s
CustomFieldPONumber	12	VARCHAR	30	True	True	True	False	%s