F4826GetRow

F4826 Get Row

Major Business Rule

Object Name: B4800090

Parent DLL: CMFG

Location: Client/Server

Language: C

Functional Description

Purpose
This function will be used to read a row from the WO Status Action table (F4826) by the user input
index/key combination.

Setup Notes and Prerequisites
At this time, index one is the only valid index; however, index shall remain a parameter in
consideration of future additions.
1 = DCTO, TYPS, SRST

Special Logic

Technical Specification

1.Test for a valid key.
2.Read the WO Status Action table (F4826) by the input index/key combination.
3.If a row exists,

a.Return each row value.
b.If the input status (ds-SRST) is not equal to the Next Status (GENTST), or to the Allowed
Status Codes (GEA1ST, GEA2ST, GEA3ST, GEA4ST, GEA5ST), assign the Allowed Status Code a value of '1'.
c.Return an error if the row does not exist.

Data Structure

D4800090 - F4826 Get Row

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

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

cWOType TYPS char NONE NONE

A user defined code (00/TY) that indicates the classification of a work order or engineering change order. You can use work order type as a
selection criterion for work order approvals.

szWOStatusCode SRST char NONE 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
90 through 99  triggers the system to automatically update the completion date.

szWONextStatus NTST char NONE NONE

The next status for a work order, according to the work order activity rules,as the work order moves through the approval route. You must
define a status code as a work order status in the Work Order Activity Rules table before you can use it as a next status.

szAllowedStatusCode1 A1ST char NONE NONE

This is an optional field that indicates a status that can be assigned as the next step in the order process. Although this is not the preferred
or expected next step, this status is an allowed override. The system does not allow you to initiate an order line step or status that is not
defined as either the expected next status or an allowed status. Other allowed status codes let you bypass processing steps. In processing
options, these codes are often referred to as override next status codes. You must define a status code as a work order status in the Work Order
Activity Rules table before you can use it as a next status or another allowed status.

szAllowedStatusCode2 A2ST char NONE NONE

This is an optional field indicating a status that can be performed as the next step in the order process. Although this is not the preferred or
expected next step, this field is an allowed override. The system does not allow you to initiate an order line step or status not defined as either
the expected next status or an allowed status. Other allowed status codes let you bypass processing steps. These codes are often
referred to in processing options as  "override next status codes."

szAllowedStatusCode3 A3ST char NONE NONE

This is an optional field indicating a status that can be performed as the next step in the order process. Although this is not the preferred or
expected next step, this field is an allowed override. The system does not allow you to initiate an order line step or status not defined as either
the expected next status or an allowed status. Other allowed status codes let you bypass processing steps. These codes are often
referred to in processing options as  "override next status codes."

szAllowedStatusCode4 A4ST char NONE NONE

This is an optional field indicating a status that can be performed as the next step in the order process. Although this is not the preferred or
expected next step, this field is an allowed override. The system does not allow you to initiate an order line step or status not defined as either
the expected next status or an allowed status. Other allowed status codes let you bypass processing steps. These codes are often
referred to in processing options as  "override next status codes."

szAllowedStatusCode5 A5ST char NONE NONE

This is an optional field indicating a status that can be performed as the next step in the order process. Although this is not the preferred or
expected next step, this field is an allowed override. The system does not allow you to initiate an order line step or status not defined as either
the expected next status or an allowed status. Other allowed status codes let you bypass processing steps. These codes are often
referred to in processing options as  "override next status codes."

szMaintenanceStatus MSTS char NONE NONE

A user defined code (12/MS) that indicates the maintenance status of a piece of equipment, such as 50 for maintenance due or 60 for
waiting for parts. Note: Status code 98 is reserved for cancelled maintenance. Status code 99 is reserved for completed maintenance. Status code
01 (default) is reserved for initial maintenance setup.

cInventoryCommitmentFlag IVCM char NONE NONE

A code that determines whether Inventory is Committed or not when a Work Order changes status.  Valid values are:    1   Inventory is not
committed    2   Inventory is committed

