InsertAREFAccountCache

AREF Budget Calculation Account Cache

Minor Business Rule

Object Name: B15L0002

Parent DLL: CCRIN

Location: Client/Server

Language: C

Insert AREF Account Cache
This business function inserts or updates records into cache for the AREF Budget Calculation.  Based on the key values passed in, if a cache record
already exists and the record's lock flag is not locked, the record will be updated.  If the cache record does not exist, it will be inserted.   The following is the list
of data structure parameters.

NameAlias         I/OReqDescription
Building MCUIYAREF Building to calculate lease revenue
Revision NumberRVNBIYRevision Number of Budget Calculation
Account AIDIYF15L109 cache record key
Century CTRYIYF15L109 cache record key
Fiscal Year FYIYF15L109 cache record key
Subledger SBLIYF15L109 cache record key
Subledger TypeSBLTIYF15L109 cache record key
Amount1 AN01I
Amount2 AN02I
Amount3 AN03 I
Amount4 AN04 I
Amount5 AN05 I
Amount6 AN06 I
Amount7 AN07 I
Amount8 AN08 I
Amount9 AN09 I
Amount10 AN10 I
Amount11 AN11 I
Amount12 AN12 I
PostingBU MCU2I
Object OBJI
Subsidiary SUBI
Lock Flag BELKI
Record Exists EV01 O Return 1 if Cache record exists
Return Status EV01O Returns 1 if error occurred
ComputerID CTIDIYPart of Cache Name

Pseudo Code:
Insert AREF Account Cache

Set memory for cache account record and cache key
Set error return flag to false
Concatinate Object Name and ComputerID as Cache Name
Call Create Cache internal function
If Create Cache is successful

Open Cache Cursor
Call Load Cache Key internal function
Call Insert Cache Records internal function
If cache insert unsuccessful

Set error return flag to true

Set function return error

If cache open cursor successful

Cache Close Cursor

Else

Set error return flag to true
Set function return error

End IF - Create Cache successful

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szBuilding_MCU	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.
mnRevisionNumber_RVNB	RVNB	MATH_NUMERIC	OPT	INPUT
A number that specifies a unique budget revision. You store multiple revisions of information you set up and calculated budget information within the system. The system stores each "what-if" scenario according to the budget revision number you assign.
szAccountId_AID	AID	char	OPT	INPUT
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it.
mnCentury_CTRY	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.
mnFiscalYear_FY	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.
szSubledger_SBL	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	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
mnAmountNetPosting001_AN01	AN01	MATH_NUMERIC	OPT	NONE
A number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants table (F0010). The net amount posted is the total of all debits and credits, beginning with the first day of the period through the last day of the period.
mnAmountNetPosting002_AN02	AN02	MATH_NUMERIC	OPT	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnAmountNetPosting003_AN03	AN03	MATH_NUMERIC	OPT	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnAmountNetPosting004_AN04	AN04	MATH_NUMERIC	OPT	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnAmountNetPosting005_AN05	AN05	MATH_NUMERIC	OPT	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnAmountNetPosting006_AN06	AN06	MATH_NUMERIC	OPT	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnAmountNetPosting007_AN06	AN07	MATH_NUMERIC	OPT	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnAmountNetPosting008_AN08	AN08	MATH_NUMERIC	OPT	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnAmountNetPosting009_AN09	AN09	MATH_NUMERIC	OPT	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnAmountNetPosting010_AN10	AN10	MATH_NUMERIC	OPT	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnAmountNetPosting011_AN11	AN11	MATH_NUMERIC	OPT	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnAmountNetPosting012_AN12	AN12	MATH_NUMERIC	OPT	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
szObjectAccount_OBJ	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	SUB	char	OPT	NONE
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.
cLockFlag_BELK	BELK	char	OPT	NONE
A code that determines whether the system updates a budget result record when you run the AREF Budget Calculation program (R15L1091). You can run this program at any time; however, the system does not update records that you have locked. Valid values are: Y Lock the record but allow the AREF Budget Results table (F15L109) to be updated. N Update both the record and the AREF Budget Results table (F15L109).
szPostingBusinessUnit_MCU2	MCU2	char	OPT	NONE
An accounting entity, such as a profit center, department, warehouse location, job, project, workcenter, and so on, required for management reporting.
cRecordExists_EV01	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cReturnStatus_EV01	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
szComputerID_CTID	CTID	char	REQ	INPUT

