BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUMGOP_NONVW
CALENDAR_CODEMFG_YEARMG_CALENDAR_VW4(SQL View) |
Index Back |
|---|---|
Alternate Calendar Code View03/04/97 RPS (CN# MG700-1.0): Used for Calendar Code Print |
| select a.business_unit ,a.calendar_code,a.mfg_year from PS_MG_CALENDAR a, ps_bus_unit_opt_mg b where a.business_unit=b.business_unit and a.calendar_code<>b.calendar_code_pr group by a.business_unit ,a.calendar_code,a.mfg_year |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW |
| 2 | CALENDAR_CODE |
Character(10) | VARCHAR2(10) NOT NULL | This code is for a group of dates associated with exchange (stock, money, commodity) traded future or option contracts. |
| 3 | MFG_YEAR |
Number(4,0) | SMALLINT NOT NULL | Year |