TX140 – Vertex Geocode Update
- System
- Tax (TX)
- Type
- Batch program
- Updates
- 31 tables
- References
- 42 tables
TX140 (Vertex Geocode Update) is a Lawson Tax batch program. It updates ACSRVCLOC, APVENLOC, APVENMAST, ARCSTMXVAL, ARCUSTFLDS, ARCUSTGRP, ARCUSTOMER, ARLOCKBOX and 23 more and references AGEUSERONE, AGINGCODE, APACCRCODE, APCOMPANY, APVENGROUP, ARAPPLDBOD, ARAPPLIED, ARCOMP and 34 more.
About TX140
Run Vertex Geocode Update (TX140) to print a report of GeoCodes and addresses, as well as update GeoCodes for AR Customers, AP Vendors and Vendor Locations, IC Locations, and Ship-to locations. NOTE This program is only available for Vertex Quantum tax companies. **Processing Effect If you run TX140 in report only mode, it will generate a listing of addresses and related GeoCodes for the record parameters. If you run TX140 in update mode, it will update the appropriate records with the retrieved GeoCodes and generate a report listing the addresses and related GeoCodes for the record parameters.
Updated files (31)
| Table | Description | System |
|---|---|---|
| ACSRVCLOC | This file maintains a service location for tax purposes. | BR |
| APVENLOC | Vendor Location | AP |
| APVENMAST | Vendor Master Record | AP |
| ARCSTMXVAL | This file contains an attribute value for a customer. | AR |
| ARCUSTFLDS | AR Customer User Fields | AR |
| ARCUSTGRP | Accounts Receivable Cust Group | AR |
| ARCUSTOMER | AR Company Customer | AR |
| ARLOCKBOX | Lock Box Location | AR |
| ARPROCLEVL | Accounts Receivable Proc Level | AR |
| CBBANKINST | Bank Transaction Code | CB |
| CKPOINT | No description in the Lawson data dictionary | — |
| CRANALYST | AR Credit Analysts | AR |
| CUSTDEFLTS | AR Customer Defaults | AR |
| CUSTDESC | AR Group Customer | AR |
| CUSTEP | No description in the Lawson data dictionary | BL |
| DTCUSTBANK | AR Customer Paying Bank | DT |
| FTCUSTNOTE | EFT Customer Notification | AR |
| HOLDCODES | AR Hold Code | AR |
| ICICLAUDIT | The IC Location Audit table is created as a result of choosing the audit option in IC01.1 (IC Company). | IC |
| ICLOCATION | Company Location | IC |
| MAJCUSTCL | Major Customer Class | AR |
| MINCUSTCL | Minor Customer Class | AR |
| MXLISTHDR | Attribute List Header | IF |
| NATACCT | Accounts Receivable Natl Acct | AR |
| NATBALANCE | AR National Account Balance | AR |
| OECUST | Customer Order Processing | AR |
| OEPROCLEV | Order Entry Process Level | BL |
| SHIPTO | Customer Ship To Address | BL |
| TERMS | Payment Terms Maintenance | TE |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
Referenced files (42)
| Table | Description | System |
|---|---|---|
| AGEUSERONE | No description in the Lawson data dictionary | AR |
| AGINGCODE | Accounts Receivable Aging Code | AR |
| APACCRCODE | Invoice Accrual Code | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APVENGROUP | Vendor Group | AP |
| ARAPPLDBOD | No description in the Lawson data dictionary | AR |
| ARAPPLIED | Acct Receivables Application | AR |
| ARCOMP | Accounts Receivable Company | AR |
| ARCOMPAUD | AR Company Audit | AR |
| ARCONTACTS | AR Customer Contacts | AR |
| ARCSTMXVAL | This file contains an attribute value for a customer. | AR |
| ARCUSTBOD | No description in the Lawson data dictionary | AR |
| ARCUSTTOTS | AR Customer PL Inclusions | AR |
| ARCYCLE | Accounts Receivable Cycle Code | AR |
| ARDICT | No description in the Lawson data dictionary | AR |
| ARDUNCODE | Dunning Process Code | AR |
| AROIHDR | Acct Receivables Trans Header | AR |
| AROITEMS | Acct Receivables Transaction | AR |
| ARPAYMENT | Acct Receivables Payment | AR |
| ARPRLAUD | AR Process Level Audit | AR |
| ARREMIT | Payment Remittance | AR |
| BILLTO | Bill To | AR |
| BILLTOBOD | No description in the Lawson data dictionary | AR |
| CBBANKENT | Bank | CB |
| CONBOD | No description in the Lawson data dictionary | AR |
| CUCODES | Currency Codes | IF |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| EPTRANS | No description in the Lawson data dictionary | BL |
| FTCUSTGRP | EFT Customer Group | AR |
| FTTRANS | EFT Transaction | AR |
| GLINTCO | General Ledger Intercompany | IF |
| GLSYSTEM | General Ledger Company | IF |
| ICCOMPANY | Inventory Company Information | IC |
| INSTCTRYCD | Intrastat Country Codes | TX |
| OECOMPANY | Order Entry Company | BL |
| SALESREP | Accounts Receivables Sales Rep | AR |
| STATICCUST | AR Ovrd Credit Trans Review | AR |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXRATE | Tax Rate | TX |
| TXTAXTABLE | Tax Table | TX |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (12)
ACAC, ACTA, API3, API4, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU