STAGED_E_INV_VW

(SQL View)
 Index Back

Staged Items in Error


SELECT business_unit ,a.staging_id ,a.inv_item_id ,a.inv_lot_id ,a.container_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.rma_id ,a.rma_line_nbr ,a.staged_date ,a.qty ,a.unit_of_measure ,a.qty_base ,a.qty_conv_flag ,a.putaway_status ,a.storage_area ,a.stor_level_1 ,a.stor_level_2 ,a.stor_level_3 ,a.stor_level_4 ,a.production_id ,a.to_production_id ,a.inspect_status ,a.op_sequence ,a.qty_code ,a.inv_stock_type ,a.storage_code ,a.non_own_flag ,a.distrib_type ,a.receipt_type ,a.trans_source ,a.config_code ,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.sf_kanban_id , a.demand_hash , a.supply_hash ,a.consigned_flag ,A.STAGED_TYPE FROM PS_STAGED_ITEM_INV a WHERE putaway_status = '3'

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

Prompt Table: SP_BUIN_NONVW

2 STAGING_ID Number(15,0) DECIMAL(15) NOT NULL Putaway Staging ID
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: BU_ITM_INV_VW

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

Default Value: INSTALLATION_IN.DFLT_INV_LOT_ID

Prompt Table: %EDITTABLE6

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

Prompt Table: CNTR_ID_INV

6 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

Default Value: INSTALLATION_IN.DFLT_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 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
15 RMA_LINE_NBR Number(5,0) INTEGER NOT NULL RMA Line Number
16 STAGED_DATE Date(10) DATE NOT NULL Staged Date
17 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
18 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

19 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
20 QTY_CONV_FLAG Character(2) VARCHAR2(2) NOT NULL Quantity Convert Flag
1=Enter Qty in Stocking UOM
2=Enter Qty in Standard UOM
21 PUTAWAY_STATUS Character(1) VARCHAR2(1) NOT NULL Item Putaway Status
1=Not Assigned
2=Putaway Complete
3=In Error
22 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: %EDITTABLE

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

Prompt Table: %EDITTABLE2

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

Prompt Table: %EDITTABLE3

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

Prompt Table: %EDITTABLE4

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

Prompt Table: %EDITTABLE5

27 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
28 TO_PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL To Production ID
29 INSPECT_STATUS Character(1) VARCHAR2(1) NOT NULL Inspection Status
C=Complete
I=Incomplete

Default Value: C

30 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
31 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
32 INV_STOCK_TYPE Character(4) VARCHAR2(4) NOT NULL Stock Type

Prompt Table: STOCK_TYPE_INV

33 STORAGE_CODE Character(4) VARCHAR2(4) NOT NULL Storage Code

Prompt Table: STORAGE_CD_INV

34 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

Default Value: N

35 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

Prompt Table: CM_DISTR_TYPE

36 RECEIPT_TYPE Character(4) VARCHAR2(4) NOT NULL Receipt Type
IUT=Interunit Transfer
RMA=Return Material Authorization
37 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
38 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

Prompt Table: CP_CONFIG_VW

39 CONTAINER_TYPE Character(4) VARCHAR2(4) NOT NULL Container Type
40 SPEEDTYPE_KEY Character(10) VARCHAR2(10) NOT NULL SpeedType Key

Prompt Table: %SPEEDTYPE_VIEW

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

Prompt Table: %EDIT_ACCOUNT

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

Prompt Table: %EDIT_ALTACCT

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

Prompt Table: DEPTID_BUGL_VW

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

Prompt Table: OPERUNT_BUGL_VW

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

Prompt Table: PRODUCT_BUGL_VW

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

Prompt Table: FUND_BUGL_VW

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

Prompt Table: CLASSCF_BUGL_VW

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

Prompt Table: PROGRAM_BUGL_VW

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

Prompt Table: BUD_REF_BUGL_VW

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CF1_BUGL_VW

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

Prompt Table: CF2_BUGL_VW

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

Prompt Table: CF3_BUGL_VW

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

Prompt Table: %EDIT_BU_PC

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

Prompt Table: %EDIT_PROJECT

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

Prompt Table: %EDIT_ACTIVITY

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

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

63 COMBO_VALID_FLG Character(1) VARCHAR2(1) NOT NULL ChartField Combinatn Valid Flg
?=Validation in Progress
V=Valid ChartField Combination
X=Invalid ChartField Combo
64 SF_KANBAN_ID Character(15) VARCHAR2(15) NOT NULL Kanban ID
65 DEMAND_HASH Character(28) VARCHAR2(28) NOT NULL 08/11/04 EGS: Created.
66 SUPPLY_HASH Character(28) VARCHAR2(28) NOT NULL 08/11/04 EGS: Created.
67 CONSIGNED_FLAG Character(1) VARCHAR2(1) NOT NULL Consigned Flag
68 STAGED_TYPE Character(1) VARCHAR2(1) NOT NULL Staging Type
1=
2=* Cancellation
3=* Short Shipment