D1702680 - CRM Routing PreProcess
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both | 
|---|---|---|---|---|
| mnOrderNumber | DOCO | MATH_NUMERIC | OPT | NONE | 
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry, 
  | ||||
| mnOperationSequence | OPSQ | MATH_NUMERIC | OPT | NONE | 
A number used to indicate an order of succession.
In routing instructions, a number that sequences the fabrication or assembly steps in the 
  | ||||
| szOperationCode | OPSC | char | OPT | NONE | 
A user defined code (30/OT) that indicates the type of operation. Valid values include: A Alternate routing TT Travel time IT Idle time T Text  | ||||
| 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 
  | ||||
| szOrderType | DCTO | char | OPT | NONE | 
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has 
  | ||||
| szTypeRouting | TRT | char | OPT | NONE | 
A user defined code (40/TR) that indicates the type of routing. You can define different types of routing instructions for different uses.
For 
  | ||||
| szWorkCenter | 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 | DSC1 | char | OPT | NONE | 
Brief information about an item; a remark or an explanation.  | ||||
| szOperationStatus | OPST | char | OPT | NONE | 
User defined code system 31, type OS. The operation status code that identifies the current status of a work order or engineering change 
  | ||||
| mnCustomer | 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 
  | ||||
| jdOrderDate | TRDJ | JDEDATE | OPT | NONE | 
The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing.  | ||||
| jdRequestDate | DRQJ | JDEDATE | OPT | NONE | 
The date that an item is scheduled to arrive or that an action is scheduled for completion.  | ||||
| jdStartDate | STRT | JDEDATE | OPT | NONE | 
The start date for the order. You can enter this date manually, or have the system calculate it using a backscheduling routine. The routine 
  | ||||
| jdCompletionDate | STRX | JDEDATE | OPT | NONE | 
The date that the work order or engineering change order is completed or canceled.  | ||||
| mnBeginningTime | PBTM | MATH_NUMERIC | OPT | NONE | 
A field that is used to enter the beginning time of the operation sequence for the work center operation on the routing.  | ||||
| mnEndingTime | PETM | MATH_NUMERIC | OPT | NONE | 
A field that is used to enter the ending time of the operation sequence for the work center operation on the routing.  | ||||
| mnCrewSize | SETC | MATH_NUMERIC | OPT | NONE | 
The number of people who work in the specified work center or routing operation.
The system multiplies the Run Labor value in the Routing 
  | ||||
| mnEstimatedHours | RUNL | MATH_NUMERIC | OPT | NONE | 
The standard hours of labor that you expect to incur in the normal production of this item.
The run labor hours in the Routing Master table 
  | ||||
| mnActualHours | LABA | MATH_NUMERIC | OPT | NONE | 
This is the actual labor time in hours recorded for the work order.  | ||||
| mnRatePiecework | PWRT | MATH_NUMERIC | OPT | NONE | 
The rate to be paid for the type of component (piece) being produced.  | ||||
| szUnitOfMeasure | UOM | char | OPT | NONE | 
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box).  | ||||
| szObjectAccount | OBJ | char | OPT | NONE | 
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into 
  | ||||
| szSubsidiary | SUB | char | OPT | NONE | 
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.  | ||||
| mnEmployee | VEND | MATH_NUMERIC | OPT | NONE | 
The address book number of the preferred provider of this item.  | ||||
| szCompanyKeyRelated | RKCO | char | OPT | NONE | 
The key company that is associated with the document number of the related order.  | ||||
| szRelatedPoSoNumber | RORN | char | OPT | NONE | 
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 | NONE | 
A user defined code (system 00, type DT) that indicates the document type of the secondary or related order. For example, a purchase 
  | ||||
| mnRelatedPoSoLineNo | RLLN | MATH_NUMERIC | OPT | NONE | 
A number of the detail line on the related order for which the current order was created. For example, on a purchase order created to fill 
  | ||||
