Edit

Share via

Tax calculation data model

  • Article

This article provides information about how the field values in the tax data model are determined in tax calculation transactions.

The tax data model is made up of fields that are required for tax calculations. Microsoft provides the tax calculation data model, which includes the header fields and line fields of transaction documents in finance and operations apps. The fields that are defined in the tax calculation data model are the available columns of the applicability rules tables in the configuration of the tax calculation feature configuration.

Note

Some nodes that are defined in the data model, such as Record ID and Table ID, are for technical purposes. They aren't available columns in the tax calculation feature configuration.

Follow these steps to view the tax calculation data model.

Note

The functionality of Regulatory Configuration Service (RCS) is merged to the Globalization Studio workspace in Microsoft Dynamics 365 Finance in version 10.0.39. For more information, see Regulatory Configuration Service merge to the Globalization Studio workspace.

If you're using version 10.0.39 or later, use the Globalization Studio workspace in Finance instead of RCS.

  1. Follow one of these steps, depending on where you're completing the procedure:

    • In RCS, select Electronic reporting > Tax configurations.
    • In Finance, open the Globalization Studio workspace, and select Electronic reporting > Tax configurations.

  2. Select Tax Data Model > Tax Calculation Data Model.

  3. On the Versions FastTab, select a version.

  4. Select Designer.

    Designer button.

  5. Expand the Tax Calculation node.

  6. Expand the Header node to view the header data models.

  7. Expand the Lines node to view the line data models.

    Data models.

You can also view the tax calculation data model and the available columns in the applicability rules table.

  1. Follow one of these steps, depending on where you're completing the procedure:

    • In RCS, open the Globalization features workspace, select Features, and then select the Tax Calculation tile.
    • In Finance, open the Globalization Studio workspace, select Globalization services, and then select the Tax Calculation tile.

  2. On the Tax calculation features page, find a tax feature that has a status of Draft, and then select Edit.

  3. On the General tab, select the configuration version, based on the version of the tax calculation data model. For example, select 40.46.212.

  4. On the Tax group applicability tab, select Manage columns.

    Manage columns.

The tax calculation data model is integrated with finance and operations apps. During each transaction that is related to tax calculation, the values of the fields that is defined in the applicability rules tables are collected and sent to the tax calculation. In version 40.46, 57 predefined data models are available for the following transaction types: purchase orders, sales orders, transfer orders, purchase requisitions, requests for quotation, and sales quotations.

Version updates and restrictions

  • Free text invoice: Supported as of version 40.50.221 and Finance version 10.0.23.

  • General journals: Supported as of version 40.54.234 and Finance version 10.0.26.

    Restriction: One voucher and payment fee aren't supported.

  • Vendor invoice journal: Supported as of version 40.54.234 and Finance version 10.0.26.

  • Periodic journals: Supported as of version 40.55.236 and Finance version 10.0.29.

Field mapping

Thirty-two data models can be included as fields on the header of a transaction. However, not all fields are applicable to all transaction types. The following table shows which header fields are available for specific transaction types. In some cases, the field mapping must be determined by predefined logic. Where applicable, the logic is provided.

Header field Business transaction type and field mapping
Amount include tax
  • Sales order: Prices include sales tax
  • Purchase order: Prices include sales tax
  • Purchase requisition: No
  • Request for quotation: Prices include sales tax
  • Sales quotation: Prices include sales tax
  • Free text invoice: Prices include sales tax
  • Journal: Amounts include sales tax
Business process
  • Sales order: Sales
  • Purchase order: Purchase
  • Transfer order - Ship: Inventory
  • Transfer order - Receive: Inventory
  • Purchase requisition: Purchase
  • Request for quotation: Purchase
  • Sales quotation: Sales
  • Free text invoice: FTI
  • Journal: Journal
Currency
  • Sales order: Transaction currency
  • Purchase order: Transaction currency
  • Transfer order - Ship: Accounting currency
  • Transfer order - Receive: Accounting currency
  • Purchase requisition: Transaction currency
  • Free text invoice: Transaction currency
  • Journal: Currency
Customer account
  • Sales order: Customer account
  • Sales quotation: Customer account
  • Free text invoice: Customer account
  • Journal (customer): Customer account
Customer account group
  • Sales order: Customer account group
  • Sales quotation: Customer account group
  • Free text invoice: Customer account group
  • Journal (customer): Customer account group
Customer invoice account
  • Sales order: Invoice account
  • Sales quotation: Invoice account
  • Free text invoice: Invoice account
  • Journal (customer):
    1. Customer master > Invoice account
    2. Customer account
Customer invoice account group
  • Sales order: Invoice account group
  • Sales quotation: Invoice account group
  • Free text invoice: Invoice account group
  • Journal (customer):
    1. Customer master > Invoice account group
    2. Customer account group
Customer tax registration country/region
  • Sales order: Customer VAT ID country/region
  • Sales quotation: Customer VAT ID country/region
  • Free text invoice: Customer VAT ID country/region
  • Journal (customer): Customer VAT ID country/region
Customer tax registration number
  • Sales order: Tax exempt number (registration category VAT ID)
  • Sales quotation: Tax exempt number (registration category VAT ID)
  • Free text invoice: Tax exempt number (registration category VAT ID)
  • Journal (customer): Tax exempt number (registration category VAT ID)
Delivery term
  • Sales order: Delivery terms
  • Purchase order: Delivery terms
  • Transfer order - Ship: Delivery terms
  • Transfer order - Receive: Delivery terms
  • Request for quotation: Delivery terms
  • Sales quotation: Delivery terms
  • Free text invoice: Delivery terms
Direct delivery
  • Sales order: Line details > Direct delivery
  • Purchase order: Direct delivery
Intercompany direct delivery
  • Sales order: Header > Intercompany settings > Direct delivery
Invoice from city
  • Sales order:
    1. Legal entity > Default invoice address > City
    2. Legal entity > Primary address > City
  • Purchase order:
    1. Header > Invoice account > Default invoice address > City
    2. Header > Invoice account > Primary address > City
  • Sales quotation:
    1. Legal entity > Default invoice address > City
    2. Legal entity > Primary address > City
  • Free text invoice:
    1. Legal entity > Default invoice address > City
    2. Legal entity > Primary address > City
  • Journal (customer):
    1. Legal entity > Default invoice address > City
    2. Legal entity > Primary address > City
  • Journal (vendor):
    1. Vendor invoice account > Default invoice address > City
    2. Vendor invoice account > Primary address > City
    3. Vendor account > Default invoice address > City
    4. Vendor account > Primary address > City
Invoice from country/region
  • Sales order:
    1. Legal entity > Default invoice address > Country/region
    2. Legal entity > Primary address > Country/region
  • Purchase order:
    1. Header > Invoice account > Default invoice address > Country/region
    2. Header > Invoice account > Primary address > Country/region
  • Sales quotation:
    1. Legal entity > Default invoice address > Country/region
    2. Legal entity > Primary address > Country/region
  • Free text invoice:
    1. Legal entity > Default invoice address > Country/region
    2. Legal entity > Primary address > Country/region
  • Journal (customer):
    1. Legal entity > Default invoice address > Country/region
    2. Legal entity > Primary address > Country/region
  • Journal (vendor):
    1. Vendor invoice account > Default invoice address > Country/region
    2. Vendor invoice account > Primary address > Country/region
    3. Vendor account > Default invoice address > Country/region
    4. Vendor account > Primary address > Country/region
Invoice from country/region type
  • If the Invoice from country/region and Invoice to country/region fields have the same value, the type is Domestic.
  • The mapping is determined by the configuration on the Country/region properties tab of the Foreign trade parameters page (Tax > Setup > Foreign trade > Foreign trade parameters), based on the value of the Invoice from country/region field.
  • Not applicable to Purchase requisition or Request for quotation.
Invoice from province/state
  • Sales order:
    1. Legal entity > Default invoice address > State
    2. Legal entity > Primary address > State
  • Purchase order:
    1. Header > Invoice account > Default invoice address > State
    2. Header > Invoice account > Primary address > State
  • Sales quotation:
    1. Legal entity > Default invoice address > State
    2. Legal entity > Primary address > State
  • Free text invoice:
    1. Legal entity > Default invoice address > State
    2. Legal entity > Primary address > State
  • Journal (customer):
    1. Legal entity > Default invoice address > State
    2. Legal entity > Primary address > State
  • Journal (vendor):
    1. Vendor invoice account > Default invoice address > State
    2. Vendor invoice account > Primary address > State
    3. Vendor account > Default invoice address > State
    4. Vendor account > Primary address > State
Invoice from zip code
  • Sales order:
    1. Legal entity > Default invoice address > ZIP/postal code
    2. Legal entity > Primary address > ZIP/postal code
  • Purchase order:
    1. Header > Invoice account > Default invoice address > ZIP/postal code
    2. Header > Invoice account > Primary address > ZIP/postal code
  • Sales quotation:
    1. Legal entity > Default invoice address > ZIP/postal code
    2. Legal entity > Primary address > ZIP/postal code
  • Free text invoice:
    1. Legal entity > Default invoice address > ZIP/postal code
    2. Legal entity > Primary address > ZIP/postal code
  • Journal (customer):
    1. Legal entity > Default invoice address > ZIP/postal code
    2. Legal entity > Primary address > ZIP/postal code
  • Journal (vendor):
    1. Vendor invoice account > Default invoice address > ZIP/postal code
    2. Vendor invoice account > Primary address > ZIP/postal code
    3. Vendor account > Default invoice address > ZIP/postal code
    4. Vendor account > Primary address > ZIP/postal code
Invoice to city
  • Sales order:
    1. Header > Invoice account > Default invoice address > City
    2. Header > Invoice account > Primary address > City
  • Purchase order:
    1. Legal entity > Default invoice address > City
    2. Legal entity > Primary address > City
  • Sales quotation:
    1. Header > Invoice account > Default invoice address > City
    2. Header > Invoice account > Primary address > City
  • Free text invoice:
    1. Header > Invoice address > City
    2. Header > Invoice account > Default invoice address > City
    3. Header > Invoice account > Primary address > City
  • Journal (customer):
    1. Customer invoice account > Default invoice address > City
    2. Customer invoice account > Primary address > City
    3. Customer account > Default invoice address > City
    4. Customer account > Primary address > City
  • Journal (vendor):
    1. Legal entity > Default invoice address > City
    2. Legal entity > Primary address > City
Invoice to country/region
  • Sales order:
    1. Header > Invoice account > Default invoice address > Country/region
    2. Header > Invoice account > Primary address > Country/region
  • Purchase order:
    1. Legal entity > Default invoice address > Country/region
    2. Legal entity > Primary address > Country/region
  • Sales quotation:
    1. Header > Invoice account > Default invoice address > Country/region
    2. Header > Invoice account > Primary address > Country/region
  • Free text invoice:
    1. Header > Invoice address > Country/region
    2. Header > Invoice account > Default invoice address > Country/region
    3. Header > Invoice account > Primary address > Country/region
  • Journal (customer):
    1. Customer invoice account > Default invoice address > Country/region
    2. Customer invoice account > Primary address > Country/region
    3. Customer account > Default invoice address > Country/region
    4. Customer account > Primary address > Country/region
  • Journal (vendor):
    1. Legal entity > Default invoice address > Country/region
    2. Legal entity > Primary address > Country/region
Invoice to country/region type
  • If the Invoice from country/region and Invoice to country/region fields have the same value, the type is Domestic.
  • The mapping is determined by the configuration on the Country/region properties tab of the Foreign trade parameters page (Tax > Setup > Foreign trade > Foreign trade parameters), based on the value of the Invoice to country/region field.
  • Not applicable to Purchase requisition or Request for quotation.
Invoice to province/state
  • Sales order:
    1. Header > Invoice account > Default invoice address > State
    2. Header > Invoice account > Primary address > State
  • Purchase order:
    1. Legal entity > Default invoice address > State
    2. Legal entity > Primary address > State
  • Sales quotation:
    1. Header > Invoice account > Default invoice address > State
    2. Header > Invoice account > Primary address > State
  • Free text invoice:
    1. Header > Invoice address > State
    2. Header > Invoice account > Default invoice address > State
    3. Header > Invoice account > Primary address > State
  • Journal (customer):
    1. Customer invoice account > Default invoice address > State
    2. Customer invoice account > Primary address > State
    3. Customer account > Default invoice address > State
    4. Customer account > Primary address > State
  • Journal (vendor):
    1. Legal entity > Default invoice address > State
    2. Legal entity > Primary address > State
Invoice to zip code
  • Sales order:
    1. Header > Invoice account > Default invoice address > ZIP/postal code
    2. Header > Invoice account > Primary address > ZIP/postal code
  • Purchase order:
    1. Legal entity > Default invoice address > ZIP/postal code
    2. Legal entity > Primary address > ZIP/postal code
  • Sales quotation:
    1. Header > Invoice account > Default invoice address > ZIP/postal code
    2. Header > Invoice account > Primary address > ZIP/postal code
  • Free text invoice:
    1. Header > Invoice address > ZIP/postal code
    2. Header > Invoice account > Default invoice address > ZIP/postal code
    3. Header > Invoice account > Primary address > ZIP/postal code
  • Journal (customer):
    1. Customer invoice account > Default invoice address > ZIP/postal code
    2. Customer invoice account > Primary address > ZIP/postal code
    3. Customer account > Default invoice address > ZIP/postal code
    4. Customer account > Primary address > ZIP/postal code
  • Journal (vendor):
    1. Legal entity > Default invoice address > ZIP/postal code
    2. Legal entity > Primary address > ZIP/postal code
Is prepayment journal voucher
  • Journal: From the Prepayment journal voucher field on the Customer or Vendor line
Journal name
  • Journal: Name
Order type
  • Sales order: Order type
  • Purchase order: Order type
Ship from city
  • Sales order:
    1. Header > Warehouse > Primary address > City
    2. Header > Site > Primary address > City
    3. Legal entity > Default delivery address > Country/region
    4. Legal entity > Primary address > Country/region
  • Purchase order:
    1. Transportation details > Loading address > City
    2. Header > Vendor account > Default delivery address > City
    3. Header > Vendor account > Primary address > City
  • Transfer order - Ship:
    1. Header > From warehouse > Primary address > City
    2. Header > From site > Primary address > City
  • Transfer order - Receive:
    1. Header > From warehouse > Primary address > City
    2. Header > From site > Primary address > City
  • Request for quotation:
    1. Header > Vendor account > Default delivery address > City
    2. Header > Vendor account > Primary address > City
  • Sales quotation:
    1. Header > Warehouse > Primary address > City
    2. Header > Site > Primary address > City
    3. Legal entity > Default delivery address > City
    4. Legal entity > Primary address > City
  • Free text invoice:
    1. Transportation details > Loading address > City
    2. Legal entity > Default delivery address > City
    3. Legal entity > Primary address > City
  • Journal (customer):
    1. Legal entity > Default delivery address > City
    2. Legal entity > Primary address > City
  • Journal (vendor):
    1. Vendor account > Default delivery address > City
    2. Vendor account > Primary address > City
Ship from country/region
  • Sales order:
    1. Header > Warehouse > Primary address > Country/region
    2. Header > Site > Primary address > Country/region
    3. Legal entity > Default delivery address > Country/region
    4. Legal entity > Primary address > Country/region
  • Purchase order:
    1. Transportation details > Loading address > Country/region
    2. Header > Vendor account > Default delivery address > Country/region
    3. Header > Vendor account > Primary address > Country/region
  • Transfer order - Ship:
    1. Header > From warehouse > Primary address > Country/region
    2. Header > From site > Primary address > Country/region
  • Transfer order - Receive:
    1. Header > From warehouse > Primary address > Country/region
    2. Header > From site > Primary address > Country/region
  • Request for quotation:
    1. Header > Vendor account > Default delivery address > Country/region
    2. Header > Vendor account > Primary address > Country/region
  • Sales quotation:
    1. Header > Warehouse > Primary address > Country/region
    2. Header > Site > Primary address > Country/region
    3. Legal entity > Default delivery address > Country/region
    4. Legal entity > Primary address > Country/region
  • Free text invoice:
    1. Transportation details > Loading address > Country/region
    2. Legal entity > Default delivery address > Country/region
    3. Legal entity > Primary address > Country/region
  • Journal (customer):
    1. Legal entity > Default delivery address > Country/region
    2. Legal entity > Primary address > Country/region
  • Journal (vendor):
    1. Vendor account > Default delivery address > Country/region
    2. Vendor account > Primary address > Country/region
Ship from country/region type
  • If the Ship from country/region and Ship to country/region fields have the same value, the type is Domestic.
  • The mapping is determined by the configuration on the Country/region properties tab of the Foreign trade parameters page (Tax > Setup > Foreign trade > Foreign trade parameters), based on the value of the Ship from country/region field.
  • Not applicable to Purchase requisition.
Ship from province/state
  • Sales order:
    1. Header > Warehouse > Primary address > State
    2. Header > Site > Primary address > State
    3. Legal entity > Default delivery address > State
    4. Legal entity > Primary address > State
  • Purchase order:
    1. Transportation details > Loading address > State
    2. Header > Vendor account > Default delivery address > State
    3. Header > Vendor account > Primary address > State
  • Transfer order - Ship:
    1. Header > From warehouse > Primary address > State
    2. Header > From site > Primary address > state
  • Transfer order - Receive:
    1. Header > From warehouse > Primary address > State
    2. Header > From site > Primary address > State
  • Request for quotation:
    1. Header > Vendor account > Default delivery address > State
    2. Header > Vendor account > Primary address > State
  • Sales quotation:
    1. Header > Warehouse > Primary address > State
    2. Header > Site > Primary address > State
    3. Legal entity > Default delivery address > State
    4. Legal entity > Primary address > State
  • Free text invoice:
    1. Transportation details > Loading address > State
    2. Legal entity > Default delivery address > State
    3. Legal entity > Primary address > State
  • Journal (customer):
    1. Legal entity > Default delivery address > State
    2. Legal entity > Primary address > State
  • Journal (vendor):
    1. Vendor account > Default delivery address > State
    2. Vendor account > Primary address > State
Ship from zip code
  • Sales order:
    1. Header > Warehouse > Primary address > ZIP/postal code
    2. Header > Site > Primary address > ZIP/postal code
    3. Legal entity > Default delivery address > ZIP/postal code
    4. Legal entity > Primary address > ZIP/postal code
  • Purchase order:
    1. Transportation details > Loading address > ZIP/postal code
    2. Header > Vendor account > Default delivery address > ZIP/postal code
    3. Header > Vendor account > Primary address > ZIP/postal code
  • Transfer order - Ship:
    1. Header > From warehouse > Primary address > ZIP/postal code
    2. Header > From site > Primary address > ZIP/postal code
  • Transfer order - Receive:
    1. Header > From warehouse > Primary address > ZIP/postal code
    2. Header > From site > Primary address > ZIP/postal code
  • Request for quotation:
    1. Header > Vendor account > Default delivery address > ZIP/postal code
    2. Header > Vendor account > Primary address > ZIP/postal code
  • Sales quotation:
    1. Header > Warehouse > Primary address > ZIP/postal code
    2. Header > Site > Primary address > ZIP/postal code
    3. Legal entity > Default delivery address > ZIP/postal code
    4. Legal entity > Primary address > ZIP/postal code
  • Free text invoice:
    1. Transportation details > Loading address > ZIP/postal code
    2. Legal entity > Default delivery address > ZIP/postal code
    3. Legal entity > Primary address > ZIP/postal code
  • Journal (customer):
    1. Legal entity > Default delivery address > ZIP/postal code
    2. Legal entity > Primary address > ZIP/postal code
  • Journal (vendor):
    1. Vendor account > Default delivery address > ZIP/postal code
    2. Vendor account > Primary address > ZIP/postal code
Ship to city
  • Sales order:
    1. Header > Delivery address > City
  • Purchase order:
    1. Header > Delivery address > City
  • Transfer order - Ship:
    1. Header > To warehouse > Primary address > City
    2. Header > To site > Primary address > City
  • Transfer order - Receive:
    1. Header > To warehouse > Primary address > City
    2. Header > To site > Primary address > City
  • Request for quotation:
    1. Header > Delivery address > City
  • Sales quotation:
    1. Header > Delivery address > City
  • Free text invoice:
    1. Header > Customer account > Default delivery address > City
    2. Header > Customer account > Primary address > City
  • Journal (customer):
    1. Customer account > Default delivery address > City
    2. Customer account > Primary address > City
  • Journal (vendor):
    1. Legal entity > Default delivery address > City
    2. Legal entity > Primary address > City
Ship to country/region
  • Sales order:
    1. Header > Delivery address > Country/region
  • Purchase order:
    1. Header > Delivery address > Country/region
  • Transfer order - Ship:
    1. Header > To warehouse > Primary address > Country/region
    2. Header > To site > Primary address > Country/region
  • Transfer order - Receive:
    1. Header > To warehouse > Primary address > Country/region
    2. Header > To site > Primary address > Country/region
  • Request for quotation:
    1. Header > Delivery address > Country/region
  • Sales quotation:
    1. Header > Delivery address > Country/region
  • Free text invoice:
    1. Header > Customer account > Default delivery address > Country/region
    2. Header > Customer account > Primary address > Country/region
  • Journal (customer):
    1. Customer account > Default delivery address > Country/region
    2. Customer account > Primary address > Country/region
  • Journal (vendor):
    1. Legal entity > Default delivery address > Country/region
    2. Legal entity > Primary address > Country/region
Ship to country/region type
  • If the Ship from country/region and Ship to country/region fields have the same value, the type is Domestic.
  • The mapping is determined by the configuration on the Country/region properties tab of the Foreign trade parameters page (Tax > Setup > Foreign trade > Foreign trade parameters), based on the value of the Ship to country/region field.
  • Not applicable to Purchase requisition.
Ship to province/state
  • Sales order:
    1. Header > Delivery address > State
  • Purchase order:
    1. Header > Delivery address > State
  • Transfer order - Ship:
    1. Header > To warehouse > Primary address > State
    2. Header > To site > Primary address > State
  • Transfer order - Receive:
    1. Header > To warehouse > Primary address > State
    2. Header > To site > Primary address > State
  • Request for quotation:
    1. Header > Delivery address > State
  • Sales quotation:
    1. Header > Delivery address > state
  • Free text invoice:
    1. Header > Customer account > Default delivery address > State
    2. Header > Customer account > Primary address > State
  • Journal (customer):
    1. Customer account > Default delivery address > State
    2. Customer account > Primary address > State
  • Journal (vendor):
    1. Legal entity > Default delivery address > State
    2. Legal entity > Primary address > State
Ship to zip code
  • Sales order:
    1. Header > Delivery address > ZIP/postal code
  • Purchase order:
    1. Header > Delivery address > ZIP/postal code
  • Transfer order - Ship:
    1. Header > To warehouse > Primary address > ZIP/postal code
    2. Header > To site > Primary address > ZIP/postal code
  • Transfer order - Receive:
    1. Header > To warehouse > Primary address > ZIP/postal code
    2. Header > To site > Primary address > ZIP/postal code
  • Request for quotation:
    1. Header > Delivery address > ZIP/postal code
  • Sales quotation:
    1. Header > Delivery address > ZIP/postal code
  • Free text invoice:
    1. Header > Customer account > Default delivery address > ZIP/postal code
    2. Header > Customer account > Primary address > ZIP/postal code
  • Journal (customer):
    1. Customer account > Default delivery address > ZIP/postal code
    2. Customer account > Primary address > ZIP/postal code
  • Journal (vendor):
    1. Legal entity > Default delivery address > ZIP/postal code
    2. Legal entity > Primary address > ZIP/postal code
Site
  • Sales order: Site
  • Purchase order: Site
  • Transfer order - Ship: Site of the From warehouse
  • Transfer order - Receive: Site of the To warehouse
  • Request for quotation: Site
  • Sales quotation: Site
Tax direction
  • Sales order: Output
  • Purchase order: Input
  • Transfer order - Ship: Output
  • Transfer order - Receive: Input
  • Purchase requisition: Input
  • Request for quotation: Input
  • Sales quotation: Output
  • Free text invoice: Output
  • Journal: Output
Vendor account
  • Purchase order: Vendor account
  • Journal (vendor): Vendor account
Vendor account group
  • Purchase order: Vendor account group
  • Journal (vendor): Vendor account group
Vendor invoice account
  • Purchase order: Invoice account
  • Journal (vendor):
    1. Vendor master > Invoice account
    2. Vendor account
Vendor invoice account group
  • Purchase order: Invoice account group
  • Journal (vendor):
    1. Vendor master > Invoice account group
    2. Vendor account group
Vendor tax registration country/region
  • Purchase order: Vendor VAT ID country/region
  • Journal (vendor): Vendor VAT ID country/region
Vendor tax registration number
  • Purchase order: Tax exempt number (registration category VAT ID)
  • Journal (vendor): Tax exempt number (registration category VAT ID)
Warehouse
  • Sales order: Warehouse
  • Purchase order: Warehouse
  • Transfer order - Ship: From warehouse
  • Transfer order - Receive: To warehouse
  • Request for quotation: Warehouse
  • Sales quotation: Warehouse

Twenty-six data models are included as fields on the lines of a transaction. As for the header fields, not all fields are applicable to all transaction types. The following table shows which line fields are available for specific transaction types. In some cases, the field mapping must be determined by predefined logic. Where applicable, the logic is provided.

Line field Business transaction type and mapping
Amount
  • Sales order: Net amount
  • Purchase order: Net amount
  • Transfer order - Slip: Amount
  • Transfer order - Receive: Amount
  • Purchase requisition: Net amount
  • Request for quotation: Net amount
  • Sales quotation: Net amount
  • Free text invoice: Net amount
  • Journal: Debit/Credit
