F1201OverlayAssetMBFParms

F1201 Overlay Application Parameters for Asset MBF

Major Business Rule

Object Name: B1200270

Parent DLL: CFIN

Location: Client/Server

Language: C

Functional Description

Purpose
This business function helps forms to pass parameters to the Asset Master MBF. This allows the
developer to reduce the number of required grid columns in the calling application and improve application
performance.

Setup Notes and Prerequisites
This business function currently only supports calls from P1702 and P1705.

Special Logic
The process of overlaying data from this function's input parameters to the Asset Master MBF data
structure is determined by the Calling Program parameter. For example: If the Calling Program parameter
is "P1705" then only P1705 parameters are overlaid into the Asset Master MBF's data structure.

Technical Specification




If Action Code = 'A'


 Default blanks and zeros to N1200010's data structure.


 Overlay F1201 Fields from Input Parameters into the N1200010 data structure.


End If


If Action Code = 'C'


 Fetch Record from Asset MBF cache using NUMB=Input Asset Item Number, and Modified Flag = 

'O' using B1200260


 Copy All F1201 Fields from the Cache Record to the N1200010 data structure.


 Overlay F1201 Fields from Input Parameters based on the Calling Program Id to  the N1200010 

data structure.


End If


If Action Code = 'D'


 Fetch Record from Asset MBF cache using NUMB=Input Asset Item Number, and Modified Flag = 'O' 

using B1200260


 Copy All F1201 Fields from the Cache Record to the N1200010 data structure.


 Overlay F1201 Fields from Input Parameters based on the Calling Program Id to  the N1200010 

data structure.


End If


Return All Output from the Overlayed Datastructure to the I/O Parameters of this function.

Data Structure

D1200270 - F1201 Overlay Application Parameters for MBF

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

cActionCode ACTN char OPT NONE

A code that specifies the action that is performed. Valid values are: A Add C Change

szProgramId PID char OPT NONE

The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
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.

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.

mnAssetItemNumber NUMB MATH_NUMERIC OPT NONE

An 8-digit number that uniquely identifies an asset.

szUnitNumber APID char OPT NONE

A 12-character alphanumeric code used as an alternate identification number for an asset. This number is not required, nor does the
system assign a number if you leave the field blank when you add an asset. If you use this number, it must be unique. For equipment, this is
typically the serial number.

mnParentNumber AAID MATH_NUMERIC OPT NONE

A parent number groups related components together. You can associate each item of property and piece of equipment with a parent item.
For example, you can associate a mobile telephone with a specific automobile (the parent), a printer with a computer (the parent), or a flat
bed with a specific truck chassis (the parent). Note: If this is a data entry field, the default value is the asset number. For example, if the asset
number is 123, the system assigns 123 as the default parent number.

szSerialTagNumber ASID char OPT NONE

A 25-character alphanumeric number that you can use as an alternate asset identification number. You might use this number to track
assets by the manufacturer's serial number. You are not required to use a serial number to identify an asset. Every serial number that you enter
must be unique.

mnSequenceNumber1 SEQ MATH_NUMERIC OPT NONE

A number that specifies the sequence of information.

szMajorClass ACL1 char OPT NONE

A user defined code (12/C1) that determines the accounting class category code. You use this accounting category code to classify assets
into groups or families, for example, 100 for land, 200 for vehicles, and 300 for general office equipment. J.D. Edwards recommends that you
set up major class codes that correspond to the major general ledger object accounts in order to facilitate the reconciliation to the general
ledger. Note: If you do not want to use the major accounting class code, you must set up a value for blank in the user defined code table.

szSubClass ACL2 char OPT NONE

A user defined code (12/C2) that is used to classify assets into groups or families. You use the equipment category code as a subclass to
further define the accounting class, for example, 310 for copy equipment, 320 for projectors,and 330 for typewriters within the accounting class
for general office equipment. Note: If you do not want to use the major equipment class, you must set up a value for blank in the user defined
code table.

szClassCode3 ACL3 char OPT NONE

