TABLE DETAIL REFERENCE: PurchaseOrderLine
(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
AttachableRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
AttachableRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
DocNumber12 VARCHAR 1000TrueFalseFalseFalse%s
TxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
PrivateNote12 VARCHAR 4000TrueFalseFalseFalse%s
VendorRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
VendorRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
APAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
APAccountRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
Amount3 DECIMAL 15TrueFalseFalseFalse%11.2f
ClassRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ClassRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
SalesTermRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTermRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
DueDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
VendorAddrId12 VARCHAR 36TrueFalseFalseFalse%s
VendorAddrAddr112 VARCHAR 100TrueFalseFalseFalse%s
VendorAddrAddr212 VARCHAR 100TrueFalseFalseFalse%s
VendorAddrAddr312 VARCHAR 100TrueFalseFalseFalse%s
VendorAddrAddr412 VARCHAR 100TrueFalseFalseFalse%s
VendorAddrAddr512 VARCHAR 100TrueFalseFalseFalse%s
VendorAddrCity12 VARCHAR 100TrueFalseFalseFalse%s
VendorAddrState12 VARCHAR 100TrueFalseFalseFalse%s
VendorAddrProvince12 VARCHAR 100TrueFalseFalseFalse%s
VendorAddrCounty12 VARCHAR 100TrueFalseFalseFalse%s
VendorAddrPostalCode12 VARCHAR 100TrueFalseFalseFalse%s
VendorAddrLat12 VARCHAR 100TrueFalseFalseFalse%s
VendorAddrLong12 VARCHAR 100TrueFalseFalseFalse%s
ShipAddrId12 VARCHAR 36TrueFalseFalseFalse%s
ShipAddrAddr112 VARCHAR 100TrueFalseFalseFalse%s
ShipAddrAddr212 VARCHAR 100TrueFalseFalseFalse%s
ShipAddrAddr312 VARCHAR 100TrueFalseFalseFalse%s
ShipAddrAddr412 VARCHAR 100TrueFalseFalseFalse%s
ShipAddrAddr512 VARCHAR 100TrueFalseFalseFalse%s
ShipAddrCity12 VARCHAR 100TrueFalseFalseFalse%s
ShipAddrState12 VARCHAR 100TrueFalseFalseFalse%s
ShipAddrProvince12 VARCHAR 100TrueFalseFalseFalse%s
ShipAddrPostalCode12 VARCHAR 100TrueFalseFalseFalse%s
ShipAddrCounty12 VARCHAR 100TrueFalseFalseFalse%s
ShipAddrLat12 VARCHAR 100TrueFalseFalseFalse%s
ShipAddrLong12 VARCHAR 100TrueFalseFalseFalse%s
ShipMethodRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ShipMethodRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
POStatus12 VARCHAR 1000TrueFalseFalseFalse%s
TaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TaxCodeRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseFalseFalse%11.7f
GlobalTaxCalculation12 VARCHAR 15TrueFalseFalseFalse
TaxExcluded
TaxIncluded
NotApplicable
PurchaseOrderLineTxnLineID12 VARCHAR 36TrueFalseFalseFalse%s
PurchaseOrderLineItemRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PurchaseOrderLineItemRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
PurchaseOrderLineMemo12 VARCHAR 1000TrueFalseFalseFalse%s
PurchaseOrderLineUnitPrice3 DECIMAL 18TrueFalseFalseFalse%10.7f
PurchaseOrderLineQty3 DECIMAL 13TrueFalseFalseFalse%10.7f
PurchaseOrderLineClassRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PurchaseOrderLineClassRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
PurchaseOrderLineAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
PurchaseOrderLineIsTaxable-7 BIT 1TrueFalseFalseFalse
1
0
true
false
PurchaseOrderLineDetailType12 VARCHAR 11TrueFalseFalseFalse
ItemBasedExpenseLineDetail
PurchaseOrderLineAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PurchaseOrderLineAccountRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
PurchaseOrderLineCustomerRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PurchaseOrderLineCustomerRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
PurchaseOrderLineBillableStatus12 VARCHAR 11TrueFalseFalseFalse
NON
PurchaseOrderLineTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PurchaseOrderLineTaxCodeRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
PurchaseOrderLineTaxCodeRef12 VARCHAR 11TrueFalseFalseFalse
NotBillable
FQSaveToCache-7 BIT 1TrueFalseFalseFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
CustomFieldCrew12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldSalesRep12 VARCHAR 30TrueTrueTrueFalse%s