Name

Description

The DynamicsNAV table Company.

The DynamicsNAV table Country.

The DynamicsNAV table Currency.

The DynamicsNAV table Customer.

The DynamicsNAV table GeneralProductPosting.

The DynamicsNAV table PurchaseLines.

The DynamicsNAV table PurchaseOrder.

The DynamicsNAV table PurchaseOrderPurchLines.

The DynamicsNAV table PurchaseOrders.

The DynamicsNAV table ResourceCard.

The DynamicsNAV table SalesOrder.

Name

Type

ReadOnly

Description

Name [KEY]

String

False

The Name column for the table Company.

LinkedCountry

String

False

The LinkedCountry column for the table Company.

LinkedCurrency

String

False

The LinkedCurrency column for the table Company.

LinkedCustomer

String

False

The LinkedCustomer column for the table Company.

LinkedGeneralProductPosting

String

False

The LinkedGeneralProductPosting column for the table Company.

LinkedPurchaseLines

String

False

The LinkedPurchaseLines column for the table Company.

LinkedPurchaseOrder

String

False

The LinkedPurchaseOrder column for the table Company.

LinkedPurchaseOrderPurchLines

String

False

The LinkedPurchaseOrderPurchLines column for the table Company.

LinkedPurchaseOrders

String

False

The LinkedPurchaseOrders column for the table Company.

LinkedResourceCard

String

False

The LinkedResourceCard column for the table Company.

LinkedSalesOrder

String

False

The LinkedSalesOrder column for the table Company.

Name

Type

ReadOnly

Description

Code [KEY]

String

False

The Code column for the table Country.

Address_Format

String

False

The Address_Format column for the table Country.

Contact_Address_Format

String

False

The Contact_Address_Format column for the table Country.

ETag

String

False

The ETag column for the table Country.

EU_Country_Region_Code

String

False

The EU_Country_Region_Code column for the table Country.

Intrastat_Code

String

False

The Intrastat_Code column for the table Country.

Name

String

False

The Name column for the table Country.

Name

Type

ReadOnly

Description

Code [KEY]

String

False

The Code column for the table Currency.

Amount_Decimal_Places

String

False

The Amount_Decimal_Places column for the table Currency.

Amount_Rounding_Precision

Decimal

False

The Amount_Rounding_Precision column for the table Currency.

Appln_Rounding_Precision

Decimal

False

The Appln_Rounding_Precision column for the table Currency.

Conv_LCY_Rndg_Credit_Acc

String

False

The Conv_LCY_Rndg_Credit_Acc column for the table Currency.

Conv_LCY_Rndg_Debit_Acc

String

False

The Conv_LCY_Rndg_Debit_Acc column for the table Currency.

CurrencyFactor

Decimal

False

The CurrencyFactor column for the table Currency.

Description

String

False

The Description column for the table Currency.

EMU_Currency

Boolean

False

The EMU_Currency column for the table Currency.

ETag

String

False

The ETag column for the table Currency.

Invoice_Rounding_Precision

Decimal

False

The Invoice_Rounding_Precision column for the table Currency.

Invoice_Rounding_Type

String

False

The Invoice_Rounding_Type column for the table Currency.

Last_Date_Adjusted

Datetime

False

The Last_Date_Adjusted column for the table Currency.

Last_Date_Modified

Datetime

False

The Last_Date_Modified column for the table Currency.

Max_Payment_Tolerance_Amount

Decimal

False

The Max_Payment_Tolerance_Amount column for the table Currency.

Max_VAT_Difference_Allowed

Decimal

False

The Max_VAT_Difference_Allowed column for the table Currency.

Payment_Tolerance_Percent

Decimal

False

The Payment_Tolerance_Percent column for the table Currency.

Realized_G_L_Gains_Account

String

False

The Realized_G_L_Gains_Account column for the table Currency.

Realized_G_L_Losses_Account

String

False

The Realized_G_L_Losses_Account column for the table Currency.

Realized_Gains_Acc

String

False

The Realized_Gains_Acc column for the table Currency.

Realized_Losses_Acc

String

False

The Realized_Losses_Acc column for the table Currency.

Residual_Gains_Account

String

False

The Residual_Gains_Account column for the table Currency.

Residual_Losses_Account

String

False

The Residual_Losses_Account column for the table Currency.

Symbol

String

False

The Symbol column for the table Currency.

Unit_Amount_Decimal_Places

String

False

