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
MA278 PO53.4 PO53.5 PO53.8 PO99.9 AR02.1
TX06.2 TX06.3 TX100 TX120 TX125 TX130
TX202 TX204 TX300 TX01.1 TX01.2 TX03.1
TX03.2 TX221


UPDATED BY
AC160 AC56.1 AC560 AM115 AM117 AM15.1
AM15.2 AM15.3 AM15.4 AM19.1 AM19.2 AM20.1
AM20.3 AM21.1 AM21.3 AM22.1 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 AP271
AP30.2 AP30.4 AP300 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 AR501
AR550 ARLL.1 BR00.1 BR00.2 BR02.3 BR11.1
BR120 BR121 BR122 BR123 BR140 BR151
BR152 BR156 BR16.1 BR180 BR20.1 BR20.2
BR20.3 BR20.4 BR20.5 BR20.6 BR420 BR46.1
BR46.2 BR46.4 BR48.1 BR521 BRIP.1 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 CX05.1 CX05.2 CX100 CX20.1
CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300
CX506 CX805 CXCP.1 EE05.1 EE11.1 EE135
EE20.3 EE35.1 EE35.2 EE520 DR100 IC02.1
IC10.1 IC10.2 IC11.1 IC12.1 IC130 IC140
IC141 IC142 IC330 IC64.1 IC64.2 IC64.3
IC64.4 IC64.5 IC64.6 IC64.7 IC64.8 IC64.9
IC66.1 IC802 IC81.1 IC811 IC812 IC83.1
IC840 EX175 EX542 MX123 MX500 MA08.1
MA180 MA208 MA26.1 MA279 MA310 MA41.1
MA41.2 MA41.4 MA41.7 MA42.1 MA42.2 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MA44.1
MA44.2 MA530 MA531 MA540 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA64.9 MA65.1 MA66.2
MA66.3 MA67.2 MA67.3 MA68.2 MA68.3 MA68.5
MA69.1 MA70.1 MA75.1 MA80.1 MAED.1 MAI1.1
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PD21.1 PD22.1 PD235 PO10.1 PO100 PO101
PO120 PO122 PO131 PO132 PO135 PO136
PO150 PO190 PO20.1 PO20.6 PO20.9 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.2
PO22.3 PO22.4 PO22.5 PO220 PO223 PO229
PO23.1 PO233 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO253 PO254 PO26.1 PO26.2 PO26.3
PO26.4 PO26.5 PO26.6 PO26.7 PO26.9 PO27.1
PO27.2 PO278 PO28.2 PO29.1 PO30.1 PO30.2
PO30.3 PO30.4 PO300 PO31.1 PO31.2 PO32.1
PO32.2 PO32.3 PO32.4 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 PO54.1 PO54.2
PO54.3 PO54.4 PO54.5 POCP.1 POED.1 POI3.1
POI7.1 POID.1 POIF.1 POIG.1 POII.1 POIJ.1
POIM.1 POIT.1 PR05.1 PR05.3 PR226 PR247
PR26.1 PR47.1 PR514 UK47.1 RQ01.1 RQ10.1
RQ10.2 RQ10.3 RQ10.4 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ260 RQ35.1 RQ500 RQIA.1 RQIB.1
RQIC.1 RQID.1 RQIF.1 RQIG.1 RQIH.1 RQII.1
RQIJ.1 TX00.1 TX02.1 TX04.1 TX101 TX140
TX40.1 TX40.2 TX804 WH130 WH132 WH190
WH20.2 WH20.7 WH222 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 WH32.5 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2
WH520 WH830 ZW130

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.
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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).
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TAC-TAX-ID
Element: Tax Id
Alpha 20
The company's tax identification or registration number.
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TAC-ACCR-CODE
Element: Ar Code
Alpha 4
A user-defined code representing an accounts payable accrual account.
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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
ARLL.1 BRIP.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 MA42.2
MA43.1 MA43.2
MA44.1 MA44.2
MA61.1 MA64.9
MA66.2 MA66.3
MA70.1 MA75.1
MAI1.1 TX04.1
TX804 WH20.7
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
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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.
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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.
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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.
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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.
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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.
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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.
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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.
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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.
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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.
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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.
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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.
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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.
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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.
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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.
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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.
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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.
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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.
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TAC-TRNGL-IND
Element: Trngl Ind
Alpha 1
Triangulation indicator
Y = Yes
N = No
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.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
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
TACSET2 TAX-CODE
COMPANY
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125


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: Thu Jun 09 11:29:32 2016

Home
Contact Us



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