TABLE DETAIL REFERENCE: SalesReceiptTaxLineDetail

(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
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
TaxDetailLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
TaxDetailLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
TaxDetailLineDetailType	12	VARCHAR	15	True	True	True	False	TaxLineDetail
TaxDetailLineTaxRateRefListID	12	VARCHAR	36	True	True	True	False	%s
TaxDetailLineTaxRateRefFullName	12	VARCHAR	1000	True	True	True	False	%s
TaxDetailLinePercentBased	-7	BIT	1	True	True	True	False	1 0 true false
TaxDetailLineTaxPercent	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailLineNetAmountTaxable	3	DECIMAL	13	True	True	True	False	%11.2f
TaxDetailLineOverrideDeltaAmount	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailLineTaxInclusiveAmount	4	INTEGER	4	True	True	True	False	%11.0f
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