| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 3 |
MG_ASSOCIATED_BOM |
Character(18) |
VARCHAR2(18) NOT NULL |
04/99 LAJ CN#EN800.6.0
Necessary for new CPG functionality. It stores the assembly item that is the primary method for producing secondary co-products. This field defaults to the assembly item (itself).
|
| 4 |
BOM_CODE |
Number(2,0) |
SMALLINT NOT NULL |
CN# EN800-3.0, anna 09/21
added new field to database
|
| 5 |
RTG_CODE |
Number(2,0) |
SMALLINT NOT NULL |
Routing Code
|
| 6 |
COST_ELEMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
Cost Element
|
| 7 |
PL_TL_BATCH_COST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
07/09/99 WTK CN# EN800-6.0: Created for production option costing
|
| 8 |
PL_LL_BATCH_COST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
07/09/99 WTK CN# EN800-6.0: Created for production option costing
|
| 9 |
TL_COST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
This Level Cost
|
| 10 |
LL_COST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Lower Level Cost
|