Category name
  • Sales order: Sales category
  • Purchase order: Procurement category
  • Purchase requisition: Procurement category
  • Request for quotation: Procurement category
  • Sales quotation: Sales category
Charges code
  • Sales order: Charges code
  • Purchase order: Charges code
  • Purchase requisition: Charges code
  • Request for quotation: Charges code
  • Sales quotation: Charges code
  • Free text invoice: Charges code
Commodity code
  • Sales order: Line > Foreign trade > Commodity
  • Purchase order: Line > Foreign trade > Commodity
  • Transfer order - Ship: Line > Foreign trade > Commodity
  • Transfer order - Receive: Line > Foreign trade > Commodity
  • Sales quotation: Line > Foreign trade > Commodity
  • Free text invoice: Line > Foreign trade > Commodity
Cost amount
  • Sales order: The cost price of the item in inventory
  • Sales quotation: The cost price of the item in inventory
Delivery term
  • Sales order: Delivery terms
  • Request for quotation: Delivery terms
  • Sales quotation: Delivery terms
Direct delivery
  • Sales order: Direct delivery
  • Purchase order: Direct delivery
Item code
  • Sales order: Item number
  • Purchase order: Item number
  • Transfer order - Ship: Item number
  • Transfer order - Receive: Item number
  • Purchase requisition: Item number
  • Request for quotation: Item number
  • Sales quotation: Item number
Item group
  • Sales order: Item group of the item
  • Purchase order: Item group of the item
  • Transfer order - Ship: Item group of the item
  • Transfer order - Receive: Item group of the item
  • Purchase requisition: Item group of the item
  • Request for quotation: Item group of the item
  • Sales quotation: Item group of the item
Item type
  • Sales order: The Product type of the Item code
  • Purchase order: The Product type of the Item code
  • Transfer order - Ship: The Product type of the Item code
  • Transfer order - Receive: The Product type of the Item code
  • Purchase requisition: The Product type of the Item code
  • Request for quotation: The Product type of the Item code
  • Sales quotation: The Product type of the Item code
Line type
  • Sales order: The type of the current line. Options include header charge, line charge, and normal order line.
  • Purchase order: The type of the current line. Options include header charge, line charge, and normal order line.
  • Transfer order - Ship: Normal
  • Transfer order - receive: Normal
  • Purchase requisition: The type of the current line. Options include header charge, line charge, and normal order line.
  • Request for quotation: The type of the current line. Options include header charge, line charge, and normal order line.
  • Sales quotation: The type of the current line. Options include header charge, line charge, and normal order line.
  • Free text invoice: The type of the current line. Options include header charge, line charge, and normal order line.
  • Journal: Normal
Quantity
  • Sales order: Quantity
  • Purchase order: Quantity
  • Transfer order - Ship: Quantity
  • Transfer order - Receive: Quantity
  • Purchase requisition: Quantity
  • Request for quotation: Quantity
  • Sales quotation: Quantity
  • Free text invoice: Quantity
Ship from city
  • Sales order:
    1. Header > Warehouse > Primary address > City
    2. Header > Site > Primary address > City
    3. Legal entity > Default delivery address > City
    4. Legal entity > Primary address > City
  • Purchase order:
    1. Transportation details > Loading address > City
    2. Header > Vendor account > Default delivery address > City
    3. Header > Vendor account > Primary address > City
  • Transfer order - Ship:
    1. Header > From warehouse > Primary address > City
    2. Header > From site > Primary address > City
  • Transfer order - Receive:
    1. Header > From warehouse > Primary address > City
    2. Header > From site > Primary address > City
  • Purchase requisition:
    1. Line > Vendor account > Default delivery address > City
    2. Line > Vendor account > Primary address > City
  • Request for quotation:
    1. Header > Vendor account > Default delivery address > City
    2. Header > Vendor account > Primary address > City
  • Sales quotation:
    1. Header > Warehouse > Primary address > City
    2. Header > Site > Primary address > City
    3. Legal entity > Default delivery address > City
    4. Legal entity > Primary address > City
  • Free text invoice:
    1. Transportation details > Loading address > City
    2. Legal entity > Default delivery address > City
    3. Legal entity > Primary address > City
Ship from country/region
  • Sales order:
    1. Line > Warehouse > Primary address > Country/region
    2. Line > Site > Primary address > Country/region
    3. Legal entity > Default delivery address > Country/region
    4. Legal entity > Primary address > Country/region
  • Purchase order:
    1. Transportation details > Loading address > Country/region
    2. Header > Vendor account > Default delivery address > Country/region
    3. Header > Vendor account > Primary address > Country/region
  • Transfer order - Ship:
    1. Header > From warehouse > Primary address > Country/region
    2. Header > From site > Primary address > Country/region
  • Transfer order - Receive:
    1. Header > From warehouse > Primary address > Country/region
    2. Header > From site > Primary address > Country/region
  • Purchase requisition:
    1. Line > Vendor account > Default delivery address > Country/region
    2. Line > Vendor account > Primary address > Country/region
  • Request for quotation:
    1. Header > Vendor account > Default delivery address > Country/region
    2. Header > Vendor account > Primary address > Country/region
  • Sales quotation:
    1. Line > Warehouse > Primary address > Country/region
    2. Line > Site > Primary address > Country/region
    3. Legal entity > Default delivery address > Country/region
    4. Legal entity > Primary address > Country/region
  • Free text invoice:
    1. Transportation details > Loading address > Country/region
    2. Legal entity > Default delivery address > Country/region
    3. Legal entity > Primary address > Country/region
