Sales Tax Rate Interface Program Updates
of AR_TAX_INTERFACE Table
Below is a description of the columns in the tax interface table AR_TAX_INTERFACE that the Sales Tax Rate Interface program updates during execution. All other columns in this table remain unchanged after the initial load from your feeder system. You can review this data by running the Sales Tax Rate Interface report in Review mode.
STATUS
The Sales Tax Rate Interface program populates this column with the action code that it identifies for this record.
LOCATION_
SEGMENT_ID
The Sales Tax Rate Interface program populates this column with the ID of the location associated with this row. This ID column links a location in Receivables to the rows of tax interface data that relate to this location, and is a foreign key to AR_LOCATION_VALUES.LOCATION_SEGMENT_ID.
Note: If you need to reload the tax data for a month that you have previously loaded into the interface tables, you should first null the above two columns to reset the data. You can then run the sql*loader file again and reload the data for that month. If you do not null these two columns, Receivables will not reload the same month's data.
The Sales Tax Rate Interface program transfers sales tax data into the following Receivables tables:
AR_LOCATION_VALUES
AR_LOCATION_RATES
AR_TAX_INTERFACE
Below is a description of the columns in the AR_TAX_INTERFACE table into which you load sales tax data using SQL*Loader.
The Sales Tax Rate Interface program transfers the sales tax rate data from AR_TAX_INTERFACE to the AR_LOCATION_VALUES and AR_LOCATION_RATES tables. These two tables store your locations and tax rates, respectively. The AR_TAX_INTERFACE table's column descriptions note the columns in the AR_LOCATION_VALUES and AR_LOCATION_RATES tables into which records are transferred. If the column description does not have a destination section, this information will not be transferred.
REQUEST_ID
The concurrent request ID of each submission of the Sales Tax Rate Interface program. Receivables lets you submit multiple uploads of tax data concurrently. This column is not null.
INTERFACE_LINE_ID
The sequence number that uniquely identifies each tax data line. This column is not null.
CREATED_BY
The ID of the Oracle Application Object Library user who has loaded this tax data record into this table. This column is not null.
CREATION_DATE
The date on which the user loaded this tax data record into this table. This column is not null.
SEGMENT_
QUALIFIER
Identifies which segment this tax data record is for. 'COUNTRY', 'STATE', 'COUNTY', 'CITY', and 'PROVINCE' are examples of possible segment qualifier values. This column is not null.
Destination:
| AR_LOCATION_VALUES.LOCATION_
SEGMENT_QUALIFIER
|
RATE_TYPE
Identifies the tax rate type of this tax data record, and will always be 'SALES'. This column is not null.
LOCATION_ID
The ID (or Geo-code) for this location. This ID number must be unique for every location. This number is composed of a unique identifier for the location prefixed by the parent location ID. This column is not null.
LOCATION_VALUE
The actual location. 'CA' is an example of a location for the segment of 'STATE'.
Destination:
| AR_LOCATION_VALUES.LOCATION_
SEGMENT_VALUE
|
LOCATION_
DESCRIPTION
The description of the location. For a location of 'CA', the description is 'California'.
Destination:
| AR_LOCATION_VALUES.LOCATION_
SEGMENT_DESCRIPTION
|
PARENT_LOCATION_ID
The ID of the location that is directly senior to this record. This value is a foreign key to the LOCATION_ID column in the tax interface table.
FROM_POSTAL_
CODE
The starting postal code for the postal code range of this tax rate. If this column is null, Receivables uses the value that you have defined for the Postal Code Range: From field in the System Options window for this column. This value is stored in the column AR_SYSTEM_PARAMETERS.FROM_POSTAL_CODE.
Destination:
| AR_LOCATION_RATES.FROM_POSTAL_CODE
|
TO_POSTAL_
CODE
The ending postal code for the postal code range of this tax rate. If this column is null, Receivables uses the value that you have defined for the Postal Code Range: To field in the System Options window for this column. This value is stored in the column AR_SYSTEM_PARAMETERS.TO_POSTAL_CODE.
Destination:
| AR_LOCATION_RATES.TO_POSTAL_CODE
|
START_DATE
The start date of a tax rate for this location. If this column is null, then Receivables uses the value '01-JAN-1900 00:00:00' for this column.
Destination:
| AR_LOCATION_RATES.START_DATE
|
END_DATE
The end date of a tax rate for this location. If this column is null, then Receivables uses the value '31-DEC-2199 23:59:59' for this column.
Destination:
| AR_LOCATION_RATES.END_DATE
|
TAX_RATE
The tax rate for this location.
Destination:
| AR_LOCATION_RATES.TAX_RATES
|
CHANGE_FLAG
A flag that indicates whether this tax record is different from the previous listing of this data. Set this column to 'Y' if this record has been changed, 'N' if it has not, and 'U' if it is unknown whether this tax record has changed. This column is not null.
See Also
Sales Tax Rate Interface
Running the Tax Rate Interface Program
Tax Interface Report