STAGED_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

Prompt Table: SP_BUIN_NONVW

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

Prompt Table: BU_ITM_INV_VW

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 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

Default Value: 1

9 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
10 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
11 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
12 DISTRIB_SEQ_NUM Number(5,0) INTEGER NOT NULL Distribution Sequence
13 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element

Prompt Table: CM_ELEMENT

14 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
15 RMA_LINE_NBR Number(5,0) INTEGER NOT NULL RMA Line Number
16 LOT_BIRTHDATE Date(10) DATE Lot Creation Dt
17 EXPIRATION_DATE Date(10) DATE Expiration Date
18 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
19 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
20 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line
21 INSPECT_STATUS Character(1) VARCHAR2(1) NOT NULL Inspection Status
C=Complete
I=Incomplete

Default Value: C

22 INSPECTION_ID Character(10) VARCHAR2(10) NOT NULL Item Inspection ID
23 LAST_PURCH_DATE Date(10) DATE Last Purchase Date
24 ACTUAL_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 10/09/02 lee: added label "Total Unit Cost"
25 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
26 TRANSFER_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price
27 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
28 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: INV_STCK_UOM_VW

29 RECEIPT_TYPE Character(4) VARCHAR2(4) NOT NULL Receipt Type
IUT=Interunit Transfer
RMA=Return Material Authorization
30 NON_OWN_FLAG Character(1) VARCHAR2(1) NOT NULL 07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No
Y=Yes

Y/N Table Edit

31 INV_STOCK_TYPE Character(4) VARCHAR2(4) NOT NULL Stock Type

Default Value: BU_ITEMS_INV.INV_STOCK_TYPE

Prompt Table: STOCK_TYPE_INV

32 PURCH_LOT_ID Character(15) VARCHAR2(15) NOT NULL Purchase Lot
33 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: %EDITTABLE

34 MA_PRDN_ID_FLG Character(1) VARCHAR2(1) NOT NULL 10/18/99 SCC CN#IC800: Add label MAINTAIN_PID
N=No
Y=Yes

Y/N Table Edit

Default Value: N

35 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
36 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
37 PRODUCTION_TYPE Character(2) VARCHAR2(2) NOT NULL JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production
RW=Rework
SV=Service
TD=Teardown
38 TO_PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL To Production ID
39 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
40 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
41 STORAGE_CODE Character(4) VARCHAR2(4) NOT NULL Storage Code

Prompt Table: STORAGE_CD_INV

42 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
43 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
44 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
45 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
46 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
47 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
48 PO_DT Date(10) DATE Date
49 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
50 TRANS_SOURCE Character(3) VARCHAR2(3) NOT NULL Transaction Source
01=Purchasing
02=WIP Completion
03=Inventory
04=WIP Component
05=Adjustment
06=Component Kit Returns

Default Value: 03

51 STAGED_STATUS Character(3) VARCHAR2(3) NOT NULL Staged Status
01=InterUnit
02=Receipt

Default Value: 02

52 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
53 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
54 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
A=Purge All
S=Only purge items with at least

Y/N Table Edit

Default Value: N

55 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
56 JOB_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance
57 CONTAINER_TYPE Character(4) VARCHAR2(4) NOT NULL Container Type
58 SPEEDTYPE_KEY Character(10) VARCHAR2(10) NOT NULL SpeedType Key
59 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
60 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
61 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
62 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
63 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
64 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
65 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
66 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
67 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
68 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
69 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
70 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
71 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
72 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
73 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
74 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: %EDIT_BU_PC

75 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: %EDIT_PROJECT

76 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: %EDIT_ACTIVITY

77 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

78 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

79 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

80 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

81 COMBO_VALID_FLG Character(1) VARCHAR2(1) NOT NULL ChartField Combinatn Valid Flg
?=Validation in Progress
V=Valid ChartField Combination
X=Invalid ChartField Combo
82 CONSIGNED_FLAG Character(1) VARCHAR2(1) NOT NULL Consigned Flag

Y/N Table Edit

Default Value: N

83 SF_KANBAN_ID Character(15) VARCHAR2(15) NOT NULL Kanban ID
84 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
85 SUPPLY_HASH Character(28) VARCHAR2(28) NOT NULL 08/11/04 EGS: Created.