TrialBalanceLODCacheTotaling

Trial Balance LOD Cache Totaling

Minor Business Rule

Object Name: B0900159

Parent DLL: CFIN

Location: Client/Server

Language: C

Functional Description

Purpose
This function is used in the application P09210A - Trial Balance Ledger Comparison.  Its primary use
is to track LOD account balances and either clear, initialize, load, load and accumulate, load and
retrieve or just retrieve the level of detail and the associated account information, or terminate cache
records.   Associated information includes:  Account Level of Detail(Cache Key), Account Number, Long
Account Number, Account Description, Company, Business Unit, Object Account, Subsidiary, Account
Posting Edit Code and Amounts by level of detail.

Technical Specification

2.1Parameters:

Data Item Data Structure DescriptionI/ORequiredNotes

LDAcAccountLevelOfDetailIReqPass in the
desired account
level of detail,
OR a blank for
the "clear cache"
mode or "terminate
cache" mode.  Used
as the key to the
cache.
AIDszAccountIDI/O
ANIszLongAccountNumberI/O
DESCszAccountDescriptionI/O
COszCompanyI/O
MCUszBusinessUnitI/O
OBJszObjectAccountI/O
SUBszSubsidiaryI/O
PECcPostingEditCodeI/O
AAmnAmount01I/O
AAmnAmount02I/O
AAmnAmount03I/O
AAmnAmount04I/O
AAmnAmount05I/O
AAmnAmount06I/O
AAmnAmount07I/O
AAmnAmount08I/O
AAmnAmount09I/O
AAmnAmount10I/O
EV01cProcessingModeFlagIReq
DL010szLODCacheNameI/OReqA 50-character
string variable
should be null
when passed in the
first time.  The
actual cache name
will be returned
on the initial
call.  This same
cache name should
then be reused
upon subsequent
calls until termi-
nation before
exiting the
program.

2.2Related Tables
Table Table Description

2.3Related Business Functions
Source NameFunction Name


2.4Processing

If cProcessingModeFlag is equal to 'C':
•
Clear the cache of all LOD account information and amounts.

'b7'b7'b7'b7

If cProcessingModeFlag is equal to 'I':
•
Clear the cache of all LOD account information and amounts.
• Then Load the cache with the specified level of detail information and amounts.

'b7'b7'b7'b7

If cProcessingModeFlag is equal to 'L':
•
Load the specified LOD account information and copy amounts from the BSFN data structure to the
specified cache LOD and roll up amounts to all higher LOD buckets (highest = 1).

'b7'b7'b7'b7

If cProcessingModeFlag is equal to 'N':
•
Load the cache with the specified LOD account information and accumulate amounts to the specified
LOD without clearing it first.  Roll up amounts to all higher LOD buckets.

'b7'b7'b7'b7

If cProcessingModeFlag is equal to 'P':
•
Load and retrieve the same LOD record information and amounts from cache, rolling up balances and
clearing down to all lower LOD's (lowest = 9).

'b7'b7'b7'b7

If cProcessingModeFlag is equal to 'R':
•
Retrieve the specified LOD Account information and amounts from cache, clearing down to all lower
LOD's (lowest = 9).

'b7'b7'b7'b7

If cProcessingModeFlag is equal to 'T':
•
Terminate the cache.

'b7'b7'b7'b7

Loading the cache:
•
Determine the Account Level of Detail passed in.
• Copy or add the record information and amounts passed in to LOD cache elements.
• If any amount buckets are non-zero, roll up amounts to cache elements of a higher Account
Level Of Detail.

'b7'b7'b7'b7
Retrieve from LOD cache:
•
String copy or math copy the specified LOD cache elements to the BSFN Data Structure.

'b7'b7'b7'b7

Clearing the cache:
•
Delete cache records beginning at the specified level of detail and ending at the lowest level
of detail 9.

'b7'b7'b7'b7

Terminating the cache:
•
Destroy the cache.  Should be called once before exiting the program.

'b7'b7'b7'b7

Data Structure

D0900159 - Trial Balance LOD Cache Totaling

Parameter Name Data Item Data Type Req/Opt I/O/Both

cAccountLevelOfDetail LDA char REQ INPUT

Pass in the level of detail number.  If calling the cache clear or cache termination functions, pass
in a blank.
^

szAccountID AID char OPT NONE

A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it.

szLongAccountNumber ANI char OPT NONE

A value that identifies an account in the general ledger. Use one of the following formats to enter account numbers:   o  Standard account
number (business unit.object.subsidiary or flex format).   o  Third G/L number (maximum of 25 digits).   o  Account ID number. The number is eight
digits long.     o  Speed code, which is a two-character code that you concatenate to the AAI item SP. You can then enter the code instead of
an account number. The first character of the account number indicates its format. You define the account format in the General Accounting
constants.

