GetWOTimeTransactionRows

F31122 Get WO TimeTransaction Rows

Major Business Rule

Object Name: B3101010

Parent DLL: CMFGBASE

Location: Client/Server

Language: C

•
• •

•
•
•
•
•
•
•
•
•
•

Data Structure

D3101010 - F31122 Get WO Time Transaction Rows

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

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
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.

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

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
location.

mnTransactionNumber 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
timecard for display. This field is also used to tie a timecard to each Actual Burden audit record created for the timecard during the Actual
Burden Journaling process.

mnParentShortItem KIT MATH_NUMERIC NONE NONE

The system provides for three separate item numbers.    1.   Item Number (short) - An eight-digit, computer assigned, completely
non-significant item number.    2.   2nd Item Number - The 25-digit, free form, user defined alphanumeric item number.    3.   3rd Item Number - Another
25-digit, free form, user defined alphanumeric item number.

szParent2ndItem KITL char NONE NONE

The system provides for three separate item numbers.    1.   Item Number (short) - An eight-digit, computer assigned, completely
non-significant item number.    2.   2nd Item Number - The 25-digit, free form, user defined alphanumeric item number.    3.   3rd Item Number - Another
25-digit, free form, user defined alphanumeric item number. This is used in a parts list as either a parent or component number. In the Equipment
Management system, this item is used for memo purposes only.

szParent3rdItem KITA char NONE NONE

The system provides three separate item numbers:    1. Item Number (short) - An eight-digit, computer assigned, completely non-significant
item number.    2. 2nd Item Number - The 25-digit, free form, user defined alphanumeric item number.    3. 3rd Item Number - Another 25-digit,
free form, user defined alphanumeric item number.

szBranch MMCU char NONE 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
represent lower-level business units, subordinate to it. For example:     o Branch/Plant (MMCU)     o Dept A (MCU)     o Dept B (MCU)     o Job 123
(MCU) Business unit security is based on the higher-level business unit.

szCostCenter MMCU char NONE 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
represent lower-level business units, subordinate to it. For example:     o Branch/Plant (MMCU)     o Dept A (MCU)     o Dept B (MCU)     o Job 123
(MCU) Business unit security is based on the higher-level business unit.

mnOpSequenceNumber 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)

szRemarkExplanation EXR char NONE NONE

A name or remark that describes the purpose for using an account or conveys any other information that the user wants about the
transaction.

mnBatchNumber ICU MATH_NUMERIC NONE 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
assign a batch number or let the system assign it using the Next Numbers program.

szDocumentType DCT char NONE NONE

A user defined code (00/DT) that identifies the origin and purpose of the transaction.  PeopleSoft reserves several prefixes for document
types, such as, vouchers, invoices, receipts, and timesheets. The reserved document type prefixes for codes are: P Accounts payable
documents R Accounts receivable documents T Time and Pay documents I Inventory documents O Purchase order documents S Sales order
documents

jdGLDate 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
financial period. You can have as many as 14 periods. Generally, period 14 is used for audit adjustments. The system validates this field for
PBCO (posted before cutoff), PYEB (prior year ending balance), PACO (post after cutoff), and WACO (post way after cutoff) messages.

jdTimeClockDate PBDT JDEDATE NONE NONE

Date associated with the time clock start time. The date associated with the ending clock time is the work date.

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.

cShiftCode SHFT char NONE 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
the hourly rate on a timecard. For payroll and time entry: If an employee always works a shift for which a shift rate differential is applicable,
enter that shift code on the employee's master record. When you enter the shift on the employee's master record, you do not need to enter the
code on the timecard when you enter time. If an employee occasionally works a different shift, you enter the shift code on each applicable
timecard to override the default value.

szUnitNumber APID char NONE NONE

A 12-character alphanumeric code used as an alternate identification number for an asset. This number is not required, nor does the
system assign a number if you leave the field blank when you add an asset. If you use this number, it must be unique. For equipment, this is
typically the serial number.

