Fields Imported From PeopleSoft SCM to Build Demand Data HistoryThis appendix describes fields imported and published by PeopleSoft Demand Planning and discusses:
Fields imported from PeopleSoft Supply Chain Management (PeopleSoft SCM) to build demand data history.
Fields loaded from external data imports.
Fields published to inventory forecast.
Fields published to product forecast.
Fields published for use as external data.
Fields Imported From PeopleSoft SCM to Build Demand Data HistoryThis table describes where the data used to build the demand stream for PeopleSoft Demand Planning is pulled from PeopleSoft Supply Chain Management applications:
|
DP_DMDHISTORY Field |
Populated from |
Description |
|
DP_DDH_ID |
System assigned |
IF Demand Source BI then DP_DDH_ID = YYYY + MM+DD+HH+MM+SS+BI+ROW NUMBER IF Demand Source OM(Configured Component) then DP_DDH_ID = YYYY+MM+DD+HH+MM+SS+O1+Row Number IF Demand Source = OM (Non-Configured Components) then DP_DDH_ID = YYYY+MM+DD+HH+MM+SS+O2+Row Number IF Demand Source = OM(Non-Configured Items) then DP_DDH_ID = YYYY+MM+DD+HH+MM+SS+O3+Row Number IF Demand Source = IN then DP_DDH_ID = YYYY+MM+DD+HH+MM+SS+IN+Row Number IF Demand Source = TR then DP_DDH_ID = YYYY+MM+DD+HH+MM+SS+TR+Row Number |
|
DP_DDH_ID_LINK |
System assigned |
IF New Demand then DP_DDH_ID_LINK = Blank Else DP_DDH_ID_LINK = Previously Processed Demand DP_DDH_ID |
|
DEMAND_SOURCE |
BI, OM, SO, IN, TR |
IF Demand Source BI then DEMAND_SOURCE = BI IF Demand Source = OM then DEMAND_SOURCE = OM IF Demand Source = SO then DEMAND_SOURCE = IN IF Demand Source = TR then DEMAND_SOURCE = TR |
|
DP_UPDATE_DMDTYPE |
BI, OM, SO, IN, TR |
If Demand Source BI then DEMAND_SOURCE = BI IF Demand Source = OM then DEMAND_SOURCE = OM IF Demand Source = SO then DEMAND_SOURCE = IN IF Demand Source = TR then DEMAND_SOURCE = TR |
|
DP_TRANSOURCE |
1, 2, 3 |
IF Demand Source = BI then DP_TRANSOURCE = 2 IF Demand Source = OM then DP_TRANSOURCE = 3 Else DP_TRANSOURCE = 1 |
|
AUDIT_ACTN |
A, C |
IF new Demand then AUDIT_ACTN = A Else AUDIT_ACTN = C |
|
DP_SOURCESTATUS |
0 |
Extracted from forecast data. |
|
DP_UPDATESTATUS |
System assigned |
'-1, 0, 1, 2. Indicates whether the row has been processed or not by the Loader. 0 it is ready to process, 1 indicates processed, 2 indicates it is currently locked by a Loader in process.' 1 indicates an errored row. |
|
DP_DEMANDDATE |
SHIP_INV_INV.DEMAND_DATE ORD_SCHEDULE.REQ_SHIP_DTTM SHIP_INF_INV.SHIP_DATE |
IF Demand Source = BI then DP_DEMANDDATE = SHIP_INF_INV(DEMAND_DATE) IF Demand Source = OM then DP_DEMANDDATE = ORD_SCHEDULE(REQ_SHIP_DTTM) IF Demand Source = (SO or IN or TR) THEN DP_DEMANDDATE = SHIP_INF_INV(SHIP_DATE) |
|
DP_DEMANDQTY |
SHIP_INF_INV.QTY_SHIPPED |
IF Demand Source = (BI or SO or IN or TR) THEN DP_DEMANDQTY = SHIP_INF_INV(QTY_SHIPPED) IF Demand Source = OM THEN DP_DEMANDQTY = ORD_SCHEDULE(QTY_SCHEDULED) * ORD_SCHEDULE(SF_QTY_PER) |
|
DP_UPDTE_NO |
1 or Higher |
IF New Demands THEN DP_UPDATE_NO = 1 IF Update Demand THEN DP_UPDATE_NO = DP_UPDATE_NO + 1 |
|
BUSINESS_UNIT |
BI_LINE.BUSINESS_UNIT ORD_SCHEDULE.BUSINESS_UNIT SHIP_INF_INV.BUSINESS_UNIT |
IF Demand Source = BI THEN BUSINESS_UNIT = BI_LINE(BUSINESS_UNIT) IF Demand_Source = OM THEN BUSINESS_UNIT = ORDE_SCHEDULE(BUSINESS_UNIT) IF Demand Source = (SO or IN or TR') THEN BUSINESS_UNI = SHIP_INF_INV(BUSINESS_UNIT) |
|
BILL_TO_CUST_ID |
BI_HDR.BILL_TO_CUST_ID ORD_HEADER.BILL_TO_CUST_ID BLANK |
IF Demand SourcE = BI THEN BILL_TO_CUST_ID = BI_HDR(BILL_TO_CUST_ID) IF Demand Source = SO THEN BILL_TO_CUST_ID = ORD_HEADER(BILL_TO_CUST_ID) ELSE BILL_TO_CUST_ID = BLANK |
|
CM_UNIT_COST |
CM_ACTUAL_COST(SUM(CM_UNIT_COST)) CM_PDAV_COST_VW(CM_UNIT_COST) CM_PERPAVG(CM_UNIT_COST) CM_PERIODCOST(SUM(TL_COST+LL_COST)) |
IF CM_ITEM_LED_VW(CM_METHOD) = 1 THEN CM_UNIT_COST = CM_ACTUAL_COST(SUM(CM_UNIT_COST) IF COST_METHOD = 6 THEN CM_UNIT_COST = CM_PDAV_COST_VW(CM_UNIT_COST)) IF COST_METHOD = 7 THEN CM_UNIT_COST = CM_PDAV_COST_VW(CM_UNIT_COST) IF COST_METHOD = 8 THEN CM_UNIT_COST = CM_PRODCOST(SUM(TL_COST+LL_COST)) ELSE CM_UNIT_COST = 0 |
|
CURRENCY_CD |
BI_LINE(BASE_CURRENCY) ORD_HEADER(CURRENCY_CD) SHIP_INF_INV(CURRENCY_CD) BLANK |
IF Demand Source = BI THEN CURRENCY_CD = BI_LINE(BASE_CURRENCY) IF Demand Source = (OM or SO) THEN CURRENCY_CD = ORD_HEADER(CURRENCY_CD) IF Demand Source = TR THEN CURRENCY_CD = SHIP_INF_INV(CURRENCY_CD) ELSE CURRENCY_CD = BLANK |
|
DEMAND_LINE_NO |
SHIP_INF_INV(DEMAND_LINE_NO) 0 |
IF Demand Source = (BI or SO or IN or TR) THEN DEMAND_LINE_NO = SHIP_INF_INV(DEMAND_LINE_NO) ELSE DEMAND_LINE_NO = 0 |
|
DP_DEMANDVALUE |
Calculated |
IF Demand Source = (SO or IN or TR) THEN DP_DEMANDVALUE = SHIP_INF_INV(QTY_SHIPPED) * SHIP_INF_INV(NET_UNIT_PRICE) IF Demand Source = BI THEN DP_DEMANDVALUE = BI_LINE(NET_EXTENDED_BSE) IF Demand Source = OM (Configured Components)THEN DP_DEMANDVALUE = ORD_SCHEDULE(QTY_SCHEDULE) * SF_COMP_LIST(SF_QTY_PER) * ORD_SCHEDULE(NET_UNIT_PRICE_BSE) IF Demand Source = OM (NON-CONFIGURED KITS) THEN DP_DEMANDVALUE = ORD_SCHEDULE(QTY_SCHEDULE) * SF_COMP_LIST(SF_QTY_PER) * ORD_SCHEDULE(NET_UNIT_PRICE_BSE) |
|
INV_ITEM_ID |
SHIP_INF_INV.INV_ITEM_ID PROD_ITEM.INV_ITEM_ID |
IF Demand Source = (OM or SO or IN or TR) THEN INV_ITEM_ID = SHIP_INF_INV(INV_ITEM_ID) ELSE INV_ITEM_ID = PROD_ITEM(INV_ITEM_ID) |
|
INVOICE |
BI_LINE.INVOICE |
IF Demand Source = (BI) THEN INVOICE = BI_LINE(INVOICE) ELSE INVOICE = BLANK |
|
INVOICE_DT |
BI_HDR.INVOICE_DT |
IF Demand Source = BI THEN INVOICE_DT = BI_HDR(INVOICE_DT) ELSE INVOICE_DT = NULL |
|
LINE_SEQ_NUM |
BI_LINE.LINE_SEQ_NUM |
IF Demand Source = BI THEN INVOICE_DT = BI_HDR(INVOICE_DT) ELSE INVOICE_DT = NULL |
|
LIST_PRICE |
BI_LINE.LIST_PRICE ORD_SCHEDULE.LIST_PRICE PROD_PRICE.LIST_PRICE |
IF Demand Source = BI THEN LIST_PRICE = BI_LINE(LIST_PRICE) IF Demand Source = OM or SO THEN LIST_PRICE = ORD_SCHEDULE(LIST_PRICE) IF Demand Source = IN THEN LIST_PRICE = 0 IF Demand Source = TR AND LIST_PRICE = 0 THEN LIST_PRICE = PROD_PRICE(LIST_PRICE) |
|
ORDER_DATE |
ORD_HEADER.ORDER_DATE |
IF Demand Source = (OM or SO ) THEN ORDER_DATE = ORD_HEADER(ORDER_DATE) ELSE ORDER_DATE = NULL |
|
ORDER_GRP |
ORD_HEADER.ORDER_GRP |
IF Demand Source = (OM or SO) THEN ORDER_GRP = ORD_HEADER(ORDER_GRP) ELSE ORDER_GRP = BLANK |
|
ORDER_INT_LINE_NO |
BI_LINE.ORDER_INT_LINE_NO ORD_SCHEDULE.ORDER_INT_LINE_NO SHIP_INF_INV.ORDER_INT_LINE_NO |
IF Demand SourcE = BI THEN ORDER_INT_LINE_NO = BI_LINE(ORDER_INT_LINE_NO) IF Demand Source = OM THEN ORDER_INT_LINE_NO = ORD_SCHEDULE(ORDER_INT_LINE_NO) IF Demand Source = (SO or IN or TR) THEN ORDER_INT_LINE_NO = SHIP_INF_INV(ORDER_INT_LINE_NO) |
|
ORDER_NO |
BI_LINE.ORDER_NO ORD_SCHEDULE.ORDER_NO SHIP_INF_INV.ORDER_NO |
IF Demand Source = BI THEN ORDER_NO = BI_LINE(ORDER_NO) IF Demand Source = OM THEN ORDER_NO = ORD_SCHEDULE(ORDER_NO) IF Demand Source = (SO or IN or TR) THEN ORDER_NO = SHIP_INF_INV(ORDER_NO) |
|
PRICE_PROGRAM |
ORD_SCHEDULE.PRICE_PROGRAM |
IF Demand Source = OM THEN PRICE_PROGRAM = ORD_SCHEDULE(PRICE_PROGRAM) ELSE PRICE_PROGRAM = BLANK |
|
PRODUCT_ID |
BI_LINE.PRODUCT_ID ORD_LINE.PRODUCT_ID |
IF Demand SourcE = BI THEN PRODUCT_ID = BI_LINE(PRODUCT_ID) IF Demand Source = OM THEN PRODUCT_ID = ORD_SCHEDULE(PRODUCT_ID) IF Demand Source = (SO or IN or TR) THEN PRODUCT_ID = SHIP_INF_INV(PRODUCT_ID) |
|
COMPONENT_ID |
SF_COMP_LIST.COMPONENT_ID |
IF Demand Source = OM THEN COMPONENT_ID = SF_COMP_LIST(COMPONENT_ID) ELSE COMPONENT_ID = BLANK |
|
SCHED_LINE_NO |
SHIP_INF_INV.SCHED_LINE_NO ORD_SCHEDULE.SCHED_LINE_NBR |
IF Demand Source = (BI or SO or IN or TR) THEN SCHED_LINE_NO = SHIP_INF_INV(SCHED_LINE_NO) IF Demand Source = OM THEN SCHED_LINE_NO = ORD_SCHEDULE(SCHED_LINE_NBR) |
|
SHIP_DATE |
SHIP_INF_INV.SHIP_DATE BI_LINE.SHIP_DATE |
IF Demand Source = (SO or IN or TR) THEN SHIP_DATE = SHIP_INF_INV(SHIP_DATE) IF Demand Source = BI THEN SHIP_DATE = BI_LINE(SHIP_DATE) IF Demand Source = OM THEN SHIP_DATE = NULL |
|
SHIP_TO_CUST_ID |
BI_HDR.SHIP_TO_CUST_ID ORD_SCHEDULE.SHIP_TO_CUST_ID SHIP_INF_INV.SHIP_TO_CUST_ID |
IF Demand Source = (IN or TR) THEN SHIP_TO_CUST_ID = SHIP_INF_INV(SHIP_TO_CUST_ID) IF Demand Source = BI THEN SHIP_TO_CUST_ID = BI_HDR(SHIP_TO_CUST_ID) IF Demand Source = OM THEN SHIP_DATE = ORD_SCHEDULE(SHIP_TO_CUST_ID) |
|
SOLD_TO_CUST_ID |
BI_HDR.SOLD_TO_CUST_ID ORD_HEADER.SOLD_TO_CUST_ID |
IF Demand Source = BI THEN SOLD_TO_CUST_ID = BI_HDR(SOLD_TO_CUST_ID) IF Demand Source = (OM or SO) THEN SOLD_TO_CUST_ID = ORD_HEADER(SOLD_TO_CUST_ID) ELSE SOLD_TO_CUST_ID = BLANK |
|
SOURCE_BUS_UNIT |
SHIP_INF_INV(SOURCE_BUS_UNIT) BLANK |
IF Demand Source = (BI or SO or IN or TR) THEN SOURCE_BUS_UNIT = SHIP_INF_INV(SOURCE_BUS_UNIT) ELSE SOURCE_BUS_UNIT = BLANK |
|
SOURCE_CD |
ORD_HEADER(SOURCE_CD) BLANK |
IF Demand Source = (OM or SO ) THEN SOURCE_CD = ORD_HEADER(SOURCE_CD) ELSE ORDER_DATE = NULL |
|
UNIT_OF_MEASURE |
BI_LINE(UNIT_OF_MEASURE) MASTER_ITEM_TBL(UNIT_OF_MEASURE_STD) SHIP_INF_INV(UNIT_OF_MEASURE_SHIP) |
IF Demand Source = (SO or IN or TR) THEN UNIT_OF_MEASURE = SHIP_INF_INV(UNIT_OF_MEASURE_SHIP) IF Demand Source = BI THEN UNIT_OF_MEASURE = BI_LINE(UNIT_OF_MEASURE) IF Demand Source = OM THEN UNIT_OF_MEASURE = MASTER_ITEM_TBL(UNIT_OF_MEASURE_STD) |
|
CONVERSION_RATE |
INV_ITEM_UOM(CONVERSION_RATE) |
Data extracted the same for all demand sources. |
|
BUSINESS_UNIT_BI |
BI_LINE(BUSINESS_UNIT) BUS_UNIT_TBL_OM(BUS_UNIT_BI) BLANK |
IF Demand Source = OM and (NON-Configured Item or NON-Configured Kit) THEN BUSINESS_UNIT_BI = BUS_UNIT_TBL_OM(BUS_UNIT_BI) ELSE BUSINESS_UINIT_BI = BLANK |
|
BUSINESS_UNIT_IN |
BI_LINE(SHIP_FROM_BU) ORD_SCHEDULE(PRIORITY_SHIP_FROM) SHIP_INF_INV(BUSINESS_UNIT) SHIP_INF_INV(SOURCE_BUSINESS_UNIT) |
IF Demand Source = BI THEN BUSINESS_UNIT_IN = BI_LINE(SHIP_FROM_BU) IF Demand Source = OM THEN BUSINESS_UNIT_IN = ORD_SCHEDULE(PRIORITY_SHIP_FROM) IF Demand Source = SO or IN THEN BUSINESS_UNIT_IN = SHIP_INF_INV(BUSINESS_UNIT) IF Demand SourcE = TR THEN BUSINESS_UNIT_IN = SHIP_INF_INV(SOURCE_BUS_UNIT) |
|
BUSINESS_UNIT_OM |
BI_LINE(BUSINESS_UNIT_OM) ORD_SCHEDULE(BUSINESS_UNIT) SHIP_INF_INV(SOURCE_BUSINESS_UNIT) |
IF Demand Source = BI THEN BUSINESS_UNIT_OM = BI_LINE(BUSINESS_UNIT_OM) IF Demand Source = OM THEN BUSINESS_UNIT_OM = ORD_SCHEDULE(BUSINESS_UNIT) IF Demand SourcE = SO or IN or TR THEN BUSINESS_UNIT_OM = SHIP_INF_INV(SOURCE_BUS_UNIT) |
|
CORPORATE_CUST_ID |
CUSTOMER.CORPORATE_CUST_ID |
Data extracted the same for all demand sources. |
|
CUST_FIELD_C10 A-D |
CUSTOMER.CUST_FIELD_C10 A-D |
Data extracted the same for all demand sources. |
|
CUST_FIELD_C1 A-D |
CUSTOMER.CUST_FIELD_C1 A-D |
Data extracted the same for all demand sources. |
|
CUST_FIELD_C 2, 4, 6, 8 |
CUSTOMER.CUST_FIELD_C 2, 4, 6, 8 |
Data extracted the same for all demand sources. |
|
CUST_FIELD_C30 A-D |
CUSTOMER.CUST_FIELD_C30 A-D |
Data extracted the same for all demand sources. |
|
CUST_FIELD_N12 A-D |
CUSTOMER.CUST_FIELD_N12 A-D |
Data extracted the same for all demand sources. |
|
CUST_FIELD_N15 A-D |
CUSTOMER.CUST_FIELD_N15 A-D |
Data extracted the same for all demand sources. |
|
SUBCUST_QUAL1 |
CUSTOMER.SUBCUST_QUAL1 |
Data extracted the same for all demand sources. |
|
SUBCUST_QUAL2 |
CUSTOMER.SUBCUST_QUAL2 |
Data extracted the same for all demand sources. |
|
CUSTOMER_GROUP |
CUST_CRGP_LNK.CUSTOMER_GROUP |
Data extracted the same for all demand sources. |
|
CUST_CHANNEL |
CUST_PM_CHANNEL.CUST_CHANNEL |
Data extracted the same for all demand sources. |
|
CLASSIFICATION |
CUST_HIERARCHY.CLASSIFICATION |
Data extracted the same for all demand sources. |
|
PM_DIVISION |
CUST_HIERARCHY.PM_DIVISION |
Data extracted the same for all demand sources. |
|
PM_REGION |
CUST_HIERARCHY.PM_REGION |
Data extracted the same for all demand sources. |
|
PM_TERRITORY |
CUST_HIERARCHY.PM_TERRITORY |
Data extracted the same for all demand sources. |
|
INV_ITEM_GROUP |
MASTER_ITEM_TBL.INV_ITEM_GROUP |
Data extracted the same for all demand sources. |
|
MITBL_DESCR |
MASTER_ITEM_TBL.DESCR |
Data extracted the same for all demand sources. |
|
CATEGORY_ID |
MASTER_ITEM_TBL.CATEGORY_ID |
Data extracted the same for all demand sources. |
|
INV_PROD_FAM_CD |
MASTER_ITEM_TBL.INV_PROD_FAM_CD |
Data extracted the same for all demand sources. |
|
INV_ITEM_TYPE |
INV_ITEMS.INV_ITEM_TYPE |
Data extracted the same for all demand sources. |
|
INV_ITEM_COLOR |
INV_ITEMS.INV_ITEM_COLOR |
Data extracted the same for all demand sources. |
|
UPD_ID |
INV_ITEMS.UPD_ID |
Data extracted the same for all demand sources. |
|
FORECAST_ITEM_FLAG |
BU_ITEMS_INV.FORECAST_ITEM_FLAG |
Demand will only be pulled for items where either this forecast flag is set to Y, OR the one the on the product master is set to Y. |
|
UTILIZ_CD |
BU_ITEMS_UTIL_CD.UTILIZ_CD |
Data extracted the same for all demand sources. |
|
UTILIZ_GROUP |
BU_ITEMS_UTIL_CD.UTILIZ_GROUP |
Data extracted the same for all demand sources. |
|
ITEM_FIELD_C10 A-D |
BU_ITEMS_INV.ITEM_FIELD_C10 A-D MASTER_ITEM_TBL.ITEM_FIELD_C10 A-D |
Users selects at Build history time, whether attributes will be selected from the item master or the business unit item record. |
|
ITEM_FIELD_C1 A-D |
BU_ITEMS_INV.ITEM_FIELD_C1 A-D MASTER_ITEM_TBL.ITEM_FIELD_C1 A-D |
Users selects at Build history time, whether attributes will be selected from the item master or the business unit item record. |
|
ITEM_FIELD_C 2, 4, 6, 8 |
BU_ITEMS_INV.ITEM_FIELD_C 2, 4, 6, 8 MASTER_ITEM_TBL.ITEM_FIELD_C 2, 4, 6, 8 |
Users selects at Build history time, whether attributes will be selected from the item master or the business unit item record. |
|
ITEM_FIELD_C30 A-D |
BU_ITEMS_INV.ITEM_FIELD_C30 A-D MASTER_ITEM_TBL.ITEM_FIELD_C30 A-D |
Users selects at Build history time, whether attributes will be selected from the item master or the business unit item record. |
|
ITEM_FIELD_N12 A-D |
BU_ITEMS_INV.ITEM_FIELD_N12 A-D MASTER_ITEM_TBL.ITEM_FIELD_N12 A-D |
Users selects at Build history time, whether attributes will be selected from the item master or the business unit item record. |
|
ITEM_FIELD_N15 A-D |
BU_ITEMS_INV.ITEM_FIELD_N15 A-D MASTER_ITEM_TBL.ITEM_FIELD_N15 A-D |
Users selects at Build history time, whether attributes will be selected from the item master or the business unit item record. |
|
PROD_BRAND |
PROD_ITEM.PROD_BRAND |
Data extracted the same for all demand sources. |
|
PROD_CATEGORY |
PROD_ITEM.PROD_CATEGORY |
Data extracted the same for all demand sources. |
|
PRDITM_DESCR |
PROD_ITEM.DESCR |
Data extracted the same for all demand sources. |
|
PROD_FIELD_C1 A-D |
PROD_ITEM.PROD_FIELD_C1 A-D |
Data extracted the same for all demand sources. |
|
PROD_FIELD_C10 A-D |
PROD_ITEM.PROD_FIELD_C10 A-D |
Data extracted the same for all demand sources. |
|
PROD_FIELD_C 2, 4, 6, 8 |
PROD_ITEM.PROD_FIELD_C 2, 4, 6, 8 |
Data extracted the same for all demand sources. |
|
PROD_FIELD_C30 A-D |
PROD_ITEM.PROD_FIELD_C30 A-D |
Data extracted the same for all demand sources. |
|
PROD_FIELD_N12 A-D |
PROD_ITEM.PROD_FIELD_N12 A-D |
Data extracted the same for all demand sources. |
|
PROD_FIELD_N15 A-D |
PROD_ITEM.PROD_FIELD_N15 A-D |
Data extracted the same for all demand sources. |
|
PRODUCT_GROUP |
PROD_PGRP_LNK.PRODUCT_GROUP |
Data extracted the same for all demand sources. |
|
SALES_PERSON |
BI_HDR.SALES_PERSON |
Data extracted the same for all demand sources. |
|
FORECASTER |
BU_ITEMS_INV.FORECASTER |
Data extracted the same for all demand sources. |
|
DP_ERRORCOMMENTS |
System assigned. |
Demand Loader will write errors into this field, separated by colons, indicating why records were not processed into certain views. |
Fields Loaded During External Data Imports
This section discusses:
Forecast adjustment fields.
Demand history fields.
Forecast item fields.
User period data fields.
Note. All file layouts require a record ID of 100, except XML files. The first column should always be 100 for processing by PeopleSoft Demand Planning.
Forecast Adjustment FieldsThis table describes the fields and their processing order for forecast adjustment data for all layout types:
|
Field Loaded |
Field Description |
Field Seq. |
Field Start |
Field Length |
Field Type |
Decimal |
Required |
|
RECORD IDENTIFIER (Always 100) |
Record ID |
0 |
1 |
3 |
Number |
0 |
Y |
|
DP_CONFIGLEVEL |
Config Level |
1 |
4 |
2 |
Number |
0 |
Y |
|
DP_YEAR |
Year |
2 |
6 |
4 |
Number |
0 |
Y if input date is not supported |
|
DP_PERIOD |
Period |
3 |
10 |
2 |
Number |
0 |
Y if input date is not supported |
|
DP_INPUTDATE |
Input Date |
4 |
12 |
10 |
Date |
0 |
Y if year and period are not supported |
|
DP_ADJFORECAST_STR |
Adjusted Forecast |
5 |
22 |
15 |
Character |
0 |
N |
|
DP_ADJFORECASTUOM |
Adjusted Forecast UOM |
6 |
37 |
3 |
Character |
0 |
N If not supplied, assumed to be base UOM |
|
DP_FC_PROCESS_ACT |
Process Action |
7 |
40 |
1 |
Character |
0 |
Y |
|
DP_FC_COMMENT |
Comment |
8 |
41 |
50 |
Character |
0 |
N |
|
DP_ITEMCODE |
Item Code |
9 |
91 |
18 |
Character |
0 |
Y if key field |
|
DP_LOCATION |
Location |
10 |
109 |
5 |
Character |
0 |
Y if key field |
|
DP_UD01 |
User Data Field |
11 |
114 |
30 |
Character |
0 |
N |
|
DP_UD02 |
User Data Field |
12 |
144 |
30 |
Character |
0 |
N |
|
DP_UD03 |
User Data Field |
13 |
174 |
30 |
Character |
0 |
N |
|
DP_UD04 |
User Data Field |
14 |
204 |
30 |
Character |
0 |
N |
|
DP_UD05 |
User Data Field |
15 |
234 |
30 |
Character |
0 |
N |
|
DP_UD06 |
User Data Field |
16 |
264 |
30 |
Character |
0 |
N |
|
DP_UD07 |
User Data Field |
17 |
294 |
30 |
Character |
0 |
N |
|
DP_UD08 |
User Data Field |
18 |
324 |
30 |
Character |
0 |
N |
|
DP_UD09 |
User Data Field |
19 |
354 |
30 |
Character |
0 |
N |
|
DP_UD10 |
User Data Field |
20 |
384 |
30 |
Character |
0 |
N |
|
DP_UD11 |
User Data Field |
21 |
414 |
20 |
Character |
0 |
N |
|
DP_UD12 |
User Data Field |
22 |
434 |
20 |
Character |
0 |
N |
|
DP_UD13 |
User Data Field |
23 |
454 |
20 |
Character |
0 |
N |
|
DP_UD14 |
User Data Field |
24 |
474 |
20 |
Character |
0 |
N |
|
DP_UD15 |
User Data Field |
25 |
494 |
20 |
Character |
0 |
N |
|
DP_UD16 |
User Data Field |
26 |
514 |
20 |
Character |
0 |
N |
|
DP_UD17 |
User Data Field |
27 |
534 |
20 |
Character |
0 |
N |
|
DP_UD18 |
User Data Field |
28 |
554 |
20 |
Character |
0 |
N |
|
DP_UD19 |
User Data Field |
29 |
574 |
20 |
Character |
0 |
N |
|
DP_UD20 |
User Data Field |
30 |
594 |
20 |
Character |
0 |
N |
|
DP_UD21 |
User Data Field |
31 |
614 |
10 |
Character |
0 |
N |
|
DP_UD22 |
User Data Field |
32 |
624 |
10 |
Character |
0 |
N |
|
DP_UD23 |
User Data Field |
33 |
634 |
10 |
Character |
0 |
N |
|
DP_UD24 |
User Data Field |
34 |
644 |
10 |
Character |
0 |
N |
|
DP_UD25 |
User Data Field |
35 |
654 |
10 |
Character |
0 |
N |
|
DP_UD26 |
User Data Field |
36 |
664 |
10 |
Character |
0 |
N |
|
DP_UD27 |
User Data Field |
37 |
674 |
10 |
Character |
0 |
N |
|
DP_UD28 |
User Data Field |
38 |
684 |
10 |
Character |
0 |
N |
|
DP_UD29 |
User Data Field |
39 |
694 |
10 |
Character |
0 |
N |
|
DP_UD30 |
User Data Field |
40 |
704 |
10 |
Character |
0 |
N |
|
DP_UD31 |
User Data Field |
41 |
714 |
10 |
Character |
0 |
N |
|
DP_UD32 |
User Data Field |
42 |
724 |
10 |
Character |
0 |
N |
|
DP_UD33 |
User Data Field |
43 |
734 |
10 |
Character |
0 |
N |
|
DP_UD34 |
User Data Field |
44 |
744 |
10 |
Character |
0 |
N |
|
DP_UD35 |
User Data Field |
45 |
754 |
10 |
Character |
0 |
N |
|
DP_UD36 |
User Data Field |
46 |
764 |
10 |
Character |
0 |
N |
|
DP_UD37 |
User Data Field |
47 |
774 |
10 |
Character |
0 |
N |
|
DP_UD38 |
User Data Field |
48 |
784 |
10 |
Character |
0 |
N |
|
DP_UD39 |
User Data Field |
49 |
794 |
10 |
Character |
0 |
N |
|
DP_UD40 |
User Data Field |
50 |
804 |
10 |
Character |
0 |
N |
|
DP_UD41 |
User Data Field |
51 |
814 |
21 |
Number |
4 |
N |
|
DP_UD42 |
User Data Field |
52 |
835 |
21 |
Number |
4 |
N |
|
DP_UD43 |
User Data Field |
53 |
856 |
21 |
Number |
4 |
N |
|
DP_UD44 |
User Data Field |
54 |
877 |
21 |
Number |
4 |
N |
|
DP_UD45 |
User Data Field |
55 |
898 |
21 |
Number |
4 |
N |
|
DP_UD46 |
User Data Field |
56 |
919 |
21 |
Number |
4 |
N |
|
DP_UD47 |
User Data Field |
57 |
940 |
21 |
Number |
4 |
N |
|
DP_UD48 |
User Data Field |
58 |
961 |
21 |
Number |
4 |
N |
|
DP_UD49 |
User Data Field |
59 |
982 |
21 |
Number |
4 |
N |
|
DP_UD50 |
User Data Field |
60 |
1003 |
21 |
Number |
4 |
N |
Demand History FieldsThis table describes the fields and their processing order for demand history data for all layout types:
|
Field Loaded |
Field Description |
Field Seq. |
Field Start |
Field Length |
Field Type |
Decimal |
Required |
|
RECORD IDENTIFIER (Always 100) |
Record ID |
0 |
1 |
3 |
Number |
0 |
Y |
|
DP_YEAR |
Year |
1 |
4 |
4 |
Number |
0 |
Y if demand date is not supported |
|
DP_PERIOD |
Period |
2 |
8 |
2 |
Number |
0 |
Y if demand date is not supported |
|
DP_DEMANDDATE |
Date |
3 |
10 |
10 |
Date |
0 |
Y if year and period are not supported |
|
DP_ACTLDEMAND_STR |
Actual Demand |
4 |
20 |
16 |
Character |
0 |
N |
|
DP_ADJDEMAND_STR |
Adjusted Demand |
5 |
36 |
15 |
Character |
0 |
N |
|
DP_DEMANDVALUE_STR |
Value |
6 |
51 |
15 |
Character |
0 |
N |
|
DP_DEMANDUOM |
UOM |
7 |
66 |
3 |
Character |
0 |
N If not supplied, assumed to be base UOM |
|
DP_DMD_COMMENT |
Comment |
8 |
69 |
50 |
Character |
0 |
N |
|
DP_ITEMCODE |
Item |
9 |
119 |
18 |
Character |
0 |
N |
|
DP_LOCATION |
Location |
10 |
137 |
5 |
Character |
0 |
N |
|
DP_UD01 |
User Data Field |
11 |
142 |
30 |
Character |
0 |
N |
|
DP_UD02 |
User Data Field |
12 |
172 |
30 |
Character |
0 |
N |
|
DP_UD03 |
User Data Field |
13 |
202 |
30 |
Character |
0 |
N |
|
DP_UD04 |
User Data Field |
14 |
232 |
30 |
Character |
0 |
N |
|
DP_UD05 |
User Data Field |
15 |
262 |
30 |
Character |
0 |
N |
|
DP_UD06 |
User Data Field |
16 |
292 |
30 |
Character |
0 |
N |
|
DP_UD07 |
User Data Field |
17 |
322 |
30 |
Character |
0 |
N |
|
DP_UD08 |
User Data Field |
18 |
352 |
30 |
Character |
0 |
N |
|
DP_UD09 |
User Data Field |
19 |
382 |
30 |
Character |
0 |
N |
|
DP_UD10 |
User Data Field |
20 |
412 |
30 |
Character |
0 |
N |
|
DP_UD11 |
User Data Field |
21 |
442 |
20 |
Character |
0 |
N |
|
DP_UD12 |
User Data Field |
22 |
462 |
20 |
Character |
0 |
N |
|
DP_UD13 |
User Data Field |
23 |
482 |
20 |
Character |
0 |
N |
|
DP_UD14 |
User Data Field |
24 |
502 |
20 |
Character |
0 |
N |
|
DP_UD15 |
User Data Field |
25 |
522 |
20 |
Character |
0 |
N |
|
DP_UD16 |
User Data Field |
26 |
542 |
20 |
Character |
0 |
N |
|
DP_UD17 |
User Data Field |
27 |
562 |
20 |
Character |
0 |
N |
|
DP_UD18 |
User Data Field |
28 |
582 |
20 |
Character |
0 |
N |
|
DP_UD19 |
User Data Field |
29 |
602 |
20 |
Character |
0 |
N |
|
DP_UD20 |
User Data Field |
30 |
622 |
20 |
Character |
0 |
N |
|
DP_UD21 |
User Data Field |
31 |
642 |
10 |
Character |
0 |
N |
|
DP_UD22 |
User Data Field |
32 |
652 |
10 |
Character |
0 |
N |
|
DP_UD23 |
User Data Field |
33 |
662 |
10 |
Character |
0 |
N |
|
DP_UD24 |
User Data Field |
34 |
672 |
10 |
Character |
0 |
N |
|
DP_UD25 |
User Data Field |
35 |
682 |
10 |
Character |
0 |
N |
|
DP_UD26 |
User Data Field |
36 |
692 |
10 |
Character |
0 |
N |
|
DP_UD27 |
User Data Field |
37 |
702 |
10 |
Character |
0 |
N |
|
DP_UD28 |
User Data Field |
38 |
712 |
10 |
Character |
0 |
N |
|
DP_UD29 |
User Data Field |
39 |
722 |
10 |
Character |
0 |
N |
|
DP_UD30 |
User Data Field |
40 |
732 |
10 |
Character |
0 |
N |
|
DP_UD31 |
User Data Field |
41 |
742 |
10 |
Character |
0 |
N |
|
DP_UD32 |
User Data Field |
42 |
752 |
10 |
Character |
0 |
N |
|
DP_UD33 |
User Data Field |
43 |
762 |
10 |
Character |
0 |
N |
|
DP_UD34 |
User Data Field |
44 |
772 |
10 |
Character |
0 |
N |
|
DP_UD35 |
User Data Field |
45 |
782 |
10 |
Character |
0 |
N |
|
DP_UD36 |
User Data Field |
46 |
792 |
10 |
Character |
0 |
N |
|
DP_UD37 |
User Data Field |
47 |
802 |
10 |
Character |
0 |
N |
|
DP_UD38 |
User Data Field |
48 |
812 |
10 |
Character |
0 |
N |
|
DP_UD39 |
User Data Field |
49 |
822 |
10 |
Character |
0 |
N |
|
DP_UD40 |
User Data Field |
50 |
832 |
10 |
Character |
0 |
N |
|
DP_UD41 |
User Data Field |
51 |
842 |
21 |
Number |
4 |
N |
|
DP_UD42 |
User Data Field |
52 |
863 |
21 |
Number |
4 |
N |
|
DP_UD43 |
User Data Field |
53 |
884 |
21 |
Number |
4 |
N |
|
DP_UD44 |
User Data Field |
54 |
905 |
21 |
Number |
4 |
N |
|
DP_UD45 |
User Data Field |
55 |
926 |
21 |
Number |
4 |
N |
|
DP_UD46 |
User Data Field |
56 |
947 |
21 |
Number |
4 |
N |
|
DP_UD47 |
User Data Field |
57 |
968 |
21 |
Number |
4 |
N |
|
DP_UD48 |
User Data Field |
58 |
989 |
21 |
Number |
4 |
N |
|
DP_UD49 |
User Data Field |
59 |
1010 |
21 |
Number |
4 |
N |
|
DP_UD50 |
User Data Field |
60 |
1031 |
21 |
Number |
4 |
N |
Forecast Item FieldsThis table describes the fields and their processing order for forecast item data for all layout types:
|
Field Loaded |
Field Description |
Field Seq. |
Field Start |
Field Length |
Field Type |
Decimal |
Required |
|
RECORD IDENTIFIER (Always 100) |
Record ID |
0 |
1 |
3 |
Number |
0 |
Y |
|
DP_CONFIGLEVEL |
Level |
1 |
4 |
2 |
Number |
0 |
Y |
|
DP_FCITEMCAPTION |
Caption |
2 |
6 |
40 |
Character |
0 |
N, created from definition if not loaded |
|
DP_CONTROLGROUP |
Control Group |
3 |
46 |
20 |
Character, |
0 |
N, created from template if not loaded |
|
DP_DESCRIPTION |
Description |
4 |
66 |
254 |
Character |
0 |
N, created from definition if not loaded |
|
DP_BASEUOM |
Base UOM |
5 |
320 |
3 |
Character |
0 |
N, created from template if not loaded |
|
DP_WEIGHTUOM |
Weight UOM |
6 |
323 |
3 |
Character |
0 |
N, created from template if not loaded |
|
DP_WEIGHT |
Weight |
7 |
326 |
13 |
Number |
2 |
N, created from template if not loaded |
|
DP_VOLUMEUOM |
Volume UOM |
8 |
339 |
3 |
Character |
0 |
N, created from template if not loaded |
|
DP_VOLUME |
Volume |
9 |
342 |
13 |
Number |
2 |
N, created from template if not loaded |
|
DP_NEXTLEVELUOM |
Next Level UOM |
10 |
355 |
3 |
Character |
0 |
N, created from template if not loaded |
|
DP_NEXTLEVELCONV |
Next Level Conversion Factor |
11 |
358 |
13 |
Number |
2 |
N, created from template if not loaded |
|
DP_STANDARDCOST |
Cost |
12 |
371 |
15 |
Number |
4 |
N |
|
DP_STANDARDPRICE |
Price |
13 |
386 |
15 |
Number |
4 |
N |
|
UTILIZ_CD |
Utilization Code |
14 |
401 |
4 |
Character |
0 |
N |
|
UTILIZ_GROUP |
Utilization Group |
15 |
405 |
4 |
Character |
0 |
N |
|
DP_FORECASTANALYST |
Analyst |
16 |
409 |
20 |
Character |
0 |
N |
|
DP_ITEMCODE |
Item |
17 |
429 |
18 |
Character |
0 |
Y if key field |
|
DP_LOCATION |
Location |
18 |
447 |
5 |
Character |
0 |
Y if key field |
|
DP_UD01 |
User Data Field |
19 |
452 |
30 |
Character |
0 |
N |
|
DP_UD02 |
User Data Field |
20 |
482 |
30 |
Character |
0 |
N |
|
DP_UD03 |
User Data Field |
21 |
512 |
30 |
Character |
0 |
N |
|
DP_UD04 |
User Data Field |
22 |
542 |
30 |
Character |
0 |
N |
|
DP_UD05 |
User Data Field |
23 |
572 |
30 |
Character |
0 |
N |
|
DP_UD06 |
User Data Field |
24 |
602 |
30 |
Character |
0 |
N |
|
DP_UD07 |
User Data Field |
25 |
632 |
30 |
Character |
0 |
N |
|
DP_UD08 |
User Data Field |
26 |
662 |
30 |
Character |
0 |
N |
|
DP_UD09 |
User Data Field |
27 |
692 |
30 |
Character |
0 |
N |
|
DP_UD10 |
User Data Field |
28 |
722 |
30 |
Character |
0 |
N |
|
DP_UD11 |
User Data Field |
29 |
752 |
20 |
Character |
0 |
N |
|
DP_UD12 |
User Data Field |
30 |
772 |
20 |
Character |
0 |
N |
|
DP_UD13 |
User Data Field |
31 |
792 |
20 |
Character |
0 |
N |
|
DP_UD14 |
User Data Field |
32 |
812 |
20 |
Character |
0 |
N |
|
DP_UD15 |
User Data Field |
33 |
832 |
20 |
Character |
0 |
N |
|
DP_UD16 |
User Data Field |
34 |
852 |
20 |
Character |
0 |
N |
|
DP_UD17 |
User Data Field |
35 |
872 |
20 |
Character |
0 |
N |
|
DP_UD18 |
User Data Field |
36 |
892 |
20 |
Character |
0 |
N |
|
DP_UD19 |
User Data Field |
37 |
912 |
20 |
Character |
0 |
N |
|
DP_UD20 |
User Data Field |
38 |
932 |
20 |
Character |
0 |
N |
|
DP_UD21 |
User Data Field |
39 |
952 |
10 |
Character |
0 |
N |
|
DP_UD22 |
User Data Field |
40 |
962 |
10 |
Character |
0 |
N |
|
DP_UD23 |
User Data Field |
41 |
972 |
10 |
Character |
0 |
N |
|
DP_UD24 |
User Data Field |
42 |
982 |
10 |
Character |
0 |
N |
|
DP_UD25 |
User Data Field |
43 |
992 |
10 |
Character |
0 |
N |
|
DP_UD26 |
User Data Field |
44 |
1002 |
10 |
Character |
0 |
N |
|
DP_UD27 |
User Data Field |
45 |
1012 |
10 |
Character |
0 |
N |
|
DP_UD28 |
User Data Field |
46 |
1022 |
10 |
Character |
0 |
N |
|
DP_UD29 |
User Data Field |
47 |
1032 |
10 |
Character |
0 |
N |
|
DP_UD30 |
User Data Field |
48 |
1042 |
10 |
Character |
0 |
N |
|
DP_UD31 |
User Data Field |
49 |
1052 |
10 |
Character |
0 |
N |
|
DP_UD32 |
User Data Field |
50 |
1062 |
10 |
Character |
0 |
N |
|
DP_UD33 |
User Data Field |
51 |
1072 |
10 |
Character |
0 |
N |
|
DP_UD34 |
User Data Field |
52 |
1082 |
10 |
Character |
0 |
N |
|
DP_UD35 |
User Data Field |
53 |
1092 |
10 |
Character |
0 |
N |
|
DP_UD36 |
User Data Field |
54 |
1102 |
10 |
Character |
0 |
N |
|
DP_UD37 |
User Data Field |
55 |
1112 |
10 |
Character |
0 |
N |
|
DP_UD38 |
User Data Field |
56 |
1122 |
10 |
Character |
0 |
N |
|
DP_UD39 |
User Data Field |
57 |
1132 |
10 |
Character |
0 |
N |
|
DP_UD40 |
User Data Field |
58 |
1142 |
10 |
Character |
0 |
N |
|
DP_UD41 |
User Data Field |
59 |
1152 |
21 |
Number |
4 |
N |
|
DP_UD42 |
User Data Field |
60 |
1173 |
21 |
Number |
4 |
N |
|
DP_UD43 |
User Data Field |
61 |
1194 |
21 |
Number |
4 |
N |
|
DP_UD44 |
User Data Field |
62 |
1215 |
21 |
Number |
4 |
N |
|
DP_UD45 |
User Data Field |
63 |
1236 |
21 |
Number |
4 |
N |
|
DP_UD46 |
User Data Field |
64 |
1257 |
21 |
Number |
4 |
N |
|
DP_UD47 |
User Data Field |
65 |
1278 |
21 |
Number |
4 |
N |
|
DP_UD48 |
User Data Field |
66 |
1299 |
21 |
Number |
4 |
N |
|
DP_UD49 |
User Data Field |
67 |
1320 |
21 |
Number |
4 |
N |
|
DP_UD50 |
User Data Field |
68 |
1341 |
21 |
Number |
4 |
N |
User Period Data FieldsThis table describes the fields and their processing order for user period data for all layout types:
|
Field Loaded |
Field Description |
Field Seq. |
Field Start |
Field Length |
Field Type |
Decimal |
Required |
|
RECORD IDENTIFIER (Always 100) |
Record ID |
0 |
1 |
3 |
Number |
0 |
Y |
|
DP_CONFIGLEVEL |
Level |
1 |
4 |
2 |
Number |
0 |
Y |
|
DP_PERIOD |
Period |
2 |
6 |
2 |
Number |
0 |
Y if input date is not supported |
|
DP_YEAR |
Year |
3 |
8 |
4 |
Number |
0 |
Y if input date is not supported |
|
DP_INPUTDATE |
Date |
4 |
12 |
10 |
Date |
0 |
Y if year and period are not supported |
|
DP_USERDATA01 |
User Data |
5 |
22 |
16 |
Signed |
4 |
N |
|
DP_USERDATA02 |
User Data |
6 |
38 |
16 |
Signed |
4 |
N |
|
DP_USERDATA03 |
User Data |
7 |
54 |
16 |
Signed |
4 |
N |
|
DP_USERDATA04 |
User Data |
8 |
70 |
16 |
Signed |
4 |
N |
|
DP_USERDATA05 |
User Data |
9 |
86 |
16 |
Signed |
4 |
N |
|
DP_USERDATA06 |
User Data |
10 |
102 |
16 |
Signed |
4 |
N |
|
DP_USERDATA07 |
User Data |
11 |
118 |
16 |
Signed |
4 |
N |
|
DP_USERDATA08 |
User Data |
12 |
134 |
30 |
Character |
0 |
N |
|
DP_USERDATA09 |
User Data |
13 |
164 |
30 |
Character |
0 |
N |
|
DP_USERDATA10 |
User Data |
14 |
194 |
10 |
Date |
0 |
N |
|
DP_FORECAST01 |
User Forecast |
15 |
204 |
16 |
Signed |
4 |
N |
|
DP_FORECAST02 |
User Forecast |
16 |
220 |
16 |
Signed |
4 |
N |
|
DP_FORECAST03 |
User Forecast |
17 |
236 |
16 |
Signed |
4 |
N |
|
DP_FORECAST04 |
User Forecast |
18 |
252 |
16 |
Signed |
4 |
N |
|
DP_FORECAST05 |
User Forecast |
19 |
268 |
16 |
Signed |
4 |
N |
|
DP_FORECAST06 |
User Forecast |
20 |
284 |
16 |
Signed |
4 |
N |
|
DP_FORECAST07 |
User Forecast |
21 |
300 |
16 |
Signed |
4 |
N |
|
DP_FORECAST08 |
User Forecast |
22 |
316 |
16 |
Signed |
4 |
N |
|
DP_FORECAST09 |
User Forecast |
23 |
332 |
16 |
Signed |
4 |
N |
|
DP_FORECAST10 |
User Forecast |
24 |
348 |
16 |
Signed |
4 |
N |
|
DP_ADJ_REASON |
Adjustment Reason |
25 |
364 |
8 |
Character |
0 |
N |
|
DP_ADJ_COMMENT |
Comment |
26 |
372 |
50 |
Character |
0 |
N |
|
DP_PERIODCOST |
Cost |
27 |
422 |
15 |
Number |
4 |
N |
|
DP_PERIODPRICE |
Price |
28 |
437 |
15 |
Number |
4 |
N |
|
DP_PDCOSTFACTOR |
Cost Factor |
29 |
452 |
17 |
Number |
6 |
N |
|
DP_BASEUOM |
UOM |
30 |
469 |
3 |
Character |
0 |
N |
|
DP_ITEMCODE |
Item |
31 |
472 |
18 |
Character |
6 |
Y if key field |
|
DP_LOCATION |
Location |
32 |
490 |
5 |
Character |
0 |
Y if key field |
|
DP_UD01 |
User Defined Field |
33 |
495 |
30 |
Character |
0 |
N |
|
DP_UD02 |
User Defined Field |
34 |
525 |
30 |
Character |
0 |
N |
|
DP_UD03 |
User Defined Field |
35 |
555 |
30 |
Character |
0 |
N |
|
DP_UD04 |
User Defined Field |
36 |
585 |
30 |
Character |
0 |
N |
|
DP_UD05 |
User Defined Field |
37 |
615 |
30 |
Character |
0 |
N |
|
DP_UD06 |
User Defined Field |
38 |
645 |
30 |
Character |
0 |
N |
|
DP_UD07 |
User Defined Field |
39 |
675 |
30 |
Character |
0 |
N |
|
DP_UD08 |
User Defined Field |
40 |
705 |
30 |
Character |
0 |
N |
|
DP_UD09 |
User Defined Field |
41 |
735 |
30 |
Character |
0 |
N |
|
DP_UD10 |
User Defined Field |
42 |
765 |
30 |
Character |
0 |
N |
|
DP_UD11 |
User Defined Field |
43 |
795 |
20 |
Character |
0 |
N |
|
DP_UD12 |
User Defined Field |
44 |
815 |
20 |
Character |
0 |
N |
|
DP_UD13 |
User Defined Field |
45 |
835 |
20 |
Character |
0 |
N |
|
DP_UD14 |
User Defined Field |
46 |
855 |
20 |
Character |
0 |
N |
|
DP_UD15 |
User Defined Field |
47 |
875 |
20 |
Character |
0 |
N |
|
DP_UD16 |
User Defined Field |
48 |
895 |
20 |
Character |
0 |
N |
|
DP_UD17 |
User Defined Field |
49 |
915 |
20 |
Character |
0 |
N |
|
DP_UD18 |
User Defined Field |
50 |
935 |
20 |
Character |
0 |
N |
|
DP_UD19 |
User Defined Field |
51 |
955 |
20 |
Character |
0 |
N |
|
DP_UD20 |
User Defined Field |
52 |
975 |
20 |
Character |
0 |
N |
|
DP_UD21 |
User Defined Field |
53 |
995 |
10 |
Character |
0 |
N |
|
DP_UD22 |
User Defined Field |
54 |
1005 |
10 |
Character |
0 |
N |
|
DP_UD23 |
User Defined Field |
55 |
1015 |
10 |
Character |
0 |
N |
|
DP_UD24 |
User Defined Field |
56 |
1025 |
10 |
Character |
0 |
N |
|
DP_UD25 |
User Defined Field |
57 |
1035 |
10 |
Character |
0 |
N |
|
DP_UD26 |
User Defined Field |
58 |
1045 |
10 |
Character |
0 |
N |
|
DP_UD27 |
User Defined Field |
59 |
1055 |
10 |
Character |
0 |
N |
|
DP_UD28 |
User Defined Field |
60 |
1065 |
10 |
Character |
0 |
N |
|
DP_UD29 |
User Defined Field |
61 |
1075 |
10 |
Character |
0 |
N |
|
DP_UD30 |
User Defined Field |
62 |
1085 |
10 |
Character |
0 |
N |
|
DP_UD31 |
User Defined Field |
63 |
1095 |
10 |
Character |
0 |
N |
|
DP_UD32 |
User Defined Field |
64 |
1105 |
10 |
Character |
0 |
N |
|
DP_UD33 |
User Defined Field |
65 |
1115 |
10 |
Character |
0 |
N |
|
DP_UD34 |
User Defined Field |
66 |
1125 |
10 |
Character |
0 |
N |
|
DP_UD35 |
User Defined Field |
67 |
1135 |
10 |
Character |
0 |
N |
|
DP_UD36 |
User Defined Field |
68 |
1145 |
10 |
Character |
0 |
N |
|
DP_UD37 |
User Defined Field |
69 |
1155 |
10 |
Character |
0 |
N |
|
DP_UD38 |
User Defined Field |
70 |
1165 |
10 |
Character |
0 |
N |
|
DP_UD39 |
User Defined Field |
71 |
1175 |
10 |
Character |
0 |
N |
|
DP_UD40 |
User Defined Field |
72 |
1185 |
10 |
Character |
0 |
N |
|
DP_UD41 |
User Defined Field |
73 |
1195 |
21 |
Number |
4 |
N |
|
DP_UD42 |
User Defined Field |
74 |
1216 |
21 |
Number |
4 |
N |
|
DP_UD43 |
User Defined Field |
75 |
1237 |
21 |
Number |
4 |
N |
|
DP_UD44 |
User Defined Field |
76 |
1258 |
21 |
Number |
4 |
N |
|
DP_UD45 |
User Defined Field |
77 |
1279 |
21 |
Number |
4 |
N |
|
DP_UD46 |
User Defined Field |
78 |
1300 |
21 |
Number |
4 |
N |
|
DP_UD47 |
User Defined Field |
79 |
1321 |
21 |
Number |
4 |
N |
|
DP_UD48 |
User Defined Field |
80 |
1342 |
21 |
Number |
4 |
N |
|
DP_UD49 |
User Defined Field |
81 |
1363 |
21 |
Number |
4 |
N |
|
DP_UD50 |
User Defined Field |
82 |
1384 |
21 |
Number |
4 |
N |
Fields Published to Inventory ForecastWhen you create publish specifications with an internal target, you select to publish either an item or a product forecast. After publishing this forecast, you use the Update Forecast Data feature to write the published data back to the FORECAST_INV record in the PeopleSoft SCM database. Changes you make are not reflected back in the PeopleSoft Demand Planning system, and can be overwritten the next time you run the update.
This table describes fields you can use to populate the FORECAST_INV record:
|
FORECAST_INV Field Name |
PeopleSoft Demand Planning Record Name |
Description |
|
FORECAST_SET |
User entered. |
The default is the publish name that was used to generate this record. The user can override this during the Update Forecast Data process. |
|
BUSINESS_UNIT |
DP_FCITEMS.DP_LOCATION |
Extracted from forecast item. |
|
INV_ITEM_ID |
DP_FCITEMDATA.ITEMCODE |
Extracted from forecast item. |
|
FORECAST_DATE |
DP_CALPERIODS. DP_DATE |
Start Date of the period on the DP_FCITEMDATA record generating this record. |
|
FORECAST_TIME |
System assigned. |
Current item. |
|
QTY_FORECAST |
DP_FCITEMDATA DP_STATFORECAST DP_PROFORECAST DP_ADJFORECAST DP_SUMMFORECAST DP_EVALSTATFORE DP_EVALPROFORE DP_EVALADJFORE DP_USERDATA01 - 07 DP_FORECAST01 - 10 |
FORECAST field selected by the user * InvUOMConvFactor |
|
DP_PUBLISHNAME |
DP_FCITEMDATA |
Publish name used to generate this record. This field along with the publish date provides a unique key back to the publish that was used to generate this record. |
|
DP_PUBLISH_DATE |
DP_FCITEMDATA |
Publish date used to generate this record. |
Fields Published to Product ForecastWhen you create publish specifications with a target of PeopleSoft SCM, you select to publish either an item or a product forecast. After publishing the forecast, you published data back to the FORECAST_PROD record in the PeopleSoft SCM database. Any modifications made through this process, are not reflected back in the PeopleSoft Demand Planning system, and can be overwritten the next time you run the update.
This table describes fields you can use to populate the FORECAST_PROD record:
|
FORECAST_PROD Field Name |
PeopleSoft Demand Planning Record Name |
Description |
|
FORECAST_SET |
User entered. |
The default is the publish name that was used to generate this record. The user can override this during the Update Forecast Data process. |
|
BUSINESS_UNIT |
DP_FCITEMS.DP_UD01– 50. |
The user data code that is mapped to BUS_UNIT_OM will be loaded into this field. |
|
INV_ITEM_ID |
DP_FCITEMDATA.DP_UD01 – 50 |
The user data code that is mapped to the PRODUCT_ID will be loaded into this field. |
|
FORECAST_DATE |
DP_CALPERIODS. DP_DATE |
Start Date of the of the period that is on the DP_FCITEMDATA record being generating this record. |
|
FORECAST_TIME |
System assigned. |
Current Time. |
|
QTY_FORECAST |
DP_FCITEMDATA DP_STATFORECAST DP_PROFORECAST DP_ADJFORECAST DP_SUMMFORECAST DP_EVALSTATFORE DP_EVALPROFORE DP_EVALADJFORE DP_USERDATA01 – 07 DP_FORECAST01 – 10 |
FORECAST Field Selected by the user * InvUOMConvFactor |
|
DP_PUBLISHNAME |
DP_FCITEMDATA |
Publish Name used to generate this record. This field along with the Publish date provides a unique key back to the publish that was used to generate this record. |
|
DP_PUBLISH_DATE |
DP_FCITEMDATA |
Publish Date used to generate this record. |
Fields Published for Use as External DataThis section discusses:
Fields published to the DP_PUB_FCAST record.
Fields published to the DP_PUB_FCASTKEY record.
Fields published to the DP_PUB_FCITEMS record.
Fields published to the DP_PUB_FCITEMS2 record.
Fields published to the DP_PUB_FCITDATA record.
Fields published to the DP_PUB_FCIT_EXT record.
Fields published to the DP_PUB_FCIT_WGT record.
Fields Published to the DP_PUB_FCAST Record
This table describes fields that are published to the DP_PUB_FCAST record:
|
Field Name |
Populated From |
Description |
|
DP_PUBLISHNAME |
User entered. |
Key: View name is the default value. User enters this during the publish process |
|
DP_PUBLISH_DATE |
User entered. |
Key: Current date is default value. User enters this during the publish process. |
|
DP_DESCRIPTION |
User entered. |
User enters this during the publish process. |
|
DP_CONFIGVIEW |
DP_FCITEMS.CONFIGVIEW |
Extracted from forecast item. |
|
DP_CONFIGLEVEL |
DP_FCITEMS.DP_CONFIGLEVEL |
Extracted from forecast item. |
|
DP_STATISTICALATTR |
Y or N |
Are statistical attributes Published? |
|
DP_DAILYWEIGHTS |
Y or N |
Are Daily Weights Published? |
|
DP_USERFIELD |
Y or N |
Are User defined Fields published? |
|
DP_CALENDARID |
DP_CONFIGVIEWS.DP_CALENDAR_ID |
Calendar ID from the forecast view, for the forecast item being published. |
|
DP_PUBTIEMPERIODCD |
DP_PUBSPEC_HDR.DP_TIMEPERIODCODE |
This is the time period the forecast is being published in. It may differ from the time period code of the view. |
|
DP_TIMEPERIODCODE |
DP_CONFIGVIEWS.DP_TIMEPERIODCODE |
This is the time period code of the forecast view. |
|
DP_PUBLISHUOM |
User entered. |
If DP_PUBSPEC.HDR.DP_FCCONVUNIT = 3 (Alternate) then DP_PUBLISHUOM = DP_PUBSPEC.HDR.DP_PUB_ALTUOM If DP_PUBSPEC.HDR.DP_FCCONVUNIT = 4 (UOM Group) then DP_PUBLISHUOM = DP_PUBSPEC.HDR.DP_UOMGROUP Else DP_PUBLISHUOM = blank for the rest of the UOMs |
|
DP_CONVTOINVUOM |
Y or N |
Y= Fcst Quantities can be converted to INV UOM's using the forecast item Conversion Factor.N=Fcst Quantities are not convertible to Inv Standard UOM. |
|
DP_LASTUPDATED |
System Assigned |
|
Fields Published to the DP_PUB_FCASTKEY Record
This table describes fields that are published to the DP_PUB_FCASTKEY record:
|
Field Name |
Populated From |
Description |
|
DP_PUBLISHNAME |
User entered. |
Key: View name is the default value. User enters this during the publish process |
|
DP_PUBLISH_DATE |
User entered. |
Key: Current date is default value. User enters this during the publish process. |
|
DP_SEQNUMBER |
DP_CONFIGLVLFLD.DP_CONFIGFIELDSEQ |
A key field. |
|
DP_FIELDID |
DP_CONFIGLVLFLD.DP_FIELDID |
Contain the field name that the data was actually written to. Item, Location, UD01-UD50 or the actual field name such as Product ID. |
Fields Published to the DP_PUB_FCITEMS Record
This table describes fields that are published to the DP_PUB_FCITEMS record:
|
Field Name |
Populated From DP_FCITEMS |
Description |
|
DP_PUBLISHNAME |
User entered. |
Key: View name is the default value. User enters this during the publish process |
|
DP_PUBLISH_DATE |
User entered. |
Key: Current date is default value. User enters this during the publish process. |
|
DP_FORECASTITEM |
DP_FORECASTITEM |
A key field. |
|
DP_FCITEMCAPTION |
DP_FCITEMCAPTION |
Extracted from forecast item. |
|
DP_DESCRIPTION |
User entered. |
User enters during the publish process. |
|
DP_CONTROLGROUP |
DP_CONTROLGROUP |
Extracted from forecast item. |
|
DP_SEASONALITYPROF |
DP_SEASONALITYPROF |
Extracted from forecast item. |
|
DP_BASEUOM |
DP_BASEUOM |
Extracted from forecast item. |
|
DP_STDUOMCONVFACTOR |
System assigned |
Conversion factor that can be used to convert the published quantities from the publish UOM to the standard inventory UOM. |
|
DP_WEIGHT |
DP_WEIGHT |
Extracted from forecast item. |
|
DP_WEIGHTUOM |
DP_WEIGHTUOM |
Extracted from forecast item. |
|
DP_VOLUME |
DP_VOLUME |
Extracted from forecast item. |
|
DP_VOLUMEUOM |
DP_VOLUMEUOM |
Extracted from forecast item. |
|
DP_CONVFACTOR |
System assigned. |
Conversion factor that can be used to convert the published quantities back to the forecast item base UOM. |
|
DP_NEXTLEVELUOM |
DP_NEXTLEVELUOM |
Extracted from forecast item. |
|
DP_NEXTLEVELCONV |
DP_NEXTLEVELCONV |
Extracted from forecast item. |
|
DP_NEXTFCITEM |
DP_NEXTFCITEM |
Extracted from forecast item. |
|
DP_STANDARDCOST |
DP_STANDARDOCST |
Extracted from forecast item. |
|
DP_STANDARDPRICE |
DP_STANDARDPRICE |
Extracted from forecast item. |
|
DP_AVGPRICE |
DP_AVGPRICE |
Extracted from forecast item. |
|
DP_UTILIZ_CD |
DP_UTILIZ_CD |
Extracted from forecast item. |
|
DP_UTILZ_GROUP |
DP_UTLIZ_GROUP |
Extracted from forecast item. |
|
DP_FORECASTANALYST |
DP_FORECASTANALYST |
Extracted from forecast item. |
|
DP_STATFOREDEV |
DP_STATFOREDEV |
Extracted from forecast item. |
|
DP_PRORATEDFOREDEV |
DP_PRORATEDFOREDEV |
Extracted from forecast item. |
|
DP_ADJFOREDEV |
DP_ADJFOREDEV |
Extracted from forecast item. |
|
DP_CURRENTMODELPD |
DP_CURRENTMODELPD |
Extracted from forecast item. |
|
DP_CURRENTMODELYR |
DP_CURRENTMODELYR |
Extracted from forecast item. |
|
DP_FC_YEAR |
DP_FC_YEAR |
Extracted from forecast item. |
|
DP_FC_EFFPD |
DP_FC_EFFPD |
Extracted from forecast item. |
|
DP_LIFEPROFILE |
DP_LIFEPROFILE |
Extracted from forecast item. |
|
DP_WEIGHTPROFILE |
DP_WEIGHTPROFILE |
Extracted from forecast item. |
|
DP_ITEMCODE |
DP_ITEMCODE |
Extracted from forecast item. |
|
DP_LOCATION |
DP_LOCATION |
Extracted from forecast item. |
|
DP_INHIBITED |
DP_INHIBITED |
Extracted from forecast item. |
|
DP_DEMAND_AVERAGE |
DP_DEMAND_AVERAGE |
Extracted from forecast item. |
|
DP_KEYFLDNAMES |
DP_CONFIGLVLFLD.DP_FIELDID |
This contains a list of field names that are used to compose the forecast item key, for the forecast view and level being published. (item:location:productid) |
|
BILL_TO_CUST_ID |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
BUSINESS_UNIT_BI |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
BUSINESS_UNIT_IN |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
BUSINESS_UNIT_OM |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
CATEGORY_ID |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
CLASSIFICATION_INFO |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
CM_UNIT_COST |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
CONVERSION_RATE |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
CORPORATE_CUST_ID |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
CURRENCY_CD |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
CUSTOMER_GROUP |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
CUST_CHANNEL |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
CUST_FIELD_C10 A - D |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
CUST_FIELD_C2, C4, C6, C8 |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
CUST_FIELD_C30 A - D |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
INVOICE_NUMBER |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
INV_ITEM_COLOR |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
INV_ITEM_GROUP |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
INV_ITEM_ID |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
INV_ITEM_TYPE |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
INV_PROD_FAM_CD |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
ITEM_FIELD_C10 A - D |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
ITEM_FIELD_C1 A - D |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
ITEM_FIELD_C2, C4, C6, C8 |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
ITEM_FIELD_C30 A - D |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
MITBL_DESCR |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
PM_DIVISION |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
PM_TERRITORY |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
PM_REGION |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
PRDITEM_DESCR |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
PRICE_PROGRAM |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
PROD_BRAN D |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
PROD_CATEGORY |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
PROD_FIELD_C10 A - D |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
PROD_FIELD_C2, C4, C6, C8 |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
PROD_FIELD_C1 A - D |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
PROD_FIELD_C30 A - D |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
PRODUCT_GROUP |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
REGION_CD |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
SETID |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
SHIP_TO_CUST_ID |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
SOLD_TO_CUST_ID |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
SOURCE_CD |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
SUBCUST_QUAL1 |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
SUBCUST_QUAL2 |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
UPC_ID |
DP_UD01 – 50 |
If one of the user defined fields is mapped to this field, then it will be populated with the field value from the forecast item record. If none of the user defined fields are mapped to this field, then the field will be blank at publish. |
|
DP_PERIODCREATED |
DP_PERIODCREATED |
Extracted from forecast item. |
|
DP_USESSEASONPROF |
DP_USESSEASONPROF |
Extracted from forecast item. |
|
DP_CALCULATIONTYPE |
DP_CALCULATIONTYPE |
Field Values are: 0 - Best Fit 1 - Reoptimize 3 - No Calculation |
|
DP_SUSPENDEDITEM |
DP_SUSPENDEDITEM |
Extracted from forecast item. |
|
DP_FCMETHOD |
DP_FCMETHOD |
Field Values are: 0 - No Model Selected 4 - Moving Average 5 - Exponential Smoothing 6 - Linear Regression 7 - Adaptive Exponential Smoothing 8 - Dbl Exponential Smoothing - Br 9 - Dbl Exponential Smoothing - Ho 10 - Tpl Exponential Smoothing - Br 14 - Holt Winters 15 - Weighted Moving Average 18 - Box Jenkins/ARIMA 19 - Census X11 24 Croston |
|
DP_YEARCREATED |
DP_YEARCREATED |
Extracted from forecast item. |
|
DP_LASTRESETPD |
DP_LASTRESETPD |
Extracted from forecast item. |
|
DP_LASTERESETYR |
DP_LASTRESETYR |
Extracted from forecast item. |
|
DP_DETSEASPROFILE |
DP_DETSEASPROFILE |
Extracted from forecast item. |
|
DP_HISTDEMANDPDS |
DP_HISTDEMANDPDS |
Extracted from forecast item. |
|
DP_TEMPATEITEM |
DP_TEMPLATEITEM |
Extracted from forecast item. |
|
DP_EVALPERIODS |
DP_EVALPERIODS |
Extracted from forecast item. |
|
DP_EFFDEMANDPDS |
DP_EFFDEMANDPDS |
Extracted from forecast item. |
|
DP_LIFEPROFILEITEM |
DP_LIFEPROFILEITEM |
Extracted from forecast item. |
|
DP_PRORATE |
DP_PRORATE |
Extracted from forecast item. |
|
DP_AUDITREVIEWDONE |
DP_AUDITREVIEWDONE |
Extracted from forecast item. |
|
DP_ROUNDDECIMALS |
DP_ROUNDDECIMALS |
Extracted from forecast item. |
|
DP_ROLLBACKPERIODS |
DP_ROLLBACKPERIODS |
Extracted from forecast item. |
|
DP_SEASONALITYTYPE |
DP_SEASONALITYTYPE |
Extracted from forecast item. |
|
DP_LASTEVALPDS |
DP_LASTEVALPDS |
Extracted from forecast item. |
|
DP_UPDATETOINVPOL |
DP_UPDATETOINVPOL |
Extracted from forecast item. |
Fields Published to the DP_PUB_FCITEMS2 Record
This table describes fields that are published to the DP_PUB_FCITEMS2 record:
|
Field Name |
Populated From |
Description |
|
DP_PUBLISHNAME |
User entered. |
Key: View name is the default value. User enters this during the publish process |
|
DP_PUBLISH_DATE |
User entered. |
Key: Current date is default value. User enters this during the publish process. |
|
DP_FORECASTITEM |
DP_FORECASTITEM |
Key. Extracted from forecast item. |
|
DP_UD01 – 50 |
DP_UD01 – 50 |
All 50 user defined fields will be written. |
|
DP_SUMMGROUP |
DP_SUMMGROUP |
Extracted from forecast item. |
|
DP_LASTCHANGEDATE |
DP_LASTCHANGEDATE |
Extracted from forecast item. |
Fields Published to the DP_PUB_FCITDATA Record
This table describes fields that are published to the DP_PUB_FCITDATA record:
|
Field Name |
Populated From DP_FCITEMDATA |
Description |
|
DP_PUBLISHNAME |
User entered. |
Key: View name is the default value. User enters this during the publish process |
|
DP_PUBLISH_DATE |
User entered. |
Key: Current date is default value. User enters this during the publish process. |
|
DP_FORECASTITEM |
DP_FORECASTITEM |
Key |
|
DP_STARTDATE |
System assigned. |
A key field. Start date of the period on the forecast item data record. |
|
DP_ENDDATE |
System Assigned. |
End date of the period on the forecast item data record. |
|
DP_FCST_YEAR |
DP_FCST_YEAR |
Extracted from Forecast Item time phased data. |
|
DP_FCST_PERIOD |
DP_FCST_PERIOD |
Extracted from Forecast Item time phased data. |
|
DP_STATFORECAST |
DP_STATFORECAST |
This field will be converted to the publish time period, and then if applicable, multiplied by the UOM conversion to the publish UOM. |
|
DP_PROFORECAST |
DP_PROFORECAST |
This field will be converted to the publish time period, and then if applicable, multiplied by the UOM conversion to the publish UOM. |
|
DP_ADJFORECAST |
DP_ADJFORECAST |
This field will be converted to the publish time period, and then if applicable, multiplied by the UOM conversion to the publish UOM. |
|
DP_EVALSTATFORE |
DP_EVALSTATFORE |
This field will be converted to the publish time period, and then if applicable, multiplied by the UOM conversion to the publish UOM. |
|
DP_EVALPRORFORE |
DP_EVALPRORFORE |
This field will be converted to the publish time period, and then if applicable, multiplied by the UOM conversion to the publish UOM. |
|
DP_EVALADJFORE |
DP_EVALADJFORE |
This field will be converted to the publish time period, and then if applicable, multiplied by the UOM conversion to the publish UOM. |
|
DP_FORECAST01 – 10 |
DP_FORECAST01 – 10 |
This field will be converted to the publish time period, and then if applicable, multiplied by the UOM conversion to the publish UOM. |
|
DP_ACTUALDEMAND |
DP_ACTUALDEMAND |
This field will be converted to the publish time period, and then if applicable, multiplied by the UOM conversion to the publish UOM. |
|
DP_DEMANDVALUE |
DP_DEMANDVALUE |
This field will be converted to the publish time period, and then if applicable, multiplied by the UOM conversion to the publish UOM. |
|
DP_ADJDEMAND |
DP_ADJDEMAND |
This field will be converted to the publish time period, and then if applicable, multiplied by the UOM conversion to the publish UOM. |
|
DP_DEMANDCOMMENT |
DP_DEMANDCOMMENT |
Extracted from Forecast Item time phased data. |
|
DP_FORECASTADJ |
DP_FORECASTADJ |
This field will be converted to the publish time period, and then if applicable, multiplied by the UOM conversion to the publish UOM. |
|
DP_FC_PROCESS_ACT |
DP_FC_PROCESS_ACT |
Extracted from Forecast Item time phased data. |
|
DP_FORECASTCOMMENT |
DP_FORECASTCOMMENT |
Extracted from Forecast Item time phased data. |
|
DP_SUMMFORECAST |
DP_SUMMFORECAST |
This field will be converted to the publish time period, and then if applicable, multiplied by the UOM conversion to the publish UOM. |
|
DP_PERIODPRICE |
DP_PERIODPRICE |
Extracted from Forecast Item time phased data. |
|
DP_PERIODCOST |
DP_PERIODCOST |
Extracted from Forecast Item time phased data. |
|
DP_AVGPRICE |
DP_AVGPRICE |
Extracted from Forecast Item time phased data. |
|
DP_MAPESTAT |
DP_MAPESTAT |
This field will be converted to the publish time period, and then if applicable, multiplied by the UOM conversion to the publish UOM. |
|
DP_MAPEPROR |
DP_MAPEPROR |
This field will be converted to the publish time period, and then if applicable, multiplied by the UOM conversion to the publish UOM. |
|
DP_MAPEADJ |
DP_MAPEADJ |
This field will be converted to the publish time period, and then if applicable, multiplied by the UOM conversion to the publish UOM. |
|
DP_MAPEEVALSTAT |
DP_MAPEEVALSTAT |
This field will be converted to the publish time period, and then if applicable, multiplied by the UOM conversion to the publish UOM. |
|
DP_MAPEEVALPROR |
DP_MAPEEVALPROR |
This field will be converted to the publish time period, and then if applicable, multiplied by the UOM conversion to the publish UOM. |
|
DP_MAPEEVALADJ |
DP_MAPEEVALADJ |
This field will be converted to the publish time period, and then if applicable, multiplied by the UOM conversion to the publish UOM. |
|
DP_USERDATA01 – 10 |
DP_USERDATA01 – 10 |
This field will be converted to the publish time period, and then if applicable, multiplied by the UOM conversion to the publish UOM. Only the numeric, DP_UD01 – 07, are convertible. |
Fields Published to the DP_PUB_FCIT_EXT Record
This table describes fields that are published to the DP_PUB_FCIT_EXT record:
|
Field Name |
Populated From DP_FCITEMS |
Description |
|
DP_PUBLISHNAME |
User entered. |
Key: View name is the default value. User enters this during the publish process |
|
DP_PUBLISH_DATE |
User entered. |
Key: Current date is default value. User enters this during the publish process. |
|
DP_FORECASTITEM |
DP_FORECASTITEM |
Key |
|
DP_MEAN_ERROR |
DP_MEAN_ERROR |
Extracted from forecast item data. |
|
DP_MEANABSERROR |
DP_MEANABSERROR |
Extracted from forecast item data. |
|
DP_MOVINGAVERAGE |
DP_MOVINGAVERAGE |
Extracted from forecast item data. |
|
DP_ERRORRATIO |
DP_ERRORRATIO |
Extracted from forecast item data. |
|
DP_TRACKSIGNAL0 – 5 |
DP_TRACKSIGNAL0 – 5 |
Extracted from forecast item data. |
|
DP_ACCURACY_STAT |
DP_ACCURACY_STAT |
Extracted from forecast item data. |
|
DP_MA_ALPHA |
DP_MA_ALPHA |
Extracted from forecast item data. |
|
DP_MA_FINALLEVEL |
DP_MA_FINALLEVEL |
Extracted from forecast item data. |
|
DP_WMA_ALPHA |
DP_WMA_ALPHA |
Extracted from forecast item data. |
|
DP_WMA_FINALLEVEL |
DP_WMA_FINALLEVEL |
Extracted from forecast item data. |
|
DP_LR_ELASTICITY |
DP_LR_ELASTICITY |
Extracted from forecast item data. |
|
DP_LR_FTEST |
DP_LR_FTEST |
Extracted from forecast item data. |
|
DP_LR_INTERCEPT |
DP_LR_INTERCEPT |
Extracted from forecast item data. |
|
DP_LR_SLOPE |
DP_LR_SLOPE |
Extracted from forecast item data. |
|
DP_LR_TTEST1 |
DP_LR_TTEST1 |
Extracted from forecast item data. |
|
DP_LR_TTEST2 |
DP_LR_TTEST2 |
Extracted from forecast item data. |
|
DP_SES_ALPHA |
DP_SES_ALPHA |
Extracted from forecast item data. |
|
DP_SES_FINALLEVEL |
DP_SES_FINALLEVEL |
Extracted from forecast item data. |
|
DP_AES_BETA |
DP_AES_BETA |
Extracted from forecast item data. |
|
DP_DESH_ALPHA |
DP_DESH_ALPHA |
Extracted from forecast item data. |
|
DP_DESH_FINALLEVEL |
DP_DESH_FINALLEVEL |
Extracted from forecast item data. |
|
DP_DESH_FINALTREND |
DP_DESH_FINALTREND |
Extracted from forecast item data. |
|
DP_DESH_GAMMA |
DP_DESH_GAMMA |
Extracted from forecast item data. |
|
DP_TESB_ALPHA |
DP_TESB_ALPHA |
Extracted from forecast item data. |
|
DP_CROSTON_ALPHA |
DP_CROSTON_ALPHA |
Extracted from forecast item data. |
|
DP_HW_ALPHA |
DP_HW_ALPHA |
Extracted from forecast item data. |
|
DP_HW_BETA |
DP_HW_BETA |
Extracted from forecast item data. |
|
DP_HW_FINALLEVEL |
DP_HW_FINALLEVEL |
Extracted from forecast item data. |
|
DP_HW_FINALTREND |
DP_HW_FINALTREND |
Extracted from forecast item data. |
|
DP_HW_GAMA |
DP_HW_GAMA |
Extracted from forecast item data. |
|
DP_AIC |
DP_AIC |
Extracted from forecast item data. |
|
DP_BIC |
DP_BIC |
Extracted from forecast item data. |
|
DP_CHI_SQR |
DP_CHI_SQR |
Extracted from forecast item data. |
|
DP_COCHRANE |
DP_COCHRANE |
Extracted from forecast item data. |
|
DP_DW |
DP_DW |
Extracted from forecast item data. |
|
DP_LJUNG_B OX |
DP_LJUNG_BOX |
Extracted from forecast item data. |
|
DP_ME |
DP_ME |
Extracted from forecast item data. |
|
DP_MAE |
DP_MAE |
Extracted from forecast item data. |
|
DP_NORMALITY |
DP_NORMALITY |
Extracted from forecast item data. |
|
DP_RSQUARE |
DP_RSQUARE |
Extracted from forecast item data. |
|
DP_ADJ_RSQUARE |
DP_ADJ_RSQUARE |
Extracted from forecast item data. |
|
DP_RMSE |
DP_RMSE |
Extracted from forecast item data. |
|
DP_SDE |
DP_SDE |
Extracted from forecast item data. |
|
DP_SSE |
DP_SSE |
Extracted from forecast item data. |
|
DP_X11_TEST |
DP_X11_TEST |
Extracted from forecast item data. |
|
DP_THEIL |
DP_THEIL |
Extracted from forecast item data. |
Fields Published to the DP_PUB_FCIT_WGT Record
This table describes fields that are published to the DP_PUB_FCIT WGT record:
|
Field Name |
Populated From |
Description |
|
DP_PUBLISHNAME |
User entered. |
Key: View name is the default value. User enters this during the publish process |
|
DP_PUBLISH_DATE |
User entered. |
Key: Current date is default value. User enters this during the publish process. |
|
DP_WEIGHTPROFILE |
DP_WEIGHTPROFILE |
A key field. |
|
DP_DATE |
DP_CALPERIODS.DP_DATE |
A key field. |
|
DP_WEIGHT |
DP_CALWEIGHTS.DP_DEMANDWGT1 |
Data extracted from the calendar weights. |