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 AP52.1 AP52.3 AP700 BL12.1 BL209
MA278 MA54.1 MA54.2 PO150 PO53.4 PO53.5
PO53.8 IN120 IN20.1 TX06.1 TX07.1 TX08.1
TX125 TX130 TX200 TX202 TX220 TX221
TX222 TX226 TX301
UPDATED BY
AC160 AC56.1 AC560 AM115 AM117 AM15.1
AM15.2 AM15.3 AM15.4 AM19.1 AM19.2 AM20.1
AM20.3 AM21.1 AM21.3 AM500 AM51.1 AM551
AM97.1 AP00.3 AP00.4 AP03.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 AP21.1 AP210 AP220 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP30.4 AP305
AP510 AP520 AP90.1 AP91.1 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
AR32.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 BL30.1 BL30.2 BL30.3 BL30.5 BL31.1
BL31.2 BL31.3 BL31.5 BL31.7 BL32.1 BL32.2
BL32.3 BL32.4 BL520 BL80.1 BL802 BL820
BL92.1 BR00.1 BR00.2 BR02.3 BR11.1 BR120
BR121 BR122 BR123 BR140 BR151 BR152
BR156 BR16.1 BR180 BR20.1 BR20.2 BR20.3
BR20.4 BR20.5 BR20.6 BR420 BR46.1 BR46.2
BR46.4 BR48.1 BR521 BRIP.1 CB03.2 CB10.1
CB10.3 CB150 CB180 CB191 CB20.1 CB30.1
CB43.1 CB44.1 CB45.1 CB46.1 CB50.1 CB500
CB54.1 CB543 CB544 CB55.1 CB554 CXCP.1
DT180 DT181 EE05.1 EE135 EE20.3 EE35.1
EE35.2 EE520 ET175 ET542 IC02.1 IC11.1
IC12.1 IC130 IC330 IC811 IC812 MX123
MX500 MA08.1 MA180 MA208 MA279 MA310
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA530 MA531
MA540 MA60.2 MA60.3 MA60.5 MA61.1 MA63.1
MA65.1 MA66.2 MA66.3 MA67.2 MA67.3 MA68.2
MA68.3 MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PD21.1 PD22.1 PD235 PO10.1 PO100 PO101
PO120 PO122 PO131 PO132 PO135 PO136
PO190 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO220 PO223 PO229 PO23.1
PO233 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO253 PO254 PO26.1 PO27.1 PO27.2 PO278
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.1 PO32.2 PO32.3 PO32.4 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
PO54.1 PO54.2 PO54.3 PO54.4 POED.1 POI3.1
POI7.1 POID.1 POIF.1 POIG.1 POII.1 POIJ.1
POIM.1 POIT.1 PR05.1 PR05.3 PR226 PR247
PR26.1 PR47.1 PR514 UK47.1 RQ10.1 RQ10.2
RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ500 RQIB.1 RQIC.1 RQID.1 RQIF.1 RQIG.1
RQIH.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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TXC-COMPANY Numeric 4 AC160 AC56.1
Element: Company This field contains the company number. AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-NAME Alpha 30 (Lower Case) AC160 AC56.1
Element: Name This field contains the company name or AC560 AM115
description. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-TAX-ID Alpha 20 AC160 AC56.1
Element: Tax Id This field contains the tax ID or AC560 AM115
registration number. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-THIRD-PARTY Alpha 1 AC160 AC56.1
Element: Third Party This field indicates which tax system AC560 AM115
you are using, whether you use the Tax AM117 AM15.1
system or a third-party tax system. AM15.2 AM15.3
A = Using AVP Sales/Use Tax System AM15.4 AM19.1
C = Using Vertex - City/Zip Access AM19.2 AM20.1
G = Using Vertex - Geocode Access AM20.3 AM21.1
S = Using Vertex - State Zip AM21.3 AM500
Z = Using Vertex - Zip Code Access AM51.1 AM551
Q = Using V/Quantum Geocode AM97.1 AP00.3
R = Using V/Quantm CtyStZp or StZp AP00.4 AP03.3
" " = Using Lawson Tax System 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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-TOLERANCE-LMT Signed 18.2 AC160 AC56.1
Element: Intl Amt This field indicates the minimum AC560 AM115
taxable amount for the acceptable tax AM117 AM15.1
rate range. The tolerance limit is valid AM15.2 AM15.3
for taxable amounts greater than or AM15.4 AM19.1
equal to the amount you entered. AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-TOLERANCE-AMT Signed 18.2 AC160 AC56.1
Element: Intl Amt Enter a tax tolerance amount for AC560 AM115
tolerance checking. Tolerance checking AM117 AM15.1
applies to verifying a tax amount (for AM15.2 AM15.3
example, Accounts Payable would verify a AM15.4 AM19.1
sales tax amount on an invoice that AM19.2 AM20.1
they're about to pay). If the difference AM20.3 AM21.1
between the passed tax amount exceeds AM21.3 AM500
the tax tolerance amount, then it will AM51.1 AM551
result in an error. AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.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 AP21.1
AP23.1 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
AR32.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 CB150
...
TXC-FROM-RATE Percent 7.4 (Percent) AC160 AC56.1
Element: From Rate This field shows the lowest acceptable AC560 AM115
tax rate, if you entered a tolerance AM117 AM15.1
limit. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-THRU-RATE Percent 7.4 (Percent) AC160 AC56.1
Element: From Rate This field shows the highest acceptable AC560 AM115
tax rate if you entered a tolerance AM117 AM15.1
limit. AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-ACCT-BY-CODE Alpha 1 AC160 AC56.1
Element: All Flag This field indicates whether general AC560 AM115
ledger accounts are defined at the AM117 AM15.1
company level or at the tax code level. AM15.2 AM15.3
Select Yes to indicate that general AM15.4 AM19.1
ledger accounts are defined at the tax AM19.2 AM20.1
code level. Select No to indicate that AM20.3 AM21.1
general ledger accounts are defined at AM21.3 AM500
the company level. AM51.1 AM551
Y = Yes AM97.1 AP00.3
N = No AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-TAX-POINT Alpha 1 AC160 AC56.1
Element: Tax Point This field indicates the date at which AC560 AM115
you want the system to calculate sales AM117 AM15.1
tax. If you select Invoice Date, tax is AM15.2 AM15.3
calculated when you release an invoice AM15.4 AM19.1
in the Billing system. AM19.2 AM20.1
AM20.3 AM21.1
If you select Shipping Date, it is AM21.3 AM500
calculated when you perform shipping AM51.1 AM551
feedback in the Warehouse system. AM97.1 AP00.3
AP00.4 AP03.3
If you select Payment Date, tax is AP10.1 AP10.2
calculated at the date of payment. AP10.5 AP10.6
I = Invoice Date AP110 AP115
S = Shipping Date AP125 AP126
P = Payment Date AP131 AP170
G = GL Date AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-ACCR-CODE Alpha 4 AC160 AC56.1
Element: Ar Code A user-defined code representing an AC560 AM115
accounts payable accrual account. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-ACCRUAL-FL Alpha 1 AC160 AC56.1
Element: Accrual Fl This field indicates how the tax code AC560 AM115
will affect a taxable transaction. AM117 AM15.1
Invoiced taxes increase the transaction AM15.2 AM15.3
amount and accrued (noninvoiced) taxes AM15.4 AM19.1
do not affect the transaction amount. AM19.2 AM20.1
I = Invoiced AM20.3 AM21.1
A = Accrued AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-ALLOW-CHANGE Alpha 1 AC160 AC56.1
Element: All Flag This field indicates whether or not you AC560 AM115
can override the default general ledger AM117 AM15.1
accounts at tax calculation time. AM15.2 AM15.3
Y = Yes AM15.4 AM19.1
N = No AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-LAND-COST-FLG Alpha 1 AC160 AC56.1
Element: All Flag This field is used with the Purchase AC560 AM115
Order and Inventory Control systems. AM117 AM15.1
Select Yes to indicate that the tax on AM15.2 AM15.3
an item is included in the item's cost AM15.4 AM19.1
(landed). AM19.2 AM20.1
Y = Yes AM20.3 AM21.1
N = No AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-TAX-TERMS Alpha 1 AC160 AC56.1
Element: Tax Terms This field indicates whether tax is AC560 AM115
calculated before or after payment terms AM117 AM15.1
are applied. You define terms in the AM15.2 AM15.3
Terms system. AM15.4 AM19.1
B = Tax Before Terms AM19.2 AM20.1
A = Tax After Terms AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-INP-ACCT-UNIT Alpha 15 AC160 AC56.1
Element: Acct Unit The general ledger accounting unit used AC560 AM115
for input taxes. Input taxes are paid AM117 AM15.1
by the company through the Accounts AM15.2 AM15.3
Payable system. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-INP-ACCOUNT Numeric 6 AC160 AC56.1
Element: Account The general ledger account used for AC560 AM115
input taxes. Input taxes are paid by AM117 AM15.1
the company through the Accounts Payable AM15.2 AM15.3
system. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-INP-SUB-ACCT Numeric 4 AC160 AC56.1
Element: Sub Acct The general ledger subaccount used for AC560 AM115
input taxes. Input taxes are paid for AM117 AM15.1
by the company through the Accounts AM15.2 AM15.3
Payable system. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-INPDU-ACT-UNIT Alpha 15 AC160 AC56.1
Element: Acct Unit The general ledger accounting unit for AC560 AM115
the input due account. This account is AM117 AM15.1
a temporary account to post the tax AM15.2 AM15.3
amount to when invoicing and the tax AM15.4 AM19.1
point date is set to payment date. When AM19.2 AM20.1
the company actually pays the vendor, AM20.3 AM21.1
the tax posting is moved from this AM21.3 AM500
account to the input accounting unit. AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-INPDU-ACCOUNT Numeric 6 AC160 AC56.1
Element: Account The general ledger account for the AC560 AM115
input due account. This account is a AM117 AM15.1
temporary account to post the tax amount AM15.2 AM15.3
to when invoicing and the tax point date AM15.4 AM19.1
is set to payment date. When the company AM19.2 AM20.1
actually pays the vendor, the tax AM20.3 AM21.1
posting is moved from this account to AM21.3 AM500
the input account. AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-INPDU-SUB-ACCT Numeric 4 AC160 AC56.1
Element: Sub Acct The general ledger subaccount for the AC560 AM115
input due account. This account is a AM117 AM15.1
temporary account to post the tax amount AM15.2 AM15.3
to when invoicing and the tax point date AM15.4 AM19.1
is set to payment date. When the company AM19.2 AM20.1
actually pays the vendor, the tax AM20.3 AM21.1
posting is moved from this account to AM21.3 AM500
the input subaccount. AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-OUT-ACCT-UNIT Alpha 15 AC160 AC56.1
Element: Acct Unit The general ledger accounting unit used AC560 AM115
for output taxes. Output taxes are AM117 AM15.1
collected by the company through the AM15.2 AM15.3
Accounts Receivable system. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-OUT-ACCOUNT Numeric 6 AC160 AC56.1
Element: Account The general ledger account used for AC560 AM115
output taxes. Output taxes are AM117 AM15.1
collected by the company through the AM15.2 AM15.3
Accounts Receivable system. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-OUT-SUB-ACCT Numeric 4 AC160 AC56.1
Element: Sub Acct The general ledger subaccount used for AC560 AM115
output taxes. Output taxes are AM117 AM15.1
collected by the company through the AM15.2 AM15.3
Accounts Receivable system. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-OUTDU-ACT-UNIT Alpha 15 AC160 AC56.1
Element: Acct Unit The general ledger accounting unit for AC560 AM115
output due taxes. This account is a AM117 AM15.1
temporary account to post the tax amount AM15.2 AM15.3
to when invoicing and the tax point date AM15.4 AM19.1
is set to payment date. When the AM19.2 AM20.1
customer actually pays the invoice, the AM20.3 AM21.1
tax posting is moved from this account AM21.3 AM500
to the output accounting unit. AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-OUTDU-ACCOUNT Numeric 6 AC160 AC56.1
Element: Account The general ledger account for the AC560 AM115
output due account. This account is a AM117 AM15.1
temporary account to post the tax amount AM15.2 AM15.3
to when invoicing and the tax point date AM15.4 AM19.1
is set to payment date. When the AM19.2 AM20.1
customer actually pays the invoice, the AM20.3 AM21.1
tax posting is moved from this account AM21.3 AM500
to the output account. AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-OUTDU-SUB-ACCT Numeric 4 AC160 AC56.1
Element: Sub Acct The general ledger subaccount for the AC560 AM115
output due account. This account is a AM117 AM15.1
temporary account to post the tax amount AM15.2 AM15.3
to when invoicing and the tax point date AM15.4 AM19.1
is set to payment date. When the AM19.2 AM20.1
customer actually pays the invoice, the AM20.3 AM21.1
tax posting is moved from this account AM21.3 AM500
to the output subaccount. AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-NBR-PERIODS Numeric 2
Element: Nbr 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 AC160 AC56.1
Element: Intrastat Ind Determines whether the company is AC560 AM115
subject to Intrastat reporting. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-VAT-REG-CTRY Alpha 2 AC160 AC56.1
Element: Vat Reg Ctry The country component of the VAT AC560 AM115
Registration Number. This field, AM117 AM15.1
together with the Registration Number AM15.2 AM15.3
for the company on the tax transaction. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-VAT-REG-NBR Alpha 12 AC160 AC56.1
Element: Vat Reg Nbr The number component of the VAT AC560 AM115
Registration Number. This field together AM117 AM15.1
with the Registration Country field make AM15.2 AM15.3
up the VAT Registration Number. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.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 AC160 AC56.1
Element: Branch Id The company's branch ID, if required AC560 AM115
for Intrastate reporting. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXC-TAXABLE-CNTR Alpha 1 AC160 AC56.1
Element: Taxable Cntr This field indicates whether the AC560 AM115
taxable amount edit is turned on or off. AM117 AM15.1
If turned on, the taxable amount sum of AM15.2 AM15.3
the invoice lines must equal the total AM15.4 AM19.1
taxable amount on the AP invoice. AM19.2 AM20.1
N = No (Default) AM20.3 AM21.1
Y = Yes AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.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 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 AP520
AP90.1 AP91.1
AP95.1 API1.1
...
TXCOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TXCSET1 COMPANY AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
...
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
|