TABLE DETAIL REFERENCE: PurchaseOrderLine
(USA VERSION)
| FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
|---|---|---|---|---|---|---|---|---|---|
| TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
| TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
| VendorRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| VendorRefFullName | 12 | VARCHAR | 41 | True | True | True | False | %s | Yes |
| ClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| ClassRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
| InventorySiteRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| InventorySiteRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
| ShipToEntityRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| ShipToEntityRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
| TemplateRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| TemplateRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
| TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | 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 | |
| RefNumber | 12 | VARCHAR | 11 | True | True | True | False | %s | |
| VendorAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| VendorAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| VendorAddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| VendorAddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| VendorAddressAddr5 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| VendorAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
| VendorAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| VendorAddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| VendorAddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| VendorAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
| VendorAddressCountry | 12 | VARCHAR | 31 | True | True | True | False | %s | |
| VendorAddressNote | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| VendorAddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| VendorAddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| VendorAddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| VendorAddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| VendorAddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| ShipAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| ShipAddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| ShipAddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| ShipAddressAddr5 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| ShipAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
| ShipAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| ShipAddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| ShipAddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| ShipAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
| ShipAddressCountry | 12 | VARCHAR | 31 | True | True | True | False | %s | |
| ShipAddressNote | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| ShipAddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipAddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipAddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipAddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipAddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| TermsRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| TermsRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
| DueDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| ExpectedDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| ShipMethodRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| ShipMethodRefFullName | 12 | VARCHAR | 15 | True | True | True | False | %s | Yes |
| FOB | 12 | VARCHAR | 13 | True | True | True | False | %s | |
| TotalAmount | 3 | DECIMAL | 18 | True | False | False | False | %10.2f | |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| CurrencyRefFullName | 12 | VARCHAR | 31 | True | False | False | False | %s | Yes |
| ExchangeRate | 3 | DECIMAL | 17 | True | True | True | False | %6.8f | |
| TotalAmountInHomeCurrency | 3 | DECIMAL | 18 | True | False | False | False | %10.2f | |
| IsManuallyClosed | -7 | BIT | 1 | True | True | False | False | 1 0 true false | |
| IsFullyReceived | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
| VendorMsg | 12 | VARCHAR | 99 | True | True | True | False | %s | |
| IsToBePrinted | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| IsToBeEmailed | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| IsTaxIncluded | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| SalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | False | False | False | %s | Yes |
| TaxCodeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| TaxCodeRefFullName | 12 | VARCHAR | 3 | True | False | False | False | %s | Yes |
| CustomFieldOther1 | 12 | VARCHAR | 29 | True | True | True | False | %s | |
| CustomFieldOther2 | 12 | VARCHAR | 29 | True | True | True | False | %s | |
| PurchaseOrderLineType | 12 | VARCHAR | 11 | True | False | False | False | ItemType | |
| PurchaseOrderLineSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
| PurchaseOrderLineGroupTxnLineID | 12 | VARCHAR | 36 | True | True | False | False | %s | |
| PurchaseOrderLineGroupItemGroupRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| PurchaseOrderLineGroupItemGroupFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
| PurchaseOrderLineGroupDesc | 12 | VARCHAR | 4095 | True | False | False | False | %s | |
| PurchaseOrderLineGroupQuantity | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
| PurchaseOrderLineGroupUnitOfMeasure | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
| PurchaseOrderLineGroupInventorySiteRefListID | 12 | VARCHAR | 36 | False | False | True | False | %s | Yes |
| PurchaseOrderLineGroupInventorySiteRefFullName | 12 | VARCHAR | 31 | False | False | True | False | %s | Yes |
| PurchaseOrderLineGroupInventorySiteLocationRefListID | 12 | VARCHAR | 36 | False | False | True | False | %s | Yes |
| PurchaseOrderLineGroupInventorySiteLocationRefFullName | 12 | VARCHAR | 31 | False | False | True | False | %s | Yes |
| PurchaseOrderLineGroupOverrideUOMSetRefListID | 12 | VARCHAR | 36 | True | True | False | False | %s | Yes |
| PurchaseOrderLineGroupOverrideUOMSetRefFullName | 12 | VARCHAR | 31 | True | True | False | False | %s | Yes |
| PurchaseOrderLineGroupIsPrintItemsInGroup | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| PurchaseOrderLineGroupTotalAmount | 3 | DECIMAL | 18 | True | False | False | False | %10.2f | |
| PurchaseOrderLineGroupServiceDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| PurchaseOrderLineGroupSeqNo | 4 | INTEGER | 4 | True | False | False | False | SubSeqNo | |
| PurchaseOrderLineTxnLineID | 12 | VARCHAR | 36 | True | True | False | False | %s | |
| PurchaseOrderLineItemRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| PurchaseOrderLineItemRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
| PurchaseOrderLineManufacturerPartNumber | 12 | VARCHAR | 31 | True | True | True | False | %s | |
| PurchaseOrderLineDesc | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
| PurchaseOrderLineQuantity | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
| PurchaseOrderLineUnitOfMeasure | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
| PurchaseOrderLineOverrideUOMSetRefListID | 12 | VARCHAR | 36 | True | True | False | False | %s | Yes |
| PurchaseOrderLineOverrideUOMSetRefFullName | 12 | VARCHAR | 31 | True | True | False | False | %s | Yes |
| PurchaseOrderLineRate | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
| PurchaseOrderLineClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| PurchaseOrderLineClassRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
| PurchaseOrderLineAmount | 3 | DECIMAL | 18 | True | True | True | False | %10.2f | |
| PurchaseOrderLineInventorySiteLocationRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| PurchaseOrderLineInventorySiteLocationRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
| PurchaseOrderLineTaxAmount | 3 | DECIMAL | 17 | True | False | False | False | %10.2f | |
| PurchaseOrderLineCustomerRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| PurchaseOrderLineCustomerRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
| PurchaseOrderLineServiceDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| PurchaseOrderLineSalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| PurchaseOrderLineTaxCodeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| PurchaseOrderLineSalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | False | False | False | %s | Yes |
| PurchaseOrderLineTaxCodeRefFullName | 12 | VARCHAR | 3 | True | False | False | False | %s | Yes |
| PurchaseOrderLineReceivedQuantity | 3 | DECIMAL | 18 | True | False | False | False | %10.5f | |
| PurchaseOrderLineUnbilledQuantity | 3 | DECIMAL | 18 | True | False | False | False | %10.5f | |
| PurchaseOrderLineIsBilled | -7 | BIT | 1 | True | True | False | False | 1 0 true false | |
| PurchaseOrderLineIsManuallyClosed | -7 | BIT | 1 | True | True | False | False | 1 0 true false | |
| PurchaseOrderLineOverrideItemAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| PurchaseOrderLineOverrideItemAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
| CustomFieldPurchaseOrderLineOther1 | 12 | VARCHAR | 29 | True | True | True | False | %s | |
| CustomFieldPurchaseOrderLineOther2 | 12 | VARCHAR | 29 | True | True | True | False | %s | |
| Tax1Total | 3 | DECIMAL | 17 | True | False | False | False | %10.2f | |
| Tax2Total | 3 | DECIMAL | 17 | True | False | False | False | %10.2f | |
| AmountIncludesVAT | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
| FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey | |
| FQTxnLinkKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey | |
| CustomFieldPurchaseOrderLineALU | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineALU2 | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineApproved | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineColor | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineCompletedby | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineCustomer | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineInspectedBy | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineOrdered | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLinePulled | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLinePulledby | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineQtyPriceBreak | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineRequiredDate | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineStartDate | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineStyle | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupALU | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupALU2 | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupApproved | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupColor | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupCompletedby | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupCustomer | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupInspectedBy | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupOrdered | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupPulled | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupPulledby | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupQtyPriceBreak | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupRequiredDate | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupStartDate | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupStyle | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupLineALU | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupLineALU2 | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupLineApproved | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupLineColor | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupLineCompletedby | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupLineCustomer | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupLineInspectedBy | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupLineOrdered | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupLinePulled | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupLinePulledby | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupLineQtyPriceBreak | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupLineRequiredDate | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupLineStartDate | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldPurchaseOrderLineGroupLineStyle | 12 | VARCHAR | 30 | True | True | False | False | %s |