jdBudgetEndDate_EFTE	EFTE	JDEDATE	OPT	NONE
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.

Create Cache

Set memory for cache key
Initialize Behavior
If behavior initialization is successful

Set cache key based on F15L109 primary index
Initialize cache

Else

Set Cache initialization error

End IF - Behavior successful

Load Cache Key Cache

Set cache key values from passed data structure values (based on F15L109)

Insert Cache Records

If cursor open

Fetch cache record

Set cache field values from passed data structure values (based on F15L109)
If fetch cache record successful

Update cache record

Else

Set cache key values from passed data structure values (based on F15L109)
Insert cache record

Data Structure

D15L0002A - AREF Budget Calculation Account Cache

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

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

mnRevisionNumber_RVNB RVNB MATH_NUMERIC OPT INPUT

A number that specifies a unique budget revision. You store multiple revisions of information you set up and calculated budget information
within the system.  The system stores each "what-if" scenario according to the budget revision number you assign.

szAccountId_AID AID char OPT INPUT

A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it.

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

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

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

mnAmountNetPosting001_AN01 AN01 MATH_NUMERIC OPT NONE

A number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants table (F0010). The net amount posted is the total of all debits and credits, beginning with the first day of the period through the last
day of the period.

mnAmountNetPosting002_AN02 AN02 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting003_AN03 AN03 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting004_AN04 AN04 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting005_AN05 AN05 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting006_AN06 AN06 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting007_AN06 AN07 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting008_AN08 AN08 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting009_AN09 AN09 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting010_AN10 AN10 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting011_AN11 AN11 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting012_AN12 AN12 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

szObjectAccount_OBJ 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 SUB char OPT NONE

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

cLockFlag_BELK BELK char OPT NONE

A code that determines whether the system updates a budget result record when you run the AREF Budget  Calculation program
(R15L1091). You can run this program at any time; however, the system does not update records that you have locked. Valid values are: Y Lock the
record but allow the AREF Budget Results table (F15L109) to be updated. N Update both the record and the AREF Budget Results table
(F15L109).

szPostingBusinessUnit_MCU2 MCU2 char OPT NONE

An accounting entity, such as a profit center, department, warehouse location, job, project, workcenter, and so on, required for management
reporting.

cRecordExists_EV01 EV01 char OPT NONE

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

cReturnStatus_EV01 EV01 char OPT NONE

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

szComputerID_CTID CTID char REQ INPUT

jdBudgetEndDate_EFTE EFTE JDEDATE OPT NONE

The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective
date, or whatever is appropriate.

Related Functions

None

Related Tables

None

PostCacheToF15L109
PostCacheToF15L109

AREF Budget Calculation Account Cache

Minor Business Rule

Object Name: B15L0002

Parent DLL: CCRIN

Location: Client/Server

Language: C

Post Cache to F15L109
This business function inserts AREF account cache into the F15L109 AREF Budget Results table for the AREF Budget Calculation .  The business
function sequentially reads each record in cache and inters the record into the F15L109 if it's not locked.  The parameters passed into the business function are
used to update values common to all Budget Results records.  The following is the list of data structure parameters.

Name AliasI/OReqDescription
Company COIYBusiness Unit Company
BudgetBeginDateEFTBIYBudget Starting Date based on PO
BudgetEndDateEFTEIYBudget Ending Date based on PO
Transaction OriginatorTORGIY
Transaction DateENTJIY
WorkStationIdJOBNIY
UserId USERIY
ProgramId PIDIY
Date Updated UPMJIY
Time UpdatedUPMTIY
Return Status EV01O Returns 1 if error occurred
GLG6 OBJIYAAI GLGs
GLG7 OBJIYAAI GLGs
GLG11 OBJIYAAI GLGs
GLG13 OBJIYAAI GLGs
ComputerID CTIDIYPart of Cache Name

Pseudo Code:
Post Cache To F15L1091

Set memory for cache account record
Set error return flag to false
Concatinate Object Name and ComputerID as Cache Name
Call Create Cache internal function
If Create Cache is successful

Open Cache Cursor
If cache open cursor successful

