Lawson Insight Technical Documentation |
|
TXTAXCODE
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
AR02.1 AR501 BL00.1 BL12.1 BL121 BL209
BL290 BL80.1 BR180 MA278 PD21.1 PD22.1
PO150 PO53.4 PO53.5 PO53.8 RQIH.1 TX00.1
TX06.2 TX06.3 TX100 TX120 TX125 TX130
TX140 TX202 TX204 TX300 TX40.1 TX40.2
BL202 RQII.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 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 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
AR115 AR124 AR15.4 AR190 AR20.1 AR21.1
AR21.2 AR21.3 AR24.1 AR29.2 AR30.1 AR32.1
AR34.1 AR42.1 AR42.2 AR42.7 AR43.1 AR550
AR560 AR570 AR575 AR580 ARLL.1 BL01.1
BL02.1 BL09.1 BL120 BL122 BL123 BL130
BL20.1 BL20.3 BL20.5 BL20.6 BL21.2 BL21.5
BL29.1 BL29.2 BL30.1 BL30.2 BL30.3 BL30.5
BL31.1 BL31.2 BL31.3 BL31.5 BL31.7 BL32.1
BL32.2 BL32.3 BL32.4 BL520 BL802 BL820
BL92.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
CB150 CB180 CB191 CB20.1 CB30.1 CB43.1
CB44.1 CB45.1 CB46.1 CB50.1 CB500 CB54.1
CB543 CB544 CB55.1 CB554 CXCP.1 DT180
DT181 EE05.1 EE135 EE20.3 EE35.1 EE35.2
EE520 ET175 ET542 IC02.1 IC11.1 IC12.1
IC130 IC330 IC811 IC812 MX123 MX500
MA08.1 MA180 MA208 MA279 MA310 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA43.7 MA530 MA531 MA540
MA60.2 MA60.3 MA60.5 MA61.1 MA63.1 MA65.1
MA66.2 MA66.3 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PD235
PO10.1 PO100 PO101 PO120 PO122 PO131
PO132 PO135 PO136 PO190 PO20.1 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO220
PO223 PO229 PO23.1 PO233 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO253 PO254 PO26.1
PO27.2 PO278 PO29.1 PO30.1 PO30.2 PO30.3
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
PO536 PO54.1 PO54.2 PO54.3 PO54.4 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 RQ10.1
RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ500 RQIB.1 RQIC.1 RQID.1 RQIF.1
RQIG.1 RQIJ.1 TX02.1 TX04.1 TX101 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 AC160 AC56.1
Element: Company This field indicates the company AC560 AM115
number. You must have already defined AM117 AM15.1
the company in the General Ledger AM15.2 AM15.3
system. 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 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
...
TAC-TAX-CODE Alpha 10 AC160 AC56.1
Element: Tax Code A user-defined code representing tax AC560 AM115
information. You define tax codes using AM117 AM15.1
TX01.1 (Tax Code Master). 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 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
...
TAC-TAX-ID Alpha 20 AC160 AC56.1
Element: Tax Id The company's tax identification or AC560 AM115
registration number. 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 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
...
TAC-ACCRUAL-FL Alpha 1 AC160 AC56.1
Element: Accrual Fl This field indicates how the tax code AC560 AM115
will affect a taxable transaction. AM117 AM15.1
Invoiced taxes increase the transaction AM15.2 AM15.3
amount and accrued taxes (non-invoiced) AM15.4 AM19.1
do not affect the transaction amount. AM19.2 AM20.1
I = Invoiced AM20.3 AM21.1
A = Accrual 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 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
...
TAC-ALLOW-CHANGE Alpha 1 AC160 AC56.1
Element: All Flag This field indicates whether or not you AC560 AM115
can override the default general ledger AM117 AM15.1
accounts at tax calculation time. AM15.2 AM15.3
Y = Yes AM15.4 AM19.1
N = No 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 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
...
TAC-TAX-TERMS Alpha 1 AC160 AC56.1
Element: Tax Terms Indicates at what point the tax will be AC560 AM115
calculated, before or after payment AM117 AM15.1
terms are applied. You define terms in AM15.2 AM15.3
the Terms system. AM15.4 AM19.1
B = Tax Before Terms AM19.2 AM20.1
A = Tax After Terms 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 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
...
TAC-TAX-POINT Alpha 1 AC160 AC56.1
Element: Tax Point This field indicates the date at which AC560 AM115
you want the system to calculate sales AM117 AM15.1
tax. AM15.2 AM15.3
I = Invoice Date AM15.4 AM19.1
S = Shipping Date AM19.2 AM20.1
P = Payment Date AM20.3 AM21.1
G = GL Date 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 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
...
TAC-ACCR-CODE Alpha 4 AC160 AC56.1
Element: Ar Code A user-defined code representing an AC560 AM115
accounts payable accrual account. 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 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
...
TAC-LAST-TRANS-ID Numeric 10 AP125 AP126
Element: Last TransactiThis 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
ARLL.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BRIP.1
CB10.1 CB150
...
TAC-LAND-COST-FLG Alpha 1 AC160 AC56.1
Element: All Flag This field is used with the Purchase AC560 AM115
Order and Inventory Control systems. You AM117 AM15.1
determine whether or not the tax on an AM15.2 AM15.3
item is to be included in the item's AM15.4 AM19.1
cost. AM19.2 AM20.1
Y = Yes AM20.3 AM21.1
N = No 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 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
...
TAC-TOLERANCE-LMT Signed 18.2 AC160 AC56.1
Element: Intl Amt This field indicates a minimum taxable AC560 AM115
amount for the acceptable tax rate AM117 AM15.1
range. The tolerance limit is valid for AM15.2 AM15.3
taxable amounts greater than or equal to AM15.4 AM19.1
the amount you entered. 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 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
...
TAC-TOLERANCE-AMT Signed 18.2 AC160 AC56.1
Element: Intl Amt Enter a tax tolerance amount for AC560 AM115
tolerance checking. Tolerance checking AM117 AM15.1
applies to verifying a tax amount (for AM15.2 AM15.3
example, the Accounts Payable system AM15.4 AM19.1
would verify a sales tax amount on an AM19.2 AM20.1
invoice that they're about to pay). If AM20.3 AM21.1
the difference between the passed tax AM21.3 AM500
amount and the system calculated tax AM51.1 AM551
amount exceeds the tax tolerance amount, AM97.1 AP00.3
then it will result in an error. AP00.4 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
AP131 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
...
TAC-FROM-RATE Percent 7.4 (Percent) AC160 AC56.1
Element: From Rate If you entered a tolerance limit, this AC560 AM115
field indicates the lowest acceptable AM117 AM15.1
tax rate. 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 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
...
TAC-THRU-RATE Percent 7.4 (Percent) AC160 AC56.1
Element: From Rate If you entered a tolerance limit, this AC560 AM115
field indicates the highest acceptable AM117 AM15.1
tax rate. 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 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
...
TAC-ADJUST-DISC Alpha 1
Element: 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 AC160 AC56.1
Element: Acct Unit The general ledger accounting unit used AC560 AM115
for input taxes. Input taxes are paid AM117 AM15.1
by the company through the Accounts AM15.2 AM15.3
Payable system. 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 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
...
TAC-INP-ACCOUNT Numeric 6 AC160 AC56.1
Element: Account The general ledger account used for AC560 AM115
input taxes. Input taxes are paid for AM117 AM15.1
by the company through the Accounts AM15.2 AM15.3
Payable system. 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 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
...
TAC-INP-SUB-ACCT Numeric 4 AC160 AC56.1
Element: Sub Acct The general ledger subaccount used for AC560 AM115
input taxes. Input taxes are paid for AM117 AM15.1
by the company through the Accounts AM15.2 AM15.3
Payable system. 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 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
...
TAC-INPDU-ACT-UNIT Alpha 15 AC160 AC56.1
Element: Acct Unit The general ledger accounting unit for AC560 AM115
the input due account. This account is AM117 AM15.1
a temporary account to post the tax AM15.2 AM15.3
amount to when invoicing and the tax AM15.4 AM19.1
point date is set to payment date. When AM19.2 AM20.1
the company actually pays the vendor, AM20.3 AM21.1
the tax posting is moved from this AM21.3 AM500
account to the input accounting unit. AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
AP131 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
...
TAC-INPDU-ACCOUNT Numeric 6 AC160 AC56.1
Element: Account The general ledger account for the AC560 AM115
input due account. This account is a AM117 AM15.1
temporary account to post the tax amount AM15.2 AM15.3
to when invoicing and the tax point date AM15.4 AM19.1
is set to payment date. When the company AM19.2 AM20.1
actually pays the vendor, the tax AM20.3 AM21.1
posting is moved from this account to AM21.3 AM500
the input account. AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
AP131 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
...
TAC-INPDU-SUB-ACCT Numeric 4 AC160 AC56.1
Element: Sub Acct The general ledger subaccount for the AC560 AM115
input due account. This is a temporary AM117 AM15.1
account to post the tax amount to when AM15.2 AM15.3
invoicing and the tax point date is set AM15.4 AM19.1
to payment date. When the company AM19.2 AM20.1
actually pays the vendor, the tax AM20.3 AM21.1
posting is moved from this account to AM21.3 AM500
the input subaccount. AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
AP131 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
...
TAC-OUT-ACCT-UNIT Alpha 15 AC160 AC56.1
Element: Acct Unit The general ledger accounting unit for AC560 AM115
output taxes. Output taxes are AM117 AM15.1
collected by the company through the AM15.2 AM15.3
Accounts Receivable system. 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 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
...
TAC-OUT-ACCOUNT Numeric 6 AC160 AC56.1
Element: Account The general ledger account used for AC560 AM115
output taxes. Output taxes are AM117 AM15.1
collected by the company through the AM15.2 AM15.3
Accounts Receivable system. 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 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
...
TAC-OUT-SUB-ACCT Numeric 4 AC160 AC56.1
Element: Sub Acct The general ledger subaccount used for AC560 AM115
output taxes. Output taxes are AM117 AM15.1
collected by the company through the AM15.2 AM15.3
Accounts Receivable system. 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 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
...
TAC-OUTDU-ACT-UNIT Alpha 15 AC160 AC56.1
Element: Acct Unit The general ledger accounting unit for AC560 AM115
the output due account. This is a AM117 AM15.1
temporary account to post the tax amount AM15.2 AM15.3
to when invoicing and the tax point date AM15.4 AM19.1
is set to payment date. When the AM19.2 AM20.1
customer actually pays the invoice, the AM20.3 AM21.1
tax posting is moved from this account AM21.3 AM500
to the output accounting unit. AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
AP131 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
...
TAC-OUTDU-ACCOUNT Numeric 6 AC160 AC56.1
Element: Account The general ledger account for the AC560 AM115
output due account. This account is a AM117 AM15.1
temporary account to post the tax amount AM15.2 AM15.3
to when invoicing and the tax point date AM15.4 AM19.1
is set to payment date. When the AM19.2 AM20.1
customer actually pays the invoice, the AM20.3 AM21.1
tax posting is moved from this account AM21.3 AM500
to the output account. AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
AP131 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
...
TAC-OUTDU-SUB-ACCT Numeric 4 AC160 AC56.1
Element: Sub Acct The general ledger subaccount for the AC560 AM115
output due account. This account is a AM117 AM15.1
temporary account to post the tax amount AM15.2 AM15.3
to when invoicing and the tax point date AM15.4 AM19.1
is set to payment date. When the AM19.2 AM20.1
customer actually pays the invoice, the AM20.3 AM21.1
tax posting is moved from this account AM21.3 AM500
to the output subaccount. AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
AP131 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
...
TAC-TAX-NAME Derived
Element: Tax Name This field contains the tax code name.
TAC-GDS-SVCS-IND Alpha 1 AC160 AC56.1
Element: Gds Svcs Ind Goods and services indicator. AC560 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 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
...
TAC-VAT-TYPE Alpha 1 AC160 AC56.1
Element: Vat Type Specifies the type of transaction the AC560 AM115
tax code is used for. AM117 AM15.1
D = Domestic AM15.2 AM15.3
E = Intra-EC AM15.4 AM19.1
I = Import AM19.2 AM20.1
X = Export 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 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
...
TAC-TRNGL-IND Alpha 1 AC160 AC56.1
Element: Trngl Ind Triangulation indicator AC560 AM115
Y = Yes AM117 AM15.1
N = No 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 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
...
TXTAXCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TACSET1 COMPANY AC160 AC56.1
TAX-CODE AC560 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
...
TACSET2 TAX-CODE AC160 AC56.1
COMPANY AC560 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
...
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 TCM-TAX-TYPE = "S"
Or TCM-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
|