UpdateBalanceAuditTable

Update Balance Audit Work File - (Financial Reporting)

Minor Business Rule

Object Name: B83AUDIT

Parent DLL: CAEC

Location: Client/Server

Language: C

Functional Description

Purpose
Insert records to the Balance Audit worktable (F83UI001). This function is called by the smart field
business functions.
Setup Notes and Prerequisites
Designed for use in a tabular UBE.

Special Logic

Technical Specification

• Fetch from the LineNumber cache.
• Compare the keys for the current record to the keys in the cache.
• If the same, increment line number by one.
• If not the same, delete any existing records from the F83UI001 matching the current key. Set line
number to one.
• Insert a record to the F83UI001.

Data Structure

D83AUDIT - Update Balance Audit Work File - (Financial Reporting)

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szProgramId	PID	char	NONE	NONE
Special Input Expected The system value for ReportName. ^
szVersionId	VRID	char	NONE	NONE
Special Input Expected The system value for VersionName. ^
mnBalanceAuditSectionNumber	BASECN	MATH_NUMERIC	NONE	NONE
Special Input Expected The system value for SectionNumber. ^
mnBalanceAuditColumnNumber	BACOLN	MATH_NUMERIC	NONE	NONE
Special Input Expected The system value for CurrentColumn. ^
mnBalanceAuditRowNumber	BAROWN	MATH_NUMERIC	NONE	NONE
Special Input Expected The system value for CurrentRow. ^
szCompany	CO	char	NONE	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.
szAccountId	AID	char	NONE	NONE
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it.
mnPeriodNumber	PN	MATH_NUMERIC	NONE	NONE
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the General Constants table (F0009), allows the user to define up to 14 accounting periods. See General Ledger Date. The current period number is used to determine posted before and posted after cut off warning messages. It is also used as the default accounting period in the preparation of financial reports.
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.
mnFiscalYear	FY	MATH_NUMERIC	NONE	NONE
A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal year (as defined on the Company Setup form). Specify the year at the end of the first period rather than the year at the end of the fiscal period. For example, a fiscal year begins October 1, 1998 and ends September 30, 1999. The end of the first period is October 31, 1998. Specify the year 98 rather than 99.
szSubledger	SBL	char	NONE	NONE
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an address book number. If you enter a subledger, you must also specify the subledger type.
cSubledgerType	SBLT	char	NONE	NONE
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger editing. On the User Defined Codes form, the second line of the description controls how the system performs editing. This is either hard-coded or user defined. Valid values include: A Alphanumeric field, do not edit N Numeric field, right justify and zero fill C Alphanumeric field, right justify and blank fill
szCurrencyCodeFrom	CRCD	char	NONE	NONE
A code that identifies the currency of a transaction.
szCurrencyCodeDenom	CRCX	char	NONE	NONE
A code that indicates the currency in which an amount is denominated.
mnAmount	AA	MATH_NUMERIC	NONE	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.
mnViewNumber	VWNM	MATH_NUMERIC	OPT	NONE
A number from 1 to 10 that specifies how the system posts records from the Account Ledger table (F0911) to the Cost Analyzer Balances table (F1602). This number also specifies which managerial accounting posting code (PM01 - PM10) in the F0911 table to update as posted. For example, if the view number is 1, then the system updates PM01 with a P when the F0911 record is marked as being posted.
szActivityCode	ACTB	char	OPT	NONE
The aggregation of actions performed within an organization that are useful for purposes of activity-based costing.
szManagerialAnalysisCode1	ABR1	char	OPT	NONE
A cost object code, such as an equipment item number or an address book number. If you enter a cost object code, you must also specify the cost object type. This field functions the same and is validated the same as the subledger field, but the system does not post the data in the cost object code field to the Account Balances file (F0902).
cManagerialAnalysisType1	ABT1	char	OPT	NONE
A code that specifies the type of cost object and the type of editing. Valid types are stored in the Cost Object Types table (F1620) and can be added or modified using the Cost Object Types program (P1620).
szManagerialAnalysisCode2	ABR2	char	OPT	NONE
A cost object code, such as an equipment item number or an address book number. If you enter a cost object code, you must also specify the cost object type. This field functions the same and is validated the same as the subledger field, but the system does not post the data in the cost object code field to the Account Balances file (F0902).
cManagerialAnalysisType2	ABT2	char	OPT	NONE
A code that specifies the type of cost object and the type of editing. Valid types are stored in the Cost Object Types table (F1620) and can be added or modified using the Cost Object Types program (P1620).
szManagerialAnalysisCode3	ABR3	char	OPT	NONE
A cost object code, such as an equipment item number or an address book number. If you enter a cost object code, you must also specify the cost object type. This field functions the same and is validated the same as the subledger field, but the system does not post the data in the cost object code field to the Account Balances file (F0902).
cManagerialAnalysisType3	ABT3	char	OPT	NONE
A code that specifies the type of cost object and the type of editing. Valid types are stored in the Cost Object Types table (F1620) and can be added or modified using the Cost Object Types program (P1620).
szManagerialAnalysisCode4	ABR4	char	OPT	NONE
A cost object code, such as an equipment item number or an address book number. If you enter a cost object code, you must also specify the cost object type. This field functions the same and is validated the same as the subledger field, but the system does not post the data in the cost object code field to the Account Balances file (F0902).
cManagerialAnalysisType4	ABT4	char	OPT	NONE
A code that specifies the type of cost object and the type of editing. Valid types are stored in the Cost Object Types table (F1620) and can be added or modified using the Cost Object Types program (P1620).
mnIdentifierShortItem	ITM	MATH_NUMERIC	OPT	NONE
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and so forth. The item numbers are as follows: o Item Number (short) - An eight-digit, computer-assigned item number o 2nd Item Number - The 25-digit, free-form, user defined alphanumeric item number o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number
mnCenturyFiscalYear	CFY	MATH_NUMERIC	OPT	NONE
A field used to store the century concatenated with the fiscal year.

Related Functions

B9800100 Get Audit Information