TABLE DETAIL REFERENCE: PurchaseOrderLine
(USA 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
InventorySiteRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InventorySiteRefFullName12 VARCHAR 31TrueTrueTrueFalse%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
ThisFiscalYear
ThisFiscalYearToDate
Yesterday
LastWeek
LastWeekToDate
LastMonth
LastMonthToDate
LastCalendarQuarter
LastCalendarQuarterToDate
LastFiscalQuarter
LastFiscalQuarterToDate
LastCalendarYear
LastCalendarYearToDate
LastFiscalYear
LastFiscalYearToDate
NextWeek
NextFourWeeks
NextMonth
NextCalendarQuarter
NextCalendarYear
NextFiscalQuarter
NextFiscalYear
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 15TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 15TrueTrueTrueFalse%6.8f
TotalAmountInHomeCurrency3 DECIMAL 15TrueFalseFalseFalse%10.2f
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 1TrueFalseFalseFalse
1
0
true
false
SalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%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 18TrueTrueTrueFalse%10.5f
PurchaseOrderLineGroupUnitOfMeasure12 VARCHAR 31TrueTrueTrueFalse%s Yes
PurchaseOrderLineGroupOverrideUOMSetRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
PurchaseOrderLineGroupOverrideUOMSetRefFullName12 VARCHAR 31TrueTrueFalseFalse%s Yes
PurchaseOrderLineGroupIsPrintItemsInGroup-7 BIT 1TrueFalseFalseFalse
1
0
true
false
PurchaseOrderLineGroupTotalAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
PurchaseOrderLineGroupServiceDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
PurchaseOrderLineGroupSeqNo4 INTEGER 4TrueFalseFalseFalseSubSeqNo
PurchaseOrderLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
PurchaseOrderLineItemRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PurchaseOrderLineItemRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
PurchaseOrderLineManufacturerPartNumber12 VARCHAR 31TrueTrueTrueFalse%s
PurchaseOrderLineDesc12 VARCHAR 4095TrueTrueTrueFalse%s
PurchaseOrderLineQuantity3 DECIMAL 18TrueTrueTrueFalse%10.5f
PurchaseOrderLineUnitOfMeasure12 VARCHAR 31TrueTrueTrueFalse%s Yes
PurchaseOrderLineOverrideUOMSetRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
PurchaseOrderLineOverrideUOMSetRefFullName12 VARCHAR 31TrueTrueFalseFalse%s Yes
PurchaseOrderLineRate3 DECIMAL 18TrueTrueTrueFalse%10.5f
PurchaseOrderLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PurchaseOrderLineClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
PurchaseOrderLineAmount3 DECIMAL 15TrueTrueTrueFalse%10.2f
PurchaseOrderLineInventorySiteLocationRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PurchaseOrderLineInventorySiteLocationRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
PurchaseOrderLineTaxAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
PurchaseOrderLineCustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PurchaseOrderLineCustomerRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
PurchaseOrderLineServiceDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
PurchaseOrderLineSalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PurchaseOrderLineTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PurchaseOrderLineSalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
PurchaseOrderLineTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
PurchaseOrderLineReceivedQuantity3 DECIMAL 18TrueFalseFalseFalse%10.5f
PurchaseOrderLineUnbilledQuantity3 DECIMAL 18TrueFalseFalseFalse%10.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 15TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
FQTxnLinkKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey