COMPANY_CONTROLS
Company Controls
tableFINCOMPANY
COMPANY_CONTROLS — Company Controls. FIN table in the standard Ross ERP 8.0 schema: 157 columns, used by 1,133 programs. Columns, data types, keys, foreign keys and relationships.
Open COMPANY_CONTROLS 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 | COMPANY_NAME | varchar(40) | Company Name | |
| 4 | TOTAL_NUMBER_PERIODS | smallint | Number of Periods in Year | |
| 5 | CURRENT_PERIOD | smallint | Current Period | |
| 6 | CURRENT_YEAR | smallint | Current Year | |
| 7 | YEAR_START_DATE | datetime | Year Start Date | |
| 8 | YEAR_END_DATE | datetime | Year End Date | |
| 9 | FUND_IN_USE | varchar(1) | Fund/Commitment Accounting in Use | |
| 10 | MULTI_CURRENCY | varchar(1) | Multi-Currency General Ledger | |
| 11 | ACTIVATE_MODULE | varchar(1) | Activate Module | |
| 12 | SECURITY_ACTIVE | varchar(1) | Transaction Security in Operation | |
| 13 | ACCOUNT_MASK | varchar(61) | GL Account output mask | |
| 14 | RETAINED_EARNINGS_ACCOUNT | varchar(50) | Retained Earnings Account | |
| 15 | SUSPENSE_ACCOUNT | varchar(50) | GL Suspense Account | |
| 16 | CLEARING_ACCOUNT | varchar(50) | GL Clearing Account | |
| 17 | DIVISION_SUBCLASS | smallint | Division Element | |
| 18 | COST_CENTER_SUBCLASS | smallint | Cost Center Element | |
| 19 | DESCRIPTION_SUBCLASS | smallint | ||
| 20 | SYS_ADDRESS_1 | varchar(40) | Address Line 1 | |
| 21 | SYS_ADDRESS_2 | varchar(40) | Address Line 2 | |
| 22 | SYS_ADDRESS_3 | varchar(40) | Address Line 3 | |
| 23 | SYS_ADDRESS_4 | varchar(40) | Address Line 4 | |
| 24 | SYS_POSTAL_CODE | varchar(12) | Postal Code | |
| 25 | SYS_CITY | varchar(25) | City | |
| 26 | SYS_COUNTY | varchar(25) | County | |
| 27 | SYS_STATE | varchar(6) | State Code | |
| 28 | SYS_PROVINCE | varchar(6) | Province Code | |
| 29 | SYS_COUNTRY | varchar(6) | Country Code | |
| 30 | ATP_IN_USE | varchar(1) | Available To Promise In Use | |
| 31 | SYS_CURRENCY_CODE | varchar(6) | Currency Code | |
| 32 | SYS_EC_STATS_REQUIRED | varchar(1) | EC Sales Stats Required | |
| 33 | SYS_SSD_SALES_REQD | varchar(1) | EC SSD Sales Details Required | |
| 34 | SYS_SSD_PURCHASES_REQD | varchar(1) | EC SSD Purchases Details Required | |
| 35 | SYS_ECSL_REQD | varchar(1) | EC ECSL Statistics Required | |
| 36 | TAX_REFERENCE | varchar(20) | Tax Reference | |
| 37 | SYS_TAX_REFERENCE_ONLY | varchar(1) | EC Tax Reference ONLY | |
| 38 | SYS_RATE_AUTH_IN_USE | varchar(1) | Currency Rate Authority in Use | |
| 39 | SYS_RATE_TYPE_IN_USE | varchar(1) | Currency Rate Type in Use | |
| 40 | SYS_TAX_REFERENCE_BRANCH | varchar(4) | Tax Branch Reference | |
| 41 | SYS_AGENT_TRADER | varchar(1) | Company is Agent or Trader | |
| 42 | SYS_MODIFY_GL_CONTROL | varchar(1) | Modify GL Control Accounts | |
| 43 | SYS_DEF_RATE_TYPE | varchar(6) | ||
| 44 | SYS_DEF_RATE_AUTHORITY | varchar(6) | ||
| 45 | SYS_EC_RATE_TYPE | varchar(6) | ||
| 46 | SYS_EC_RATE_AUTHORITY | varchar(6) | ||
| 47 | GL_COMMIT_TAX | varchar(1) | Commit Tax | |
| 48 | SYS_CURRENCY_DATE_OVERRIDE | varchar(1) | Allow Override of Currency Date | |
| 49 | SYS_INTERDIVISION_IN_USE | varchar(1) | Interdivisional Balance in Use | |
| 50 | SYS_ADB_REQUIRED | varchar(1) | Average Daily Balances Required | |
| 51 | SYS_CURRENCY_GAIN_LOSS | varchar(1) | Compute Unrealized Currency Gain/Loss | |
| 52 | GL_DEFAULT_RATE_TYPE | varchar(6) | FK→SYS_RATE_TYPES | Default Currency Rate Type |
| 53 | GL_DEFAULT_RATE_AUTHORITY | varchar(6) | FK→SYS_RATE_AUTHORITIES | Default Currency Rate Authority |
| 54 | SYS_TAX_OVER | varchar(1) | Allow taxable value to exceed transaction value | |
| 55 | SYS_BUDGETS_IN_BASE | varchar(1) | ||
| 56 | SYS_COMMIT_FULL_VALUE | varchar(1) | ||
| 57 | SYS_USE_TAX_IN_USE | varchar(1) | Use Tax In Operation | |
| 58 | SYS_COMMIT_REVERSE_FLAG | varchar(1) | ||
| 59 | PERIOD_BALANCE_BY_ACCOUNT | varchar(1) | Period Balance By Control Account | |
| 60 | SYS_POST_AT_RECV_CODE | varchar(1) | Postings At Receiving Code | |
| 61 | SYS_PPV_AT_RECV_FLAG | varchar(1) | PPV At Receiving Flag | |
| 62 | MODIFY_FLAG | varchar(1) | Modify flag | |
| 63 | TRANSLATION_BAL_ACCOUNT | varchar(50) | GL Translation Balancing Account | |
| 64 | LET_POSITION_ACCOUNT | smallint | Reconciliation Element | |
| 65 | LET_CPT_GAIN | varchar(50) | Currency Gain Account | |
| 66 | LET_CPT_LOSS | varchar(50) | Currency Loss Account | |
| 67 | SYS_EDI_ACTIVE_FLAG | varchar(1) | EDI Active Flag | |
| 68 | SYS_EDI_TRN_TYPE_QUAL_1 | varchar(4) | EDI Transaction Type Qualifier 1 | |
| 69 | SYS_EDI_TRN_TYPE_QUAL_2 | varchar(4) | EDI Transaction Type Qualifier 2 | |
| 70 | SYS_EDI_ORDER_NUMBER_QUAL | varchar(4) | EDI Order Number Qualifier | |
| 71 | SYS_EDI_DIVISION_QUAL | varchar(4) | EDI Division Qualifier | |
| 72 | SYS_EDI_CUSTOMER_NUMBER_QUAL | varchar(4) | EDI Customer Number Qualifier | |
| 73 | SYS_EDI_SALESPERSON_CODE_QUAL | varchar(4) | EDI Salesperson Code Qualifier | |
| 74 | SYS_EDI_CUSTOMER_REF_QUAL | varchar(4) | EDI Customer Reference Qualifier | |
| 75 | SYS_EDI_TAX_REF_QUAL | varchar(4) | EDI Tax Reference Qualifier | |
| 76 | SYS_EDI_TAX_REF_BRANCH_QUAL | varchar(4) | EDI Tax Reference Branch Qualifier | |
| 77 | SYS_EDI_BASE_VALUE_QUAL | varchar(4) | EDI Base Value Qualifier | |
| 78 | SYS_EDI_CUSTOMER_CONTACT_QUAL | varchar(4) | EDI Customer Contact Qualifier | |
| 79 | SYS_EDI_COUNTY_QUAL | varchar(4) | EDI County Qualifier | |
| 80 | SYS_EDI_PHONE_QUAL | varchar(4) | EDI Phone Qualifier | |
| 81 | SYS_EDI_TELEX_QUAL | varchar(4) | EDI Telex Qualifier | |
| 82 | SYS_EDI_FAX_QUAL | varchar(4) | EDI Fax Qualifier | |
| 83 | SYS_EDI_SOP_PART_CODE_QUAL | varchar(4) | EDI SOP Product Qualifier | |
| 84 | SYS_EDI_PART_DESCRIPTION_QUAL | varchar(4) | EDI Product Description Qualifier | |
| 85 | SYS_EDI_WAREHOUSE_QUAL | varchar(4) | EDI Warehouse Qualifier | |
| 86 | SYS_EDI_DESPATCH_NOTE_QUAL | varchar(4) | EDI Ship Note Qualifier | |
| 87 | SYS_EDI_INVOICE_LINE_TYPE_QUAL | varchar(4) | EDI Invoice Line Type Qualifier | |
| 88 | SYS_EDI_FREIGHT_QUAL_1 | varchar(4) | EDI Freight Indicator | |
| 89 | SYS_EDI_FREIGHT_QUAL_2 | varchar(4) | EDI Freight Code | |
| 90 | SYS_EDI_MISC_QUAL_1 | varchar(4) | EDI Miscellaneous Indicator | |
| 91 | SYS_EDI_MISC_QUAL_2 | varchar(4) | EDI Miscellaneous Code | |
| 92 | SYS_EDI_COUNTRY_QUAL | varchar(4) | EDI Country Qualifier | |
| 93 | SYS_EDI_LOT_NUMBER_QUAL | varchar(4) | EDI Lot Number Qualifier | |
| 94 | SYS_EDI_LOT_SEQUENCE_QUAL | varchar(4) | EDI Lot Sequence Qualifier | |
| 95 | SYS_EDI_VENDOR_NUMBER_QUAL | varchar(4) | Supplier Number Qualifier | |
| 96 | SYS_EDI_VENDOR_CONTACT_QUAL | varchar(4) | Supllier Contact Qualifier | |
| 97 | SYS_EDI_SUPPLIER_REF_QUAL | varchar(4) | Supplier Reference Qualifier | |
| 98 | SYS_EDI_SUPPLIER_CONTACT_QUAL | varchar(4) | Invoice Contact Code Qualifier | |
| 99 | SYS_EDI_PO_TAX_REF_BR_QUAL | varchar(4) | Tax Reference Branch Qualifier | |
| 100 | SYS_EDI_PO_TAX_REF_QUAL | varchar(4) | Tax Reference Qualifier | |
| 101 | SYS_EDI_POP_PART_CODE_QUAL | varchar(4) | POP Product Code Qualifier | |
| 102 | SYS_EDI_SCH_REQD_DATE_QUAL | varchar(4) | Required Date Qaulifier | |
| 103 | SYS_EDI_TARIFF_CODE_QUAL | varchar(4) | Tariff Code Qualifier | |
| 104 | SYS_EDI_LINE_TAX_VALUE_QUAL | varchar(4) | Line Tax Value Qualifier | |
| 105 | SYS_EDI_FREIGHT_TAX_VAL_QUAL | varchar(4) | Freight Tax Value Qualifier | |
| 106 | SYS_EDI_MISC_TAX_VALUE_QUAL | varchar(4) | Miscellaneous Tax Value Qualifier | |
| 107 | SYS_EDI_INVOICE_NAME_QUAL | varchar(4) | EDI Invoice Name Qualifier | |
| 108 | SYS_EDI_INVOICE_CONTACT_QUAL | varchar(4) | EDI Invoice Contact Qualifier | |
| 109 | SYS_EDI_DELIVERY_NAME_QUAL | varchar(4) | EDI Delivery Name Qualifier | |
| 110 | SYS_EDI_DELIVERY_CONTACT_QUAL | varchar(4) | EDI Delivery Contact Qualifier | |
| 111 | SYS_EDI_VENDOR_PROD_QUAL | varchar(4) | Supplier Product Code Qualifier | |
| 112 | SYS_EDI_EAN_NUMBER_QUALIFIER | varchar(2) | EAN number | |
| 113 | SYS_POSTING_DATE_REQD | varchar(1) | Posting Date Required | |
| 114 | SYS_VALID_POSTING_DATE | varchar(1) | Validate Posting Date | |
| 115 | SYS_REPORT_IN_EURO | varchar(1) | European Currency in use flag | |
| 116 | SYS_REPORT_AT_GRN | varchar(1) | Report Goods at GRN | |
| 117 | SYS_TAX_ON_CASH | varchar(1) | Tax on Cash | |
| 118 | SYS_LEGAL_POSTING_CODE | varchar(1) | Code to specify the type of legal postings required | |
| 119 | SYS_PHONE_NUMBER | varchar(21) | ||
| 120 | SYS_TAX_RETAINERS_FLAG_AP | varchar(1) | ||
| 121 | SYS_TAX_RETAINERS_FLAG_AR | varchar(1) | ||
| 122 | SYS_SECOND_BASE_IN_USE | varchar(1) | Store Second Base Currency | |
| 123 | SYS_DISPLAY_SECOND_BASE | varchar(1) | Display Second Base Currency | |
| 124 | SYS_SECOND_BASE_CURRENCY_CODE | varchar(6) | Second Base Currency Code | |
| 125 | BASE_ROUNDING_ACCOUNT | varchar(50) | Base Rounding Account | |
| 126 | MP_AGREEMENT_BEFORE_PROMOTION | varchar(1) | Apply Agreements Before Promotions | |
| 127 | CONSOLIDATED_IN_USE | varchar(1) | Consolidated Invoicing In Use | |
| 128 | SELECT_CALC_FLAG | varchar(1) | Inventory Calculation By flag | |
| 129 | SYS_CURRENCY_OVERRIDE | varchar(1) | Currency Override | |
| 130 | SYS_AUTO_QOH_UPDATE_FLAG | varchar(1) | Auto QOH/CQOH Update | |
| 131 | SYS_VALUE_TO_LOT_CHAR_FLAG | varchar(1) | Avg or Last Result | |
| 132 | SYS_BILLBACK_IN_USE | varchar(1) | ||
| 133 | PRICING_METHOD_STATE | smallint | ||
| 134 | REQUISITION_WORKFLOW_APPROVALS | numeric(3,0) | Requisition Approval BPM in use indicator | |
| 135 | REQUISITION_APPROVAL_METHOD | numeric(3,0) | Requisition Approval Method - Header/Line | |
| 136 | SYS_INTERFUND_IN_USE | varchar(1) | Interfund in Use | |
| 137 | FUND_SUBCLASS | smallint | Fund Element | |
| 138 | PA_IN_USE | varchar(1) | Project Accounting In Use | |
| 139 | SUSPENSE_PROJECT | varchar(10) | ||
| 140 | PI_WINDOW_WEEKS | smallint | Projected Inventory Window Weeks | |
| 141 | GL_PA_LABOR_ACCOUNT | varchar(50) | ||
| 142 | GL_PA_LAB_OH_ACCOUNT | varchar(50) | ||
| 143 | GL_EXPENSE_OFFSET_ACCOUNT | varchar(50) | ||
| 144 | TIME_APPROVAL_REQUIRED | numeric(3,0) | Time Approval Required | |
| 145 | EXPENSE_APPROVAL_REQUIRED | numeric(3,0) | Expense Approval Required | |
| 146 | PROJECT_SUBCLASS | smallint | ||
| 147 | OVERDUE_DEMAND_SUPPLY | smallint | Overdue Demand/Supply | |
| 148 | ACCOUNT_INPUT_MASK | varchar(51) | GL Account input mask | |
| 149 | PRODUCT_AUDIT_FLAG | varchar(1) | Product Audit | |
| 150 | RECIPE_AUDIT_FLAG | varchar(1) | Recipe Audit | |
| 151 | SYS_FUNC_SECURITY_ACTIVE | varchar(1) | Master Table Maintenance Function Security | |
| 152 | PA_WBS_DELIMITER | varchar(1) | Project WBS Delimiter | |
| 153 | DAIRY_COSTING_IN_USE | varchar(1) | Dairy costing in use | |
| 154 | COST_CENTER_ON_ORDER_TYPE | varchar(1) | Cost Center Required | |
| 155 | DROPSHIPPING_IN_USE | varchar(1) | Dropshipping in Use | |
| 156 | INTERCOMPANY_ORDERS | varchar(1) | Intercompany Orders in Use | |
| 157 | GEM_MODIFY_DATE | datetime | System timestamp of the most recent modification to the row, maintained by GEMBASE. |