Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
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. |
szDocumentType | DCT | char | NONE | 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 | NONE | 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. |
szPayItem | SFX | char | NONE | NONE |
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. |
cGLPost | POST | char | NONE | NONE |
A code the system uses to determine whether a transaction is available for the post process. Valid codes
are:
Blank
Unposted.
D
Posted.
P
Posted or posting. Depending on the type of transaction, this code has different meanings. If the code is assigned to an Account Ledger
record (F0911), it indicates a posted status. If the code is assigned to any other transaction, it indicates that the system attempted to post the
record but failed, due to an error it encountered.
M
Model. The transaciton is a model journal entry.
|
cReceiptTranCode | TRTC | char | NONE | NONE |
A code for specific transaction processing in Cash Receipts. A blank TI code will cause the transaction to be bypassed. The following is a
summarized list of valid TI codes. For more detailed information, please see the system help text for Cash Receipts w/Action Code program
(P03103).
Codes and their uses are:
1 Invoice Match Net with Discount
2 Inv Match Open without Discount
A Adjustment
B Balance
Forward
C Chargeback (Unapplied Debit)
D Inv Match w/ Chgbck for Discount
F Automatic Gain/Loss Record (foreign currency only -
machine generated)
G General Ledger
I Invoice Match
R Begin or End Range of Invoices
S Spread
U Unapplied Cash (Credit)
W
Automatic Write-off
X Skip Invoice within Range
Z Automatic Gain/Loss on Spreads (foreign currency only-machine generated) |
szMatchingDocType | DCTM | char | NONE | NONE |
Within Auto Bank Statement process, a document type is needed for the following:
1) Document Type is needed for creating Variance
Journal Entries for payments, receipts, and journal entries when running the Auto Bank Statement Process (R09616). If Document Type on the
Payment Clear tab is left blank, it will default to PN. If Document Type on the Receipt Clear tab is left blank, it will default to RC. If Document
Type on the Journal Entry Reconcile tab is left blank, it will default to JE.
2) Document Type is needed for creating Journal Entries on the
Journal Entry Create tab, and the Draft Paid tab. For both of these, it will default to JE if left blank.
|
mnGrossAmount | AG | MATH_NUMERIC | NONE | 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.
|
mnOpenAmount | AAP | MATH_NUMERIC | NONE | NONE |
The amount of an invoice or voucher pay item that is unpaid. |
mnForeignAmount | ACR | MATH_NUMERIC | NONE | NONE |
The foreign currency amount entered on the transaction. If the Multi-Currency Conversion option on the General Accounting constants is set
to Y, the foreign amount is multiplied by the exchange rate to arrive at the domestic amount. If the Multi-Currency Conversion option is set to Z,
the foreign amount is divided by the exchange rate. |
mnForeignOpenAmt | FAP | MATH_NUMERIC | NONE | NONE |
The unpaid foreign amount of a transaction. |
szRecurringFrequency | RF | char | NONE | NONE |
A code to specify the time interval between transactions that the system creates. Valid recurring frequency values
are:
MO
Monthly
AN
Annually
WK
Weekly
QT
Quarterly
SA
Semiannually
BW
Biweekly |
mnNumberOfPayments | DRF | MATH_NUMERIC | NONE | NONE |
The number of recurring invoices or vouchers that you want the system to process. This number includes the original transaction that you
enter. For example, if you enter 12, the system will process the transaction 11 additional times, reducing the value of the number of payments
by 1 each time it creates a new transaction. When this field contains 1, the system does not create a new transaction, it clears the field. |
cErrorFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event.
|
cPayStatus | PST | char | NONE | NONE |
A user defined code (00/PS) that indicates the current payment status for a voucher or an invoice. Examples of codes include:
A
Approved
for payment but not yet paid
H
Held pending approval
P
Paid
Note: Some of the payment status codes are hard coded; the system assigns
the code.
|
mnMatchingDocNo | DOCM | MATH_NUMERIC | NONE | NONE |
The number of the matching document, such as a receipt, payment, adjustment,or credit. You apply a matching document (DOCM) against
an original document (DOC), such as an invoice or voucher. |
cCurrencyMode | CRRM | char | NONE | 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.
|