CFM00100 - CFM Forecast MSTR
SQL Query Builder
21 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| EBS_Forecast_ID | char(15) '' | |||
| Forecast_Description | char(41) '' | |||
| Default_Forecast | tinyint 0 | |||
| Last_Calendar_Date | datetime '1/1/1900' | |||
| Last_Calc_Time | datetime '1/1/1900' | |||
| BankReconcilation | tinyint 0 | |||
| Opening_Balance_Amount | numeric(19,5) 0.00 | |||
| ACTINDX | Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. | int 0 | ||
| RM_Open | tinyint 0 | |||
| RM_Work | tinyint 0 | |||
| RM_Date_Type | smallint 0 | |||
| SOP | tinyint 0 | |||
| SOP_IncludeQuotes | tinyint 0 | |||
| PM_Open | tinyint 0 | |||
| PM_Work | tinyint 0 | |||
| POP | tinyint 0 | |||
| POP_BasedOn | smallint 0 | |||
| Cash_Management_Transact | tinyint 0 | |||
| Week | smallint 0 | |||
| NOTEINDX | numeric(19,5) 0.00 | |||
| DEX_ROW_ID | int auto number (1,1) |
Related Tables
Tables that share columns with CFM00100. Click "Join" to add to your query.