TABLE DETAIL REFERENCE: PaymentTaxLineDetail

(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
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
PrivateNote	12	VARCHAR	4000	True	True	True	False	%s
TxnStatus	12	VARCHAR	1000	True	True	True	False	%s
CustomerRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
CustomerRefFullName	12	VARCHAR	100	True	False	True	False	%s	Yes
ARAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ARAccountRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
DepositToAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepositToAccountRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
PaymentMethodRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PaymentMethodRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
PaymentRefNum	12	VARCHAR	1000	True	False	False	False	%s
CreditCardPaymentCCAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CreditCardPaymentCCAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CreditCardPaymentCCDetailNumber	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailType	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailNameOnAcct	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailCcExpiryMonth	4	INTEGER	4	True	True	True	False	%11.0f
CreditCardPaymentCCDetailCcCcExpiryYear	4	INTEGER	4	True	True	True	False	%11.0f
CreditCardPaymentCCDetailBillAddrStreet	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailPostalCode	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailCommercialCardCode	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailCCTxnMode	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailCCTxnType	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailPrevCCTransId	12	VARCHAR	1000	True	True	True	False	%s
TxnSource	12	VARCHAR	100	True	False	False	False	%s
TotalAmt	3	DECIMAL	13	True	False	False	False	%11.2f
UnappliedAmt	3	DECIMAL	13	True	False	False	False	%11.2f
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
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
FQPrimaryKey	12	VARCHAR	73	True	True	False	False	FQPrimaryKey