1.Functional Description
The Functional Description section is to be cut from the Word document and pasted into the Notes
section of the Business Function.
1.1Purpose
To update/add/delete records to the Shop Floor Control WO Time Transactions (F31122).
1.2Setup Notes and Prerequisites
Set on "Suppress Error Messages" to suppress the runtime error message handling. Otherwise, if an
error occurs the error message will be displayed on the message line.
The user passes to the business function the number of the index they want to use and the number of
key fields within that index that will be used.
1. YST, AN8, DGL -(Index 1, Keys 3)
2. YST, USER, UPMJ, PBDT -(Index 2, Keys 4)
3. YST, DOCO, DGL, OPSQ, TYR-(Index 3, Keys 5)
4. PRTR, YST, TYR-(Index 4, Keys 3)
5. YST, SUMR, DOCO, DCTO, OPSQ, TYR-(Index 5, Keys 6)
6. UKID-(Index 6, Key 1)
(copied).
'b7The Mode will determine if a record is to be updated, added, or deleted.
Mode 1 - Update the F31122 record retrieved by the index and key combination with the values for
the designated update fields.
Mode 2 - Add the F31122 record based on the record referenced by the F31122 file pointer.
Mode 3 - Delete the F31122 record retrieved by the index and key combination.
1.3Special Logic
None.
2.Technical Specifications
2.4Processing
Fetch the Shop Floor Control WO Time Transactions Record corresponding to the index and keys entered
by the user.
If the fetch failed, the DS Suppress Error Message is not equal to '1', and the Mode is '1' or '3',
SetGBRError where error message is '0002' ( Record Invalid ).
If the fetch was successful, the DS Suppress Error Message is not equal to '1', and the Mode is '2',
SetGBRError where the error message is '2463' (Record Exists).
If the fetch was successful and Mode is '1':
If Memory Allocation is successful, Assign DS F31122 Pointer = Address of WO Time Transactions
Record.
If Memory Allocation is not successful, return error messages.
Assign DS Error Message ID = '4365' (No Memory).
If DS Suppress Error Message is not equal to '1', SetGBRError where error message is '4365'.
Update the WO Time Transactions record with the values of PRTR, HRW, PBTM, PETM, SOQS, UOM, TYR, and
GPAY that are passed in.
If the fetch was successful and Mode is '3':
If the fetch was not successful and the Mode is '2':
Change the values in the new record to the values of the PRTR, HRW, PBTM, PETM, SOQS, UOM, TYR, and
GPAY that are passed in.
If the Mode is equal to '1' or '3' and the fetch fails, return Error Message ID '0002' (Record
Invalid).
If the Mode is equal to '2' and the fetch is successful, return Error Message ID '2463' (Record
Exists).
^
D3100590 - Update WO Time Transactions
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cMode | MODE | char | NONE | NONE |
The processing mode used in Purchase Order Consolidator to signify when specific orders are being processed. | ||||
cSuppressErrorMessages | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
szIndex | DTAI | char | NONE | 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
| ||||
szKeys | DTAI | char | NONE | 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
| ||||
szErrorMessageID | DTAI | char | NONE | 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
| ||||
idF31122Pointer | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
cProcessedCode | YST | char | NONE | NONE |
A code used to indicate whether a payroll transaction has been processed through the payroll cycle. This value is held within various files
| ||||
mnAddressNumber | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
jdWorkDate | DGL | JDEDATE | NONE | 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
| ||||
szUserID | USER | char | NONE | NONE |
The code that identifies a user profile. | ||||
jdDateUpdated | UPMJ | JDEDATE | NONE | NONE |
The date that specifies the last update to the file record. | ||||
jdTimeClockStart | PBDT | JDEDATE | NONE | NONE |
Date associated with the time clock start time. The date associated with the ending clock time is the work date. | ||||
mnWorkOrderNumber | DOCO | MATH_NUMERIC | NONE | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
mnOperationSequenceNo | OPSQ | MATH_NUMERIC | NONE | 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 | char | NONE | 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
| ||||
mnTransactionNo | PRTR | MATH_NUMERIC | NONE | 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
| ||||
cSummaryRecord | SUMR | char | NONE | NONE |
Identifies records containing summarized detail information. | ||||
szOrderType | DCTO | char | NONE | 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
| ||||
mnUniqueKeyID | UKID | MATH_NUMERIC | NONE | NONE |
This field is a unique number used to identify a record in a file. | ||||
mnHoursWorked | HRW | MATH_NUMERIC | NONE | NONE |
The number of hours associated with each transaction. | ||||
mnBeginningTime | PBTM | MATH_NUMERIC | NONE | 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 | NONE | NONE |
A field that is used to enter the ending time of the operation sequence for the work center operation on the routing. | ||||
mnQuantity | SOQS | MATH_NUMERIC | NONE | 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 | char | NONE | 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). | ||||
mnMiscPay | GPAY | MATH_NUMERIC | NONE | NONE |
The actual gross pay amount for an employee. This amount is different from the distributed gross pay amount used for labour
|
B4000460 Free Ptr To Data Structure |
F31122 Work Order Time Transactions |