Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
cMatchType | MATC | char | NONE | NONE |
A code, attached to each purchase-order detail record or receipt record, that indicates whether a voucher exists and whether the voucher
or receipt record has been reversed. Valid values are:
1
No voucher exists.
2
A voucher exists.
3
The voucher has been reversed.
4
The receipt
record has been reversed.
Note: Record types 3 and 4 are audit records only; you cannot access these record types for the Voucher Match
program (P4314) or the PO Receipts program (P4312).
|
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
|
szOrderCompany | KCOO | char | NONE | NONE |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
sales order, and so on).
If you use the Next Numbers by Company/Fiscal Year facility, the Automatic Next Numbers program (X0010) uses the
order company to retrieve the correct next number for that company. If two or more order documents have the same order number and order
type, the order company lets you locate the desired document.
If you use the regular Next Numbers facility, the order company is not used to
assign a next number. In this case, you probably would not use the order company to locate the document. |
szOrderSuffix | SFXO | char | NONE | NONE |
In the A/R and A/P systems, a code that corresponds to the pay item. In the Sales Order and Procurement systems, this code identifies
multiple transactions for an original order.
For purchase orders, the code is always 000.
For sales orders with multiple partial receipts against an
order, the first receiver used to record receipt has a suffix of 000, the next has a suffix of 001, the next 002, and so on. |
mnLineNumber | LNID | MATH_NUMERIC | NONE | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
this number,but in some cases you can override it. |
mnExistingReceiptLineNumber | NLIN | MATH_NUMERIC | NONE | NONE |
A number representing the number of lines on either a purchase or sales order.
or The number of receivers recorded during the receipts
process. This field will be used in Voucher Matching. |
szCurrentBranchPlant | MCU | char | NONE | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant.
You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department.
Business unit security might prevent you from viewing information about business units
for which you have no authority.
|
mnOperationSequence | OPRS | MATH_NUMERIC | NONE | NONE |
The sequence in which the system performs the operations or steps of the route. |
mnShortItemNumber | ITM | MATH_NUMERIC | NONE | NONE |
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 |
szLocation | LOCN | char | NONE | NONE |
The storage location from which goods will be moved. |
szLot | LOTN | char | NONE | NONE |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. |
mnMovementQuantity | UREC | MATH_NUMERIC | NONE | NONE |
The original quantity of the order line, plus or minus any changes to that quantity, less all quantities shipped, received and/or vouchered to
date. This number can also be the actual quantity received. |
szUpdateItemBalanceBucket | UPIB | char | NONE | NONE |
Indicates which quantity field in the Item Location table that the system updates when quantity is moved from one receipt routing operation
to another.
Valid values:
QTTR - Quantity in Transit
QTIN - Quantity in Inspection
QTO1 - Quantity in User-defined Operation 1
QTO2 - Quantity in User-defined Operation 2
PQOH - Quantity on Hand PREQ - Quantity on Purchase Order |
szProgramId | PID | char | NONE | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565.
The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where:
T
The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program.
SS
The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system.
XXX
The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.
|
mnNewReceiptLineNumber | NLIN | MATH_NUMERIC | NONE | NONE |
A number representing the number of lines on either a purchase or sales order.
or The number of receivers recorded during the receipts
process. This field will be used in Voucher Matching. |
szNewBranchPlant | MCU | char | NONE | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant.
You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department.
Business unit security might prevent you from viewing information about business units
for which you have no authority.
|
mnDocumentNumber | DOC | MATH_NUMERIC | NONE | NONE |
A number that identifies the original document, such as a voucher, invoice, or journal entry. On entry forms, you can assign the document
number or let the system assign it using the Next Numbers program (P0002). Matching document numbers (DOCM) identify related documents
in the Accounts Receivable and Accounts Payable systems. Examples of original and matching documents are:
Accounts Payable
o
Original document - voucher
o Matching document - payment
Accounts Receivable
o Original document - invoice
o Matching document -
receipt
Note: In the Accounts Receivable system, the following transactions simultaneously generate original and matching documents:
deductions, unapplied receipts, chargebacks, and drafts. |
mnLotPotency | LOTP | MATH_NUMERIC | NONE | NONE |
A code that indicates the potency of the lot expressed as a percentage of active or useful material (for example, the percentage of alcohol
in a solution). The actual potency of a lot is defined in the Lot Master table (F4108). |
szLotGrade | LOTG | char | NONE | NONE |
A code that indicates the grade of a lot. The grade is used to indicate the quality of the lot. Examples include the following:
A1 Premium
grade
A2 Secondary grade
The grade for a lot is stored in the Lot Master table (F4108). |
cLotStatusCode | LOTS | char | NONE | NONE |
A user defined code (41/L) that indicates the status of the lot. If you leave this field blank, it indicates that the lot is approved. All other codes
indicate that the lot is on hold.
You can assign a different status code to each location in which a lot resides on Item/Location Information or
Location Lot Status Change. |
szSupplierLotNumber | RLOT | char | NONE | NONE |
The supplier's lot number for the item. |
szMemoLotField1 | LOT1 | char | NONE | NONE |
A higher classification or grouping of serial number or lot processed items,maintained within the Lot Master (F4108). |
szMemoLotField2 | LOT2 | char | NONE | NONE |
A higher classification or grouping of memo lot 1 maintained within the lot master (F4108). |
szMoveUnitOfMeasure | 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).
|
szLotDescription | LDSC | char | NONE | NONE |
A brief description of a specific lot. |
jdLotExpiration | MMEJ | JDEDATE | NONE | NONE |
The date on which a lot of items expires.
The system automatically enters this date if you have specified the shelf life days for the item on
Item Master Information or Item Branch/Plant Information.
The system calculates the expiration date by adding the number of shelf life days to
the date that you receive the item.
You can commit inventory based on the lot expiration date for items. You choose how the system commits
inventory for an item on Item Master Information or Item Branch/Plant Information. |
mnSupplierNumber | 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.
|
jdBestBeforeDate | BBDJ | JDEDATE | OPT | NONE |
The last date on which the products in a lot should be consumed. The system calculates the date by retrieving the value from the Best
Before Days field in the Item Master program (P4101). You can also use this date as a "through" date for commitment processing. You can
commit a lot by this date by using the Commitment Date Method field in the Item Branch program (P41026). |
jdSellByDate | SBDJ | JDEDATE | OPT | NONE |
The date by which a lot should be completely sold. The system uses this date as a "through" date for commitment processing. The system
calculates the sell by date using the value in the Sell By Days field, which is contained in the Item Branch File table (F4102), when inventory
becomes available on-hand.
|
jdBasedOnDate | BODJ | JDEDATE | OPT | NONE |
The date that the system uses in conjunction with the shelf life days to calculate the lot expiration date. You can enter this date during
inventory completions. In addition to calculating the lot expiration date, the system uses the date that you enter in this field to calculate the following
lot dates:
o Sell By Date
o Best Before Date
o Lot Effectivity Date
o User Lot Date 1
o User Lot Date 2
o User Lot Date 3
o User Lot Date
4
o User Lot Date 5 |
jdOnHandDate | OHDJ | JDEDATE | OPT | NONE |
The date when a lot is considered to be on hand in a branch/plant. The system determines the on-hand date by using the transaction date
upon which the first inventory for a particular lot is determined to be on hand. The system automatically assigns this date to the Lot Master
table (F4108). |
jdLotEffectivityDate | DLEJ | JDEDATE | OPT | NONE |
The date on which a lot becomes available. The system uses this date for availability and commitment processing to indicate that the lot is
available on or after the date that you specify. You must complete this field when inventory first becomes an on-hand quantity for the lot. If you
leave this field blank, the system calculates the effective date of the lot by using the value for Effective Days in the Item Branch File table
(F4102) or the current date if the value for Effective Days is zero. |
jdUserLotDate1 | U1DJ | JDEDATE | OPT | NONE |
A date that the system can use as a through date for commitment processing. The system stores this date in the Lot Master table (F4108). If
you leave this field blank, the system can calculate the date by using the value for the User Lot Date 1 Default Days field, which is stored in
the Item Branch File table (F4102).
|
jdUserLotDate2 | U2DJ | JDEDATE | OPT | NONE |
A user-defined date that can be used for commitment purposes and is stored in the Lot Master table (F4108). Similar to the Lot Expiration
Date, User Lot Date 2 is a through date for commitment processing.
The User Lot Date 2 commitment option is available in the Commitment
Date Method in the Item Branch table (F4102). The system uses the User Lot Date 2 Default Days from the Item Branch table (F4102) to
calculate User Lot Date 2 when inventory first goes on hand.
|
jdUserLotDate3 | U3DJ | JDEDATE | OPT | NONE |
A user-defined date that can be used for commitment purposes and is stored in the Lot Master table (F4108). Similar to Lot Expiration Date,
User Lot Date 3 is a through date for commitment processing.
The User Lot Date commitment option is available in the Commitment Date
Method in the Item Branch table (F4102). The system uses the User Lot Date 3 Default Days from the Item Branch table (F4102) to calculate User
Lot Date 3 when inventory first goes on hand.
|
jdUserLotDate4 | U4DJ | JDEDATE | OPT | NONE |
A user-defined date that can be used for commitment purposes and is stored in the Lot Master table (F4108). Similar to Lot Expiration Date,
User Lot Date 4 is a through date for commitment processing.
The User Lot Date commitment option is available in the Commitment Date
Method in the Item Branch table (F4102). The system uses the User Lot Date 4 Default Days from the Item Branch table (F4102) to calculate
User Lot Date 4 when inventory first goes on hand.
|
jdUserLotDate5 | U5DJ | JDEDATE | OPT | NONE |
A user-defined date that can be used for commitment purposes and is stored in the Lot Master table (F4108). Similar to Lot Expiration Date,
User Lot Date 5 is a through date for commitment processing.
The User Lot Date 5 commitment option is available in the Commitment Date
Method in the Item Branch table (F4102). The system uses the User Lot Date 5 Default Days from the Item Branch table (F4102) to calculate
User Lot Date 5 when inventory first goes on hand.
|