F0902AccessOriginalBudget

F0902 Access Original Budget

Minor Business Rule

Object Name: B5100007

Parent DLL: CAEC

Location: Client/Server

Language: C

Purpose
F0902 Creation Records need to be created or updated in the Account Balance Table(F0902) when Budget Amounts and or Budget Unit values are
entered. The amount or unit values entered update the Original Budget(BORG) field on the F0902. The Account Master record, Processing Option Values and
System Values are used to populate fields on the F0902 record. The following fields are updated from values from the Account Master record:
AID,CO,MCU,OBJ,SUB. The Processing Options provide the Ledger Types and which Fiscal Years records to create or update. System values will provide the User ID,
Program ID, Workstation ID and the Date updated. If a Subledger and Subledger Type is entered the Posting Edit Code of the Account will determine if
separate F0902 records are created. Error #2455 is issued when the Processing Option is set to update more than one fiscal year.

Use the Action Code to Determine F0902 BORG Processing:

• C - Change
• I - Inquire
• D - Delete

Deletion of Budget Balance Records(F0902) The Budget Account Balance record is deleted when an* is entered in the first position of the Cost
Code(SUB) field. The record is deleted only when the BORG field is populated on the F0902 record. The projections routine X51013 is then called which deletes the
F0902 in the HA ledger.
Only the budget record for the year inquired on is deleted. The Account Master Record can only be deleted if no records exist in the F0902 or F4311 files.
Errors '0054' and '0060' occur when trying to delete an Account which has records in the F0902 or F4311 files.

Data Structure

D5100007 - F0902 Access Original Budget

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cActionCode	ACTN	char	REQ	INPUT
A code that specifies the action that is performed. Valid values are: A Add C Change
szBusinessUnit	MCU	char	OPT	INPUT
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.
szAccountID	AID	char	REQ	INPUT
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	INPUT
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.
szObjectAccount	OBJ	char	OPT	INPUT
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	INPUT
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.
szProgramID	PID	char	OPT	INPUT
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.
mnOriginalBudgetUnit	BORG	MATH_NUMERIC	OPT	BOTH
Field that tracks amounts for an annual budget amount by ledger type in the Account Balances file (F0902).
mnOriginalBudgetAmount	BORG	MATH_NUMERIC	OPT	BOTH
Field that tracks amounts for an annual budget amount by ledger type in the Account Balances file (F0902).
mnFiscalYear	FY	MATH_NUMERIC	OPT	INPUT
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.
mnCentury	CTRY	MATH_NUMERIC	OPT	INPUT
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 (1998, 1999), 20 indicates any year beginning with 20 (2000, 2001), and so on.
szSubledger	SBL	char	REQ	INPUT
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	INPUT
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
cBudgetUpdateOptions	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
szLedgerTypeUnit	LT	char	REQ	INPUT
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.
szLedgerTypeAmount	LT	char	REQ	INPUT
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	OPT	INPUT
A code that identifies the currency of a transaction.
szEdiBatchNumber	EDBT	char	OPT	BOTH
The number that the transmitter assigns to the batch. During batch processing, the system assigns a new batch number to the PeopleSoft transactions for each control (user) batch number it finds.
cCostManagementFlag	CO01	char	OPT	INPUT
A flag that activates cost objects.

Related Functions

B0000069 Retrieve Ledger Type Currency
B9800100 Get Audit Information

Related Tables

F0902 Account Balances