SF_VND_RPL_VW

(SQL View)
 Index Back

WIP replenishment Request

02/06/2000 FRD (CN#SF800-30.0) Created table for flow processing

SELECT A.BUSINESS_UNIT , A.SF_KANBAN_ID , A.INV_ITEM_ID , A.SF_RPL_MODE , A.SF_RPL_SOURCE , A.SF_RPL_METHOD , A.SF_RPL_TYPE , A.SF_RPL_STATUS , A.STORAGE_AREA , A.STOR_LEVEL_1 , A.STOR_LEVEL_2 , A.STOR_LEVEL_3 , A.STOR_LEVEL_4 , A.SF_RPL_STOR_AREA , A.SF_RPL_STOR_LEV1 , A.SF_RPL_STOR_LEV2 , A.SF_RPL_STOR_LEV3 , A.SF_RPL_STOR_LEV4 , A.SF_RPL_PRDN_AREA , A.SF_RPL_VENDOR_ID , A.SF_RPL_VNDR_LOC , A.SF_RPL_VENDOR_QTY , A.SF_RPL_VENDOR_UOM , A.SF_DISPATCH_MODE , A.SF_RPL_TRANS_QTY , A.REPL_DISP_METHOD , A.PRINT_COUNT , A.LAST_DTTM_UPDATE , A.DTTM_COMPLETE , A.DTTM_DISP , A.CREATE_DTTM , A.OPRID , A.PROCESS_INSTANCE , A.MG_VENDOR_VIEWED FROM PS_SF_WIP_RPL_REQ a WHERE a.sf_rpl_status IN ('10','20','30','40','50')

# 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 SF_KANBAN_ID Character(15) VARCHAR2(15) NOT NULL Kanban ID
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: SF_RPLLOC_AR_VW

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

Prompt Table: SF_RPLLOC_L1_VW

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

Prompt Table: SF_RPLLOC_L2_VW

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

Prompt Table: SF_RPLLOC_L3_VW

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

Prompt Table: SF_RPLLOC_L4_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: VENDOR_PO_VW

21 SF_RPL_VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Replinshment Vendor

Prompt Table: VNDR_LOC_VW3

22 SF_RPL_VENDOR_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Replinshment Vendor QTY
23 SF_RPL_VENDOR_UOM Character(3) VARCHAR2(3) NOT NULL Replenishment Vendor UOM
24 SF_DISPATCH_MODE Character(1) VARCHAR2(1) NOT NULL Dispatch Mode
1=Deferred
2=Immediate
25 SF_RPL_TRANS_QTY Number(16,4) DECIMAL(15,4) NOT NULL Replensihment Transaction QTY
26 REPL_DISP_METHOD Character(3) VARCHAR2(3) NOT NULL repl_disp_method
EDX=Electronic Document Exchange
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print
27 PRINT_COUNT Number(3,0) SMALLINT NOT NULL Print Count
28 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
29 DTTM_COMPLETE DateTime(26) TIMESTAMP Date/Time Completed
30 DTTM_DISP DateTime(26) TIMESTAMP Date Time Dispatched
31 CREATE_DTTM DateTime(26) TIMESTAMP Creation Datetime
32 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
33 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
34 MG_VENDOR_VIEWED Character(1) VARCHAR2(1) NOT NULL Vendor has viewed information

Y/N Table Edit