Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revisionLast revisionBoth sides next revision | ||
gl_excel:parameters [2010/06/18 14:40 UTC] – further explained PosNeg parameter mwolfe | gl_excel:parameters [2014/03/14 14:23 UTC] – add CallRpt function parameters mwolfe | ||
---|---|---|---|
Line 26: | Line 26: | ||
" | " | ||
" | " | ||
- | %fineprint{Used in: [[AvgBal]], [[LineAverage]], | + | %fineprint{Used in: [[AvgBal]], [[FedRptAvgBal]], [[LineAverage]], |
==== BalanceDate ==== | ==== BalanceDate ==== | ||
Line 33: | Line 33: | ||
" | " | ||
" | " | ||
- | %fineprint{Used in: [[Balance]], | + | %fineprint{Used in: [[Balance]], [[FedRptBalance]], [[LineBalance]], |
==== BudgetDate ==== | ==== BudgetDate ==== | ||
The date that represents the **month and year** used to retrieve the budget numbers | The date that represents the **month and year** used to retrieve the budget numbers | ||
Line 39: | Line 39: | ||
" | " | ||
" | " | ||
- | %fineprint{Used in: [[Budget]], [[LineBudget]], | + | %fineprint{Used in: [[Budget]], [[FedRptBudget]], [[LineBudget]], |
==== ColDate ==== | ==== ColDate ==== | ||
- | The date of the user report column created by going to Edit Columns from the Edit User Report form. The date must be manually added in the General Ledger in order for it to work in the Excel function. | + | The date of the user report column created by going to Edit Columns from the Edit User Report form in the General Ledger. The date must be manually added in the General Ledger in order for it to work in the Excel function. |
" | " | ||
" | " | ||
Line 47: | Line 47: | ||
==== ColName ==== | ==== ColName ==== | ||
- | Name of the user report column created by going to Edit Columns from the Edit User Report form. | + | Name of the user report column created by going to Edit Columns from the Edit User Report form in the General Ledger. |
"AVG BAL" | "AVG BAL" | ||
"QTD Average Balance" | "QTD Average Balance" | ||
Line 62: | Line 62: | ||
" | " | ||
| | ||
- | %fineprint{Used in: [[LineAverage]], | + | %fineprint{Used in: [[FedRptAvgBal]], |
+ | |||
+ | ==== Concept ==== | ||
+ | The 8-character alphanumeric Call Report concept code. | ||
+ | " | ||
+ | " | ||
+ | %fineprint{Used in: [[CallRptDescription]], | ||
==== LineCode ==== | ==== LineCode ==== | ||
Line 69: | Line 75: | ||
" | " | ||
%fineprint{Used in: [[LineAverage]], | %fineprint{Used in: [[LineAverage]], | ||
+ | |||
+ | ==== LineNum ==== | ||
+ | The abbreviated federal report line number. | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | %fineprint{Used in: [[FedRptAvgBal]], | ||
+ | |||
==== PosNeg ==== | ==== PosNeg ==== | ||
Limit results to **P**ositive, | Limit results to **P**ositive, | ||
Line 78: | Line 92: | ||
" | " | ||
- | %fineprint{Used in: [[AvgBal]], [[Balance]], | + | %fineprint{Used in: [[AvgBal]], [[Balance]], [[FedRptAvgBal]], |
+ | ==== RptDate ==== | ||
+ | The month-end date that corresponds to the respective Call Report reporting period. | ||
+ | " | ||
+ | " | ||
+ | %fineprint{Used in: [[CallRptValue]]}% | ||
+ | |||
+ | ==== RptName ==== | ||
+ | The name of the federal report (not its description) | ||
+ | " | ||
+ | " | ||
+ | %fineprint{Used in: [[FedRptAvgBal]], | ||
+ | | ||
==== StartDate ==== | ==== StartDate ==== | ||
The date that represents the month and year **from** which to compute the daily average balance (used only with the required AvgBalDate parameter). | The date that represents the month and year **from** which to compute the daily average balance (used only with the required AvgBalDate parameter). | ||
Line 85: | Line 111: | ||
" | " | ||
" | " | ||
- | %fineprint{Used in: [[AvgBal]], [[LineAverageRound]]}% | + | %fineprint{Used in: [[AvgBal]], [[FedRptAvgBal]], [[LineAverageRound]]}% |
==== UserRpt ==== | ==== UserRpt ==== |