| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
CM_BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Cost Book
|
| 3 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 4 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 5 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 6 |
CM_DT_TIMESTAMP_A |
DateTime(26) |
TIMESTAMP |
07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.
|
| 7 |
CM_SEQ_NBR_A |
Number(15,0) |
DECIMAL(15) NOT NULL |
07/99 GMG CN800-9.0:
|
| 8 |
CM_SEQ_COST |
Number(15,0) |
DECIMAL(15) NOT NULL |
Cost Sequence Number. Incremented each time the actual cost is updated.
|
| 9 |
COST_ELEMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
Cost Element
|
| 10 |
CM_SOURCE_RECORD |
Character(18) |
VARCHAR2(18) NOT NULL |
CM Transaction Source Record
|
| 11 |
CM_QTY_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
07/99 GMG CN800-9.0:
|
| 12 |
CM_UNIT_COST |
Signed Number(27,15) |
DECIMAL(25,15) NOT NULL |
07/99 GMG CN800-9.0:
|
| 13 |
CM_RECEIPT_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
07/99 GMG CN800-9.0:
|
| 14 |
CM_RECEIPT_COST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
07/99 GMG CN800-9.0:
|
| 15 |
CM_RECADJ_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
07/99 GMG CN800-9.0:
|
| 16 |
CM_RECADJ_COST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
07/99 GMG CN800-9.0:
|