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
IN120 TX06.1 TX07.1 TX08.1 TX120 TX125
TX130 TX200 TX202 TX220 TX221 TX901
UPDATED BY
AC15.1 AP00.3 AP10.1 AP10.2 AP10.5 AP10.6
AP110 AP125 AP126 AP170 AP180 AP181
AP190 AP193 AP20.1 AP20.2 AP20.5 AP20.6
AP20.7 AP225 AP226 AP23.1 AP25.1 AP25.2
AP26.1 AP30.2 AP30.4 AP32.2 AP510 AP520
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 BL00.1 BL01.1 BL02.1 BL08.1
BL09.1 BL120 BL121 BL122 BL123 BL130
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL290 BL520 BL80.1 BL802 BL820 BL902
BL92.1 BL940 CB03.2 CB10.1 CB10.3 CB180
CB191 CB20.1 CB30.1 CB500 CX05.1 CX05.2
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CX805 CXCP.1 DT180
DT181 EE05.3 EE135 EE20.3 EE35.1 EE35.2
EE520 DR100 IC02.1 IC10.1 IC10.2 IC11.1
IC12.1 IC141 IC142 IC811 IC812 IC83.1
IN20.1 MA08.1 MA140 MA208 MA40.1 MA40.2
MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1
MA43.2 MA43.3 MA43.4 MA52.1 MA530 MA540
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 OE112 OE113 OE114 OE129 OE14.1
OE14.2 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4
OE15.5 OE15.7 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE80.1
OE80.2 OE80.3 OE80.4 OE80.5 OE810 OE830
OE920 OE950 PBIP.1 PO100 PO120 PO121
PO122 PO123 PO132 PO20.1 PO21.1 PO21.2
PO21.5 PO21.6 PO22.1 PO22.2 PO22.3 PO220
PO225 PO25.1 PO25.3 PO25.4 PO25.7 PO28.3
PO28.8 PO31.1 PO820 PO821 RQ10.1 RQ10.3
RQ11.1 RQ20.1 RQ20.3 RQ20.4 RQ35.1 RQ500
TX00.1 TX02.1 TX04.1 TX100 TX140 TX204
TX300 TX40.1 TX40.2 TX804 TX904 TX954
TX955 TX956 WH130 WH132 WH190 WH20.2
WH20.7 WH222 WH30.1 WH30.2 WH30.3 WH31.1
WH31.2 WH31.3 WH32.1 WH32.2 WH32.3 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 AC15.1 AP00.3
Company This field contains the company number. AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP125
AP126 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-NAME Alpha 30 (Lower Case) AC15.1 AP00.3
Name This field contains the company name or AP10.1 AP10.2
description. AP10.5 AP10.6
AP110 AP125
AP126 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-TAX-ID Alpha 20 AC15.1 AP00.3
Tax ID This field contains the tax ID or AP10.1 AP10.2
registration number. AP10.5 AP10.6
AP110 AP125
AP126 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-THIRD-PARTY Alpha 1 AC15.1 AP00.3
Third Party This field indicates which tax system AP10.1 AP10.2
you are using, whether you use the Tax AP10.5 AP10.6
system or a third-party tax system. AP110 AP125
A = Using AVP Sales/Use Tax System AP126 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.5 AP20.6
Q = Using V/Quantum Geocode AP20.7 AP225
R = Using V/Quantm CtyStZp or StZp AP226 AP23.1
" " = Using Lawson Tax System AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-TOLERANCE-LMT Signed 13.2 AC15.1 AP00.3
Tolerance Lmt This field indicates the minimum AP10.1 AP10.2
taxable amount for the acceptable tax AP10.5 AP10.6
rate range. The tolerance limit is valid AP110 AP125
for taxable amounts greater than or AP126 AP170
equal to the amount you entered. AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
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 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904
TXC-FROM-RATE Percent 7.4 (Percent) AC15.1 AP00.3
From Rate This field shows the lowest acceptable AP10.1 AP10.2
tax rate, if you entered a tolerance AP10.5 AP10.6
limit. AP110 AP125
AP126 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-THRU-RATE Percent 7.4 (Percent) AC15.1 AP00.3
Thru Rate This field shows the highest acceptable AP10.1 AP10.2
tax rate if you entered a tolerance AP10.5 AP10.6
limit. AP110 AP125
AP126 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-ACCT-BY-CODE Alpha 1 AC15.1 AP00.3
Acct By Code This field indicates whether general AP10.1 AP10.2
ledger accounts are defined at the AP10.5 AP10.6
company level or at the tax code level. AP110 AP125
Select Yes to indicate that general AP126 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.5 AP20.6
Y = Yes AP20.7 AP225
N = No AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-TAX-POINT Alpha 1 AC15.1 AP00.3
Tax Point This field indicates the date at which AP10.1 AP10.2
you want the system to calculate sales AP10.5 AP10.6
tax. If you select Invoice Date, tax is AP110 AP125
calculated when you release an invoice AP126 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.5 AP20.6
feedback in the Warehouse system. AP20.7 AP225
AP226 AP23.1
If you select Payment Date, tax is AP25.1 AP25.2
calculated at the date of payment. AP26.1 AP30.2
I = Invoice Date AP30.4 AP32.2
S = Shipping Date AP510 AP520
P = Payment Date 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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-ACCR-CODE Alpha 4 AC15.1 AP00.3
Accrual Code A user-defined code representing an AP10.1 AP10.2
accounts payable accrual account. AP10.5 AP10.6
AP110 AP125
AP126 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-ACCRUAL-FL Alpha 1 AC15.1 AP00.3
Accrual Flag This field indicates how the tax code AP10.1 AP10.2
will affect a taxable transaction. AP10.5 AP10.6
Invoiced taxes increase the transaction AP110 AP125
amount and accrued (noninvoiced) taxes AP126 AP170
do not affect the transaction amount. AP180 AP181
I = Invoiced AP190 AP193
A = Accrued AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-ALLOW-CHANGE Alpha 1 AC15.1 AP00.3
Allow Change This field indicates whether or not you AP10.1 AP10.2
can override the default general ledger AP10.5 AP10.6
accounts at tax calculation time. AP110 AP125
Y = Yes AP126 AP170
N = No AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-LAND-COST-FLG Alpha 1 AC15.1 AP00.3
Landing Cost Flag This field is used with the Purchase AP10.1 AP10.2
Order and Inventory Control systems. AP10.5 AP10.6
Select Yes to indicate that the tax on AP110 AP125
an item is included in the item's cost AP126 AP170
(landed). AP180 AP181
Y = Yes AP190 AP193
N = No AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-TAX-TERMS Alpha 1 AC15.1 AP00.3
Tax Terms This field indicates whether tax is AP10.1 AP10.2
calculated before or after payment terms AP10.5 AP10.6
are applied. You define terms in the AP110 AP125
Terms system. AP126 AP170
B = Tax Before Terms AP180 AP181
A = Tax After Terms AP190 AP193
AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-INP-ACCT-UNIT Alpha 15 AC15.1 AP00.3
Input Acct Unit The general ledger accounting unit used AP10.1 AP10.2
From Tax Code for input taxes. Input taxes are paid AP10.5 AP10.6
by the company through the Accounts AP110 AP125
Payable system. AP126 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-INP-ACCOUNT Numeric 6 AC15.1 AP00.3
Input Account From The general ledger account used for AP10.1 AP10.2
Tax Code input taxes. Input taxes are paid by AP10.5 AP10.6
the company through the Accounts Payable AP110 AP125
system. AP126 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-INP-SUB-ACCT Numeric 4 AC15.1 AP00.3
Input Subacct From The general ledger subaccount used for AP10.1 AP10.2
Tax Code input taxes. Input taxes are paid for AP10.5 AP10.6
by the company through the Accounts AP110 AP125
Payable system. AP126 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-INPDU-ACT-UNIT Alpha 15 AC15.1 AP00.3
Inpdu Act Unit The general ledger accounting unit for AP10.1 AP10.2
the input due account. This account is AP10.5 AP10.6
a temporary account to post the tax AP110 AP125
amount to when invoicing and the tax AP126 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.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-INPDU-ACCOUNT Numeric 6 AC15.1 AP00.3
Inpdu Account The general ledger account for the AP10.1 AP10.2
input due account. This account is a AP10.5 AP10.6
temporary account to post the tax amount AP110 AP125
to when invoicing and the tax point date AP126 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.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-INPDU-SUB-ACCT Numeric 4 AC15.1 AP00.3
Inpdu Sub Acct The general ledger subaccount for the AP10.1 AP10.2
input due account. This account is a AP10.5 AP10.6
temporary account to post the tax amount AP110 AP125
to when invoicing and the tax point date AP126 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.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-OUT-ACCT-UNIT Alpha 15 AC15.1 AP00.3
Output Acct Unit The general ledger accounting unit used AP10.1 AP10.2
From Tax Code for output taxes. Output taxes are AP10.5 AP10.6
collected by the company through the AP110 AP125
Accounts Receivable system. AP126 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-OUT-ACCOUNT Numeric 6 AC15.1 AP00.3
Output Account From The general ledger account used for AP10.1 AP10.2
Tax Code output taxes. Output taxes are AP10.5 AP10.6
collected by the company through the AP110 AP125
Accounts Receivable system. AP126 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-OUT-SUB-ACCT Numeric 4 AC15.1 AP00.3
Output Subacct From The general ledger subaccount used for AP10.1 AP10.2
Tax Code output taxes. Output taxes are AP10.5 AP10.6
collected by the company through the AP110 AP125
Accounts Receivable system. AP126 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-OUTDU-ACT-UNIT Alpha 15 AC15.1 AP00.3
Outdu Act Unit The general ledger accounting unit for AP10.1 AP10.2
output due taxes. This account is a AP10.5 AP10.6
temporary account to post the tax amount AP110 AP125
to when invoicing and the tax point date AP126 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.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-OUTDU-ACCOUNT Numeric 6 AC15.1 AP00.3
Outdu Account The general ledger account for the AP10.1 AP10.2
output due account. This account is a AP10.5 AP10.6
temporary account to post the tax amount AP110 AP125
to when invoicing and the tax point date AP126 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.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
TXC-OUTDU-SUB-ACCT Numeric 4 AC15.1 AP00.3
Outdu Sub Acct The general ledger subaccount for the AP10.1 AP10.2
output due account. This account is a AP10.5 AP10.6
temporary account to post the tax amount AP110 AP125
to when invoicing and the tax point date AP126 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.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
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
BL00.1 BL01.1
BL02.1 BL08.1
...
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.
TXCOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TXCSET1 COMPANY This index is used to access and update AC15.1 AP00.3
tax company records. AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP125
AP126 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.5 AP20.6
AP20.7 AP225
AP226 AP23.1
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP510 AP520
...
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
|