D90CD032A - Load Work Order Labor Line
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both | 
|---|---|---|---|---|
| mnOrderNumber_DOCO | DOCO | MATH_NUMERIC | OPT | INPUT | 
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 | DCTO | char | OPT | INPUT | 
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 
  | ||||
| szProcessModule_VC04A | VC04A | char | OPT | INPUT | 
This is a generic field used as a work field in Everest.  | ||||
| mnJobNumber_JOBS | JOBS | MATH_NUMERIC | OPT | INPUT | 
The job number (work station ID) which executed the particular job.  | ||||
| nCacheRowNumber_INT01 | INT01 | integer | OPT | OUTPUT | 
Number of Days in Future to Query for Responses Due.  | ||||
| nCSMSCacheRowNumber_INT02 | INT02 | integer | OPT | BOTH | 
Number of Days in the Past to Query for Quote Requests Received.  | ||||
| nCSMSLastRowNumber_INT02 | INT02 | integer | OPT | BOTH | 
Number of Days in the Past to Query for Quote Requests Received.  | ||||
| idCSMSCacheCursor_GENLNG | GENLNG | ID | OPT | BOTH | 
General purpose ID variable.  | ||||
| mnOperationSeqNum_OPSQ | OPSQ | MATH_NUMERIC | OPT | INPUT | 
A number used to indicate an order of succession.
In routing instructions, a number that sequences the fabrication or assembly steps in the 
  | ||||
| szOperationTypeCode_OPSC | OPSC | char | OPT | INPUT | 
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  | ||||
| szWorkCenter_MCU | MCU | char | OPT | INPUT | 
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit 
  | ||||
| szOperationStatusCode_OPST | OPST | char | OPT | INPUT | 
User defined code system 31, type OS. The operation status code that identifies the current status of a work order or engineering change 
  | ||||
| szDescription_DSC1 | DSC1 | char | OPT | INPUT | 
Brief information about an item; a remark or an explanation.  | ||||
| mnEquipmentNumber_NUMB | NUMB | MATH_NUMERIC | OPT | INPUT | 
An 8-digit number that uniquely identifies an asset.  | ||||
| szEquipmentNumber_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 
  | ||||
| szEquipmentDescription_DL01 | DL01 | char | OPT | NONE | 
A user defined name or remark.  | ||||
| mnRunMachineRate_MACR | MACR | MATH_NUMERIC | OPT | OUTPUT | 
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 | OUTPUT | 
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 
  | ||||
| mnRunLaborRate_LABR | LABR | MATH_NUMERIC | OPT | OUTPUT | 
The number of labor hours required to process one unit of the parent item at a specific operation.  | ||||
| mnRunMachine_RUNM | RUNM | MATH_NUMERIC | OPT | INPUT | 
The standard machine hours that you expect to incur in the normal production of this item.  | ||||
| mnEstimatedHours_RUNL | RUNL | MATH_NUMERIC | OPT | INPUT | 
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 | LABA | MATH_NUMERIC | OPT | INPUT | 
This is the actual labor time in hours recorded for the work order.  | ||||
| mnSetupLabor_SETL | SETL | MATH_NUMERIC | OPT | INPUT | 
The standard setup hours that you expect to incur in the normal completion of this item. This value is not affected by crew size.  | ||||
| mnQueueHours_QUED | QUED | MATH_NUMERIC | OPT | INPUT | 
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 
  | ||||
| mnMoveHours_MOVD | MOVD | MATH_NUMERIC | OPT | INPUT | 
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 
  | ||||
| mnRatePiecework_PWRT | PWRT | MATH_NUMERIC | OPT | BOTH | 
The rate to be paid for the type of component (piece) being produced.  | ||||
| mnSetupCrew_SETC | SETC | MATH_NUMERIC | OPT | BOTH | 
The number of people who work in the specified work center or routing operation.
The system multiplies the Run Labor value in the Routing 
  | ||||
| jdStartDate_STRT | STRT | JDEDATE | OPT | BOTH | 
The start date for the order. You can enter this date manually, or have the system calculate it using a backscheduling routine. The routine 
  | ||||
| jdRequestDate_DRQJ | DRQJ | JDEDATE | OPT | BOTH | 
The date that an item is scheduled to arrive or that an action is scheduled for completion.  | ||||
| mnAssignedTo_AN8 | AN8 | MATH_NUMERIC | OPT | INPUT | 
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or 
  | ||||
