PRODUCTION_PROFILES
Production Profiles
tableMANPRODUCTION
PRODUCTION_PROFILES — Production Profiles. MAN table in the standard Ross ERP 8.0 schema: 12 columns, used by 8 programs. Columns, data types, keys, foreign keys and relationships.
Open PRODUCTION_PROFILES 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 | PLANNING_PRODUCT | varchar(15) | PK | |
| 4 | PLANNING_LEVEL_CODE | smallint | PK | Planning Level |
| 5 | BASE_DATE | datetime | PK | Planning Base Date |
| 6 | STARTING_BUCKET_OFFSET | int | PK | |
| 7 | ENDING_BUCKET_OFFSET | int | ||
| 8 | PRODUCTION_RATIO | numeric(20,4) | Production Ratio | |
| 9 | BUCKET_PRODUCTION_RATIO | computed | ||
| 10 | STARTING_BUCKET_START_DATE | datetime | ||
| 11 | ENDING_BUCKET_END_DATE | datetime | ||
| 12 | NUMBER_OF_BUCKETS | int |