TABLE DETAIL REFERENCE: PurchaseOrderLine
(Australia ,New Zealand,Singapore Southeast Asia 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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
VendorRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
VendorRefFullName12 VARCHAR 41TrueTrueTrueFalse%s Yes
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ShipToEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ShipToEntityRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
TemplateRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TemplateRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
TxnDateMacro12 VARCHAR 23TrueFalseFalseFalse
All
Today
ThisWeek
ThisWeekToDate
ThisMonth
ThisMonthToDate
ThisCalendarQuarter
ThisCalendarQuarterToDate
ThisFiscalQuarter
ThisFiscalQuarterToDate
ThisCalendarYear
ThisCalendarYearToDate
ThisFiscalYelities
Estimates
InventoryAssets
OpeningBalanceEquity
PayrollExpenses
PayrollLiabilities
PettyCash
P~õn,~õn))?_¸"x ¬ ± dLkwõnÌõnÜõn
RefNumber12 VARCHAR 11TrueTrueTrueFalse%s
VendorAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
VendorAddressState12 VARCHAR 21TrueTrueTrueFalse%s
VendorAddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
VendorAddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
VendorAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
VendorAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
VendorAddressNote12 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
VendorAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
VendorAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
VendorAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
VendorAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressState12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
ShipAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressNote12 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
TermsRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TermsRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
DueDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
ExpectedDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
ShipMethodRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ShipMethodRefFullName12 VARCHAR 15TrueTrueTrueFalse%s Yes
FOB12 VARCHAR 13TrueTrueTrueFalse%s
TotalAmount3 DECIMAL 13TrueFalseFalseFalse%8.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
IsManuallyClosed-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsFullyReceived-7 BIT 1TrueFalseFalseFalse
1
0
true
false
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
VendorMsg12 VARCHAR 99TrueTrueTrueFalse%s
IsToBePrinted-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsToBeEmailed-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsTaxIncluded-7 BIT 1TrueTrueTrueFalse
1
0
true
false
SalesTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 6TrueTrueTrueFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TaxCodeRefFullName12 VARCHAR 6TrueTrueTrueFalse%s Yes
CustomFieldOther112 VARCHAR 29TrueTrueTrueFalse%s
CustomFieldOther212 VARCHAR 29TrueTrueTrueFalse%s
PurchaseOrderLineType12 VARCHAR 11TrueFalseFalseFalseItemType
PurchaseOrderLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
PurchaseOrderLineGroupTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
PurchaseOrderLineGroupItemGroupRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PurchaseOrderLineGroupItemGroupFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
PurchaseOrderLineGroupDesc12 VARCHAR 4095TrueFalseFalseFalse%s
PurchaseOrderLineGroupQuantity3 DECIMAL 16TrueTrueTrueFalse%8.5f
PurchaseOrderLineGroupIsPrintItemsInGroup-7 BIT 1TrueFalseFalseFalse
1
0
true
false
PurchaseOrderLineGroupTotalAmount3 DECIMAL 13TrueFalseFalseFalse%8.2f
PurchaseOrderLineGroupServiceDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
PurchaseOrderLineGroupSeqNo4 INTEGER 4TrueFalseFalseFalseSubSeqNo
PurchaseOrderLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
PurchaseOrderLineItemRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PurchaseOrderLineItemRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
PurchaseOrderLineDesc12 VARCHAR 4095TrueTrueTrueFalse%s
PurchaseOrderLineQuantity3 DECIMAL 16TrueTrueTrueFalse%8.5f
PurchaseOrderLineRate3 DECIMAL 16TrueTrueTrueFalse%8.5f
PurchaseOrderLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PurchaseOrderLineClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
PurchaseOrderLineAmount3 DECIMAL 13TrueTrueTrueFalse%8.2f
PurchaseOrderLineTaxAmount3 DECIMAL 13TrueTrueTrueFalse%8.2f
PurchaseOrderLineCustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PurchaseOrderLineCustomerRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
PurchaseOrderLineServiceDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
PurchaseOrderLineSalesTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PurchaseOrderLineTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PurchaseOrderLineSalesTaxCodeRefFullName12 VARCHAR 6TrueTrueTrueFalse%s Yes
PurchaseOrderLineTaxCodeRefFullName12 VARCHAR 6TrueTrueTrueFalse%s Yes
PurchaseOrderLineReceivedQuantity3 DECIMAL 16TrueFalseFalseFalse%8.5f
PurchaseOrderLineUnbilledQuantity3 DECIMAL 16TrueFalseFalseFalse%8.5f
PurchaseOrderLineIsBilled-7 BIT 1TrueTrueFalseFalse
1
0
true
false
PurchaseOrderLineIsManuallyClosed-7 BIT 1TrueTrueTrueFalse
1
0
true
false
PurchaseOrderLineOverrideItemAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PurchaseOrderLineOverrideItemAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
CustomFieldPurchaseOrderLineOther112 VARCHAR 29TrueTrueTrueFalse%s
CustomFieldPurchaseOrderLineOther212 VARCHAR 29TrueTrueTrueFalse%s
Tax1Total3 DECIMAL 13TrueFalseFalseFalse%8.2f
Tax2Total3 DECIMAL 13TrueFalseFalseFalse%8.2f
ExchangeRate3 DECIMAL 15TrueFalseFalseFalse%6.8f
AmountIncludesVAT-7 BIT 1TrueTrueTrueFalse
1
0
true
false
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
FQTxnLinkKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey