TABLE DETAIL REFERENCE:
  
(US VERSION)
FIELD NAME TYPE LENGTH QRY MOD INS REQ INS VALIDATE REL
TxnID Varchar 36 True False False N/A String
TimeCreated Timestamp 27 True False False N/A CCCC-MM-DDThh:mm:ssZ
TimeModified Timestamp 27 True False False N/A CCCC-MM-DDThh:mm:ssZ
EditSequence Varchar 16 True False False N/A String
TxnNumber Integer 13 True False False N/A 11.0
VendorRefListID Varchar 36 True False True No String
VendorRefFullName Varchar 41 True True True No String
ClassRefListID Varchar 36 True False True No String
ClassRefFullName Varchar 159 True True True No String
ShipToEntityRefListID Varchar 36 True False True No String
ShipToEntityRefFullName Varchar 209 True True True No String
TemplateRefListID Varchar 36 True False True No String
TemplateRefFullName Varchar 159 True True True No String
TxnDate Date 10 True True True No CCCC-MM-DD
TxnDateMacro Varchar 23 True False False N/A 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 Varchar 11 True True True No String
VendorAddressAddr1 Varchar 41 True True True No String
VendorAddressAddr2 Varchar 41 True True True No String
VendorAddressAddr3 Varchar 41 True True True No String
VendorAddressAddr4 Varchar 41 True True True No String
VendorAddressAddr5 Varchar 41 True True True No String
VendorAddressCity Varchar 31 True True True No String
VendorAddressState Varchar 21 True True True No String
VendorAddressPostalCode Varchar 13 True True True No String
VendorAddressCountry Varchar 31 True True True No String
VendorAddressNote Varchar 41 True True True No String
VendorAddressBlockAddr1 Varchar 41 True False False N/A String
VendorAddressBlockAddr2 Varchar 41 True False False N/A String
VendorAddressBlockAddr3 Varchar 41 True False False N/A String
VendorAddressBlockAddr4 Varchar 41 True False False N/A String
VendorAddressBlockAddr5 Varchar 41 True False False N/A String
ShipAddressAddr1 Varchar 41 True True True No String
ShipAddressAddr2 Varchar 41 True True True No String
ShipAddressAddr3 Varchar 41 True True True No String
ShipAddressAddr4 Varchar 41 True True True No String
ShipAddressAddr5 Varchar 41 True True True No String
ShipAddressCity Varchar 31 True True True No String
ShipAddressState Varchar 21 True True True No String
ShipAddressPostalCode Varchar 13 True True True No String
ShipAddressCountry Varchar 31 True True True No String
ShipAddressNote Varchar 41 True True True No String
ShipAddressBlockAddr1 Varchar 41 True False False N/A String
ShipAddressBlockAddr2 Varchar 41 True False False N/A String
ShipAddressBlockAddr3 Varchar 41 True False False N/A String
ShipAddressBlockAddr4 Varchar 41 True False False N/A String
ShipAddressBlockAddr5 Varchar 41 True False False N/A String
TermsRefListID Varchar 36 True False True No String
TermsRefFullName Varchar 31 True True True No String
DueDate Date 10 True True True No CCCC-MM-DD
ExpectedDate Date 10 True True True No CCCC-MM-DD
ShipMethodRefListID Varchar 36 True False True No String
ShipMethodRefFullName Varchar 15 True True True No String
FOB Varchar 13 True True True No String
TotalAmount Decimal 11 True False False N/A 8.2
IsManuallyClosed Bit 5 True True True No 1 0 true false
IsFullyReceived Bit 5 True False False N/A 1 0 true false
Memo Varchar 4095 True True True No String
VendorMsg Varchar 99 True True True No String
IsToBePrinted Bit 5 True True True No 1 0 true false
IsToBeEmailed Bit 5 True True True No 1 0 true false
Other1 Varchar 29 True True True No String
Other2 Varchar 29 True True True No String
PurchaseOrderLineType Varchar 11 True False False N/A ItemType
PurchaseOrderLineSeqNo Integer 13 True False False N/A SeqNo
PurchaseOrderLineGroupTxnLineID Varchar 36 True True False N/A String
PurchaseOrderLineGroupItemGroupRefListID Varchar 36 True False True No String
PurchaseOrderLineGroupItemGroupFullName Varchar 159 True True True No String
PurchaseOrderLineGroupDesc Varchar 4095 True False False N/A String
PurchaseOrderLineGroupQuantity Decimal 13 True True True No 7.5
PurchaseOrderLineGroupIsToBePrinted Bit 5 True False False N/A 1 0 true false
PurchaseOrderLineGroupTotalAmount Decimal 11 True False False N/A 8.2
PurchaseOrderLineGroupSeqNo Integer 13 True False False N/A SubSeqNo
PurchaseOrderLineTxnLineID Varchar 36 True True False N/A String
PurchaseOrderLineItemRefListID Varchar 36 True False True No String
PurchaseOrderLineItemRefFullName Varchar 159 True True True No String
PurchaseOrderLineDesc Varchar 4095 True True True No String
PurchaseOrderLineQuantity Decimal 13 True True True No 7.5
PurchaseOrderLineRate Decimal 14 True True True No 8.5
PurchaseOrderLineClassRefListID Varchar 36 True False True No String
PurchaseOrderLineClassRefFullName Varchar 159 True True True No String
PurchaseOrderLineAmount Decimal 11 True True True No 8.2
PurchaseOrderLineCustomerRefListID Varchar 36 True False True No String
PurchaseOrderLineCustomerRefFullName Varchar 209 True True True No String
PurchaseOrderLineServiceDate Date 10 True True True No CCCC-MM-DD
PurchaseOrderLineReceivedQuantity Decimal 13 True False False N/A 7.5
PurchaseOrderLineIsManuallyClosed Bit 5 True True True No 1 0 true false
PurchaseOrderLineIsFullyReceived Bit 5 True True True No 1 0 true false
PurchaseOrderLineOverrideItemAccountRefListID Varchar 36 True False True No String
PurchaseOrderLineOverrideItemAccountRefFullName Varchar 159 True True True No String
PurchaseOrderLineOther1 Varchar 29 True True True No String
PurchaseOrderLineOther2 Varchar 29 True True True No String
PurchaseOrderLineTxnLineID Varchar 36 True True False N/A String
PurchaseOrderLineItemRefListID Varchar 36 True False False N/A String
PurchaseOrderLineItemRefFullName Varchar 159 True True False N/A String
PurchaseOrderLineDesc Varchar 4095 True True False N/A String
PurchaseOrderLineQuantity Decimal 13 True True False N/A 7.5
PurchaseOrderLineRate Decimal 14 True True False N/A 8.5
PurchaseOrderLineClassRefListID Varchar 36 True False False N/A String
PurchaseOrderLineClassRefFullName Varchar 159 True True False N/A String
PurchaseOrderLineAmount Decimal 11 True True False N/A 8.2
PurchaseOrderLineCustomerRefListID Varchar 36 True False False N/A String
PurchaseOrderLineCustomerRefFullName Varchar 209 True True False N/A String
PurchaseOrderLineServiceDate Date 10 True True False N/A CCCC-MM-DD
PurchaseOrderLineReceivedQuantity Decimal 13 True False False N/A 7.5
PurchaseOrderLineIsManuallyClosed Bit 5 True True False N/A 1 0 true false
PurchaseOrderLineIsFullyReceived Bit 5 True True False N/A 1 0 true false
PurchaseOrderLineOverrideItemAccountRefListID Varchar 36 True False True No String
PurchaseOrderLineOverrideItemAccountRefFullName Varchar 159 True True True No String
PurchaseOrderLineOther1 Varchar 29 True True True No String
PurchaseOrderLineOther2 Varchar 29 True True True No String
FQSaveToCache Bit 5 True False True No FQSaveToCache
FQPrimaryKey Varchar 110 True False False N/A FQPrimaryKey