Lawson Insight Technical Documentation |
|
TXCOMPANY
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
AP272 AP700 BL12.1 BL209 PO150 PO190
PO229 PO53.4 PO53.5 PO53.8 IN120 IN20.1
TX06.1 TX07.1 TX08.1 TX125 TX130 TX200
TX202 TX220 TX221 TX226 TX301
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 AR02.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 AR501 AR550 AR560 AR570
AR575 AR580 ARLL.1 BL00.1 BL01.1 BL02.1
BL09.1 BL120 BL121 BL122 BL123 BL130
BL20.1 BL20.3 BL20.5 BL20.6 BL21.2 BL21.5
BL29.1 BL29.2 BL290 BL520 BL80.1 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 PO120 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.1 PO27.2 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 PO36.1 PO36.2
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO536 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 TX00.1 TX02.1 TX04.1
TX100 TX101 TX120 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 WO132 WO140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TXC-COMPANY Numeric 4 AM115 AM117
Element: Company This field contains the company number. 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 AR02.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
...
TXC-NAME Alpha 30 (Lower Case) AM115 AM117
Element: Name This field contains the company name or AM15.1 AM15.2
description. 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 AR02.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
...
TXC-TAX-ID Alpha 20 AM115 AM117
Element: Tax ID This field contains the tax ID 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 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 AR02.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
...
TXC-THIRD-PARTY Alpha 1 AM115 AM117
Element: Third Party This field indicates which tax system AM15.1 AM15.2
you are using, whether you use the Tax AM15.3 AM15.4
system or a third-party tax system. AM20.1 AM20.3
A = Using AVP Sales/Use Tax System AM21.1 AM21.3
C = Using Vertex - City/Zip Access AM500 AM51.1
G = Using Vertex - Geocode Access AM551 AM97.1
S = Using Vertex - State Zip AP00.3 AP10.1
Z = Using Vertex - Zip Code Access AP10.2 AP10.5
Q = Using V/Quantum Geocode AP10.6 AP110
R = Using V/Quantm CtyStZp or StZp AP125 AP126
" " = Using Lawson Tax System 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 AR02.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
...
TXC-TOLERANCE-LMT Signed 18.2 AM115 AM117
Element: Intl Amt This field indicates the minimum AM15.1 AM15.2
taxable amount for the acceptable tax AM15.3 AM15.4
rate range. The tolerance limit is valid AM20.1 AM20.3
for taxable amounts greater than or AM21.1 AM21.3
equal to 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 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 AR02.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
...
TXC-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 exceeds the tax tolerance amount, AP10.2 AP10.5
then it will result in an error. 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 AR02.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
...
TXC-LAST-TRANS-ID Numeric 10 AP125 AP126
Element: Seq Trns Nbr This field indicates the last AP170 AP180
transaction identifier that the system AP181 AP190
generated. AP193 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
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
...
TXC-FROM-RATE Percent 7.4 (Percent) AM115 AM117
Element: From Rate This field shows the lowest acceptable AM15.1 AM15.2
tax rate, if you entered a tolerance AM15.3 AM15.4
limit. 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 AR02.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
...
TXC-THRU-RATE Percent 7.4 (Percent) AM115 AM117
Element: From Rate This field shows the highest acceptable AM15.1 AM15.2
tax rate if you entered a tolerance AM15.3 AM15.4
limit. 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 AR02.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
...
TXC-ACCT-BY-CODE Alpha 1 AM115 AM117
Element: All Flag This field indicates whether general AM15.1 AM15.2
ledger accounts are defined at the AM15.3 AM15.4
company level or at the tax code level. AM20.1 AM20.3
Select Yes to indicate that general AM21.1 AM21.3
ledger accounts are defined at the tax AM500 AM51.1
code level. Select No to indicate that AM551 AM97.1
general ledger accounts are defined at AP00.3 AP10.1
the company level. AP10.2 AP10.5
Y = Yes AP10.6 AP110
N = No 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 AR02.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
...
TXC-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. If you select Invoice Date, tax is AM20.1 AM20.3
calculated when you release an invoice AM21.1 AM21.3
in the Billing system. AM500 AM51.1
AM551 AM97.1
If you select Shipping Date, it is AP00.3 AP10.1
calculated when you perform shipping AP10.2 AP10.5
feedback in the Warehouse system. AP10.6 AP110
AP125 AP126
If you select Payment Date, tax is AP131 AP170
calculated at the date of payment. AP180 AP181
I = Invoice Date AP190 AP193
S = Shipping Date AP220 AP25.1
P = Payment Date AP25.2 AP26.1
G = GL Date AP27.1 AP30.2
AP30.4 AP510
AP520 AP95.1
API1.1 API2.1
API3.1 API4.1
API5.1 AR02.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
...
TXC-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 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 AR02.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
...
TXC-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 (noninvoiced) taxes AM21.1 AM21.3
do not affect the transaction amount. AM500 AM51.1
I = Invoiced AM551 AM97.1
A = Accrued 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 AR02.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
...
TXC-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 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 AR02.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
...
TXC-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. AM15.3 AM15.4
Select Yes to indicate that the tax on AM20.1 AM20.3
an item is included in the item's cost AM21.1 AM21.3
(landed). 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 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 AR02.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
...
TXC-TAX-TERMS Alpha 1 AM115 AM117
Element: Tax Terms This field indicates whether tax is AM15.1 AM15.2
calculated before or after payment terms AM15.3 AM15.4
are applied. You define terms in the AM20.1 AM20.3
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 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 AR02.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
...
TXC-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 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 AR02.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
...
TXC-INP-ACCOUNT Numeric 6 AM115 AM117
Element: Account The general ledger account used for AM15.1 AM15.2
input taxes. Input taxes are paid by AM15.3 AM15.4
the company through the Accounts Payable 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 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 AR02.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
...
TXC-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 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 AR02.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
...
TXC-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 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 AR02.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
...
TXC-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 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 AR02.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
...
TXC-INPDU-SUB-ACCT Numeric 4 AM115 AM117
Element: Subaccount The general ledger subaccount 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 subaccount. 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 AR02.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
...
TXC-OUT-ACCT-UNIT Alpha 15 AM115 AM117
Element: Accounting UniThe general ledger accounting unit used AM15.1 AM15.2
for 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 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 AR02.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
...
TXC-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 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 AR02.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
...
TXC-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 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 AR02.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
...
TXC-OUTDU-ACT-UNIT Alpha 15 AM115 AM117
Element: Accounting UniThe general ledger accounting unit for AM15.1 AM15.2
output due taxes. 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 accounting unit. 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 AR02.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
...
TXC-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 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 AR02.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
...
TXC-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 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 AR02.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
...
TXC-NBR-PERIODS Numeric 2
Element: Number of PeriThe 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 AM115 AM117
Element: Intrastat Ind Determines whether the company is AM15.1 AM15.2
subject to Intrastat reporting. 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 AR02.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
...
TXC-VAT-REG-CTRY Alpha 2 AM115 AM117
Element: Vat Reg Ctry The country component of the VAT AM15.1 AM15.2
Registration Number. This field, AM15.3 AM15.4
together with the Registration Number AM20.1 AM20.3
for the company on the tax transaction. 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 AR02.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
...
TXC-VAT-REG-NBR Alpha 12 AM115 AM117
Element: Vat Reg Nbr The number component of the VAT AM15.1 AM15.2
Registration Number. This field together AM15.3 AM15.4
with the Registration Country field make AM20.1 AM20.3
up the VAT Registration Number. 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 AR02.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
...
TXC-VAT-NBR Derived
Element: Vat Nbr The concatenation of the VAT-REG-CTRY
and VAT-REG-NBR fields, used as VAT
reporting ID.
TXC-BRANCH-ID Alpha 3 AM115 AM117
Element: Branch Id The company's branch ID, if required AM15.1 AM15.2
for Intrastate reporting. 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 AR02.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
...
TXC-TAXABLE-CNTR Alpha 1 AM115 AM117
Element: Taxable Cntr This field indicates whether the taxable AM15.1 AM15.2
amount edit is turned on or off. If AM15.3 AM15.4
turned on, the taxable amount sum of the AM20.1 AM20.3
invoice lines must equal the total AM21.1 AM21.3
taxable amount on the AP invoice. AM500 AM51.1
N = No (Default) AM551 AM97.1
Y = Yes 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 AR02.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
...
TXCOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TXCSET1 COMPANY This index is used to access and update AM115 AM117
tax company records. 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
...
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
|