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