Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
TAX_SCHEDULE_CD |
|
VARCHAR(10) |
NO |
Name: Tax Schedule. Description: The tax code type unique identifier. |
EFFECTIVE_DT |
|
DATE |
NO |
Name: Effective Date. Description: Effective date. |
EXP_TYPE_CD |
|
VARCHAR(10) |
NO |
Name: Expense Type. Description: The expense type code for the tax schedule if record is expense type specific. If the record is not for a specific expense type, "ALL" will be stored in this field. |
TAX_LOCATION_S |
|
VARCHAR(20) |
NO |
Name: Tax Location. Description: The location used in the tax schedule. If record is not for a specific location, "ALL" will be stored in this field. |
TAX_RATE1_PCT |
|
NUMERIC(5, 4) |
NO |
Name: Tax Rate 1 Percentage. Description: The Rate1 percentage for this tax schedule record. |
TAX_RATE2_PCT |
|
NUMERIC(5, 4) |
NO |
Name: Tax Rate 2 Percentage. Description: The Rate2 percentage for this tax schedule record. |
TOLERANCE_PCT |
|
NUMERIC(3, 2) |
NO |
Name: Tolerance Percentage. Description: The tolerance percentage that a user can deviate from system calculated rate. |
MODIFIED_BY |
|
VARCHAR(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMERIC(10, 0) |
NO |
Name: Row Version. Description: The number of times this record has been updated. |
TIME_STAMP |
|
DATE |
NO |
Name: Time Stamp. Description: Date and time the record was last modified. |
TAX_RECOVERY_RATE1_PCT |
|
NUMERIC(3, 2) |
NO |
Name: Tax Rate 1 Recovery Percentage. Description: The rate 1 tax recovery percentage for this tax schedule record. |
TAX_RECOVERY_RATE2_PCT |
|
NUMERIC(3, 2) |
NO |
Name: Tax Rate 2 Recovery Percentage. Description: The rate 2 tax recovery percentage for this tax schedule record. |
S_RATE2_CALC_METHOD_CD |
|
VARCHAR(1) |
NO |
Name: Rate 2 Calculation Method Code. Description: Determines how the system will calculate tax amounts. Valid values are: S – Standard, A - Additive. |