STAGED_INV_VW

(SQL View)
 Index Back

Inventory Staged Items View


SELECT a.business_unit , a.staging_id , a.inv_lot_id , a.container_id , a.inv_item_id , a.serial_id , a.receiver_id , a.recv_ln_nbr , a.staged_num , a.source_bus_unit , a.recv_ship_seq_nbr , a.distrib_line_num , a.distrib_seq_num , a.ptwy_plan_id , a.rma_id , a.rma_line_nbr , a.ptwyplan_ln_nbr , a.staged_date , a.lot_birthdate , a.expiration_date , a.ma_prdn_id_flg , a.production_id , a.prdn_area_code , a.production_type , a.to_production_id , a.op_sequence , a.qty_code , a.inv_stock_type , a.qty , a.unit_of_measure , a.qty_base , a.qty_conv_flag , a.putaway_status , a.conversion_rate , a.transfer_cost , a.process_flag , a.process_instance , a.job_instance , a.text254 , a.from_stor_area , a.from_stor_lev1 , a.from_stor_lev2 , a.from_stor_lev3 , a.from_stor_lev4 , a.from_uom , a.storage_area , a.stor_level_1 , a.stor_level_2 , a.stor_level_3 , a.stor_level_4 , a.putaway_flag , a.receipt_type , a.po_id , a.interunit_id , a.interunit_line , a.inspect_status , a.inspection_id , a.last_purch_date , a.non_own_flag , a.purch_lot_id , a.vendor_id , a.storage_code , a.oprid , a.staged_type , a.distrib_type , a.po_dt , a.business_unit_po , a.trans_source , a.config_code , a.cancel_nettable , a.dt_timestamp , a.container_type , a.speedtype_key , a.account , a.altacct , A.DEPTID , %subrec(cf16_an_sbr,a) , %subrec(pc_cf1_n_sbr,a) , a.combo_valid_flg , a.consigned_flag , a.sf_kanban_id , a.demand_hash , a.supply_hash FROM PS_STAGED_ITEM_INV a WHERE putaway_status = '1' AND process_flag = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 STAGING_ID Number(15,0) DECIMAL(15) NOT NULL Putaway Staging ID
3 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID

Prompt Table: %EDITTABLE6

4 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID

Prompt Table: CNTR_ID_INV

5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
6 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
7 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
8 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
9 STAGED_NUM Number(3,0) SMALLINT NOT NULL Staged Number
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 PTWY_PLAN_ID Number(10,0) DECIMAL(10) NOT NULL Putaway Plan ID
15 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
16 RMA_LINE_NBR Number(5,0) INTEGER NOT NULL RMA Line Number
17 PTWYPLAN_LN_NBR Number(10,0) DECIMAL(10) NOT NULL Putaway Line Number
18 STAGED_DATE Date(10) DATE Staged Date
19 LOT_BIRTHDATE Date(10) DATE Lot Creation Dt
20 EXPIRATION_DATE Date(10) DATE Expiration Date
21 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

22 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
23 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
24 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
25 TO_PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL To Production ID
26 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
27 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
28 INV_STOCK_TYPE Character(4) VARCHAR2(4) NOT NULL Stock Type
29 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
30 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

31 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
32 QTY_CONV_FLAG Character(2) VARCHAR2(2) NOT NULL Quantity Convert Flag
1=Enter Qty in Stocking UOM
2=Enter Qty in Standard UOM
33 PUTAWAY_STATUS Character(1) VARCHAR2(1) NOT NULL Item Putaway Status
1=Not Assigned
2=Putaway Complete
3=In Error
34 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
35 TRANSFER_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price
36 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

37 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
38 JOB_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance
39 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text
40 FROM_STOR_AREA Character(5) VARCHAR2(5) NOT NULL From storage area
41 FROM_STOR_LEV1 Character(4) VARCHAR2(4) NOT NULL From Storage Level 1
42 FROM_STOR_LEV2 Character(4) VARCHAR2(4) NOT NULL From Storage Level 2
43 FROM_STOR_LEV3 Character(4) VARCHAR2(4) NOT NULL From Storage Level 3
44 FROM_STOR_LEV4 Character(4) VARCHAR2(4) NOT NULL From Storage Level 4
45 FROM_UOM Character(3) VARCHAR2(3) NOT NULL Unit of Measure
46 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: %EDITTABLE

47 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1

Prompt Table: %EDITTABLE2

48 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2

Prompt Table: %EDITTABLE3

49 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3

Prompt Table: %EDITTABLE4

50 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4

Prompt Table: %EDITTABLE5

51 PUTAWAY_FLAG Character(1) VARCHAR2(1) NOT NULL Item Putaway Flag

Y/N Table Edit

Default Value: N

52 RECEIPT_TYPE Character(4) VARCHAR2(4) NOT NULL Receipt Type
IUT=Interunit Transfer
RMA=Return Material Authorization
53 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
54 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
55 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line
56 INSPECT_STATUS Character(1) VARCHAR2(1) NOT NULL Inspection Status
C=Complete
I=Incomplete
57 INSPECTION_ID Character(10) VARCHAR2(10) NOT NULL Item Inspection ID
58 LAST_PURCH_DATE Date(10) DATE Last Purchase Date
59 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

Default Value: N

60 PURCH_LOT_ID Character(15) VARCHAR2(15) NOT NULL Purchase Lot
61 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
62 STORAGE_CODE Character(4) VARCHAR2(4) NOT NULL Storage Code
63 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
64 STAGED_TYPE Character(1) VARCHAR2(1) NOT NULL Staging Type
1=
2=* Cancellation
3=* Short Shipment
65 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

Prompt Table: CM_DISTR_TYPE

66 PO_DT Date(10) DATE Date
67 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
68 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
69 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

Prompt Table: CP_CONFIG_VW

70 CANCEL_NETTABLE Character(1) VARCHAR2(1) NOT NULL Nettable Flag from Picking Loc

Y/N Table Edit

Default Value: N

71 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
72 CONTAINER_TYPE Character(4) VARCHAR2(4) NOT NULL Container Type
73 SPEEDTYPE_KEY Character(10) VARCHAR2(10) NOT NULL SpeedType Key

Prompt Table: %SPEEDTYPE_VIEW

74 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: %EDIT_ACCOUNT

75 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

Prompt Table: %EDIT_ALTACCT

76 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW

77 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

78 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_BUGL_VW

79 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_BUGL_VW

80 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASSCF_BUGL_VW

81 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_BUGL_VW

82 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_BUGL_VW

83 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

84 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

85 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

86 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_BUGL_VW

87 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CF2_BUGL_VW

88 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CF3_BUGL_VW

89 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: %EDIT_BU_PC

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

Prompt Table: %EDIT_PROJECT

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

Prompt Table: %EDIT_ACTIVITY

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

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

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

Y/N Table Edit

Default Value: N

98 SF_KANBAN_ID Character(15) VARCHAR2(15) NOT NULL Kanban ID
99 DEMAND_HASH Character(28) VARCHAR2(28) NOT NULL 08/11/04 EGS: Created.
100 SUPPLY_HASH Character(28) VARCHAR2(28) NOT NULL 08/11/04 EGS: Created.