| szUserReservedCode | URCD | char | OPT | NONE | 
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.  | ||||
| jdUserReservedDate | URDT | JDEDATE | OPT | NONE | 
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.  | ||||
| mnUserReservedAmount | URAT | MATH_NUMERIC | OPT | NONE | 
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.  | ||||
| szUserReservedReference | URRF | char | OPT | NONE | 
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 | NONE | 
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.  | ||||
| szUserId | USER | char | OPT | NONE | 
The code that identifies a user profile.  | ||||
| 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 
  | ||||
| szWorkStationId | JOBN | char | OPT | NONE | 
The code that identifies the work station ID that executed a particular job.  | ||||
| jdDateUpdated | UPMJ | JDEDATE | OPT | NONE | 
The date that specifies the last update to the file record.  | ||||
| mnTimeOfDay | TDAY | MATH_NUMERIC | OPT | NONE | 
The computer clock in hours:minutes:seconds.  | ||||
| cPayableYN | PAYAB | char | OPT | NONE | 
This field specifies whether a general ledger account should be paid. Valid values are:
   Y The account should be paid.
   N The account 
  | ||||
| cBillableYN | BILL | char | OPT | NONE | 
Specifies whether a general ledger account should be billed. Valid codes are:
   Y Yes, the account should be billed.
   N No, it should not be 
  | ||||
| jdDatePaid | DTPAY | JDEDATE | OPT | NONE | 
The date a service provider was paid for a service.  | ||||
| jdDateBilled | DTBIL | JDEDATE | OPT | NONE | 
In service billing, the date a customer was billed for a service.  | ||||
| mnEstUnitBillAmnt | ESRTB | MATH_NUMERIC | OPT | NONE | 
The estimated billable rate associated with a service.  | ||||
| mnEstBillAmnt | EBILL | MATH_NUMERIC | OPT | NONE | 
| mnActUnitBillAmnt | ACRTB | MATH_NUMERIC | OPT | NONE | 
The actual billable rate associated with a transaction.  | ||||
| mnActBillAmnt | TOTB | MATH_NUMERIC | OPT | NONE | 
The total amount billed through this application number.  | ||||
| szCostType | COST | char | OPT | NONE | 
A code that designates each element of cost for an item. Examples of the cost object types are:
  o  A1  Purchased raw material
  o  B1  
  | ||||
| szGLCategoryNonCovered | GLCNC | char | OPT | NONE | 
A user defined code (41/9) that identifies the G/L Offset to use when the system is searching for the account to which it will post the 
  | ||||
| szGLCategoryCovered | GLCCV | char | OPT | NONE | 
A user defined code (41/9) that identifies the G/L Offset to use when the system is searching for the account to which it will post the covered 
  | ||||
| szEntitlementCheck | ENTCK | char | OPT | NONE | 
A user defined code (17/ER) to indicate the results of an entitlement check.
Valid values are:
   0   Not entitled
   1   Transaction entitled
   2   
  | ||||
| cMethodofPricing | MTHPR | char | OPT | NONE | 
A code used to determine if this type of service should be priced based on a flat rate or based on actual time and materials.
Valid values 
  | ||||
| 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.  | ||||
| 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.  | ||||
| szCoverageGroup | COVGR | char | OPT | NONE | 
A user defined code that specifies the Coverage Group. The Coverage Group consists of unlimited cost codes and the percentage 
  | ||||
| cPayPricingMethod | PMTHP | char | OPT | NONE | 
A code used to determine if this type of service should be priced based on a flat rate or based on actual time and materials.
Valid values 
  | ||||
| cPayServProviderForParts | PYPRT | char | OPT | NONE | 
A code to indicate if the service provider should be paid for parts used during a repair.
Valid values are:
       Y or 1 - Pay the service provider 
  | ||||
| mnSiteNumber | SAID | MATH_NUMERIC | OPT | NONE | 
A unique numeric identifier for a physical location at which utility service is delivered.  A service address often corresponds to a parcel of 
  | ||||
| mnPercentCovered | PCOVR | MATH_NUMERIC | OPT | NONE | 
The percentage covered under warranty or contract. This is used to calculate the amount to bill or the amount to cost for the line item being 
  | ||||
| szAdjustScheduleService | ASN2 | char | OPT | NONE | 
This user defined code (40/AS) identifies a price and adjustment schedule. A price and adjustment schedule contains one or more 
  | ||||
| szAdjustScheduleFour | ASN4 | char | OPT | NONE | 
A user defined code (40/AS) identifying a price and adjustment schedule. A price and adjustment schedule contains one or more 
  | ||||
| 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 
  | ||||
| cActionCode | ACTN | char | OPT | NONE | 
A code that specifies the action that is performed. Valid values are: A Add C Change  | ||||
| szErrorMessage | 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 
  | ||||
| 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 
  | ||||
| mnJobnumber | JOBS | MATH_NUMERIC | OPT | NONE | 
The job number (work station ID) which executed the particular job.  | ||||
| szCapacityUOM | CAPU | char | OPT | NONE | 
A unit of measure that you use to express the capacity of a production line. Examples of units of measure include hours, number of 
  | ||||
| cTimeBasisCode | TIMB | char | OPT | NONE | 
A user defined code (30/TB) that indicates how machine or labor hours are expressed for a product. Time basis codes identify the time 
  | ||||
| mnPercentOfOverlap | POVR | MATH_NUMERIC | OPT | NONE | 
A number that indicates the percentage that successive operations can overlap.
The actual overlap percentage entered for the operation 
  | ||||
| mnNextOperation | NXOP | MATH_NUMERIC | OPT | NONE | 
The operation number with which the current operation can be simultaneously processed.  | ||||
| mnMoveHours | MOVD | MATH_NUMERIC | OPT | NONE | 
The planned hours that are required to move the order from this operation to the next operation in the same work center.
If the Routing 
  | ||||
| mnQueueHours | QUED | MATH_NUMERIC | OPT | NONE | 
The total hours that an order is expected to be in queue at work centers and moving between work centers.
The system stores this value in 
  | ||||
| mnSetupLaborHrsStdr | SETL | MATH_NUMERIC | OPT | NONE | 
The standard setup hours that you expect to incur in the normal completion of this item. This value is not affected by crew size.  | ||||
| szMessageNo | SHNO | char | OPT | NONE | 
A generic rates and message code (48/SN) that is assigned to a standard note, message, or general narrative explanation. You can use 
  | ||||
| mnAssetItemNumber | NUMB | MATH_NUMERIC | OPT | NONE | 
An 8-digit number that uniquely identifies an asset.  | ||||
| mnResourceunitsconsumed | RUC | MATH_NUMERIC | OPT | NONE | 
A number that indicates how many of the line's resource units are needed to produce one item.  | ||||
| mnAmountActual | AMTA | MATH_NUMERIC | OPT | NONE | 
The actual dollars accumulated for the work order.  | ||||
| mnAmountOriginalDollars | AMTO | MATH_NUMERIC | OPT | NONE | 
The estimated monetary amount that is budgeted for this work order.  | ||||
| mnClaimAmount | CLAMT | MATH_NUMERIC | OPT | NONE | 
The amount requested for providing a service.  | ||||
| mnLaborRatePerHour | LBR1 | MATH_NUMERIC | OPT | NONE | 
Under a Service Contract, the labor rate per hour charged while providing the service for each day of the week and for holidays.  For 
  | ||||
| jdDateActualStart | D2J | JDEDATE | OPT | NONE | 
Enter the actual start date for a project or job in this field. Use this information for reporting purposes.  | ||||
| mnActualStartTime | STTI | MATH_NUMERIC | OPT | NONE | 
This is the start time for an operation or an order.  | ||||
| mnEstEndingHhMmSs | EPETM | MATH_NUMERIC | OPT | NONE | 
The estimated ending time associated with a work order.  | ||||
| szDocumentType | DCT | char | OPT | NONE | 
A user defined code (00/DT) that identifies the origin and purpose of the transaction.  PeopleSoft reserves several prefixes for document 
  | ||||
