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. |