cSubledgerInactiveCode SBLI char NONE NONE

An option that indicates whether a specific subledger is inactive. Examples of inactive subledgers are jobs that are closed, employees
who have been terminated, or assets that have been disposed. Turn on this option to indicate that a subledger is inactive. If a subledger
becomes active again, turn off this option. If you want to use subledger information in the tables for reports, but you want to prevent transactions
from posting to the record in the Account Balances table (F0902), turn on this option. Valid values are: Off Subledger active On Subledger inactive

cEqWOFutureConstant1 EQW1 char NONE NONE

The capacity flag determines whether the system runs the capacity plan generation when a work order changes status. Valid values are:
Blank Do not run the capacity plan generation.    1        Run the capacity plan generation.    2        Run the capacity plan generation and provide
a warning message when labor resources are over capacity. The warning message appears on the work order header and on Backlog
Management when you inquire on the work order.

cEqWOFutureConstant2 EQW2 char NONE NONE

A code that determines whether a work order can be changed at a particular status. The lock applies to records in both the Work Order
Master table (F4801) and the Work Order Instruction table (F4802). Values are:    Blank Do not lock the work order.    1        Lock the work order    2
    Lock the work order with a completion date    3        Do not lock the work order with a completion date    4        Lock the work order, the parts
list & the routings    5        Lock the work order, the parts list and the routings with a completion date    6        Lock the order type & the work order
type only

cEqWOFutureConstant3 EQW3 char NONE NONE

An indication of whether to print the work order when it reaches a particular status.

cEqWOFutureConstant4 EQW4 char NONE NONE

A code that indicates the status of a condition-based alert. Valid values are listed in UDC table 13/AS (Alert Status).

cEqWOFutureConstant5 EQW5 char NONE NONE

A code that specifies which role has the authority to edit a claim at a particular status. The system uses this code in the Warranty Claims
program (P1777) and the Supplier Recovery Claims program (P1779). Valid roles include: Dealer Assessor Supplier Recovery Manager.

nIndex INT01 integer NONE NONE

Number of Days in Future to Query for Responses Due.

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

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.

cBudgetApproval BUDG char NONE NONE

0 = The input status is allowed.
1 = The input status is not allowed.  (The input status is not equal to the F4826 Next Status (GENTST), or the  Allowed Status Codes 1-5 (GEA1ST,
GEA2ST, GEA3ST, GEA4ST, or GEA5ST)).
^

Related Functions

None

Related Tables

