TABLE DETAIL REFERENCE: BillLinkedTxn

(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
VendorRefListID	12	VARCHAR	36	True	False	False	True	%s	Yes
VendorRefFullName	12	VARCHAR	1000	True	False	False	True	%s	Yes
APAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
APAccountRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	False	False	%11.7f
DepartmentRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
TxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
DueDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
AmountDue	3	DECIMAL	13	True	False	False	False	%11.2f
RefNumber	12	VARCHAR	21	True	False	False	False	%s
TermsRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TermsRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
Memo	12	VARCHAR	4000	True	False	False	False	%s
GlobalTaxCalculation	12	VARCHAR	15	True	False	False	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
ExpenseLineBillableStatus	12	VARCHAR	23	True	False	False	False	Billable NotBillable HasBeenBilled
OpenAmount	3	DECIMAL	15	True	False	False	False	%11.2f
HomeBalance	3	DECIMAL	13	True	False	False	False	%11.2f
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey