Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
szCompany | CO | char | OPT | INPUT |
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 | INPUT |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.
|
cSystemCodeFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
mnTaxRate1 | TXR1 | MATH_NUMERIC | OPT | BOTH |
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 | BOTH |
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 | BOTH |
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 | BOTH |
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 | BOTH |
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.
|
szGlClassByTaxArea1 | GL01 | char | OPT | BOTH |
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 | BOTH |
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 | BOTH |
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 | BOTH |
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 | BOTH |
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. |
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.
|