szAccountDescription DESC char OPT NONE

A description, remark, name, or address.

szCompany CO char OPT NONE

A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany
transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000
for transaction entries.

szBusinessUnit MCU char OPT NONE

An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units
for which you have no authority.

szObjectAccount OBJ char OPT NONE

The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
subcategories. For example, you can divide the Cost Code for labor into regular time, premium time, and burden. Note: If you use a flexible chart of
accounts and the object account is set to 6 digits, J.D. Edwards recommends that you use all 6 digits. For example, entering 000456 is not
the same as entering 456 because if you enter 456 the system enters three blank spaces to fill a 6-digit object.

szSubsidiary SUB char OPT NONE

A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.

cPostingEditCode PEC char OPT NONE

A code that controls G/L posting and account balance updates in the Account Master table (F0901). Valid values are: Blank Allows all
posting. Posts subledgers in detailed format for every account transaction. Does not require subledger entry. B Only allows posting to budget
ledger types starting with B or J. I Inactive account. No posting allowed. L Subledger and type are required for all transactions. Posts subledgers in
detailed format for every account. The system stores the subledger and type in the Account Ledger (F0911) and Account Balances (F0902)
tables. If you want to report on subledgers in the Financial Reporting feature, use this code. M Machine-generated transactions only (post
program creates offsets). N Non-posting. Does not allow any post or account balance updates. In the Job Cost system, you can still post budget
quantities. S Subledger and type are required for all transactions. Posts subledgers in summary format for every transaction. The system
stores the subledger detail in the Account Ledger table. This code is not valid for budget entry programs. U Unit quantities are required for all
transactions. X Subledger and type must be blank for all transactions. Does not allow subledger entry for the account.

mnAmount01 AA MATH_NUMERIC OPT NONE

A number that identifies the amount that the system will add to the account balance of the associated account number.  Enter credits with a
minus sign (-) either before or after the amount.

mnAmount02 AA MATH_NUMERIC OPT NONE

A number that identifies the amount that the system will add to the account balance of the associated account number.  Enter credits with a
minus sign (-) either before or after the amount.

mnAmount03 AA MATH_NUMERIC OPT NONE

A number that identifies the amount that the system will add to the account balance of the associated account number.  Enter credits with a
minus sign (-) either before or after the amount.

mnAmount04 AA MATH_NUMERIC OPT NONE

A number that identifies the amount that the system will add to the account balance of the associated account number.  Enter credits with a
minus sign (-) either before or after the amount.

mnAmount05 AA MATH_NUMERIC OPT NONE

A number that identifies the amount that the system will add to the account balance of the associated account number.  Enter credits with a
minus sign (-) either before or after the amount.

mnAmount06 AA MATH_NUMERIC OPT NONE

A number that identifies the amount that the system will add to the account balance of the associated account number.  Enter credits with a
minus sign (-) either before or after the amount.

mnAmount07 AA MATH_NUMERIC OPT NONE

A number that identifies the amount that the system will add to the account balance of the associated account number.  Enter credits with a
minus sign (-) either before or after the amount.

mnAmount08 AA MATH_NUMERIC OPT NONE

A number that identifies the amount that the system will add to the account balance of the associated account number.  Enter credits with a
minus sign (-) either before or after the amount.

mnAmount09 AA MATH_NUMERIC OPT NONE

A number that identifies the amount that the system will add to the account balance of the associated account number.  Enter credits with a
minus sign (-) either before or after the amount.

mnAmount10 AA MATH_NUMERIC OPT NONE

A number that identifies the amount that the system will add to the account balance of the associated account number.  Enter credits with a
minus sign (-) either before or after the amount.

cProcessingModeFlag EV01 char REQ INPUT

Enter one of the following processing modes:

C:  To clear the cache of all levels of detail information.
I:  To clear and load the cache with LOD account information.
L:  To load the cache with LOD account information.
N:  To load the cache and accumulate LOD amounts without clearing.
P:  To load and Unload the same record to cache.
R:  To retrieve the specified LOD account information.
T:  To terminate the cache before exiting the program.

^

szLODCacheName DL010 char REQ BOTH

Choose a 50-character string variable.  This variable should be NULL the first time it is passed into
B0900159 "Trial Balance LOD Cache Totaling".  The cache name will be passed back from the business
function into this variable after the initial call.

Thereafter, this same variable holding the value returned for the cache name will need to be passed
into B0900159 "Trial Balance LOD Cache Totaling" on any subsequent calls.

