SF_WIP_RPLFL_VW

(SQL View)
 Index Back

WIP replenish FEEDER LINE Req

02/25/2000 NAS (CN#SF800-30.0) Created View for flow processing - barcode completion - prompting

SELECT BUSINESS_UNIT , SF_KANBAN_ID , INV_ITEM_ID , SF_RPL_MODE , SF_RPL_SOURCE , SF_RPL_METHOD , SF_RPL_TYPE , SF_RPL_STATUS , STORAGE_AREA , STOR_LEVEL_1 , STOR_LEVEL_2 , STOR_LEVEL_3 , STOR_LEVEL_4 , SF_RPL_STOR_AREA , SF_RPL_STOR_LEV1 , SF_RPL_STOR_LEV2 , SF_RPL_STOR_LEV3 , SF_RPL_STOR_LEV4 , SF_RPL_PRDN_AREA , SF_RPL_VENDOR_ID , SF_RPL_VNDR_LOC , SF_DISPATCH_MODE , SF_RPL_TRANS_QTY FROM PS_SF_WIP_RPL_REQ WHERE SF_RPL_SOURCE='3' AND SF_RPL_STATUS='20'

# 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_FS_VW.BUSINESS_UNIT

Prompt Table: SP_BUIN_NONVW

2 SF_KANBAN_ID Character(15) VARCHAR2(15) NOT NULL Kanban ID

Default Value: NEXT

3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: MG_ITEM_APPR_VW

4 SF_RPL_MODE Character(1) VARCHAR2(1) NOT NULL Replenishment Mode
1=Backflush
2=Manual
3=Kanban
5 SF_RPL_SOURCE Character(1) VARCHAR2(1) NOT NULL Repl Source
1=Inventory
2=Supplier
3=Feeder
6 SF_RPL_METHOD Character(1) VARCHAR2(1) NOT NULL Replenishment Method
1=Pull List
2=Pull Ticket
3=Workflow
7 SF_RPL_TYPE Character(1) VARCHAR2(1) NOT NULL Rpl Type
1=One Time
2=Reusable
8 SF_RPL_STATUS Character(2) VARCHAR2(2) NOT NULL WIP Replenishment Status
10=New
20=Open
30=Dispatched
40=In Process
50=Complete
60=Hold
70=Canceled
9 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: SF_WIPLOC_A_VW

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

Prompt Table: SF_WIPLOC_L1_VW

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

Prompt Table: SF_WIPLOC_L2_VW

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

Prompt Table: SF_WIPLOC_L3_VW

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

Prompt Table: SF_WIPLOC_L4_VW

14 SF_RPL_STOR_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: STOR_AR_INSP_VW

15 SF_RPL_STOR_LEV1 Character(4) VARCHAR2(4) NOT NULL Level 1

Prompt Table: STOR_L1_INSP_VW

16 SF_RPL_STOR_LEV2 Character(4) VARCHAR2(4) NOT NULL Level 2

Prompt Table: STOR_L2_INSP_VW

17 SF_RPL_STOR_LEV3 Character(4) VARCHAR2(4) NOT NULL Level 3

Prompt Table: STOR_L3_INSP_VW

18 SF_RPL_STOR_LEV4 Character(4) VARCHAR2(4) NOT NULL Level 4

Prompt Table: STOR_L4_INSP_VW

19 SF_RPL_PRDN_AREA Character(10) VARCHAR2(10) NOT NULL Production Area

Prompt Table: SF_PA_PR_SCH_VW

20 SF_RPL_VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Replenishment Vendor ID

Prompt Table: VNDR_LOC_VW1

21 SF_RPL_VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Replinshment Vendor
22 SF_DISPATCH_MODE Character(1) VARCHAR2(1) NOT NULL Dispatch Mode
1=Deferred
2=Immediate
23 SF_RPL_TRANS_QTY Number(16,4) DECIMAL(15,4) NOT NULL Replensihment Transaction QTY