D90CD001 - Equipment Master Display
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnAssetItemNumber_NUMB | NUMB | MATH_NUMERIC | OPT | BOTH |
An 8-digit number that uniquely identifies an asset. | ||||
szDescCompressed_DSCC | DSCC | char | OPT | OUTPUT |
The compressed description contains the alpha name without spaces, slashes,dashes, commas, and other special characters. The
| ||||
szDescription001_DL01 | DL01 | char | OPT | OUTPUT |
A user defined name or remark. | ||||
szDescription01002_DL02 | DL02 | char | OPT | OUTPUT |
Additional text that further describes or clarifies a field in the system. | ||||
szDescription01003_DL03 | DL03 | char | OPT | OUTPUT |
Additional text that further describes or clarifies an element. | ||||
szProgramId_PID | PID | char | OPT | INPUT |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
szAccountNumber_ANI | ANI | char | OPT | OUTPUT |
A value that identifies an account in the general ledger. Use one of the following formats to enter account numbers:
o Standard account
| ||||
szAcctDescription_DL01 | DL01 | char | OPT | OUTPUT |
A user defined name or remark. | ||||
cBasedOnFormat_EV01 | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event. | ||||
mnShortItemNumber_ITM | ITM | MATH_NUMERIC | OPT | BOTH |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
szPrimaryItemNo_UITM | UITM | char | OPT | OUTPUT |
A number that the system assigns to an item. It can be in short, long, or third item number format. | ||||
szInventoryItemDesc_DSC1 | DSC1 | char | OPT | OUTPUT |
Brief information about an item; a remark or an explanation. | ||||
szNameAlpha_ALPH | ALPH | char | OPT | OUTPUT |
The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter
| ||||
szCostCenter_MCU | MCU | char | OPT | OUTPUT |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
szCustomerNumber_ALKY | ALKY | char | OPT | OUTPUT |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
| ||||
mnCustomerNumber_AN8 | AN8 | MATH_NUMERIC | OPT | BOTH |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
szSiteNumber_ALKY | ALKY | char | OPT | OUTPUT |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
| ||||
mnSiteNumber_LANO | LANO | MATH_NUMERIC | OPT | BOTH |
The address book number for the lessor, renter, or lending institution. | ||||
szServiceProvider_ALKY | ALKY | char | OPT | OUTPUT |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
| ||||
mnServiceProvider_PA8 | PA8 | MATH_NUMERIC | OPT | INPUT |
The address book number of the parent company. The system uses this number to associate a particular address with a parent company
| ||||
cDefaultLocation_EV01 | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event. | ||||
szBusinessUnitLocation_LOC | LOC | char | OPT | OUTPUT |
The current physical location of an asset. The location must have a valid business unit or job number in the Business Unit Master table
| ||||
cDateAcquired_EV01 | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event. | ||||
jdDateBeginningEffective | EFTB | JDEDATE | OPT | OUTPUT |
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program.
| ||||
jdDateAcquired_DAJ | DAJ | JDEDATE | OPT | OUTPUT |
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
| ||||
jdInstallationDate_JCD | JCD | JDEDATE | OPT | OUTPUT |
The date the contract for the asset was put into effect. | ||||
cAssessorDefault_EV01 | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event. | ||||
mnAssessorNumber_AN8AS | AN8AS | MATH_NUMERIC | OPT | INPUT |
The address book number that identifies the assessor. | ||||
szCountry_CTR | CTR | char | OPT | OUTPUT |
A user defined code (00/CN) that identifies a country. The country code has no effect on currency conversion.
The Address Book system
| ||||
szBranchPlant_MMCU | MMCU | char | OPT | OUTPUT |
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
| ||||
szProductModel_PRODM | PRODM | char | OPT | OUTPUT |
A code that classifies an inventory item into a model for customer service. Some examples include: Laser Printer, Inkjet or Fax. | ||||
szProductFamily_PRODF | PRODF | char | OPT | OUTPUT |
A code that classifies an inventory item into a group for customer service. Some examples include: Laser Printer, Inkjet, or Fax. | ||||
szAssessorNumber_ALKY | ALKY | char | OPT | OUTPUT |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
| ||||
CUSTOMER_NUMBER_ALKY | ALKY | char | OPT | OUTPUT |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
| ||||
SITE_NUMBER_ALKY | ALKY | char | OPT | OUTPUT |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
| ||||
ASSESSOR_NUMBER_ALKY | ALKY | char | OPT | OUTPUT |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
| ||||
cEvent_EV01 | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event. | ||||
szSerialNumber_ASID | ASID | char | OPT | OUTPUT |
A 25-character alphanumeric number that you can use as an alternate asset identification number. You might use this number to track
| ||||
szCompany_CO | CO | char | OPT | OUTPUT |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
szUnitNumber_APID | APID | char | OPT | OUTPUT |
A 12-character alphanumeric code used as an alternate identification number for an asset. This number is not required, nor does the
| ||||
mnParentEquipmentNumber_AAID | AAID | MATH_NUMERIC | OPT | INPUT |
A parent number groups related components together. You can associate each item of property and piece of equipment with a parent item.
| ||||
mnSequenceNumber_SEQ | SEQ | MATH_NUMERIC | OPT | OUTPUT |
A number that specifies the sequence of information. | ||||
szMajorAccountingClass_ACL1 | ACL1 | char | OPT | OUTPUT |
A user defined code (12/C1) that determines the accounting class category code. You use this accounting category code to classify assets
| ||||
szMajorEquipmentClass_ACL2 | ACL2 | char | OPT | OUTPUT |
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
| ||||
szModelYear_ACL4 | ACL4 | char | OPT | OUTPUT |
A user defined code (12/C4) that classifies assets into groups or families. You use the model year category code to further define the
| ||||
szUsageMilesHours_ACL5 | ACL5 | char | OPT | OUTPUT |
A user defined code (12/C5) that classifies assets into groups or families. You use the usage category codes to further define the subclass
| ||||
jdDateDisposal_DSP | DSP | JDEDATE | OPT | OUTPUT |
The date the asset was disposed. | ||||
szEquipmentStatus_EQST | EQST | char | OPT | OUTPUT |
A user defined code (12/ES) that identifies the equipment or disposal status of an asset, such as available, down, or disposed. | ||||
cNewOrUsedOnAcquisit_NORU | NORU | char | OPT | OUTPUT |
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
| ||||
mnAmtEstSalvageValue_AESV | AESV | MATH_NUMERIC | OPT | OUTPUT |
The estimated salvage value at the end of the useful life of an asset. | ||||
mnAmountReplacementCost_ARPC | ARPC | MATH_NUMERIC | OPT | OUTPUT |
The current or estimated replacement cost of the asset. Typically, replacement cost is established by objective means, such as an
| ||||
mnAmtLastYearsReplaceCost_ALRC | ALRC | MATH_NUMERIC | OPT | OUTPUT |
The estimate cost to replace the asset if purchased in the prior year. You must use the query facility for reports. | ||||
szAssetCostAcctBusUnit_AMCU | AMCU | char | OPT | OUTPUT |
The business unit to which the system charges original acquisition cost and any supplemental capital additions. The system uses a default
| ||||
szAssetCostAcctObject_AOBJ | AOBJ | char | OPT | OUTPUT |
The object account to which the original acquisition cost and any supplemental capital additions have been charged.
If the asset is a
| ||||
szAssetCostActSubsid_ASUB | ASUB | char | OPT | OUTPUT |
The subsidiary account to which the original acquisition cost and any supplemental capital additions have been charged. | ||||
szAcumDeprAcctBU_DMCU | DMCU | char | OPT | OUTPUT |
The business unit to which the system charges accumulated depreciation amounts. | ||||
szAccumDepreAcctObj_DOBJ | DOBJ | char | OPT | OUTPUT |
The object account number to which the accumulated depreciation amount is to be charged. | ||||
szAccumDepreAcctSub_DSUB | DSUB | char | OPT | OUTPUT |
The subsidiary account to which the accumulated depreciation amount is to be charged. | ||||
szDepreciationExpenseBU_XMCU | XMCU | char | OPT | OUTPUT |
The business unit to which the system charges depreciation expense. | ||||
szDepreciationExpenseObj_XOBJ | XOBJ | char | OPT | OUTPUT |
The object account to which the depreciation expense is to be charged. | ||||
szDepreciaExpenseSubsid_XSUB | XSUB | char | OPT | OUTPUT |
The subsidiary number to which the depreciation expense is to be charged. | ||||
szAssetRevenueBusUnit_RMCU | RMCU | char | OPT | OUTPUT |
The business unit that the system credits for revenue amounts that originate in Equipment/Plant Management billing programs. | ||||
szAssetRevenueObject_ROBJ | ROBJ | char | OPT | OUTPUT |
The object account the system credits for revenue amounts that originate in Equipment/Plant Management billing programs. | ||||
szAssetRevenueSubsidiary_RSUB | RSUB | char | OPT | OUTPUT |
The subsidiary account that the system credits for revenue amounts that originate in Equipment/Plant Management billing programs. | ||||
mnAssetItemCurrentQuan_ARCQ | ARCQ | MATH_NUMERIC | OPT | OUTPUT |
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
| ||||
mnAssetItemOrigQuan_AROQ | AROQ | MATH_NUMERIC | OPT | OUTPUT |
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 | TXJS | MATH_NUMERIC | OPT | OUTPUT |
The address number of the tax authority to which property taxes are paid. | ||||
mnAmtInvTaxCredit_AITY | AITY | MATH_NUMERIC | OPT | OUTPUT |
The amount of investment tax credit (ITC) to be considered in depreciation calculations. | ||||
mnAmtInvTaxCredit_AITP | AITP | MATH_NUMERIC | OPT | OUTPUT |
The investment tax credit amount taken in the prior year. | ||||
cFinancingMethod_FINC | FINC | char | OPT | OUTPUT |
A user defined code (12/FM) that indicates how a fixed asset was acquired, for example financed or purchased outright. | ||||
cItcOwnedFlag_ITCO | ITCO | char | OPT | OUTPUT |
Investment Tax Credit. Data item not used. | ||||
cPurchaseOption_PURO | PURO | char | OPT | OUTPUT |
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_PURO | APUR | MATH_NUMERIC | OPT | OUTPUT |
A number that indicates the purchase price, if you have the option to purchase a leased or rented asset. This field is informational only. | ||||
mnPurchaseOptionMaxCredit_APOM | APOM | MATH_NUMERIC | OPT | OUTPUT |
A number that indicates the maximum monetary amount that applies toward the purchase, if applicable. For example, if a portion of the
| ||||
jdInstallDate_JCD | JCD | JDEDATE | OPT | INPUT |
The date the contract for the asset was put into effect. | ||||
jdDateExpiredJulian_DEXJ | DEXJ | JDEDATE | OPT | BOTH |
The date that the contract for the asset expired. | ||||
mnMonthlyPayment_AMF | AMF | MATH_NUMERIC | OPT | OUTPUT |
A number that indicates the amount of the monthly payment for the asset you are financing, renting, or leasing. This field is informational
| ||||
szNameRemark_RMK | RMK | char | OPT | OUTPUT |
A generic field that you use for a remark, description, name, or address. | ||||
szNameRemarksLine2_RMK2 | RMK2 | char | OPT | OUTPUT |
A generic field that you use for a remark, description, name, or address. | ||||
szInsurancePolicyNumber_INSP | INSP | char | OPT | OUTPUT |
A reference number for information only. | ||||
szInsuranceCompany_INSC | INSC | char | OPT | OUTPUT |
The name of the company issuing a specific insurance policy for a piece of equipment or property. | ||||
mnInsurancePremium_INSA | INSA | MATH_NUMERIC | OPT | OUTPUT |
The cost of the insurance premium. | ||||
mnAmountInsuranceValue_AIV | AIV | MATH_NUMERIC | OPT | OUTPUT |
The declared value for insurance reporting purposes. You must use the query facility to prepare reports as prescribed by your insurance
| ||||
mnInsuranceValueIndex_INSI | INSI | MATH_NUMERIC | OPT | OUTPUT |
Data item not used. | ||||
szState_ADDS | ADDS | char | OPT | INPUT |
A user defined code (00/S) that specifies the state or province. This code is usually a postal service abbreviation. | ||||
jdDateExpectedReturn_DER | DER | JDEDATE | OPT | OUTPUT |
The date the equipment is expected to be returned from a particular location. | ||||
cActionMessageControl_MSGA | MSGA | char | OPT | OUTPUT |
A code to indicate which messages should be displayed.
A Y code will display all messages, including those that have been cleared or
| ||||
szNameExplanation_EX | EX | char | OPT | OUTPUT |
A description, remark, name, or address. | ||||
szNameRemarkExplanation_EXR | EXR | char | OPT | OUTPUT |
A name or remark that describes the purpose for using an account or conveys any other information that the user wants about the
| ||||
szCategoryCode6_ACL6 | ACL6 | char | OPT | OUTPUT |
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 | ACL7 | char | OPT | OUTPUT |
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 | ACL8 | char | OPT | OUTPUT |
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
| ||||
szRateGroup_ACL0 | ACL0 | char | OPT | OUTPUT |
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 | SFC | MATH_NUMERIC | OPT | OUTPUT |
The standard fuel consumption per unit (hour or mile) as described in the manufacturer's specifications. This can be compared with the
| ||||
szDisposalAccumDepreBU_DADC | DADC | char | OPT | OUTPUT |
The business unit to which accumulated depreciation was backed out of at time of disposal. | ||||
szDisposalAccumDepreObj_DADO | DADO | char | OPT | OUTPUT |
The object account to which accumulated depreciation was backed out of at time of disposal. | ||||
szDisposalAccumDepreSub_DADS | DADS | char | OPT | OUTPUT |
The subsidiary to which accumulated depreciation was backed out of at time of disposal. | ||||
szUnitNo_UNIT | UNIT | char | OPT | OUTPUT |
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 | KIT | MATH_NUMERIC | OPT | INPUT |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
| ||||
sz2ndItemNumber_KITL | KITL | char | OPT | INPUT |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
| ||||
szAfeNumber_AFE | AFE | char | OPT | OUTPUT |
Authorization for Expenditure unit number. This number is used for informational purposes only. | ||||
szJobCategory_JBCD | JBCD | char | OPT | OUTPUT |
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 | JBST | char | OPT | OUTPUT |
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 | UN | char | OPT | OUTPUT |
A user defined code (06/UN) that represents the union or plan in which the employee or group of employees work or participate. | ||||
szFACategoryCode20_FA0 | FA0 | char | OPT | OUTPUT |
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
| ||||
szFACatagoryCode11_FA1 | FA1 | char | OPT | OUTPUT |
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
| ||||
szFACategoryCode12_FA2 | FA2 | char | OPT | OUTPUT |
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
| ||||
szFACategoryCode13_FA3 | FA3 | char | OPT | OUTPUT |
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
| ||||
szFACategoryCode14_FA4 | FA4 | char | OPT | OUTPUT |
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
| ||||
szFACategoryCode15_FA5 | FA5 | char | OPT | OUTPUT |
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
| ||||
szFACategoryCode16_FA6 | FA6 | char | OPT | OUTPUT |
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
| ||||
szFACategoryCode17_FA7 | FA7 | char | OPT | OUTPUT |
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
| ||||
szFACategoryCode18_FA8 | FA8 | char | OPT | OUTPUT |
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
| ||||
szFACategoryCode19_FA9 | FA9 | char | OPT | OUTPUT |
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
| ||||
szFACategoryCode21_FA21 | FA21 | char | OPT | OUTPUT |
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
| ||||
szFACategoryCode22_FA22 | FA22 | char | OPT | OUTPUT |
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
| ||||
szFACategoryCode23_FA23 | FA23 | char | OPT | OUTPUT |
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 | WOYN | char | OPT | OUTPUT |
A code that indicates whether a piece of equipment or asset may be entered on a work order. Valid values are:
1
| ||||
mnCriticality_CRTL | CRTL | MATH_NUMERIC | OPT | OUTPUT |
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
| ||||
jdDateWarrantyExpiraJu_WARJ | WARJ | JDEDATE | OPT | OUTPUT |
The date through which the product warranty is in effect. | ||||
mnPolicyRenewalMonth_INSM | INSM | MATH_NUMERIC | OPT | OUTPUT |
The month in which the insurance policy is to be renewed. | ||||
jdDtLastChanged_LCT | LCT | JDEDATE | OPT | OUTPUT |
The day a master or transaction record was last changed. | ||||
cTermsAcceptedFlag_TERMYN | TERMYN | char | OPT | OUTPUT |
A code that specifies whether the owner of the equipment has agreed to the the terms and conditions presented regarding the ownership of
| ||||
szRegistrationStatus_REGSTS | REGSTS | char | OPT | OUTPUT |
A code that specifies the current registration status for an equipment record. Enter a value from UDC 17/RS. | ||||
jdInServiceDate_INSDTE | INSDTE | JDEDATE | OPT | OUTPUT |
The date that the equipment was placed into service. | ||||
szParentNumber_ASII | ASII | char | OPT | OUTPUT |
An identification code that represents an asset. You enter the identification code in one of the following formats:
1
Asset number (a
| ||||
szPartsListNumber_ASII | ASII | char | OPT | OUTPUT |
An identification code that represents an asset. You enter the identification code in one of the following formats:
1
Asset number (a
| ||||
cCompanyOwned_COOWN | COOWN | char | OPT | OUTPUT |
A flag that indicates if an equipment record is company owned. | ||||
cProofOfPurchase_WRFL | WRFL | char | OPT | OUTPUT |
A code that indicates whether a piece of equipment is under warranty. Valid values are: Blank Not under warranty 1 Under warranty | ||||
szParentModel_PRODM | PRODM | char | OPT | OUTPUT |
A code that classifies an inventory item into a model for customer service. Some examples include: Laser Printer, Inkjet or Fax. | ||||
szSalesType_SATYP | SATYP | char | OPT | OUTPUT |
A code that specifies the sales type for the equipment. Enter a value from UDC 17/SY. | ||||
cMeterReadingRequired_MRRYN | MRRYN | char | OPT | OUTPUT |
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
| ||||
szManufacturer_ACL3 | ACL3 | char | OPT | OUTPUT |
A user defined code (12/C3) that classifies assets into groups or families. You use the manufacturer category code to further define
| ||||
szProductComponent_PRODC | PRODC | char | OPT | OUTPUT |
The components that make an equipment number or components associated with a customer site. | ||||
szEquipmentCatCode01_ZE01 | ZE01 | char | OPT | OUTPUT |
A user defined reporting code for equipment. | ||||
szEquipmentCatCode02_ZE02 | ZE02 | char | OPT | OUTPUT |
A user defined reporting code for equipment. | ||||
szEquipmentCatCode03_ZE03 | ZE03 | char | OPT | OUTPUT |
A user defined reporting code for equipment. | ||||
szEquipmentCatCode04_ZE04 | ZE04 | char | OPT | OUTPUT |
A user defined reporting code for equipment. | ||||
szEquipmentCatCode05_ZE05 | ZE05 | char | OPT | OUTPUT |
A user defined reporting code for equipment. | ||||
szEquipmentCatCode06_ZE06 | ZE06 | char | OPT | OUTPUT |
A user defined reporting code for equipment. Enter a value from UDC 17/B6. | ||||
szEquipmentCatCode07_ZE07 | ZE07 | char | OPT | OUTPUT |
A user defined reporting code for equipment. | ||||
szEquipmentCatCode08_ZE08 | ZE08 | char | OPT | OUTPUT |
A user defined reporting code for equipment. | ||||
szEquipmentCatCode09_ZE09 | ZE09 | char | OPT | OUTPUT |
A user defined reporting code for equipment. | ||||
szEquipmentCatCode10_ZE10 | ZE10 | char | OPT | OUTPUT |
A user defined reporting code for equipment. | ||||
szServiceTechnician_ALKY | ALKY | char | OPT | OUTPUT |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
| ||||
szLeasedFrom_ALKY | ALKY | char | OPT | OUTPUT |
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 | ALKY | char | OPT | OUTPUT |
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 | ALKY | char | OPT | OUTPUT |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
| ||||
mnServiceTechnician_ANOB | ANOB | MATH_NUMERIC | OPT | INPUT |
The address number of an alternate location to which the owner wants the invoice (application) sent. | ||||
mnDefaultDealer_AN8DL | AN8DL | MATH_NUMERIC | OPT | INPUT |
The default Dealer for the Customer. | ||||
mnDistributor_AN8DR | AN8DR | MATH_NUMERIC | OPT | INPUT |
The address book number that identifies the distributor of the equipment. | ||||
mnLeasedFrom_SLSM | SLSM | MATH_NUMERIC | OPT | INPUT |
The first of two salespeople who have responsibility for or can receive a commission on sales to this customer.
You create this code by
| ||||
SERVICE_PROVIDER | ALKY | char | OPT | OUTPUT |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
| ||||
SERVICE_TECHNICIAN | ALKY | char | OPT | OUTPUT |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
| ||||
SALES_PERSON | ALKY | char | OPT | OUTPUT |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
| ||||
DEFAULT_DEALER | ALKY | char | OPT | OUTPUT |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
| ||||
DISTRIBUTOR | ALKY | char | OPT | OUTPUT |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
| ||||
szCategoryCode9_ACL9 | ACL9 | char | OPT | OUTPUT |
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
| ||||
mnEquipmentPartsNumber | EQPN | MATH_NUMERIC | OPT | INPUT |
cSubledgerInactiveCode_SBLI | SBLI | char | OPT | OUTPUT |
An option that indicates whether a specific subledger is inactive. Examples of inactive subledgers are jobs that are closed, employees
| ||||
jdContractStartDate_CSDT | CSDT | JDEDATE | OPT | OUTPUT |
The date you actually start work on the contract. | ||||
jdContractEndDate_CDTE | CDTE | JDEDATE | OPT | OUTPUT |
The date you actually completed work on the contract. | ||||
cContractFound_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cEqmtFlashMsgExist_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cSiteFlashMsgExist_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cCustomerFlashMsgExist_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cProdModelFlashMsgExist_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cInventoryFlashMsgExist_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cMapToAcctClass_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cMapToEqmtClass_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cMapToManufacturer_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cMapToModelYear_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cMapToUsageMiles_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cMapToCategoryCode6_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cMapToCategoryCode7_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cMapToCategoryCode8_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cMapToCategoryCode9_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cMapToCategoryCode10_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cMapToCategoryCode11_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cMapToCategoryCode12_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cMapToCategoryCode13_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cMapToCategoryCode14_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cMapToCategoryCode15_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cMapToCategoryCode16_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cMapToCategoryCode17_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cMapToCategoryCode18_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cMapToCategoryCode19_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cMapToCategoryCode20_EV01 | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
szCacheName_JBNM | JBNM | char | OPT | BOTH |
This is the name of a job in the system. | ||||
mnDocumentOrderInvoiceE | DOCO | MATH_NUMERIC | OPT | OUTPUT |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
szOrderType | DCTO | char | OPT | OUTPUT |
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
| ||||
szCompanyKeyOrderNo | KCOO | char | OPT | OUTPUT |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
mnLineNumber | LNID | MATH_NUMERIC | OPT | OUTPUT |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
jdDateOrderedJulian | ORDJ | JDEDATE | OPT | OUTPUT |
The date you entered the sales or purchase order into the system. | ||||
jdDateShippedJulian | SHPJ | JDEDATE | OPT | OUTPUT |
The date on which you confirm that a specific order line was shipped. | ||||
jdActualShipDate | ADDJ | JDEDATE | OPT | OUTPUT |
The date on which the shipment to the customer is confirmed as shipped. During shipment confirmation, the system updates the Sales
| ||||
szRelatedPoSoNumber | RORN | char | OPT | OUTPUT |
A number that identifies a secondary purchase order, sales order, or work order that is associated with the original order. This number is for
| ||||
szRelatedOrderType | RCTO | char | OPT | OUTPUT |
A user defined code (system 00, type DT) that indicates the document type of the secondary or related order. For example, a purchase
| ||||
jdDateCompletion | STRX | JDEDATE | OPT | OUTPUT |
The date that the work order or engineering change order is completed or canceled. | ||||
mnPrimaryLastVendorNo | VEND | MATH_NUMERIC | OPT | OUTPUT |
The address book number of the preferred provider of this item. | ||||
szOriginalPoSoNumber | OORN | char | OPT | OUTPUT |
The original document number. This can be a voucher, an invoice, unapplied cash, a journal entry number, and so on Matching document
| ||||
szOriginalOrderType | OCTO | char | OPT | OUTPUT |
This code defines the order type. It is verified in user defined codes (40/OT). Reserved document types have been defined for voucher
| ||||
szCompanyKeyOriginal | OKCO | char | OPT | OUTPUT |
A number that is used in conjunction with the values in the ODOC and ODCT fields to identify a transaction. | ||||
mnOriginalLineNumber | OGNO | MATH_NUMERIC | OPT | OUTPUT |
A number identifying which line on the original order that the current line matches. | ||||
szOrderSuffix | SFXO | char | OPT | OUTPUT |
In the A/R and A/P systems, a code that corresponds to the pay item. In the Sales Order and Procurement systems, this code identifies
| ||||
szReferenceNumber | REFN | char | OPT | OUTPUT |
A Reference number or identification number as defined for a particular EDI transaction set or as specified by the Reference Number
| ||||
szUserReservedCode | URCD | char | OPT | OUTPUT |
This is a 2 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
szUserReservedReference | URRF | char | OPT | OUTPUT |
A 15-position reference that is reserved for the user. J.D. Edwards does not currently use this field and does not plan to use it in the future. | ||||
mnUserReservedNumber | URAB | MATH_NUMERIC | OPT | OUTPUT |
This is a 8 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
mnUserReservedAmount | URAT | MATH_NUMERIC | OPT | OUTPUT |
This is a 15 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
mnAddressNumberShipTo | SHAN | MATH_NUMERIC | OPT | OUTPUT |
The address number of the location to which you want to ship this order. The address book provides default values for customer address,
| ||||
szVehicleIdentNum | VINNU | char | OPT | OUTPUT |
jdUserReservedDate | URDT | JDEDATE | OPT | OUTPUT |
This is a 6 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
szCreatedByUser | CRTU | char | OPT | OUTPUT |
The address book number of the user who created this record. | ||||
szLot | LOTN | char | OPT | OUTPUT |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
szLocation | LOCN | char | OPT | OUTPUT |
The storage location from which goods will be moved. | ||||
mnWorkOrderNumber_WOD | WOD | MATH_NUMERIC | OPT | OUTPUT |
The order number from the work order. | ||||
szBillRevisionLevel | BREV | char | OPT | OUTPUT |
A value that indicates the revision level of a bill of material. It is usually used in conjunction with an engineering change notice or
| ||||
jdEffectiveFromDate | EFFF | JDEDATE | OPT | OUTPUT |
A date that indicates one of the following:
o When a component part goes into effect on a bill of material
o When a routing step goes into
| ||||
cEqmtMsgExist_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cSiteMsgExist_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cCustomerMsgExist_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cProdModelMsgExist_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cInventoryMsgExist_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. |
None |
None |