JDBC Driver for Microsoft Dynamics NAV

Build 22.0.8462

PurchaseLines

The DynamicsNAV table PurchaseLines.

Columns

Name Type ReadOnly Description
Document_No [KEY] String False

The Document_No column for the table PurchaseLines.

Document_Type [KEY] String False

The Document_Type column for the table PurchaseLines.

Line_No [KEY] Int32 False

The Line_No column for the table PurchaseLines.

Amt_Rcd_Not_Invoiced_LCY Decimal False

The Amt_Rcd_Not_Invoiced_LCY column for the table PurchaseLines.

Buy_from_Vendor_No String False

The Buy_from_Vendor_No column for the table PurchaseLines.

Description String False

The Description column for the table PurchaseLines.

Direct_Unit_Cost Decimal False

The Direct_Unit_Cost column for the table PurchaseLines.

ETag String False

The ETag column for the table PurchaseLines.

Expected_Receipt_Date Datetime False

The Expected_Receipt_Date column for the table PurchaseLines.

Indirect_Cost_Percent Decimal False

The Indirect_Cost_Percent column for the table PurchaseLines.

Job_Line_Type String False

The Job_Line_Type column for the table PurchaseLines.

Job_No String False

The Job_No column for the table PurchaseLines.

Job_Task_No String False

The Job_Task_No column for the table PurchaseLines.

Line_Amount Decimal False

The Line_Amount column for the table PurchaseLines.

Location_Code String False

The Location_Code column for the table PurchaseLines.

No String False

The No column for the table PurchaseLines.

Outstanding_Amount_LCY Decimal False

The Outstanding_Amount_LCY column for the table PurchaseLines.

Outstanding_Quantity Decimal False

The Outstanding_Quantity column for the table PurchaseLines.

Quantity Decimal False

The Quantity column for the table PurchaseLines.

Reserved_Qty_Base Decimal False

The Reserved_Qty_Base column for the table PurchaseLines.

Shortcut_Dimension_1_Code String False

The Shortcut_Dimension_1_Code column for the table PurchaseLines.

Shortcut_Dimension_2_Code String False

The Shortcut_Dimension_2_Code column for the table PurchaseLines.

ShortcutDimCode_x005B_3_x005D_ String False

The ShortcutDimCode_x005B_3_x005D_ column for the table PurchaseLines.

ShortcutDimCode_x005B_4_x005D_ String False

The ShortcutDimCode_x005B_4_x005D_ column for the table PurchaseLines.

ShortcutDimCode_x005B_5_x005D_ String False

The ShortcutDimCode_x005B_5_x005D_ column for the table PurchaseLines.

ShortcutDimCode_x005B_6_x005D_ String False

The ShortcutDimCode_x005B_6_x005D_ column for the table PurchaseLines.

ShortcutDimCode_x005B_7_x005D_ String False

The ShortcutDimCode_x005B_7_x005D_ column for the table PurchaseLines.

ShortcutDimCode_x005B_8_x005D_ String False

The ShortcutDimCode_x005B_8_x005D_ column for the table PurchaseLines.

Type String False

The Type column for the table PurchaseLines.

Unit_Cost_LCY Decimal False

The Unit_Cost_LCY column for the table PurchaseLines.

Unit_of_Measure_Code String False

The Unit_of_Measure_Code column for the table PurchaseLines.

Unit_Price_LCY Decimal False

The Unit_Price_LCY column for the table PurchaseLines.

Variant_Code String False

The Variant_Code column for the table PurchaseLines.

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