# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
2 |
FROM_PRDN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
From Production ID
|
3 |
TO_PRDN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
To Production ID
|
4 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
5 |
PRDN_SPLIT_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Production Split Qty
|
6 |
FROM_PRDN_AREA |
Character(10) |
VARCHAR2(10) NOT NULL |
From Production Area
|
7 |
TO_PRDN_AREA |
Character(10) |
VARCHAR2(10) NOT NULL |
To Production Area
|
8 |
FROM_ITEMID |
Character(18) |
VARCHAR2(18) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label ITEM_ID
|
9 |
TO_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label ITEM_ID
|
10 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|