STGCOST_INF_INV

(SQL Table)
Index Back

Interface to Inventory

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

2 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID

Default Value: INSTALLATION_IN.DFLT_INV_LOT_ID

3 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
5 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

Default Value: INSTALLATION_IN.DFLT_SERIAL_ID

6 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
7 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
8 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
9 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

Default Value: 1

10 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
11 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
12 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
13 DISTRIB_SEQ_NUM Number(5,0) INTEGER NOT NULL Distribution Sequence
14 ACTUAL_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 10/09/02 lee: added label "Total Unit Cost"
15 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
16 JOB_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance