CFM Forecast MSTR (CFM00100)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CFM00100

Product: Cash Flow Management (1632)
Series:

Display Name: CFM Forecast MSTR
Physical Name: CFM00100
Technical Name: CFM_Forecast_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1EBS_Forecast_ID SearchForecast IDStringSTR15_Forecast_ID15
2Forecast_Description SearchForecast DescriptionStringSTR4040
3Default_Forecast SearchDefault ForecastBooleanCB_Default_Forecast0
4Last_Calendar_Date SearchLast Calc DateDateDATE6
5Last_Calc_Time SearchLast Calc TimeTimeTM66
6RM SearchRMIntegerPOA_RG_Security_Type0
7BankReconcilation SearchBankReconcilationBooleanCFM_CB_BankRec0
8Opening_Balance_Amount SearchOpening Balance AmountCurrencyDLR17_RBS0_UTR$17
9ACTINDX SearchAccount IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['CFM Forecast MSTR'].ACTINDX AS 'CFM Forecast MSTR-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       CFM00100 AS ['CFM Forecast MSTR']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['CFM Forecast MSTR'].ACTINDX = ['Account Index Master'].ACTINDX
10RM_Open SearchRM OpenBooleanCFM_CB_Receivable_Open0
11PM SearchPMBooleanCFM_CB_Payable0
12RM_Work SearchRM WorkBooleanCFM_CB_Receivable_Work0
13RM_Date_Type SearchRM Date TypeIntegerGB0
14SOP SearchSOPBooleanCFM_CB_SOP0
15Include_Opening_Balance SearchInclude Opening BalanceBooleanCB_Include_Opening_Balance0
16SOP_IncludeQuotes SearchSOP_IncludeQuotesBooleanCFM_CB_IncludeQuotes0
17PM_Open SearchPM OpenBooleanCFM_CB_Payable_Open0
18Opening_Balance_Type SearchOpening Balance TypeIntegerDDL_Opening_Balance_Type0
19PM_Work SearchPM WorkBooleanCFM_CB_Payable_Work0
20CHEKBKID SearchCheckbook IDStringSTR15_Checkbook_ID15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['CFM Forecast MSTR'].CHEKBKID AS 'CFM Forecast MSTR-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CFM00100 AS ['CFM Forecast MSTR']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['CFM Forecast MSTR'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
21POP SearchPOPBooleanCFM_CB_POP0
22POP_BasedOn SearchPOP_BasedOnIntegerCFM_POP_BasedOn0
23Cash_Management_Transact SearchCash Flow Management TransactionBooleanCB_Cash_Management_Transaction0
24Week SearchWeekIntegerINT54
25NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['CFM Forecast MSTR'].NOTEINDX AS 'CFM Forecast MSTR-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       CFM00100 AS ['CFM Forecast MSTR']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['CFM Forecast MSTR'].NOTEINDX = ['Record Notes Master'].NOTEINDX

Leave a Reply

Your email address will not be published. Required fields are marked *