TXTAXCODE

Tax Code

The Tax Code file contains all tax code information. Tax codes are used in several Lawson systems to calculate tax transactions. Some examples of tax codes are VAT (Value Added Tax), GST (Goods and Services Tax), PST (Provincial Goods and Services Tax), and USE (Use Tax). Tax codes are stored with tax rate effective dates to allow individual tax codes to have multiple effective dates. Each Lawson system uses the most recent tax rate effective date defined for the tax code (compared to the transaction date, for example) to calculate tax information.

REFERENCED BY
PO53.4 PO53.5 PO53.8 TX06.2 TX06.3 TX125


UPDATED BY
AM115 AM117 AM15.1 AM15.2 AM15.3 AM15.4
AM19.1 AM19.2 AM20.1 AM20.3 AM21.1 AM21.3
AM500 AM51.1 AM551 AM97.1 AP00.3 AP00.4
AP03.3 AP10.1 AP10.2 AP10.5 AP10.6 AP110
AP115 AP125 AP126 AP131 AP150 AP170
AP180 AP181 AP190 AP193 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.6 AP20.7 AP21.1
AP210 AP220 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 AP30.2 AP30.4 AP305 AP510 AP520
AP90.1 AP91.1 AP95.1 API1.1 API2.1 API3.1
API4.1 API5.1 AR08.1 AR10.1 AR15.4 AR550
CB03.2 CB10.1 CB10.3 CB10.5 CB150 CB180
CB191 CB20.1 CB20.6 CB30.1 CB43.1 CB44.1
CB45.1 CB46.1 CB50.1 CB500 CB54.1 CB543
CB544 CB55.1 CB554 EE05.1 EE11.1 EE135
EE20.3 EE35.1 EE35.2 EE520 EX175 EX542
MX123 MX500 MA08.1 MA208 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MA540 MAED.1 MAI1.1 PO10.1
PO136 PO190 PO300 PO520 POCP.1 POED.1
POI3.1 POI7.1 POIF.1 POIG.1 POII.1 POIJ.1
POIM.1 PR05.1 PR05.3 PR226 PR247 PR26.1
PR47.1 PR514 UK47.1 RQ01.1 TX02.1 TX04.1
TX101 TX804 AR02.1 AR501 TX00.1 TX100
TX120 TX130 TX140 TX202 TX204 TX300
TX40.1 TX40.2 TX01.1 TX01.2 TX03.1 TX03.2
TX221

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TAC-COMPANY
Element: Company
Numeric 4
This field indicates the company number. You must have already defined the company in the General Ledger system.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-TAX-CODE
Element: Tax Code
Alpha 10
A user-defined code representing tax information. You define tax codes using TX01.1 (Tax Code Master).
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-TAX-ID
Element: Tax Id
Alpha 20
The company's tax identification or registration number.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-ACCRUAL-FL
Element: Accrual Fl
Alpha 1
This field indicates how the tax code will affect a taxable transaction. Invoiced taxes increase the transaction amount and accrued taxes (non-invoiced) do not affect the transaction amount.
I = Invoiced
A = Accrual
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-ALLOW-CHANGE
Element: All Flag
Alpha 1
This field indicates whether or not you can override the default general ledger accounts at tax calculation time.
Y = Yes
N = No
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-TAX-TERMS
Element: Tax Terms
Alpha 1
Indicates at what point the tax will be calculated, before or after payment terms are applied. You define terms in the Terms system.
B = Tax Before Terms
A = Tax After Terms
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-TAX-POINT
Element: Tax Point
Alpha 1
This field indicates the date at which you want the system to calculate sales tax.
I = Invoice Date
S = Shipping Date
P = Payment Date
G = GL Date
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-ACCR-CODE
Element: Ar Code
Alpha 4
A user-defined code representing an accounts payable accrual account.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-LAST-TRANS-ID
Element: Last Transaction ID
Numeric 10
This field indicates the system assigned, internal tax transaction number. It is used to keep tax transactions unique.
AP125 AP126
AP170 AP180
AP181 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
CB10.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 EE135
EE35.1 EE35.2
EE520 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MAI1.1 TX04.1
TX804
TAC-LAND-COST-FLG
Element: All Flag
Alpha 1
This field is used with the Purchase Order and Inventory Control systems. You determine whether or not the tax on an item is to be included in the item's cost.
Y = Yes
N = No
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-TOLERANCE-LMT
Element: Intl Amt
Signed 18.2
This field indicates a minimum taxable amount for the acceptable tax rate range. The tolerance limit is valid for taxable amounts greater than or equal to the amount you entered.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-TOLERANCE-AMT
Element: Intl Amt
Signed 18.2
Enter a tax tolerance amount for tolerance checking. Tolerance checking applies to verifying a tax amount (for example, the Accounts Payable system would verify a sales tax amount on an invoice that they're about to pay). If the difference between the passed tax amount and the system calculated tax amount exceeds the tax tolerance amount, then it will result in an error.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-FROM-RATE
Element: From Rate
Percent 7.4 (Percent)
If you entered a tolerance limit, this field indicates the lowest acceptable tax rate.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-THRU-RATE
Element: From Rate
Percent 7.4 (Percent)
If you entered a tolerance limit, this field indicates the highest acceptable tax rate.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-ADJUST-DISC
Element: Adjust Disc
Alpha 1
This field indicates whether or not you can change the discount amount in the Accounts Payable system.
TAC-INP-ACCT-UNIT
Element: Acct Unit
Alpha 15
The general ledger accounting unit used for input taxes. Input taxes are paid by the company through the Accounts Payable system.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-INP-ACCOUNT
Element: Account
Numeric 6
The general ledger account used for input taxes. Input taxes are paid for by the company through the Accounts Payable system.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-INP-SUB-ACCT
Element: Sub Acct
Numeric 4
The general ledger subaccount used for input taxes. Input taxes are paid for by the company through the Accounts Payable system.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-INPDU-ACT-UNIT
Element: Acct Unit
Alpha 15
The general ledger accounting unit for the input due account. This account is a temporary account to post the tax amount to when invoicing and the tax point date is set to payment date. When the company actually pays the vendor, the tax posting is moved from this account to the input accounting unit.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-INPDU-ACCOUNT
Element: Account
Numeric 6
The general ledger account for the input due account. This account is a temporary account to post the tax amount to when invoicing and the tax point date is set to payment date. When the company actually pays the vendor, the tax posting is moved from this account to the input account.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-INPDU-SUB-ACCT
Element: Sub Acct
Numeric 4
The general ledger subaccount for the input due account. This is a temporary account to post the tax amount to when invoicing and the tax point date is set to payment date. When the company actually pays the vendor, the tax posting is moved from this account to the input subaccount.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-OUT-ACCT-UNIT
Element: Acct Unit
Alpha 15
The general ledger accounting unit for output taxes. Output taxes are collected by the company through the Accounts Receivable system.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-OUT-ACCOUNT
Element: Account
Numeric 6
The general ledger account used for output taxes. Output taxes are collected by the company through the Accounts Receivable system.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-OUT-SUB-ACCT
Element: Sub Acct
Numeric 4
The general ledger subaccount used for output taxes. Output taxes are collected by the company through the Accounts Receivable system.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-OUTDU-ACT-UNIT
Element: Acct Unit
Alpha 15
The general ledger accounting unit for the output due account. This is a temporary account to post the tax amount to when invoicing and the tax point date is set to payment date. When the customer actually pays the invoice, the tax posting is moved from this account to the output accounting unit.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-OUTDU-ACCOUNT
Element: Account
Numeric 6
The general ledger account for the output due account. This account is a temporary account to post the tax amount to when invoicing and the tax point date is set to payment date. When the customer actually pays the invoice, the tax posting is moved from this account to the output account.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-OUTDU-SUB-ACCT
Element: Sub Acct
Numeric 4
The general ledger subaccount for the output due account. This account is a temporary account to post the tax amount to when invoicing and the tax point date is set to payment date. When the customer actually pays the invoice, the tax posting is moved from this account to the output subaccount.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-TAX-NAME
Element: Tax Name
Derived
This field contains the tax code name.
TAC-GDS-SVCS-IND
Element: Gds Svcs Ind
Alpha 1
Goods and services indicator.
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-VAT-TYPE
Element: Vat Type
Alpha 1
Specifies the type of transaction the tax code is used for.
D = Domestic
E = Intra-EC
I = Import
X = Export
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-TRNGL-IND
Element: Trngl Ind
Alpha 1
Triangulation indicator
Y = Yes
N = No
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
API3.1 API4.1
TAC-STATUS
Element: Status
Numeric 1

0 = Inactive
1 = Active


TXTAXCODE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TACSET1 COMPANY
TAX-CODE
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
TACSET2 TAX-CODE
COMPANY
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170


TXTAXCODE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Glsystem GLSYSTEM Required
TAC-COMPANY->GLS-COMPANY
Input Account GLMASTER Required
When TAC-INP-ACCT-UNIT !=Spaces
OrTAC-INP-ACCOUNT !=Zeroes
OrTAC-INP-SUB-ACCT !=Zeroes
TAC-COMPANY->GLM-COMPANY
TAC-INP-ACCT-UNIT->GLM-ACCT-UNIT
TAC-INPDU-ACCOUNT->GLM-ACCOUNT
TAC-INPDU-SUB-ACCT->GLM-SUB-ACCOUNT
Input Due Acct GLMASTER Required
When TAC-INPDU-ACT-UNIT !=Spaces
OrTAC-INPDU-ACCOUNT !=Zeroes
OrTAC-INPDU-SUB-ACCT !=Zeroes
TAC-COMPANY->GLM-COMPANY
TAC-INPDU-ACT-UNIT->GLM-ACCT-UNIT
TAC-INPDU-ACCOUNT->GLM-ACCOUNT
TAC-INPDU-SUB-ACCT->GLM-SUB-ACCOUNT
Outpt Due Acct GLMASTER Required
When (TAC-OUTDU-ACT-UNIT !=Spaces )
Or(TAC-OUTDU-ACCOUNT !=Zeroes )
Or(TAC-OUTDU-SUB-ACCT !=Zeroes )
TAC-COMPANY->GLM-COMPANY
TAC-OUTDU-ACT-UNIT->GLM-ACCT-UNIT
TAC-OUTDU-ACCOUNT->GLM-ACCOUNT
TAC-OUTDU-SUB-ACCT->GLM-SUB-ACCOUNT
Output Account GLMASTER Required
When TAC-OUT-ACCT-UNIT !=Spaces
OrTAC-OUT-ACCOUNT !=Zeroes
OrTAC-OUT-SUB-ACCT !=Zeroes
TAC-COMPANY->GLM-COMPANY
TAC-OUT-ACCT-UNIT->GLM-ACCT-UNIT
TAC-OUT-ACCOUNT->GLM-ACCOUNT
TAC-OUT-SUB-ACCT->GLM-SUB-ACCOUNT
Txcodemast TXCODEMAST Required
TAC-TAX-CODE->TCM-TAX-CODE
Txcompany TXCOMPANY Required
TAC-COMPANY->TXC-COMPANY


TXTAXCODE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Txtaxrate TXTAXRATE
Valid When TCM-TAX-TYPE ="S"
OrTCM-TAX-TYPE ="M"
TAC-TAX-CODE->TXR-TAX-CODE
  TXR-PROD-TAX-CAT
  TXR-EFFECT-DATE
Txtaxtran TXTAXTRAN
TAC-COMPANY->TXD-COMPANY
TAC-TAX-CODE->TXD-TAX-CODE
  TXD-SYSTEM-CD
  TXD-TAX-PNT-DATE
  TXD-VOUCHER-NBR
  TXD-TRANS-IDENT


File created: Wed Jun 08 20:51:47 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.