BUSINESS_UNITPrompt Table: SP_BUMGOP_NONVW
PRDN_AREA_CODEPrompt Table: SF_PRDN_AREA
PRDN_DUE_SHIFTSF_PA_SCH_TMPS(SQL Table) |
Index Back |
|---|---|
Prdn Sch by PA shift tempSCC 9/17/97 CN# PL750-DI-SCHEW-109: Added temp record. This is the grid scroll for Production Schedule by Production Area/Shift. Needed because work record is not supported as primary record on scroll. No data will be stored in this record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUMGOP_NONVW |
| 2 | PRDN_AREA_CODE |
Character(10) | VARCHAR2(10) NOT NULL |
Production Area
Prompt Table: SF_PRDN_AREA |
| 3 | PRDN_DUE_SHIFT |
Signed Number(2,0) | DECIMAL(1) NOT NULL | Prdn Due Shift |
| 4 | QTY_MONDAY | Number(12,4) | DECIMAL(11,4) NOT NULL | Monday Production Quantity |
| 5 | QTY_TUESDAY | Number(12,4) | DECIMAL(11,4) NOT NULL | Tuesday Production Quantity |
| 6 | QTY_WEDNESDAY | Number(12,4) | DECIMAL(11,4) NOT NULL | Wednesday Production Quantity |
| 7 | QTY_THURSDAY | Number(12,4) | DECIMAL(11,4) NOT NULL | Thursday Production Quantity |
| 8 | QTY_FRIDAY | Number(12,4) | DECIMAL(11,4) NOT NULL | Friday Production Quantity |
| 9 | QTY_SATURDAY | Number(12,4) | DECIMAL(11,4) NOT NULL | Saturday Production Quantity |
| 10 | QTY_SUNDAY | Number(12,4) | DECIMAL(11,4) NOT NULL | Sunday Production Quantity |