AccumulateAmountByAccountNo

Variance Journal Entry Cache

Minor Business Rule

Object Name: B3100690

Parent DLL: CMFGBASE

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose
This function will accumulate amount by Document Type, account Id and by Debit or Credit .At the end,
it will return sequentially all the accounts with the data kept and the amount calculated.

1.2Setup Notes and Prerequisites
1.3Special Logic

2.Technical Specifications
2.4Processing
If mode = 1

If a record already exists for this document type, account id and this transaction type in the
work file
If the account id is blank verify that the account number matches

Accumulate the amount sent to the amount in the work file

Else

Create a new record for this account and this type with all the data sent

If mode = 2

If HUSERID and HREQUEST are nul,

Retrieve the first record, and send back all parameters, send back the pointers

Else

Retrieve the next record, send back all parameters, send back the pointers

If End of File, send back The End Of File = 1 and free memory.

If mode = 3

Delete all records matching the job number.

Data Structure

D3100690A - Variance Journal Entry Data Structure

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cMode	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cSummarize	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cTransactionType	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
mnAmount	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.
szCostCenter	MMCU	char	OPT	NONE
A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which represent lower-level business units, subordinate to it. For example: o Branch/Plant (MMCU) o Dept A (MCU) o Dept B (MCU) o Job 123 (MCU) Business unit security is based on the higher-level business unit.
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.
szSubledger	SBL	char	OPT	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	OPT	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
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.
szUnitOfMeasure	UM	char	OPT	NONE
A user defined code (00/UM) that identifies the unit of measurement for an amount or quantity. For example, it can represent a barrel, box, cubic meter, liter, hour, and so on.
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.
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.
szAccountNumber	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	DL01	char	OPT	NONE
A user defined name or remark.
mnUnits	U	MATH_NUMERIC	OPT	NONE
The quantity of something that is identified by a unit of measure. For example, it can be the number of barrels, boxes, cubic yards, gallons, hours, and so on.
cCostObjectType1	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).
szCostObject1	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).
cCostObjectType2	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).
szCostObject2	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).
cCostObjectType3	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).
szCostObject3	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).
cCostObjectType4	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).
szCostObject4	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).
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
mnOrderNumber	DOCO	MATH_NUMERIC	OPT	NONE
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry, and so on.
szDocumentType	DCT	char	OPT	NONE
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document types, such as, vouchers, invoices, receipts, and timesheets. The reserved document type prefixes for codes are: P Accounts payable documents R Accounts receivable documents T Time and Pay documents I Inventory documents O Purchase order documents S Sales order documents
cEndOfFile	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
idhCursor	GENLNG	ID	OPT	NONE
General purpose ID variable.
cSuppressErrorMessages	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
szErrorMessageID	DTAI	char	OPT	NONE
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
mnJobNumber	JOBS	MATH_NUMERIC	OPT	NONE
The job number (work station ID) which executed the particular job.
szComputerID	CTID	char	OPT	NONE

szReasonCode	REAC	char	OPT	NONE
A user defined code (31/RC) that indicates the reason for the quantity that was scrapped at this operation.
cSummFlex	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
mnAAITableNumber	ANUM	MATH_NUMERIC	OPT	NONE
A number used to specify sequence and retrieve accounting information.

Related Functions

None

Related Tables

F31UI802 Accumulate Amounts by Account