Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
mnEdiDocumentNumber | EDOC | MATH_NUMERIC | NONE | NONE |
The document number that is assigned by the transmitter in an EDI transaction.
In a non EDI environment, this would be consistent with the
order number assigned at order entry time (DOCO). |
szEdiDocumentType | EDCT | char | NONE | NONE |
The document type that is assigned by the transmitter in an EDI transaction.
In a non EDI environment, this would be consistent with the order
type (DCTO) assigned at order entry time, an invoice document type, a voucher document type, and so on. |
szCompanyKeyEdiOrder | EKCO | char | NONE | NONE |
Company - Key (EDI - Document Key Co) |
mnEdiLineNumber | EDLN | MATH_NUMERIC | NONE | NONE |
This is the line number you assign when originating an EDI transaction. This number can represent an order line number (applicable for any
order type), an invoice pay item, a journal entry line number, and so on. |
cEDIType | EDTY | char | NONE | NONE |
The identifier used to mark EDI transaction records as header and detail information. This is an EDI function only. |
mnEDISeq | EDSQ | MATH_NUMERIC | NONE | NONE |
An identifier that is used to assign the relative position within the header or detail information of an EDI transaction-- for example, H01, H02,
D01, and so on.
|
szEdiTransactionSet | EDST | char | NONE | NONE |
The qualifier used to identify a specific type of EDI transaction. |
szEdiTranslationFormat | EDFT | char | NONE | NONE |
The qualifier used to identify a specific mapping structure used to process both inbound and outbound EDI transactions. This does not
apply to non-EDI transactions. |
cEdiSendRcvIndicator | EDER | char | NONE | NONE |
Indicator used to identify if a specific transaction set can be sent, received or both. Valid values are:
S Send
R Receive
B Both |
szEdiBatchNumber | EDBT | char | NONE | NONE |
The number that the transmitter assigns to the batch. During batch processing, the system assigns a new batch number to the PeopleSoft
transactions for each control (user) batch number it finds.
|
szTradingPartnerId | PNID | char | NONE | NONE |
Field used in an EDI transaction to identify the party that is trading document with you. |
szTransactionOriginator | TORG | char | NONE | NONE |
The person who originally entered the transaction. |
szUserId | USER | char | NONE | NONE |
The code that identifies a user profile.
|
szWorkStationId | JOBN | char | NONE | NONE |
The code that identifies the work station ID that executed a particular job.
|
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.
|
jdDateUpdated | UPMJ | JDEDATE | NONE | NONE |
The date that specifies the last update to the file record. |
mnTimeOfDay | TDAY | MATH_NUMERIC | NONE | NONE |
The computer clock in hours:minutes:seconds. |
szItemNoCustomerVendor | CITM | char | NONE | NONE |
The cross-reference item number that the system assigns to an item number. A cross-reference number allows you to use a supplier's item
number if it is different from your own item number when you are processing an order or printing. |
mnDocumentOrderInvoiceE | 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
|
szCompanyKeyOrderNo | 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. |
mnIdentifierShortItem | 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 |
szIdentifier2ndItem | LITM | char | NONE | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
alternative item numbers. The three types of item numbers are:
Item Number (short)
An 8-digit, computer-assigned item number.
2nd Item Number
A
25-digit, user defined, alphanumeric item number.
3rd Item Number
Another 25-digit, user defined, alphanumeric item number.
In addition to
these three basic item numbers, the system provides an extensive cross-reference search capability. You can define numerous
cross-references to alternative part numbers. For example, you can define substitute item numbers, replacements, bar codes, customer numbers, or
supplier numbers.
|
szIdentifier3rdItem | AITM | char | NONE | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
numbers are as follows:
1. Item Number (short) - An 8-digit, computer-assigned 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.
In addition to
these three basic item numbers, an extensive cross-reference search capability has been provided (see XRT). Numerous cross references to
alternate part numbers can be user defined, such as substitute item numbers, replacements, bar codes, customer numbers, or supplier
numbers. |
szStatusCodeNext | NXTR | char | NONE | NONE |
A user defined code (system 40/type AT) indicating the next step in the order flow of the line type. |
szStatusCodeLast | LTTR | char | NONE | NONE |
A code (system 40/type AT) specifying the last step in the processing cycle that this order line has successfully completed. |
mnChangeOrderLineNumber | CHLN | MATH_NUMERIC | NONE | NONE |
The number of times this detail line has been revised. |
szChangeCode | CHGC | char | OPT | NONE |
Code specifying the type of change to the line item in an EDI Purchase Order Change, Purchase Order Change Acknowledgment, Product
Transfer Account Adjustment, Price Authorization Acknowledgment, Response to Product Transfer Account Adjustment, and Lease
Schedule. Refer to ANSI X.12 Data Item 670.
Valid change codes for inbound transactions are:
A Add this line/item
C Change this line/item -
replace all fields mapped into record
D Delete this line/item
Q D Change this line/item (quantities expressed as decrease amounts)
QI
Change this line/item (quantities expressed as increase amounts)
On outbound transactions, the change code is derived from the first two bytes of
the reason code (RCD) on the order detail line, or if the reason code is blank, the code will be computed as follows:
o If the quantity open is
zeros, then the change code will be D. If the line is new, then the change code will be A. If any field has changed on the record, the the
change code will be C. |