PurchaseOrder Table

Back to list of tables.

Column Data type Data type name Length Can be queried? Can be updated? Can be inserted? Mandatory when inserting? Format Refers To Version introduced in Edition available in
TxnID 12 VARCHAR 36 True False False False %s 1.0 US, CA, UK
TimeCreated 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 1.0 US, CA, UK
TimeModified 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 1.0 US, CA, UK
EditSequence 12 VARCHAR 16 True False False False %s 1.0 US, CA, UK
TxnNumber 4 INTEGER 9 True False False False %11.0f 1.0 US, CA, UK
VendorRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
VendorRef_FullName 12 VARCHAR 41 True True True False %s Name 1.0 US, CA, UK
ClassRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
ClassRef_FullName 12 VARCHAR 159 True True True False %s Name 1.0 US, CA, UK
InventorySiteRef_ListID 12 VARCHAR 36 True True True True %s ListID 10.0 US, CA, UK
InventorySiteRef_FullName 12 VARCHAR 31 True True True True %s Name 10.0 US, CA, UK
ShipToEntityRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
ShipToEntityRef_FullName 12 VARCHAR 209 True True True False %s Name 1.0 US, CA, UK
TemplateRef_ListID 12 VARCHAR 36 True True True False %s ListID 3.0 US, CA, UK
TemplateRef_FullName 12 VARCHAR 159 True True True False %s Name 3.0 US, CA, UK
TxnDate 91 DATE 10 True True True False CCCC-MM-DD 1.0 US, CA, UK
TxnDateMacro 12 VARCHAR 25 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
 1.0 US, CA, UK
RefNumber 12 VARCHAR 11 True True True False %s 1.0 US, CA, UK
VendorAddress_Addr1 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
VendorAddress_Addr2 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
VendorAddress_Addr3 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
VendorAddress_Addr4 12 VARCHAR 41 True True True False %s 2.0 US, CA, UK
VendorAddress_Addr5 12 VARCHAR 41 True True True False %s 6.0 US, CA, UK
VendorAddress_City 12 VARCHAR 31 True True True False %s 1.0 US, CA, UK
VendorAddress_State 12 VARCHAR 21 True True True False %s 1.0 US, CA, UK
VendorAddress_PostalCode 12 VARCHAR 13 True True True False %s 1.0 US, CA, UK
VendorAddress_Country 12 VARCHAR 31 True True True False %s 1.0 US, CA, UK
VendorAddress_Note 12 VARCHAR 41 True True True False %s 6.0 US, CA, UK
VendorAddressBlock_Addr1 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
VendorAddressBlock_Addr2 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
VendorAddressBlock_Addr3 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
VendorAddressBlock_Addr4 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
VendorAddressBlock_Addr5 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
ShipAddress_Addr1 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
ShipAddress_Addr2 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
ShipAddress_Addr3 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
ShipAddress_Addr4 12 VARCHAR 41 True True True False %s 2.0 US, CA, UK
ShipAddress_Addr5 12 VARCHAR 41 True True True False %s 6.0 US, CA, UK
ShipAddress_City 12 VARCHAR 31 True True True False %s 1.0 US, CA, UK
ShipAddress_State 12 VARCHAR 21 True True True False %s 1.0 US, CA, UK
ShipAddress_PostalCode 12 VARCHAR 13 True True True False %s 1.0 US, CA, UK
ShipAddress_Country 12 VARCHAR 21 True True True False %s 1.0 US, CA, UK
ShipAddress_Note 12 VARCHAR 41 True True True False %s 1.0 US, CA, UK
ShipAddressBlock_Addr1 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
ShipAddressBlock_Addr2 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
ShipAddressBlock_Addr3 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
ShipAddressBlock_Addr4 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
ShipAddressBlock_Addr5 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
TermsRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
TermsRef_FullName 12 VARCHAR 31 True True True False %s Name 1.0 US, CA, UK
DueDate 91 DATE 10 True True True False CCCC-MM-DD 1.0 US, CA, UK
ExpectedDate 91 DATE 10 True True True False CCCC-MM-DD 1.0 US, CA, UK
ShipMethodRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
ShipMethodRef_FullName 12 VARCHAR 15 True True True False %s Name 1.0 US, CA, UK
FOB 12 VARCHAR 13 True True True False %s 1.0 US, CA, UK
TotalAmount 2 NUMERIC 15 True False False False %10.2f 1.0 US, CA, UK
CurrencyRef_ListID 12 VARCHAR 36 True False False False %s 8.0 US, CA, UK
ExchangeRate 2 NUMERIC 18 True True True False %6.6f 8.0 US, CA, UK
CurrencyRef_FullName 12 VARCHAR 64 True False False False %s Name 8.0 US, CA, UK
TotalAmountInHomeCurrency 2 NUMERIC 15 True False False False %10.2f 8.0 US, CA, UK
IsManuallyClosed -7 BIT 2 True True True False
1
0
true
false
 2.1 US, CA, UK
IsFullyReceived -7 BIT 2 True False False False
1
0
true
false
 2.1 US, CA, UK
Memo 12 VARCHAR 4095 True True True False %s 1.0 US, CA, UK
VendorMsg 12 VARCHAR 99 True True True False %s 1.0 US, CA, UK
IsToBePrinted -7 BIT 2 True True True False
1
0
true
false
 1.0 US, CA, UK
IsToBeEmailed -7 BIT 2 True True True False
1
0
true
false
 6.0 US, CA, UK
Other1 12 VARCHAR 29 True True True False %s 6.0 US, CA, UK
Other2 12 VARCHAR 29 True True True False %s 6.0 US, CA, UK
ExternalGUID 12 VARCHAR 40 9.0 US, CA, UK

Back to list of tables.