Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
mnPaymentID | PYID | MATH_NUMERIC | REQ | INPUT |
A number that the system assigns from Next Numbers to identify and track payment records. |
mnDocumentNumber | DOC | MATH_NUMERIC | REQ | 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 | REQ | 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 | REQ | 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. |
szDocumentPayItem | SFX | char | REQ | INPUT |
A number that identifies the pay item for a voucher or an invoice. The system assigns the pay item number. If the voucher or invoice has
multiple pay items, the numbers are sequential. |
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.
|
mnParentNumber | PA8 | MATH_NUMERIC | OPT | INPUT |
The address book number of the parent company. The system uses this number to associate a particular address with a parent company
or location. Any value that you enter in this field updates the Address Organizational Structure Master table (F0150) for the blank structure
type. This address number must exist in the Address Book Master table (F0101) for validation purposes. Examples of address book records
that would have a parent number include:
o Subsidiaries with parent companies
o Branches with a home office
o Job sites with a general
contractor
|
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.
|
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. |
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.
|
szUnappliedAcctID | 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.
|
szBatchType | ICUT | char | OPT | INPUT |
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. |
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. |
mnAmountForeignOpen | FAP | MATH_NUMERIC | OPT | INPUT |
The unpaid foreign amount of a transaction. |
mnAmountOpen | AAP | MATH_NUMERIC | OPT | INPUT |
The amount of an invoice or voucher pay item that is unpaid. |
szCurrencyCodeFrom | CRCD | char | OPT | INPUT |
A code that identifies the currency of a transaction.
|
mnExchangeRate | 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.
|
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.
|
szCurrencyCodeBase | 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.
|
szBusinessUnit | 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.
|
szBusinessUnit2 | MCU2 | char | OPT | INPUT |
An accounting entity, such as a profit center, department, warehouse location, job, project, workcenter, and so on, required for management
reporting. |
szRemark | RMK | char | OPT | INPUT |
A generic field that you use for a remark, description, name, or address.
|
szReference | VR01 | char | OPT | INPUT |
An alphanumeric value used as a cross-reference or secondary reference number. Typically, this is the customer number, supplier
number, or job number. |
szUnitNumber | UNIT | char | OPT | INPUT |
The number that identifies the actual space within a building that is or can be leased, such as an apartment, office, retail space, parking
space, and so on. |
szPurchaseOrder | PO | char | OPT | INPUT |
A document that authorizes the delivery of specified merchandise or the rendering of certain services.
|
szPurchaseDctType | PDCT | char | OPT | INPUT |
A value that is hard-coded in the originating programs and passed to the Accounts Payable system.
In Accounts Receivable, the document
type on the purchase order issued by the customer can be entered directly into the Accounts Receivable Ledger (F03B11) |
szPurchaseDctCompany | PKCO | char | OPT | INPUT |
For purchase orders, a code that differentiates a record from another with the same document number, document type, and G/L date.
If you
are using the Next Numbers by Company/Fiscal Year feature of the software, the Next Numbers program (X0010) uses the document
company to retrieve the next number. If two or more original documents have the same document number and type, you can use the document
company to locate the correct record. |
mnNetTransactionID | NETTCID | MATH_NUMERIC | OPT | INPUT |
A number that identifies a netting transaction. The system assigns it using the Next Numbers program (P0002). A netting transaction could
contain one or more netting documents.
|
mnNetDocumentNumber | NETDOC | MATH_NUMERIC | OPT | INPUT |
A number that the system uses to cross reference netting source documents from which netting transfer and netting result documents are
generated.
The system assigns it using the Next Numbers program (P0002). Examples of netting source documents are:
Accounts Payable
o
Voucher
o Debit Memo
Accounts Receivable
o Invoice
o Credit Memo
o Chargeback
o Unapplied Cash
|
mnNetLineID | NETRC5 | MATH_NUMERIC | OPT | INPUT |
A number that identifies the pay item for a netting source document (voucher or invoice). The system assigns this number. If the voucher or
invoice has multiple pay items, the numbers are sequential.
|
szNettingClearAcct | 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.
|
cErrorFlag | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event.
|
szNettingBusinessUnit | 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.
|
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.
|
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. |
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.
|
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.
|