F4801GetRateOrderNumber

F4801 Get Rate Order Number

Minor Business Rule

Object Name: N3101740

Parent DLL: CMFGBASE

Location: Client/Server

Language: NER

1.Functional Description

1.1Purpose

The function will check F4801 for an existing Rate with the same  Item Number ITM, Branch/Plant MMCU,
Document Type DCTO, Line LINE, Start Date STRT, and Request Date DRQJ.  If Period MWDH is not equal
to blank or the Rate Status SRST does not match, the function will look for another Rate until one is
found, when the same filtering will be done.   If none are found, the function will return an
indicator.  If one is  found the function will return the Rate document number DOCO.

1.2Setup Notes and Prerequisites

None.

1.3Special Logic

None.

2.Technical Specifications

2.4Processing

Open F4801
If Successful,

Select to retrieve DOCO, passing ITM, MMCU, STRT, DRQJ, DCTO, and SRST.
If Successful,

While not EOF and record is not found yet

Fetch from F4801T, passing DOCO to retrieve MWDH and LINE.
If MWDH is not equal to blank

Record is found
Pass back DOCO

End If

End While

End If

Else

Send ERRC open table failed.

End If
Close F4801

Data Structure

D3101740 - F4801 Get Rate Order Number

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

mnIdentifierShortItem ITM MATH_NUMERIC REQ INPUT

An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and
so forth. The item numbers are as follows:   o Item Number (short) - An eight-digit, computer-assigned item number     o 2nd Item Number - The
25-digit, free-form, user defined alphanumeric item number     o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item
number

szBranch MMCU char REQ INPUT

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.

jdDateStart STRT JDEDATE REQ INPUT

The start date for the order. You can enter this date manually, or have the system calculate it using a backscheduling routine. The routine
starts with the required date and offsets the total leadtime to calculate the appropriate start date.

jdDateRequested DRQJ JDEDATE REQ INPUT

The date that an item is scheduled to arrive or that an action is scheduled for completion.

szOrderType DCTO char REQ INPUT

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

szStatus SRST char REQ INPUT

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.

szLine LINE char REQ INPUT

A number that defines a production line or cell. Detailed work center operations can be defined inside the line or cell.

mnOrderNumber DOCO MATH_NUMERIC OPT OUTPUT

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.

cErrorCode ERRC char OPT OUTPUT

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

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

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnIdentifierShortItem	ITM	MATH_NUMERIC	REQ	INPUT
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and so forth. The item numbers are as follows: o Item Number (short) - An eight-digit, computer-assigned item number o 2nd Item Number - The 25-digit, free-form, user defined alphanumeric item number o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number
szBranch	MMCU	char	REQ	INPUT
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.
jdDateStart	STRT	JDEDATE	REQ	INPUT
The start date for the order. You can enter this date manually, or have the system calculate it using a backscheduling routine. The routine starts with the required date and offsets the total leadtime to calculate the appropriate start date.
jdDateRequested	DRQJ	JDEDATE	REQ	INPUT
The date that an item is scheduled to arrive or that an action is scheduled for completion.
szOrderType	DCTO	char	REQ	INPUT
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
szStatus	SRST	char	REQ	INPUT
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.
szLine	LINE	char	REQ	INPUT
A number that defines a production line or cell. Detailed work center operations can be defined inside the line or cell.
mnOrderNumber	DOCO	MATH_NUMERIC	OPT	OUTPUT
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.
cErrorCode	ERRC	char	OPT	OUTPUT
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).
cShiftCode	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 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.