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.