 |
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
AR501 AR82.1 BL00.1 BL121 BL290 BL80.1
PO120 TX00.1 TX06.2 TX06.3 TX100 TX120
TX125 TX130 TX140 TX202 TX204 TX300
TX40.1 TX40.2 AC57.1 BL202 TX01.1 TX01.2
TX03.1 TX03.2
UPDATED BY
AP00.3 AP10.1 AP10.2 AP10.5 AP10.6 AP110
AP170 AP180 AP181 AP190 AP193 AP30.2
AP30.4 AP32.2 AP510 AP520 API1.1 API2.1
API3.1 API4.1 API5.1 AR08.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 BL01.1 BL02.1 BL09.1 BL123
BL802 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 IC330 IC811 IC812 IC83.1
MA08.1 MA208 MA65.1 PO132 PO220 POED.1
POI7.1 POIF.1 POIJ.1 POIT.1 PR197 TX02.1
TX04.1 TX804 WH130 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4
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 AP170 AP180
system. AP181 AP190
AP30.2 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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). AP170 AP180
AP181 AP190
AP30.2 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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
AP170 AP180
AP181 AP190
AP30.2 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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 AP170 AP180
amount and accrued taxes (noninvoiced) AP181 AP190
do not affect the transaction amount. AP30.2 AP32.2
I = Invoiced AP510 AP520
A = Accrual API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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. AP170 AP180
Y = Yes AP181 AP190
N = No AP30.2 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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 AP170 AP180
the Terms system. AP181 AP190
B = Tax Before Terms AP30.2 AP32.2
A = Tax After Terms AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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. AP170 AP180
I = Invoice Date AP181 AP190
S = Shipping Date AP30.2 AP32.2
P = Payment Date AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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
AP170 AP180
AP181 AP190
AP30.2 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
TAC-LAST-TRANS-ID Numeric 10 AP170 AP180
Last Transaction ID This field indicates the system AP181 AP190
assigned, internal tax transaction AP193 AP30.2
number. It is used to keep tax AP30.4 AP32.2
transactions unique. 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
TX04.1 TX804
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 AP170 AP180
item is to be included in the item's AP181 AP190
cost. AP30.2 AP32.2
Y = Yes AP510 AP520
N = No API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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 AP170 AP180
taxable amounts greater than or equal to AP181 AP190
the amount you entered. AP30.2 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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. AP170 AP180
AP181 AP190
AP30.2 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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. AP170 AP180
AP181 AP190
AP30.2 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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 AP170 AP180
Payable system. AP181 AP190
AP30.2 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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 AP170 AP180
Payable system. AP181 AP190
AP30.2 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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 AP170 AP180
Payable system. AP181 AP190
AP30.2 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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 AP170 AP180
amount to when invoicing and the tax AP181 AP190
point date is set to payment date. When AP30.2 AP32.2
the company actually pays the vendor, AP510 AP520
the tax posting is moved from this API1.1 API2.1
account to the input accounting unit. API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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 AP170 AP180
to when invoicing and the tax point date AP181 AP190
is set to payment date. When the company AP30.2 AP32.2
actually pays the vendor, the tax AP510 AP520
posting is moved from this account to API1.1 API2.1
the input account. API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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 AP170 AP180
invoicing and the tax point date is set AP181 AP190
to payment date. When the company AP30.2 AP32.2
actually pays the vendor, the tax AP510 AP520
posting is moved from this account to API1.1 API2.1
the input subaccount. API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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 AP170 AP180
Accounts Receivable system. AP181 AP190
AP30.2 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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 AP170 AP180
Accounts Receivable system. AP181 AP190
AP30.2 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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 AP170 AP180
Accounts Receivable system. AP181 AP190
AP30.2 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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 AP170 AP180
to when invoicing and the tax point date AP181 AP190
is set to payment date. When the AP30.2 AP32.2
customer actually pays the invoice, the AP510 AP520
tax posting is moved from this account API1.1 API2.1
to the output accounting unit. API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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 AP170 AP180
to when invoicing and the tax point date AP181 AP190
is set to payment date. When the AP30.2 AP32.2
customer actually pays the invoice, the AP510 AP520
tax posting is moved from this account API1.1 API2.1
to the output account. API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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 AP170 AP180
to when invoicing and the tax point date AP181 AP190
is set to payment date. When the AP30.2 AP32.2
customer actually pays the invoice, the AP510 AP520
tax posting is moved from this account API1.1 API2.1
to the output subaccount. API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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
AP170 AP180
AP181 AP190
AP30.2 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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 AP170 AP180
E = Intra-EC AP181 AP190
I = Import AP30.2 AP32.2
X = Export AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
TAC-TRNGL-IND Alpha 1 AP00.3 AP10.1
Trngl Ind Triangulation indicator AP10.2 AP10.5
Y = Yes AP10.6 AP110
N = No AP170 AP180
AP181 AP190
AP30.2 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL123
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
CB191 CB20.1
CB30.1 CB500
...
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
AP170 AP180
AP181 AP190
AP193 AP30.2
AP30.4 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
...
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 AP170
AP180 AP181
AP190 AP30.2
AP32.2 AP510
AP520 API1.1
API2.1 API3.1
API4.1 API5.1
AR08.1 AR115
AR124 AR15.4
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.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
TXD-TRANS-IDENT
|