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 PO120 PO150 PO190 PO229
PO53.4 PO53.5 PO53.8 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
AM115 AM117 AM15.1 AM15.2 AM15.3 AM15.4
AM20.1 AM20.3 AM21.1 AM21.3 AM500 AM51.1
AM551 AM97.1 AP00.3 AP10.1 AP10.2 AP10.5
AP10.6 AP110 AP125 AP126 AP131 AP170
AP180 AP181 AP190 AP193 AP220 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP30.4 AP510
AP520 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 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 BL520 BL802
BL820 BL92.1 BR00.1 BR00.2 BR02.3 BR11.1
BR120 BR121 BR122 BR140 BR16.1 BR20.1
BR20.2 BR20.3 BR20.4 BR20.5 BR20.6 BR420
BR46.1 BR46.2 BR46.4 BR521 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 MA530 MA531 MA540
MA60.2 MA60.3 MA60.5 MA61.1 MA65.1 MA66.2
MA66.3 MA67.1 MA67.2 MA70.1 MA75.1 MA80.1
MAI1.1 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 OE111 OE112 OE113 OE114
OE116 OE129 OE13.2 OE13.3 OE13.5 OE13.6
OE14.1 OE14.2 OE14.4 OE229 OE30.1 OE30.2
OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9
OE510 OE530 OE80.1 OE80.2 OE80.3 OE80.4
OE80.5 OE81.1 OE810 OE830 OE90.1 OE90.2
PBIP.1 PO100 PO101 PO122 PO131 PO132
PO20.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO220 PO23.1 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 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.4 POED.1
POI3.1 POI7.1 POIE.1 POIF.1 POIG.1 POII.1
POIJ.1 POIM.1 POIT.1 PR05.1 PR05.3 PR197
PR226 PR247 PR26.1 PR47.1 UK47.1 RQ10.1
RQ10.2 RQ10.3 RQ11.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 WO132 WO140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TAC-COMPANY Numeric 4 AM115 AM117
Element: Company This field indicates the company AM15.1 AM15.2
number. You must have already defined AM15.3 AM15.4
the company in the General Ledger AM20.1 AM20.3
system. AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-TAX-CODE Alpha 10 AM115 AM117
Element: Tax Code A user-defined code representing tax AM15.1 AM15.2
information. You define tax codes using AM15.3 AM15.4
TX01.1 (Tax Code Master). AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-TAX-ID Alpha 20 AM115 AM117
Element: Tax ID The company's tax identification or AM15.1 AM15.2
registration number. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-ACCRUAL-FL Alpha 1 AM115 AM117
Element: Accrual Flag This field indicates how the tax code AM15.1 AM15.2
will affect a taxable transaction. AM15.3 AM15.4
Invoiced taxes increase the transaction AM20.1 AM20.3
amount and accrued taxes (noninvoiced) AM21.1 AM21.3
do not affect the transaction amount. AM500 AM51.1
I = Invoiced AM551 AM97.1
A = Accrual AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-ALLOW-CHANGE Alpha 1 AM115 AM117
Element: All Flag This field indicates whether or not you AM15.1 AM15.2
can override the default general ledger AM15.3 AM15.4
accounts at tax calculation time. AM20.1 AM20.3
Y = Yes AM21.1 AM21.3
N = No AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-TAX-TERMS Alpha 1 AM115 AM117
Element: Tax Terms Indicates at what point the tax will be AM15.1 AM15.2
calculated, before or after payment AM15.3 AM15.4
terms are applied. You define terms in AM20.1 AM20.3
the Terms system. AM21.1 AM21.3
B = Tax Before Terms AM500 AM51.1
A = Tax After Terms AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-TAX-POINT Alpha 1 AM115 AM117
Element: Tax Point This field indicates the date at which AM15.1 AM15.2
you want the system to calculate sales AM15.3 AM15.4
tax. AM20.1 AM20.3
I = Invoice Date AM21.1 AM21.3
S = Shipping Date AM500 AM51.1
P = Payment Date AM551 AM97.1
G = GL Date AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-ACCR-CODE Alpha 4 AM115 AM117
Accounts Receivable A user-defined code representing an AM15.1 AM15.2
Code accounts payable accrual account. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.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 AP25.1
transactions unique. 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
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
CB180 CB191
CB20.1 CB30.1
CB500 DT180
DT181 EE135
EE35.1 EE35.2
...
TAC-LAND-COST-FLG Alpha 1 AM115 AM117
Element: All Flag This field is used with the Purchase AM15.1 AM15.2
Order and Inventory Control systems. You AM15.3 AM15.4
determine whether or not the tax on an AM20.1 AM20.3
item is to be included in the item's AM21.1 AM21.3
cost. AM500 AM51.1
Y = Yes AM551 AM97.1
N = No AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-TOLERANCE-LMT Signed 18.2 AM115 AM117
Element: Intl Amt This field indicates a minimum taxable AM15.1 AM15.2
amount for the acceptable tax rate AM15.3 AM15.4
range. The tolerance limit is valid for AM20.1 AM20.3
taxable amounts greater than or equal to AM21.1 AM21.3
the amount you entered. AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-TOLERANCE-AMT Signed 18.2 AM115 AM117
Element: Intl Amt Enter a tax tolerance amount for AM15.1 AM15.2
tolerance checking. Tolerance checking AM15.3 AM15.4
applies to verifying a tax amount (for AM20.1 AM20.3
example, the Accounts Payable system AM21.1 AM21.3
would verify a sales tax amount on an AM500 AM51.1
invoice that they're about to pay). If AM551 AM97.1
the difference between the passed tax AP00.3 AP10.1
amount and the system calculated tax AP10.2 AP10.5
amount exceeds the tax tolerance amount, AP10.6 AP110
then it will result in an error. AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-FROM-RATE Percent 7.4 (Percent) AM115 AM117
Element: From Rate If you entered a tolerance limit, this AM15.1 AM15.2
field indicates the lowest acceptable AM15.3 AM15.4
tax rate. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-THRU-RATE Percent 7.4 (Percent) AM115 AM117
Element: From Rate If you entered a tolerance limit, this AM15.1 AM15.2
field indicates the highest acceptable AM15.3 AM15.4
tax rate. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.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 AM115 AM117
Element: Accounting UniThe general ledger accounting unit used AM15.1 AM15.2
for input taxes. Input taxes are paid AM15.3 AM15.4
by the company through the Accounts AM20.1 AM20.3
Payable system. AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-INP-ACCOUNT Numeric 6 AM115 AM117
Element: Account The general ledger account used for AM15.1 AM15.2
input taxes. Input taxes are paid for AM15.3 AM15.4
by the company through the Accounts AM20.1 AM20.3
Payable system. AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-INP-SUB-ACCT Numeric 4 AM115 AM117
Element: Subaccount The general ledger subaccount used for AM15.1 AM15.2
input taxes. Input taxes are paid for AM15.3 AM15.4
by the company through the Accounts AM20.1 AM20.3
Payable system. AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-INPDU-ACT-UNIT Alpha 15 AM115 AM117
Element: Accounting UniThe general ledger accounting unit for AM15.1 AM15.2
the input due account. This account is AM15.3 AM15.4
a temporary account to post the tax AM20.1 AM20.3
amount to when invoicing and the tax AM21.1 AM21.3
point date is set to payment date. When AM500 AM51.1
the company actually pays the vendor, AM551 AM97.1
the tax posting is moved from this AP00.3 AP10.1
account to the input accounting unit. AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-INPDU-ACCOUNT Numeric 6 AM115 AM117
Element: Account The general ledger account for the AM15.1 AM15.2
input due account. This account is a AM15.3 AM15.4
temporary account to post the tax amount AM20.1 AM20.3
to when invoicing and the tax point date AM21.1 AM21.3
is set to payment date. When the company AM500 AM51.1
actually pays the vendor, the tax AM551 AM97.1
posting is moved from this account to AP00.3 AP10.1
the input account. AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-INPDU-SUB-ACCT Numeric 4 AM115 AM117
Element: Subaccount The general ledger subaccount for the AM15.1 AM15.2
input due account. This is a temporary AM15.3 AM15.4
account to post the tax amount to when AM20.1 AM20.3
invoicing and the tax point date is set AM21.1 AM21.3
to payment date. When the company AM500 AM51.1
actually pays the vendor, the tax AM551 AM97.1
posting is moved from this account to AP00.3 AP10.1
the input subaccount. AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-OUT-ACCT-UNIT Alpha 15 AM115 AM117
Element: Accounting UniThe general ledger accounting unit for AM15.1 AM15.2
output taxes. Output taxes are AM15.3 AM15.4
collected by the company through the AM20.1 AM20.3
Accounts Receivable system. AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-OUT-ACCOUNT Numeric 6 AM115 AM117
Element: Account The general ledger account used for AM15.1 AM15.2
output taxes. Output taxes are AM15.3 AM15.4
collected by the company through the AM20.1 AM20.3
Accounts Receivable system. AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-OUT-SUB-ACCT Numeric 4 AM115 AM117
Element: Subaccount The general ledger subaccount used for AM15.1 AM15.2
output taxes. Output taxes are AM15.3 AM15.4
collected by the company through the AM20.1 AM20.3
Accounts Receivable system. AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-OUTDU-ACT-UNIT Alpha 15 AM115 AM117
Element: Accounting UniThe general ledger accounting unit for AM15.1 AM15.2
the output due account. This is a AM15.3 AM15.4
temporary account to post the tax amount AM20.1 AM20.3
to when invoicing and the tax point date AM21.1 AM21.3
is set to payment date. When the AM500 AM51.1
customer actually pays the invoice, the AM551 AM97.1
tax posting is moved from this account AP00.3 AP10.1
to the output accounting unit. AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-OUTDU-ACCOUNT Numeric 6 AM115 AM117
Element: Account The general ledger account for the AM15.1 AM15.2
output due account. This account is a AM15.3 AM15.4
temporary account to post the tax amount AM20.1 AM20.3
to when invoicing and the tax point date AM21.1 AM21.3
is set to payment date. When the AM500 AM51.1
customer actually pays the invoice, the AM551 AM97.1
tax posting is moved from this account AP00.3 AP10.1
to the output account. AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-OUTDU-SUB-ACCT Numeric 4 AM115 AM117
Element: Subaccount The general ledger subaccount for the AM15.1 AM15.2
output due account. This account is a AM15.3 AM15.4
temporary account to post the tax amount AM20.1 AM20.3
to when invoicing and the tax point date AM21.1 AM21.3
is set to payment date. When the AM500 AM51.1
customer actually pays the invoice, the AM551 AM97.1
tax posting is moved from this account AP00.3 AP10.1
to the output subaccount. AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-TAX-NAME Derived
Element: Tax Name This field contains the tax code name.
TAC-GDS-SVCS-IND Alpha 1 AM115 AM117
Element: Gds Svcs Ind Goods and services indicator. AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-VAT-TYPE Alpha 1 AM115 AM117
Element: Vat Type Specifies the type of transaction the AM15.1 AM15.2
tax code is used for. AM15.3 AM15.4
D = Domestic AM20.1 AM20.3
E = Intra-EC AM21.1 AM21.3
I = Import AM500 AM51.1
X = Export AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TAC-TRNGL-IND Alpha 1 AM115 AM117
Element: Trngl Ind Triangulation indicator AM15.1 AM15.2
Y = Yes AM15.3 AM15.4
N = No AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TXTAXCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TACSET1 COMPANY This index is used to validate a tax AM115 AM117
TAX-CODE code for a specific company. AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP193
AP220 AP25.1
...
TACSET2 TAX-CODE This index is used to locate a tax code AM115 AM117
COMPANY for a vendor or customer. AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
...
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
|