A user defined code (12/C3) that classifies assets into groups or families. You use the manufacturer category code to further define
subclass codes. For example, you can define an International Harvester, single-axle within the subclass for trucks.

szClassCode4 ACL4 char OPT NONE

A user defined code (12/C4) that classifies assets into groups or families. You use the model year category code to further define the
subclass codes. For example, you can define a 1990 International Harvester, single-axle within the subclass for trucks.

szClassCode5 ACL5 char OPT NONE

A user defined code (12/C5) that classifies assets into groups or families. You use the usage category codes to further define the subclass
codes.

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.

szDescription001 DL01 char OPT NONE

A user defined name or remark.

szDescription002 DL02 char OPT NONE

Additional text that further describes or clarifies a field in the system.

szDescription003 DL03 char OPT NONE

Additional text that further describes or clarifies an element.

szDescCompressed DSCC char OPT NONE

The compressed description contains the alpha name without spaces, slashes,dashes, commas, and other special characters.  The
compressed description is the field used in the Data Dictionary Name Search.

jdDateAcquired DAJ JDEDATE OPT NONE

Use this field to specify the date the asset was acquired. This date is typically the start depreciation date, but you can specify a different
start depreciation date on the Depreciation Information form. If you are using the half-year convention, you must adjust the start depreciation
date manually.

jdDateDisposal DSP JDEDATE OPT NONE

The date the asset was disposed.

szEquipmentStatus EQST char OPT NONE

A user defined code (12/ES) that identifies the equipment or disposal status of an asset, such as available, down, or disposed.

cNewOrUsedOnAcquisition NORU char OPT NONE

A user defined code (H12/NO) that specifies whether an asset is new or used for tax purposes. Valid values are: N The asset is new. U The
asset is used. This code is used in computing the ITC limitation on the acquisition of used assets.

mnAmtEstSalvageValue AESV MATH_NUMERIC OPT NONE

The estimated salvage value at the end of the useful life of an asset.

mnAmtReplacementCost ARPC MATH_NUMERIC OPT NONE

The current or estimated replacement cost of the asset. Typically, replacement cost is established by objective means, such as an
appraisal or an industry valuation guideline. Replacement costs are often used for insurance reporting and special financial statements.

mnLastYearsReplacementCost ALRC MATH_NUMERIC OPT NONE

The estimate cost to replace the asset if purchased in the prior year. You must use the query facility for reports.

szAssetCostAcct_BU AMCU char OPT NONE

The business unit to which the system charges original acquisition cost and any supplemental capital additions. The system uses a default
value for this field based on the business unit that you specify on the Asset Master Revisions form when you create a new asset master
record. You can change this default value on the Depreciation Information form only if you have not entered any transactions for the account.

szAssetCostAcct_OBJ AOBJ char OPT NONE

The object account to which the original acquisition cost and any supplemental capital additions have been charged. If the asset is a
non-capitalized lease, this should be the expense account that lease payments are charged to. This expense account should have default coding
instructions set up for method 00 (no depreciation method used).

szAssetCostAcct_SUB ASUB char OPT NONE

The subsidiary account to which the original acquisition cost and any supplemental capital additions have been charged.

szAccumDepreAcct_BU DMCU char OPT NONE

The business unit to which the system charges accumulated depreciation amounts.

szAccumDepreAcct_OBJ DOBJ char OPT NONE

The object account number to which the accumulated depreciation amount is to be charged.

szAccumDepreAcct_SUB DSUB char OPT NONE

The subsidiary account to which the accumulated depreciation amount is to be charged.

szDepreciationExpense_BU XMCU char OPT NONE

The business unit to which the system charges depreciation expense.

szDepreciationExpense_OBJ XOBJ char OPT NONE

The object account to which the depreciation expense is to be charged.

szDepreciationExpense_SUB XSUB char OPT NONE

The subsidiary number to which the depreciation expense is to be charged.

szAssetRevenue_BU RMCU char OPT NONE

The business unit that the system credits for revenue amounts that originate in Equipment/Plant Management billing programs.

