TXTAXCODE

Tax Code Maintenance

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
AR02.1 AR501 BR180 PD21.1 PD22.1 PO53.4
PO53.5 PO53.8 RQIH.1 TX00.1 TX06.2 TX06.3
TX125 TX130 TX140 TX202 TX204 TX300
TX40.1 TX40.2 TXBD.2 RQIA.1 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 API6.2 AR08.1 AR10.1 AR15.4
AR550 ARLL.1 BR00.1 BR00.2 BR02.3 BR11.1
BR120 BR121 BR122 BR123 BR140 BR151
BR152 BR156 BR16.1 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 EE52.2 EE520 DR100 IC02.1
IC10.1 IC10.2 IC11.1 IC12.1 IC130 IC140
IC141 IC142 IC145 IC243 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 MA126 MA180 MA208 MA26.1
MA278 MA279 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 MA53.1 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 PD235 PD570
PO04.1 PO04.2 PO10.1 PO10.2 PO100 PO101
PO115 PO120 PO122 PO131 PO132 PO135
PO136 PO15.1 PO15.2 PO15.4 PO150 PO17.1
PO190 PO192 PO195 PO20.1 PO20.6 PO20.9
PO204 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.2 PO22.3 PO22.4 PO22.5 PO220
PO222 PO223 PO224 PO225 PO229 PO23.1
PO230 PO233 PO234 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO251 PO253 PO254 PO26.1
PO26.2 PO26.3 PO26.4 PO26.5 PO26.6 PO26.7
PO26.9 PO27.2 PO27.3 PO27.4 PO275 PO276
PO277 PO278 PO28.2 PO280 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 PO300 PO31.1 PO31.2
PO32.1 PO32.2 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 PO529 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 RQ01.1 RQ10.1
RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ11.3
RQ11.4 RQ11.5 RQ12.1 RQ13.1 RQ13.2 RQ260
RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1 RQIC.1
RQID.1 RQIF.1 RQIG.1 RQII.1 RQIJ.1 TX02.1
TX04.1 TX100 TX101 TX804 TXI1.1 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 TX120

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 = Active
1 = Inactive
TAC-POST-OPTION
Element: All Flag
Alpha 1

I = AP Invoice Company
D = Distribution 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
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


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
Tacbod TACBOD Not Required, Delete Cascades
TAC-COMPANY->YTA-COMPANY
TAC-TAX-CODE->YTA-TAX-CODE
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 02:33:16 2016

Home
Contact Us



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