PurchaseOrder
The DynamicsNAV table PurchaseOrder.
Columns
| Name | Type | ReadOnly | Description |
| Document_Type [KEY] | String | False |
The Document_Type column for the table PurchaseOrder. |
| No [KEY] | String | False |
The No column for the table PurchaseOrder. |
| Area | String | False |
The Area column for the table PurchaseOrder. |
| Assigned_User_ID | String | False |
The Assigned_User_ID column for the table PurchaseOrder. |
| Buy_from_Address | String | False |
The Buy_from_Address column for the table PurchaseOrder. |
| Buy_from_Address_2 | String | False |
The Buy_from_Address_2 column for the table PurchaseOrder. |
| Buy_from_City | String | False |
The Buy_from_City column for the table PurchaseOrder. |
| Buy_from_Contact | String | False |
The Buy_from_Contact column for the table PurchaseOrder. |
| Buy_from_Contact_No | String | False |
The Buy_from_Contact_No column for the table PurchaseOrder. |
| Buy_from_County | String | False |
The Buy_from_County column for the table PurchaseOrder. |
| Buy_from_Post_Code | String | False |
The Buy_from_Post_Code column for the table PurchaseOrder. |
| Buy_from_Vendor_Name | String | False |
The Buy_from_Vendor_Name column for the table PurchaseOrder. |
| Buy_from_Vendor_No | String | False |
The Buy_from_Vendor_No column for the table PurchaseOrder. |
| Compress_Prepayment | Boolean | False |
The Compress_Prepayment column for the table PurchaseOrder. |
| Creditor_No | String | False |
The Creditor_No column for the table PurchaseOrder. |
| Currency_Code | String | False |
The Currency_Code column for the table PurchaseOrder. |
| Document_Date | Datetime | False |
The Document_Date column for the table PurchaseOrder. |
| Due_Date | Datetime | False |
The Due_Date column for the table PurchaseOrder. |
| Entry_Point | String | False |
The Entry_Point column for the table PurchaseOrder. |
| ETag | String | False |
The ETag column for the table PurchaseOrder. |
| Expected_Receipt_Date | Datetime | False |
The Expected_Receipt_Date column for the table PurchaseOrder. |
| Inbound_Whse_Handling_Time | String | False |
The Inbound_Whse_Handling_Time column for the table PurchaseOrder. |
| IRS_1099_Code | String | False |
The IRS_1099_Code column for the table PurchaseOrder. |
| Job_Queue_Status | String | False |
The Job_Queue_Status column for the table PurchaseOrder. |
| Lead_Time_Calculation | String | False |
The Lead_Time_Calculation column for the table PurchaseOrder. |
| Location_Code | String | False |
The Location_Code column for the table PurchaseOrder. |
| No_of_Archived_Versions | Int32 | False |
The No_of_Archived_Versions column for the table PurchaseOrder. |
| On_Hold | String | False |
The On_Hold column for the table PurchaseOrder. |
| Order_Address_Code | String | False |
The Order_Address_Code column for the table PurchaseOrder. |
| Order_Date | Datetime | False |
The Order_Date column for the table PurchaseOrder. |
| Pay_to_Address | String | False |
The Pay_to_Address column for the table PurchaseOrder. |
| Pay_to_Address_2 | String | False |
The Pay_to_Address_2 column for the table PurchaseOrder. |
| Pay_to_City | String | False |
The Pay_to_City column for the table PurchaseOrder. |
| Pay_to_Contact | String | False |
The Pay_to_Contact column for the table PurchaseOrder. |
| Pay_to_Contact_No | String | False |
The Pay_to_Contact_No column for the table PurchaseOrder. |
| Pay_to_County | String | False |
The Pay_to_County column for the table PurchaseOrder. |
| Pay_to_Name | String | False |
The Pay_to_Name column for the table PurchaseOrder. |
| Pay_to_Post_Code | String | False |
The Pay_to_Post_Code column for the table PurchaseOrder. |
| Pay_to_Vendor_No | String | False |
The Pay_to_Vendor_No column for the table PurchaseOrder. |
| Payment_Discount_Percent | Decimal | False |
The Payment_Discount_Percent column for the table PurchaseOrder. |
| Payment_Reference | String | False |
The Payment_Reference column for the table PurchaseOrder. |
| Payment_Terms_Code | String | False |
The Payment_Terms_Code column for the table PurchaseOrder. |
| Pmt_Discount_Date | Datetime | False |
The Pmt_Discount_Date column for the table PurchaseOrder. |
| Posting_Date | Datetime | False |
The Posting_Date column for the table PurchaseOrder. |
| Posting_Description | String | False |
The Posting_Description column for the table PurchaseOrder. |
| Prepayment_Due_Date | Datetime | False |
The Prepayment_Due_Date column for the table PurchaseOrder. |
| Prepayment_Percent | Decimal | False |
The Prepayment_Percent column for the table PurchaseOrder. |
| Prepmt_Include_Tax | Boolean | False |
The Prepmt_Include_Tax column for the table PurchaseOrder. |
| Prepmt_Payment_Discount_Percent | Decimal | False |
The Prepmt_Payment_Discount_Percent column for the table PurchaseOrder. |
| Prepmt_Payment_Terms_Code | String | False |
The Prepmt_Payment_Terms_Code column for the table PurchaseOrder. |
| Prepmt_Pmt_Discount_Date | Datetime | False |
The Prepmt_Pmt_Discount_Date column for the table PurchaseOrder. |
| Promised_Receipt_Date | Datetime | False |
The Promised_Receipt_Date column for the table PurchaseOrder. |
| Provincial_Tax_Area_Code | String | False |
The Provincial_Tax_Area_Code column for the table PurchaseOrder. |
| Purchaser_Code | String | False |
The Purchaser_Code column for the table PurchaseOrder. |
| Quote_No | String | False |
The Quote_No column for the table PurchaseOrder. |
| Requested_Receipt_Date | Datetime | False |
The Requested_Receipt_Date column for the table PurchaseOrder. |
| Responsibility_Center | String | False |
The Responsibility_Center column for the table PurchaseOrder. |
| Sell_to_Customer_No | String | False |
The Sell_to_Customer_No column for the table PurchaseOrder. |
| Ship_to_Address | String | False |
The Ship_to_Address column for the table PurchaseOrder. |
| Ship_to_Address_2 | String | False |
The Ship_to_Address_2 column for the table PurchaseOrder. |
| Ship_to_City | String | False |
The Ship_to_City column for the table PurchaseOrder. |
| Ship_to_Code | String | False |
The Ship_to_Code column for the table PurchaseOrder. |
| Ship_to_Contact | String | False |
The Ship_to_Contact column for the table PurchaseOrder. |
| Ship_to_County | String | False |
The Ship_to_County column for the table PurchaseOrder. |
| Ship_to_Name | String | False |
The Ship_to_Name column for the table PurchaseOrder. |
| Ship_to_Post_Code | String | False |
The Ship_to_Post_Code column for the table PurchaseOrder. |
| Ship_to_UPS_Zone | String | False |
The Ship_to_UPS_Zone column for the table PurchaseOrder. |
| Shipment_Method_Code | String | False |
The Shipment_Method_Code column for the table PurchaseOrder. |
| Shortcut_Dimension_1_Code | String | False |
The Shortcut_Dimension_1_Code column for the table PurchaseOrder. |
| Shortcut_Dimension_2_Code | String | False |
The Shortcut_Dimension_2_Code column for the table PurchaseOrder. |
| Status | String | False |
The Status column for the table PurchaseOrder. |
| Tax_Area_Code | String | False |
The Tax_Area_Code column for the table PurchaseOrder. |
| Tax_Exemption_No | String | False |
The Tax_Exemption_No column for the table PurchaseOrder. |
| Tax_Liable | Boolean | False |
The Tax_Liable column for the table PurchaseOrder. |
| Transaction_Specification | String | False |
The Transaction_Specification column for the table PurchaseOrder. |
| Transaction_Type | String | False |
The Transaction_Type column for the table PurchaseOrder. |
| Transport_Method | String | False |
The Transport_Method column for the table PurchaseOrder. |
| Vendor_Cr_Memo_No | String | False |
The Vendor_Cr_Memo_No column for the table PurchaseOrder. |
| Vendor_Invoice_No | String | False |
The Vendor_Invoice_No column for the table PurchaseOrder. |
| Vendor_Order_No | String | False |
The Vendor_Order_No column for the table PurchaseOrder. |
| Vendor_Shipment_No | String | False |
The Vendor_Shipment_No column for the table PurchaseOrder. |
| LinkedPurchaseOrderPurchLines | String | False |
The LinkedPurchaseOrderPurchLines column for the table PurchaseOrder. |
| LinkedCurrency_Code_Link | String | False |
The LinkedCurrency_Code_Link column for the table PurchaseOrder. |