TXUSAGECD – Tax Usage Codes
- System
- Tax (TX)
- Prefix
TXU- Primary key
COMPANY,TAX-USAGE-CD- Fields
- 3
- Updated by
- 1 program
- Referenced by
- 38 programs
TXUSAGECD is the Tax Usage Codes table in Lawson Tax (prefix TXU). It is indexed by COMPANY, TAX-USAGE-CD (TXUSET1); alternate indexes: TXUSET2. It is updated by TX07.1 and referenced by AP00.3, AP10.1, AP10.2, AP10.5, AP10.6, AP20.1, AP20.2, AP20.3 and 30 more. The table has 3 fields, 2 indexes and 0 documented relations.
About TXUSAGECD
No description in the Lawson data dictionary.
Fields (3)
Column = COBOL field name without the TXU- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#TXU-COMPANY PKCOMPANY | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | TX07.1 |
#TXU-TAX-USAGE-CD PKTAX_USAGE_CD | Alpha 10 | The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required. | TX07.1 |
#TXU-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the description. | TX07.1 |
Indexes (2)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
TXUSET1 |
| Primary | AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +14 more | |
TXUSET2 |
| AP00.3, AP10.1, AP10.2, AP10.5, AP10.6, AP510, API1.1, MA531 +9 more |
Programs
Updated by (1)
- TX07.1 Tax Usage Codes
Referenced by (38)
- AP00.3 Vendor Class
- AP10.1 Vendor
- AP10.2 Vendor Location
- AP10.5 Vendor, Company Codes
- AP10.6 Location, Company Codes
- AP20.1 Basic Invoice
- AP20.2 Taxed Invoice
- AP20.3 Detail Invoice
- AP20.4 Invoice Line Detail
- AP20.5 Multiple Invoice
- AP20.7 Distributions
- AP21.1 View Distributions
- AP23.1 Transit Invoice Entry
- AP510 Vendor Conversion
- AP520 Invoice Interface
- API1.1 Add Invoice
- MA41.1 Add-On Cost Detail - Purchase Order
- MA41.2 Add On Cost Lookup
- MA41.4 Miscellaneous Add-On Cost
- MA41.7 AOC Approval Entry
- MA42.2 Memo Line AOC Detail
- MA43.2 Purchase Order Lookup
- MA44.1 Invoice Line Detail - Purchase Order
- MA44.2 Invoice Line Detail- Service
- MA531 Receipt Interface
- MA540 Invoice Interface
- MA61.1 Match Invoice Approval
- MA65.1 Invoice Line Adjustment
- PO150 Bid Load to Contract or Catalog
- PO25.6 Vendor Agreement Line
- PO25.7 Service Agreement Line
- PO26.4 Vendor Agreement Line Price Breaks
- PO26.5 Vendor Agreement Line Price Breaks
- PO28.2 Vendor Agreement Line Detail List
- PO36.2 Vendor Agreement Import Manual Input
- PO536 Vendor Price Agreement Load
- POIJ.1 Invoke for POPLIUPD
- TX06.2 Codes for Report Line