SETIDANALYSIS_GRP_CDPrompt Table: ANALYSIS_GRP_OM
EFFDTFISCAL_YEARFISCAL_MONTHY/N Table Edit
Y/N Table Edit
Y/N Table Edit
FORECAST_DTL_OM(SQL Table) |
Index Back |
|---|---|
OM Forecast DetailThis table is the child of ANALYSIS_GRP_OM, and holds the forecast details by fiscal period. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | ANALYSIS_GRP_CD |
Character(6) | VARCHAR2(6) NOT NULL |
Analysis Group Code
Prompt Table: ANALYSIS_GRP_OM |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 5 | FISCAL_MONTH |
Number(4,0) | SMALLINT NOT NULL | Fiscal Month |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 7 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 8 | QUANTITY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Interface |
| 9 | DEFAULT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Default
Y/N Table Edit |
| 10 | BOOKINGS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Bookings Flag
Y/N Table Edit |
| 11 | SALES_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Sales Flag
Y/N Table Edit |