APTAXGROUP – Reportable Income Group
- System
- Accounts Payable (AP)
- Prefix
TXP- Primary key
TAX-GROUP- Fields
- 23
- Updated by
- 1 program
- Referenced by
- 4 programs
APTAXGROUP is the Reportable Income Group table in Lawson Accounts Payable (prefix TXP). It is indexed by TAX-GROUP (TXPSET1). It is related 1:M to APTAXENT. It is updated by AP02.1 and referenced by AP145, AP146, AP245 and AP246. The table has 23 fields, 1 index and 1 documented relation.
About APTAXGROUP
The Reportable Income Group file contains reportable income processing information for a group of companies or process levels within a vendor group. Reportable income is processed and reported by reportable income group. A Reportable Income Group file record must have one or more associated Reportable Income Group Entity file records in order to generate reportable income forms or tapes.
Fields (23)
Column = COBOL field name without the TXP- 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 |
|---|---|---|---|
#TXP-TAX-GROUP PKTAX_GROUP | Alpha 10 | A user-defined code that represents a group of accounts payable companies and process levels. Used to process and report reportable vendor income. | AP02.1 |
#TXP-VENDOR-GROUPVENDOR_GROUP | Alpha 4 | The vendor group associated with the reportable income group. All companies and process levels assigned to the reportable income group must be associated with this vendor group. Must be a valid record in the Vendor Group file. | AP02.1 |
#TXP-TAX-IDTAX_ID | Alpha 20 | The tax identification or registration number for the reportable income group. | AP02.1 |
#TXP-NAMENAME | Alpha 30 (Lower Case) | The reportable income group name. Used on reportable income forms and tapes. | AP02.1 |
#TXP-ADDR1ADDR1 | Alpha 30 (Lower Case) | The first line of address information for the reportable income group. The reportable income group address is used on reportable income forms and tapes. | AP02.1 |
#TXP-ADDR2ADDR2 | Alpha 30 (Lower Case) | The second line of address information for the reportable income group. | AP02.1 |
#TXP-ADDR3ADDR3 | Alpha 30 (Lower Case) | The third line of address information for the reportable income group. | AP02.1 |
#TXP-ADDR4ADDR4 | Alpha 30 (Lower Case) | The fourth line of address information for the reportable income group. | AP02.1 |
#TXP-CITY-ADDR5CITY_ADDR5 | Alpha 18 (Lower Case) | The city or fifth line of address information for the reportable income group. | AP02.1 |
#TXP-STATE-PROVSTATE_PROV | Alpha 2 | The state or province for the reportable income group address. | AP02.1 |
#TXP-POSTAL-CODEPOSTAL_CODE | Alpha 10 (Lower Case) | The postal code for the reportable income group address. | AP02.1 |
#TXP-COUNTYCOUNTY | Alpha 25 (Lower Case) | The county for the company address. | AP02.1 |
#TXP-COUNTRYCOUNTRY | Alpha 30 (Lower Case) | The country for the reportable income group address. Can also be used for additional information such as an attention name. | AP02.1 |
#TXP-TAPE-CONTROLTAPE_CONTROL | Alpha 5 | The transmitter control number for the reportable income group. Used for creating 1099 reportable income tapes. | AP02.1 |
#TXP-PAYER-NUMBERPAYER_NUMBER | Alpha 12 | The state identification number for the reportable income group. Used for creating Miscellaneous 1099 reportable income forms. | AP02.1 |
#TXP-PAYER-NAMEPAYER_NAME | Alpha 4 | The first four characters of the Payer Name Control provided by the Internal Revenue Service. Used for creating 1099 reportable income tapes. | AP02.1 |
#TXP-PHONE-PREFIXPHONE_PREFIX | Alpha 6 | The telephone number country code for the reportable income group. | AP02.1 |
#TXP-PHONE-NUMPHONE_NUM | Alpha 15 | The telephone number for the reportable income group. | AP02.1 |
#TXP-PHONE-EXTPHONE_EXT | Alpha 5 | The telephone extension number for the reportable income group. | AP02.1 |
#TXP-TAX-CONTACTTAX_CONTACT | Alpha 30 | — | AP02.1 |
#TXP-CONTACT-EMAILCONTACT_EMAIL | Alpha 35 (Lower Case) | Required if available. Enter the email address of the contact regarding electronic or magnetic files. If no email address is available, enter blanks. 35 character length is requirement of IRS Publication 1220 specifications. | AP02.1 |
#TXP-TRAN-MEDIA-NBRTRAN_MEDIA_NBR | Alpha 6 | For magnetic media filers only. Enter the number used to identify a particular piece of media. | AP02.1 |
#TXP-COUNTRY-CODECOUNTRY_CODE | Alpha 2 | The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). | AP02.1 |
Indexes (1)
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 |
|---|---|---|---|---|
TXPSET1 |
| Primary | AP02.1, AP02.2, AP145, AP146, AP245, AP246 |
Relations
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Aptaxent | APTAXENT |
|
Programs
Updated by (1)
- AP02.1 Reportable Income Group