F0902JobCostUpdateBalances

F0902 Job Cost Update Balances

Master Business Function

Object Name: B5100020

Parent DLL: CAEC

Location: Client/Server

Language: C

Purpose
A F0911 Audit Trail record can be created for changes by passing in an Audit Trail Flag. The Audit Trail Flag controls the creation of Audit Trail
records. The options are to: 1) Create an F0911 for each change, 2) Create one F0911 per period for all changes or 3) To not create any Audit Trail
records. The F0911 record can contain Amounts, Units or Both depending upon the values entered.

If the Audit Trail Flag is set to '2' ,create an audit trail record 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 records exist with the Period end GL Date then a new F0911 record is created.

Update the 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 doesn't exist, the a new record must be inserted.

Data Structure

D5100020 - F0902 Job Cost Update Balances

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

mnBatchNumber ICU MATH_NUMERIC OPT BOTH

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
assign a batch number or let the system assign it using the Next Numbers program.

szDocumentType DCT char OPT INPUT

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

jdGLDate DGL JDEDATE OPT INPUT

A date that identifies the financial period to which the transaction is to be posted. The company constants specify the date range for each
financial period. You can have as many as 14 periods. Generally, period 14 is used for audit adjustments. The system validates this field for
PBCO (posted before cutoff), PYEB (prior year ending balance), PACO (post after cutoff), and WACO (post way after cutoff) messages.

szCompany CO char REQ 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.

szAccountNumber ANI char OPT INPUT

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.

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.

szCostCenter MCU char REQ 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.

szObjectAccount OBJ char REQ 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 REQ INPUT

A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.

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 REQ 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

szLedgerType 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.

szUnitsLedgerType ULT char REQ INPUT

The units ledger is relational to the amount ledger.  The first character in both ledgers is the same.  The second character in the units ledger
is a U. The one exception to this rule is the AZ (Cash Basis) amount ledger.  If you do not fill in a units ledger for the AZ amount ledger, a
default units ledger of ZU will be used by the G/L Post.  The units ledger must be a valid ledger type.

mnPeriodNumber PN MATH_NUMERIC REQ INPUT

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.

mnCentury CTRY MATH_NUMERIC REQ 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.

mnFiscalYear FY MATH_NUMERIC REQ 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.

szCurrencyCode CRCD char OPT INPUT

A code that identifies the currency of a transaction.

mnAmount AA MATH_NUMERIC OPT INPUT

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.

mnUnits U MATH_NUMERIC OPT INPUT

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.

szNameAlphaExplanation EXA char OPT INPUT

A description, remark, explanation, name, or address.

szNameRemarkExplanation EXR char OPT INPUT

A name or remark that describes the purpose for using an account or conveys any other information that the user wants about the
transaction.

szReference2 R2 char OPT INPUT

A number that provides an audit trail for specific transactions, such as an asset, supplier number, or document number.

szReference3 R3 char OPT INPUT

Number that provides an audit trail for specific transactions.  Used primarily in the G/L Account Reconciliation program (P09131).

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.

cAuditTrailFlag EV01 char OPT INPUT

An option that specifies the type of processing for an event.

mnDocumentNumber DOC MATH_NUMERIC OPT BOTH

A number that identifies the original document, such as a voucher, invoice, or journal entry. On entry forms, you can assign the document
number or let the system assign it using the Next Numbers program (P0002). Matching document numbers (DOCM) identify related documents
in the Accounts Receivable and Accounts Payable systems. Examples of original and matching documents are: Accounts Payable     o
Original document - voucher     o Matching document - payment Accounts Receivable     o Original document - invoice     o Matching document -
receipt Note: In the Accounts Receivable system, the following transactions simultaneously generate original and matching documents:
deductions, unapplied receipts, chargebacks, and drafts.

mnJournalEntryLineNo JELN MATH_NUMERIC OPT BOTH

A number that designates a line within a journal entry. The system uses this field to sequence the journal entry lines for inquiry purposes.

cCostManagementFlag CO01 char OPT BOTH

A flag that activates cost objects.