The Unit_Amount_Decimal_Places column for the table Currency.

Unit_Amount_Rounding_Precision

Decimal

False

The Unit_Amount_Rounding_Precision column for the table Currency.

Unrealized_Gains_Acc

String

False

The Unrealized_Gains_Acc column for the table Currency.

Unrealized_Losses_Acc

String

False

The Unrealized_Losses_Acc column for the table Currency.

VAT_Rounding_Type

String

False

The VAT_Rounding_Type column for the table Currency.

Name

Type

ReadOnly

Description

No [KEY]

String

False

The No column for the table Customer.

Address

String

False

The Address column for the table Customer.

Address_2

String

False

The Address_2 column for the table Customer.

Allow_Line_Disc

Boolean

False

The Allow_Line_Disc column for the table Customer.

Application_Method

String

False

The Application_Method column for the table Customer.

Balance_LCY

Decimal

False

The Balance_LCY column for the table Customer.

Bank_Communication

String

False

The Bank_Communication column for the table Customer.

Base_Calendar_Code

String

False

The Base_Calendar_Code column for the table Customer.

Bill_to_Customer_No

String

False

The Bill_to_Customer_No column for the table Customer.

Block_Payment_Tolerance

Boolean

False

The Block_Payment_Tolerance column for the table Customer.

Blocked

String

False

The Blocked column for the table Customer.

Cash_Flow_Payment_Terms_Code

String

False

The Cash_Flow_Payment_Terms_Code column for the table Customer.

Check_Date_Format

String

False

The Check_Date_Format column for the table Customer.

Check_Date_Separator

String

False

The Check_Date_Separator column for the table Customer.

City

String

False

The City column for the table Customer.

Combine_Shipments

Boolean

False

The Combine_Shipments column for the table Customer.

Contact

String

False

The Contact column for the table Customer.

Copy_Sell_to_Addr_to_Qte_From

String

False

The Copy_Sell_to_Addr_to_Qte_From column for the table Customer.

Country_Region_Code

String

False

The Country_Region_Code column for the table Customer.

County

String

False

The County column for the table Customer.

Credit_Limit_LCY

Decimal

False

The Credit_Limit_LCY column for the table Customer.

CURP_No

String

False

The CURP_No column for the table Customer.

Currency_Code

String

False

The Currency_Code column for the table Customer.

Currency_Filter

String

False

The Currency_Filter column for the table Customer.

Customer_Disc_Group

String

False

The Customer_Disc_Group column for the table Customer.

Customer_Posting_Group

String

False

The Customer_Posting_Group column for the table Customer.

Customer_Price_Group

String

False

The Customer_Price_Group column for the table Customer.

Customized_Calendar

String

False

The Customized_Calendar column for the table Customer.

E_Mail

String

False

The E_Mail column for the table Customer.

ETag

String

False

The ETag column for the table Customer.

Fax_No

String

False

The Fax_No column for the table Customer.

Fin_Charge_Terms_Code

String

False

The Fin_Charge_Terms_Code column for the table Customer.

Gen_Bus_Posting_Group

String

False

The Gen_Bus_Posting_Group column for the table Customer.

Global_Dimension_1_Filter

String

False

The Global_Dimension_1_Filter column for the table Customer.

Global_Dimension_2_Filter

String

False

The Global_Dimension_2_Filter column for the table Customer.

Home_Page

String

False

The Home_Page column for the table Customer.

IC_Partner_Code

String

False

The IC_Partner_Code column for the table Customer.

Invoice_Copies

Int32

False

The Invoice_Copies column for the table Customer.

Invoice_Disc_Code

String

False

The Invoice_Disc_Code column for the table Customer.

Language_Code

String

False

The Language_Code column for the table Customer.

Last_Date_Modified

Datetime

False

The Last_Date_Modified column for the table Customer.

Last_Statement_No

Int32

False

The Last_Statement_No column for the table Customer.

Location_Code

String

False

The Location_Code column for the table Customer.

Name

String

False

The Name column for the table Customer.

Partner_Type

String

False

The Partner_Type column for the table Customer.

Payment_Method_Code

String

False

The Payment_Method_Code column for the table Customer.

Payment_Terms_Code

String

False

The Payment_Terms_Code column for the table Customer.

Phone_No

String

False

The Phone_No column for the table Customer.

Post_Code

String

False

The Post_Code column for the table Customer.

Preferred_Bank_Account

String

False

The Preferred_Bank_Account column for the table Customer.

