 |
Lawson Insight Technical Documentation |
|
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
AP220 AR501 AR82.1 PO120 PO150 PO190
TX00.1 TX06.2 TX06.3 TX100 TX120 TX125
TX130 TX140 TX202 TX204 TX300 TX40.1
TX40.2 AC57.1 TX01.1 TX01.2 TX03.1 TX03.2
TX221
UPDATED BY
AP00.3 AP10.1 AP10.2 AP10.5 AP10.6 AP110
AP125 AP126 AP131 AP170 AP180 AP181
AP190 AP193 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.6 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.2 AP30.4 AP32.2 AP510
AP520 API1.1 API2.1 API3.1 API4.1 API5.1
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
BR00.2 BR11.1 BR120 BR121 BR420 BRIP.1
CB03.2 CB10.1 CB10.3 CB180 CB191 CB20.1
CB30.1 CB500 CXCP.1 DT180 DT181 EE05.1
EE135 EE20.3 EE35.1 EE35.2 EE520 DR100
IC02.1 IC10.1 IC10.2 IC11.1 IC12.1 IC141
IC142 IC28.1 IC330 IC811 IC812 IC83.1
IC840 MA08.1 MA180 MA208 MA41.1 MA41.2
MA41.4 MA43.1 MA43.2 MA43.3 MA43.4 MA43.5
MA43.7 MA43.8 MA43.9 MA530 MA531 MA540
MA60.2 MA60.3 MA60.5 MA61.1 MA65.1 MA66.2
MA66.3 MA67.1 MA67.2 MA70.1 MAI1.1 PBIP.1
PO100 PO101 PO122 PO131 PO132 PO20.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO220
PO23.1 PO25.2 PO25.6 PO25.7 PO25.8 PO27.3
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO33.1 PO34.1 PO35.1 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO54.4 POED.1 POI3.1 POI7.1 POIE.1 POIF.1
POIG.1 POII.1 POIJ.1 POIT.1 PR197 RQ10.1
RQ10.2 RQ10.3 RQ11.1 RQ35.1 RQ500 RQIB.1
RQIC.1 RQIF.1 RQIG.1 TX02.1 TX04.1 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
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TAC-COMPANY Numeric 4 AP00.3 AP10.1
Company This field indicates the company AP10.2 AP10.5
number. You must have already defined AP10.6 AP110
the company in the General Ledger AP125 AP126
system. AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-TAX-CODE Alpha 10 AP00.3 AP10.1
Tax Code A user-defined code representing tax AP10.2 AP10.5
information. You define tax codes using AP10.6 AP110
TX01.1 (Tax Code Master). AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-TAX-ID Alpha 20 AP00.3 AP10.1
Tax ID The company's tax identification or AP10.2 AP10.5
registration number. AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-ACCRUAL-FL Alpha 1 AP00.3 AP10.1
Accrual Flag This field indicates how the tax code AP10.2 AP10.5
will affect a taxable transaction. AP10.6 AP110
Invoiced taxes increase the transaction AP125 AP126
amount and accrued taxes (noninvoiced) AP131 AP170
do not affect the transaction amount. AP180 AP181
I = Invoiced AP190 AP20.1
A = Accrual AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-ALLOW-CHANGE Alpha 1 AP00.3 AP10.1
Allow Change This field indicates whether or not you AP10.2 AP10.5
can override the default general ledger AP10.6 AP110
accounts at tax calculation time. AP125 AP126
Y = Yes AP131 AP170
N = No AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-TAX-TERMS Alpha 1 AP00.3 AP10.1
Tax Terms Indicates at what point the tax will be AP10.2 AP10.5
calculated, before or after payment AP10.6 AP110
terms are applied. You define terms in AP125 AP126
the Terms system. AP131 AP170
B = Tax Before Terms AP180 AP181
A = Tax After Terms AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-TAX-POINT Alpha 1 AP00.3 AP10.1
Tax Point This field indicates the date at which AP10.2 AP10.5
you want the system to calculate sales AP10.6 AP110
tax. AP125 AP126
I = Invoice Date AP131 AP170
S = Shipping Date AP180 AP181
P = Payment Date AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-ACCR-CODE Alpha 4 AP00.3 AP10.1
Accrual Code A user-defined code representing an AP10.2 AP10.5
accounts payable accrual account. AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
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 AP20.1
transactions unique. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP32.2 AP520
API1.1 API2.1
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
BRIP.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 DT180
DT181 EE135
EE35.1 EE35.2
EE520 MA41.2
MA43.2 MA61.1
...
TAC-LAND-COST-FLG Alpha 1 AP00.3 AP10.1
Landing Cost Flag This field is used with the Purchase AP10.2 AP10.5
Order and Inventory Control systems. You AP10.6 AP110
determine whether or not the tax on an AP125 AP126
item is to be included in the item's AP131 AP170
cost. AP180 AP181
Y = Yes AP190 AP20.1
N = No AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-TOLERANCE-LMT Signed 13.2 AP00.3 AP10.1
Tolerance Lmt This field indicates a minimum taxable AP10.2 AP10.5
amount for the acceptable tax rate AP10.6 AP110
range. The tolerance limit is valid for AP125 AP126
taxable amounts greater than or equal to AP131 AP170
the amount you entered. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-FROM-RATE Percent 7.4 (Percent) AP00.3 AP10.1
From Rate If you entered a tolerance limit, this AP10.2 AP10.5
field indicates the lowest acceptable AP10.6 AP110
tax rate. AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-THRU-RATE Percent 7.4 (Percent) AP00.3 AP10.1
Thru Rate If you entered a tolerance limit, this AP10.2 AP10.5
field indicates the highest acceptable AP10.6 AP110
tax rate. AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-ADJUST-DISC Alpha 1
Adjust Disc This field indicates whether or not you
can change the discount amount in the
Accounts Payable system.
TAC-INP-ACCT-UNIT Alpha 15 AP00.3 AP10.1
Input Acct Unit The general ledger accounting unit used AP10.2 AP10.5
From Tax Code for input taxes. Input taxes are paid AP10.6 AP110
by the company through the Accounts AP125 AP126
Payable system. AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-INP-ACCOUNT Numeric 6 AP00.3 AP10.1
Input Account From The general ledger account used for AP10.2 AP10.5
Tax Code input taxes. Input taxes are paid for AP10.6 AP110
by the company through the Accounts AP125 AP126
Payable system. AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-INP-SUB-ACCT Numeric 4 AP00.3 AP10.1
Input Subacct From The general ledger subaccount used for AP10.2 AP10.5
Tax Code input taxes. Input taxes are paid for AP10.6 AP110
by the company through the Accounts AP125 AP126
Payable system. AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-INPDU-ACT-UNIT Alpha 15 AP00.3 AP10.1
Inpdu Act Unit The general ledger accounting unit for AP10.2 AP10.5
the input due account. This account is AP10.6 AP110
a temporary account to post the tax AP125 AP126
amount to when invoicing and the tax AP131 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.3
account to the input accounting unit. AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-INPDU-ACCOUNT Numeric 6 AP00.3 AP10.1
Inpdu Account The general ledger account for the AP10.2 AP10.5
input due account. This account is a AP10.6 AP110
temporary account to post the tax amount AP125 AP126
to when invoicing and the tax point date AP131 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.3
the input account. AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-INPDU-SUB-ACCT Numeric 4 AP00.3 AP10.1
Inpdu Sub Acct The general ledger subaccount for the AP10.2 AP10.5
input due account. This is a temporary AP10.6 AP110
account to post the tax amount to when AP125 AP126
invoicing and the tax point date is set AP131 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.3
the input subaccount. AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-OUT-ACCT-UNIT Alpha 15 AP00.3 AP10.1
Output Acct Unit The general ledger accounting unit for AP10.2 AP10.5
From Tax Code output taxes. Output taxes are AP10.6 AP110
collected by the company through the AP125 AP126
Accounts Receivable system. AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-OUT-ACCOUNT Numeric 6 AP00.3 AP10.1
Output Account From The general ledger account used for AP10.2 AP10.5
Tax Code output taxes. Output taxes are AP10.6 AP110
collected by the company through the AP125 AP126
Accounts Receivable system. AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-OUT-SUB-ACCT Numeric 4 AP00.3 AP10.1
Output Subacct From The general ledger subaccount used for AP10.2 AP10.5
Tax Code output taxes. Output taxes are AP10.6 AP110
collected by the company through the AP125 AP126
Accounts Receivable system. AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-OUTDU-ACT-UNIT Alpha 15 AP00.3 AP10.1
Outdu Act Unit The general ledger accounting unit for AP10.2 AP10.5
the output due account. This is a AP10.6 AP110
temporary account to post the tax amount AP125 AP126
to when invoicing and the tax point date AP131 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.3
to the output accounting unit. AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-OUTDU-ACCOUNT Numeric 6 AP00.3 AP10.1
Outdu Account The general ledger account for the AP10.2 AP10.5
output due account. This account is a AP10.6 AP110
temporary account to post the tax amount AP125 AP126
to when invoicing and the tax point date AP131 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.3
to the output account. AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-OUTDU-SUB-ACCT Numeric 4 AP00.3 AP10.1
Outdu Sub Acct The general ledger subaccount for the AP10.2 AP10.5
output due account. This account is a AP10.6 AP110
temporary account to post the tax amount AP125 AP126
to when invoicing and the tax point date AP131 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.3
to the output subaccount. AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-TAX-NAME Derived
Tax Name This field contains the tax code name.
TAC-GDS-SVCS-IND Alpha 1 AP00.3 AP10.1
Gds Svcs Ind Goods and services indicator. AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-VAT-TYPE Alpha 1 AP00.3 AP10.1
Vat Type Specifies the type of transaction the AP10.2 AP10.5
tax code is used for. AP10.6 AP110
D = Domestic AP125 AP126
E = Intra-EC AP131 AP170
I = Import AP180 AP181
X = Export AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-TRNGL-IND Alpha 1 AP00.3 AP10.1
Trngl Ind Triangulation indicator AP10.2 AP10.5
Y = Yes AP10.6 AP110
N = No AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
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
BR00.2 BR11.1
...
TAC-AR-CODE Alpha 4
Accounts Receivable
Code
TXTAXCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TACSET1 COMPANY This index is used to validate a tax AP00.3 AP10.1
TAX-CODE code for a specific company. AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
...
TACSET2 TAX-CODE This index is used to locate a tax code AC57.1 AP00.3
COMPANY for a vendor or customer. AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP125
AP126 AP131
AP170 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP32.2
AP510 AP520
...
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
TXD-TRANS-IDENT
|