Call Post Records internal function
If Post Records unsuccessful

Set error return flag to true

Set function return error

Else

Set error return flag to true
Set function return error

Else

Set error return flag to true
Set function return error

End IF - Create Cache successful

Create Cache

Set memory for cache key
Initialize Behavior
If behavior initialization is successful

Set cache key based on F15L109 primary index
Initialize cache

Else

Set Cache initialization error

End IF - Behavior successful

Post Records

Get cache number of records
Open F15L109 table for processing
If open table successful

Clear column buffer
Set buffered inserts flag
Assign static F15L109 data to table data structure 1
While number of cache records is greater than zero

Fetch cache record (sequential fetches - no key needed)

If fetch cache record successful and lock flag not equal to Y

Assign cache data to F15L109 record structure
Reverse F15L109 net posting amount signs based on the GLGs
Insert record into F15L109
Decrement number of cache records by 1

If table is open

Close F15L109 table
Null table request

Data Structure

D15L0002B - AREF Budget Calculation Account Posting

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

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

jdBudgetBeginDate_EFTB EFTB JDEDATE REQ INPUT

The date that an address, item, transaction, or table record becomes active.  The meaning of this field differs, depending on the program.
For example, the effective date could represent the following:   o When a change of address becomes effective.   o When a lease becomes
effective.   o When a price becomes effective.   o When the currency exchange rate becomes effective.   o When a tax rate becomes effective.

szTransOriginator_TORG TORG char REQ INPUT

The person who originally entered the transaction.

jdTransEnteredDate_ENTJ ENTJ JDEDATE REQ INPUT

The date the item was keyed into the system.

szWorkStationId_JOBN JOBN char REQ INPUT

The code that identifies the work station ID that executed a particular job.

szUserId_USER USER char REQ INPUT

The code that identifies a user profile.

szProgramId_PID PID char REQ 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.

jdDateUpdated_UPMJ UPMJ JDEDATE REQ INPUT

The date that specifies the last update to the file record.

mnTimeUpdated_UPMT UPMT MATH_NUMERIC REQ INPUT

The time that specifies when the program executed the last update to this record.

cReturnStatus_EV01 EV01 char OPT OUTPUT

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

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

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

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

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

szComputerID_CTID CTID char REQ INPUT

Related Functions

None

Related Tables

None

RetrieveAREFAccountCache
RetrieveAREFAccountCache

AREF Budget Calculation Account Cache

Minor Business Rule

Object Name: B15L0002

Parent DLL: CCRIN

Location: Client/Server

Language: C

Retrieve AREF Account Cache
This business function retrieves F15L109 records from cache for the AREF Budget Calculation.  Based on the key values passed in, if a cache record
exists the cache record data wil be retrieved and passed back to the calling application.  If the cache record does not exist, it will be inserted.   The following is
the list of data structure parameters.

NameAlias         I/OReqDescription
Building MCUIYAREF Building to calculate lease revenue
Revision NumberRVNBIYRevision Number of Budget Calculation
Account AIDIYF15L109 cache record key
Century CTRYIYF15L109 cache record key
Fiscal Year FYIYF15L109 cache record key
Subledger SBLIYF15L109 cache record key
Subledger TypeSBLTIYF15L109 cache record key
Amount1 AN01O
Amount2 AN02O
Amount3 AN03 O
Amount4 AN04 O
Amount5 AN05 O
Amount6 AN06 O
Amount7 AN07 O
Amount8 AN08 O
Amount9 AN09 O
Amount10 AN10 O
Amount11 AN11 O
Amount12 AN12 O
PostingBU MCU2O
Object OBJO
Subsidiary SUBO
Lock Flag BELKO
Record Exists EV01 O Return 1 if Cache record exists
Return Status EV01O Returns 1 if error occurred
ComputerID CTIDIYPart of Cache Name

Pseudo Code:
Retrieve AREF Account Cache

Set memory for cache account record and cache key
Set error return flag to false
Concatinate Object Name and ComputerID as Cache Name
Call Create Cache internal function
If Create Cache is successful

Open Cache Cursor
Call Load Cache Key internal function
If cache open cursor successful

Call Read Cache Records internal function
If cache read unsuccessful

Set error return flag to true

Set function return error

