Purchase_Order
The table below describes the Purchase_Order table.
This table contains the following virtual tables:
- PurchaseOrder_Account_Based_Expense_Line
- PurchaseOrder_Item_Based_Expense_Line
- PurchaseOrder_LinkedTxn
- PurchaseOrder_CustomField
- PurchaseOrder_TxnTaxDetail_TaxLine
This table contains the following foldable columns:
- Id
- Document_Number
- Transaction_Date
The primary key columns in this table are returnable.
| Column Name | SQL Type | Updatable | Nullable |
|---|---|---|---|
|
Id Primary Key |
SQL_VARCHAR(255) | False | False |
|
APAccountRef_Name |
SQL_VARCHAR(255) | True | True |
|
APAccountRef_Value |
SQL_VARCHAR(255) | True | True |
|
ClassRef_Name |
SQL_VARCHAR(255) | True | True |
|
ClassRef_Value |
SQL_VARCHAR(255) | True | True |
|
Create_Time |
SQL_TIMESTAMP | False | True |
|
CurrencyRef_Name |
SQL_VARCHAR(255) | False | True |
|
CurrencyRef_Value |
SQL_VARCHAR(255) | False | True |
|
Document_Number |
SQL_VARCHAR(255) | True | True |
|
Due_Date |
SQL_DATE | True | True |
|
Exchange_Rate |
SQL_NUMERIC(15,2) | True | True |
|
Global_Tax_Calculation |
SQL_VARCHAR(255) | True | True |
|
Last_Updated_Time |
SQL_TIMESTAMP | False | True |
|
Memo |
SQL_VARCHAR(255) | True | True |
|
POStatus |
SQL_VARCHAR(255) | True | True |
|
Private_Note |
SQL_VARCHAR(4000) | True | True |
|
SalesTermRef_Name |
SQL_VARCHAR(255) | True | True |
|
SalesTermRef_Value |
SQL_VARCHAR(255) | True | True |
|
ShipMethodRef_Name |
SQL_VARCHAR(255) | True | True |
|
ShipMethodRef_Value |
SQL_VARCHAR(255) | True | True |
|
Ship_Address_City |
SQL_VARCHAR(255) | True | True |
|
Ship_Address_Country |
SQL_VARCHAR(255) | True | True |
|
Ship_Address_Country_SubDivision_Code |
SQL_VARCHAR(255) | True | True |
|
Ship_Address_Id |
SQL_VARCHAR(255) | False | True |
|
Ship_Address_Lat |
SQL_VARCHAR(255) | True | True |
|
Ship_Address_Line1 |
SQL_VARCHAR(500) | True | True |
|
Ship_Address_Line2 |
SQL_VARCHAR(500) | True | True |
|
Ship_Address_Line3 |
SQL_VARCHAR(500) | True | True |
|
Ship_Address_Line4 |
SQL_VARCHAR(500) | True | True |
|
Ship_Address_Line5 |
SQL_VARCHAR(500) | True | True |
|
Ship_Address_Long |
SQL_VARCHAR(255) | True | True |
|
Ship_Address_Note |
SQL_VARCHAR(255) | True | True |
|
Ship_Address_Postal_Code |
SQL_VARCHAR(255) | True | True |
|
SyncToken |
SQL_VARCHAR(255) | True | True |
|
Total_Amount |
SQL_NUMERIC(15,2) | True | True |
|
Transaction_Date |
SQL_DATE | True | True |
|
Transaction_Location_Type |
SQL_VARCHAR(255) | True | True |
|
TxnTaxDetail_TotalTax |
SQL_NUMERIC(15,2) | True | True |
|
TxnTaxDetail_TxnTaxCodeRef_Name |
SQL_VARCHAR(255) | True | True |
|
TxnTaxDetail_TxnTaxCodeRef_Value |
SQL_VARCHAR(255) | True | True |
|
VendorRef_Name |
SQL_VARCHAR(255) | True | True |
|
VendorRef_Value |
SQL_VARCHAR(255) | True | True |
|
Vendor_Address_City |
SQL_VARCHAR(255) | True | True |
|
Vendor_Address_Country |
SQL_VARCHAR(255) | True | True |
|
Vendor_Address_Country_SubDivision_Code |
SQL_VARCHAR(255) | True | True |
|
Vendor_Address_Id |
SQL_VARCHAR(255) | False | True |
|
Vendor_Address_Lat |
SQL_VARCHAR(255) | True | True |
|
Vendor_Address_Line1 |
SQL_VARCHAR(500) | True | True |
|
Vendor_Address_Line2 |
SQL_VARCHAR(500) | True | True |
|
Vendor_Address_Line3 |
SQL_VARCHAR(500) | True | True |
|
Vendor_Address_Line4 |
SQL_VARCHAR(500) | True | True |
|
Vendor_Address_Line5 |
SQL_VARCHAR(500) | True | True |
|
Vendor_Address_Long |
SQL_VARCHAR(255) | True | True |
|
Vendor_Address_Note |
SQL_VARCHAR(255) | True | True |
|
Vendor_Address_Postal_Code |
SQL_VARCHAR(255) | True | True |