Prepayment_Percent

Decimal

False

The Prepayment_Percent column for the table Customer.

Prices_Including_VAT

Boolean

False

The Prices_Including_VAT column for the table Customer.

Primary_Contact_No

String

False

The Primary_Contact_No column for the table Customer.

Print_Statements

Boolean

False

The Print_Statements column for the table Customer.

Reminder_Terms_Code

String

False

The Reminder_Terms_Code column for the table Customer.

Reserve

String

False

The Reserve column for the table Customer.

Responsibility_Center

String

False

The Responsibility_Center column for the table Customer.

RFC_No

String

False

The RFC_No column for the table Customer.

Salesperson_Code

String

False

The Salesperson_Code column for the table Customer.

Search_Name

String

False

The Search_Name column for the table Customer.

Service_Zone_Code

String

False

The Service_Zone_Code column for the table Customer.

Shipment_Method_Code

String

False

The Shipment_Method_Code column for the table Customer.

Shipping_Advice

String

False

The Shipping_Advice column for the table Customer.

Shipping_Agent_Code

String

False

The Shipping_Agent_Code column for the table Customer.

Shipping_Agent_Service_Code

String

False

The Shipping_Agent_Service_Code column for the table Customer.

Shipping_Time

String

False

The Shipping_Time column for the table Customer.

State_Inscription

String

False

The State_Inscription column for the table Customer.

Tax_Area_Code

String

False

The Tax_Area_Code column for the table Customer.

Tax_Exemption_No

String

False

The Tax_Exemption_No column for the table Customer.

Tax_Identification_Type

String

False

The Tax_Identification_Type column for the table Customer.

Tax_Liable

Boolean

False

The Tax_Liable column for the table Customer.

VAT_Bus_Posting_Group

String

False

The VAT_Bus_Posting_Group column for the table Customer.

VAT_Registration_No

String

False

The VAT_Registration_No column for the table Customer.

LinkedCountry_Region_Code_Link

String

False

The LinkedCountry_Region_Code_Link column for the table Customer.

LinkedCurrency_Code_Link

String

False

The LinkedCurrency_Code_Link column for the table Customer.

LinkedCurrency_Filter_Link

String

False

The LinkedCurrency_Filter_Link column for the table Customer.

Name

Type

ReadOnly

Description

Code [KEY]

String

False

The Code column for the table GeneralProductPosting.

Auto_Insert_Default

Boolean

False

The Auto_Insert_Default column for the table GeneralProductPosting.

Def_VAT_Prod_Posting_Group

String

False

The Def_VAT_Prod_Posting_Group column for the table GeneralProductPosting.

Description

String

False

The Description column for the table GeneralProductPosting.

ETag

String

False

The ETag column for the table GeneralProductPosting.

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.

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.

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.

Name

Type

ReadOnly

Description

Document_No [KEY]

String

False

The Document_No column for the table PurchaseOrders.

Document_Type [KEY]

String

False

The Document_Type column for the table PurchaseOrders.

Line_No [KEY]

Int32

False

The Line_No column for the table PurchaseOrders.

Amount

Decimal

False

The Amount column for the table PurchaseOrders.

Buy_from_Vendor_No

String

False

The Buy_from_Vendor_No column for the table PurchaseOrders.

Currency_Code

String

False

The Currency_Code column for the table PurchaseOrders.

Description

String

False

The Description column for the table PurchaseOrders.

Direct_Unit_Cost

Decimal

False

The Direct_Unit_Cost column for the table PurchaseOrders.

ETag

String

False

The ETag column for the table PurchaseOrders.

Expected_Receipt_Date

Datetime

False

The Expected_Receipt_Date column for the table PurchaseOrders.

Line_Discount_Percent

Decimal

False

The Line_Discount_Percent column for the table PurchaseOrders.

No

String

False

The No column for the table PurchaseOrders.

Outstanding_Quantity

Decimal

False

The Outstanding_Quantity column for the table PurchaseOrders.

Quantity

Decimal

False

The Quantity column for the table PurchaseOrders.

Type

String

False

The Type column for the table PurchaseOrders.

Unit_of_Measure_Code

String

False

The Unit_of_Measure_Code column for the table PurchaseOrders.

LinkedCurrency_Code_Link

String

False

The LinkedCurrency_Code_Link column for the table PurchaseOrders.

Name

Type

ReadOnly

Description

No [KEY]

String

False

The No column for the table ResourceCard.

Address

