TXTAXCODE FILE
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
AR501 BL00.1 BL01.1 BL121 BL290 BL80.1
BL96E TX00.1 TX06.2 TX06.3 TX100 TX120
TX125 TX130 TX140 TX202 TX204 TX206
TX225 TX300 TX40.1 TX40.2 BL202 TX01.1
TX01.2 TX03.1 TX03.2
UPDATED BY
AC15.1 AP00.3 AP10.1 AP10.2 AP10.5 AP10.6
AP110 AP125 AP126 AP170 AP180 AP181
AP190 AP193 AP20.1 AP20.2 AP20.5 AP20.6
AP20.7 AP225 AP226 AP23.1 AP25.1 AP25.2
AP26.1 AP30.2 AP30.4 AP32.2 AP510 AP520
AR08.1 AR10.1 AR115 AR124 AR15.4 AR190
AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2
AR30.1 AR30.2 AR30.4 AR42.1 AR42.2 AR42.7
AR43.1 AR550 AR560 AR570 AR575 AR580
AR82.1 BL02.1 BL08.1 BL09.1 BL120 BL122
BL123 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL802 BL820 BL902
BL92.1 BL940 CB03.2 CB10.1 CB10.3 CB180
CB191 CB20.1 CB30.1 CB500 CX05.1 CX05.2
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CX805 CXCP.1 DT180
DT181 EE05.3 EE135 EE20.3 EE35.1 EE35.2
EE520 DR100 IC02.1 IC10.1 IC10.2 IC11.1
IC12.1 IC141 IC142 IC811 IC812 IC83.1
IN20.1 MA08.1 MA140 MA208 MA40.1 MA40.2
MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1
MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540
OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6
OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9
OE110 OE112 OE113 OE114 OE129 OE14.1
OE14.2 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4
OE15.5 OE15.7 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE80.1
OE80.2 OE80.3 OE80.4 OE80.5 OE810 OE830
OE920 OE950 PBIP.1 PO100 PO120 PO121
PO122 PO123 PO132 PO20.1 PO21.1 PO21.2
PO21.5 PO21.6 PO22.1 PO22.2 PO22.3 PO220
PO225 PO25.1 PO25.3 PO25.4 PO25.7 PO28.3
PO28.8 PO31.1 PO820 PO821 RQ10.1 RQ10.3
RQ11.1 RQ20.1 RQ20.3 RQ20.4 RQ35.1 RQ500
TX02.1 TX04.1 TX804 TX904 TX954 TX955
TX956 WH130 WH132 WH190 WH20.2 WH20.7
WH222 WH30.1 WH30.2 WH30.3 WH31.1 WH31.2
WH31.3 WH32.1 WH32.2 WH32.3 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 WO132 WO140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TAC-COMPANY Numeric 4 AC15.1 AP00.3
Company This field indicates the company AP10.1 AP10.2
number. You must have already defined AP10.5 AP10.6
the company in the General Ledger AP110 AP125
system. AP126 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-TAX-CODE Alpha 10 AC15.1 AP00.3
Tax Code A user-defined code representing tax AP10.1 AP10.2
information. You define tax codes using AP10.5 AP10.6
TX01.1 (Tax Code Master). AP110 AP125
AP126 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-TAX-ID Alpha 20 AC15.1 AP00.3
Tax ID The company's tax identification or AP10.1 AP10.2
registration number. AP10.5 AP10.6
AP110 AP125
AP126 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-ACCRUAL-FL Alpha 1 AC15.1 AP00.3
Accrual Flag This field indicates how the tax code AP10.1 AP10.2
will affect a taxable transaction. AP10.5 AP10.6
Invoiced taxes increase the transaction AP110 AP125
amount and accrued taxes (noninvoiced) AP126 AP170
do not affect the transaction amount. AP180 AP181
I = Invoiced AP190 AP20.1
A = Accrued AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-ALLOW-CHANGE Alpha 1 AC15.1 AP00.3
Allow Change This field indicates whether or not you AP10.1 AP10.2
can override the default general ledger AP10.5 AP10.6
accounts at tax calculation time. AP110 AP125
Y = Yes AP126 AP170
N = No AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-TAX-TERMS Alpha 1 AC15.1 AP00.3
Tax Terms Indicates at what point the tax will be AP10.1 AP10.2
calculated, before or after payment AP10.5 AP10.6
terms are applied. You define terms in AP110 AP125
the Terms system. AP126 AP170
B = Tax Before Terms AP180 AP181
A = Tax After Terms AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-TAX-POINT Alpha 1 AC15.1 AP00.3
Tax Point This field indicates the date at which AP10.1 AP10.2
you want the system to calculate sales AP10.5 AP10.6
tax. AP110 AP125
I = Invoice Date AP126 AP170
S = Shipping Date AP180 AP181
P = Payment Date AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-ACCR-CODE Alpha 4 AC15.1 AP00.3
Accrual Code A user-defined code representing an AP10.1 AP10.2
accounts payable accrual account. AP10.5 AP10.6
AP110 AP125
AP126 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-LAST-TRANS-ID Numeric 10 AP125 AP126
Last Transaction ID This field indicates the system AP170 AP180
assigned, internal tax transaction AP181 AP190
number. It is used to keep tax AP193 AP25.1
transactions unique. AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 AP520
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX954
TX955
TAC-LAND-COST-FLG Alpha 1 AC15.1 AP00.3
Landing Cost Flag This field is used with the Purchase AP10.1 AP10.2
Order and Inventory Control systems. You AP10.5 AP10.6
determine whether or not the tax on an AP110 AP125
item is to be included in the item's AP126 AP170
cost. AP180 AP181
Y = Yes AP190 AP20.1
N = No AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-TOLERANCE-LMT Signed 13.2 AC15.1 AP00.3
Tolerance Lmt This field indicates a minimum taxable AP10.1 AP10.2
amount for the acceptable tax rate AP10.5 AP10.6
range. The tolerance limit is valid for AP110 AP125
taxable amounts greater than or equal to AP126 AP170
the amount you entered. AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-FROM-RATE Percent 7.4 (Percent) AC15.1 AP00.3
From Rate If you entered a tolerance limit, this AP10.1 AP10.2
field indicates the lowest acceptable AP10.5 AP10.6
tax rate. AP110 AP125
AP126 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-THRU-RATE Percent 7.4 (Percent) AC15.1 AP00.3
Thru Rate If you entered a tolerance limit, this AP10.1 AP10.2
field indicates the highest acceptable AP10.5 AP10.6
tax rate. AP110 AP125
AP126 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-ADJUST-DISC Alpha 1 TX954 TX955
Adjust Disc This field indicates whether or not you TX956
can change the discount amount in the
Accounts Payable system.
TAC-INP-ACCT-UNIT Alpha 15 AC15.1 AP00.3
Input Acct Unit The general ledger accounting unit used AP10.1 AP10.2
From Tax Code for input taxes. Input taxes are paid AP10.5 AP10.6
by the company through the Accounts AP110 AP125
Payable system. AP126 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-INP-ACCOUNT Numeric 6 AC15.1 AP00.3
Input Account From The general ledger account used for AP10.1 AP10.2
Tax Code input taxes. Input taxes are paid for AP10.5 AP10.6
by the company through the Accounts AP110 AP125
Payable system. AP126 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-INP-SUB-ACCT Numeric 4 AC15.1 AP00.3
Input Subacct From The general ledger subaccount used for AP10.1 AP10.2
Tax Code input taxes. Input taxes are paid for AP10.5 AP10.6
by the company through the Accounts AP110 AP125
Payable system. AP126 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-INPDU-ACT-UNIT Alpha 15 AC15.1 AP00.3
Inpdu Act Unit The general ledger accounting unit for AP10.1 AP10.2
the input due account. This account is AP10.5 AP10.6
a temporary account to post the tax AP110 AP125
amount to when invoicing and the tax AP126 AP170
point date is set to payment date. When AP180 AP181
the company actually pays the vendor, AP190 AP20.1
the tax posting is moved from this AP20.2 AP20.5
account to the input accounting unit. AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-INPDU-ACCOUNT Numeric 6 AC15.1 AP00.3
Inpdu Account The general ledger account for the AP10.1 AP10.2
input due account. This account is a AP10.5 AP10.6
temporary account to post the tax amount AP110 AP125
to when invoicing and the tax point date AP126 AP170
is set to payment date. When the company AP180 AP181
actually pays the vendor, the tax AP190 AP20.1
posting is moved from this account to AP20.2 AP20.5
the input account. AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-INPDU-SUB-ACCT Numeric 4 AC15.1 AP00.3
Inpdu Sub Acct The general ledger subaccount for the AP10.1 AP10.2
input due account. This is a temporary AP10.5 AP10.6
account to post the tax amount to when AP110 AP125
invoicing and the tax point date is set AP126 AP170
to payment date. When the company AP180 AP181
actually pays the vendor, the tax AP190 AP20.1
posting is moved from this account to AP20.2 AP20.5
the input subaccount. AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-OUT-ACCT-UNIT Alpha 15 AC15.1 AP00.3
Output Acct Unit The general ledger accounting unit for AP10.1 AP10.2
From Tax Code output taxes. Output taxes are AP10.5 AP10.6
collected by the company through the AP110 AP125
Accounts Receivable system. AP126 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-OUT-ACCOUNT Numeric 6 AC15.1 AP00.3
Output Account From The general ledger account used for AP10.1 AP10.2
Tax Code output taxes. Output taxes are AP10.5 AP10.6
collected by the company through the AP110 AP125
Accounts Receivable system. AP126 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-OUT-SUB-ACCT Numeric 4 AC15.1 AP00.3
Output Subacct From The general ledger subaccount used for AP10.1 AP10.2
Tax Code output taxes. Output taxes are AP10.5 AP10.6
collected by the company through the AP110 AP125
Accounts Receivable system. AP126 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-OUTDU-ACT-UNIT Alpha 15 AC15.1 AP00.3
Outdu Act Unit The general ledger accounting unit for AP10.1 AP10.2
the output due account. This is a AP10.5 AP10.6
temporary account to post the tax amount AP110 AP125
to when invoicing and the tax point date AP126 AP170
is set to payment date. When the AP180 AP181
customer actually pays the invoice, the AP190 AP20.1
tax posting is moved from this account AP20.2 AP20.5
to the output accounting unit. AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-OUTDU-ACCOUNT Numeric 6 AC15.1 AP00.3
Outdu Account The general ledger account for the AP10.1 AP10.2
output due account. This account is a AP10.5 AP10.6
temporary account to post the tax amount AP110 AP125
to when invoicing and the tax point date AP126 AP170
is set to payment date. When the AP180 AP181
customer actually pays the invoice, the AP190 AP20.1
tax posting is moved from this account AP20.2 AP20.5
to the output account. AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-OUTDU-SUB-ACCT Numeric 4 AC15.1 AP00.3
Outdu Sub Acct The general ledger subaccount for the AP10.1 AP10.2
output due account. This account is a AP10.5 AP10.6
temporary account to post the tax amount AP110 AP125
to when invoicing and the tax point date AP126 AP170
is set to payment date. When the AP180 AP181
customer actually pays the invoice, the AP190 AP20.1
tax posting is moved from this account AP20.2 AP20.5
to the output subaccount. AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-TAX-NAME Derived
Tax Name This field contains the tax code name.
TAC-GDS-SVCS-IND Alpha 1 AC15.1 AP00.3
Gds Svcs Ind Indicates whether the Tax Code is used AP10.1 AP10.2
for Goods, Services or both Goods and AP10.5 AP10.6
Services. AP110 AP125
G = Goods AP126 AP170
S = Services AP180 AP181
B = Both AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-VAT-TYPE Alpha 1 AC15.1 AP00.3
Vat Type Specifies the type of transaction the AP10.1 AP10.2
Tax Code is used for: AP10.5 AP10.6
D = Domestic AP110 AP125
E = Within EC AP126 AP170
I = Import AP180 AP181
X = Export AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TAC-TRNGL-IND Alpha 1 AC15.1 AP00.3
Trngl Ind Triangulation Indicator - Indicates AP10.1 AP10.2
whether the transaction on which the Tax AP10.5 AP10.6
Code is entered involves a triangulation AP110 AP125
transaction (more than two parties AP126 AP170
involved). AP180 AP181
Y = Yes AP190 AP20.1
N = No AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL122
BL123 BL130
...
TXTAXCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TACSET1 COMPANY This index is used to validate a tax AC15.1 AP00.3
TAX-CODE code for a specific company. AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP125
AP126 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
...
TACSET2 TAX-CODE This index is used to locate a tax code AC15.1 AP00.3
COMPANY for a vendor or customer. AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP125
AP126 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
...
TXTAXCODE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glsystem GLSYSTEM Required
TAC-COMPANY -> GLS-COMPANY
Input Account GLMASTER Required
When TAC-INP-ACCT-UNIT != Spaces
Or TAC-INP-ACCOUNT != Zeroes
Or TAC-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
Or TAC-INPDU-ACCOUNT != Zeroes
Or TAC-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
Or TAC-OUT-ACCOUNT != Zeroes
Or TAC-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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Txtaxrate TXTAXRATE
Valid When TAC-TAX-TYPE = "S"
Or TAC-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
|