ANALYSIS_GRP_OM(SQL Table) |
Index Back |
|---|---|
OM Analysis GroupThis table is used to store Analysis codes which are used when setting up Forecasts and Quotas (child records). This table allows users to set up a code (Analysis Group Code), with Customer or Customer Group, Product or Product Group, or Region combinations. Once the code is established it could be used to set up period forecasts (by month, quarter, etc) in quantity and amounts. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_FS_VW.SETID Prompt Table: SP_SETID_NONVW |
| 2 | ANALYSIS_GRP_CD |
Character(6) | VARCHAR2(6) NOT NULL | Analysis Group Code |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: CUSTOMER |
| 6 | CUSTOMER_GROUP | Character(10) | VARCHAR2(10) NOT NULL |
Customer Group
Prompt Table: CUSTGP_RPT_VW |
| 7 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: PRODITM_NOCA_VW |
| 8 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL |
Product Group
Prompt Table: PRODGP_RPT_VW |
| 9 | REGION_CD | Character(10) | VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table: REGNCD_RPT_VW |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |