Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
szExr1 | 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. |
szTxa1 | 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. |
cRp2 | RP2 | char | OPT | NONE |
A flag that internal processing uses for the A/P and A/R detail files. If this field is blank, the Post program will create the offsetting entries for
tax in the General Ledger Detail file (F0911) and write to the Tax file (F0018).
The Order Processing and Distribution systems put a 1 in this field
as they write the offsetting entries for tax and write to the Tax File.
If there is a 1 in this field, the Invoice and Voucher Entry programs require
manual changes to the tax amount information. They will not automatically calculate the information. Any changes to tax amounts in these
programs will not be carried to the Tax file when this code is a 1. |
mnIcu | 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. |
szIcut | ICUT | char | OPT | NONE |
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. |
szKco | 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. |
mnDoc | 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. |
szDct | 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
|
szSfx | 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. |
mnSfxe | 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. |
cCrrm | 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.
|
mnAtxa | ATXA | MATH_NUMERIC | OPT | NONE |
The amount on which taxes are assessed. |
mnAtxn | ATXN | MATH_NUMERIC | OPT | NONE |
The amount upon which taxes are not assessed. This is the portion of the transaction not subject to sales, use, or VAT taxes because the
products are tax-exempt or zero-rated. |
mnCtxa | CTXA | MATH_NUMERIC | OPT | NONE |
That portion of the sale that is subject to tax in foreign currency. |
mnCtxn | CTXN | MATH_NUMERIC | OPT | NONE |
The foreign amount associated with this document which is not subject to sales, use or value-added tax due to the nature of the transaction
and not due to the nature of the parties to the transaction (as in tax exemption). |
mnAn8 | 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.
|
szCo | 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.
|
jdDsvj | DSVJ | JDEDATE | OPT | NONE |
A date that indicates when you purchased goods or services, or when you incurred a tax liability.
|
jdDgj | 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. |
mnRu | RU | MATH_NUMERIC | OPT | NONE |
A value expressed is units, dollars, floor space, etc., that is used for calculation of capacity. |
szMcu | MCU | char | OPT | NONE |
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.
|
mnCtam | CTAM | MATH_NUMERIC | OPT | NONE |
The tax amount in foreign currency. This can be the sales, use, or VAT tax.
|
mnStam | 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). |
mnItm | 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 |
mnFnrt | FNRT | MATH_NUMERIC | OPT | NONE |
The portion of the foreign tax amount for which you cannot take a credit.
|
mnNrta | NRTA | MATH_NUMERIC | OPT | NONE |
The portion of the tax amount for which you cannot take a credit. |
mnAcr | ACR | MATH_NUMERIC | OPT | 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. |
szCrcd | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction.
|
mnLnid | LNID | MATH_NUMERIC | OPT | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
this number,but in some cases you can override it. |
mnCrr | CRR | MATH_NUMERIC | OPT | NONE |
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.
|
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.
|
mnTime | TME0 | MATH_NUMERIC | OPT | NONE |
Everest Parent Data Item |
jdDate | DTE | JDEDATE | OPT | NONE |
You can enter a date with or without slashes (/) or dashes (-) as separators.
If you leave a date entry field blank, the system supplies the
current date. |
mnGAg | 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.
|
mnGAcr | ACR | MATH_NUMERIC | OPT | 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. |
szGGlc | 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.
|
szGMmco | MMCO | char | OPT | NONE |
A code to designate a specific company, fund, entity, partnership, etc. This code is verified in the Company Constants File (F0010). This
field will be right justified automatically. Therefore, company 1 would be entered as 1 and right justified and stored as 00001. It will, however, be
displayed with leading blanks as ' 1' except when it is the key to the file. Even though a '00000' company is allowed to be set up in the
Company Constants File, it is not a valid entry for any transaction processing. Company '00000' is used for default coding only. |
cGAm | AM | char | OPT | NONE |
A code that indicates which of the three general ledger account numbers is being used for data entry. Valid codes are:
1 The short
account ID number
2 The standard long account number
3 The long (unstructured, 24-byte) account number
7 The first character of the
account number indicates the format of the account number You can also define special characters in the Accounting Constants file (F0009) to
facilitate data entry. For example:
/ For the unstructured account number
* For the short account ID number
blank For the business
unit.object.subsidiary number For example, if the account mode is 7 and the first character of the account number is *, the account number was
entered as the short account ID number. |
szGAid | AID | char | OPT | NONE |
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it.
|
szGAni | ANI | char | OPT | NONE |
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.
|
szGMcu | MCU | char | OPT | NONE |
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.
|
szGObj | OBJ | char | OPT | NONE |
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. |
szGSub | SUB | char | OPT | NONE |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.
|
szGCo | 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.
|
mnDomesticTaxAmount | 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). |
mnForeignTaxAmount | 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). |
mnForeignGross | 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.
|
mnForeignTaxableAmount | ATXA | MATH_NUMERIC | OPT | NONE |
The amount on which taxes are assessed. |
mnDomesticTaxableAmount | ATXA | MATH_NUMERIC | OPT | NONE |
The amount on which taxes are assessed. |
mnDomesticGross | 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.
|
mnDomesticTaxExempt | TAXE | MATH_NUMERIC | OPT | NONE |
The dollar amount associated with this document which is not subject to sales,use or value-added tax. This is due to the nature of the
parties to the transaction and not due to the nature of the transaction itself (as in a non-taxable item). |
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. |
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.
|
szVersion | 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. |
szFormId | FID | char | OPT | NONE |
The Form ID refers to the report (R), form (V), or table number (F). |
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 |
szCallingEvent | EVDEFNM | char | OPT | NONE |
|
cProcessControl | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
cFlag | EV01 | char | OPT | BOTH |
An option that specifies the type of processing for an event.
|
cVertexActive | 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.
|
mnJobnumber | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. |
cAutoOffMode | OFFP | char | OPT | NONE |
A code that specifies how the system generates the offset entry (document type AE) in the Account Ledger table (F0911) when vouchers,
payments, and drafts are posted to the general ledger. Valid values are:
B
The system creates one offset for each batch of transactions by
account.
Y
The system creates one offset for each transaction by account.
S
The system creates one offset for each pay item by account.
The
system creates offsets for the actual amount (AA) and foreign currency (CA) ledger types only.
|
cIntercompanySettlements | ICO | char | OPT | NONE |
A code that specifies the method that the system uses to automatically create journal entries between companies within an organization
(intercompany settlements).
Valid values are:
1
Hub Method. Create intercompany settlements using a hub company.
2
Detail Method. Create
intercompany settlements without a hub company. Valid for multicurrency processing.
3
Configured Hub Method. Create intercompany
settlements using a configured hub. Valid for multicurrency processing.
N
No, do not create intercompany settlements. The system does not post the
batch if it contains intercompany settlements.
*
No, do not create intercompany settlements. The system posts the batch even if it contains
intercompany settlements.
|
cTaxFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
szIntercompanyCacheName | AA11 | char | OPT | NONE |
This item is used scrub Specification Data fields that are 11 character alpha fields. |
cMultiCurrencyIntercompanyJE | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
cCurrencyConverYNAR | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
szOffsetByDocument | EXA | char | OPT | NONE |
A description, remark, explanation, name, or address. |
szVinv | VINV | char | OPT | NONE |
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).
|
mnPn | PN | MATH_NUMERIC | OPT | NONE |
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.
|
mnFy | FY | MATH_NUMERIC | OPT | NONE |
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. |
mnCtry | CTRY | MATH_NUMERIC | OPT | NONE |
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.
|
szPo | PO | char | OPT | NONE |
A document that authorizes the delivery of specified merchandise or the rendering of certain services.
|
szRmk | RMK | char | OPT | NONE |
A generic field that you use for a remark, description, name, or address.
|
szSbl | SBL | char | OPT | NONE |
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
address book number. If you enter a subledger, you must also specify the subledger type. |
cSblt | SBLT | char | OPT | NONE |
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
editing. On the User Defined Codes form, the second line of the description controls how the system performs editing. This is either hard-coded
or user defined. Valid values include:
A
Alphanumeric field, do not edit
N
Numeric field, right justify and zero fill
C
Alphanumeric field, right
justify and blank fill
|
jdDicj | DICJ | JDEDATE | OPT | NONE |
The date of the batch. If you leave this field blank, the system date is used. |
jdHdgj | HDGJ | JDEDATE | OPT | NONE |
This is a historical date which is used when processing Dual Currency. This date is used to retrieve rates from the Daily Transaction File
(F0015) instead of the general ledger date of the transaction. Transactions that carry an historical date include voids of vouchers, invoices, or
payments. |
szBcrc | BCRC | char | OPT | NONE |
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.
|
mnHcrr | HCRR | MATH_NUMERIC | OPT | NONE |
The exchange rate entered for a journal entry. During multiple currency processing, the system uses this rate for the associated journal
entry instead of the rate in the Currency Exchange Rates table (F0015). This rate can be the average or historical rate. |