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 18TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 17TrueTrueTrueFalse%6.8f
TotalAmountInHomeCurrency3 DECIMAL 18TrueFalseFalseFalse%10.2f
IsManuallyClosed-7 BIT 1TrueTrueFalseFalse
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
PurchaseOrderLineGroupInventorySiteRefListID12 VARCHAR 36FalseFalseTrueFalse%s Yes
PurchaseOrderLineGroupInventorySiteRefFullName12 VARCHAR 31FalseFalseTrueFalse%s Yes
PurchaseOrderLineGroupInventorySiteLocationRefListID12 VARCHAR 36FalseFalseTrueFalse%s Yes
PurchaseOrderLineGroupInventorySiteLocationRefFullName12 VARCHAR 31FalseFalseTrueFalse%s Yes
PurchaseOrderLineGroupOverrideUOMSetRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
PurchaseOrderLineGroupOverrideUOMSetRefFullName12 VARCHAR 31TrueTrueFalseFalse%s Yes
PurchaseOrderLineGroupIsPrintItemsInGroup-7 BIT 1TrueFalseFalseFalse
1
0
true
false
PurchaseOrderLineGroupTotalAmount3 DECIMAL 18TrueFalseFalseFalse%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 18TrueTrueTrueFalse%10.2f
PurchaseOrderLineInventorySiteLocationRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PurchaseOrderLineInventorySiteLocationRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
PurchaseOrderLineTaxAmount3 DECIMAL 17TrueFalseFalseFalse%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 1TrueTrueFalseFalse
1
0
true
false
PurchaseOrderLineOverrideItemAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PurchaseOrderLineOverrideItemAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
CustomFieldPurchaseOrderLineOther112 VARCHAR 29TrueTrueTrueFalse%s
CustomFieldPurchaseOrderLineOther212 VARCHAR 29TrueTrueTrueFalse%s
Tax1Total3 DECIMAL 17TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 17TrueFalseFalseFalse%10.2f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
FQTxnLinkKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
CustomFieldPurchaseOrderLineALU12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineALU212 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineApproved12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineColor12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineCompletedby12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineCustomer12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineInspectedBy12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineOrdered12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLinePulled12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLinePulledby12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineQtyPriceBreak12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineRequiredDate12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineStartDate12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineStyle12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupALU12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupALU212 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupApproved12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupColor12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupCompletedby12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupCustomer12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupInspectedBy12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupOrdered12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupPulled12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupPulledby12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupQtyPriceBreak12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupRequiredDate12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupStartDate12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupStyle12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupLineALU12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupLineALU212 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupLineApproved12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupLineColor12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupLineCompletedby12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupLineCustomer12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupLineInspectedBy12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupLineOrdered12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupLinePulled12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupLinePulledby12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupLineQtyPriceBreak12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupLineRequiredDate12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupLineStartDate12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldPurchaseOrderLineGroupLineStyle12 VARCHAR 30TrueTrueFalseFalse%s