szAssetRevenue_OBJ ROBJ char OPT NONE

The object account the system credits for revenue amounts that originate in Equipment/Plant Management billing programs.

szAssetRevenue_SUB RSUB char OPT NONE

The subsidiary account that the system credits for revenue amounts that originate in Equipment/Plant Management billing programs.

mnCurrentItemQty ARCQ MATH_NUMERIC OPT NONE

This is the current number of units for an asset. The current item quantity is used in conjunction with the original quantity. The Current Item
Quantity field should always reflect the current or remaining amount of units.

mnOriginalItemQty AROQ MATH_NUMERIC OPT NONE

The original number of units for an asset. If assets are purchased and accounted for in quantities (more than one), you can specify the
original quantity purchased. For example, if you purchase 100 office chairs, you would set up one asset item with an original quantity of 100. Then,
as you disposed of office chairs, you would adjust the current quantity to reflect the current balance. This adjustment allows you to track
assets purchased in bulk quantity on one master record.

mnTaxEntity TXJS MATH_NUMERIC OPT NONE

The address number of the tax authority to which property taxes are paid.

mnITC AITY MATH_NUMERIC OPT NONE

The amount of investment tax credit (ITC) to be considered in depreciation calculations.

mnAmtInvTaxCrPye AITP MATH_NUMERIC OPT NONE

The investment tax credit amount taken in the prior year.

cFinancingMethod FINC char OPT NONE

A user defined code (12/FM) that indicates how a fixed asset was acquired, for example financed or purchased outright.

cItcOwnedFlag ITCO char OPT NONE

Investment Tax Credit.  Data item not used.

cPurchaseOption PURO char OPT NONE

A code that indicates whether there is an option to purchase a leased or rented asset. This code is informational only. Valid values are: Y
Yes, there is a purchase option for the asset. N No, there is not a purchase option for the asset.

mnPurchaseOptionPrice APUR MATH_NUMERIC OPT NONE

A number that indicates the purchase price, if you have the option to purchase a leased or rented asset. This field is informational only.

mnAmtPurchaseOptionMax APOM MATH_NUMERIC OPT NONE

A number that indicates the maximum monetary amount that applies toward the purchase, if applicable. For example, if a portion of the
monthly payment is credited towards the eventual purchase of the asset, this number indicates the maximum monthly credit. This concept is
typically used with IBM rentals.

mnLessorRentor LANO MATH_NUMERIC OPT NONE

The address book number for the lessor, renter, or lending institution.

jdContractDate JCD JDEDATE OPT NONE

The date the contract for the asset was put into effect.

jdDateExpired DEXJ JDEDATE OPT NONE

The date that the contract for the asset expired.

mnMonthlyPayment AMF MATH_NUMERIC OPT NONE

A number that indicates the amount of the monthly payment for the asset you are financing, renting, or leasing. This field is informational
only.

szRemark RMK char OPT NONE

A generic field that you use for a remark, description, name, or address.

szRemark_Line2 RMK2 char OPT NONE

A generic field that you use for a remark, description, name, or address.

szInsurancePolicyNumber INSP char OPT NONE

A reference number for information only.

szInsuranceCompany INSC char OPT NONE

The name of the company issuing a specific insurance policy for a piece of equipment or property.

mnInsurancePremium INSA MATH_NUMERIC OPT NONE

The cost of the insurance premium.

mnInsuranceValue AIV MATH_NUMERIC OPT NONE

The declared value for insurance reporting purposes. You must use the query facility to prepare reports as prescribed by your insurance
company.

mnInsuranceValueIndex INSI MATH_NUMERIC OPT NONE

Data item not used.

szLocation LOC char OPT NONE

The current physical location of an asset. The location must have a valid business unit or job number in the Business Unit Master table
(F0006).

szState ADDS char OPT NONE

A user defined code (00/S) that specifies the state or province. This code is usually a postal service abbreviation.

jdStartEffectiveDate EFTB JDEDATE OPT NONE

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.

