Tax Calculation Input Parameters

When calling the Tax Calculation process, the calling application must provide the names of the rowsets or temporary tables that the process should use.

Parent Transaction Lines

The calling application must populate the following fields in the parent transaction line:

Field Notes (if applicable)

Tax Calculation Rowset/Table

Name of the Tax Calculation rowset (online) or temporary table (batch).

Business Unit

Refers to the transaction business unit.

Tax Calc Transaction ID

The calling applications can use, for example, the invoice ID.

Tax Calc Transaction Line Number

 

Tax Calc Schedule Line Number

If applicable.

Tax Calc Date

Used for effective date processing.

Transaction Line Amount in Transaction Currency.

 

Transaction Line Amount

In transaction currency.

Standard UOM (unit of measure)

For items, this value is stored in MASTER_ITEM_TBL.UNIT_MEASURE_STD

For products this is the value stored in PROD_UOM.UNIT_OF_MEASURE

For ad hoc Items, this is the transaction unit of measure.

Quantity in Standard UOM (unit of measure)

 

Freight Amount in Transaction Currency

In transaction unit of measure (applicable only to Purchasing and Payables).

Misc Charge Amount in Transaction Currency

In transaction unit of measure (applicable only to Purchasing and Payables).

Rate Type

Same rate type used on the transaction for converting transaction currency into base.

Transaction Currency Code

 

Base Currency Code

 

Rate Mult

Used to convert transaction currency into base currency.

Rate Div

Used to convert transaction currency into base currency.

Tax Applicability Flag

 

Reporting Currency Code

 

Use Assessable Value Flag

 

Tax Detail Lines

For each transaction line, the calling application must populate one or more tax detail lines containing:

Field Notes (if applicable)

Tax Rate Code Sequence Number

 

Tax Component Code

 

Tax Dependency Code

 

Calculation Scheme

Valid values are:

P: percentage.

Q: quantity.

A: ad hoc amount.

Tax Rate Percentage

Used only when the calculation scheme is defined as percentage.

Tax Rate Amount

Used when the calculation scheme is define as ad hoc or quantity.

Tax Rate Currency

 

Tax Rate Unit Of Measure

 

Tax Location Reporting Currency

 

Recovery Percent

 

Tax Calculation Code