TABLE DETAIL REFERENCE: RefundReceiptTaxLineDetail

(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
DocNumber	12	VARCHAR	1000	True	False	True	False	%s
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	100	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	13	True	False	True	False	%11.7f
PrivateNote	12	VARCHAR	4000	True	True	True	False	%s
TxnTaxDetailTxnTaxCodeRef	12	VARCHAR	11	True	True	True	False	%8.2f
TxnTaxDetailTotalTax	3	DECIMAL	13	True	True	True	False	%10.7f
TxnTaxDetailTaxLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
TxnTaxDetailTaxLineDetailType	12	VARCHAR	11	True	True	True	False	TaxLineDetail
TxnTaxDetailTaxLineTaxLineDetailTaxRateRef	12	VARCHAR	11	True	True	True	False	NotBillable
TxnTaxDetailTaxLineTaxLineDetailPercentBased	-7	BIT	1	True	True	True	False	1 0 true false
TxnTaxDetailTaxLineTaxLineDetailTaxPercent	3	DECIMAL	13	True	True	True	False	%10.7f
TxnTaxDetailTaxLineTaxLineDetailNetAmountTaxable	3	DECIMAL	13	True	True	True	False	%11.2f
CustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CustomerRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
CustomerMemo	12	VARCHAR	1000	True	True	True	False	%s
BillAddrTxnLineID	12	VARCHAR	36	True	True	False	False	%s
BillAddrLine1	12	VARCHAR	100	True	True	True	False	%s
BillAddrLine2	12	VARCHAR	100	True	True	True	False	%s
BillAddrLine3	12	VARCHAR	100	True	True	True	False	%s
BillAddrLat	12	VARCHAR	100	True	True	True	False	%s
BillAddrLong	12	VARCHAR	100	True	True	True	False	%s
ShipAddrTxnLineID	12	VARCHAR	36	True	True	False	False	%s
ShipAddrLine1	12	VARCHAR	100	True	True	True	False	%s
ShipAddrLine2	12	VARCHAR	100	True	True	True	False	%s
ShipAddrLine3	12	VARCHAR	100	True	True	True	False	%s
ShipAddrLat	12	VARCHAR	100	True	True	True	False	%s
ShipAddrLong	12	VARCHAR	100	True	True	True	False	%s
ClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ClassRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
TotalAmt	3	DECIMAL	13	True	False	False	False	%11.2f
HomeTotalAmt	3	DECIMAL	13	True	False	False	False	%11.2f
ApplyTaxAfterDiscount	-7	BIT	1	True	True	True	False	1 0 true false
PrintStatus	12	VARCHAR	1000	True	True	True	False	NeedToPrint PrintComplete NotSet
BillEmailAddress	12	VARCHAR	1000	True	True	True	False	%s
Balance	3	DECIMAL	13	True	True	True	False	%11.2f
HomeBalance	3	DECIMAL	13	True	False	False	False	%11.2f
PaymentMethodRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PaymentMethodRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
PaymentRefNum	12	VARCHAR	100	True	False	True	False	%s
TxnSource	12	VARCHAR	100	True	False	False	False	%s
DepositToAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepositToAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
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
DiscountLineLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
DiscountLineIsTaxable	-7	BIT	1	True	True	True	False	1 0 true false
DiscountLineAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
DiscountLineAccountRefFullName	12	VARCHAR	1000	True	False	True	False	%s	Yes
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