TDV Adapter for Microsoft Dynamics NAV

Build 24.0.9060

PurchaseOrderPurchLines

The DynamicsNAV table PurchaseOrderPurchLines.

Columns

Name Type ReadOnly Description
Document_No [KEY] String False

The Document_No column for the table PurchaseOrderPurchLines.

Document_Type [KEY] String False

The Document_Type column for the table PurchaseOrderPurchLines.

Line_No [KEY] Int32 False

The Line_No column for the table PurchaseOrderPurchLines.

Allow_Invoice_Disc Boolean False

The Allow_Invoice_Disc column for the table PurchaseOrderPurchLines.

Allow_Item_Charge_Assignment Boolean False

The Allow_Item_Charge_Assignment column for the table PurchaseOrderPurchLines.

Appl_to_Item_Entry Int32 False

The Appl_to_Item_Entry column for the table PurchaseOrderPurchLines.

Bin_Code String False

The Bin_Code column for the table PurchaseOrderPurchLines.

Blanket_Order_Line_No Int32 False

The Blanket_Order_Line_No column for the table PurchaseOrderPurchLines.

Blanket_Order_No String False

The Blanket_Order_No column for the table PurchaseOrderPurchLines.

Cross_Reference_No String False

The Cross_Reference_No column for the table PurchaseOrderPurchLines.

Description String False

The Description column for the table PurchaseOrderPurchLines.

Direct_Unit_Cost Decimal False

The Direct_Unit_Cost column for the table PurchaseOrderPurchLines.

Drop_Shipment Boolean False

The Drop_Shipment column for the table PurchaseOrderPurchLines.

ETag String False

The ETag column for the table PurchaseOrderPurchLines.

Expected_Receipt_Date Datetime False

The Expected_Receipt_Date column for the table PurchaseOrderPurchLines.

Finished Boolean False

The Finished column for the table PurchaseOrderPurchLines.

GST_HST String False

The GST_HST column for the table PurchaseOrderPurchLines.

IC_Partner_Code String False

The IC_Partner_Code column for the table PurchaseOrderPurchLines.

IC_Partner_Ref_Type String False

The IC_Partner_Ref_Type column for the table PurchaseOrderPurchLines.

IC_Partner_Reference String False

The IC_Partner_Reference column for the table PurchaseOrderPurchLines.

Inbound_Whse_Handling_Time String False

The Inbound_Whse_Handling_Time column for the table PurchaseOrderPurchLines.

Indirect_Cost_Percent Decimal False

The Indirect_Cost_Percent column for the table PurchaseOrderPurchLines.

Inv_Discount_Amount Decimal False

The Inv_Discount_Amount column for the table PurchaseOrderPurchLines.

IRS_1099_Liable Boolean False

The IRS_1099_Liable column for the table PurchaseOrderPurchLines.

Job_Line_Amount Decimal False

The Job_Line_Amount column for the table PurchaseOrderPurchLines.

Job_Line_Amount_LCY Decimal False

The Job_Line_Amount_LCY column for the table PurchaseOrderPurchLines.

Job_Line_Disc_Amount_LCY Decimal False

The Job_Line_Disc_Amount_LCY column for the table PurchaseOrderPurchLines.

Job_Line_Discount_Amount Decimal False

The Job_Line_Discount_Amount column for the table PurchaseOrderPurchLines.

Job_Line_Discount_Percent Decimal False

The Job_Line_Discount_Percent column for the table PurchaseOrderPurchLines.

Job_Line_Type String False

The Job_Line_Type column for the table PurchaseOrderPurchLines.

Job_No String False

The Job_No column for the table PurchaseOrderPurchLines.

Job_Planning_Line_No Int32 False

The Job_Planning_Line_No column for the table PurchaseOrderPurchLines.

Job_Remaining_Qty Decimal False

The Job_Remaining_Qty column for the table PurchaseOrderPurchLines.

Job_Task_No String False

The Job_Task_No column for the table PurchaseOrderPurchLines.

Job_Total_Price Decimal False

The Job_Total_Price column for the table PurchaseOrderPurchLines.

Job_Total_Price_LCY Decimal False

The Job_Total_Price_LCY column for the table PurchaseOrderPurchLines.

Job_Unit_Price Decimal False

The Job_Unit_Price column for the table PurchaseOrderPurchLines.

Job_Unit_Price_LCY Decimal False

The Job_Unit_Price_LCY column for the table PurchaseOrderPurchLines.

Lead_Time_Calculation String False

The Lead_Time_Calculation column for the table PurchaseOrderPurchLines.

Line_Amount Decimal False

The Line_Amount column for the table PurchaseOrderPurchLines.

Line_Discount_Amount Decimal False

The Line_Discount_Amount column for the table PurchaseOrderPurchLines.

Line_Discount_Percent Decimal False

The Line_Discount_Percent column for the table PurchaseOrderPurchLines.

Location_Code String False

The Location_Code column for the table PurchaseOrderPurchLines.

No String False

The No column for the table PurchaseOrderPurchLines.

Nonstock Boolean False

The Nonstock column for the table PurchaseOrderPurchLines.

Operation_No String False

The Operation_No column for the table PurchaseOrderPurchLines.

Order_Date Datetime False

