AccumulateFixedAssetTotals

Fixed Asset Total

Minor Business Rule

Object Name: B1200008

Parent DLL: CAEC

Location: Client/Server

Language: C

Purpose
To create totals for processing reports. The totals are determined by the type (AD, DE, Company, Grand), ledger type, sub-ledger.

The Grand Totals contains no company or account information. Total by ledger type, subledger type.
The Company totals contain no account information. Total by ledger type, subledger type.
The Account totals contains ledger type, and subledger information.

If subledger is not required, use a '*" or Blank to default to a single ledger type. The type can be user defined. When fetching on Account, 5 keys will
be used.

The error determines the successful cache processing.

Setup Notes and Prerequisites
• The cache will be set up by the business function
• The function needs to be called for each type desired
• Type:
•

AD - Accumulated Depreciation Account (Fetch by 5 Keys) User Defined
• DE - Depreciation Expense Account (Fetch by 5 Keys) User Defined
• IT - Item used only within the same sequence with level breaks
• CO - Company (hard coded) 2Keys fields
• GT - Grand Total (hard coded) 1Key field

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szType	DCTO	char	REQ	NONE
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and should not be changed: P Accounts Payable documents R Accounts Receivable documents T Payroll documents I Inventory documents O Purchase Order Processing documents J General Accounting/Joint Interest Billing documents S Sales Order Processing documents
szCompany	CO	char	OPT	NONE
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000 for transaction entries.
szBusinessUnit	MCU	char	OPT	NONE
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
szObjectAccount	OBJ	char	OPT	NONE
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into subcategories. For example, you can divide the Cost Code for labor into regular time, premium time, and burden. Note: If you use a flexible chart of accounts and the object account is set to 6 digits, J.D. Edwards recommends that you use all 6 digits. For example, entering 000456 is not the same as entering 456 because if you enter 456 the system enters three blank spaces to fill a 6-digit object.
szSubsidiary	SUB	char	OPT	NONE
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.
szLedgerType	LT	char	REQ	NONE
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.
szSubledger	SBL	char	OPT	NONE
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an address book number. If you enter a subledger, you must also specify the subledger type.
cSubledgerType	SBLT	char	OPT	NONE
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger editing. On the User Defined Codes form, the second line of the description controls how the system performs editing. This is either hard-coded or user defined. Valid values include: A Alphanumeric field, do not edit N Numeric field, right justify and zero fill C Alphanumeric field, right justify and blank fill
cErrorFlag	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cFetchbyTypeOnly	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
mnTotal_1	A12OW	MATH_NUMERIC	OPT	NONE
Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data dictionary edits.
mnTotal_2	A12OW	MATH_NUMERIC	OPT	NONE
Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data dictionary edits.
mnTotal_3	A12OW	MATH_NUMERIC	OPT	NONE
Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data dictionary edits.
mnTotal_4	A12OW	MATH_NUMERIC	OPT	NONE
Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data dictionary edits.
mnTotal_5	A12OW	MATH_NUMERIC	OPT	NONE
Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data dictionary edits.
mnTotal_6	A12OW	MATH_NUMERIC	OPT	NONE
Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data dictionary edits.
mnTotal_7	A12OW	MATH_NUMERIC	OPT	NONE
Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data dictionary edits.
mnTotal_8	A12OW	MATH_NUMERIC	OPT	NONE
Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data dictionary edits.
mnTotal_9	A12OW	MATH_NUMERIC	OPT	NONE
Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data dictionary edits.
mnTotal_10	A12OW	MATH_NUMERIC	OPT	NONE
Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data dictionary edits.
szDescription	DL01	char	OPT	NONE
A user defined name or remark.
mnAssetItemNumber	NUMB	MATH_NUMERIC	OPT	NONE
An 8-digit number that uniquely identifies an asset.

Special Logic
Attach on UBE - "Do Section" or  APPL - "Write Grid Line" of totals that are retrieved for processing

Data Structure

D1200008 - Fixed Asset Totals

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

szType DCTO char REQ NONE

A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post
program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and
should not be changed: P Accounts Payable documents   R Accounts Receivable documents   T Payroll documents   I Inventory documents
O Purchase Order Processing documents   J General Accounting/Joint Interest Billing documents   S Sales Order Processing documents

szCompany CO char OPT NONE

A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany
transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000
for transaction entries.

szBusinessUnit MCU char OPT NONE

An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units
for which you have no authority.

szObjectAccount OBJ char OPT NONE

The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
subcategories. For example, you can divide the Cost Code for labor into regular time, premium time, and burden. Note: If you use a flexible chart of
accounts and the object account is set to 6 digits, J.D. Edwards recommends that you use all 6 digits. For example, entering 000456 is not
the same as entering 456 because if you enter 456 the system enters three blank spaces to fill a 6-digit object.

szSubsidiary SUB char OPT NONE

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

szLedgerType LT char REQ NONE

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.

szSubledger SBL char OPT NONE

A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
address book number. If you enter a subledger, you must also specify the subledger type.

cSubledgerType SBLT char OPT NONE

A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
editing. On the User Defined Codes form, the second line of the description controls how the system performs editing. This is either hard-coded
or user defined. Valid values include: A Alphanumeric field, do not edit   N Numeric field, right justify and zero fill   C Alphanumeric field, right
justify and blank fill

cErrorFlag EV01 char OPT NONE

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

cFetchbyTypeOnly EV01 char OPT NONE

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

mnTotal_1 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_2 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_3 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_4 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_5 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_6 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_7 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_8 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_9 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_10 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

szDescription DL01 char OPT NONE

A user defined name or remark.

mnAssetItemNumber NUMB MATH_NUMERIC OPT NONE

An 8-digit number that uniquely identifies an asset.

Related Functions

None

Related Tables

None

