ESPGERPLAN - Working File -- 10990

Entry Point: ESPGERPLAN - Working file

Description:

The entry point ESPGERPLAN allows creating a specific ADVPL query or logic to generate the working (TMP) files used by the Managerial Accounting Balance Sheet and Statement reports. By using this entry point, it is possible to apply an optimized (custom) method according to the customer’s configuration, improving report generation performance.

Source Program

CTBXSAL.PRW

Syntax

ESPGERPLAN - Working file ( ) --> cArqTMP

Return
cArqTMP

(array_of_record)

• Working file created with the data for printing.

Notes

SCOPE
Reports (Balance Sheets and Statements) that use the CtGerPlan function.

SYNTAX
ExecBlock('ESPGERPLAN',.F.,.F.,{oMeter,oText,oDlg,lEnd,cArqtmp,dDataIni,dDataFim,cAlias,cIdent,cContaIni,cContaFim,cCCIni,cCCFim,cItemIni,cItemFim,cClvlIni,cClVlFim,cMoeda ,cSaldos,aSetOfBook,cSegmento,cSegIni,cSegFim,cFiltSegm,lNImpMov,lImpConta,nGrupo,cHeader,lImpAntLP,dDataLP,nDivide,lVlrZerado,cFiltroEnt,cCodFilEnt,cSegmentoG,cSegIniG,cSegFimG,cFiltSegmG,lUsGaap,cMoedConv,cConsCrit,dDataConv,nTaxaConv,aGeren,lImpMov,lImpSint,cFilUSU,lRecDesp0,cRecDesp,dDtZeraRD,lImp3Ent,lImp4Ent,lImpEntGer,lFiltraCC,lFiltraIt,lFiltraCV})

Parameters

01 - oMeter = Object, Progress bar control 

02 - oText = Object, Progress bar control 

03 - oDlg = Object, Window 

04 - lEnd = Logical, Progress bar control -> finish 

05 - cArqTmp = Character, Temporary file 

06 - dDataIni = Date, Start date of processing 

07 - dDataFim = Date, End date of processing 

08 - cAlias = Character, File alias 

09 - cIdent = Character, Identifier of the file to be processed 

10 - cContaIni = Character, Starting account 

11 - cContaFim = Character, Ending account 

12 - cCCIni = Character, Starting cost center 

13 - cCCFim = Character, Ending cost center 

14 - cItemIni = Character, Starting item 

15 - cItemFim = Character, Ending item 

16 - cClvlIni = Character, Starting value class 

17 - cClvlFim = Character, Ending value class 

18 - cMoeda = Character, Currency 

19 - cSaldos = Character, Balance types to be processed 

20 - aSetOfBook = Array, Set of books configuration matrix 

21 - cSegmento = Character, Indicates which segment will be filtered 

22 - cSegIni = Character, Segment starting content 

23 - cSegFim = Character, Segment ending content 

24 - cFiltSegm = Character, Filter by segment 

25 - lNImpMov = Logical, Whether to print entities with no transactions 

26 - lImpConta = Logical, Whether to print accounts 

27 - nGrupo = Numeric, Group 

28 - cHeader = Character, Identifies the main entity 

29 - lImpAntLP = Logical, Whether to print previous Profit and Loss entries 

30 - dDataLP = Date, Date of last Profit and Loss calculation 

31 - nDivide = Numeric, Divides values by (100, 1000, 1,000,000) 

32 - lVlrZerado = Logical, Whether to record zero values in the temporary file 

33 - cFiltroEnt = Character, Managerial Entity used as a filter within another entity, e.g.: Cost Center filtered by Accounting Item (CTH) 

34 - cCodFilEnt = Character, Code of the Managerial Entity used as a filter 

35 - cSegmentoG = Character, Filter by managerial segment (CC/Item or ClVl) 

36 - cSegIniG = Character, Starting managerial segment 

37 - cSegFimG = Character, Ending managerial segment 

38 - cFiltSegmG = Character, Managerial segment contained in 

39 - lUsGaap = Logical, Whether it is a currency conversion balance sheet 

40 - cMoedConv = Character, Currency for which the conversion criterion will be retrieved from the Chart of Accounts.

41 - cConsCrit = Character, Conversion criterion used:   1 - Daily, 2 - Average, 3 - Monthly, 4 - Informed, 5 - Chart of Accounts 

42 - dDataConv = Date, Conversion date 

43 - nTaxaConv = Numeric, Conversion rate 

44 - aGeren = Array, Matrix that stores Management Plan elements for report filtering 
5 - lImpMov = Logical, Not used 

46 - lImpSint = Logical, Whether to update summarized accounts 

47 - cFilUSU = Character, User-provided filter 

48 - lRecDesp0 = Logical, Whether to print previous period balance if zero 

49 - cRecDesp = Character, Revenue and expense group 

50 - dDtZeraRD = Date, Date of revenue and expense reset 

51 - lImp3Ent = Logical, Whether it is a Cost Center / Account / Item balance sheet 

52 - lImp4Ent = Logical, Whether it is a balance sheet by CC x Account x Item x Value Class 

53 - lImpEntGer = Logical, Whether it is an Entity balance sheet (Cost Center / Item / Value Class by Managerial Entity) 

54 - lFiltraCC = Logical, Whether to apply question filters for Cost Center 

55 - lFiltraIt = Logical, Whether to apply question filters for Item 

56 - lFiltraCV = Logical, Whether to apply question filters for Value Class

RETURN

cArqTMP = Character, Temporary file created.