SF_OP_LT_TMP(SQL Table) |
Index Back |
|---|---|
Operation Leadtime Work RecordOperation Leadtime Work Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 2 | SETUP_LT | Signed Number(14,4) | DECIMAL(12,4) NOT NULL | Setup Leadtime |
| 3 | SETUP_NO_LT | Signed Number(14,4) | DECIMAL(12,4) NOT NULL | Setup Leadtime Not Included |
| 4 | FXRUN_LT | Signed Number(14,4) | DECIMAL(12,4) NOT NULL | Fixed Run Leadtime |
| 5 | TOT_RUN_LT | Signed Number(14,4) | DECIMAL(12,4) NOT NULL | Total Run Leadtime |
| 6 | QUEUE_LT | Signed Number(14,4) | DECIMAL(12,4) NOT NULL | Queue Leadtime |
| 7 | QUEUE_ADJ_LT | Signed Number(14,4) | DECIMAL(12,4) NOT NULL | Adjusted Queue Leadtime |
| 8 | INTRANS_LT | Signed Number(14,4) | DECIMAL(12,4) NOT NULL | Intransit Leadtime |
| 9 | RUN_RATE | Number(11,4) | DECIMAL(10,4) NOT NULL | Run Rate |
| 10 | OVERLAP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Overlap Flag |