TABLE DETAIL REFERENCE: PurchaseTaxLineDetail

(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
RefNumber	12	VARCHAR	21	True	False	True	False	%s
TxnDate	9	DATE	6	True	False	True	False	CCCC-MM-DD
DepartmentRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	100	True	False	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	100	True	False	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
PrivateNote	12	VARCHAR	4000	True	False	True	False	%s
AccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
AccountRefFullName	12	VARCHAR	100	True	False	True	False	%s	Yes
PaymentType	12	VARCHAR	1000	True	False	True	False	%s
PaymentMethodRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
PaymentMethodRefFullName	12	VARCHAR	100	True	False	True	False	%s	Yes
EntityRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
EntityRefFullName	12	VARCHAR	100	True	False	True	False	%s	Yes
Credit	-7	BIT	1	True	False	True	False	1 0 true false
TxnSource	12	VARCHAR	100	True	False	False	False	%s
RemitToAddrAddr1	12	VARCHAR	500	True	False	True	False	%s
RemitToAddrAddr2	12	VARCHAR	500	True	False	True	False	%s
RemitToAddrAddr3	12	VARCHAR	500	True	False	True	False	%s
RemitToAddrAddr4	12	VARCHAR	500	True	False	True	False	%s
RemitToAddrAddr5	12	VARCHAR	500	True	False	True	False	%s
RemitToAddrCity	12	VARCHAR	255	True	False	True	False	%s
RemitToAddrPostalCode	12	VARCHAR	30	True	False	True	False	%s
TotalAmt	3	DECIMAL	13	True	False	True	False	%11.2f
PrintStatus	12	VARCHAR	1000	True	False	True	False	NeedToPrint NotSet PrintComplete
GlobalTaxCalculation	12	VARCHAR	15	True	False	True	False	TaxExcluded TaxIncluded NotApplicable
TaxDetailDefaultTaxCodeRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
TaxDetailDefaultTaxCodeRefFullName	12	VARCHAR	100	True	False	True	False	%s	Yes
TaxDetailTxnTaxCodeRef	12	VARCHAR	11	True	False	True	False	%8.2f
TaxDetailTotalTax	3	DECIMAL	13	True	False	True	False	%10.7f
TaxDetailReviewStatus	12	VARCHAR	11	True	False	True	False	Billable NotBillable HasBeenBill
TaxDetailLineTxnLineID	12	VARCHAR	36	True	False	False	False	%s
TaxDetailLineAmount	3	DECIMAL	15	True	False	True	False	%11.2f
TaxDetailLineDetailType	12	VARCHAR	15	True	False	True	False	TaxLineDetail
TaxDetailLineTaxRateRefListID	12	VARCHAR	36	True	False	True	False	%s
TaxDetailLineTaxRateRefFullName	12	VARCHAR	1000	True	False	True	False	%s
TaxDetailLinePercentBased	-7	BIT	1	True	False	True	False	1 0 true false
TaxDetailLineTaxPercent	3	DECIMAL	13	True	False	True	False	%10.7f
TaxDetailLineNetAmountTaxable	3	DECIMAL	13	True	False	True	False	%11.2f
TaxDetailLineOverrideDeltaAmount	3	DECIMAL	13	True	False	True	False	%10.7f
TaxDetailLineTaxInclusiveAmount	4	INTEGER	4	True	False	True	False	%11.0f
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey