Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
mnDocumentNumber | DOC | MATH_NUMERIC | OPT | INPUT |
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 | INPUT |
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 | INPUT |
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. |
mnAddressNumber | AN8 | MATH_NUMERIC | OPT | INPUT |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.
|
jdTransactionDate | DIVJ | JDEDATE | OPT | INPUT |
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. |
jdServiceTaxDate | DSVJ | JDEDATE | OPT | INPUT |
A date that indicates when you purchased goods or services, or when you incurred a tax liability.
|
jdGLDate | DGJ | JDEDATE | OPT | INPUT |
A date that identifies the financial period to which the transaction will be posted. You define financial periods for a date pattern code that you
assign to the company record. The system compares the date that you enter on the transaction to the fiscal date pattern assigned to the
company to retrieve the appropriate fiscal period number, as well as to perform date validations. |
mnFiscalYear | FY | MATH_NUMERIC | OPT | INPUT |
A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal
year (as defined on the Company Setup form).
Specify the year at the end of the first period rather than the year at the end of the fiscal period.
For example, a fiscal year begins October 1, 1998 and ends September 30, 1999. The end of the first period is October 31, 1998. Specify the
year 98 rather than 99. |
mnCentury | CTRY | MATH_NUMERIC | OPT | INPUT |
The calendar century associated with the year. Enter is the first two digits of
the year. For example, 19 indicates any year beginning with 19
(1998, 1999),
20 indicates any year beginning with 20 (2000, 2001), and so on.
|
mnPeriodNumber | PN | MATH_NUMERIC | OPT | INPUT |
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the
General Constants table (F0009), allows the user to define up to 14 accounting periods. See General Ledger Date. The current period number
is used to determine posted before and posted after cut off warning messages. It is also used as the default accounting period in the
preparation of financial reports.
|
szCompany | CO | char | OPT | INPUT |
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.
|
mnBatchNumber | ICU | MATH_NUMERIC | OPT | INPUT |
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. |
jdBatchDate | DICJ | JDEDATE | OPT | INPUT |
The date of the batch. If you leave this field blank, the system date is used. |
mnBatchTime | TICU | MATH_NUMERIC | OPT | INPUT |
The system time a batch was created. |
cCurrencyMode | CRRM | char | OPT | INPUT |
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.
|
szTransactionCurrency | CRCD | char | OPT | INPUT |
A code that identifies the currency of a transaction.
|
mnCurrencyExchangeRate | CRR | MATH_NUMERIC | OPT | INPUT |
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.
|
szBaseCurrency | BCRC | char | OPT | INPUT |
A code that represents the currency of the company for a transaction. For a foreign currency transaction, this is the currency code of the
domestic side of the transaction.
|
mnAmountToDistribute | ATAD | MATH_NUMERIC | OPT | INPUT |
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).
|
mnCurrencyAmtToDistribute | CTAD | MATH_NUMERIC | OPT | INPUT |
For a journal entry with VAT, this represents the amount to be expensed in foreign currency. |
szGLOffset | GLC | char | OPT | INPUT |
A code that determines the trade account that the system uses as the offset when you post invoices or vouchers. The system concatenates
the value that you enter to the AAI item RC (for Accounts Receivable) or PC (for Accounts Payable) to locate the trade account. For
example, if you enter TRAD, the system searches for the AAI item RCTRAD (for receivables) or PCTRAD (for payables).
You can assign up to four
alphanumeric characters to represent the G/L offset or you can assign the three-character currency code (if you enter transactions in a
multicurrency environment). You must, however, set up the corresponding AAI item for the system to use; otherwise, the system ignores the G/L
offset and uses the account that is set up for PC or RC for the company specified.
If you set up a default value in the G/L Offset field of the
customer or supplier record, the system uses the value during transaction entry unless you override it.
Note: Do not use code 9999. It is reserved for
the post program and indicates that offsets should not be created.
|
szJournalEntryMBFVersion | VERS | char | OPT | INPUT |
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. |
szAlphaName | ALPH | char | OPT | INPUT |
The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter
dashes, commas, and other special characters, but the system cannot search on them when you use this field to search for a name. |
szUserID | USER | char | OPT | INPUT |
The code that identifies a user profile.
|
szProgramID | PID | char | OPT | INPUT |
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.
|
szWorkStationID | JOBN | char | OPT | INPUT |
The code that identifies the work station ID that executed a particular job.
|
szClearingAccountNumber | ANI | char | OPT | INPUT |
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.
|
szClearingAccountID | AID | char | OPT | INPUT |
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it.
|
szClearingAcctBusinessUnit | MCU | char | OPT | INPUT |
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.
|
szClearingAcctObjectAccount | OBJ | char | OPT | INPUT |
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
subcategories. For example, you can divide the Cost Code for labor into regular time, premium time, and burden.
Note: If you use a flexible chart of
accounts and the object account is set to 6 digits, J.D. Edwards recommends that you use all 6 digits. For example, entering 000456 is not
the same as entering 456 because if you enter 456 the system enters three blank spaces to fill a 6-digit object. |
szClearingAcctSubsidiary | SUB | char | OPT | INPUT |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.
|
szClearingAcctCompany | CO | char | OPT | INPUT |
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.
|
cConfigHubMethod | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event.
|
cTransactionType | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event.
|
szVendorInvoiceNumber | VINV | char | OPT | INPUT |
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).
|
szNameRemarkExplanation | EXR | char | OPT | INPUT |
A name or remark that describes the purpose for using an account or conveys any other information that the user wants about the
transaction. |