SF_REPL_INV

(SQL Table)
 Index Back

Prdn Repl Location Attributes

5/11/1999 WHS (CN#SF800-4.0) New RowInit and FieldChange code to correctly handle hide/unhide of storage level display. 02/05/2000 FRD (CN#SF800-30.0) added flow fields

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

Prompt Table: SP_BUIN_NONVW

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

Prompt Table: MG_ITEM_APPR_VW

3 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: SF_WIPLOC_A_VW

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

Prompt Table: SF_WIPLOC_L1_VW

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

Prompt Table: SF_WIPLOC_L2_VW

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

Prompt Table: SF_WIPLOC_L3_VW

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

Prompt Table: SF_WIPLOC_L4_VW

8 SF_RPL_MODE Character(1) VARCHAR2(1) NOT NULL Replenishment Mode
1=Backflush
2=Manual
3=Kanban
9 SF_RPL_SOURCE Character(1) VARCHAR2(1) NOT NULL Repl Source
1=Inventory
2=Supplier
3=Feeder
10 SF_RPL_METHOD Character(1) VARCHAR2(1) NOT NULL Replenishment Method
1=Pull List
2=Pull Ticket
3=Workflow
11 SF_RPL_TYPE Character(1) VARCHAR2(1) NOT NULL Rpl Type
1=One Time
2=Reusable
12 SF_DISPATCH_MODE Character(1) VARCHAR2(1) NOT NULL Dispatch Mode
1=Deferred
2=Immediate
13 SF_RPL_STOR_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: SF_RPLLOC_AR_VW

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

Prompt Table: SF_RPLLOC_L1_VW

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

Prompt Table: SF_RPLLOC_L2_VW

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

Prompt Table: SF_RPLLOC_L3_VW

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

Prompt Table: SF_RPLLOC_L4_VW

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

Prompt Table: SF_PA_PR_SCH_VW

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

Prompt Table: VENDOR_PO_VW

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

Prompt Table: VNDR_LOC_VW3

21 ISSUE_MULTIPLE Number(16,4) DECIMAL(15,4) NOT NULL Prdn Issue Multiple

Default Value: BU_ITEMS_INV.ISSUE_MULTIPLE

22 REPLENISH_POINT Number(16,4) DECIMAL(15,4) NOT NULL Prdn Replenishment Point

Default Value: BU_ITEMS_INV.REPLENISH_POINT

23 WIP_MIN_QTY Number(16,4) DECIMAL(15,4) NOT NULL WIP Minimum Quantity

Default Value: BU_ITEMS_INV.WIP_MIN_QTY

24 SF_WIP_MAX_QTY Number(16,4) DECIMAL(15,4) NOT NULL WIP maximum QTY

Default Value: BU_ITEMS_INV.SF_WIP_MAX_QTY