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
AP700 PO150 PO190 IN120 IN20.1 TX06.1
TX07.1 TX08.1 TX125 TX130 TX200 TX202
TX220 TX221 TX226
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 AR501
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 PO120 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.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 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 RQIH.1 RQIJ.1
TX00.1 TX02.1 TX04.1 TX100 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 AM15.1
Element: Company This field contains the company number. 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
...
TXC-NAME Alpha 30 (Lower Case) AM115 AM15.1
Element: Name This field contains the company name or AM15.2 AM15.3
description. 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
...
TXC-TAX-ID Alpha 20 AM115 AM15.1
Element: Tax ID This field contains the tax ID 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 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
...
TXC-THIRD-PARTY Alpha 1 AM115 AM15.1
Element: Third Party This field indicates which tax system AM15.2 AM15.3
you are using, whether you use the Tax AM15.4 AM20.1
system or a third-party tax system. AM20.3 AM21.1
A = Using AVP Sales/Use Tax System AM21.3 AM500
C = Using Vertex - City/Zip Access AM51.1 AM551
G = Using Vertex - Geocode Access AM97.1 AP00.3
S = Using Vertex - State Zip AP10.1 AP10.2
Z = Using Vertex - Zip Code Access AP10.5 AP10.6
Q = Using V/Quantum Geocode AP110 AP115
R = Using V/Quantm CtyStZp or StZp AP125 AP126
" " = Using Lawson Tax System 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
...
TXC-TOLERANCE-LMT Signed 13.2 AM115 AM15.1
Element: App Limit This field indicates the minimum AM15.2 AM15.3
taxable amount for the acceptable tax AM15.4 AM20.1
rate range. The tolerance limit is valid AM20.3 AM21.1
for taxable amounts greater than or AM21.3 AM500
equal to 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 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
...
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 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 BRPI.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA41.2 MA41.7
...
TXC-FROM-RATE Percent 7.4 (Percent) AM115 AM15.1
Element: From Rate This field shows the lowest acceptable AM15.2 AM15.3
tax rate, if you entered a tolerance AM15.4 AM20.1
limit. 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
...
TXC-THRU-RATE Percent 7.4 (Percent) AM115 AM15.1
Element: From Rate This field shows the highest acceptable AM15.2 AM15.3
tax rate if you entered a tolerance AM15.4 AM20.1
limit. 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
...
TXC-ACCT-BY-CODE Alpha 1 AM115 AM15.1
Element: All Flag This field indicates whether general AM15.2 AM15.3
ledger accounts are defined at the AM15.4 AM20.1
company level or at the tax code level. AM20.3 AM21.1
Select Yes to indicate that general AM21.3 AM500
ledger accounts are defined at the tax AM51.1 AM551
code level. Select No to indicate that AM97.1 AP00.3
general ledger accounts are defined at AP10.1 AP10.2
the company level. AP10.5 AP10.6
Y = Yes AP110 AP115
N = No 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
...
TXC-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. If you select Invoice Date, tax is AM20.3 AM21.1
calculated when you release an invoice AM21.3 AM500
in the Billing system. AM51.1 AM551
AM97.1 AP00.3
If you select Shipping Date, it is AP10.1 AP10.2
calculated when you perform shipping AP10.5 AP10.6
feedback in the Warehouse system. AP110 AP115
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 AP20.1 AP20.2
P = Payment Date 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
...
TXC-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 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
...
TXC-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 (noninvoiced) taxes AM21.3 AM500
do not affect the transaction amount. AM51.1 AM551
I = Invoiced AM97.1 AP00.3
A = Accrued 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
...
TXC-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 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
...
TXC-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. AM15.4 AM20.1
Select Yes to indicate that the tax on AM20.3 AM21.1
an item is included in the item's cost AM21.3 AM500
(landed). 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 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
...
TXC-TAX-TERMS Alpha 1 AM115 AM15.1
Element: Tax Terms This field indicates whether tax is AM15.2 AM15.3
calculated before or after payment terms AM15.4 AM20.1
are applied. You define terms in the AM20.3 AM21.1
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 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
...
TXC-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 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
...
TXC-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 by AM15.4 AM20.1
the company through the Accounts Payable 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 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
...
TXC-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 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
...
TXC-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 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
...
TXC-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 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
...
TXC-INPDU-SUB-ACCT Numeric 4 AM115 AM15.1
Element: Subaccount The general ledger subaccount 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 subaccount. 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
...
TXC-OUT-ACCT-UNIT Alpha 15 AM115 AM15.1
Element: Accounting UniThe general ledger accounting unit used AM15.2 AM15.3
for 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 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
...
TXC-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 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
...
TXC-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 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
...
TXC-OUTDU-ACT-UNIT Alpha 15 AM115 AM15.1
Element: Accounting UniThe general ledger accounting unit for AM15.2 AM15.3
output due taxes. 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 accounting unit. 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
...
TXC-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 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
...
TXC-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 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
...
TXC-NBR-PERIODS Numeric 2
Element: Number Fields
TXC-INTRASTAT-IND Alpha 1 AM115 AM15.1
Element: Intrastat Ind Determines whether the company is AM15.2 AM15.3
subject to Intrastat reporting. 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
...
TXC-VAT-REG-CTRY Alpha 2 AM115 AM15.1
Element: Vat Reg Ctry The country component of the VAT AM15.2 AM15.3
Registration Number. This field, AM15.4 AM20.1
together with the Registration Number AM20.3 AM21.1
for the company on the tax transaction. 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
...
TXC-VAT-REG-NBR Alpha 12 AM115 AM15.1
Element: Vat Reg Nbr The number component of the VAT AM15.2 AM15.3
Registration Number. This field together AM15.4 AM20.1
with the Registration Country field make AM20.3 AM21.1
up the VAT Registration Number. 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
...
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 AM15.1
Element: Branch Id The company's branch ID, if required AM15.2 AM15.3
for Intrastate reporting. 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
...
TXC-TAXABLE-CNTR Alpha 1 AM115 AM15.1
Element: Taxable Cntr This field indicates whether the taxable AM15.2 AM15.3
amount edit is turned on or off. If AM15.4 AM20.1
turned on, the taxable amount sum of the AM20.3 AM21.1
invoice lines must equal the total AM21.3 AM500
taxable amount on the AP invoice. AM51.1 AM551
N = No (Default) AM97.1 AP00.3
Y = Yes 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
...
TXCOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TXCSET1 COMPANY This index is used to access and update AM115 AM15.1
tax company records. 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
...
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
|