D90CD022 - CRM Equipment Cache
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both | 
|---|---|---|---|---|
| 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 
  | ||||
| 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 
  | ||||
| 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 
  | ||||
| szMajorAcctClass | 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 
  | ||||
| szMajorEquipClass | 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 
  | ||||
| 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 
  | ||||
| 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.  | ||||
| jdDateContract | JCD | JDEDATE | OPT | NONE | 
The date the contract for the asset was put into effect.  | ||||
| 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 
  | ||||
| szAfeNumber | AFE | char | OPT | NONE | 
Authorization for Expenditure unit number. This number is used for informational purposes only.  | ||||
| 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 
  | ||||
| szCategoryCodeFA0 | 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 
  | ||||
| szCatagoryCodeFA11 | 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 
  | ||||
| szCategoryCodeFA12 | 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 
  | ||||
| szCategoryCodeFA13 | 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 
  | ||||
| szCategoryCodeFA14 | 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 
  | ||||
| szCategoryCodeFA15 | 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 
  | ||||
| szCategoryCodeFA16 | 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 
  | ||||
| szCategoryCodeFA17 | 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 
  | ||||
| szCategoryCodeFA18 | 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 
  | ||||
| szCategoryCodeFA19 | 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 
  | ||||
| szCategoryCodeFA21 | 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 
  | ||||
| szCategoryCodeFA22 | 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 
  | ||||
| szCategoryCodeFA23 | 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 
  | ||||
| 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 
  | ||||
| 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  | ||||
| szCacheActionCode | CACTN | char | OPT | NONE | 
A code that indicates the activity you want to perform. Valid codes:
    o Get - Retrieve the cache element
    o Add - Add a cache element
    o 
  | ||||
| mnNumberKeys | NKEYS | MATH_NUMERIC | OPT | NONE | 
The number of keys in an index that will be used to retrieve, delete, or update a record.  | ||||
| szCacheName | JBNM | char | OPT | NONE | 
This is the name of a job in the system.  | ||||
| idCacheCursorPtr | GENLNG | ID | OPT | NONE | 
General purpose ID variable.  | ||||
| cSequentialFetch | EV01 | char | OPT | NONE | 
An option that specifies the type of processing for an event.  | ||||
| cErrorCode | ERRC | char | OPT | NONE | 
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document 
  | ||||
| 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 
  | ||||
| szParentNumber | ASII | char | OPT | NONE | 
An identification code that represents an asset. You enter the identification code in one of the following formats:
1
Asset number (a 
  | ||||
| szSiteNumber | ALKY | char | OPT | NONE | 
A user-defined name or number that identifies an address book record.  You can use this number to locate and enter information about the 
  | ||||
| szCustomerNumber | ALKY | char | OPT | NONE | 
A user-defined name or number that identifies an address book record.  You can use this number to locate and enter information about the 
  | ||||
| szParentModel | 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.  | ||||
| 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 
  | ||||
| szPartsListNumber | ASII | char | OPT | NONE | 
An identification code that represents an asset. You enter the identification code in one of the following formats:
1
Asset number (a 
  | ||||
| szRegistrationStatus | REGSTS | char | OPT | NONE | 
A code that specifies the current registration status for an equipment record. Enter a value from UDC 17/RS.  | ||||
| szDescription2 | DL02 | char | OPT | NONE | 
Additional text that further describes or clarifies a field in the system.  | ||||
| szDescription3 | DL03 | char | OPT | NONE | 
Additional text that further describes or clarifies an element.  | ||||
| cMeterReadingRequired | MRRYN | char | OPT | NONE | 
A code that specifies whether the system requires a value in one of the meter readings fields when you enter a warranty claim against a 
  | ||||
| szEquipmentDescription | DL01 | char | OPT | NONE | 
A user defined name or remark.  | ||||
| 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 
  | ||||
| szInventoryItemNo | UITM | char | OPT | NONE | 
A number that the system assigns to an item. It can be in short, long, or third item number format.  | ||||
| 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.  | ||||
| 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.  | ||||
| jdInServiceDate | INSDTE | JDEDATE | OPT | NONE | 
The date that the equipment was placed into service.  | ||||
| szSalesType | SATYP | char | OPT | NONE | 
A code that specifies the sales type for the equipment. Enter a value from UDC 17/SY.  | ||||
| cTermsAcceptedFlag | TERMYN | char | OPT | NONE | 
A code that specifies whether the owner of the equipment has agreed to the the terms and conditions presented regarding the ownership of 
  | ||||
| cCompanyOwned | COOWN | char | OPT | NONE | 
A flag that indicates if an equipment record is company owned.  | ||||
| szProductComponent | PRODC | char | OPT | NONE | 
The components that make an equipment number or components associated with a customer site.  | ||||
| szEquipmentCatCode1 | ZE01 | char | OPT | NONE | 
A user defined reporting code for equipment.  | ||||
| szEquipmentCatCode2 | ZE02 | char | OPT | NONE | 
A user defined reporting code for equipment.  | ||||
| szEquipmentCatCode3 | ZE03 | char | OPT | NONE | 
A user defined reporting code for equipment.  | ||||
| szEquipmentCatCode4 | ZE04 | char | OPT | NONE | 
A user defined reporting code for equipment.  | ||||
| szEquipmentCatCode5 | ZE05 | char | OPT | NONE | 
A user defined reporting code for equipment.  | ||||
| szEquipmentCatCode6 | ZE06 | char | OPT | NONE | 
A user defined reporting code for equipment. Enter a value from UDC 17/B6.  | ||||
| szEquipmentCatCode7 | ZE07 | char | OPT | NONE | 
A user defined reporting code for equipment.  | ||||
| szEquipmentCatCode8 | ZE08 | char | OPT | NONE | 
A user defined reporting code for equipment.  | ||||
| szEquipmentCatCode9 | ZE09 | char | OPT | NONE | 
A user defined reporting code for equipment.  | ||||
| szEquipmentCatCode10 | ZE10 | char | OPT | NONE | 
A user defined reporting code for equipment.  | ||||
| szAcctNo | 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 
  | ||||
| szManager | ALKY | char | OPT | NONE | 
A user-defined name or number that identifies an address book record.  You can use this number to locate and enter information about the 
  | ||||
| szTechnician | ALKY | char | OPT | NONE | 
A user-defined name or number that identifies an address book record.  You can use this number to locate and enter information about the 
  | ||||
| szDefaultDealer | ALKY | char | OPT | NONE | 
A user-defined name or number that identifies an address book record.  You can use this number to locate and enter information about the 
  | ||||
| szAssessorNumber | ALKY | char | OPT | NONE | 
A user-defined name or number that identifies an address book record.  You can use this number to locate and enter information about the 
  | ||||
| szDistributor | ALKY | char | OPT | NONE | 
A user-defined name or number that identifies an address book record.  You can use this number to locate and enter information about the 
  | ||||
| jdContractStartDate | CSDT | JDEDATE | OPT | NONE | 
The date you actually start work on the contract.  | ||||
| jdContractCompletionDate | CDTE | JDEDATE | OPT | NONE | 
The date you actually completed work on the contract.  | ||||
| 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.  
  | ||||
| jdDateExpectedReturn | DER | JDEDATE | OPT | NONE | 
The date the equipment is expected to be returned from a particular location.  | ||||
| None | 
| F1201 Asset Master File | ||||
| F1217 Equipment Master Extension |