This cache will be used throughout the program and will be destroyed only upon exiting the program
when B0900159 is called in the cache termination mode.
^

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cAccountLevelOfDetail	LDA	char	REQ	INPUT
Pass in the level of detail number. If calling the cache clear or cache termination functions, pass in a blank. ^
szAccountID	AID	char	OPT	NONE
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it.
szLongAccountNumber	ANI	char	OPT	NONE
A value that identifies an account in the general ledger. Use one of the following formats to enter account numbers: o Standard account number (business unit.object.subsidiary or flex format). o Third G/L number (maximum of 25 digits). o Account ID number. The number is eight digits long. o Speed code, which is a two-character code that you concatenate to the AAI item SP. You can then enter the code instead of an account number. The first character of the account number indicates its format. You define the account format in the General Accounting constants.
szAccountDescription	DESC	char	OPT	NONE
A description, remark, name, or address.
szCompany	CO	char	OPT	NONE
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000 for transaction entries.
szBusinessUnit	MCU	char	OPT	NONE
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
szObjectAccount	OBJ	char	OPT	NONE
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into subcategories. For example, you can divide the Cost Code for labor into regular time, premium time, and burden. Note: If you use a flexible chart of accounts and the object account is set to 6 digits, J.D. Edwards recommends that you use all 6 digits. For example, entering 000456 is not the same as entering 456 because if you enter 456 the system enters three blank spaces to fill a 6-digit object.
szSubsidiary	SUB	char	OPT	NONE
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.
cPostingEditCode	PEC	char	OPT	NONE
A code that controls G/L posting and account balance updates in the Account Master table (F0901). Valid values are: Blank Allows all posting. Posts subledgers in detailed format for every account transaction. Does not require subledger entry. B Only allows posting to budget ledger types starting with B or J. I Inactive account. No posting allowed. L Subledger and type are required for all transactions. Posts subledgers in detailed format for every account. The system stores the subledger and type in the Account Ledger (F0911) and Account Balances (F0902) tables. If you want to report on subledgers in the Financial Reporting feature, use this code. M Machine-generated transactions only (post program creates offsets). N Non-posting. Does not allow any post or account balance updates. In the Job Cost system, you can still post budget quantities. S Subledger and type are required for all transactions. Posts subledgers in summary format for every transaction. The system stores the subledger detail in the Account Ledger table. This code is not valid for budget entry programs. U Unit quantities are required for all transactions. X Subledger and type must be blank for all transactions. Does not allow subledger entry for the account.
mnAmount01	AA	MATH_NUMERIC	OPT	NONE
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a minus sign (-) either before or after the amount.
mnAmount02	AA	MATH_NUMERIC	OPT	NONE
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a minus sign (-) either before or after the amount.
mnAmount03	AA	MATH_NUMERIC	OPT	NONE
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a minus sign (-) either before or after the amount.
mnAmount04	AA	MATH_NUMERIC	OPT	NONE
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a minus sign (-) either before or after the amount.
mnAmount05	AA	MATH_NUMERIC	OPT	NONE
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a minus sign (-) either before or after the amount.
mnAmount06	AA	MATH_NUMERIC	OPT	NONE
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a minus sign (-) either before or after the amount.
mnAmount07	AA	MATH_NUMERIC	OPT	NONE
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a minus sign (-) either before or after the amount.
mnAmount08	AA	MATH_NUMERIC	OPT	NONE
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a minus sign (-) either before or after the amount.
mnAmount09	AA	MATH_NUMERIC	OPT	NONE
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a minus sign (-) either before or after the amount.
mnAmount10	AA	MATH_NUMERIC	OPT	NONE
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a minus sign (-) either before or after the amount.
cProcessingModeFlag	EV01	char	REQ	INPUT
Enter one of the following processing modes: C: To clear the cache of all levels of detail information. I: To clear and load the cache with LOD account information. L: To load the cache with LOD account information. N: To load the cache and accumulate LOD amounts without clearing. P: To load and Unload the same record to cache. R: To retrieve the specified LOD account information. T: To terminate the cache before exiting the program. ^
szLODCacheName	DL010	char	REQ	BOTH
Choose a 50-character string variable. This variable should be NULL the first time it is passed into B0900159 "Trial Balance LOD Cache Totaling". The cache name will be passed back from the business function into this variable after the initial call. Thereafter, this same variable holding the value returned for the cache name will need to be passed into B0900159 "Trial Balance LOD Cache Totaling" on any subsequent calls. This cache will be used throughout the program and will be destroyed only upon exiting the program when B0900159 is called in the cache termination mode. ^