AccumulateLODBalances

Level of Detail Totaling Processes

Minor Business Rule

Object Name: B0900065

Parent DLL: CFIN

Location: Client/Server

Language: C

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szLedgerType	LT	char	NONE	NONE
A user defined code (09/LT) that specifies the type of ledger, such as AA (Actual Amounts), BA (Budget Amount), or AU (Actual Units). You can set up multiple, concurrent accounting ledgers within the general ledger to establish an audit trail for all transactions.
szCurrencyCode	CRCD	char	NONE	NONE
A code that identifies the currency of a transaction.
szTextID	DESC	char	NONE	NONE
A description, remark, name, or address.
szDescription	DL01	char	NONE	NONE
A user defined name or remark.
mnAmountONE	AN01	MATH_NUMERIC	NONE	NONE
A number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants table (F0010). The net amount posted is the total of all debits and credits, beginning with the first day of the period through the last day of the period.
mnAmountTWO	AN10	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnAmountTHREE	AN19	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnAmountFOUR	AN28	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnAmountFIVE	AN37	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnLevelOfDetail	MATH01	MATH_NUMERIC	NONE	NONE
- - - Good Performance Low Value.
szCurrencyCodeDenom	CRCX	char	NONE	NONE
A code that indicates the currency in which an amount is denominated.
szSecondDescription	DL09	char	NONE	NONE
A description, remark, name or address.
cPostingEditCode	PEC	char	NONE	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.
mnAmountSIX	AN06	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.

Data Structure

D0900065 - Level of Detail Totaling Processes

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

szLedgerType LT char NONE NONE

A user defined code (09/LT) that specifies the type of ledger, such as AA (Actual Amounts), BA (Budget Amount), or AU (Actual Units). You
can set up multiple, concurrent accounting ledgers within the general ledger to establish an audit trail for all transactions.

szCurrencyCode CRCD char NONE NONE

A code that identifies the currency of a transaction.

szTextID DESC char NONE NONE

A description, remark, name, or address.

szDescription DL01 char NONE NONE

A user defined name or remark.

mnAmountONE AN01 MATH_NUMERIC NONE NONE

A number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants table (F0010). The net amount posted is the total of all debits and credits, beginning with the first day of the period through the last
day of the period.

mnAmountTWO AN10 MATH_NUMERIC NONE NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountTHREE AN19 MATH_NUMERIC NONE NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountFOUR AN28 MATH_NUMERIC NONE NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountFIVE AN37 MATH_NUMERIC NONE NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnLevelOfDetail MATH01 MATH_NUMERIC NONE NONE

- - - Good Performance Low Value.

szCurrencyCodeDenom CRCX char NONE NONE

A code that indicates the currency in which an amount is denominated.

szSecondDescription DL09 char NONE NONE

A description, remark, name or address.

cPostingEditCode PEC char NONE 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.

mnAmountSIX AN06 MATH_NUMERIC NONE NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

Related Functions

None

Related Tables

F09UI009 Trial Balance Generic Work File - OneWorld ONLY

ClearLODBalancesWorkFile
ClearLODBalancesWorkFile

Level of Detail Totaling Processes

Minor Business Rule

Object Name: B0900065

Parent DLL: CFIN

Location: Client/Server

Language: C

This function gets from one to five amounts that have been accumulated for the given level of detail.
When the amount for the level of detail have been retrieved, buckets for that level and all greater
levels of detail will be cleared for the five amounts.  This is designed to be used generically for
any level of detail processing.  See Monetary Accounts Valuation and Trial Balances for examples.
Partial Keys are used depending on the application.  Uniq Key:  JobNo, ComputerID, AccountID, LedgerType,
CurrencyCode, TextID.
AccumulateLODBalances, ClearLODBalancesWF.
^

Data Structure

D0900065 - Level of Detail Totaling Processes

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

szLedgerType LT char NONE NONE

A user defined code (09/LT) that specifies the type of ledger, such as AA (Actual Amounts), BA (Budget Amount), or AU (Actual Units). You
can set up multiple, concurrent accounting ledgers within the general ledger to establish an audit trail for all transactions.

szCurrencyCode CRCD char NONE NONE

A code that identifies the currency of a transaction.

szTextID DESC char NONE NONE

A description, remark, name, or address.

szDescription DL01 char NONE NONE

A user defined name or remark.

mnAmountONE AN01 MATH_NUMERIC NONE NONE

A number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants table (F0010). The net amount posted is the total of all debits and credits, beginning with the first day of the period through the last
day of the period.

mnAmountTWO AN10 MATH_NUMERIC NONE NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountTHREE AN19 MATH_NUMERIC NONE NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountFOUR AN28 MATH_NUMERIC NONE NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountFIVE AN37 MATH_NUMERIC NONE NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnLevelOfDetail MATH01 MATH_NUMERIC NONE NONE

- - - Good Performance Low Value.

szCurrencyCodeDenom CRCX char NONE NONE

A code that indicates the currency in which an amount is denominated.

szSecondDescription DL09 char NONE NONE

A description, remark, name or address.

cPostingEditCode PEC char NONE 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.

mnAmountSIX AN06 MATH_NUMERIC NONE NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

Related Functions

None

Related Tables

F09UI009 Trial Balance Generic Work File - OneWorld ONLY

RetrieveLODBalances
RetrieveLODBalances

Level of Detail Totaling Processes

Minor Business Rule

Object Name: B0900065

Parent DLL: CFIN

Location: Client/Server

Language: C

This function clears all records from the work file F09ui009 for the given full or partial key.  This
is designed to be used generically for any level of detail processing with the functions listed
below.  See Monetary Accounts Valuation and Trial Balances for examples.  Partial Keys are used depending
on the application.  Uniq Key:  JobNo, ComputerID, AccountID, LedgerType, CurrencyCode, TextID.
Accompanying functions:  AccumulateLODBalances, RetrieveLODBalances.
^

Data Structure

D0900065 - Level of Detail Totaling Processes

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

szLedgerType LT char NONE NONE

A user defined code (09/LT) that specifies the type of ledger, such as AA (Actual Amounts), BA (Budget Amount), or AU (Actual Units). You
can set up multiple, concurrent accounting ledgers within the general ledger to establish an audit trail for all transactions.

szCurrencyCode CRCD char NONE NONE

A code that identifies the currency of a transaction.

szTextID DESC char NONE NONE

A description, remark, name, or address.

szDescription DL01 char NONE NONE

A user defined name or remark.

mnAmountONE AN01 MATH_NUMERIC NONE NONE

A number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants table (F0010). The net amount posted is the total of all debits and credits, beginning with the first day of the period through the last
day of the period.

mnAmountTWO AN10 MATH_NUMERIC NONE NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountTHREE AN19 MATH_NUMERIC NONE NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountFOUR AN28 MATH_NUMERIC NONE NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountFIVE AN37 MATH_NUMERIC NONE NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnLevelOfDetail MATH01 MATH_NUMERIC NONE NONE

- - - Good Performance Low Value.

szCurrencyCodeDenom CRCX char NONE NONE

A code that indicates the currency in which an amount is denominated.

szSecondDescription DL09 char NONE NONE

A description, remark, name or address.

cPostingEditCode PEC char NONE 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.

mnAmountSIX AN06 MATH_NUMERIC NONE NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

Related Functions

None

Related Tables

F09UI009 Trial Balance Generic Work File - OneWorld ONLY