| szBaseCurrency | CRCD | char | OPT | NONE | 
A code that identifies the currency of a transaction.  | ||||
| szBillableCurrency | BCRCD | char | OPT | NONE | 
The currency for the billable amounts of a service order.  | ||||
| mnBillableExchangeRate | BCRR | MATH_NUMERIC | OPT | NONE | 
The rate that the system uses to convert foreign currency amounts to domestic currency amounts. The system uses this rate specifically for 
  | ||||
| cBillableCurrencyMode | BCRRM | char | OPT | NONE | 
A code that specifies whether the system uses the foreign currency (currency of the customer) or the domestic currency for billable 
  | ||||
| szPayableCurrency | PCRCD | char | OPT | NONE | 
A code that indicates the currency of the payable amounts on a work order or claim.  | ||||
| mnPayableExchangeRate | PCRR | MATH_NUMERIC | OPT | NONE | 
The rate that the system uses to convert foreign currency amounts to domestic currency amounts. The system uses this rate specifically for 
  | ||||
| cPayableCurrencyMode | PCRRM | char | OPT | NONE | 
A code that specifies whether payable amounts are in the foreign currency (currency of the service provider) or in the domestic currency. 
  | ||||
| mnUniqueKeyPricing | UKIDP | MATH_NUMERIC | OPT | NONE | 
| mnForeignEstimatedBillableUnit | FESUNB | MATH_NUMERIC | OPT | NONE | 
The estimated unit rate that is billable in the currency of the customer.  | ||||
| mnForeignEstimatedBillableAmt | FEBILL | MATH_NUMERIC | OPT | NONE | 
The estimated billable amount in the currency of the customer.  | ||||
| mnForeignActualBillableUnit | FACUNB | MATH_NUMERIC | OPT | NONE | 
The actual unit rate that is billable in the currency of the customer.  | ||||
| mnForeignActualBillableAmt | FTOTB | MATH_NUMERIC | OPT | NONE | 
The actual amount that is billable in the currency of the customer.  | ||||
| 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 
  | ||||
| szOrderSuffix_SFXO | SFXO | char | OPT | NONE | 
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 
  | ||||
| mnItemNumberShortKit_KIT | KIT | MATH_NUMERIC | OPT | NONE | 
The system provides for three separate item numbers.
   1.   Item Number (short) - An eight-digit, computer assigned, completely 
  | ||||
| szItemNumber2ndKit_KITL | KITL | char | OPT | NONE | 
The system provides for three separate item numbers.
   1.   Item Number (short) - An eight-digit, computer assigned, completely 
  | ||||
| szItemNumber3rdKit_KITA | KITA | char | OPT | NONE | 
The system provides three separate item numbers:
   1. Item Number (short) - An eight-digit, computer assigned, completely non-significant 
  | ||||
| szLineIdentifier_LINE | LINE | char | OPT | NONE | 
A number that defines a production line or cell. Detailed work center operations can be defined inside the line or cell.  | ||||
| szAutoLoadDescription_ALD | ALD | char | OPT | NONE | 
This field is used to pull in a standard description from a user defined for the specified operation.  | ||||
| szInspectionCode_INPE | INPE | char | OPT | NONE | 
Future use. This is a user defined code specifying the type of normal inspection practice for this particular item.  Examples that could be 
  | ||||
| cLaborOrMachine_LAMC | LAMC | char | OPT | NONE | 
A code to designate whether the operation is labor or machine.  | ||||
| cPayPointCode_BFPF | BFPF | char | OPT | NONE | 
A code that indicates whether a work center has labor, material, or both,backflushed through it when quantities are reported against 
  | ||||
| cPayPointStatus_PPRF | PPRF | char | OPT | NONE | 
A code that indicates whether the operation should be taken to a status of complete or partially complete. Valid values are:
   Blank Not 
  | ||||
| szJobCategory_JBCD | 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 
  | ||||
