| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|
| szTaxArea | TXA1 | char | REQ | INPUT |
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. |
| jdDateForGL | DGJ | JDEDATE | REQ | 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. |
| mnItem | ITM | MATH_NUMERIC | REQ | INPUT |
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 | OUTPUT |
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 | OUTPUT |
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 | OUTPUT |
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 | OUTPUT |
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 | OUTPUT |
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.
|
| szBillCodeTaxArea1 | GL01 | char | OPT | OUTPUT |
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. |
| szBillCodeTaxArea2 | GL02 | char | OPT | OUTPUT |
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. |
| szBillCodeTaxArea3 | GL03 | char | OPT | OUTPUT |
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. |
| szBillCodeTaxArea4 | GL04 | char | OPT | OUTPUT |
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. |
| szBillCodeTaxArea5 | GL05 | char | OPT | OUTPUT |
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. |
| szDescriptionTaxArea | TAXA | char | OPT | OUTPUT |
Text that names or describes the tax rate/area. You can use this 30-character field, for example, to identify a zip code for a tax area or to
partially describe the geographic area. |
| mnTaxLevel | NBR0 | MATH_NUMERIC | OPT | OUTPUT |
Everest Parent Data Item |
| mnRoundingDifference | MATH01 | MATH_NUMERIC | OPT | OUTPUT |
- - - Good Performance Low Value.
|
| mnAmountTaxable | ATXA | MATH_NUMERIC | REQ | INPUT |
The amount on which taxes are assessed. |
| cInvalidTaxArea | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
| mnCurrencyRoundingDifference | MATH01 | MATH_NUMERIC | OPT | OUTPUT |
- - - Good Performance Low Value.
|
| mnCurrencyTaxableAmount | CTXA | MATH_NUMERIC | REQ | INPUT |
That portion of the sale that is subject to tax in foreign currency. |
| szBaseCurrency | BCRC | char | REQ | 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.
|
| szTransactionCurrency | CRCD | char | REQ | INPUT |
A code that identifies the currency of a transaction.
|
| cCurrencyMode | CRRM | char | REQ | 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.
|
| cCurrencyConversion | CRYR | char | REQ | INPUT |
A code that specifies whether to use multi-currency accounting, and the method of multi-currency accounting to use:
Codes are:
N Do not
use multi-currency accounting. Use if you enter transactions in only one currency for all companies. The multi-currency fields will not appear
on forms. The system supplies a value of N if you do not enter a value.
Y Activate multi-currency accounting and use multipliers to convert
currency. The system multiplies the foreign amount by the exchange rate to calculate the domestic amount.
Z Activate multi-currency
accounting and use divisors to convert currency. The system divides the foreign amount by the exchange rate to calculate the domestic amount. |