PLANNING_LEVEL_DETAILS

Planning Level Bucket Start And End Dates

tableMANPLANNING

PLANNING_LEVEL_DETAILS — Planning Level Bucket Start And End Dates. MAN table in the standard Ross ERP 8.0 schema: 8 columns, used by 19 programs. Columns, data types, keys, foreign keys and relationships.

Open PLANNING_LEVEL_DETAILS in the interactive Data Dictionary →

Part of PLANNING tables & objects · all tables, views & procedures

Columns

#ColumnTypeKeyDescription
1GEM_DBKEYintGEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one.
2COMPANY_CODEvarchar(10)PKCompany Code
3PLANNING_LEVEL_CODEsmallintPKPlanning Level
4START_DATE_01datetimeRequired Schedule Start Date
5END_DATE_01datetimeRequired Schedule End Date
6END_TIMEvarchar(4)End Time
7BUCKET_OFFSETintPKTime Bucket Offset
8START_TIMEvarchar(4)Start Time