PROCESS_INSTANCECALENDAR_CODE1=Manufacturing
2=Receiving
3=Shipping
PL_SHEX_BLK_AET(SQL Table) |
Index Back |
|---|---|
Ship/Received Except Dates09/25/01 EGS (CN#PL900-1): Added. - Ship/Received Except Block Dates |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | PL_CALENDAR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
08/16/01 EGS (CN#PL900-1.0): Added
1=Manufacturing 2=Receiving 3=Shipping |
| 5 | CALENDAR_DATE | Date(10) | DATE | An internal work field utilized to store calendar dates for a given calendar year. The dates are displa |
| 6 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 7 | END_TIME | Time(15) | TIMESTAMP | End of Shift |
| 8 | DTTM_FROM | DateTime(26) | TIMESTAMP | From Date/Time |
| 9 | DTTM_TO | DateTime(26) | TIMESTAMP | To Date/Time |