| szAssignedTo_ALKY | 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 
  | ||||
| szAssignedToName_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 
  | ||||
| cPayPointCode_BFPF | BFPF | char | OPT | INPUT | 
A code that indicates whether a work center has labor, material, or both,backflushed through it when quantities are reported against 
  | ||||
| szMessageNumber_SHNO | SHNO | char | OPT | INPUT | 
A generic rates and message code (48/SN) that is assigned to a standard note, message, or general narrative explanation. You can use 
  | ||||
| szRelatedOrderNumber_RORN | RORN | char | OPT | INPUT | 
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 | RCTO | char | OPT | INPUT | 
A user defined code (system 00, type DT) that indicates the document type of the secondary or related order. For example, a purchase 
  | ||||
| mnNextOperation_NXOP | NXOP | MATH_NUMERIC | OPT | INPUT | 
The operation number with which the current operation can be simultaneously processed.  | ||||
| cTimeBasisCode_TIMB | TIMB | char | OPT | BOTH | 
A user defined code (30/TB) that indicates how machine or labor hours are expressed for a product. Time basis codes identify the time 
  | ||||
| mnPercentOverlap_POVR | POVR | MATH_NUMERIC | OPT | INPUT | 
A number that indicates the percentage that successive operations can overlap.
The actual overlap percentage entered for the operation 
  | ||||
| mnPlannedYieldPercentCum_CPYP | CPYP | MATH_NUMERIC | OPT | INPUT | 
The cumulative planned output yield percent for a step. The system uses this value to adjust the operation step scrap percent for the 
  | ||||
| mnPlannedYieldPercentOper_OPYP | OPYP | MATH_NUMERIC | OPT | INPUT | 
The planned output yield percent for a step. The Planned Yield Update program uses this value to update the cumulative percent in the 
  | ||||
| jdF4801RequestedDate_DRQJ | DRQJ | JDEDATE | OPT | INPUT | 
The date that an item is scheduled to arrive or that an action is scheduled for completion.  | ||||
| mnServiceProvider_VEND | VEND | MATH_NUMERIC | OPT | INPUT | 
The address book number of the preferred provider of this item.  | ||||
| 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 
  | ||||
| szServiceProviderName_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 
  | ||||
| szBranch_MMCU | MMCU | char | OPT | INPUT | 
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 
  | ||||
| szJobType_JBCD | JBCD | char | OPT | INPUT | 
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 
  | ||||
| jdCompletionDate_STRX | STRX | JDEDATE | OPT | INPUT | 
The date that the work order or engineering change order is completed or canceled.  | ||||
| mnExtendedCost_ECST | ECST | MATH_NUMERIC | OPT | BOTH | 
For accounts receivable and accounts payable, the invoice (gross) amount. For sales orders and purchase orders, the unit cost times the 
  | ||||
| mnResUnitsConsumed_RUC | RUC | MATH_NUMERIC | OPT | OUTPUT | 
A number that indicates how many of the line's resource units are needed to produce one item.  | ||||
| szCapacityUOM_CAPU | CAPU | char | OPT | OUTPUT | 
A unit of measure that you use to express the capacity of a production line. Examples of units of measure include hours, number of 
  | ||||
| szCompetencyType_CMPE | CMPE | char | OPT | INPUT | 
A code that identifies a competency table or category for which you can track employee competencies. Valid values 
  | ||||
| szCompetencyCode_CMPC | CMPC | char | OPT | INPUT | 
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 | INPUT | 
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 | INPUT | 
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 | INPUT | 
A field that indicates whether the resource must satisfy the requirements that define the rule criteria. Valid values are:
   1   The resource must 
  | ||||
| cPayableYN_PAYAB | PAYAB | char | OPT | OUTPUT | 
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 | BILL | char | OPT | OUTPUT | 
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 
  | ||||
| jdBillDate_DTBIL | DTBIL | JDEDATE | OPT | OUTPUT | 
In service billing, the date a customer was billed for a service.  | ||||
| jdPaidDate_DTPAY | DTPAY | JDEDATE | OPT | OUTPUT | 
The date a service provider was paid for a service.  | ||||
| mnEstBillableRate_ESRTB | ESRTB | MATH_NUMERIC | OPT | OUTPUT | 
The estimated billable rate associated with a service.  | ||||
| mnEstimatedAmount_EBILL | EBILL | MATH_NUMERIC | OPT | OUTPUT | 
| mnActBillableRate_ACRTB | ACRTB | MATH_NUMERIC | OPT | OUTPUT | 
The actual billable rate associated with a transaction.  | ||||
| mnTotalBilled_TOTB | TOTB | MATH_NUMERIC | OPT | OUTPUT | 
The total amount billed through this application number.  | ||||
| mnEstPayableRate_ESRTP | ESRTP | MATH_NUMERIC | OPT | OUTPUT | 
The estimated payable rate associated with a transaction.  | ||||
| mnEstPaymentAmount_EPAAP | EPAAP | MATH_NUMERIC | OPT | OUTPUT | 
This is the estimated payment amount used in service billing.  | ||||
| mnActPayableRate_ACRTP | ACRTP | MATH_NUMERIC | OPT | OUTPUT | 
The actual payable rate associated with a transaction.  | ||||
| mnPaymentAmount_PAAP | PAAP | MATH_NUMERIC | OPT | OUTPUT | 
In the Accounts Payable system, the amount of the payment.
In the Accounts Receivable system, the amount of the receipt. This amount 
  | ||||
| mnForEstBillRate_FESUNB | FESUNB | MATH_NUMERIC | OPT | OUTPUT | 
The estimated unit rate that is billable in the currency of the customer.  | ||||
| mnForEstBillAmount_FEBILL | FEBILL | MATH_NUMERIC | OPT | OUTPUT | 
The estimated billable amount in the currency of the customer.  | ||||
| mnForActBillRate_FACUNB | FACUNB | MATH_NUMERIC | OPT | OUTPUT | 
The actual unit rate that is billable in the currency of the customer.  | ||||
| mnForActBillAmount_FTOTB | FTOTB | MATH_NUMERIC | OPT | OUTPUT | 
The actual amount that is billable in the currency of the customer.  | ||||
| mnForEstPayRate_FESUNP | FESUNP | MATH_NUMERIC | OPT | OUTPUT | 
The estimated unit rate that is payable in the currency of the service provider.  | ||||
| mnForEstPayAmount_FEPAAP | FEPAAP | MATH_NUMERIC | OPT | OUTPUT | 
The estimated payable amount in the currency of the service provider.  | ||||
| mnForActPayRate_FACUNP | FACUNP | MATH_NUMERIC | OPT | OUTPUT | 
The actual unit rate that is payable in the currency of the service provider.  | ||||
| mnForActPayAmount_FPAAP | FPAAP | MATH_NUMERIC | OPT | OUTPUT | 
The actual payable amount that is recorded in the foreign currency of the service provider.  | ||||
| szBillableCurrency_BCRCD | BCRCD | char | OPT | OUTPUT | 
The currency for the billable amounts of a service order.  | ||||
| mnBillableExchangeRate_BCRR | BCRR | MATH_NUMERIC | OPT | OUTPUT | 
The rate that the system uses to convert foreign currency amounts to domestic currency amounts. The system uses this rate specifically for 
  | ||||
| cBillableCurrencyMode_BCRRM | BCRRM | char | OPT | OUTPUT | 
A code that specifies whether the system uses the foreign currency (currency of the customer) or the domestic currency for billable 
  | ||||
| szPayableCurrency_PCRCD | PCRCD | char | OPT | OUTPUT | 
A code that indicates the currency of the payable amounts on a work order or claim.  | ||||
| mnPayableExchangeRate_PCRR | PCRR | MATH_NUMERIC | OPT | OUTPUT | 
The rate that the system uses to convert foreign currency amounts to domestic currency amounts. The system uses this rate specifically for 
  | ||||
| cPayableCurrencyMode_PCRRM | PCRRM | char | OPT | OUTPUT | 
A code that specifies whether payable amounts are in the foreign currency (currency of the service provider) or in the domestic currency. 
  | ||||
| jd_ActualStartDate_D2J | D2J | JDEDATE | OPT | OUTPUT | 
Enter the actual start date for a project or job in this field. Use this information for reporting purposes.  | ||||
| mnStartTimeUnformatted_STTI | STTI | MATH_NUMERIC | OPT | OUTPUT | 
This is the start time for an operation or an order.  | ||||
| szStartTimeFormatted_FTIME | FTIME | char | OPT | OUTPUT | 
A time value displayed in the format of hours, minutes, and seconds (for example, 08:30:15).  | ||||
| mnEstEndTimeUnformatted_EPETM | EPETM | MATH_NUMERIC | OPT | OUTPUT | 
The estimated ending time associated with a work order.  | ||||
| mnEstEndTimeFormatted_FTIME | FTIME | char | OPT | OUTPUT | 
A time value displayed in the format of hours, minutes, and seconds (for example, 08:30:15).  | ||||
| szCostType_COST | COST | char | OPT | OUTPUT | 
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  
  | ||||
| szEntitlementCheck_ENTCK | ENTCK | char | OPT | OUTPUT | 
A user defined code (17/ER) to indicate the results of an entitlement check.
Valid values are:
   0   Not entitled
   1   Transaction entitled
   2   
  | ||||
| szPayableAdjSchedule_ASN4 | ASN4 | char | OPT | OUTPUT | 
A user defined code (40/AS) identifying a price and adjustment schedule. A price and adjustment schedule contains one or more 
  | ||||
| szBillableAdjSchedule_ASN2 | ASN2 | char | OPT | OUTPUT | 
This user defined code (40/AS) identifies a price and adjustment schedule. A price and adjustment schedule contains one or more 
  | ||||
| mnPercentageCovered_PCOVR | PCOVR | MATH_NUMERIC | OPT | OUTPUT | 
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 
  | ||||
| cBillMethodOfPricing_MTHPR | MTHPR | char | OPT | OUTPUT | 
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 
  | ||||
| cPayMethodOfPricing_PMTHP | PMTHP | char | OPT | OUTPUT | 
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 
  | ||||
| mnSiteNumber_SAID | SAID | MATH_NUMERIC | OPT | OUTPUT | 
A unique numeric identifier for a physical location at which utility service is delivered.  A service address often corresponds to a parcel of 
  | ||||
| szCoverageGroup_COVGR | COVGR | char | OPT | OUTPUT | 
A user defined code that specifies the Coverage Group. The Coverage Group consists of unlimited cost codes and the percentage 
  | ||||
| mnClaimAmount_CLAMT | CLAMT | MATH_NUMERIC | OPT | OUTPUT | 
The amount requested for providing a service.  | ||||
| mnCausalPart_CSLPRT | CSLPRT | MATH_NUMERIC | OPT | OUTPUT | 
The item number that indicates which part failed and caused the equipment failure.  | ||||
| szCausalPart_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.  | ||||
| szCausalPartDescription_DL01 | DL01 | char | OPT | OUTPUT | 
A user defined name or remark.  | ||||
| szCausalPartBU_MCUCSL | MCUCSL | char | OPT | OUTPUT | 
The business unit that is related to the causal portion of the claim.  | ||||
| szSupplierLotNumber_RLOT | RLOT | char | OPT | OUTPUT | 
The supplier's lot number for the item.  | ||||
| mnSupplierRecVendor_SRVEND | SRVEND | MATH_NUMERIC | OPT | OUTPUT | 
The address book number of the vendor to be used for supplier recovery.  | ||||
| mnUniqueKeyPricing_UKIDP | UKIDP | MATH_NUMERIC | OPT | OUTPUT | 
| mnEstimatedDuration_EDUR | EDUR | MATH_NUMERIC | OPT | OUTPUT | 
A number that indicates the estimated hourly duration for a scheduled task. The system calculates this number using the estimated hours 
  | ||||
| szCurrencyCodeTo_CRDC | CRDC | char | OPT | NONE | 
A code that identifies the domestic (base) currency of the company on a transaction.  | ||||
| mnManager_ANSA | ANSA | MATH_NUMERIC | OPT | NONE | 
The address book number of a manager or planner.  
Note:  A processing option for some forms allows you to enter a default value for this 
  | ||||
| mnSupervisor_ANPA | ANPA | MATH_NUMERIC | OPT | NONE | 
The address book number of the supervisor.  | ||||
| mnAssignedTo_ANP | ANP | MATH_NUMERIC | OPT | NONE | 
The address book number of the person assigned to do the work.  | ||||
| cMaintenanceScheduleFlag_WSCHF | WSCHF | char | OPT | NONE | 
A flag used to indicate if the work (i.e. work order, labor detail step, or PM Projection) is scheduled to a crew. Valid values are listed in UDC 
  | ||||
| cResourceAssigned_TRAF | TRAF | char | OPT | NONE | 
A code that indicates whether a resource has been assigned to a work order through the Resource Assignment program (P48331). You 
  | ||||
| None | 
| None |