| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|
| szTaxarea1 | TXA1 | char | NONE | 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. |
| jdDateservicecurrency | DSVJ | JDEDATE | NONE | NONE |
A date that indicates when you purchased goods or services, or when you incurred a tax liability.
|
| mnIdentifiershortitem | ITM | MATH_NUMERIC | NONE | 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 | NONE | 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 | NONE | 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 | NONE | 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 | NONE | 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 | NONE | 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 | NONE | 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 | NONE | 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 | NONE | 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 | NONE | 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 | NONE | 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 | NONE | 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 | NONE | 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 | NONE | 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 | NONE | 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 | NONE | 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. |
| mnAmtAuth1 | STAM | MATH_NUMERIC | NONE | NONE |
The amount assessed and payable to tax authorities. It is the total of the VAT, use, and sales taxes (PST). |
| mnAmtAuth2 | STAM | MATH_NUMERIC | NONE | NONE |
The amount assessed and payable to tax authorities. It is the total of the VAT, use, and sales taxes (PST). |
| mnAmtAuth3 | STAM | MATH_NUMERIC | NONE | NONE |
The amount assessed and payable to tax authorities. It is the total of the VAT, use, and sales taxes (PST). |
| mnAmtAuth4 | STAM | MATH_NUMERIC | NONE | NONE |
The amount assessed and payable to tax authorities. It is the total of the VAT, use, and sales taxes (PST). |
| mnAmtAuth5 | STAM | MATH_NUMERIC | NONE | NONE |
The amount assessed and payable to tax authorities. It is the total of the VAT, use, and sales taxes (PST). |
| mnNonRecoverGST | 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.
|
| mnTaxAmt | STAM | MATH_NUMERIC | NONE | NONE |
The amount assessed and payable to tax authorities. It is the total of the VAT, use, and sales taxes (PST). |
| mnTaxableAmt | ATXA | MATH_NUMERIC | NONE | NONE |
The amount on which taxes are assessed. |
| szTaxexemptreason | EXR1 | char | NONE | 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. |
| cTaxcalcmethod | TC2 | char | NONE | NONE |
An option that is used in Canada to specify whether to calculate PST tax after GST has been added to the product value. Valid settings
are:
On
The system calculates PST tax after GST has been added to the product value.
Off
The system calculates the PST before GST has been
added to the product value.
For example, suppose that you have a tax area set up with 7% GST and 8% PST, and you turn on the option to
calculate tax on tax. If you enter a voucher for a taxable amount of 1000 CAD, the system calculates the GST as 70 CAD, adds it to the taxable
amount, and multiplies the PST by that result (1070 CAD). If you do not use compound taxes, the system calculates PST on the taxable
amount only.
Note: This option is valid only for tax explanation codes that begin with the letters B and C. To calculate compound taxes for tax
explanation code V, use tax explanation code V+.
|
| cVATRecoverableFlag3 | TT3 | char | NONE | NONE |
An option that indicates the percent of VAT that is not recoverable. You enter the nonrecoverable percentage in the Tax Rate field to the left
of this option. Valid settings are:
On
Not recoverable. The system multiplies the percentage that you specify by the total tax amount and
reduces the amount of VAT that is recoverable from the first tax authority.
Off
Recoverable. All of the VAT tax is recoverable.
Note: This option is
valid only with tax explanation codes that begin with the letters C, B, and V.
|
| cVATRecoverableFlag4 | TT4 | char | NONE | NONE |
An option that indicates the percent of VAT that is not recoverable. You enter the nonrecoverable percentage in the Tax Rate field to the left
of this option. Valid settings are:
On
Not recoverable. The system multiplies the percentage that you specify by the total tax amount and
reduces the amount of VAT that is recoverable from the first tax authority.
Off
Recoverable. All of the VAT tax is recoverable.
Note: This option is
valid only with tax explanation codes that begin with the letters C, B, and V.
|
| cVATRecoverableFlag5 | TT5 | char | NONE | NONE |
An option that indicates the percent of VAT that is not recoverable. You enter the nonrecoverable percentage in the Tax Rate field to the left
of this option. Valid settings are:
On
Not recoverable. The system multiplies the percentage that you specify by the total tax amount and
reduces the amount of VAT that is recoverable from the first tax authority.
Off
Recoverable. All of the VAT tax is recoverable.
Note: This option is
valid only with tax explanation codes that begin with the letters C, B, and V.
|
| szDescriptiontaxarea | TAXA | char | NONE | NONE |
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. |
| cFactorvaluetype | FVTY | char | NONE | NONE |
A code that indicates whether the factor value is a multiplier (%) or an additional/deductible cash amount ($) when applied to an order's
price. |
| cSystemCodeFlag | TXSY | char | OPT | NONE |
An option that specifies the system to which the tax rules apply. The system allows you to select one option only.
|
| 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.
|
| 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.
|