Customer order
These tables show the field mapping information of the fields that you can use to build your customer order IDM template.
Business Class: CustomerOrder
List: CustomerOrderForIDM
| XML field | Description | FSM field |
|---|---|---|
| BillingCompany | Billing Company | Company |
| BillingCompanyAddressLine1 | Billing Company Address Line 1 | Company.CompanyAddress.DeliveryAddress.AddressLine1 |
| BillingCompanyAddressLine2 | Billing Company Address Line 2 | Company.CompanyAddress.DeliveryAddress.AddressLine2 |
| BillingCompanyAddressLine3 | Billing Company Address Line 3 | Company.CompanyAddress.DeliveryAddress.AddressLine3 |
| BillingCompanyAddressLine4 | Billing Company Address Line 4 | Company.CompanyAddress.DeliveryAddress.AddressLine4 |
| City | City | Company.CompanyAddress.Municipality |
| State | State | Company.CompanyAddress.StateProvince |
| ZipCode | Zip Code | Company.CompanyAddress.PostalCode |
| CountryCode | Country Code | Company.CompanyAddress.Country |
| OrderNumber | Order Number | CustomerOrder |
| Location | Location | InventoryLocation |
| OrderDate | Order Date | OrderDate |
| ProcessLevel | Process Level | BillingProcessLevel |
| OrderCode | Order Code | OrderEntryOrderType |
| OrderDescription | Order Description | OrderEntryOrderType.Description |
| RequestedDate | Requested Date | RequestedDate |
| Currency | Currency | Currency |
| PaymentTerms | Payment Terms | TermsCode |
| VATNumber | VAT Registration Number | VATRegistrationNumber |
| RemitToName | Remit To Name | Company.RemitToName |
| RemitToDeliveryAddressLine1 | Remit To Delivery Address Line 1 | Company.RemitToAddress.DeliveryAddress.AddressLine1 |
| RemitToDeliveryAddressLine2 | Remit To Delivery Address Line 2 | Company.RemitToAddress.DeliveryAddress.AddressLine2 |
| RemitToDeliveryAddressLine3 | Remit To Delivery Address Line 3 | Company.RemitToAddress.DeliveryAddress.AddressLine3 |
| RemitToDeliveryAddressLine4 | Remit To Delivery Address Line 4 | Company.RemitToAddress.DeliveryAddress.AddressLine4 |
| RemitToCity | Remit To City | Company.RemitToAddress.Municipality |
| RemitToState | Remit To State | Company.RemitToAddress.StateProvince |
| RemitToZipCode | Remit To Zip Code | Company.RemitToAddress.PostalCode |
| RemitToCountryCode | Remit To Country Code | Company.RemitToAddress.Country |
| CustomerBillToName | Customer Bill To Name | CustomerBillTo.Name |
| CustomerBillToDeliveryAddressLine1 | Customer Bill To Delivery Address Line 1 | CustomerBillTo.PostalAddress.DeliveryAddress.AddressLine1 |
| CustomerBillToDeliveryAddressLine2 | Customer Bill To Delivery Address Line 2 | CustomerBillTo.PostalAddress.DeliveryAddress.AddressLine2 |
| CustomerBillToDeliveryAddressLine3 | Customer Bill To Delivery Address Line 3 | CustomerBillTo.PostalAddress.DeliveryAddress.AddressLine3 |
| CustomerBillToDeliveryAddressLine4 | Customer Bill To Delivery Address Line 4 | CustomerBillTo.PostalAddress.DeliveryAddress.AddressLine4 |
| CustomerBillToCity | Customer Bill To City | CustomerBillTo.PostalAddress.Municipality |
| CustomerBillToState | Customer Bill To State | CustomerBillTo.PostalAddress.StateProvince |
| CustomerBillToZipCode | Customer Bill To Zip Code | CustomerBillTo.PostalAddress.PostalCode |
| CustomerBillToCountryCode | Customer Bill To Country Code | CustomerBillTo.PostalAddress.Country |
| ShipToName | Ship To Name | CustomerShipTo.Name |
| ShipToDeliveryAddressLine1 | Ship To Delivery Address Line 1 | CustomerShipTo.ShipToAddress.DeliveryAddress.AddressLine1 |
| ShipToDeliveryAddressLine2 | Ship To Delivery Address Line 2 | CustomerShipTo.ShipToAddress.DeliveryAddress.AddressLine2 |
| ShipToDeliveryAddressLine3 | Ship To Delivery Address Line 3 | CustomerShipTo.ShipToAddress.DeliveryAddress.AddressLine3 |
| ShipToDeliveryAddressLine4 | Ship To Delivery Address Line 4 | CustomerShipTo.ShipToAddress.DeliveryAddress.AddressLine4 |
| ShipToCity | Ship To City | CustomerShipTo.ShipToAddress.Municipality |
| ShipToState | Ship To State | CustomerShipTo.ShipToAddress.StateProvince |
| ShipToZipCode | Ship To Zip Code | CustomerShipTo.ShipToAddress.PostalCode |
| ShipToCountryCode | Ship To Country Code | CustomerShipTo.ShipToAddress.Country |
| BillingCompanyName | Billing Company Name | Company.Name |
| CustomerName | Customer Name | Customer.Name |
| EmailFrom | Email From | DerivedCustomerOrderFromAndReplyToEmail |
| GoodsAmount | Goods Amount | GoodsAmount |
| FreightCharges | Freight Charges | FreightCharge |
| AddOnCharges | Add On Charges | TotalAddOnChargeAmount |
| OrderGross | Order Gross | OrderGrossBaseAmount |
| DiscountAmount | Discount Amount | DerivedDiscountAmount |
| NetAmount | Net Amount | OriginalOpenOrderAmount |
| Tax | Tax | DerivedTaxTotalBaseAmount |
| NetAmountDue | Net Amount Due | OrderTotalBase |
Business Class: CustomerOrderLine
List: CustomerOrderLineForIDM
| XML field | Description | FSM field |
|---|---|---|
| LineNumber | Line Number | CustomerOrderLine |
| Item | Item | Item |
| Description | Description | ItemDescription |
| Quantity | Quantity | OrderQuantity |
| Price | Price | EnteredPrice |
| UOM | UOM | SellUOM |
| Discount | Discount | DiscountAmountCurrency |
| NetAmount | Net Amount | NetAmountCurrency |
| ExpShipDate | Expected Ship Date | ExpectedShipDate |
Business Class: CustomerOrderAddOnCharge
List: CustomerOrderAddOnChargeForIDM
| XML field | Description | FSM field |
|---|---|---|
| AddOnCharge | Add On Charge | Miscellaneous |
| UnitPrice | Unit Price | DerivedUnitPriceForIDM |
| UnitCost | Unit Cost | DerivedUnitCostForIDM |
| PricePercent | Price Percent | PricePercent |
| CostPercent | Cost Percent | CostPercent |