The Order_Date column for the table PurchaseOrderPurchLines.

Planned_Receipt_Date Datetime False

The Planned_Receipt_Date column for the table PurchaseOrderPurchLines.

Planning_Flexibility String False

The Planning_Flexibility column for the table PurchaseOrderPurchLines.

Prepayment_Percent Decimal False

The Prepayment_Percent column for the table PurchaseOrderPurchLines.

Prepmt_Amt_Deducted Decimal False

The Prepmt_Amt_Deducted column for the table PurchaseOrderPurchLines.

Prepmt_Amt_Inv Decimal False

The Prepmt_Amt_Inv column for the table PurchaseOrderPurchLines.

Prepmt_Amt_to_Deduct Decimal False

The Prepmt_Amt_to_Deduct column for the table PurchaseOrderPurchLines.

Prepmt_Line_Amount Decimal False

The Prepmt_Line_Amount column for the table PurchaseOrderPurchLines.

Prod_Order_Line_No Int32 False

The Prod_Order_Line_No column for the table PurchaseOrderPurchLines.

Prod_Order_No String False

The Prod_Order_No column for the table PurchaseOrderPurchLines.

Promised_Receipt_Date Datetime False

The Promised_Receipt_Date column for the table PurchaseOrderPurchLines.

Provincial_Tax_Area_Code String False

The Provincial_Tax_Area_Code column for the table PurchaseOrderPurchLines.

Qty_Assigned Decimal False

The Qty_Assigned column for the table PurchaseOrderPurchLines.

Qty_to_Assign Decimal False

The Qty_to_Assign column for the table PurchaseOrderPurchLines.

Qty_to_Invoice Decimal False

The Qty_to_Invoice column for the table PurchaseOrderPurchLines.

Qty_to_Receive Decimal False

The Qty_to_Receive column for the table PurchaseOrderPurchLines.

Quantity Decimal False

The Quantity column for the table PurchaseOrderPurchLines.

Quantity_Invoiced Decimal False

The Quantity_Invoiced column for the table PurchaseOrderPurchLines.

Quantity_Received Decimal False

The Quantity_Received column for the table PurchaseOrderPurchLines.

Requested_Receipt_Date Datetime False

The Requested_Receipt_Date column for the table PurchaseOrderPurchLines.

Reserved_Quantity Decimal False

The Reserved_Quantity column for the table PurchaseOrderPurchLines.

Return_Reason_Code String False

The Return_Reason_Code column for the table PurchaseOrderPurchLines.

Shortcut_Dimension_1_Code String False

The Shortcut_Dimension_1_Code column for the table PurchaseOrderPurchLines.

Shortcut_Dimension_2_Code String False

The Shortcut_Dimension_2_Code column for the table PurchaseOrderPurchLines.

ShortcutDimCode_x005B_3_x005D_ String False

The ShortcutDimCode_x005B_3_x005D_ column for the table PurchaseOrderPurchLines.

ShortcutDimCode_x005B_4_x005D_ String False

The ShortcutDimCode_x005B_4_x005D_ column for the table PurchaseOrderPurchLines.

ShortcutDimCode_x005B_5_x005D_ String False

The ShortcutDimCode_x005B_5_x005D_ column for the table PurchaseOrderPurchLines.

ShortcutDimCode_x005B_6_x005D_ String False

The ShortcutDimCode_x005B_6_x005D_ column for the table PurchaseOrderPurchLines.

ShortcutDimCode_x005B_7_x005D_ String False

The ShortcutDimCode_x005B_7_x005D_ column for the table PurchaseOrderPurchLines.

ShortcutDimCode_x005B_8_x005D_ String False

The ShortcutDimCode_x005B_8_x005D_ column for the table PurchaseOrderPurchLines.

Tax_Area_Code String False

The Tax_Area_Code column for the table PurchaseOrderPurchLines.

Tax_Group_Code String False

The Tax_Group_Code column for the table PurchaseOrderPurchLines.

Tax_Liable Boolean False

The Tax_Liable column for the table PurchaseOrderPurchLines.

Type String False

The Type column for the table PurchaseOrderPurchLines.

Unit_Cost_LCY Decimal False

The Unit_Cost_LCY column for the table PurchaseOrderPurchLines.

Unit_of_Measure String False

The Unit_of_Measure column for the table PurchaseOrderPurchLines.

Unit_of_Measure_Code String False

The Unit_of_Measure_Code column for the table PurchaseOrderPurchLines.

Unit_Price_LCY Decimal False

The Unit_Price_LCY column for the table PurchaseOrderPurchLines.

Use_Tax Boolean False

The Use_Tax column for the table PurchaseOrderPurchLines.

Variant_Code String False

The Variant_Code column for the table PurchaseOrderPurchLines.

VAT_Prod_Posting_Group String False

The VAT_Prod_Posting_Group column for the table PurchaseOrderPurchLines.

Whse_Outstanding_Qty_Base Decimal False

The Whse_Outstanding_Qty_Base column for the table PurchaseOrderPurchLines.

Work_Center_No String False

The Work_Center_No column for the table PurchaseOrderPurchLines.

LinkedBlanket_Order_Line_No_Link String False

The LinkedBlanket_Order_Line_No_Link column for the table PurchaseOrderPurchLines.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060