JDBC Driver for Microsoft Dynamics NAV

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462