 |
Lawson Insight Technical Documentation |
|
TXCOMPANY FILE
Tax Company
The Tax Company file contains company information, as well as which tax
system the company uses. If general ledger accounts are defined at the
company level, those accounts are included on this file.
REFERENCED BY
AP220 PO150 PO190 IN120 IN20.1 TX06.1
TX07.1 TX08.1 TX120 TX125 TX130 TX200
TX202 TX220 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 AR501 AR550 AR560 AR570 AR575
AR580 AR82.1 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 PO120 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.1 PO27.3 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.1
PO32.2 PO32.3 PO33.1 PO34.1 PO35.1 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
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 TX00.1 TX02.1 TX04.1 TX100
TX140 TX204 TX300 TX40.1 TX40.2 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
TXC-COMPANY Numeric 4 AP00.3 AP10.1
Company This field contains the company number. 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 AR501
AR550 AR560
AR570 AR575
...
TXC-NAME Alpha 30 (Lower Case) AP00.3 AP10.1
Name This field contains the company name or AP10.2 AP10.5
description. 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 AR501
AR550 AR560
AR570 AR575
...
TXC-TAX-ID Alpha 20 AP00.3 AP10.1
Tax ID This field contains the tax ID or AP10.2 AP10.5
registration number. 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 AR501
AR550 AR560
AR570 AR575
...
TXC-THIRD-PARTY Alpha 1 AP00.3 AP10.1
Third Party This field indicates which tax system AP10.2 AP10.5
you are using, whether you use the Tax AP10.6 AP110
system or a third-party tax system. AP125 AP126
A = Using AVP Sales/Use Tax System AP131 AP170
C = Using Vertex - City/Zip Access AP180 AP181
G = Using Vertex - Geocode Access AP190 AP193
S = Using Vertex - State Zip AP20.1 AP20.2
Z = Using Vertex - Zip Code Access AP20.3 AP20.4
Q = Using V/Quantum Geocode AP20.5 AP20.6
R = Using V/Quantm CtyStZp or StZp AP20.7 AP23.1
" " = Using Lawson Tax System 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 AR501
AR550 AR560
AR570 AR575
...
TXC-TOLERANCE-LMT Signed 13.2 AP00.3 AP10.1
Tolerance Lmt This field indicates the minimum AP10.2 AP10.5
taxable amount for the acceptable tax AP10.6 AP110
rate range. The tolerance limit is valid AP125 AP126
for taxable amounts greater than or AP131 AP170
equal to the amount you entered. 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 AR501
AR550 AR560
AR570 AR575
...
TXC-LAST-TRANS-ID Numeric 10 AP125 AP126
Last Trans Id This field indicates the last AP170 AP180
transaction identifier that the system AP181 AP190
generated. AP193 AP20.1
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
...
TXC-FROM-RATE Percent 7.4 (Percent) AP00.3 AP10.1
From Rate This field shows the lowest acceptable AP10.2 AP10.5
tax rate, if you entered a tolerance AP10.6 AP110
limit. 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 AR501
AR550 AR560
AR570 AR575
...
TXC-THRU-RATE Percent 7.4 (Percent) AP00.3 AP10.1
Thru Rate This field shows the highest acceptable AP10.2 AP10.5
tax rate if you entered a tolerance AP10.6 AP110
limit. 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 AR501
AR550 AR560
AR570 AR575
...
TXC-ACCT-BY-CODE Alpha 1 AP00.3 AP10.1
Acct By Code This field indicates whether general AP10.2 AP10.5
ledger accounts are defined at the AP10.6 AP110
company level or at the tax code level. AP125 AP126
Select Yes to indicate that general AP131 AP170
ledger accounts are defined at the tax AP180 AP181
code level. Select No to indicate that AP190 AP193
general ledger accounts are defined at AP20.1 AP20.2
the company level. AP20.3 AP20.4
Y = Yes AP20.5 AP20.6
N = No 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 AR501
AR550 AR560
AR570 AR575
...
TXC-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. If you select Invoice Date, tax is AP125 AP126
calculated when you release an invoice AP131 AP170
in the Billing system. AP180 AP181
AP190 AP193
If you select Shipping Date, it is AP20.1 AP20.2
calculated when you perform shipping AP20.3 AP20.4
feedback in the Warehouse system. AP20.5 AP20.6
AP20.7 AP23.1
If you select Payment Date, tax is AP25.1 AP25.2
calculated at the date of payment. AP26.1 AP27.1
I = Invoice Date AP30.2 AP30.4
S = Shipping Date AP32.2 AP510
P = Payment Date 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 AR501
AR550 AR560
AR570 AR575
...
TXC-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 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 AR501
AR550 AR560
AR570 AR575
...
TXC-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 (noninvoiced) taxes AP131 AP170
do not affect the transaction amount. AP180 AP181
I = Invoiced AP190 AP193
A = Accrued 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 AR501
AR550 AR560
AR570 AR575
...
TXC-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 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 AR501
AR550 AR560
AR570 AR575
...
TXC-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. AP10.6 AP110
Select Yes to indicate that the tax on AP125 AP126
an item is included in the item's cost AP131 AP170
(landed). AP180 AP181
Y = Yes AP190 AP193
N = No 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 AR501
AR550 AR560
AR570 AR575
...
TXC-TAX-TERMS Alpha 1 AP00.3 AP10.1
Tax Terms This field indicates whether tax is AP10.2 AP10.5
calculated before or after payment terms AP10.6 AP110
are applied. You define terms in the AP125 AP126
Terms system. AP131 AP170
B = Tax Before Terms AP180 AP181
A = Tax After Terms 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 AR501
AR550 AR560
AR570 AR575
...
TXC-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 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 AR501
AR550 AR560
AR570 AR575
...
TXC-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 by AP10.6 AP110
the company through the Accounts Payable AP125 AP126
system. 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 AR501
AR550 AR560
AR570 AR575
...
TXC-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 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 AR501
AR550 AR560
AR570 AR575
...
TXC-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 AP193
the tax posting is moved from this AP20.1 AP20.2
account to the input accounting unit. 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 AR501
AR550 AR560
AR570 AR575
...
TXC-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 AP193
posting is moved from this account to AP20.1 AP20.2
the input account. 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 AR501
AR550 AR560
AR570 AR575
...
TXC-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 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 AP193
posting is moved from this account to AP20.1 AP20.2
the input subaccount. 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 AR501
AR550 AR560
AR570 AR575
...
TXC-OUT-ACCT-UNIT Alpha 15 AP00.3 AP10.1
Output Acct Unit The general ledger accounting unit used AP10.2 AP10.5
From Tax Code for output taxes. Output taxes are AP10.6 AP110
collected by the company through the AP125 AP126
Accounts Receivable system. 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 AR501
AR550 AR560
AR570 AR575
...
TXC-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 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 AR501
AR550 AR560
AR570 AR575
...
TXC-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 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 AR501
AR550 AR560
AR570 AR575
...
TXC-OUTDU-ACT-UNIT Alpha 15 AP00.3 AP10.1
Outdu Act Unit The general ledger accounting unit for AP10.2 AP10.5
output due taxes. 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 AP193
tax posting is moved from this account AP20.1 AP20.2
to the output accounting unit. 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 AR501
AR550 AR560
AR570 AR575
...
TXC-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 AP193
tax posting is moved from this account AP20.1 AP20.2
to the output account. 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 AR501
AR550 AR560
AR570 AR575
...
TXC-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 AP193
tax posting is moved from this account AP20.1 AP20.2
to the output subaccount. 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 AR501
AR550 AR560
AR570 AR575
...
TXC-NBR-PERIODS Numeric 2
Number of Periods The Number of Periods field contains
the number of periods that are included
when the outline is built. This field
can contain up to two numeric values.
TXC-INTRASTAT-IND Alpha 1 AP00.3 AP10.1
Intrastat Ind Determines whether the company is AP10.2 AP10.5
subject to Intrastat reporting. 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 AR501
AR550 AR560
AR570 AR575
...
TXC-VAT-REG-CTRY Alpha 2 AP00.3 AP10.1
Vat Reg Ctry The country component of the VAT AP10.2 AP10.5
Registration Number. This field, AP10.6 AP110
together with the Registration Number AP125 AP126
for the company on the tax transaction. 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 AR501
AR550 AR560
AR570 AR575
...
TXC-VAT-REG-NBR Alpha 12 AP00.3 AP10.1
Vat Reg Nbr The number component of the VAT AP10.2 AP10.5
Registration Number. This field together AP10.6 AP110
with the Registration Country field make AP125 AP126
up the VAT Registration Number. 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 AR501
AR550 AR560
AR570 AR575
...
TXC-VAT-NBR Derived
Vat Nbr The concatenation of the VAT-REG-CTRY
and VAT-REG-NBR fields, used as VAT
reporting ID.
TXC-BRANCH-ID Alpha 3 AP00.3 AP10.1
Branch Id The company's branch ID, if required AP10.2 AP10.5
for Intrastate reporting. 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 AR501
AR550 AR560
AR570 AR575
...
TXC-AR-CODE Alpha 4
Accounts Receivable
Code
TXCOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TXCSET1 COMPANY This index is used to access and update AP00.3 AP10.1
tax company records. 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
...
TXCOMPANY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Inp Due Acct GLMASTER Required
When (TXC-INPDU-ACT-UNIT != Spaces )
Or (TXC-INPDU-ACCOUNT != Zeroes )
Or (TXC-INPDU-SUB-ACCT != Zeroes )
TXC-COMPANY -> GLM-COMPANY
TXC-INPDU-ACT-UNIT -> GLM-ACCT-UNIT
TXC-INPDU-ACCOUNT -> GLM-ACCOUNT
TXC-INPDU-SUB-ACCT -> GLM-SUB-ACCOUNT
Input Account GLMASTER Required
When TXC-INP-ACCT-UNIT != Spaces
Or TXC-INP-ACCOUNT != Zeroes
Or TXC-INP-SUB-ACCT != Zeroes
TXC-COMPANY -> GLM-COMPANY
TXC-INP-ACCT-UNIT -> GLM-ACCT-UNIT
TXC-INP-ACCOUNT -> GLM-ACCOUNT
TXC-INP-SUB-ACCT -> GLM-SUB-ACCOUNT
Outpt Due Acct GLMASTER Required
When (TXC-OUTDU-ACT-UNIT != Spaces )
Or (TXC-OUTDU-ACCOUNT != Zeroes )
Or (TXC-OUTDU-SUB-ACCT != Zeroes )
TXC-COMPANY -> GLM-COMPANY
TXC-OUTDU-ACT-UNIT -> GLM-ACCT-UNIT
TXC-OUTDU-ACCOUNT -> GLM-ACCOUNT
TXC-OUTDU-SUB-ACCT -> GLM-SUB-ACCOUNT
Output Account GLMASTER Required
When TXC-OUT-ACCT-UNIT != Spaces
Or TXC-OUT-ACCOUNT != Zeroes
Or TXC-OUT-SUB-ACCT != Zeroes
TXC-COMPANY -> GLM-COMPANY
TXC-OUT-ACCT-UNIT -> GLM-ACCT-UNIT
TXC-OUT-ACCOUNT -> GLM-ACCOUNT
TXC-OUT-SUB-ACCT -> GLM-SUB-ACCOUNT
TXCOMPANY FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Txtaxcode TXTAXCODE
TXC-COMPANY -> TAC-COMPANY
TAC-TAX-CODE
|