SF_WIPCOST_TMP(SQL Table) |
Index Back |
|---|---|
WIP Value Acct Sort Temp TblRecords will be written to this table during the Inventory Value Report generation if the user chooses to sort by account. The records will be cleared from this table after the report is run. 02/04/99 ej CN#CM800-2.0 : UNIT_COST_LND added for Landed Cost Enhancement KDN CM800-7.1: Added ALTACCT field. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 2 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
| 3 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 5 | WIPCOST_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
WIP Value Cost Type
1=Component Cost 2=Earned Cost 3=Assembly Scrap 4=Assembly Completions |
| 6 | UNIT_COST_MAT | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Unit Cost - Material |
| 7 | UNIT_COST_INB | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Unit Cost - Inbound |
| 8 | UNIT_COST_OUB | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Unit Cost - Outbound |
| 9 | UNIT_COST_CON | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Unit Cost - Conversion |
| 10 | UNIT_COST_COH | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Unit Cost - Conversion Ovrhead |
| 11 | UNIT_COST_LND | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | 02/04/99 ej CN#CM800-2.0 : Added for Landed Cost Enhancement |
| 12 | UNIT_COST_OTH | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Unit Cost - Other |