SF_SPLIT_HIST

(SQL Table)
Index Back

Production ID Split history

02/09/99 SCC CN#SF800-9.0: Production ID Split History

# 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).