Cache Close Cursor

Else

Set error return flag to true
Set function return error

End IF - Create Cache successful

Create Cache

Set memory for cache key
Initialize Behavior
If behavior initialization is successful

Set cache key based on F15L109 primary index
Initialize cache

Else

Set Cache initialization error

End IF - Behavior successful

Load Cache Key Cache

Set cache key values from passed data structure values (based on F15L109)

Read Cache Record

Fetch cache record

Set cache field values to data structure values
Set BF record exists flag to true

else

Set BF record exists flag to false

Data Structure

D15L0002A - AREF Budget Calculation Account Cache

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

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

mnRevisionNumber_RVNB RVNB MATH_NUMERIC OPT INPUT

A number that specifies a unique budget revision. You store multiple revisions of information you set up and calculated budget information
within the system.  The system stores each "what-if" scenario according to the budget revision number you assign.

szAccountId_AID AID char OPT INPUT

A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it.

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

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

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

mnAmountNetPosting001_AN01 AN01 MATH_NUMERIC OPT NONE

A number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants table (F0010). The net amount posted is the total of all debits and credits, beginning with the first day of the period through the last
day of the period.

mnAmountNetPosting002_AN02 AN02 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting003_AN03 AN03 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting004_AN04 AN04 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting005_AN05 AN05 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting006_AN06 AN06 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting007_AN06 AN07 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting008_AN08 AN08 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting009_AN09 AN09 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting010_AN10 AN10 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting011_AN11 AN11 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting012_AN12 AN12 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

szObjectAccount_OBJ 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 SUB char OPT NONE

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

cLockFlag_BELK BELK char OPT NONE

A code that determines whether the system updates a budget result record when you run the AREF Budget  Calculation program
(R15L1091). You can run this program at any time; however, the system does not update records that you have locked. Valid values are: Y Lock the
record but allow the AREF Budget Results table (F15L109) to be updated. N Update both the record and the AREF Budget Results table
(F15L109).

szPostingBusinessUnit_MCU2 MCU2 char OPT NONE

An accounting entity, such as a profit center, department, warehouse location, job, project, workcenter, and so on, required for management
reporting.

cRecordExists_EV01 EV01 char OPT NONE

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

cReturnStatus_EV01 EV01 char OPT NONE

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

szComputerID_CTID CTID char REQ INPUT

jdBudgetEndDate_EFTE EFTE JDEDATE OPT NONE

The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective
date, or whatever is appropriate.

Related Functions

None

Related Tables

None

RetrieveAREFAccountNoSubledger
RetrieveAREFAccountNoSubledger

AREF Budget Calculation Account Cache

Minor Business Rule

Object Name: B15L0002

Parent DLL: CCRIN

Location: Client/Server

Language: C

Retrieve AREF Account Cache No Subledger
This business function retrieves F15L109 account records from cache for the AREF Budget Calculation.  The accounts are retrieved without subledger in
the key.  For each account fiscal year combination, the record's net posting amounts are accumulated and retruned to the calling object.  The following is
the list of data structure parameters.

NameAlias         I/OReqDescription
Building MCUIYAREF Building to calculate lease revenue
Revision NumberRVNBIYRevision Number of Budget Calculation
Account AIDIYF15L109 cache record key
Century CTRYIYF15L109 cache record key
Fiscal Year FYIYF15L109 cache record key
Subledger SBLIYShould be Blanks
Subledger TypeSBLTIYShould be Blanks
Amount1 AN01O
Amount2 AN02O
Amount3 AN03 O
Amount4 AN04 O
Amount5 AN05 O
Amount6 AN06 O
Amount7 AN07 O
Amount8 AN08 O
Amount9 AN09 O
Amount10 AN10 O
Amount11 AN11 O
Amount12 AN12 O
PostingBU MCU2O
Object OBJO
Subsidiary SUBO
Lock Flag BELKO
Record Exists EV01 O Return 1 if Cache record exists
Return Status EV01O Returns 1 if error occurred
ComputerID CTIDIYPart of Cache Name

Retrieve AREF Account Cache No Subledger

Set memory for cache account record and cache key
Set error return flag to false
Call Create Cache internal function
If Create Cache is successful

Open Cache Cursor
Call Load Cache No Sub Key internal function
If cache open cursor successful