String

False

The Address column for the table ResourceCard.

Address_2

String

False

The Address_2 column for the table ResourceCard.

Automatic_Ext_Texts

Boolean

False

The Automatic_Ext_Texts column for the table ResourceCard.

Base_Unit_of_Measure

String

False

The Base_Unit_of_Measure column for the table ResourceCard.

Blocked

Boolean

False

The Blocked column for the table ResourceCard.

City

String

False

The City column for the table ResourceCard.

Contract_Class

String

False

The Contract_Class column for the table ResourceCard.

County

String

False

The County column for the table ResourceCard.

Direct_Unit_Cost

Decimal

False

The Direct_Unit_Cost column for the table ResourceCard.

Education

String

False

The Education column for the table ResourceCard.

Employment_Date

Datetime

False

The Employment_Date column for the table ResourceCard.

ETag

String

False

The ETag column for the table ResourceCard.

Gen_Prod_Posting_Group

String

False

The Gen_Prod_Posting_Group column for the table ResourceCard.

IC_Partner_Purch_G_L_Acc_No

String

False

The IC_Partner_Purch_G_L_Acc_No column for the table ResourceCard.

Indirect_Cost_Percent

Decimal

False

The Indirect_Cost_Percent column for the table ResourceCard.

Job_Title

String

False

The Job_Title column for the table ResourceCard.

Last_Date_Modified

Datetime

False

The Last_Date_Modified column for the table ResourceCard.

Name

String

False

The Name column for the table ResourceCard.

Post_Code

String

False

The Post_Code column for the table ResourceCard.

Price_Profit_Calculation

String

False

The Price_Profit_Calculation column for the table ResourceCard.

Profit_Percent

Decimal

False

The Profit_Percent column for the table ResourceCard.

Resource_Group_No

String

False

The Resource_Group_No column for the table ResourceCard.

Search_Name

String

False

The Search_Name column for the table ResourceCard.

Social_Security_No

String

False

The Social_Security_No column for the table ResourceCard.

Tax_Group_Code

String

False

The Tax_Group_Code column for the table ResourceCard.

Time_Sheet_Approver_User_ID

String

False

The Time_Sheet_Approver_User_ID column for the table ResourceCard.

Time_Sheet_Owner_User_ID

String

False

The Time_Sheet_Owner_User_ID column for the table ResourceCard.

Type

String

False

The Type column for the table ResourceCard.

Unit_Cost

Decimal

False

The Unit_Cost column for the table ResourceCard.

Unit_Price

Decimal

False

The Unit_Price column for the table ResourceCard.

Use_Time_Sheet

Boolean

False

The Use_Time_Sheet column for the table ResourceCard.

VAT_Prod_Posting_Group

String

False

The VAT_Prod_Posting_Group column for the table ResourceCard.

LinkedGen_Prod_Posting_Group_Link

String

False

The LinkedGen_Prod_Posting_Group_Link column for the table ResourceCard.

Name

Type

ReadOnly

Description

Document_No [KEY]

String

False

The Document_No column for the table SalesOrder.

Document_Type [KEY]

String

False

The Document_Type column for the table SalesOrder.

Line_No [KEY]

Int32

False

The Line_No column for the table SalesOrder.

Amount

Decimal

False

The Amount column for the table SalesOrder.

Currency_Code

String

False

The Currency_Code column for the table SalesOrder.

Description

String

False

The Description column for the table SalesOrder.

ETag

String

False

The ETag column for the table SalesOrder.

Line_Discount_Percent

Decimal

False

The Line_Discount_Percent column for the table SalesOrder.

No

String

False

The No column for the table SalesOrder.

Outstanding_Quantity

Decimal

False

The Outstanding_Quantity column for the table SalesOrder.

Quantity

Decimal

False

The Quantity column for the table SalesOrder.

Sell_to_Customer_No

String

False

The Sell_to_Customer_No column for the table SalesOrder.

Shipment_Date

Datetime

False

The Shipment_Date column for the table SalesOrder.

Type

String

False

The Type column for the table SalesOrder.

Unit_of_Measure_Code

String

False

The Unit_of_Measure_Code column for the table SalesOrder.

Unit_Price

Decimal

False

The Unit_Price column for the table SalesOrder.

Work_Type_Code

String

False

The Work_Type_Code column for the table SalesOrder.

LinkedCurrency_Code_Link

String

False

The LinkedCurrency_Code_Link column for the table SalesOrder.