| mnCriticalRatio_CRTR | CRTR | MATH_NUMERIC | OPT | NONE | 
Reserved by J.D. Edwards.  | ||||
| mnSlackTimeRatio_SLTR | SLTR | MATH_NUMERIC | OPT | NONE | 
Reserved by J.D. Edwards.  | ||||
| cShiftCodeRequested_RSFT | RSFT | char | OPT | NONE | 
| cShiftCodeStart_SSFT | SSFT | char | OPT | NONE | 
| cShiftCodeCompleted_CSFT | CSFT | char | OPT | NONE | 
| mnLeadtimeOverlap_LTPC | LTPC | MATH_NUMERIC | OPT | NONE | 
Future use This field is used to modify the normal logic in the backscheduling routine. If operation number 010 starts on day one and is 
  | ||||
| mnPercentOperationalPl_OPYP | OPYP | MATH_NUMERIC | OPT | NONE | 
The planned output yield percent for a step. The Planned Yield Update program uses this value to update the cumulative percent in the 
  | ||||
| mnPercentCumulativePla_CPYP | CPYP | MATH_NUMERIC | OPT | NONE | 
The cumulative planned output yield percent for a step. The system uses this value to adjust the operation step scrap percent for the 
  | ||||
| mnRunMachineStandard_RUNM | RUNM | MATH_NUMERIC | OPT | NONE | 
The standard machine hours that you expect to incur in the normal production of this item.  | ||||
| mnRunMachineActual_MACA | MACA | MATH_NUMERIC | OPT | NONE | 
This is the actual machine time in hours recorded against the work order.  | ||||
| mnSetupLaborHoursActual_SETA | SETA | MATH_NUMERIC | OPT | NONE | 
The actual time in hours of setup labor recorded against the work order operation.  | ||||
| mnOperationShrinkage_OPSR | OPSR | MATH_NUMERIC | OPT | NONE | 
Future use. This field indicates the percentage of scrap that is typically encountered for this operation for this part.  If the quantity ordered is 
  | ||||
| mnUnitsTransactionQty_UORG | UORG | MATH_NUMERIC | OPT | NONE | 
The quantity of units affected by this transaction.  | ||||
| mnUnitsQuantityCanceled_SOCN | SOCN | MATH_NUMERIC | OPT | NONE | 
The number of units canceled in Sales Order or Work Order Processing, using either the entered or the primary unit of measure defined for 
  | ||||
| mnUnitsQuantityShipped_SOQS | SOQS | MATH_NUMERIC | OPT | NONE | 
The number of units committed for shipment in Sales Order Entry, using either the entered or the primary unit of measure defined for this 
  | ||||
| mnUnitsQuantityMovedT_QMTO | QMTO | MATH_NUMERIC | OPT | NONE | 
The quantity that is physically at the step at the work center.  | ||||
| mnUnacctSetupLaborHrs_CTS2 | CTS2 | MATH_NUMERIC | OPT | NONE | 
The number of unaccounted setup labor hours associated with a specific operation for a work order.  | ||||
| mnUnacctMachineHours_CTS3 | CTS3 | MATH_NUMERIC | OPT | NONE | 
The number of unaccounted machine hours associated with a specific operation for a work order.  | ||||
| mnUnacctDirectLaborAmt_CTS4 | CTS4 | MATH_NUMERIC | OPT | NONE | 
The amount of unaccounted direct labor associated with a specific operation for a work order.  | ||||
| mnUnacctDirectSetupAmt_CTS5 | CTS5 | MATH_NUMERIC | OPT | NONE | 
The amount of unaccounted setup labor associated with a specific operation for a work order.  | ||||
| mnUnacctDirectMachAmt_CTS6 | CTS6 | MATH_NUMERIC | OPT | NONE | 
The amount of unaccounted machine dollars associated with a specific operation for a work order.  | ||||
| szUnitNumber_APID | 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 
  | ||||
| szLocation_LOCN | LOCN | char | OPT | NONE | 
The storage location from which goods will be moved.  | ||||
| szWorkcenterBranch_WMCU | WMCU | char | OPT | NONE | 
This is the branch/plant to which the work center belongs and must exist in the business unit master (F0006) and branch plant constants file 
  | ||||
