TAX_RATES
Tax Rates
tableFINTAX
TAX_RATES — Tax Rates. FIN table in the standard Ross ERP 8.0 schema: 46 columns, used by 38 programs. Columns, data types, keys, foreign keys and relationships.
Open TAX_RATES in the interactive Data Dictionary →Part of Other tables & objects · all tables, views & procedures
Columns
| # | Column | Type | Key | Description |
|---|---|---|---|---|
| 1 | GEM_DBKEY | int | GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one. | |
| 2 | COMPANY_CODE | varchar(10) | PK | Company Code |
| 3 | PRODUCT_TAX_CODE | varchar(5) | PK FK→TAX_CODES | Product Tax Code |
| 4 | CUSTOMER_TAX_CODE | varchar(5) | PK FK→TAX_CODES | Customer Tax Code |
| 5 | TAX_RATE_1 | numeric(10,6) | Tax Rate 1 | |
| 6 | TAX_RATE_2 | numeric(10,6) | Tax Rate 2 | |
| 7 | TAX_RATE_3 | numeric(10,6) | Tax Rate 3 | |
| 8 | TAX_RATE_4 | numeric(10,6) | Tax Rate 4 | |
| 9 | TAX_RATE_5 | numeric(10,6) | Tax Rate 5 | |
| 10 | TAX_RATE_6 | numeric(10,6) | Tax Rate 6 | |
| 11 | TAX_DESCRIPTION | varchar(30) | Tax Code Description | |
| 12 | AR_TAX_CODE | varchar(6) | FK→GL_SHORT_CODES | Short Code for Auto AR Tax |
| 13 | AR_TAX_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full Account for Auto AR Tax |
| 14 | AP_TAX_CODE | varchar(6) | FK→GL_SHORT_CODES | Short Code for Auto Tax Postings |
| 15 | AP_TAX_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | AP Full Account for Tax Postings |
| 16 | ACTIVATION_STATUS | varchar(1) | Activation Status | |
| 17 | FORMAT_CODE | varchar(6) | Format Code | |
| 18 | AR_POSTING_FORMAT | varchar(6) | FK→POSTING_FORMATS | |
| 19 | AP_POSTING_FORMAT | varchar(6) | FK→POSTING_FORMATS | |
| 20 | SYS_EXPENSE_RATE_FLAG_1 | varchar(1) | Expense tax rate_1 flag | |
| 21 | SYS_EXPENSE_RATE_FLAG_2 | varchar(1) | Expense tax rate 2 flag. | |
| 22 | SYS_EXPENSE_RATE_FLAG_3 | varchar(1) | Expense tax rate 3 flag. | |
| 23 | SYS_EXPENSE_RATE_FLAG_4 | varchar(1) | Expense tax rate 4 flag. | |
| 24 | SYS_EXPENSE_RATE_FLAG_5 | varchar(1) | Expense tax rate 5 flag | |
| 25 | SYS_EXPENSE_RATE_FLAG_6 | varchar(1) | Expense tax rate 6 flag. | |
| 26 | SYS_TOTAL_EXPENSED_RATE | numeric(10,6) | Total of all expensed tax rates. | |
| 27 | SYS_TOTAL_NON_EXPENSED_RATE | numeric(10,6) | Total of all non-expensed rates. | |
| 28 | SYS_INCLUDE_TAX_IN_WAC | varchar(1) | Include Expense Tax in WAC | |
| 29 | SYS_TAX_LIABLE | varchar(1) | Liable | |
| 30 | SYS_TAX_DEDUCTIBLE | varchar(1) | Deductible | |
| 31 | SYS_TAX_IGIC | varchar(1) | IGIC | |
| 32 | SYS_TAX_EXEMPT | varchar(1) | Exempt | |
| 33 | SYS_TAX_INTERNAL | varchar(1) | Internal | |
| 34 | SYS_TAX_EC | varchar(1) | EC | |
| 35 | SYS_TAX_TYPE_OF_GOOD | varchar(1) | Type of Good | |
| 36 | SYS_TAX_ON_CASH | varchar(1) | Tax on Cash | |
| 37 | AR_DISCOUNT_TAX_CODE | varchar(6) | FK→GL_SHORT_CODES | AR Discount Tax Code |
| 38 | AR_DISCOUNT_TAX_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | AR Discount Tax Account |
| 39 | AP_DISCOUNT_TAX_CODE | varchar(6) | FK→GL_SHORT_CODES | AP Discount Tax Code |
| 40 | AP_DISCOUNT_TAX_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | AP Discount Tax Account |
| 41 | AR_TEMP_TAX_CODE | varchar(6) | FK→GL_SHORT_CODES | AR Temporary Tax Short Code |
| 42 | AR_TEMP_TAX_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | AR Temporary Tax Account |
| 43 | AP_TEMP_TAX_CODE | varchar(6) | FK→GL_SHORT_CODES | AP Temporary Tax Short Code |
| 44 | AP_TEMP_TAX_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | AP Temporary Tax Account |
| 45 | SYS_FULL_TAX_CODE | computed | ||
| 46 | SYS_TAX_RATE | computed |