Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APTAXGROUP


                            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
Element: Tax Group     A user-defined code that represents a
                       group of accounts payable companies and
                       process levels. Used to process and
                       report reportable vendor income.

TXP-VENDOR-GROUP       Alpha 4                                   AP02.1
Element: 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
Element: Tax Id        The tax identification or registration
                       number for the reportable income group.

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


TXP-ADDR1              Alpha 30  (Lower Case)                    AP02.1
Element: Addr1         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
Element: Addr1         The second line of address information
                       for the reportable income group.


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


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

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

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


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


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

TXP-COUNTRY            Alpha 30  (Lower Case)                    AP02.1
Element: Country       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
Element: Payer State NuThe state identification number for the
                       reportable income group. Used for
                       creating Miscellaneous 1099 reportable
                       income forms.


TXP-PAYER-NAME         Alpha 4                                   AP02.1
Element: 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
Element: Phone Prefix  The telephone number country code for
                       the reportable income group.

TXP-PHONE-NUM          Alpha 15                                  AP02.1
Element: Phone         The telephone number for the reportable
                       income group.


TXP-PHONE-EXT          Alpha 5                                   AP02.1
Element: Phone Ext     The telephone extension number for the
                       reportable income group.


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

TXP-CONTACT-EMAIL      Alpha 35  (Lower Case)                    AP02.1
Element: Contact Email 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.


TXP-TRAN-MEDIA-NBR     Alpha 6                                   AP02.1
Element: Tran Media NbrFor magnetic media filers only.  Enter
                       the number used to identify a particular
                       piece of media.


TXP-COUNTRY-CODE       Alpha 2                                   AP02.1
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).


                         APTAXGROUP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TXPSET1   TAX-GROUP                                              AP02.1  AP02.2
                                                                 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