SALES_ANALYSIS_SUMMARY_CODES
Sales Analysis Summary Codes
tableFINSALES
SALES_ANALYSIS_SUMMARY_CODES — Sales Analysis Summary Codes. FIN table in the standard Ross ERP 8.0 schema: 17 columns, used by 10 programs. Columns, data types, keys, foreign keys and relationships.
Open SALES_ANALYSIS_SUMMARY_CODES in the interactive Data Dictionary →Part of SALES 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 | DIVISION | varchar(2) | PK | Division |
| 4 | DESCRIPTION | varchar(30) | Description | |
| 5 | SA_SUMMARY_CODE | varchar(6) | PK | Sales Analysis Summary Code |
| 6 | SA_FLAG_WAREHOUSE | varchar(1) | Sales Analysis Warehouse Flag | |
| 7 | SA_FLAG_PART_CODE | varchar(1) | Sales Analysis Part Code Flag | |
| 8 | SA_FLAG_PRODUCT_GROUP | varchar(1) | Sales Analysis Product Group Flag | |
| 9 | SA_FLAG_LOCATION | varchar(1) | Sales Analysis Location Flag | |
| 10 | SA_FLAG_CUSTOMER_NUMBER | varchar(1) | Sales Analysis Customer Number Flag | |
| 11 | SA_FLAG_CUSTOMER_GROUP | varchar(1) | Sales Analysis Customer Group Flag | |
| 12 | SA_FLAG_SALESPERSON_CODE | varchar(1) | Sales Analysis Salesperson Code Flag | |
| 13 | SA_FLAG_SALES_COMMISSION_CODE | varchar(1) | Sales Analysis Sales Commission Code | |
| 14 | SA_FLAG_CURRENCY | varchar(1) | Sales Analysis Currency Flag | |
| 15 | SA_FLAG_DELIVERY_ADDRESS_CODE | varchar(1) | Sales Analysis Delivery Address Flag | |
| 16 | SA_COST_CENTER | varchar(1) | Sales Analysis Cost Center Flag | |
| 17 | SA_FLAG_UNIT_OF_MEASURE | varchar(1) | Sales Analysis Unit of Measure flag |