Get F31122 Records For Payroll Time Entry
the Payroll Time Entry grid can correspond to up to 3 records of the Work Order Time Transactions table (F31122). There is a one-to-many
relationship between Payroll Time Entry grid and F31122. The purpose of the function is to find correct set of records and return the necessary fields to
the Payroll Time Entry grid.
selected transaction is transaction number 45 which has information about Labor Hours, Quantity completed and Equipment worked, then three records
with transaction number 45 will be fetched from F31122 and corresponding fields of Payroll Time Entry grid will be populated.
Special Logic
Fetch records sequentially and depending on TypeOfHours assign it to the corresponding
paramter
D3101045 - Get F31122 records for Payroll Time Entry - MFG
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
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,
| ||||
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
| ||||
mnOperationSeqNumber_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
| ||||
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
| ||||
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
| ||||
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. | ||||
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
| ||||
mnUnitsQuantity_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
| ||||
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). | ||||
szOperationStatusCodeWo_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
| ||||
mnBillingRateEquipment_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
| ||||
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
| ||||
mnShortItemNumber_KIT | KIT | MATH_NUMERIC | OPT | NONE |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
| ||||
sz2ndItemNumber_KITL | KITL | char | OPT | NONE |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
| ||||
sz3rdItemNumber_KITA | KITA | char | OPT | NONE |
The system provides three separate item numbers:
1. Item Number (short) - An eight-digit, computer assigned, completely non-significant
| ||||
mnUKIDEquip_UKID3 | UKID | MATH_NUMERIC | OPT | NONE |
This field is a unique number used to identify a record in a file. | ||||
mnUKIDQty_UKID2 | UKID | MATH_NUMERIC | OPT | NONE |
This field is a unique number used to identify a record in a file. | ||||
mnUKIDHours_UKID1 | UKID | MATH_NUMERIC | OPT | NONE |
This field is a unique number used to identify a record in a file. | ||||
mnPayrollTransNum_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
| ||||
mnBatchNumber_ICU | ICU | MATH_NUMERIC | OPT | NONE |
A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either
| ||||
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
| ||||
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
| ||||
szCompany_CO | 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
| ||||
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 |