The purpose of creating the N3101043 function is to simplify the interaction between the Work Order Hours and Quantities MBF and the Payroll
application.
Call Hours and Quantities MBF function is designed support calling Work Order Hours and Quantities Master Business Function (B3101040). The
B3101040 function needs to be called from Payroll Time Entry to validate manufacturing time entry records and to add or update records to the Work
Order Time Transactions table (F31122). The NER will process calls depending on a Processing Mode.
Special Logic
ModeProcessing = '1' call F31122BeginDoc. The F31122BeginDoc is called with a flag cCreateCache equal to '1' which means to create a cache.
ModeProcessing = '2' call F31122EditLine. The F31122EditLine can be called several times, depending on the information that need to be validated
and added to the cache. If input parameters are Hours, Quantity and Equipment Hours, then the Edit Line function will be called three times to
validate all three pieces separately since Hours, Quantity and Equipment Hours are stored as different type of records in F31122 table. See Special Logic
section for details.
ModeProcessing = '3' and '4' call F31122EditDoc and F31122EndDoc accordingly. The F31122EditDoc function is called to update the cache. The
F31122EndDoc is called to update the F31122 table based on the cache.
ModeProcessing = '5' call F31122EndDoc. The F31122EndDoc is called to only clear all caches.
D3101043 - Call Hours and Quantities MBF
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cModeProcessing_MODE | MODE | char | OPT | NONE |
The processing mode used in Purchase Order Consolidator to signify when specific orders are being processed. | ||||
mnBatchNumber_JOBS | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
cLineActionCode_ACTN | ACTN | char | OPT | NONE |
A code that specifies the action that is performed. Valid values are: A Add C Change | ||||
mnPayrollTransactionNo_PRTR | PRTR | MATH_NUMERIC | OPT | NONE |
A unique number that the system assigns to each timecard. You can use this field in the Time Entry By Job program to retrieve a specific
| ||||
cErrorCode_ERRC | 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
| ||||
szErrorMessageID_DTAI | 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
| ||||
szCacheName_DSON | DSON | char | OPT | NONE |
The object name of the data structure used for identifying the error message substitution variables. | ||||
szComputerID_CTID | CTID | char | OPT | NONE |
szProgramId_PID | 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
| ||||
szUserId_USER | USER | char | OPT | NONE |
The code that identifies a user profile. | ||||
mnOrderNumber_DOCO | 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,
| ||||
mnUKIDEquip_UKID | UKID | MATH_NUMERIC | OPT | NONE |
This field is a unique number used to identify a record in a file. | ||||
mnUKIDQty_UKID | UKID | MATH_NUMERIC | OPT | NONE |
This field is a unique number used to identify a record in a file. | ||||
mnUKIDHours_UKID | UKID | MATH_NUMERIC | OPT | NONE |
This field is a unique number used to identify a record in a file. | ||||
mnEmployeeNumber_AN8 | 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
| ||||
mnOperationSeqNo_OPSQ | 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
| ||||
jdWorkDate_DGL | DGL | JDEDATE | OPT | NONE |
A date that identifies the financial period to which the transaction is to be posted.
The company constants specify the date range for each
| ||||
cTypeOfHours_TYR | TYR | char | OPT | NONE |
A code that indicates the type of time entered. Valid values are:
1 Run Labor Hours
2 Setup Labor Hours
3 Machine Hours
4
| ||||
mnQuantityShipped_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
| ||||
mnHoursWorked_HRW | HRW | MATH_NUMERIC | OPT | NONE |
The number of hours associated with each transaction. | ||||
mnEquipmentHours_HREQ | HREQ | MATH_NUMERIC | OPT | NONE |
The number of hours the unit/rig was operated. | ||||
cShiftCode_SHFT | SHFT | char | OPT | NONE |
A user defined code (00/SH) that identifies daily work shifts.
In payroll systems, you can use a shift code to add a percentage or amount to
| ||||
szUnitOfMeasure_UOM | 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). | ||||
mnEmployeeRate_HRT | HRT | MATH_NUMERIC | OPT | NONE |
This is the employee's hourly rate as retrieved, entered or calculated during time entry. (See also GRT, PWRT, BRT.)
In the Employee
| ||||
szOrderType_DCTO | 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
| ||||
szOperationStatusCode_OPST | 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
| ||||
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
| ||||
mnBillingRateEquip_EBRT | EBRT | MATH_NUMERIC | OPT | NONE |
A code that represents the amount that you want to charge the job. Each piece of equipment can have numerous billing rates based on the
| ||||
szStatusCodeWo_SRST | SRST | char | OPT | NONE |
A user defined code (00/SS) that describes the status of a work order, rate schedule, or engineering change order. Any status change from
| ||||
mnAmountGrossPay_GPAY | GPAY | MATH_NUMERIC | OPT | NONE |
The actual gross pay amount for an employee. This amount is different from the distributed gross pay amount used for labour
| ||||
mnAmountEntered_EPAY | EPAY | MATH_NUMERIC | OPT | NONE |
An adjustment amount or extension of hours multiplied by the rate that the user actually enters on the time entry screen. This amount is
| ||||
szEmployeeName_DL01 | DL01 | char | OPT | NONE |
A user defined name or remark. | ||||
szBusinessUnit_MCU | 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
| ||||
szDocumentType_DCT | 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
| ||||
szBranchPlant_MMCU | 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
| ||||
mnItemNumberShort_KIT | KIT | MATH_NUMERIC | OPT | NONE |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
| ||||
szItemNumber3rd_KITA | KITA | char | OPT | NONE |
The system provides three separate item numbers:
1. Item Number (short) - An eight-digit, computer assigned, completely non-significant
| ||||
szItemNumber2nd_KITL | KITL | char | OPT | NONE |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
| ||||
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. | ||||
jdDateUpdated_UPMJ | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. | ||||
nCacheRowNumber_INT01 | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due. | ||||
szVersion_VERS | VERS | char | OPT | NONE |
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
| ||||
mnAssetNumber_NUMB | NUMB | MATH_NUMERIC | OPT | NONE |
An 8-digit number that uniquely identifies an asset. | ||||
mnPayrollGridRow_MATH01 | MATH01 | MATH_NUMERIC | OPT | NONE |
- - - Good Performance Low Value. | ||||
mnTimeOfDay_TDAY | TDAY | MATH_NUMERIC | OPT | NONE |
The computer clock in hours:minutes:seconds. | ||||
szReasonCode_RCD | RCD | char | OPT | NONE |
A user defined code (42/RC) that explains the purpose for a transaction. For example, you can indicate the reason that you are returning
|
None |
None |