Call Read No Sub Cache Records internal function
If cache read unsuccessful

Set error return flag to true

Set function return error

Cache Close Cursor

Else

Set error return flag to true
Set function return error

End IF - Create Cache successful

Create Cache

Set memory for cache key
Concatenate B15L0002 and Computer ID into cache name
Initialize Behavior
If behavior initialization is successful

Set cache key based on F15L109 primary index
Initialize cache

Else

Set Cache initialization error

End IF - Behavior successful

Load Cache No Sub Key Cache

Set cache key values from passed data structure values (based on F15L109)

Retrieve No Sub Records

Initialize Net Posting amounts
Fetch cache record with no subledger as key
If read unsuccessful

Set BF record exists flag to false

While read successful

If account id, fiscal year and century = cache key and subledger not blank

Add cache net posting amounts to accumulated amounts
Set BF record exists flag to true
Fetch next cache record

End While

Data Structure

D15L0002A - AREF Budget Calculation Account Cache

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

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

mnRevisionNumber_RVNB RVNB MATH_NUMERIC OPT INPUT

A number that specifies a unique budget revision. You store multiple revisions of information you set up and calculated budget information
within the system.  The system stores each "what-if" scenario according to the budget revision number you assign.

szAccountId_AID AID char OPT INPUT

A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it.

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

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

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

mnAmountNetPosting001_AN01 AN01 MATH_NUMERIC OPT NONE

A number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants table (F0010). The net amount posted is the total of all debits and credits, beginning with the first day of the period through the last
day of the period.

mnAmountNetPosting002_AN02 AN02 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting003_AN03 AN03 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting004_AN04 AN04 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting005_AN05 AN05 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting006_AN06 AN06 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting007_AN06 AN07 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting008_AN08 AN08 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting009_AN09 AN09 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting010_AN10 AN10 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting011_AN11 AN11 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting012_AN12 AN12 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

szObjectAccount_OBJ 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 SUB char OPT NONE

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

cLockFlag_BELK BELK char OPT NONE

A code that determines whether the system updates a budget result record when you run the AREF Budget  Calculation program
(R15L1091). You can run this program at any time; however, the system does not update records that you have locked. Valid values are: Y Lock the
record but allow the AREF Budget Results table (F15L109) to be updated. N Update both the record and the AREF Budget Results table
(F15L109).

szPostingBusinessUnit_MCU2 MCU2 char OPT NONE

An accounting entity, such as a profit center, department, warehouse location, job, project, workcenter, and so on, required for management
reporting.

cRecordExists_EV01 EV01 char OPT NONE

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

cReturnStatus_EV01 EV01 char OPT NONE

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

szComputerID_CTID CTID char REQ INPUT

jdBudgetEndDate_EFTE EFTE JDEDATE OPT NONE

The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective
date, or whatever is appropriate.

Related Functions

None

Related Tables

None

TerminateAREFAccountCache
TerminateAREFAccountCache

AREF Budget Calculation Account Cache

Minor Business Rule

Object Name: B15L0002

Parent DLL: CCRIN

Location: Client/Server

Language: C

Terminate AREF Account Cache
This business function terminates the AREF Account Cache from memory.  No values are required to be passed in in order to terminate the cache.
However, the return status of the termination will be returned.  The following is the list of data structure parameters.  None of the paramerters are used except
Return Status.

NameAlias         I/OReqDescription
Building MCUN/A AREF Building to calculate lease revenue
Revision NumberRVNBN/A Revision Number of Budget Calculation
Account AIDN/A F15L109 cache record key
Century CTRYN/A F15L109 cache record key
Fiscal Year FYN/A F15L109 cache record key
Subledger SBLN/A F15L109 cache record key
Subledger TypeSBLTN/A F15L109 cache record key
Amount1 AN01N/A
Amount2 AN02N/A
Amount3 AN03 N/A
Amount4 AN04 N/A
Amount5 AN05 N/A
Amount6 AN06 N/A
Amount7 AN07 N/A
Amount8 AN08 N/A
Amount9 AN09 N/A
Amount10 AN10 N/A
Amount11 AN11 N/A
Amount12 AN12 N/A
PostingBU MCU2N/A
Object OBJN/A
Subsidiary SUBN/A
Lock Flag BELKN/A
Record Exists EV01 N/A Return 1 if Cache record exists
Return Status EV01O Returns 1 if error occurred
ComputerID CTIDIYPart of Cache Name

