TABLE DETAIL REFERENCE: PurchaseLine
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
RefNumber12 VARCHAR 21TrueFalseFalseFalse%s
TxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
DepartmentRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
DepartmentRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseFalseFalse%11.7f
PrivateNote12 VARCHAR 4000TrueFalseFalseFalse%s
AccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
AccountRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
PaymentType12 VARCHAR 1000TrueFalseFalseFalse%s
PaymentMethodRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PaymentMethodRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
EntityRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
EntityRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
Credit-7 BIT 1TrueFalseFalseFalse
1
0
true
false
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
RemitToAddrAddr112 VARCHAR 500TrueFalseFalseFalse%s
RemitToAddrAddr212 VARCHAR 500TrueFalseFalseFalse%s
RemitToAddrAddr312 VARCHAR 500TrueFalseFalseFalse%s
RemitToAddrAddr412 VARCHAR 500TrueFalseFalseFalse%s
RemitToAddrAddr512 VARCHAR 500TrueFalseFalseFalse%s
RemitToAddrCity12 VARCHAR 255TrueFalseFalseFalse%s
RemitToAddrPostalCode12 VARCHAR 30TrueFalseFalseFalse%s
TotalAmt3 DECIMAL 13TrueFalseFalseFalse%11.2f
PrintStatus12 VARCHAR 1000TrueFalseFalseFalse%s
GlobalTaxCalculation12 VARCHAR 15TrueFalseFalseFalse
TaxExcluded
TaxIncluded
NotApplicable
PurchaseLineTxnLineID12 VARCHAR 36TrueFalseFalseFalse%s
PurchaseLineNumber12 VARCHAR 16TrueFalseFalseFalse%s
PurchaseLineMemo12 VARCHAR 4095TrueFalseFalseFalse%s
PurchaseLineItemRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PurchaseLineItemRefFullName12 VARCHAR 209TrueFalseFalseFalse%s Yes
PurchaseLineQuantity3 DECIMAL 16TrueFalseFalseFalse%10.7f
PurchaseLineRate3 DECIMAL 18TrueFalseFalseFalse%10.7f
PurchaseLineClassRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PurchaseLineClassRefFullName12 VARCHAR 209TrueFalseFalseFalse%s Yes
PurchaseLineAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
PurchaseLineIsTaxable-7 BIT 1TrueFalseFalseFalse
1
0
true
false
PurchaseLineDetailType12 VARCHAR 32TrueFalseFalseFalse
ItemBasedExpenseLineDetail
PurchaseLineAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PurchaseLineAccountRefFullName12 VARCHAR 209TrueFalseFalseFalse%s Yes
PurchaseLineCustomerRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PurchaseLineCustomerRefFullName12 VARCHAR 209TrueFalseFalseFalse%s Yes
PurchaseLineBillableStatus12 VARCHAR 11TrueFalseFalseFalse
Billable
NotBillable
HasBeenBill
PurchaseLineMarkupInfoPercent3 DECIMAL 13TrueFalseFalseFalse%10.7f
PurchaseLineMarkupInfoPercentBased-7 BIT 1TrueFalseFalseFalse
1
0
true
false
PurchaseLineMarkupInfoPriceLevelRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PurchaseLineMarkupInfoPriceLevelRefFullName12 VARCHAR 209TrueFalseFalseFalse%s Yes
PurchaseLineMarkupInfoValue3 DECIMAL 13TrueFalseFalseFalse%10.7f
PurchaseLineTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PurchaseLineTaxCodeRefFullName12 VARCHAR 209TrueFalseFalseFalse%s Yes
PurchaseLineTaxInclusiveAmount4 INTEGER 4TrueFalseFalseFalse%11.0f
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey