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 |