Tax – Lawson TX tables and programs
Tax (TX) in Lawson S3 v10 MSP6 has 33 tables, 29 online screens and 23 batch programs.
Tables (33)
| Table | Prefix | Description | Primary key | Fields |
|---|---|---|---|---|
| INCALENDAR | INL | Intrastat Calendar | COMPANY, TAX-YEAR, TAX-PERIOD | 6 |
| INDOCTPCD | HDC | No description in the Lawson data dictionary | GLBL-DOC-TYPE | 3 |
| INFERCONCD | SPC | No description in the Lawson data dictionary | FOR-ECON-CODE | 3 |
| INLINETYPE | ILN | No description in the Lawson data dictionary | GLBL-LINE-TYPE | 3 |
| INRPTTBL | IFT | No description in the Lawson data dictionary | COMPANY, BATCH-NBR, PAYMENT-SEQ, CASH-CODE, BANK-INST-CODE, TRANS-IDENT, TRANS-NBR | 16 |
| INSTATPROC | INP | Intrastat Stat Procedure | STAT-PROC | 2 |
| INSTCMDTY | INO | ICN and Unit of Measure Codes | ICN-CODE | 3 |
| INSTCTRYCD | INT | Intrastat Country Codes | COUNTRY-CODE | 9 |
| INSTDETAIL | ING | Intrastat Detail Transactions | COMPANY, FISCAL-YEAR, INTRASTAT-NBR, MNT-LINE-NBR | 10 |
| INSTHEADER | INH | Intrastat Transaction Header | COMPANY, FISCAL-YEAR, INTRASTAT-NBR | 36 |
| INSTNBR | INB | Intrastat Company Numbers | COMPANY, FISCAL-YEAR | 3 |
| INSTNOTC | INN | Intrastat Nature of Trans Code | NOTC | 2 |
| INSTPORTS | INX | No description in the Lawson data dictionary | COUNTRY-CODE, PORT-CD | 3 |
| INSTREGN | INR | Intrastat Region Code | COUNTRY-CODE, REGION | 4 |
| INSTUOM | INU | No description in the Lawson data dictionary | UOM | 2 |
| TACBOD | YTA | No description in the Lawson data dictionary | COMPANY, TAX-CODE | 8 |
| TXCALDTL | TXB | VAT calendar detail | COMPANY, TAX-YEAR, TAX-PERIOD | 5 |
| TXCALENDAR | TXA | VAT calendar header | COMPANY, TAX-YEAR | 2 |
| TXCODEMAST | TCM | Tax Code Master | TAX-CODE | 4 |
| TXCOMPANY | TXC | Tax Company | COMPANY | 36 |
| TXRPTDIST | TDT | No description in the Lawson data dictionary | COMPANY, SYSTEM-CD, DOCUMENT, SUFFIX, TRANS-TYPE, LINE-NBR, SEQ-NBR, DIST-SEQ-NBR | 15 |
| TXRPTTRANS | TAS | No description in the Lawson data dictionary | COMPANY, SYSTEM-CD, DOCUMENT, SUFFIX, TRANS-TYPE, VEND-CUST | 16 |
| TXTAXCODE | TAC | Tax Code Maintenance | COMPANY, TAX-CODE | 33 |
| TXTAXRATE | TXR | Tax Rate | TAX-CODE, PROD-TAX-CAT, EFFECT-DATE | 7 |
| TXTAXTABLE | TXT | Tax Table | TAX-TABLE, EFFECT-DATE | 19 |
| TXTAXTRAN | TXD | Tax Transaction | COMPANY, TAX-CODE, TRANS-IDENT | 46 |
| TXTXTRNBOD | YCI | No description in the Lawson data dictionary | COMPANY, TAX-CODE, TRANS-IDENT | 9 |
| TXUSAGECD | TXU | Tax Usage Codes | COMPANY, TAX-USAGE-CD | 3 |
| TXVATESLCD | TVS | VAT EC Sales codes | COMPANY, VAT-RPT-ID, COUNTRY-CODE, TAX-CODE | 4 |
| TXVATRPT | TVR | VAT EC Sales list Tax Codes | COMPANY, VAT-RPT-ID, COUNTRY-CODE | 4 |
| TXVATRPTCD | TVC | VAT Report codes | COMPANY, VAT-RPT-ID, COUNTRY-CODE, VAT-SEQ-NBR, TAX-USAGE-CD | 5 |
| TXVATRPTDT | TVD | No description in the Lawson data dictionary | COMPANY, VAT-RPT-ID, COUNTRY-CODE, VAT-SEQ-NBR, VAT-BOX-NBR, SUM-SEQ-NBR | 7 |
| TXVATRPTLN | TVL | VAT Report lines | COMPANY, VAT-RPT-ID, COUNTRY-CODE, VAT-SEQ-NBR | 15 |
Online screens (29)
| Screen | Description | Updates | References |
|---|---|---|---|
| IN01.1 | Country Codes | 2 | 0 |
| IN02.1 | Region Codes | 1 | 1 |
| IN03.1 | ICN and Unit of Measure Codes | 1 | 0 |
| IN04.1 | Port Codes | 1 | 1 |
| IN06.1 | Statistical Procedures | 1 | 0 |
| IN07.1 | Nature of Transaction Codes | 1 | 0 |
| IN08.1 | Intrastat Calendar Maintenance | 1 | 1 |
| IN09.1 | Foreign Economic Reg Code | 1 | 0 |
| IN10.1 | Document Type Code | 1 | 0 |
| IN11.1 | Line Type | 1 | 0 |
| IN20.1 | Intrastat Data Maintenance | 3 | 17 |
| TX00.1 | Company | 2 | 29 |
| TX01.1 | Tax Code Master | 1 | 3 |
| TX01.2 | Tax Tables | 2 | 3 |
| TX02.1 | Tax Code Maintenance | 3 | 4 |
| TX03.1 | Tax Rate | 2 | 3 |
| TX03.2 | Category Override Tax Rates | 2 | 3 |
| TX04.1 | Tax Transaction | 4 | 14 |
| TX06.1 | Tax Report Maintenance for Value Added Tax | 5 | 2 |
| TX06.2 | Codes for Report Line | 2 | 3 |
| TX06.3 | European Community Sales List Tax Codes | 2 | 2 |
| TX06.4 | Value Added Tax Box Summary Line | 1 | 2 |
| TX07.1 | Tax Usage Codes | 1 | 1 |
| TX08.1 | Tax Calendar Maintenance | 2 | 1 |
| TX40.1 | Tax Inquiry for Vertex | 5 | 25 |
| TX40.2 | Tax Rates Inquiry | 1 | 3 |
| TXBD.1 | TX BOD Maintenance | 2 | 0 |
| TXBD.2 | TX BOD Inquiry | 0 | 4 |
| TXI1.1 | Invoke for Tax Processing | 4 | 6 |
Batch programs (23)
| Program | Description | Updates | References |
|---|---|---|---|
| IN120 | Intrastat Data Report | 4 | 13 |
| IN201 | Intrastat Country Code Listing | 1 | 4 |
| IN202 | Intrastat Codes | 1 | 5 |
| IN501 | Country Code Load | 2 | 1 |
| TX100 | Tax Analysis Report | 7 | 13 |
| TX101 | Journal File Create | 16 | 26 |
| TX120 | Value Added Tax Return Report | 5 | 7 |
| TX125 | Purchase and Sales Report - Belgium | 2 | 5 |
| TX130 | European Community Sales Report | 1 | 8 |
| TX140 | Vertex Geocode Update | 31 | 42 |
| TX200 | Tax Company Listing | 1 | 1 |
| TX201 | Tax Code Master Listing | 1 | 1 |
| TX202 | Tax Code Listing | 2 | 6 |
| TX203 | Tax Rate Listing | 1 | 2 |
| TX204 | Tax Transaction Listing | 2 | 4 |
| TX220 | Vendor, Customer Tax Audit | 2 | 2 |
| TX221 | Tax Transaction Audit | 2 | 6 |
| TX222 | Tax Reconciliation Report | 3 | 8 |
| TX226 | Purchasing and Sales Journal | 6 | 17 |
| TX300 | Tax History Purge | 4 | 4 |
| TX301 | Journal Detail Purge | 5 | 15 |
| TX750 | TX shell program for BOD files | 1 | 1 |
| TX804 | Tax Transaction Conversion | 6 | 6 |
Other tables used by Tax programs (105)
ACHISTDTL, ACHISTHDR, ACHISTTAX, ACSRVCLOC, ADDRDATA, AGEUSERONE, AGINGCODE, APACCRCODE, APCOMPANY, APDISTRIB, APINVOICE, APPROCLEV, APVENGROUP, APVENLOC, APVENMAST, ARACMUF, ARAPHUF, ARAPMUF, ARAPPLDBOD, ARAPPLIED, ARARHUF, ARCOMP, ARCOMPAUD, ARCONTACTS, ARCSTMXVAL, ARCUSTBOD, ARCUSTFLDS, ARCUSTGRP, ARCUSTOMER, ARCUSTTOTS, ARCYCLE, ARDICT, ARDISTRIB, ARDUNCODE, ARLOCKBOX, AROIHDR, AROITEMS, ARPAYMENT, ARPRLAUD, ARPROCLEVL, ARREMIT, ARUSRFLDEF, BILLTO, BILLTOBOD, BLOEIUF, BLOILUF, BLSHPUF, BLUSRFLDEF, CBBANKENT, CBBANKINST, CBDISTRIB, CBPROCLEV, CBTRANS, CONBOD, CRANALYST, CUCODES, CUCONV, CURELAT, CUSTDEFLTS, CUSTDESC, CUSTEP, DTCUSTBANK, EPTRANS, FTCUSTGRP, FTCUSTNOTE, FTTRANS, GLADDRESS, GLCGCPY, GLCHART, GLCPYGRP, GLINTCO, GLSYSTEM, HOLDCODES, ICCOMPANY, ICICLAUDIT, ICLOCATION, MAJCUSTCL, MINCUSTCL, MXLISTHDR, NATACCT, NATBALANCE, OECOLUF, OECOMPANY, OECORUF, OECUST, OEDIST, OEINVCLINE, OEINVCMISC, OEINVCTAX, OEINVOICE, OEOPEUF, OEPROCLEV, OEUSRFLDEF, SALESREP, SHIPTO, STATICCUST, TERMS, WFSETUP, WHUSRFLDEF, WHWHLUF, WHWHSUF, WOUSRFLDEF, WOWBNUF, WOWOIUF, WOWORUF