DP_INTUPD_SPECS(SQL Table) |
Index Back |
---|---|
DP_INTUPD_SPECSDP_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 |