jdDateExpectedReturn DER JDEDATE OPT NONE

The date the equipment is expected to be returned from a particular location.

cClearedY MSGA char OPT NONE

A code to indicate which messages should be displayed. A Y code will display all messages, including those that have been cleared or
processed, but not those already deleted. Any value other than Y will display current messages only.

szExplanation EX char OPT NONE

A description, remark, name, or address.

szRemarkExplanation EXR char OPT NONE

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

mnAddressNumber AN8 MATH_NUMERIC OPT NONE

A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.

szClassCode6 ACL6 char OPT NONE

A user defined code (12/C6) that classifies assets into groups or families. You use this code to further define the subclass codes.

szClassCode7 ACL7 char OPT NONE

A user defined code (12/C7) that classifies assets into groups or families. You use this category code to further define the subclass codes.

szClassCode8 ACL8 char OPT NONE

A user defined code (system 12, type C8) that is used to classify assets into groups or families. You use this category code to further define
the subclass codes.

szClassCode9 ACL9 char OPT NONE

A user defined code (system 12, type C9) that is used to classify assets into groups or families. You use this category code to further define
the subclass codes.

szClassCode0 ACL0 char OPT NONE

A user defined code (12/CO) that groups similar items for billing. If you are an Equipment Management client and you use Equipment
Billing, you must use this category code for rate group purposes only.

mnStandardFuelConsumption SFC MATH_NUMERIC OPT NONE

The standard fuel consumption per unit (hour or mile) as described in the manufacturer's specifications.  This can be compared with the
actual fuel consumption to measure performance and to validate the reasonableness of actual consumption.

szDisposalAccumDepr_BU DADC char OPT NONE

The business unit to which accumulated depreciation was backed out of at time of disposal.

szDisposalAccumDepr_OBJ DADO char OPT NONE

The object account to which accumulated depreciation was backed out of at time of disposal.

szDisposalAccumDepr_SUB DADS char OPT NONE

The subsidiary to which accumulated depreciation was backed out of at time of disposal.

szUnitNo UNIT char OPT NONE

The number that identifies the actual space within a building that is or can be leased, such as an apartment, office, retail space, parking
space, and so on.

mnParentItemNoShort KIT MATH_NUMERIC OPT NONE

The system provides for three separate item numbers.    1.   Item Number (short) - An eight-digit, computer assigned, completely
non-significant item number.    2.   2nd Item Number - The 25-digit, free form, user defined alphanumeric item number.    3.   3rd Item Number - Another
25-digit, free form, user defined alphanumeric item number.

szParentItemNoLong KITL char OPT NONE

The system provides for three separate item numbers.    1.   Item Number (short) - An eight-digit, computer assigned, completely
non-significant item number.    2.   2nd Item Number - The 25-digit, free form, user defined alphanumeric item number.    3.   3rd Item Number - Another
25-digit, free form, user defined alphanumeric item number. This is used in a parts list as either a parent or component number. In the Equipment
Management system, this item is used for memo purposes only.

szAfeNumber AFE char OPT NONE

Authorization for Expenditure unit number. This number is used for informational purposes only.

szJobCategory JBCD char OPT NONE

A user defined code (07/G) that defines the jobs within your organization. You can associate pay and benefit information with a job type and
apply that information to the employees who are linked to that job type.

szJobStep JBST char OPT NONE

A user defined code (07/GS) that designates a specific level within a particular job type. The system uses this code in conjunction with job
type to determine pay rates by job in the Pay Rates table.

szUnionCode UN char OPT NONE

A user defined code (06/UN) that represents the union or plan in which the employee or group of employees work or participate.

cSubledgerInactiveCode SBLI char OPT NONE

An option that indicates whether a specific subledger is inactive. Examples of inactive subledgers are jobs that are closed, employees
who have been terminated, or assets that have been disposed. Turn on this option to indicate that a subledger is inactive. If a subledger
becomes active again, turn off this option. If you want to use subledger information in the tables for reports, but you want to prevent transactions
from posting to the record in the Account Balances table (F0902), turn on this option. Valid values are: Off Subledger active On Subledger inactive

