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
AR501 PO120 PO150 PO190 RQIH.1 TX00.1
TX06.2 TX06.3 TX100 TX120 TX125 TX130
TX140 TX202 TX204 TX300 TX40.1 TX40.2
AC57.1 RQII.1 TX01.1 TX01.2 TX03.1 TX03.2
TX221
UPDATED BY
AM115 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 AP115 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 AP305 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 BR122 BR123 BR151 BR152
BR156 BR16.1 BR420 BR521 BRIP.1 BRPI.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 IC130
IC141 IC142 IC28.1 IC330 IC811 IC812
IC83.1 IC840 MA08.1 MA126 MA180 MA208
MA41.1 MA41.2 MA41.4 MA41.7 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 MA63.1 MA65.1 MA66.2 MA66.3 MA67.1
MA67.2 MA68.1 MA70.1 MA75.1 MA80.1 MAI1.1
PBIP.1 PO100 PO101 PO122 PO131 PO132
PO135 PO136 PO20.1 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO220 PO229 PO23.1
PO25.1 PO25.5 PO25.6 PO25.7 PO26.1 PO27.2
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.1 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 POIF.1 POIG.1 POII.1 POIJ.1
POIM.1 POIT.1 PR05.1 PR05.3 PR197 PR226
PR247 PR26.1 PR47.1 PR514 UK47.1 RQ10.1
RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ35.1
RQ500 RQIB.1 RQIC.1 RQID.1 RQIE.1 RQIF.1
RQIG.1 RQIJ.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 WO132 WO140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TAC-COMPANY Numeric 4 AM115 AM15.1
Element: Company This field indicates the company AM15.2 AM15.3
number. You must have already defined AM15.4 AM20.1
the company in the General Ledger AM20.3 AM21.1
system. AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-TAX-CODE Alpha 10 AM115 AM15.1
Element: Tax Code A user-defined code representing tax AM15.2 AM15.3
information. You define tax codes using AM15.4 AM20.1
TX01.1 (Tax Code Master). AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-TAX-ID Alpha 20 AM115 AM15.1
Element: Tax ID The company's tax identification or AM15.2 AM15.3
registration number. 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 AP115
AP125 AP126
AP131 AP170
AP180 AP181
AP190 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
AP305 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
...
TAC-ACCRUAL-FL Alpha 1 AM115 AM15.1
Element: Accrual Flag This field indicates how the tax code AM15.2 AM15.3
will affect a taxable transaction. AM15.4 AM20.1
Invoiced taxes increase the transaction AM20.3 AM21.1
amount and accrued taxes (noninvoiced) AM21.3 AM500
do not affect the transaction amount. AM51.1 AM551
I = Invoiced AM97.1 AP00.3
A = Accrual 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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-ALLOW-CHANGE Alpha 1 AM115 AM15.1
Element: All Flag This field indicates whether or not you AM15.2 AM15.3
can override the default general ledger AM15.4 AM20.1
accounts at tax calculation time. AM20.3 AM21.1
Y = Yes AM21.3 AM500
N = No AM51.1 AM551
AM97.1 AP00.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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-TAX-TERMS Alpha 1 AM115 AM15.1
Element: Tax Terms Indicates at what point the tax will be AM15.2 AM15.3
calculated, before or after payment AM15.4 AM20.1
terms are applied. You define terms in AM20.3 AM21.1
the Terms system. AM21.3 AM500
B = Tax Before Terms AM51.1 AM551
A = Tax After Terms AM97.1 AP00.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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-TAX-POINT Alpha 1 AM115 AM15.1
Element: Tax Point This field indicates the date at which AM15.2 AM15.3
you want the system to calculate sales AM15.4 AM20.1
tax. AM20.3 AM21.1
I = Invoice Date AM21.3 AM500
S = Shipping Date AM51.1 AM551
P = Payment Date AM97.1 AP00.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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-ACCR-CODE Alpha 4 AM115 AM15.1
Accounts Receivable A user-defined code representing an AM15.2 AM15.3
Code accounts payable accrual account. 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 AP115
AP125 AP126
AP131 AP170
AP180 AP181
AP190 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
AP305 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
...
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 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 BRPI.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA41.2 MA41.7
...
TAC-LAND-COST-FLG Alpha 1 AM115 AM15.1
Element: All Flag This field is used with the Purchase AM15.2 AM15.3
Order and Inventory Control systems. You AM15.4 AM20.1
determine whether or not the tax on an AM20.3 AM21.1
item is to be included in the item's AM21.3 AM500
cost. AM51.1 AM551
Y = Yes AM97.1 AP00.3
N = No 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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-TOLERANCE-LMT Signed 13.2 AM115 AM15.1
Element: App Limit This field indicates a minimum taxable AM15.2 AM15.3
amount for the acceptable tax rate AM15.4 AM20.1
range. The tolerance limit is valid for AM20.3 AM21.1
taxable amounts greater than or equal to AM21.3 AM500
the amount you entered. AM51.1 AM551
AM97.1 AP00.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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-FROM-RATE Percent 7.4 (Percent) AM115 AM15.1
Element: From Rate If you entered a tolerance limit, this AM15.2 AM15.3
field indicates the lowest acceptable AM15.4 AM20.1
tax rate. AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-THRU-RATE Percent 7.4 (Percent) AM115 AM15.1
Element: From Rate If you entered a tolerance limit, this AM15.2 AM15.3
field indicates the highest acceptable AM15.4 AM20.1
tax rate. AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-ADJUST-DISC Alpha 1
Element: Ac Usage This field indicates whether or not you
can change the discount amount in the
Accounts Payable system.
TAC-INP-ACCT-UNIT Alpha 15 AM115 AM15.1
Element: Accounting UniThe general ledger accounting unit used AM15.2 AM15.3
for input taxes. Input taxes are paid AM15.4 AM20.1
by the company through the Accounts AM20.3 AM21.1
Payable system. AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-INP-ACCOUNT Numeric 6 AM115 AM15.1
Element: Account The general ledger account used for AM15.2 AM15.3
input taxes. Input taxes are paid for AM15.4 AM20.1
by the company through the Accounts AM20.3 AM21.1
Payable system. AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-INP-SUB-ACCT Numeric 4 AM115 AM15.1
Element: Subaccount The general ledger subaccount used for AM15.2 AM15.3
input taxes. Input taxes are paid for AM15.4 AM20.1
by the company through the Accounts AM20.3 AM21.1
Payable system. AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-INPDU-ACT-UNIT Alpha 15 AM115 AM15.1
Element: Accounting UniThe general ledger accounting unit for AM15.2 AM15.3
the input due account. This account is AM15.4 AM20.1
a temporary account to post the tax AM20.3 AM21.1
amount to when invoicing and the tax AM21.3 AM500
point date is set to payment date. When AM51.1 AM551
the company actually pays the vendor, AM97.1 AP00.3
the tax posting is moved from this AP10.1 AP10.2
account to the input accounting unit. 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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-INPDU-ACCOUNT Numeric 6 AM115 AM15.1
Element: Account The general ledger account for the AM15.2 AM15.3
input due account. This account is a AM15.4 AM20.1
temporary account to post the tax amount AM20.3 AM21.1
to when invoicing and the tax point date AM21.3 AM500
is set to payment date. When the company AM51.1 AM551
actually pays the vendor, the tax AM97.1 AP00.3
posting is moved from this account to AP10.1 AP10.2
the input account. 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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-INPDU-SUB-ACCT Numeric 4 AM115 AM15.1
Element: Subaccount The general ledger subaccount for the AM15.2 AM15.3
input due account. This is a temporary AM15.4 AM20.1
account to post the tax amount to when AM20.3 AM21.1
invoicing and the tax point date is set AM21.3 AM500
to payment date. When the company AM51.1 AM551
actually pays the vendor, the tax AM97.1 AP00.3
posting is moved from this account to AP10.1 AP10.2
the input subaccount. 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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-OUT-ACCT-UNIT Alpha 15 AM115 AM15.1
Element: Accounting UniThe general ledger accounting unit for AM15.2 AM15.3
output taxes. Output taxes are AM15.4 AM20.1
collected by the company through the AM20.3 AM21.1
Accounts Receivable system. AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-OUT-ACCOUNT Numeric 6 AM115 AM15.1
Element: Account The general ledger account used for AM15.2 AM15.3
output taxes. Output taxes are AM15.4 AM20.1
collected by the company through the AM20.3 AM21.1
Accounts Receivable system. AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-OUT-SUB-ACCT Numeric 4 AM115 AM15.1
Element: Subaccount The general ledger subaccount used for AM15.2 AM15.3
output taxes. Output taxes are AM15.4 AM20.1
collected by the company through the AM20.3 AM21.1
Accounts Receivable system. AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-OUTDU-ACT-UNIT Alpha 15 AM115 AM15.1
Element: Accounting UniThe general ledger accounting unit for AM15.2 AM15.3
the output due account. This is a AM15.4 AM20.1
temporary account to post the tax amount AM20.3 AM21.1
to when invoicing and the tax point date AM21.3 AM500
is set to payment date. When the AM51.1 AM551
customer actually pays the invoice, the AM97.1 AP00.3
tax posting is moved from this account AP10.1 AP10.2
to the output accounting unit. 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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-OUTDU-ACCOUNT Numeric 6 AM115 AM15.1
Element: Account The general ledger account for the AM15.2 AM15.3
output due account. This account is a AM15.4 AM20.1
temporary account to post the tax amount AM20.3 AM21.1
to when invoicing and the tax point date AM21.3 AM500
is set to payment date. When the AM51.1 AM551
customer actually pays the invoice, the AM97.1 AP00.3
tax posting is moved from this account AP10.1 AP10.2
to the output account. 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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-OUTDU-SUB-ACCT Numeric 4 AM115 AM15.1
Element: Subaccount The general ledger subaccount for the AM15.2 AM15.3
output due account. This account is a AM15.4 AM20.1
temporary account to post the tax amount AM20.3 AM21.1
to when invoicing and the tax point date AM21.3 AM500
is set to payment date. When the AM51.1 AM551
customer actually pays the invoice, the AM97.1 AP00.3
tax posting is moved from this account AP10.1 AP10.2
to the output subaccount. 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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-TAX-NAME Derived
Element: Tax Name This field contains the tax code name.
TAC-GDS-SVCS-IND Alpha 1 AM115 AM15.1
Element: Gds Svcs Ind Goods and services indicator. 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 AP115
AP125 AP126
AP131 AP170
AP180 AP181
AP190 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
AP305 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
...
TAC-VAT-TYPE Alpha 1 AM115 AM15.1
Element: Vat Type Specifies the type of transaction the AM15.2 AM15.3
tax code is used for. AM15.4 AM20.1
D = Domestic AM20.3 AM21.1
E = Intra-EC AM21.3 AM500
I = Import AM51.1 AM551
X = Export AM97.1 AP00.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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TAC-TRNGL-IND Alpha 1 AM115 AM15.1
Element: Trngl Ind Triangulation indicator AM15.2 AM15.3
Y = Yes AM15.4 AM20.1
N = No AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 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
...
TXTAXCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TACSET1 COMPANY This index is used to validate a tax AM115 AM15.1
TAX-CODE code for a specific company. 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 AP115
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
...
TACSET2 TAX-CODE This index is used to locate a tax code AC57.1 AM115
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 AP20.1
AP20.2 AP20.3
...
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
|