RetrieveWOTimeTransactionRows

Retrieve WO Time Transaction Rows

Minor Business Rule

Object Name: B3100880

Parent DLL: CMFGBASE

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose
This function is used to obtain data from the F31122 table for its calling program. The function will return error codes necessary.

1.2Setup Notes and Prerequisites
In order to shorten the processing time, the table will be kept open until the request is released. The Mode must as follows.
1. The first time the function is called, the Mode must be set to '1' in Order to Open the Table.
2. To read and select records in the table, the Mode must be '2'.
3. To get the next row in the table, the Mode must be '3'
4. To kill the Request, the Mode must be set to '4'.

1.3Special Logic
If the Input Mode is '1', Open the table and Store the Request. If Mode is '2', the rows will be selected and read sequentially. If the Mode is '3', the next
row will be read. If the Mode is '4', Kill and Release the request.

2.Technical Specifications
2.4Processing

The following actions have to be performed by the Business Function.
1. If  Mode = '1'
Open the F31122 table and Store the RequestID & User in Global Variables
If Unable to Open the Request
Kill Request, Set Error Code to '1'
     Endif
Endif
2. If Mode = '2' or '3'

If Mode = '2'
Read WO Time Transactions table (F31122) Sequentially using the appropriate key(s).
Else
Read Next WO Time Transactions table (F31122) Sequentially using the appropriate key(s).
Endif
Mode = '3'
If not found
Error Code = 2
Clear all Output fields
Break and Exit the Subroutine
Endif

Endif
3. If Mode = 4
Release and Kill the Request
   Endif

Data Structure

D3100880 - Retrieve WO Time Transaction Rows

Parameter Name Data Item Data Type Req/Opt I/O/Both

cPostedCode 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
within the payroll system.  Valid values are: Blank Unprocessed. 1 Processed.   P Processed and checks have been printed (F07350
Only). ************************************************************ The F07351 contains values as they relate to the printed payment.  For the F07351, valid
values are: Blank Not Printed. I Interim Printed. 1 Non-Interim Printed.

cSummaryRecord SUMR char NONE NONE

Identifies records containing summarized detail information.

mnOrderNumber 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,
and so on.

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
reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post
program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and
should not be changed: P Accounts Payable documents   R Accounts Receivable documents   T Payroll documents   I Inventory documents
O Purchase Order Processing documents   J General Accounting/Joint Interest Billing documents   S Sales Order Processing documents

mnOperationSequence 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
manufacture of an item. You can track costs and charge time by operation. In bills of material, a number that designates the routing step in the
fabrication or assembly process that requires a specified component part. You define the operation sequence after you create the routing
instructions for the item. The Shop Floor Management system uses this number in the backflush/preflush by operation process. In engineering
change orders, a number that sequences the assembly steps for the engineering change. For repetitive manufacturing, a number that
identifies the sequence in which an item is scheduled to be produced. Skip To fields allow you to enter an operation sequence that you want to begin
the display of information. You can use decimals to add steps between existing steps. For example, use 12.5 to add a step between steps
12 and 13.

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
Quantities Completed    5   Quantities Scrapped    9   Miscellaneous (such as piece rate bonus)

cMode EV01 char NONE NONE

An option that specifies the type of processing for an event.

cSuppressErrorMessage EV02 char NONE NONE

An option that specifies the type of processing for an event.

cErrorCode ERRC char NONE NONE

This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
Set Server program (XT4914).

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
special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.

idhRequestF31122 GENLNG ID NONE NONE

General purpose ID variable.

Related Functions

None

Related Tables

F31122 Work Order Time Transactions

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cPostedCode	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 within the payroll system. Valid values are: Blank Unprocessed. 1 Processed. P Processed and checks have been printed (F07350 Only). ************************************************************ The F07351 contains values as they relate to the printed payment. For the F07351, valid values are: Blank Not Printed. I Interim Printed. 1 Non-Interim Printed.
cSummaryRecord	SUMR	char	NONE	NONE
Identifies records containing summarized detail information.
mnOrderNumber	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, and so on.
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 reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and should not be changed: P Accounts Payable documents R Accounts Receivable documents T Payroll documents I Inventory documents O Purchase Order Processing documents J General Accounting/Joint Interest Billing documents S Sales Order Processing documents
mnOperationSequence	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 manufacture of an item. You can track costs and charge time by operation. In bills of material, a number that designates the routing step in the fabrication or assembly process that requires a specified component part. You define the operation sequence after you create the routing instructions for the item. The Shop Floor Management system uses this number in the backflush/preflush by operation process. In engineering change orders, a number that sequences the assembly steps for the engineering change. For repetitive manufacturing, a number that identifies the sequence in which an item is scheduled to be produced. Skip To fields allow you to enter an operation sequence that you want to begin the display of information. You can use decimals to add steps between existing steps. For example, use 12.5 to add a step between steps 12 and 13.
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 Quantities Completed 5 Quantities Scrapped 9 Miscellaneous (such as piece rate bonus)
cMode	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
cSuppressErrorMessage	EV02	char	NONE	NONE
An option that specifies the type of processing for an event.
cErrorCode	ERRC	char	NONE	NONE
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document Set Server program (XT4914).
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 special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
idhRequestF31122	GENLNG	ID	NONE	NONE
General purpose ID variable.