PL_BW_FLEX_DATE

(SQL Table)
 Index Back

Buyer WB - Flex Date Ranges

Runtime table used to store the Dates used for Flex Calculations

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SCHED_GROUP_CD Character(6) VARCHAR2(6) NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: %EDITTABLE

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

Prompt Table: %EDITTABLE2

5 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
7 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
8 FROM_DTTM DateTime(26) TIMESTAMP From Date/Time
9 TO_DTTM DateTime(26) TIMESTAMP Ending Number in Range
10 PL_FLEX_TYPE Character(1) VARCHAR2(1) NOT NULL Flex Type
1=Fixed
2=Firm
11 RUN_DT Date(10) DATE Run Date
12 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
13 UPSIDE_FLG Character(1) VARCHAR2(1) NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
14 UPSIDE_PCT Number(6,2) DECIMAL(5,2) NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
15 DOWNSIDE_FLG Character(1) VARCHAR2(1) NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
16 DOWNSIDE_PCT Number(6,2) DECIMAL(5,2) NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
17 CHECK_BY Character(1) VARCHAR2(1) NOT NULL Period Defined by
D=Day
R=Entire Range
18 FIX_FENCE_DAYS Number(3,0) SMALLINT NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
19 START_DT Date(10) DATE Start Date
20 END_DT Date(10) DATE End Date
21 UPSIDE_QTY Number(16,4) DECIMAL(15,4) NOT NULL Maximum Upside Quantity
22 DOWNSIDE_QTY Number(16,4) DECIMAL(15,4) NOT NULL Minimum Downside Quantity
23 QTY_OVER_UNDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Over/Under Flex Quantity
24 UPSIDE_DELTA_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Upside (Delta) Quantity
25 DOWNSIDE_DELTA_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Downside (Delta) Quantity
26 OVER_UNDER_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
27 PL_SHOWROW Character(1) VARCHAR2(1) NOT NULL PL_SHOWROW

Y/N Table Edit

Default Value: Y