Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
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.
|
szCountry | CTR | char | OPT | NONE |
A user defined code (00/CN) that identifies a country. The country code has no effect on currency conversion.
The Address Book system
uses the country code for data selection and address formatting. |
szCallingAppl | 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.
|
szCallingForm | FID | char | OPT | NONE |
The Form ID refers to the report (R), form (V), or table number (F). |
szCallingVers | 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. |
szFormAction | FATN | char | OPT | NONE |
Form Action for Localization Exits UDC 00/FA
1 ADD Add
2 CHG Change
3 DEL Delete
4 XIT Hypercontrol Exit |
mnKey1_DocumentNumber | 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. |
szKey2_DocumentType | 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
|
szKey3_CompanyKey | 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. |
szKey4_DocumentPayItem | 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. |
mnKey5_PayItemExtensionNumber | SFXE | MATH_NUMERIC | OPT | NONE |
A code to designate an adjusting entry to a pay item on a voucher or invoice. This field is required so that each record is unique. |
cGLPostedCode | POST | char | OPT | 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.
|
cStatusVoucher | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
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.
|
cSystemCodeFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
mnTaxAmount | 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.
|
szComputerID | CTID | char | OPT | NONE |
|
mnJobnumberA | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. |
szTaxArea | TA | char | OPT | NONE |
Tax Area-Payroll. The code of a taxing authority. All time entries for this Cost Center default to the value entered in this field. |
jdDateServiceCurrency | DSVJ | JDEDATE | OPT | NONE |
A date that indicates when you purchased goods or services, or when you incurred a tax liability.
|
mnIdentifierShortItem | 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 |
mnTaxRate1 | TXR1 | MATH_NUMERIC | OPT | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
Enter the percentage as a whole number and not as the decimal equivalent. For example, to specify 7 percent, enter 7, not .07.
|
mnTaxRate2 | TXR2 | MATH_NUMERIC | OPT | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
Enter the percentage as a whole number and not as the decimal equivalent. For example, to specify 7 percent, enter 7, not .07.
|
mnTaxRate3 | TXR3 | MATH_NUMERIC | OPT | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
Enter the percentage as a whole number and not as the decimal equivalent. For example, to specify 7 percent, enter 7, not .07.
|
mnTaxRate4 | TXR4 | MATH_NUMERIC | OPT | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
Enter the percentage as a whole number and not as the decimal equivalent. For example, to specify 7 percent, enter 7, not .07.
|
mnTaxRate5 | TXR5 | MATH_NUMERIC | OPT | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
Enter the percentage as a whole number and not as the decimal equivalent. For example, to specify 7 percent, enter 7, not .07.
|
mnTaxAuthority1A | TA1 | MATH_NUMERIC | OPT | NONE |
The address book number of the tax agency that has jurisdiction in the tax area. You pay and report sales, use, or VAT taxes to this
agency. Examples include states, counties, cities, transportation districts, provinces, and so on. You can specify up to five tax authorities for a single
tax area.
|
mnTaxAuthority2 | TA2 | MATH_NUMERIC | OPT | NONE |
The address book number of the tax agency that has jurisdiction in the tax area. You pay and report sales, use, or VAT taxes to this
agency. Examples include states, counties, cities, transportation districts, provinces, and so on. You can specify up to five tax authorities for a single
tax area.
|
mnTaxAuthority3 | TA3 | MATH_NUMERIC | OPT | NONE |
The address book number of the tax agency that has jurisdiction in the tax area. This is the agency to whom you pay and report sales, use,
or VAT taxes. Examples include states, counties, cities, transportation districts, provinces, and so on. You can specify up to five tax
authorities for a single tax area.
|
mnTaxAuthority4 | TA4 | MATH_NUMERIC | OPT | NONE |
The address book number of the tax agency that has jurisdiction in the tax area. You pay and report sales, use, or VAT taxes to this
agency. Examples include states, counties, cities, transportation districts, provinces, and so on. You can specify up to five tax authorities for a single
tax area.
|
mnTaxAuthority5 | TA5 | MATH_NUMERIC | OPT | NONE |
The address book number of the tax agency that has jurisdiction in the tax area. You pay and report sales, use, or VAT taxes to this
agency. Examples include states, counties, cities, transportation districts, provinces, and so on. You can specify up to five tax authorities for a single
tax area.
|
szGlClassByTaxArea1 | GL01 | char | OPT | NONE |
A code that indicates how to locate the tax account for general ledger entries. This field points to automatic accounting instructions (AAIs)
that, in turn, point to the tax account.
Examples are:
PTyyyy - for A/P (VAT only)
RTyyyy - for A/R (VAT only)
GTyyyy - for G/L (VAT
only)
4320 - for Sales Orders
4400 and 4410 - for Purchase Orders
When setting up VAT and Canadian GST, PTyyyy, RTyyyy, and
GTyyyy are the only valid values. For the A/P system, a second G/L Offset (PT_ _ _ _) is required when your tax setup involves VAT plus use
taxes (tax explanation code B). Use AAI PT_ _ _ _ to designate the use tax portion of the setup.
For sales taxes, the Accounts Payable and
Accounts Receivable systems ignore the values in this field. However, the Sales Order Management and Procurement systems require values in
this field. |
szGlClassByTaxArea2 | GL02 | char | OPT | NONE |
Code that indicates how to locate the tax account for general ledger entries.
This field points to automatic accounting instructions (AAIs) that,
in turn, point to the tax account.
Examples are:
PTxxxx
for A/P (VAT only)
RTxxxx
for A/R (VAT only)
GTxxxx
for G/L (VAT only)
SOTxxx
for Sales Orders
OPTxxx and OPAxxx
for Purchase Orders
For VAT and Canadian GST, only PTxxxx, RTxxxx, and GTxxxx are valid.
For sales taxes, the A/P and A/R systems ignore the values in this field. For sales taxes, the Sales Order and Purchaser Order systems
require values in this field. For the General Accounting system, VAT journal entries require values in this field. At this time, however, the system
only uses the first G/L offset. |
szGlClassByTaxArea3 | GL03 | char | OPT | NONE |
Code that indicates how to locate the tax account for general ledger entries.
This field points to automatic accounting instructions (AAIs) that,
in turn, point to the tax account.
Examples are:
PTxxxx
for A/P (VAT only)
RTxxxx
for A/R (VAT only)
GTxxxx
for G/L (VAT only)
SOTxxx
for Sales Orders
OPTxxx and OPAxxx
for Purchase Orders
For VAT and Canadian GST, only PTxxxx, RTxxxx, and GTxxxx are
valid. For sales taxes, the A/P and A/R systems ignore the values in this field. For sales taxes, the Sales Order and Purchaser Order systems
require values in this field. For the General Accounting system, VAT journal entries require values in this field. At this time, however, the system
only uses the first G/L offset. |
szGlClassByTaxArea4 | GL04 | char | OPT | NONE |
Code that indicates how to locate the tax account for general ledger entries.
This field points to automatic accounting instructions (AAIs) that,
in turn, point to the tax account.
Examples are:
PTxxxx
for A/P (VAT only)
RTxxxx
for A/R (VAT only)
GTxxxx
for G/L (VAT only)
SOTxxx
for Sales Orders
OPTxxx and OPAxxx
for Purchase Orders
For VAT and Canadian GST, only PTxxxx, RTxxxx, and GTxxxx are valid.
For sales taxes, the A/P and A/R systems ignore the values in this field. For sales taxes, the Sales Order and Purchaser Order systems require
values in this field. For the General Accounting system, VAT journal entries require values in this field. At this time, however, the system only
uses the first G/L offset. |
szGlClassByTaxArea5 | GL05 | char | OPT | NONE |
Code that indicates how to locate the tax account for general ledger entries.
This field points to automatic accounting instructions (AAIs) that,
in turn, point to the tax account.
Examples are:
PTxxxx
for A/P (VAT only)
RTxxxx
for A/R (VAT only)
GTxxxx
for G/L (VAT only)
SOTxxx
for Sales Orders
OPTxxx and OPAxxx
for Purchase Orders
For VAT and Canadian GST, only PTxxxx, RTxxxx, and GTxxxx are valid.
For sales taxes, the A/P and A/R systems ignore the values in this field. For sales taxes, the Sales Order and Purchaser Order systems require
values in this field. For the General Accounting system, VAT journal entries require values in this field. At this time, however, the system only
uses the first G/L offset. |
mnAmtSalesTaxTaxAuth1 | STA1 | MATH_NUMERIC | OPT | NONE |
Of the total taxes calculated for this document (invoice, voucher, etc.), the dollar value of the tax liability attributable to the first of five
possible taxing authorities who may comprise the tax area. |
mnAmtSalesTaxTaxAuth2 | STA2 | MATH_NUMERIC | OPT | NONE |
Of the total taxes calculated for this document (invoice, voucher, etc.), the dollar value of the tax liability attributable to the second of five
possible taxing authorities who may comprise the tax area. |
mnAmtSalesTaxTaxAuth3 | STA3 | MATH_NUMERIC | OPT | NONE |
Of the total taxes calculated for this document (invoice, voucher, etc.), the dollar value of the tax liability attributable to the third of five
possible taxing authorities who may comprise the tax area. |
mnAmtSalesTaxTaxAuth4 | STA4 | MATH_NUMERIC | OPT | NONE |
Of the total taxes calculated for this document (invoice, voucher, etc.), the dollar value of the tax liability attributable to the fourth of five
possible taxing authorities who may comprise the tax area. |
mnAmtSalesTaxTaxAuth5 | STA5 | MATH_NUMERIC | OPT | NONE |
Of the total taxes calculated for this document (invoice, voucher, etc.), the dollar value of the tax liability attributable to the fifth of five possible
taxing authorities who may comprise the tax area. |
mnNonRecoverGST | 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.
|
mnAmtAuth1For | STA1 | MATH_NUMERIC | OPT | NONE |
Of the total taxes calculated for this document (invoice, voucher, etc.), the dollar value of the tax liability attributable to the first of five
possible taxing authorities who may comprise the tax area. |
mnAmtAuth2For | STA2 | MATH_NUMERIC | OPT | NONE |
Of the total taxes calculated for this document (invoice, voucher, etc.), the dollar value of the tax liability attributable to the second of five
possible taxing authorities who may comprise the tax area. |
mnAmtAuth3For | STA3 | MATH_NUMERIC | OPT | NONE |
Of the total taxes calculated for this document (invoice, voucher, etc.), the dollar value of the tax liability attributable to the third of five
possible taxing authorities who may comprise the tax area. |
mnAmtAuth4For | STA4 | MATH_NUMERIC | OPT | NONE |
Of the total taxes calculated for this document (invoice, voucher, etc.), the dollar value of the tax liability attributable to the fourth of five
possible taxing authorities who may comprise the tax area. |
mnAmtAuth5For | STA5 | MATH_NUMERIC | OPT | NONE |
Of the total taxes calculated for this document (invoice, voucher, etc.), the dollar value of the tax liability attributable to the fifth of five possible
taxing authorities who may comprise the tax area. |
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.
|
mnAmountTaxable | ATXA | MATH_NUMERIC | OPT | NONE |
The amount on which taxes are assessed. |
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. |
cActionCode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
mnAmtTax | 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). |