RetrieveFixedAssetTotals
RetrieveFixedAssetTotals

Fixed Asset Total

Minor Business Rule

Object Name: B1200008

Parent DLL: CAEC

Location: Client/Server

Language: C

Purpose
To create totals for processing reports. The totals are determined by the type (AD, DE, Company, Grand), ledger type, subledger, account.

GT ~ fetch by type only
CO ~ fetch by type, and company
Account ~ fetch by 5 keys: type, company, business unit, object, and subsidiary
The Fetch by Type only always fetches by one key which is the type. This will retrieve and clear all records for each type.

Setup Notes and Prerequisites
• The cache will be set up by the business function
• The function needs to be called for each type desired
• The calling application needs to control level breaks
• Type:
• AD  Accumulated Depreciation Account (Fetch by 5 Keys) User Defined
• DE  Depreciation Expense Account (Fetch by 5 Keys) User Defined
• CO  Company (hard coded) 2Keys fields
• GT  Grand Total (hard coded) 1Key field

Special Logic
Attach in UBE - "Do Section" or  "Advance Section" when a level break occurs
Use a while loop to retrieve all the totals checking for the Error Flag ? '1'.
In the while loop use a call a "do custom section" to print each total.

Attach in APPL  "Grid Record is Fetched" when a level break occurs
Use a while loop to retrieve all the totals checking for the Error Flag ? '1'.
In the while loop use a call a "insert grid buffer" to print each total.

A key of Type, Company, Business Unit, Object, Subsidiary are used. This assumes that a partial key for your level break exists. If your level break key
information is gone, and you need the totals for each specific type in order, then use the Fetch by Type Only with a value of '1'
^

Data Structure

D1200008 - Fixed Asset Totals

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

szType DCTO char REQ NONE

A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post
program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and
should not be changed: P Accounts Payable documents   R Accounts Receivable documents   T Payroll documents   I Inventory documents
O Purchase Order Processing documents   J General Accounting/Joint Interest Billing documents   S Sales Order Processing documents

szCompany CO char OPT NONE

A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany
transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000
for transaction entries.

szBusinessUnit MCU char OPT NONE

An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units
for which you have no authority.

szObjectAccount OBJ char OPT NONE

The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
subcategories. For example, you can divide the Cost Code for labor into regular time, premium time, and burden. Note: If you use a flexible chart of
accounts and the object account is set to 6 digits, J.D. Edwards recommends that you use all 6 digits. For example, entering 000456 is not
the same as entering 456 because if you enter 456 the system enters three blank spaces to fill a 6-digit object.

szSubsidiary SUB char OPT NONE

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

szLedgerType LT char REQ NONE

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.

szSubledger SBL char OPT NONE

A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
address book number. If you enter a subledger, you must also specify the subledger type.

cSubledgerType SBLT char OPT NONE

A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
editing. On the User Defined Codes form, the second line of the description controls how the system performs editing. This is either hard-coded
or user defined. Valid values include: A Alphanumeric field, do not edit   N Numeric field, right justify and zero fill   C Alphanumeric field, right
justify and blank fill

cErrorFlag EV01 char OPT NONE

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

cFetchbyTypeOnly EV01 char OPT NONE

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

mnTotal_1 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_2 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_3 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_4 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_5 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_6 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_7 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_8 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_9 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_10 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

szDescription DL01 char OPT NONE

A user defined name or remark.

mnAssetItemNumber NUMB MATH_NUMERIC OPT NONE

An 8-digit number that uniquely identifies an asset.

Related Functions

None

Related Tables

None

TerminateFixedAssetTotals
TerminateFixedAssetTotals

Fixed Asset Total

Minor Business Rule

Object Name: B1200008

Parent DLL: CAEC

Location: Client/Server

Language: C

Data Structure

D1200008 - Fixed Asset Totals

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

szType DCTO char REQ NONE

A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post
program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and
should not be changed: P Accounts Payable documents   R Accounts Receivable documents   T Payroll documents   I Inventory documents
O Purchase Order Processing documents   J General Accounting/Joint Interest Billing documents   S Sales Order Processing documents

szCompany CO char OPT NONE

A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany
transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000
for transaction entries.

szBusinessUnit MCU char OPT NONE

An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units
for which you have no authority.

szObjectAccount OBJ char OPT NONE

The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
subcategories. For example, you can divide the Cost Code for labor into regular time, premium time, and burden. Note: If you use a flexible chart of
accounts and the object account is set to 6 digits, J.D. Edwards recommends that you use all 6 digits. For example, entering 000456 is not
the same as entering 456 because if you enter 456 the system enters three blank spaces to fill a 6-digit object.

szSubsidiary SUB char OPT NONE

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

szLedgerType LT char REQ NONE

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.

szSubledger SBL char OPT NONE

A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
address book number. If you enter a subledger, you must also specify the subledger type.

cSubledgerType SBLT char OPT NONE

A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
editing. On the User Defined Codes form, the second line of the description controls how the system performs editing. This is either hard-coded
or user defined. Valid values include: A Alphanumeric field, do not edit   N Numeric field, right justify and zero fill   C Alphanumeric field, right
justify and blank fill

cErrorFlag EV01 char OPT NONE

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

cFetchbyTypeOnly EV01 char OPT NONE

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

mnTotal_1 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_2 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_3 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_4 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_5 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_6 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_7 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_8 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_9 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

mnTotal_10 A12OW MATH_NUMERIC OPT NONE

Fixed Asset column for amounts. The editing of this column, for example,including or excluding commas, can be performed through data
dictionary edits.

szDescription DL01 char OPT NONE

A user defined name or remark.

mnAssetItemNumber NUMB MATH_NUMERIC OPT NONE

An 8-digit number that uniquely identifies an asset.

Related Functions

None

Related Tables

None