Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            APTAXGROUP FILE

                        Reportable Income Group

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.

REFERENCED BY

AP145     AP146     AP245

UPDATED BY

AP02.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

TXP-TAX-GROUP        Alpha 10                                    AP02.1
Reportable Income    A user-defined code that represents a
Group                group of accounts payable companies and
                     process levels. Used to process and
                     report reportable vendor income.

TXP-VENDOR-GROUP     Alpha 4                                     AP02.1
Vendor Group         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.

TXP-TAX-ID           Alpha 20                                    AP02.1
Tax ID               The tax identification or registration
                     number for the reportable income group.

TXP-NAME             Alpha 30  (Lower Case)                      AP02.1
Name                 The reportable income group name. Used
                     on reportable income forms and tapes.

TXP-ADDR1            Alpha 30  (Lower Case)                      AP02.1
Address 1            The first line of address information
                     for the reportable income group. The
                     reportable income group address is used
                     on reportable income forms and tapes.

TXP-ADDR2            Alpha 30  (Lower Case)                      AP02.1
Address 2            The second line of address information
                     for the reportable income group.

TXP-ADDR3            Alpha 30  (Lower Case)                      AP02.1
Address 3            The third line of address information
                     for the reportable income group.

TXP-ADDR4            Alpha 30  (Lower Case)                      AP02.1
Address 4            The fourth line of address information
                     for the reportable income group.

TXP-CITY-ADDR5       Alpha 18  (Lower Case)                      AP02.1
City or Address 5    The city or fifth line of address
                     information for the reportable income
                     group.

TXP-STATE-PROV       Alpha 2                                     AP02.1
State or Province    The state or province for the
                     reportable income group address.

TXP-POSTAL-CODE      Alpha 10  (Lower Case)                      AP02.1
Postal Code          The postal code for the reportable
                     income group address.

TXP-COUNTY           Alpha 25  (Lower Case)                      AP02.1
County               The county for the company address.

TXP-COUNTRY          Alpha 30  (Lower Case)                      AP02.1
Country or Other     The country for the reportable income
                     group address. Can also be used for
                     additional information such as an
                     attention name.

TXP-TAPE-CONTROL     Alpha 5                                     AP02.1
Tape Transaction     The transmitter control number for the
Control Nbr          reportable income group. Used for
                     creating 1099 reportable income tapes.

TXP-PAYER-NUMBER     Alpha 12                                    AP02.1
Payer State Number   The state identification number for the
                     reportable income group. Used for
                     creating Miscellaneous 1099 reportable
                     income forms.

TXP-PAYER-NAME       Alpha 4                                     AP02.1
Payer Name           The first four characters of the Payer
                     Name Control provided by the Internal
                     Revenue Service. Used for creating 1099
                     reportable income tapes.

TXP-PHONE-PREFIX     Alpha 6                                     AP02.1
Telephone Country    The telephone number country code for
Code                 the reportable income group.

TXP-PHONE-NUM        Alpha 15                                    AP02.1
Telephone Number     The telephone number for the reportable
                     income group.

TXP-PHONE-EXT        Alpha 5                                     AP02.1
Telephone Extension  The telephone extension number for the
                     reportable income group.

TXP-TAX-CONTACT      Alpha 30                                    AP02.1
Tax Contact

                         APTAXGROUP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TXPSET1   TAX-GROUP     This path is used to validate or access  AP02.1  AP02.2
                        a reportable income group record.        AP145   AP146
                                                                 AP245

                         APTAXGROUP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Aptaxent       APTAXENT

                            TXP-TAX-GROUP    -> TNT-TAX-GROUP
                                                TNT-COMPANY
                                                TNT-PROC-LEVEL