Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
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
|
mnPayrollTransactionNo | PRTR | MATH_NUMERIC | OPT | NONE |
A unique number that the system assigns to each timecard. You can use this field in the Time Entry By Job program to retrieve a specific
timecard for display. This field is also used to tie a timecard to each Actual Burden audit record created for the timecard during the Actual
Burden Journaling process. |
mnAddressNumber | 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.
|
mnCurrencyConverRateDiv | CRRD | MATH_NUMERIC | OPT | NONE |
A number (exchange rate) that a foreign currency amount is divided by to calculate a domestic currency amount. The number you enter in
this field can have a maximum of seven decimal positions. If more are entered, the system adjusts to the nearest seven decimal positions.
|
mnDocumentOrderAlt | DOCZ | MATH_NUMERIC | OPT | NONE |
The original document number. This can be a voucher, an invoice, unapplied cash, a journal entry number, etc. Matching document
numbers are also used to identify related documents in the Accounts Receivable and Accounts Payable systems. See matching document
(DOCM). This document number (DOCO) is always the original document number, and the matching document number (DOCM) is the check,
adjustment, or credit to be applied against the original document.
For example:
A/P Automated/Manual Payment: Original (DOCO) - Voucher;
Matching Document (DOCM) - Payment
A/R Original Invoice: Original (DOCO) - Invoice
Receipt Application: Original (DOCO) - Invoice; Matching
Document (DOCM) - Receipt
Credit Memo/Adjustment: Original (DOCO) - Invoice; Matching Document (DOCM) -Credit Memo
Unapplied
Case: Original (DOCO) - Receipt |
szDocTypeInvoiceOnly | DCTI | char | OPT | NONE |
A user defined (00/DI) document type for invoice entry. Any document type set up for invoice-only entry should begin with the letter R
(receivables). The default is RI, RR, or RM. Reserved document types have been defined for vouchers, invoices, receipts, and time sheets.
The
reserved document types are:
P_
Accounts Payable Documents R_Accounts Receivable Documents
T_
Payroll Documents I_Inventory
Documents
O_
Order Processing Documents
Note: Verify that the default document type for invoices is set up in both UDC 00/DT and UDC 00/DI.
|
szDocumentCompanyInvoice | KCOI | char | OPT | NONE |
Invoice Document Company. |
jdApplicatnDate | APDT | JDEDATE | OPT | NONE |
The date of the last or current application. (An application is assigned each time an invoice is issued for the contract.) |
szDocumentPayItem | SFX | char | OPT | 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. |
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. |
szGlClass | GLC | char | OPT | NONE |
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.
|
mnPercntRetainage | PRET | MATH_NUMERIC | OPT | NONE |
The retainage rate for the contract. The rate is a percentage that is expressed as a whole number. For example, you enter a retainage rate
of 10.5 percent as 10.5. |
szGlOffsetRetention | RGLC | char | OPT | NONE |
A code that designates the offset accounts for retainage, for example RETN or 1225. You set up the code as an automatic accounting
instruction.
Note: Do not use code 9999. This is reserved for the post program and indicates that offsets should not be created. |
jdDateForGLandVoucherJULIA | DGJ | JDEDATE | OPT | NONE |
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. |
szUserId | USER | char | OPT | NONE |
The code that identifies a user profile.
|
szWorkStationId | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job.
|
jdDateUpdated | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. |
mnTimeLastUpdated | UPMT | MATH_NUMERIC | OPT | NONE |
The time that specifies when the program executed the last update to this record. |
szPaymentTermsCode01 | 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.
|
szCurrencyCodeFrom | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction.
|
szCurrencyCodeOrigin | CRCF | char | OPT | NONE |
The currency code of the insured amount. |
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.
|
cModeOfInputValues | MIVL | char | OPT | NONE |
This code indicates the mode of input for Schedule of Values.
Valid values are:
blank indicates dollar amount entered.
% indicates
percent complete entered.
/ indicates units entered. |
mnAddressNumberJobAr | AN8O | MATH_NUMERIC | OPT | NONE |
The address book number to which the system posts billing and accounts receivable transactions. |
szTaxArea1 | TXA1 | char | OPT | NONE |
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
against the Tax Areas table (F4008). The system uses the tax rate area in conjunction with the tax explanation code and tax rules to calculate tax
and G/L distribution amounts when you create an invoice or voucher. |
szTaxExplanationCode1 | EXR1 | char | OPT | NONE |
A hard-coded user defined code (00/EX) that controls the algorithm that the system uses to calculate tax and G/L distribution amounts. The
system uses the tax explanation code in conjunction with the tax rate area and tax rules to determine how the tax is calculated. Each
transaction pay item can be defined with a different tax explanation code. |
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.
|
cVertexActiveFlag | VVTX | char | OPT | NONE |
This flag determines whether to use the Vertex Tax Compliance system for tax calculations. Values are:
Y
Use Vertex system to calculate
taxes.
N
Do not use Vertex system to calculate taxes. Instead, use JDE tax calculations.
|
mnVertexCacheJobNo | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. |