BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
RUNDTTMCOUNTERDefault Value: 0
WM_PM_NBR_CHECK(SQL Table) |
Index Back |
|---|---|
Work Management WO Id last useWork Management Work Order Id last number used record. Tracks the last WO id used by business unit |
| # | 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 |
| 2 | RUNDTTM |
DateTime(26) | TIMESTAMP | Run Date/Time |
| 3 | COUNTER |
Number(10,0) | DECIMAL(10) NOT NULL | Counter |
| 4 | WO_FROM_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Work Order id last number used |
| 5 | WO_LAST_NUM | Number(10,0) | DECIMAL(10) NOT NULL |
Work Order id last number used
Default Value: 0 |
| 6 | INTFC_ID | Number(8,0) | INTEGER NOT NULL | Interface ID |
| 7 | TO_INTFC_ID | Number(8,0) | INTEGER NOT NULL | To Interface ID |
| 8 | COUNTER8 | Number(8,0) | INTEGER NOT NULL | Counter - Unsigned 8 |
| 9 | RUNDATE | Date(10) | DATE | Process Scheduler Run Date |