F4826 W.O. Status Action Table

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
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
cWOType	TYPS	char	NONE	NONE
A user defined code (00/TY) that indicates the classification of a work order or engineering change order. You can use work order type as a selection criterion for work order approvals.
szWOStatusCode	SRST	char	NONE	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 90 through 99 triggers the system to automatically update the completion date.
szWONextStatus	NTST	char	NONE	NONE
The next status for a work order, according to the work order activity rules,as the work order moves through the approval route. You must define a status code as a work order status in the Work Order Activity Rules table before you can use it as a next status.
szAllowedStatusCode1	A1ST	char	NONE	NONE
This is an optional field that indicates a status that can be assigned as the next step in the order process. Although this is not the preferred or expected next step, this status is an allowed override. The system does not allow you to initiate an order line step or status that is not defined as either the expected next status or an allowed status. Other allowed status codes let you bypass processing steps. In processing options, these codes are often referred to as override next status codes. You must define a status code as a work order status in the Work Order Activity Rules table before you can use it as a next status or another allowed status.
szAllowedStatusCode2	A2ST	char	NONE	NONE
This is an optional field indicating a status that can be performed as the next step in the order process. Although this is not the preferred or expected next step, this field is an allowed override. The system does not allow you to initiate an order line step or status not defined as either the expected next status or an allowed status. Other allowed status codes let you bypass processing steps. These codes are often referred to in processing options as "override next status codes."
szAllowedStatusCode3	A3ST	char	NONE	NONE
This is an optional field indicating a status that can be performed as the next step in the order process. Although this is not the preferred or expected next step, this field is an allowed override. The system does not allow you to initiate an order line step or status not defined as either the expected next status or an allowed status. Other allowed status codes let you bypass processing steps. These codes are often referred to in processing options as "override next status codes."
szAllowedStatusCode4	A4ST	char	NONE	NONE
This is an optional field indicating a status that can be performed as the next step in the order process. Although this is not the preferred or expected next step, this field is an allowed override. The system does not allow you to initiate an order line step or status not defined as either the expected next status or an allowed status. Other allowed status codes let you bypass processing steps. These codes are often referred to in processing options as "override next status codes."
szAllowedStatusCode5	A5ST	char	NONE	NONE
This is an optional field indicating a status that can be performed as the next step in the order process. Although this is not the preferred or expected next step, this field is an allowed override. The system does not allow you to initiate an order line step or status not defined as either the expected next status or an allowed status. Other allowed status codes let you bypass processing steps. These codes are often referred to in processing options as "override next status codes."
szMaintenanceStatus	MSTS	char	NONE	NONE
A user defined code (12/MS) that indicates the maintenance status of a piece of equipment, such as 50 for maintenance due or 60 for waiting for parts. Note: Status code 98 is reserved for cancelled maintenance. Status code 99 is reserved for completed maintenance. Status code 01 (default) is reserved for initial maintenance setup.
cInventoryCommitmentFlag	IVCM	char	NONE	NONE
A code that determines whether Inventory is Committed or not when a Work Order changes status. Valid values are: 1 Inventory is not committed 2 Inventory is committed
cSubledgerInactiveCode	SBLI	char	NONE	NONE
An option that indicates whether a specific subledger is inactive. Examples of inactive subledgers are jobs that are closed, employees who have been terminated, or assets that have been disposed. Turn on this option to indicate that a subledger is inactive. If a subledger becomes active again, turn off this option. If you want to use subledger information in the tables for reports, but you want to prevent transactions from posting to the record in the Account Balances table (F0902), turn on this option. Valid values are: Off Subledger active On Subledger inactive
cEqWOFutureConstant1	EQW1	char	NONE	NONE
The capacity flag determines whether the system runs the capacity plan generation when a work order changes status. Valid values are: Blank Do not run the capacity plan generation. 1 Run the capacity plan generation. 2 Run the capacity plan generation and provide a warning message when labor resources are over capacity. The warning message appears on the work order header and on Backlog Management when you inquire on the work order.
cEqWOFutureConstant2	EQW2	char	NONE	NONE
A code that determines whether a work order can be changed at a particular status. The lock applies to records in both the Work Order Master table (F4801) and the Work Order Instruction table (F4802). Values are: Blank Do not lock the work order. 1 Lock the work order 2 Lock the work order with a completion date 3 Do not lock the work order with a completion date 4 Lock the work order, the parts list & the routings 5 Lock the work order, the parts list and the routings with a completion date 6 Lock the order type & the work order type only
cEqWOFutureConstant3	EQW3	char	NONE	NONE
An indication of whether to print the work order when it reaches a particular status.
cEqWOFutureConstant4	EQW4	char	NONE	NONE
A code that indicates the status of a condition-based alert. Valid values are listed in UDC table 13/AS (Alert Status).
cEqWOFutureConstant5	EQW5	char	NONE	NONE
A code that specifies which role has the authority to edit a claim at a particular status. The system uses this code in the Warranty Claims program (P1777) and the Supplier Recovery Claims program (P1779). Valid roles include: Dealer Assessor Supplier Recovery Manager.
nIndex	INT01	integer	NONE	NONE
Number of Days in Future to Query for Responses Due.
nKeys	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.
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.
cBudgetApproval	BUDG	char	NONE	NONE
0 = The input status is allowed. 1 = The input status is not allowed. (The input status is not equal to the F4826 Next Status (GENTST), or the Allowed Status Codes 1-5 (GEA1ST, GEA2ST, GEA3ST, GEA4ST, or GEA5ST)). ^