szCategoryCode20 FA0 char OPT NONE

A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the
Asset Master. Use UDC 12/F0 to view or change values for this category code.

szCatagoryCode11 FA1 char OPT NONE

A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the
Asset Master. Use UDC 12/F1 to view or change values for this category code.

szCategoryCode12 FA2 char OPT NONE

A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the
Asset Master. Use UDC 12/F2 to view or change values for this category code.

szCategoryCode13 FA3 char OPT NONE

A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the
Asset Master. Use UDC 12/F3 to view or change values for this category code.

szCategoryCode14 FA4 char OPT NONE

A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the
Asset Master. Use UDC 12/F4 to view or change values for this category code.

szCategoryCode15 FA5 char OPT NONE

A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the
Asset Master. Use UDC 12/F5 to view or change values for this category code.

szCategoryCode16 FA6 char OPT NONE

A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the
Asset Master. Use UDC 12/F6 to view or change values for this category code.

szCategoryCode17 FA7 char OPT NONE

A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the
Asset Master. Use UDC 12/F7 to view or change values for this category code.

szCategoryCode18 FA8 char OPT NONE

A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the
Asset Master. Use UDC 12/F8 to view or change values for this category code.

szCategoryCode19 FA9 char OPT NONE

A three digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the
Asset Master. Use UDC 12/F9 to view or change values for this category code.

szCategoryCode21 FA21 char OPT NONE

A 10-digit category code that can be specified for any purpose. This code can then be used to selectively extract specific assets from the
Item Master. See User Defined Codes, system 12, code 21 to view and/or change values for this category code.

szCategoryCode22 FA22 char OPT NONE

A 10 digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset
Master. Use UDC 12/22 to view or change values for this category code.

szCategoryCode23 FA23 char OPT NONE

A 10 digit category code that can be used for any purpose. You can then use this code to selectively extract specific assets from the Asset
Master. Use UDC 12/23 to view or change values for this category code.

cAllowWorkOrderYN WOYN char OPT NONE

A code that indicates whether a piece of equipment or asset may be entered on a work order. Valid values are:                                                  1
or Y Entry is allowed.   0 or N Entry is not allowed.

mnCriticality CRTL MATH_NUMERIC OPT NONE

A code that indicates the criticality of the piece of equipment or PM schedule. This code is used in calculating the criticality of the work
order.

cWarrantyFlag WRFL char OPT NONE

A code that indicates whether a piece of equipment is under warranty. Valid values are: Blank Not under warranty 1      Under warranty

jdWarrantyExpiration WARJ JDEDATE OPT NONE

The date through which the product warranty is in effect.

mnPurchaseOptionCreditPct PURP MATH_NUMERIC OPT NONE

The fixed percentage of the monthly payment that applies to the purchase of the asset. Enter a percent as a decimal. For example, enter
25% as .25.

mnPolicyRenewalMonth INSM MATH_NUMERIC OPT NONE

The month in which the insurance policy is to be renewed.

jdDtLastChanged LCT JDEDATE OPT NONE

The day a master or transaction record was last changed.

szAccountNumber ANI char OPT NONE

A value that identifies an account in the general ledger. Use one of the following formats to enter account numbers:   o  Standard account
number (business unit.object.subsidiary or flex format).   o  Third G/L number (maximum of 25 digits).   o  Account ID number. The number is eight
digits long.     o  Speed code, which is a two-character code that you concatenate to the AAI item SP. You can then enter the code instead of
an account number. The first character of the account number indicates its format. You define the account format in the General Accounting
constants.

szProductModel PRODM char OPT NONE

A code that classifies an inventory item into a model for customer service. Some examples include: Laser Printer, Inkjet or Fax.

szAssetMasterMBFCacheName JBNM char OPT NONE

This is the name of a job in the system.

Related Functions

B1200260 Cache Process Asset Master MBF

Related Tables

None