FINT_FLDMAP_HD(SQL Table) |
Index Back |
|---|---|
Forecast Interface Map HeaderForecast Interface Map Header |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  MAPID |
Character(3) | VARCHAR2(3) NOT NULL | Map ID |
| 2 | MAPNAME | Character(30) | VARCHAR2(30) NOT NULL | Map Name |
| 3 | DP_FCIP_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
DP_FCIP_OPTION
I=Item Forecast P=Product Forecast Default Value: I |
| 4 | COMPANY_ID | Character(20) | VARCHAR2(20) NOT NULL |
Company ID - Company Tax ID
Prompt Table: FINT_PSLOFLD_VW |
| 5 | FINT_DM_ITEM_CODE | Character(30) | VARCHAR2(30) NOT NULL | DM_ITEM_CODE |
| 6 | FINT_DM_ITEM_DESC | Character(30) | VARCHAR2(30) NOT NULL | DM_ITEM_DESC |
| 7 | FINT_DM_ORG_CODE | Character(30) | VARCHAR2(30) NOT NULL | DM_ORG_CODE |
| 8 | FINT_DM_ORG_DESC | Character(30) | VARCHAR2(30) NOT NULL | DM_ORG_DESC |
| 9 | FINT_DM_SITE_CODE | Character(30) | VARCHAR2(30) NOT NULL | DM_SITE_CODE |
| 10 | FINT_PLANNING_UOM | Character(30) | VARCHAR2(30) NOT NULL | PLANNING_UOM |
| 11 | FINT_PRIMARY_UOM | Character(30) | VARCHAR2(30) NOT NULL |
PRIMARY_UOM
Prompt Table: FINT_PSUOMFD_VW |
| 12 | FINT_SHIPPING_UOM | Character(30) | VARCHAR2(30) NOT NULL |
SHIPPING_UOM
Prompt Table: FINT_PSUOMFD_VW |
| 13 | FINT_VOLUME_UOM | Character(30) | VARCHAR2(30) NOT NULL |
VOLUME_UOM
Prompt Table: FINT_PSVOLFD_VW |
| 14 | FINT_WEIGHT_UOM | Character(30) | VARCHAR2(30) NOT NULL |
WEIGHT_UOM
Prompt Table: FINT_PSWGTFD_VW |
| 15 | FINT_MASTER_ORG | Character(5) | VARCHAR2(5) NOT NULL |
Master Branch for Demantra Integration
Prompt Table: FINT_MSTR_BR_VW |
| 16 | FINT_PRODFAMILY | Character(30) | VARCHAR2(30) NOT NULL |
Product Family
Prompt Table: FINT_PSITFLD_VW |
| 17 | FINT_ITEM_DEF_CAT | Character(30) | VARCHAR2(30) NOT NULL | Item Default |
| 18 | FINT_ITM_CAT_PSFLD | Character(18) | VARCHAR2(18) NOT NULL |
DP_PSAPPS_FIELDID
Prompt Table: FINT_PSITFLD_VW |
| 19 | FINT_CUST_CHANNEL | Character(30) | VARCHAR2(30) NOT NULL | Channel Category Name |
| 20 | FINT_CHANNEL_PSFLD | Character(18) | VARCHAR2(18) NOT NULL |
DP_PSAPPS_FIELDID
Prompt Table: FINT_PSLOFLD_VW |
| 21 | FINT_CUST_DMDCLASS | Character(30) | VARCHAR2(30) NOT NULL | Demand Class Category Name |
| 22 | FINT_DMDCLAS_PSFLD | Character(18) | VARCHAR2(18) NOT NULL |
DP_PSAPPS_FIELDID
Prompt Table: FINT_PSLOFLD_VW |