SF_STAGED_IN_VW

(SQL View)
 Index Back

Prdn View of Staged_Inf_Inv

8/29/97 rlk - add ACCOUNT and CF16_SN_SBR so insync with STAGED_INF_INV. 10/24/97 prc - add COMBO-VALID_FLG to view 11/03/97 dso - added conversion type due to INV change 11/13/97 gmg - added SPEEDTYPE_KEY 11/21/97 dvh - added PROCESS_FLAG 12/01/97 adc - added INSPECT_STATUS for PO Inspection task 12/4/97 WER - ADDED PROJECT FIELDS 06/21/99 ebn CN#CM800-4.0 : Added CONSIGNED_FLAG for Consignment Enhancement 07/06/99 RT CN#MG800-4.0 Changed prompt table for inv_item_id 08/15/99 MDS CN#SF800-13.0: Replaced location views MG_OWN_xxxx_VW with %EDITTABLE6-10. 11/16/99 SSN Inventory added a field qty_base 12/09/99 ssn Inventory changed keys where cost_lement is no longer a key 04/17/00 MDS CN#SF800-30.0: Added sf_kanban_id for flow. 08/26/04 WHS PEGGING - Added demand_source

SELECT a.BUSINESS_UNIT , a.INV_LOT_ID , a.CONTAINER_ID , a.INV_ITEM_ID , a.SERIAL_ID , a.RECEIVER_ID , a.RECV_LN_NBR , a.SEQ_NUM , a.SOURCE_BUS_UNIT , a.RECV_SHIP_SEQ_NBR , a.DISTRIB_LINE_NUM , a.DISTRIB_SEQ_NUM , a.COST_ELEMENT , a.RMA_ID , a.RMA_LINE_NBR , a.LOT_BIRTHDATE , a.EXPIRATION_DATE , a.PO_ID , a.INTERUNIT_ID , a.INTERUNIT_LINE , 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
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

Prompt Table: %EDITTABLE4

6 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

Default Value: INSTALLATION_IN.DFLT_RECEIVER_ID

7 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line

Default Value: INSTALLATION_IN.DFLT_RECEIVER_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
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

Default Value: N

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

Prompt Table: %EDITTABLE6

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

Prompt Table: %EDITTABLE7

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

Prompt Table: %EDITTABLE8

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

Prompt Table: %EDITTABLE9

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

Prompt Table: %EDITTABLE10

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

Prompt Table: CM_DISTR_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

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

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.