Tax Calculation Output Parameters
The tax calculation function returns values for the transaction line parent table and values for child tax detail table.
Transaction Line Parent Table
The Tax Calculation process returns the following values for the transaction line parent table:
| Field | Notes (if applicable) |
|---|---|
|
Quantity |
|
|
Rate Mult |
Used to convert base currency into the tax location reporting currency. |
|
Rate Div |
Used to convert base currency into the tax location reporting currency. |
|
Extended Assessable Value Amount |
In transaction currency. |
|
Extended Assessable Value Amount |
In base currency. |
|
Extended Assessable Value Amount |
In tax location reporting currency. |
|
Tax Calculation Transaction Line Status Code |
Valid values are: 00: Success. 01: Error. Unable to find exchange rate between base currency and tax location currency. 02: Warning. Unable to use assessable value. For example, the assessable value was zero |
Child Tax Detail Table
The Tax Calculation process returns the following values for the child tax detail table:
| Field | Notes (if applicable) |
|---|---|
|
Include Base Flag |
|
|
Include Freight Flag |
|
|
Include Misc Flag |
|
|
Tax Amount |
In transaction currency. |
|
Tax Amount |
In base currency. |
|
Tax Amount |
In tax location reporting currency. |
|
Tax Basis Amount (taxable amount) |
In transaction currency. |
|
Tax Basis Amount (taxable amount) |
In base currency. |
|
Tax Basis Amount (taxable amount) |
In tax location reporting currency. |
|
Recoverable Tax Amount |
In transaction currency. |
|
Recoverable Tax Amount |
In base currency. |
|
Recoverable Tax Amount |
In tax location reporting currency. |
|
Non-recoverable Tax Amount |
In transaction currency. |
|
Non-recoverable Tax Amount |
In base currency. |
|
Non-recoverable Tax Amount |
In tax location reporting currency. |
|
Tax Rate Amount |
In transaction currency. |
|
Tax Rate Amount |
In base currency. |
|
Tax Rate Amount |
In tax location reporting currency. |
|
Tax Calculation Detail Line Status Code |
Valid values are: 00: Success. 01: Error. Unable to find exchange rate between tax rate currency and tax location currency. 02: Error. Unable to find conversion rate between the standard unit of measure and the tax rate unit of measure. 03: Error. Unable to calculate tax when the calculation scheme is defined as quantity. For example, the EXS_QTY_STD field was zero or the EXS_UOM_STD field was blank. |