 |
Lawson Insight Technical Documentation |
|
TXCOMPANY FILE
Tax Company
The Tax Company file contains company information, as well as which tax
system the company uses. If general ledger accounts are defined at the
company level, those accounts are included on this file.
REFERENCED BY
IN120 IN20.1 TX06.1 TX07.1 TX08.1 TX120
TX125 TX130 TX200 TX202 TX220 TX221
UPDATED BY
AP00.3 AP10.1 AP10.2 AP10.5 AP10.6 AP110
AP170 AP180 AP181 AP190 AP193 AP30.2
AP30.4 AP32.2 AP510 AP520 API1.1 API2.1
API3.1 API4.1 API5.1 AR08.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 BL09.1 BL121 BL123 BL290 BL80.1
BL802 BR00.2 BR11.1 BR120 BR121 BR420
BRIP.1 CB03.2 CB10.1 CB10.3 CB180 CB191
CB20.1 CB30.1 CB500 CXCP.1 DT180 DT181
EE05.1 EE135 EE20.3 EE35.1 EE35.2 EE520
DR100 IC02.1 IC10.1 IC10.2 IC11.1 IC12.1
IC141 IC142 IC330 IC811 IC812 IC83.1
MA08.1 MA208 MA65.1 PO120 PO132 PO220
POED.1 POI7.1 POIF.1 POIJ.1 POIT.1 PR197
TX00.1 TX02.1 TX04.1 TX100 TX140 TX204
TX300 TX40.1 TX40.2 TX804 WH130 WH33.1
WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8
WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TXC-COMPANY Numeric 4 AP00.3 AP10.1
Company This field contains the company number. AP10.2 AP10.5
AP10.6 AP110
AP170 AP180
AP181 AP190
AP193 AP30.2
AP30.4 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-NAME Alpha 30 (Lower Case) AP00.3 AP10.1
Name This field contains the company name or AP10.2 AP10.5
description. AP10.6 AP110
AP170 AP180
AP181 AP190
AP193 AP30.2
AP30.4 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-TAX-ID Alpha 20 AP00.3 AP10.1
Tax ID This field contains the tax ID or AP10.2 AP10.5
registration number. AP10.6 AP110
AP170 AP180
AP181 AP190
AP193 AP30.2
AP30.4 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-THIRD-PARTY Alpha 1 AP00.3 AP10.1
Third Party This field indicates which tax system AP10.2 AP10.5
you are using, whether you use the Tax AP10.6 AP110
system or a third-party tax system. AP170 AP180
A = Using AVP Sales/Use Tax System AP181 AP190
C = Using Vertex - City/Zip Access AP193 AP30.2
G = Using Vertex - Geocode Access AP30.4 AP32.2
S = Using Vertex - State Zip AP510 AP520
Z = Using Vertex - Zip Code Access API1.1 API2.1
Q = Using V/Quantum Geocode API3.1 API4.1
R = Using V/Quantm CtyStZp or StZp API5.1 AR08.1
" " = Using Lawson Tax System 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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-TOLERANCE-LMT Signed 13.2 AP00.3 AP10.1
Tolerance Lmt This field indicates the minimum AP10.2 AP10.5
taxable amount for the acceptable tax AP10.6 AP110
rate range. The tolerance limit is valid AP170 AP180
for taxable amounts greater than or AP181 AP190
equal to the amount you entered. AP193 AP30.2
AP30.4 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-LAST-TRANS-ID Numeric 10 AP170 AP180
Last Trans Id This field indicates the last AP181 AP190
transaction identifier that the system AP193 AP30.2
generated. AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXC-FROM-RATE Percent 7.4 (Percent) AP00.3 AP10.1
From Rate This field shows the lowest acceptable AP10.2 AP10.5
tax rate, if you entered a tolerance AP10.6 AP110
limit. AP170 AP180
AP181 AP190
AP193 AP30.2
AP30.4 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-THRU-RATE Percent 7.4 (Percent) AP00.3 AP10.1
Thru Rate This field shows the highest acceptable AP10.2 AP10.5
tax rate if you entered a tolerance AP10.6 AP110
limit. AP170 AP180
AP181 AP190
AP193 AP30.2
AP30.4 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-ACCT-BY-CODE Alpha 1 AP00.3 AP10.1
Acct By Code This field indicates whether general AP10.2 AP10.5
ledger accounts are defined at the AP10.6 AP110
company level or at the tax code level. AP170 AP180
Select Yes to indicate that general AP181 AP190
ledger accounts are defined at the tax AP193 AP30.2
code level. Select No to indicate that AP30.4 AP32.2
general ledger accounts are defined at AP510 AP520
the company level. API1.1 API2.1
Y = Yes API3.1 API4.1
N = No API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-TAX-POINT Alpha 1 AP00.3 AP10.1
Tax Point This field indicates the date at which AP10.2 AP10.5
you want the system to calculate sales AP10.6 AP110
tax. If you select Invoice Date, tax is AP170 AP180
calculated when you release an invoice AP181 AP190
in the Billing system. AP193 AP30.2
AP30.4 AP32.2
If you select Shipping Date, it is AP510 AP520
calculated when you perform shipping API1.1 API2.1
feedback in the Warehouse system. API3.1 API4.1
API5.1 AR08.1
If you select Payment Date, tax is AR115 AR124
calculated at the date of payment. AR15.4 AR190
I = Invoice Date AR20.1 AR21.1
S = Shipping Date AR21.2 AR21.3
P = Payment Date 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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-ACCR-CODE Alpha 4 AP00.3 AP10.1
Accrual Code A user-defined code representing an AP10.2 AP10.5
accounts payable accrual account. AP10.6 AP110
AP170 AP180
AP181 AP190
AP193 AP30.2
AP30.4 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-ACCRUAL-FL Alpha 1 AP00.3 AP10.1
Accrual Flag This field indicates how the tax code AP10.2 AP10.5
will affect a taxable transaction. AP10.6 AP110
Invoiced taxes increase the transaction AP170 AP180
amount and accrued (noninvoiced) taxes AP181 AP190
do not affect the transaction amount. AP193 AP30.2
I = Invoiced AP30.4 AP32.2
A = Accrued AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-ALLOW-CHANGE Alpha 1 AP00.3 AP10.1
Allow Change This field indicates whether or not you AP10.2 AP10.5
can override the default general ledger AP10.6 AP110
accounts at tax calculation time. AP170 AP180
Y = Yes AP181 AP190
N = No AP193 AP30.2
AP30.4 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-LAND-COST-FLG Alpha 1 AP00.3 AP10.1
Landing Cost Flag This field is used with the Purchase AP10.2 AP10.5
Order and Inventory Control systems. AP10.6 AP110
Select Yes to indicate that the tax on AP170 AP180
an item is included in the item's cost AP181 AP190
(landed). AP193 AP30.2
Y = Yes AP30.4 AP32.2
N = No AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-TAX-TERMS Alpha 1 AP00.3 AP10.1
Tax Terms This field indicates whether tax is AP10.2 AP10.5
calculated before or after payment terms AP10.6 AP110
are applied. You define terms in the AP170 AP180
Terms system. AP181 AP190
B = Tax Before Terms AP193 AP30.2
A = Tax After Terms AP30.4 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-INP-ACCT-UNIT Alpha 15 AP00.3 AP10.1
Input Acct Unit The general ledger accounting unit used AP10.2 AP10.5
From Tax Code for input taxes. Input taxes are paid AP10.6 AP110
by the company through the Accounts AP170 AP180
Payable system. AP181 AP190
AP193 AP30.2
AP30.4 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-INP-ACCOUNT Numeric 6 AP00.3 AP10.1
Input Account From The general ledger account used for AP10.2 AP10.5
Tax Code input taxes. Input taxes are paid by AP10.6 AP110
the company through the Accounts Payable AP170 AP180
system. AP181 AP190
AP193 AP30.2
AP30.4 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-INP-SUB-ACCT Numeric 4 AP00.3 AP10.1
Input Subacct From The general ledger subaccount used for AP10.2 AP10.5
Tax Code input taxes. Input taxes are paid for AP10.6 AP110
by the company through the Accounts AP170 AP180
Payable system. AP181 AP190
AP193 AP30.2
AP30.4 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-INPDU-ACT-UNIT Alpha 15 AP00.3 AP10.1
Inpdu Act Unit The general ledger accounting unit for AP10.2 AP10.5
the input due account. This account is AP10.6 AP110
a temporary account to post the tax AP170 AP180
amount to when invoicing and the tax AP181 AP190
point date is set to payment date. When AP193 AP30.2
the company actually pays the vendor, AP30.4 AP32.2
the tax posting is moved from this AP510 AP520
account to the input accounting unit. API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-INPDU-ACCOUNT Numeric 6 AP00.3 AP10.1
Inpdu Account The general ledger account for the AP10.2 AP10.5
input due account. This account is a AP10.6 AP110
temporary account to post the tax amount AP170 AP180
to when invoicing and the tax point date AP181 AP190
is set to payment date. When the company AP193 AP30.2
actually pays the vendor, the tax AP30.4 AP32.2
posting is moved from this account to AP510 AP520
the input account. API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-INPDU-SUB-ACCT Numeric 4 AP00.3 AP10.1
Inpdu Sub Acct The general ledger subaccount for the AP10.2 AP10.5
input due account. This account is a AP10.6 AP110
temporary account to post the tax amount AP170 AP180
to when invoicing and the tax point date AP181 AP190
is set to payment date. When the company AP193 AP30.2
actually pays the vendor, the tax AP30.4 AP32.2
posting is moved from this account to AP510 AP520
the input subaccount. API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-OUT-ACCT-UNIT Alpha 15 AP00.3 AP10.1
Output Acct Unit The general ledger accounting unit used AP10.2 AP10.5
From Tax Code for output taxes. Output taxes are AP10.6 AP110
collected by the company through the AP170 AP180
Accounts Receivable system. AP181 AP190
AP193 AP30.2
AP30.4 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-OUT-ACCOUNT Numeric 6 AP00.3 AP10.1
Output Account From The general ledger account used for AP10.2 AP10.5
Tax Code output taxes. Output taxes are AP10.6 AP110
collected by the company through the AP170 AP180
Accounts Receivable system. AP181 AP190
AP193 AP30.2
AP30.4 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-OUT-SUB-ACCT Numeric 4 AP00.3 AP10.1
Output Subacct From The general ledger subaccount used for AP10.2 AP10.5
Tax Code output taxes. Output taxes are AP10.6 AP110
collected by the company through the AP170 AP180
Accounts Receivable system. AP181 AP190
AP193 AP30.2
AP30.4 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-OUTDU-ACT-UNIT Alpha 15 AP00.3 AP10.1
Outdu Act Unit The general ledger accounting unit for AP10.2 AP10.5
output due taxes. This account is a AP10.6 AP110
temporary account to post the tax amount AP170 AP180
to when invoicing and the tax point date AP181 AP190
is set to payment date. When the AP193 AP30.2
customer actually pays the invoice, the AP30.4 AP32.2
tax posting is moved from this account AP510 AP520
to the output accounting unit. API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-OUTDU-ACCOUNT Numeric 6 AP00.3 AP10.1
Outdu Account The general ledger account for the AP10.2 AP10.5
output due account. This account is a AP10.6 AP110
temporary account to post the tax amount AP170 AP180
to when invoicing and the tax point date AP181 AP190
is set to payment date. When the AP193 AP30.2
customer actually pays the invoice, the AP30.4 AP32.2
tax posting is moved from this account AP510 AP520
to the output account. API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-OUTDU-SUB-ACCT Numeric 4 AP00.3 AP10.1
Outdu Sub Acct The general ledger subaccount for the AP10.2 AP10.5
output due account. This account is a AP10.6 AP110
temporary account to post the tax amount AP170 AP180
to when invoicing and the tax point date AP181 AP190
is set to payment date. When the AP193 AP30.2
customer actually pays the invoice, the AP30.4 AP32.2
tax posting is moved from this account AP510 AP520
to the output subaccount. API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-NBR-PERIODS Numeric 2
Number of Periods The Number of Periods field contains
the number of periods that are included
when the outline is built. This field
can contain up to two numeric values.
TXC-INTRASTAT-IND Alpha 1 AP00.3 AP10.1
Intrastat Ind Determines whether the company is AP10.2 AP10.5
subject to Intrastat reporting. AP10.6 AP110
AP170 AP180
AP181 AP190
AP193 AP30.2
AP30.4 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-VAT-REG-CTRY Alpha 2 AP00.3 AP10.1
Vat Reg Ctry The country component of the VAT AP10.2 AP10.5
Registration Number. This field, AP10.6 AP110
together with the Registration Number AP170 AP180
for the company on the tax transaction. AP181 AP190
AP193 AP30.2
AP30.4 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-VAT-REG-NBR Alpha 12 AP00.3 AP10.1
Vat Reg Nbr The number component of the VAT AP10.2 AP10.5
Registration Number. This field together AP10.6 AP110
with the Registration Country field make AP170 AP180
up the VAT Registration Number. AP181 AP190
AP193 AP30.2
AP30.4 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXC-VAT-NBR Derived
Vat Nbr The concatenation of the VAT-REG-CTRY
and VAT-REG-NBR fields, used as VAT
reporting ID.
TXC-BRANCH-ID Alpha 3 AP00.3 AP10.1
Branch Id The company's branch ID, if required AP10.2 AP10.5
for Intrastate reporting. AP10.6 AP110
AP170 AP180
AP181 AP190
AP193 AP30.2
AP30.4 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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 BL09.1
BL121 BL123
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
...
TXCOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TXCSET1 COMPANY This index is used to access and update AP00.3 AP10.1
tax company records. AP10.2 AP10.5
AP10.6 AP110
AP170 AP180
AP181 AP190
AP193 AP30.2
AP30.4 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
...
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
|