Ship from country/region type
  • If the Ship from country/region and Ship to country/region fields have the same value, the type is Domestic.
  • The mapping is determined by the configuration on the Country/region properties tab of the Foreign trade parameters page (Tax > Setup > Foreign trade > Foreign trade parameters), based on the value of the Ship from country/region field.
  • Not applicable to Purchase requisition or Journal.
Ship from province/state
  • Sales order:
    1. Line > Warehouse > Primary address > State
    2. Line > Site > Primary address > State
    3. Legal entity > Default delivery address > State
    4. Legal entity > Primary address > State
  • Purchase order:
    1. Transportation details > Loading address > State
    2. Header > Vendor account > Default delivery address > State
    3. Header > Vendor account > Primary address > State
  • Transfer order - Ship:
    1. Header > From warehouse > Primary address > State
    2. Header > From site > Primary address > State
  • Transfer order - Receive:
    1. Header > From warehouse > Primary address > State
    2. Header > From site > Primary address > State
  • Purchase requisition:
    1. Line > Vendor account > Default delivery address > State
    2. Header > Vendor account > Primary address > State
  • Request for quotation:
    1. Header > Vendor account > Default delivery address > State
    2. Header > Vendor account > Primary address > State
  • Sales quotation:
    1. Line > Warehouse > Primary address > State
    2. Line > Site > Primary address > State
    3. Legal entity > Default delivery address > State
    4. Legal entity > Primary address > State
  • Free text invoice:
    1. Transportation details > Loading address > State
    2. Legal entity > Default delivery address > State
    3. Legal entity > Primary address > State
Ship from ZIP code
  • Sales order:
    1. Line > Warehouse > Primary address > ZIP/postal code
    2. Line > Site > Primary address > ZIP/postal code
    3. Legal entity > Default delivery address > ZIP/postal code
    4. Legal entity > Primary address > ZIP/postal code
  • Purchase order:
    1. Transportation details > Loading address > ZIP/postal code
    2. Header > Vendor account > Default delivery address > ZIP/postal code
    3. Header > Vendor account > Primary address > ZIP/postal code
  • Transfer order - Ship:
    1. Header > From warehouse > Primary address > ZIP/postal code
    2. Header > From site > Primary address > ZIP/postal code
  • Transfer order - Receive:
    1. Header > From warehouse > Primary address > ZIP/postal code
    2. Header > From site > Primary address > ZIP/postal code
  • Purchase requisition:
    1. Line > Vendor account > Default delivery address > ZIP/postal code
    2. Header > Vendor account > Primary address > ZIP/postal code
  • Request for quotation:
    1. Header > Vendor account > Default delivery address > ZIP/postal code
    2. Header > Vendor account > Primary address > ZIP/postal code
  • Sales quotation:
    1. Line > Warehouse > Primary address > ZIP/postal code
    2. Line > Site > Primary address > ZIP/postal code
    3. Legal entity > Default delivery address > ZIP/postal code
    4. Legal entity > Primary address > ZIP/postal code
  • Free text invoice:
    1. Transportation details > Loading address > ZIP/postal code
    2. Legal entity > Default delivery address > ZIP/postal code
    3. Legal entity > Primary address > ZIP/postal code
Ship to city
  • Sales order:
    1. Line > Delivery address > City
  • Purchase order:
    1. Line > Delivery address > City
    2. Header > Delivery address > City
  • Transfer order - Ship:
    1. Header > To warehouse > Primary address > City
    2. Header > To site > Primary address > City
  • Transfer order - Receive:
    1. Header > To warehouse > Primary address > City
    2. Header > To site > Primary address > City
  • Purchase requisition:
    1. Line > Delivery address > City
  • Request for quotation:
    1. Line > Delivery address > City
  • Sales quotation:
    1. Line > Delivery address > City
Ship to country/region
  • Sales order:
    1. Line > Delivery address > Country/region
  • Purchase order:
    1. Line > Delivery address > Country/region
    2. Header > Delivery address > Country/region
  • Transfer order - Ship:
    1. Header > To warehouse > Primary address > Country/region
    2. Header > To site > Primary address > Country/region
  • Transfer order - Receive:
    1. Header > To warehouse > Primary address > Country/region
    2. Header > To site > Primary address > Country/region
  • Purchase requisition:
    1. Line > Delivery address > Country/region
  • Request for quotation:
    1. Line > Delivery address > Country/region
  • Sales quotation:
    1. Line > Delivery address > Country/region
Ship to country/region type
  • If the Ship from country/region and Ship to country/region fields have the same value, the type is Domestic.
  • The mapping is determined by the configuration on the Country/region properties tab of the Foreign trade parameters page (Tax > Setup > Foreign trade > Foreign trade parameters), based on the value of the Ship to country/region field.
  • Not applicable to Purchase requisition or Journal.
