Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
szInvoiceNumber | VINV | char | OPT | NONE |
The supplier's invoice number that is used for voucher entry. Voucher entry allows only one invoice per voucher number. If multiple invoice
numbers exist on a voucher, you must set them up as multiple vouchers or combine the invoices and enter them as one voucher. Depending
on how you have your accounts payable constants set, the system can do one of the following:
o Accept a duplicate invoice number
without warning or error
o Generate a warning message in which the duplicate invoice number can still be accepted
o Generate an error
message
Blank values are treated in the same manner as any other invoice number. Two blank invoice numbers are treated as duplicates.
To test
for duplicate invoice numbers that might have been entered in error, run the Suspected Duplicate Payments report (R04601).
Note: The
duplicate invoice number validation is not run for vouchers with document type NO. These vouchers are created by the Generate Reimbursements
program (R03B610).
|
mnSupplier | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.
|
szCompany | CO | char | OPT | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany
transactions.
Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000
for transaction entries.
|
szSupplierCurrency | CRDC | char | OPT | NONE |
A code that identifies the domestic (base) currency of the company on a transaction.
|
mnExchageRate | CRR | MATH_NUMERIC | OPT | NONE |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
can have a maximum of seven decimal positions. If more are entered, the system adjusts to the nearest seven decimal positions.
|
cCurrencyMode | CRRM | char | OPT | NONE |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
foreign currency of the transaction.
Off
The system displays amounts in the domestic currency of the transaction.
|
cCurrencyConversionMethod | CRCM | char | OPT | NONE |
A value that specifies which method to use when converting from one currency to another. Valid values are:
Y
Multiplier method. The
system multiplies the foreign amount by the multiplier exchange rate to calculate the domestic amount.
Z
Divisor method. The system divides the
foreign amount by the divisor exchange rate to calculate the domestic amount.
|
cCurrencyConverYNAR | CRYR | char | OPT | NONE |
A code that specifies whether to use multi-currency accounting, and the method of multi-currency accounting to use:
Codes are:
N Do not
use multi-currency accounting. Use if you enter transactions in only one currency for all companies. The multi-currency fields will not appear
on forms. The system supplies a value of N if you do not enter a value.
Y Activate multi-currency accounting and use multipliers to convert
currency. The system multiplies the foreign amount by the exchange rate to calculate the domestic amount.
Z Activate multi-currency
accounting and use divisors to convert currency. The system divides the foreign amount by the exchange rate to calculate the domestic amount. |
mnInvoiceAmount | AG | MATH_NUMERIC | OPT | NONE |
A value that specifies the total amount of the invoice or voucher pay item. The gross amount might include the tax amount, depending on
the tax explanation code. The system does not decrease the gross amount when payments are applied. When you void a transaction, the
system clears the gross amount field.
|
szPaymentTermsCode | PTC | char | OPT | NONE |
A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date.
Use a blank code to indicate the most frequently-used payment term. You define each type of payment term on the Payment Terms Revisions
form. Examples of payment terms include:
Blank
Net 15
001
1/10 net 30
002
2/10 net 30
003
Due on the 10th day of every month
006
Due upon receipt
This code prints on customer invoices.
|
jdInvoiceDate | DIVJ | JDEDATE | OPT | NONE |
The date that either you or the system assigns to an invoice or voucher. This can be either the date of the supplier's invoice to you or the
date of your invoice to the customer. |
mnInvoiceTax | STAM | MATH_NUMERIC | OPT | NONE |
The amount assessed and payable to tax authorities. It is the total of the VAT, use, and sales taxes (PST). |
mnOrderNumber | DOCO | MATH_NUMERIC | OPT | 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 | OPT | 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 | OPT | 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 | OPT | 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. |
jdDueDate | DDJ | JDEDATE | OPT | NONE |
In Accounts Receivable, the date that the net payment is due.
In Accounts Payable, the date that the payment is due to receive a discount
or, if no discount is offered, the net due date.
The system calculates the due date based on the payment term entered, or you can enter it
manually. If you enter a negative voucher or invoice (debit or credit memo), the system might use the G/L date as the due date regardless of the
payment term entered. A processing option in the master business function (P0400047 for vouchers and P03B0011 for invoices) controls how
the system calculates the due date for debit and credit memos.
|
jdDiscountDueDate | DDNJ | JDEDATE | OPT | NONE |
In the Accounts Receivable system, the date that the invoice must be paid to receive the discount. The system calculates the discount due
date based on the payment term. If the payment term does not specify a discount, the system completes this field with the net due date.
In the
Accounts Payable system, the date that the voucher is due. |
mnShortItemNumber | ITM | MATH_NUMERIC | OPT | 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 |
mnMatchUnits | UOPN | MATH_NUMERIC | OPT | NONE |
The original quantity for the order detail line, plus or minus any changes to that quantity, minus all quantities shipped, received, and
vouchered to date. |
szMatchUOM | UOM | char | OPT | 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).
|
mnInvoiceLineTax | STAM | MATH_NUMERIC | OPT | NONE |
The amount assessed and payable to tax authorities. It is the total of the VAT, use, and sales taxes (PST). |
mnHandlingCharges | AEXP | MATH_NUMERIC | OPT | NONE |
The number of units multiplied by the unit price. |
szRemark | RMK | char | OPT | NONE |
A generic field that you use for a remark, description, name, or address.
|
cDoneProcessing | DONE | char | OPT | NONE |
|
mnAPJobnumber | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. |
mnGLJobnumber | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. |
mnBatchNumber | ICU | MATH_NUMERIC | OPT | 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. |
szBatchType | ICUT | char | OPT | NONE |
A code that specifies the system and type of transactions entered in a batch. The system assigns the value when you enter a transaction.
Valid values are set up in user defined code table 98/IT. You cannot assign new values. All batch types are hard coded. |
jdBatchDate | DICJ | JDEDATE | OPT | NONE |
The date of the batch. If you leave this field blank, the system date is used. |
szUserId | USER | char | OPT | NONE |
The code that identifies a user profile.
|
szComputerID | CTID | char | OPT | NONE |
|
szProgramId | PID | char | OPT | 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.
|
cVoucherType | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
mnUnitPrice | PRRC | MATH_NUMERIC | OPT | NONE |
The unit cost of one item, as purchased from the supplier, excluding freight,taxes, discounts, and other factors that might modify the actual
unit cost you record when you receive the item. |
mnInvoiceLineAmount | AG | MATH_NUMERIC | OPT | NONE |
A value that specifies the total amount of the invoice or voucher pay item. The gross amount might include the tax amount, depending on
the tax explanation code. The system does not decrease the gross amount when payments are applied. When you void a transaction, the
system clears the gross amount field.
|
szGL_MBFVersion | VERS | char | OPT | NONE |
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a
menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version. |
szAP_MBFVersion | VERS | char | OPT | NONE |
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a
menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version. |
mnDocumentNumber | DOC | MATH_NUMERIC | OPT | 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. |
szDocumentType | DCT | char | OPT | 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
|
szDocumentCompany | KCO | char | OPT | NONE |
A number that, with the document number, document type and G/L date, uniquely identifies an original document, such as invoice, voucher,
or journal entry.
If you use the Next Numbers by Company/Fiscal Year feature, the Automatic Next Numbers program (X0010) uses the
document company to retrieve the correct next number for that company.
If two or more original documents have the same document number and
document type, you can use the document company to locate the desired document. |
jdGLDate | DGL | JDEDATE | OPT | 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.
|
cPaymentInstrument | PYIN | char | OPT | NONE |
A user defined code (00/PY) that determines the means by which a payment is issued to a supplier or received from the customer.
Examples of payment instruments include check, electronic funds transfer, lockbox, and EDI.
|
szCompanyCurrency | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction.
|
mnLastLineNumber | XTLN | MATH_NUMERIC | OPT | NONE |
A line number designation within an item transaction. This data field is only used to sequence the transaction for inquiry purposes. |
mnPOJobnumber | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. |
mnDomAmountToDistribute | ATAD | MATH_NUMERIC | OPT | NONE |
The amount of the transaction that must be posted to the general ledger for the transaction to balance. Depending on the tax information
provided, the value of this field might be different from the gross or taxable amount of the transaction.
For example, if you enter a voucher for the
taxable amount of 1000 CAD using tax explanation C (sales plus VAT), and the tax rate area is set up for 7% VAT and 3% Sales, the system
calculates the amount to distribute as 1, 030 CAD (1000 + 30).
|
mnForAmountToDistribute | CTAD | MATH_NUMERIC | OPT | NONE |
For a journal entry with VAT, this represents the amount to be expensed in foreign currency. |
cBatchStatus | IST | char | OPT | NONE |
A user defined code (98/IC) that indicates the posting status of a batch. Valid values are:
Blank
Unposted batches that are pending
approval or have a status of approved.
A
Approved for posting. The batch has no errors, and is in balance, but has not yet been posted.
D
Posted. The batch posted successfully.
E
Error. The batch is in error. You must correct the batch before it can post.
P
Posting. The system
is in the process of posting the batch to the general ledger. The batch is unavailable until the posting process is complete. If errors occur
during the post, the batch status changes to E (error).
U
In use. The batch is temporarily unavailable because someone is working with it, or
the batch appears to be in use because a power failure occurred while the batch was open.
|
cErrorCode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
szAccountNumber | ANI | char | OPT | NONE |
A value that identifies an account in the general ledger. Use one of the following formats to enter account numbers:
o Standard account
number (business unit.object.subsidiary or flex format).
o Third G/L number (maximum of 25 digits).
o Account ID number. The number is eight
digits long.
o Speed code, which is a two-character code that you concatenate to the AAI item SP. You can then enter the code instead of
an account number.
The first character of the account number indicates its format. You define the account format in the General Accounting
constants.
|
mnProcessID | PEID | MATH_NUMERIC | OPT | NONE |
A code that identifies the Inter-Process Communication ID. |
mnTransactionID | TCID | MATH_NUMERIC | OPT | NONE |
|
szP43XPIVersion | VERS | char | OPT | NONE |
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a
menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version. |
mnOrderLineNumber | LNID | MATH_NUMERIC | OPT | 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. |
mnHeaderOrderNumber | DOCO | MATH_NUMERIC | OPT | 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. |
szHeaderOrderType | DCTO | char | OPT | 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
|
szHeaderOrderCompany | KCOO | char | OPT | 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. |
szHeaderOrderSuffix | SFXO | char | OPT | 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. |
szLoggedVoucherVersion | VERS | char | OPT | NONE |
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a
menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version. |
szVoucherMatchVersion | VERS | char | OPT | NONE |
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a
menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version. |
mnAccumulatedAmount | AEXP | MATH_NUMERIC | OPT | NONE |
The number of units multiplied by the unit price. |
szOrderEntryVersion | VERS | char | OPT | NONE |
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a
menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version. |
mnPayeeAddressNumber | PYE | MATH_NUMERIC | OPT | NONE |
The address book number of the recipient of the payment.
|
szDefTaxRateArea | TXA2 | char | OPT | NONE |
A user-defined code that identifies a tax or geographical area that has common tax rates and tax distribution. The tax rate/area must be
defined to include the tax authorities (for example, state, county, city, rapid transit district,or province) and their rates.
Typically, the U.S. sales and
use taxes require multiple taxing authorities per tax rate/area, whereas value added taxes often require only one simple rate. |
szDefTaxExplCode | EXR2 | char | OPT | NONE |
A value in user defined code table 00/EX that controls how a tax is assessed and distributed to the general ledger revenue and expense
accounts. You assign this code to customers or suppliers to set up a default code for their transactions.
Do not confuse this code with the
taxable, non-taxable code. A single invoice or voucher can have both taxable and non-taxable items. The entire invoice or voucher, however,
must have one tax explanation code.
|
cErrorLevel | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
nBypassWarning | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due.
|