UPG_CM_EARN_TAO(SQL Table) |
Index Back |
|---|---|
SF_EARNCONCOST upgrade tempSF_EARNCONCOST upgrade temp table 03/04/02 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MG_PROC_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 4 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 5 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 6 | TRANS_DATE | Date(10) | DATE | Transaction Date |
| 7 | TRANS_TIME | Time(15) | TIMESTAMP | Transaction Time |
| 8 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 9 | CONVERSION_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Conversion Type
1100=Lab Setup 1200=Lab Fixed 1300=Labor Run 1400=Lab PostPr 1500=Mach Setup 1600=Mach Fixed 1700=Mach Run 1800=MC PostPrd 2100=Ovhd 1 2200=Ovhd 2 2300=Ovhd 3 2400=Ovhd 4 |
| 10 | REVALUE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Can be either 'Y' or 'N'. This field is located on the ITEM Table and signifies whether or not an item will be considered by the Revaluation Process to be revaluated. |