DP_INTUPD_SPECS

(SQL Table)
Index Back

DP_INTUPD_SPECS

DP_INTUPD_SPECS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DP_SPECS_ID Character(20) VARCHAR2(20) NOT NULL DP_SPECS_ID
2 DP_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_CAPTION
3 DP_DDH_BI Character(1) VARCHAR2(1) NOT NULL DP_DDH_BI

Y/N Table Edit

Default Value: N

4 DP_DDH_SO Character(1) VARCHAR2(1) NOT NULL DP_DDH_SO

Y/N Table Edit

Default Value: N

5 DP_DDH_IN Character(1) VARCHAR2(1) NOT NULL DP_DDH_IN

Y/N Table Edit

Default Value: N

6 DP_DDH_OM Character(1) VARCHAR2(1) NOT NULL DP_DDH_OM

Y/N Table Edit

Default Value: N

7 DP_DDH_PL Character(1) VARCHAR2(1) NOT NULL DP_DDH_PL

Y/N Table Edit

Default Value: N

8 DP_DDH_PR Character(1) VARCHAR2(1) NOT NULL DP_DDH_PR

Y/N Table Edit

Default Value: N

9 DP_DDH_TR Character(1) VARCHAR2(1) NOT NULL DP_DDH_TR

Y/N Table Edit

Default Value: N

10 DP_CREATEFCITEMS Character(1) VARCHAR2(1) NOT NULL Create Forecast Items flag used by Updater

Y/N Table Edit

Default Value: Y

11 DP_DHLOADER_UOM Character(1) VARCHAR2(1) NOT NULL Demand Loader Unit Of Measure options
0=Transaction UOM
1=Standard Inventory UOM

Default Value: 0

12 DP_ACCUMULATEDMD Character(1) VARCHAR2(1) NOT NULL DP_ACCUMULATEDMD

Y/N Table Edit

Default Value: Y

13 DP_RESETPERCENT Number(13,2) DECIMAL(12,2) NOT NULL DP_RESETPERCENT
14 DP_SPEC_STATUS Character(1) VARCHAR2(1) NOT NULL DP_SPEC_STATUS
A=Active
N=New

Default Value: N

15 DP_FCST_KIT_SPEC Character(1) VARCHAR2(1) NOT NULL Forecast Kit Option
N=Components
Y=Product Kits

Default Value: N

16 DP_UPDATEDBY Character(20) VARCHAR2(20) NOT NULL DP_UPDATEDBY
17 DP_DATEUPDATED DateTime(26) TIMESTAMP DP_DATEUPDATED
18 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update