D1200010A - F1201 Process Master Data Data Structure
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 | ||||
cUpdateMasterFile | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cProcessEdits | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cSuppressErrorMessage | SUPPS | char | OPT | NONE |
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.
0 = allow
| ||||
szErrorMessageID | DTAI | char | OPT | NONE |
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
| ||||
szCallingProgramVersion | VERS | char | OPT | NONE |
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
| ||||
szCallingProgramId | 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
| ||||
szProcessModule | VC04A | char | OPT | NONE |
This is a generic field used as a work field in Everest. | ||||
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
| ||||
mnItemNumber | 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
| ||||
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.
| ||||
szSerialNumber | 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
| ||||
mnSequenceNumber | SEQ | MATH_NUMERIC | OPT | NONE |
A number that specifies the sequence of information. | ||||
szMajorAccountingClass | 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
| ||||
szMajorEquipmentClass | 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
| ||||
szManufacturer | 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
| ||||
szModelYear | 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
| ||||
szUsageMilesOrHours | 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
| ||||
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
| ||||
szDescription | DL01 | char | OPT | NONE |
A user defined name or remark. | ||||
szDescription_02 | DL02 | char | OPT | NONE |
Additional text that further describes or clarifies a field in the system. | ||||
szDescription_03 | DL03 | char | OPT | NONE |
Additional text that further describes or clarifies an element. | ||||
szCompressedDescription | DSCC | char | OPT | NONE |
The compressed description contains the alpha name without spaces, slashes,dashes, commas, and other special characters. The
| ||||
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
| ||||
jdDateDisposedOrRetired | 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. | ||||
cNewOrUsedAcquisition | 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
| ||||
mnEstimatedSalvageValue | AESV | MATH_NUMERIC | OPT | NONE |
The estimated salvage value at the end of the useful life of an asset. | ||||
mnReplacementCost | 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
| ||||
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. | ||||
szAssetCostAcctBusinessUnit | 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
| ||||
szAssetCostAcctObject | 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
| ||||
szAssetCostAcctSubsidiary | ASUB | char | OPT | NONE |
The subsidiary account to which the original acquisition cost and any supplemental capital additions have been charged. | ||||
szAccumDeprAcctBusinessUnit | DMCU | char | OPT | NONE |
The business unit to which the system charges accumulated depreciation amounts. | ||||
szAccumDeprAcctObject | DOBJ | char | OPT | NONE |
The object account number to which the accumulated depreciation amount is to be charged. | ||||
szAccumDeprAcctSubsidiary | DSUB | char | OPT | NONE |
The subsidiary account to which the accumulated depreciation amount is to be charged. | ||||
szDepreciationExpBusinessUnit | XMCU | char | OPT | NONE |
The business unit to which the system charges depreciation expense. | ||||
szDepreciationExpObject | XOBJ | char | OPT | NONE |
The object account to which the depreciation expense is to be charged. | ||||
szDepreciationExpSubsidiary | XSUB | char | OPT | NONE |
The subsidiary number to which the depreciation expense is to be charged. | ||||
szAssetRevenueBusinessUnit | RMCU | char | OPT | NONE |
The business unit that the system credits for revenue amounts that originate in Equipment/Plant Management billing programs. | ||||
szAssetRevenueObject | ROBJ | char | OPT | NONE |
The object account the system credits for revenue amounts that originate in Equipment/Plant Management billing programs. | ||||
szAssetRevenueSubsidiary | 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
| ||||
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
| ||||
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. | ||||
mnInvestmentTaxCredit | AITP | MATH_NUMERIC | OPT | NONE |
The investment tax credit amount taken in the prior year. | ||||
cFinanceMethod | FINC | char | OPT | NONE |
A user defined code (12/FM) that indicates how a fixed asset was acquired, for example financed or purchased outright. | ||||
cITCOwnedFlagYN | 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
| ||||
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. | ||||
mnPurchaseOptionMaxAmount | 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
| ||||
mnLessorRenterOrMortgagor | 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
| ||||
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. | ||||
szPolicyNumber | 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
| ||||
mnValueIndex | 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
| ||||
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. | ||||
jdStartEffectiveDateForLocChg | 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.
| ||||
jdExpectedReturnDate | 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
| ||||
szExplanation | EX | char | OPT | NONE |
A description, remark, name, or address. | ||||
szExplanationRemark | 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
| ||||
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
| ||||
szCategoryCode6 | 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. | ||||
szCategoryCode7 | 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. | ||||
szCategoryCode8 | 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
| ||||
szCategoryCode9 | 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
| ||||
szRateGroup | 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
| ||||
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
| ||||
szDispAccumDepr_CC | DADC | char | OPT | NONE |
The business unit to which accumulated depreciation was backed out of at time of disposal. | ||||
szDispAccumDepr_Obj | DADO | char | OPT | NONE |
The object account to which accumulated depreciation was backed out of at time of disposal. | ||||
szDispAccumDepr_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
| ||||
mnParentItemNumber | KIT | MATH_NUMERIC | OPT | NONE |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
| ||||
sz2ndItemNumber | KITL | char | OPT | NONE |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
| ||||
szAFENumber | AFE | char | OPT | NONE |
Authorization for Expenditure unit number. This number is used for informational purposes only. | ||||
szJobType | 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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
cAllowWorkOrder | 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
| ||||
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
| ||||
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
| ||||
mnPolicyRenewalMonth | INSM | MATH_NUMERIC | OPT | NONE |
The month in which the insurance policy is to be renewed. | ||||
jdDateLastChanged | LCT | JDEDATE | OPT | NONE |
The day a master or transaction record was last changed. | ||||
szProgramIDForProcOpt | 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
| ||||
szVersionForProcOpt | VERS | char | OPT | NONE |
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
| ||||
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
| ||||
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. | ||||
cUpdateChildStatusOnChange | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cUpdateChildBUOnChange | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnStartEffectiveTimeForStatChg | BEGT | MATH_NUMERIC | OPT | NONE |
The time at which the status of a piece of equipment or a work order changes. Use the HH:MM format (for example, 12:35). | ||||
szAssetMasterMBFCacheName | JBNM | char | OPT | NONE |
This is the name of a job in the system. | ||||
szEquipTagMBFCacheName | JBNM | char | OPT | NONE |
This is the name of a job in the system. | ||||
cAutomaticCleanup | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
jdStartEffectiveForParentChg | 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.
| ||||
jdStartEffectiveForStatusChg | 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.
| ||||
jdStartEffectiveForAddrNumChg | 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.
| ||||
mnBeginTimeForAddrNumChg | BEGT | MATH_NUMERIC | OPT | NONE |
The time at which the status of a piece of equipment or a work order changes. Use the HH:MM format (for example, 12:35). | ||||
cUpdateChildrenOnAddrChg | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szCountry | CTR | char | OPT | NONE |
A user defined code (00/CN) that identifies a country. The country code has no effect on currency conversion.
The Address Book system
| ||||
szBranch | MMCU | char | OPT | NONE |
A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which
| ||||
szProductFamily | PRODF | char | OPT | NONE |
A code that classifies an inventory item into a group for customer service. Some examples include: Laser Printer, Inkjet, or Fax. |
None |
None |