STAGED_IRCV_VW

(SQL View)
 Index Back

Interface to Inventory View


SELECT a.BUSINESS_UNIT ,a.RECEIVER_ID ,a.RECV_LN_NBR ,a.INV_LOT_ID ,a.CONTAINER_ID ,a.INV_ITEM_ID ,a.SERIAL_ID ,a.COST_ELEMENT ,a.SEQ_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.INTERUNIT_ID ,a.INTERUNIT_LINE ,a.LOT_BIRTHDATE ,a.EXPIRATION_DATE ,a.PO_ID ,a.INSPECT_STATUS ,a.INSPECTION_ID ,a.LAST_PURCH_DATE ,a.ACTUAL_COST ,a.CONVERSION_RATE ,a.TRANSFER_COST ,a.QTY ,a.UNIT_OF_MEASURE ,a.RECEIPT_TYPE ,a.NON_OWN_FLAG ,a.INV_STOCK_TYPE ,a.PURCH_LOT_ID ,a.VENDOR_ID ,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.STORAGE_CODE ,a.STORAGE_AREA ,a.STOR_LEVEL_1 ,a.STOR_LEVEL_2 ,a.STOR_LEVEL_3 ,a.STOR_LEVEL_4 ,a.DISTRIB_TYPE ,a.PO_DT ,a.BUSINESS_UNIT_PO ,a.TRANS_SOURCE ,a.STAGED_STATUS ,a.CONFIG_CODE ,a.OPRID ,a.PROCESS_FLAG ,a.PROCESS_INSTANCE ,a.JOB_INSTANCE ,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_source ,a.SUPPLY_HASH FROM PS_STAGED_INF_INV a

# 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 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
3 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
4 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID

Prompt Table: LOT_CONTROL_INV

5 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
7 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
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 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
15 RMA_LINE_NBR Number(5,0) INTEGER NOT NULL RMA Line Number
16 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
17 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line
18 LOT_BIRTHDATE Date(10) DATE Lot Creation Dt
19 EXPIRATION_DATE Date(10) DATE Expiration Date
20 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
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
Set Control Field: BUSINESS_UNIT

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

Default Value: N

31 INV_STOCK_TYPE Character(4) VARCHAR2(4) NOT NULL Stock Type
32 PURCH_LOT_ID Character(15) VARCHAR2(15) NOT NULL Purchase Lot
33 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
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
42 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: %EDITTABLE5

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

Prompt Table: %EDITTABLE6

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

Prompt Table: %EDITTABLE7

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

Prompt Table: %EDITTABLE8

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

Prompt Table: %EDITTABLE9

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

Prompt Table: CP_CONFIG_VW2

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

Prompt Table: %SPEEDTYPE_VIEW

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

Prompt Table: %EDIT_ACCOUNT

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

Prompt Table: %EDIT_ALTACCT

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

Prompt Table: DEPTID_BUGL_VW

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

Prompt Table: OPERUNT_BUGL_VW

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

Prompt Table: PRODUCT_BUGL_VW

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

Prompt Table: FUND_BUGL_VW

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

Prompt Table: CLASSCF_BUGL_VW

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

Prompt Table: PROGRAM_BUGL_VW

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

Prompt Table: BUD_REF_BUGL_VW

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CF1_BUGL_VW

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

Prompt Table: CF2_BUGL_VW

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

Prompt Table: CF3_BUGL_VW

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.