szEPSBatchNumber EDBT char OPT NONE

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.

Related Functions

B0000004 Batch - Open On Initialization

B0000069 Retrieve Ledger Type Currency

B1100006 Decimal Trigger Get By Currency

B9800100 Get Audit Information

N1600270 F1602Z1 File Server

Related Tables

F0901 Account Master

F0902 Account Balances

F0911 Account Ledger

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnBatchNumber	ICU	MATH_NUMERIC	OPT	BOTH
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 assign a batch number or let the system assign it using the Next Numbers program.
szDocumentType	DCT	char	OPT	INPUT
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
jdGLDate	DGL	JDEDATE	OPT	INPUT
A date that identifies the financial period to which the transaction is to be posted. The company constants specify the date range for each financial period. You can have as many as 14 periods. Generally, period 14 is used for audit adjustments. The system validates this field for PBCO (posted before cutoff), PYEB (prior year ending balance), PACO (post after cutoff), and WACO (post way after cutoff) messages.
szCompany	CO	char	REQ	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.
szAccountNumber	ANI	char	OPT	INPUT
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.
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.
szCostCenter	MCU	char	REQ	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.
szObjectAccount	OBJ	char	REQ	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	REQ	INPUT
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.
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	REQ	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
szLedgerType	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.
szUnitsLedgerType	ULT	char	REQ	INPUT
The units ledger is relational to the amount ledger. The first character in both ledgers is the same. The second character in the units ledger is a U. The one exception to this rule is the AZ (Cash Basis) amount ledger. If you do not fill in a units ledger for the AZ amount ledger, a default units ledger of ZU will be used by the G/L Post. The units ledger must be a valid ledger type.
mnPeriodNumber	PN	MATH_NUMERIC	REQ	INPUT
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.
mnCentury	CTRY	MATH_NUMERIC	REQ	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.
mnFiscalYear	FY	MATH_NUMERIC	REQ	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.
szCurrencyCode	CRCD	char	OPT	INPUT
A code that identifies the currency of a transaction.
mnAmount	AA	MATH_NUMERIC	OPT	INPUT
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.
mnUnits	U	MATH_NUMERIC	OPT	INPUT
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.
szNameAlphaExplanation	EXA	char	OPT	INPUT
A description, remark, explanation, name, or address.
szNameRemarkExplanation	EXR	char	OPT	INPUT
A name or remark that describes the purpose for using an account or conveys any other information that the user wants about the transaction.
szReference2	R2	char	OPT	INPUT
A number that provides an audit trail for specific transactions, such as an asset, supplier number, or document number.
szReference3	R3	char	OPT	INPUT
Number that provides an audit trail for specific transactions. Used primarily in the G/L Account Reconciliation program (P09131).
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.
cAuditTrailFlag	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
mnDocumentNumber	DOC	MATH_NUMERIC	OPT	BOTH
A number that identifies the original document, such as a voucher, invoice, or journal entry. On entry forms, you can assign the document number or let the system assign it using the Next Numbers program (P0002). Matching document numbers (DOCM) identify related documents in the Accounts Receivable and Accounts Payable systems. Examples of original and matching documents are: Accounts Payable o Original document - voucher o Matching document - payment Accounts Receivable o Original document - invoice o Matching document - receipt Note: In the Accounts Receivable system, the following transactions simultaneously generate original and matching documents: deductions, unapplied receipts, chargebacks, and drafts.
mnJournalEntryLineNo	JELN	MATH_NUMERIC	OPT	BOTH
A number that designates a line within a journal entry. The system uses this field to sequence the journal entry lines for inquiry purposes.
cCostManagementFlag	CO01	char	OPT	BOTH
A flag that activates cost objects.
szEPSBatchNumber	EDBT	char	OPT	NONE
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.

B0000004 Batch - Open On Initialization
B0000069 Retrieve Ledger Type Currency
B1100006 Decimal Trigger Get By Currency
B9800100 Get Audit Information
N1600270 F1602Z1 File Server

F0901 Account Master
F0902 Account Balances
F0911 Account Ledger