Pseudo Code:
Terminate AREF Account Cache

Set memory for cache account record
Set error return flag to false
Concatinate Object Name and ComputerID as Cache Name
Call Create Cache internal function
If Create Cache is successful

Terminate cache - all records

Else

Set error return flag to true
Set function return error

End IF - Create Cache successful

Create Cache

Set memory for cache key
Initialize Behavior
If behavior initialization is successful

Set cache key based on F15L109 primary index
Initialize cache

Else

Set Cache initialization error

End IF - Behavior successful

Data Structure

D15L0002A - AREF Budget Calculation Account Cache

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

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

mnRevisionNumber_RVNB RVNB MATH_NUMERIC OPT INPUT

A number that specifies a unique budget revision. You store multiple revisions of information you set up and calculated budget information
within the system.  The system stores each "what-if" scenario according to the budget revision number you assign.

szAccountId_AID AID char OPT INPUT

A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it.

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

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

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

mnAmountNetPosting001_AN01 AN01 MATH_NUMERIC OPT NONE

A number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants table (F0010). The net amount posted is the total of all debits and credits, beginning with the first day of the period through the last
day of the period.

mnAmountNetPosting002_AN02 AN02 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting003_AN03 AN03 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting004_AN04 AN04 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting005_AN05 AN05 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting006_AN06 AN06 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting007_AN06 AN07 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting008_AN08 AN08 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting009_AN09 AN09 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting010_AN10 AN10 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting011_AN11 AN11 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

mnAmountNetPosting012_AN12 AN12 MATH_NUMERIC OPT NONE

Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day
of the period.

szObjectAccount_OBJ 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 SUB char OPT NONE

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

cLockFlag_BELK BELK char OPT NONE

A code that determines whether the system updates a budget result record when you run the AREF Budget  Calculation program
(R15L1091). You can run this program at any time; however, the system does not update records that you have locked. Valid values are: Y Lock the
record but allow the AREF Budget Results table (F15L109) to be updated. N Update both the record and the AREF Budget Results table
(F15L109).

szPostingBusinessUnit_MCU2 MCU2 char OPT NONE

An accounting entity, such as a profit center, department, warehouse location, job, project, workcenter, and so on, required for management
reporting.

cRecordExists_EV01 EV01 char OPT NONE

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

cReturnStatus_EV01 EV01 char OPT NONE

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

szComputerID_CTID CTID char REQ INPUT

jdBudgetEndDate_EFTE EFTE JDEDATE OPT NONE

The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective
date, or whatever is appropriate.

Related Functions

None

Related Tables

None

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 provid

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szCompany_CO	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.
jdBudgetBeginDate_EFTB	EFTB	JDEDATE	REQ	INPUT
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program. For example, the effective date could represent the following: o When a change of address becomes effective. o When a lease becomes effective. o When a price becomes effective. o When the currency exchange rate becomes effective. o When a tax rate becomes effective.
szTransOriginator_TORG	TORG	char	REQ	INPUT
The person who originally entered the transaction.
jdTransEnteredDate_ENTJ	ENTJ	JDEDATE	REQ	INPUT
The date the item was keyed into the system.
szWorkStationId_JOBN	JOBN	char	REQ	INPUT
The code that identifies the work station ID that executed a particular job.
szUserId_USER	USER	char	REQ	INPUT
The code that identifies a user profile.
szProgramId_PID	PID	char	REQ	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.
jdDateUpdated_UPMJ	UPMJ	JDEDATE	REQ	INPUT
The date that specifies the last update to the file record.
mnTimeUpdated_UPMT	UPMT	MATH_NUMERIC	REQ	INPUT
The time that specifies when the program executed the last update to this record.
cReturnStatus_EV01	EV01	char	OPT	OUTPUT
An option that specifies the type of processing for an event.
szGLG6_OBJ	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.
szGLG7_OBJ	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.
szGLG11_OBJ	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.
szGLG13_OBJ	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.
szComputerID_CTID	CTID	char	REQ	INPUT