| mnRunMachineCurrent_CMHR | CMHR | MATH_NUMERIC | OPT | NONE | 
The current machine hours from the Routing Master table (F3003) at the time the routing is attached to the production document.
The run 
  | ||||
| mnRunLaborCurrent_CLHR | CLHR | MATH_NUMERIC | OPT | NONE | 
This is the current labor hours from the Routing Master table (F3003) at the time the routing is attached to the production document.
The run 
  | ||||
| mnSetupLaborCurrent_CSHR | CSHR | MATH_NUMERIC | OPT | NONE | 
The current setup hours from the Routing Master table (F3003) at the time the routing is attached to the production document.  | ||||
| szActivityCode_ACTB | ACTB | char | OPT | NONE | 
The aggregation of actions performed within an organization that are useful for purposes of activity-based costing.  | ||||
| mnUnacctScrapAmt_CTS7 | CTS7 | MATH_NUMERIC | OPT | NONE | 
The amount of unaccounted scrap dollars associated with a specific component for a work order.  Manufacturing accounting uses this 
  | ||||
| mnUnacctScrapUnits_CTS8 | CTS8 | MATH_NUMERIC | OPT | NONE | 
The number of units of unaccounted scrap that the system associates with a specific component for a work order.  Manufacturing 
  | ||||
| mnUnacctDirectLaborHrs_CTS9 | CTS9 | MATH_NUMERIC | OPT | NONE | 
The number of direct labor hours associated with a specific operation that are unaccounted for on a work order.  | ||||
| mnLaborRate_LABP | LABP | MATH_NUMERIC | OPT | NONE | 
A number that specifies the rate used to determine the estimated cost of labor hours for a specific operation in the Enter/Change Routing 
  | ||||
| mnMachineRate_MACR | MACR | MATH_NUMERIC | OPT | NONE | 
A rate that the system uses to determine the machine run cost for a specific item at a specific operation in the Work With Routing Master 
  | ||||
| mnSetupLaborRate_SETR | SETR | MATH_NUMERIC | OPT | NONE | 
A number that specifies the rate that you use to estimate the cost of setup labor for a specific operation in the Work With Routing Master 
  | ||||
| cConstraintsFlag_APSC | APSC | char | OPT | NONE | 
A code that specifies that the entity is constraint-based and can be planned by SCP.  | ||||
| mnTimeSchStartHHMMSS_SEST | SEST | MATH_NUMERIC | OPT | NONE | 
The time of day that an activity is scheduled to begin. The start time is calculated by the constraints based planning system.  | ||||
| mnTimeSchEndHHMMSS_SEET | SEET | MATH_NUMERIC | OPT | NONE | 
The time of day that an activity is scheduled to end. The end time is calculated by the constraints-based planning system.  | ||||
| mnTimeCompleted_TMCO | TMCO | MATH_NUMERIC | OPT | NONE | 
The time the task was completed.  | ||||
| szCompentencyType_CMPE | CMPE | char | OPT | NONE | 
A code that identifies a competency table or category for which you can track employee competencies. Valid values 
  | ||||
| szCompentencyCode_CMPC | CMPC | char | OPT | NONE | 
A code that specifies a competency within a competency type. For example, a competency for the competency type "Skill" might be "C 
  | ||||
| mnCompetencyLevelFrom_CPLVLFR | CPLVLFR | MATH_NUMERIC | OPT | NONE | 
This value set the lowest value to be included in the rule criteria range for a competency level range selection.  | ||||
| mnCompetencyLevelTo_CPLVLTO | CPLVLTO | MATH_NUMERIC | OPT | NONE | 
This value set the highest value to be included in the rule criteria range for a competency level range selection.  | ||||
| cRuleMatchFlag_CMRQ | CMRQ | char | OPT | NONE | 
A field that indicates whether the resource must satisfy the requirements that define the rule criteria. Valid values are:
   1   The resource must 
  | ||||