Ship to province/state
  • Sales order:
    1. Line > Delivery address > State
  • Purchase order:
    1. Line > Delivery address > State
    2. Header > Delivery address > State
  • Transfer order - Ship:
    1. Header > To warehouse > Primary address > ZIP/postal code
    2. Header > To site > Primary address > ZIP/postal code
  • Transfer order - Receive:
    1. Header > To warehouse > Primary address > State
    2. Header > To site > Primary address > State
  • Purchase requisition:
    1. Line > Delivery address > State
  • Request for quotation:
    1. Line > Delivery address > State
  • Sales quotation:
    1. Line > Delivery address > State
Ship to ZIP code
  • Sales order:
    1. Line > Delivery address > ZIP/postal code
  • Purchase order:
    1. Line > Delivery address > ZIP/postal code
    2. Header > Delivery address > ZIP/postal code
  • Transfer order - Ship:
    1. Header > To warehouse > Primary address > ZIP/postal code
    2. Header > To site > Primary address > ZIP/postal code
  • Transfer order - Receive:
    1. Header > To warehouse > Primary address > ZIP/postal code
    2. Header > To site > Primary address > ZIP/postal code
  • Purchase requisition:
    1. Line > Delivery address > ZIP/postal code
  • Request for quotation:
    1. Line > Delivery address > ZIP/postal code
  • Sales quotation:
    1. Line > Delivery address > ZIP/postal code
Site
  • Sales order:
    1. Line > Site
    2. Product > Site
  • Purchase order:
    1. Line > Site
    2. Product > Site
  • Transfer order - Ship: The Site that is selected for the From warehouse on the line
  • Transfer order - receive: The Site that is selected for the From warehouse on the line
  • Purchase requisition: Line > Site
  • Request for quotation: Line > Site
  • Sales quotation:
    1. Line > Site
    2. Product > Site
Transaction date
  • Sales order: The date that is used for tax calculation. The logic follows the configuration of the Calculation date type field on the Sales tax tab of the General ledger parameters page (General ledger > Setup > General ledger parameters). For example, if Delivery date is selected, the date is retrieved by using the following order:
    1. Line confirmed ship date
    2. Header confirmed ship date
    3. Line requested ship date
    4. Header requested ship date

    If the configured calculation date type isn't available in the transaction, the current session date is retrieved instead.

  • Purchase order: The date that is used for tax calculation. The logic follows the configuration of the Calculation date type field on the Sales tax tab of the General ledger parameters page. For example, if Delivery date is selected, the date is retrieved by using the following order:
    1. Line confirmed delivery date
    2. Line delivery date
    3. Header delivery date

    If the configured calculation data type isn't available in the transaction, the current session date is retrieved instead.

  • Transfer order - Ship: The date that is used for tax calculation. The logic follows the configuration of the Calculation date type field on the Sales tax tab of the General ledger parameters page. For example, if Delivery date is selected, the date is retrieved by using the following order:
    1. Ship date
    2. Receipt date
    3. Posting date

    If Invoice date or Document date is selected, the posting date is retrieved.

  • Transfer order - Received: The date that is used for tax calculation. The logic follows the configuration of the Calculation date type field on the Sales tax tab of the General ledger parameters page. For example, if Delivery date is selected, the date is retrieved by using the following order:
    1. Ship date
    2. Receipt date
    3. Posting date

    If Invoice date or Document date is selected, the posting date is retrieved.

  • Purchase requisition: The date that is used for tax calculation. The logic follows the configuration of the Calculation date type field on the Sales tax tab of the General ledger parameters page. If the configured calculation date type isn't available in the transaction, the current session date is retrieved instead.
  • Request for quotation: The date that is used for tax calculation. The logic follows the configuration of the Calculation date type field on the Sales tax tab of the General ledger parameters page. If the configured calculation date type isn't available in the transaction, the current session date is retrieved instead.
  • Sales quotation: The date that is used for tax calculation. The logic follows the configuration of the Calculation date type field on the Sales tax tab of the General ledger parameters page. For example, if Delivery date is selected, the date is retrieved by using the following order:
    1. Line > Attributes > Ship date
    2. Line > Delivery > Requested ship date
    3. Header requested ship date

    If the configured calculation date type isn't available in the transaction, the current session date is retrieved instead.

  • Free text invoice: The date that is used for tax calculation. The logic follows the configuration of the Calculation date type field on the Sales tax tab of the General ledger parameters page. For example, if Delivery date is selected, the date is retrieved by using the following order:
    1. Line confirmed ship date
    2. Header confirmed ship date
    3. Line requested ship date
    4. Header requested ship date

    If the configured calculation date type isn't available in the transaction, the current session date is retrieved instead.

  • Journal: Date
Unit
  • Sales order: Unit
  • Purchase order: Unit
  • Transfer order - Ship: Unit
  • Transfer order - Receive: Unit
  • Purchase requisition: Unit
  • Request for quotation: Unit
  • Sales quotation: Unit
Variant number
  • Sales order: Variant number
  • Purchase order: Variant number
  • Sales quotation: Variant number
Warehouse
  • Sales order:
    1. Line > Warehouse
    2. Product > Warehouse
  • Purchase order:
    1. Line > Warehouse
    2. Product > Warehouse
  • Transfer order - Ship: From warehouse
  • Transfer order - Receive: To warehouse
  • Purchase requisition: Line > Warehouse
  • Request for quotation: Line > Warehouse
  • Sales quotation:
    1. Line > Warehouse
    2. Product > Warehouse