mnBillingRate EBRT MATH_NUMERIC NONE 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
rate code. The equipment billing rate can be composed of up to ten different rates. For example: Billing Rate = 200        100 Rate 1 (Ownership
Component)         25 Rate 2 (Operating Component)         50 Rate 3 (Maintenance Component)         25 Rate 4 (Other Costs Component) When
you post time entries to the general ledger, the system recognizes credits in revenue accounts for each of the rate components. This allows
you to separate portions of the equipment billing by type of cost. Note: You are not required to use rate components.

mnOvertimeHoursWorked THRW MATH_NUMERIC NONE NONE

Hours Worked - Overtime

mnEquipmentHours HREQ MATH_NUMERIC NONE NONE

The number of hours the unit/rig was operated.

mnGrossPay 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
distribution. On Work Order Time Entry, use this field to record miscellaneous pay for an employee, such as piece rate bonus.

mnQuantityShipped 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
item. In the Manufacturing system and Work Order Time Entry, this field can indicate completed or scrapped quantities. The quantity type is
determined by the type code entered.

mnQuantityCanceled SOCN MATH_NUMERIC NONE NONE

The number of units canceled in Sales Order or Work Order Processing, using either the entered or the primary unit of measure defined for
this item. In manufacturing, this can also be the number of units scrapped to date.

szUOM 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).

cSummaryRecord SUMR char NONE NONE

Identifies records containing summarized detail information.

mnUniqueKey UKID MATH_NUMERIC NONE NONE

This field is a unique number used to identify a record in a file.

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.

nIndexNumber INT01 integer NONE NONE

Number of Days in Future to Query for Responses Due.

nNumberOfKeys INT02 integer NONE NONE

Number of Days in the Past to Query for Quote Requests Received.

cSuppressErrorMessages EV01 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.

mnHourlyRate HRT MATH_NUMERIC NONE NONE

This is the employee's hourly rate as retrieved, entered or calculated during time entry.  (See also GRT, PWRT, BRT.) In the Employee
Master file, this is the employee's base hourly rate. In the Union Rates file, this is the straight time rate. ***Special Note*** If you change the value
of the DATA DISPLAY DECIMALS for this field, you must also change the field GRT to have exactly the same data display decimals.

szReasonCode 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
items.

Related Functions

None

Related Tables

