Functional Description
This program will update F0902 account balances table according to the period using the key Account ID,
Century, Fiscal Year, Ledger Type, Subledger, Subledger Type, and Currency Code. If an existing F0902
Balance does not exist, then a new record will be created.
Also, this program will create or not create F0911 Account Ledger records based on the Audit Trail - F0911s
processing option that is sent to this program.
1. If the Audit Trail - F0911s processing option is set to a blank, create per period change, then if an audit
trail record exists with the GL date of the period end that record is updated with the new changes. If no F0911
record exists with the Period End GL Date, then a new F0911 record is created.
2. If the Audit Trail - F0911s processing option is set to a '1', create F0911's, then for each change a F0911
record will be created.
3. If the Audit Trail - F0911s processing option is set to a '2', do not create F0911's, then for each change NO
F0911 record will be created.
Also, this program calls X51013 - to calculate projections - create HA ledger types.
D5300011 - G/L Entries from Ledger Types
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szCostCenter | 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
| ||||
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
| ||||
szSubsidiary | SUB | char | OPT | NONE |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. | ||||
szAcctNumber | 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
| ||||
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. | ||||
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
| ||||
szCurrencyCodeFrom | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
jdGLDate | DGCG | JDEDATE | OPT | NONE |
The general ledger date associated with the line item for revenue information. | ||||
mnPeriodNoGeneralLedge | PN | MATH_NUMERIC | OPT | NONE |
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the
| ||||
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
| ||||
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
| ||||
mnFiscalYear1 | FY | MATH_NUMERIC | OPT | 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
| ||||
mnCentury | CTRY | MATH_NUMERIC | OPT | NONE |
The calendar century associated with the year. Enter is the first two digits of
the year. For example, 19 indicates any year beginning with 19
| ||||
mnBatchNumber | ICU | MATH_NUMERIC | OPT | NONE |
A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either
| ||||
szDescription001 | DL01 | char | OPT | NONE |
A user defined name or remark. | ||||
szNameRemark | RMK | char | OPT | NONE |
A generic field that you use for a remark, description, name, or address. | ||||
szReference2 | R2 | char | OPT | NONE |
A number that provides an audit trail for specific transactions, such as an asset, supplier number, or document number. | ||||
szAmountLedgerType | LTA | char | OPT | NONE |
A user defined code (09/LT) that identifies the ledger to which you are posting amounts, such as BA (Budget Ledger) or FE (Field Estimate).
| ||||
szUnitLedgerType | LTU | char | OPT | NONE |
A user defined code (09/LT) that identifies a unit ledger, such as BU (Budget Units) or AA (Actual Units). You can set up multiple, concurrent
| ||||
mnPostingAmount | A53OW | MATH_NUMERIC | OPT | NONE |
Change Management column for amounts. | ||||
mnPostingUnits | U53OW | MATH_NUMERIC | OPT | NONE |
Change Management column used for entering units. | ||||
cAuditTrail | 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
| ||||
cReturnErrorID | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szProgramId | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
szReference3AccountReconci | R3 | char | OPT | NONE |
Number that provides an audit trail for specific transactions. Used primarily in the G/L Account Reconciliation program (P09131). | ||||
szReference1JeVouchIn | R1 | char | OPT | NONE |
A number that provides an audit trail for specific transactions, such as a payment number for payment processing. |
None |
None |