| mnActRatePay_ACRTP | ACRTP | MATH_NUMERIC | OPT | NONE | 
The actual payable rate associated with a transaction.  | ||||
| mnEstRatePay_ESRTP | ESRTP | MATH_NUMERIC | OPT | NONE | 
The estimated payable rate associated with a transaction.  | ||||
| mnEstPaymntAmount_EPAAP | EPAAP | MATH_NUMERIC | OPT | NONE | 
This is the estimated payment amount used in service billing.  | ||||
| mnPaymntAmount_PAAP | PAAP | MATH_NUMERIC | OPT | NONE | 
In the Accounts Payable system, the amount of the payment.
In the Accounts Receivable system, the amount of the receipt. This amount 
  | ||||
| szCurrencyCodeTo_CRDC | CRDC | char | OPT | NONE | 
A code that identifies the domestic (base) currency of the company on a transaction.  | ||||
| mnForeignEstPayableU_FESUNP | FESUNP | MATH_NUMERIC | OPT | NONE | 
The estimated unit rate that is payable in the currency of the service provider.  | ||||
| mnForeignEstPayableA_FEPAAP | FEPAAP | MATH_NUMERIC | OPT | NONE | 
The estimated payable amount in the currency of the service provider.  | ||||
| mnForeignActualPayAmou_FPAAP | FPAAP | MATH_NUMERIC | OPT | NONE | 
The actual payable amount that is recorded in the foreign currency of the service provider.  | ||||
| mnForeignActualPayUnit_FACUNP | FACUNP | MATH_NUMERIC | OPT | NONE | 
The actual unit rate that is payable in the currency of the service provider.  | ||||
| jdDateSubmitted_DTSUB | DTSUB | JDEDATE | OPT | NONE | 
The date that a supplier recovery claim was submitted to the interoperability tables for Warranty Claim/Supplier Recovery 
  | ||||
| mnTimeSubmitted_TMSUB | TMSUB | MATH_NUMERIC | OPT | NONE | 
The time that a supplier recovery claim was submitted to the interoperability tables.  | ||||
| mnCausalPart_CSLPRT | CSLPRT | MATH_NUMERIC | OPT | NONE | 
The item number that indicates which part failed and caused the equipment failure.  | ||||
| cInvoiceRequired_INVREQ | INVREQ | char | OPT | NONE | 
A code that determines whether an invoice is required. Valid values are: 0 An invoice is not required. 1 An invoice is required.  | ||||
| cInvoiceReceived_INVREC | INVREC | char | OPT | NONE | 
A code that indicates whether an invoice is received. Valid values are: 0 An invoice is not received. 1 An invoice is received.  | ||||
| szCompCode_Assembly_VMRS32 | VMRS32 | char | OPT | NONE | 
A user defined code (17/C7) that indicates the location of a specific assembly, such as the air conditioning compressor, within a piece of 
  | ||||
| szCostCenterCsl_MCUCSL | MCUCSL | char | OPT | NONE | 
The business unit that is related to the causal portion of the claim.  | ||||
| szVendorLotNumber_RLOT | RLOT | char | OPT | NONE | 
The supplier's lot number for the item.  | ||||
| mnSRVendorNo_SRVEND | SRVEND | MATH_NUMERIC | OPT | NONE | 
The address book number of the vendor to be used for supplier recovery.  | ||||
| szDefectCode_FAILCD | FAILCD | char | OPT | NONE | 
A user defined code (17/FC) that indicates the type of defect.  | ||||
| szCompCodeGrpSys_VMRS31 | VMRS31 | char | OPT | NONE | 
A user defined code (17/C6) that indicates a specific system, such as the air conditioning system, that is associated with a piece of 
  | ||||
| szCompCodePart_VMRS33 | VMRS33 | char | OPT | NONE | 
A user defined code (17/C8) that indicates the location of a specific part, such as the fuse to the air conditioning compressor clutch,  within a 
  | ||||
| cLaborSource_LSRCE | LSRCE | char | OPT | NONE | 
A user defined code (17/LS) that specifies whether the system tracks labor amounts and information or whether it tracks third-party invoice 
  | ||||
| None | 
| None |