F31122 Work Order Time Transactions

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
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 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.
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
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 location.
mnTransactionNumber	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 timecard for display. This field is also used to tie a timecard to each Actual Burden audit record created for the timecard during the Actual Burden Journaling process.
mnParentShortItem	KIT	MATH_NUMERIC	NONE	NONE
The system provides for three separate item numbers. 1. Item Number (short) - An eight-digit, computer assigned, completely non-significant item number. 2. 2nd Item Number - The 25-digit, free form, user defined alphanumeric item number. 3. 3rd Item Number - Another 25-digit, free form, user defined alphanumeric item number.
szParent2ndItem	KITL	char	NONE	NONE
The system provides for three separate item numbers. 1. Item Number (short) - An eight-digit, computer assigned, completely non-significant item number. 2. 2nd Item Number - The 25-digit, free form, user defined alphanumeric item number. 3. 3rd Item Number - Another 25-digit, free form, user defined alphanumeric item number. This is used in a parts list as either a parent or component number. In the Equipment Management system, this item is used for memo purposes only.
szParent3rdItem	KITA	char	NONE	NONE
The system provides three separate item numbers: 1. Item Number (short) - An eight-digit, computer assigned, completely non-significant item number. 2. 2nd Item Number - The 25-digit, free form, user defined alphanumeric item number. 3. 3rd Item Number - Another 25-digit, free form, user defined alphanumeric item number.
szBranch	MMCU	char	NONE	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 represent lower-level business units, subordinate to it. For example: o Branch/Plant (MMCU) o Dept A (MCU) o Dept B (MCU) o Job 123 (MCU) Business unit security is based on the higher-level business unit.
szCostCenter	MMCU	char	NONE	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 represent lower-level business units, subordinate to it. For example: o Branch/Plant (MMCU) o Dept A (MCU) o Dept B (MCU) o Job 123 (MCU) Business unit security is based on the higher-level business unit.
mnOpSequenceNumber	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)
szRemarkExplanation	EXR	char	NONE	NONE
A name or remark that describes the purpose for using an account or conveys any other information that the user wants about the transaction.
mnBatchNumber	ICU	MATH_NUMERIC	NONE	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 assign a batch number or let the system assign it using the Next Numbers program.
szDocumentType	DCT	char	NONE	NONE
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document types, such as, vouchers, invoices, receipts, and timesheets. The reserved document type prefixes for codes are: P Accounts payable documents R Accounts receivable documents T Time and Pay documents I Inventory documents O Purchase order documents S Sales order documents
jdGLDate	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 financial period. You can have as many as 14 periods. Generally, period 14 is used for audit adjustments. The system validates this field for PBCO (posted before cutoff), PYEB (prior year ending balance), PACO (post after cutoff), and WACO (post way after cutoff) messages.
jdTimeClockDate	PBDT	JDEDATE	NONE	NONE
Date associated with the time clock start time. The date associated with the ending clock time is the work date.
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.
cShiftCode	SHFT	char	NONE	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 the hourly rate on a timecard. For payroll and time entry: If an employee always works a shift for which a shift rate differential is applicable, enter that shift code on the employee's master record. When you enter the shift on the employee's master record, you do not need to enter the code on the timecard when you enter time. If an employee occasionally works a different shift, you enter the shift code on each applicable timecard to override the default value.
szUnitNumber	APID	char	NONE	NONE
A 12-character alphanumeric code used as an alternate identification number for an asset. This number is not required, nor does the system assign a number if you leave the field blank when you add an asset. If you use this number, it must be unique. For equipment, this is typically the serial number.
mnBillingRate	EBRT	MATH_NUMERIC	NONE	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 rate code. The equipment billing rate can be composed of up to ten different rates. For example: Billing Rate = 200 100 Rate 1 (Ownership Component) 25 Rate 2 (Operating Component) 50 Rate 3 (Maintenance Component) 25 Rate 4 (Other Costs Component) When you post time entries to the general ledger, the system recognizes credits in revenue accounts for each of the rate components. This allows you to separate portions of the equipment billing by type of cost. Note: You are not required to use rate components.
mnOvertimeHoursWorked	THRW	MATH_NUMERIC	NONE	NONE
Hours Worked - Overtime
mnEquipmentHours	HREQ	MATH_NUMERIC	NONE	NONE
The number of hours the unit/rig was operated.
mnGrossPay	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 distribution. On Work Order Time Entry, use this field to record miscellaneous pay for an employee, such as piece rate bonus.
mnQuantityShipped	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 item. In the Manufacturing system and Work Order Time Entry, this field can indicate completed or scrapped quantities. The quantity type is determined by the type code entered.
mnQuantityCanceled	SOCN	MATH_NUMERIC	NONE	NONE
The number of units canceled in Sales Order or Work Order Processing, using either the entered or the primary unit of measure defined for this item. In manufacturing, this can also be the number of units scrapped to date.
szUOM	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).
cSummaryRecord	SUMR	char	NONE	NONE
Identifies records containing summarized detail information.
mnUniqueKey	UKID	MATH_NUMERIC	NONE	NONE
This field is a unique number used to identify a record in a file.
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.
nIndexNumber	INT01	integer	NONE	NONE
Number of Days in Future to Query for Responses Due.
nNumberOfKeys	INT02	integer	NONE	NONE
Number of Days in the Past to Query for Quote Requests Received.
cSuppressErrorMessages	EV01	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.
mnHourlyRate	HRT	MATH_NUMERIC	NONE	NONE
This is the employee's hourly rate as retrieved, entered or calculated during time entry. (See also GRT, PWRT, BRT.) In the Employee Master file, this is the employee's base hourly rate. In the Union Rates file, this is the straight time rate. *Special Note* If you change the value of the DATA DISPLAY DECIMALS for this field, you must also change the field GRT to have exactly the same data display decimals.
szReasonCode	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 items.