Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              ACIFSUB FILE

The Interface Subcontract Employee file stores data to be interfaced into the
Subcontract Employee file from a non-Lawson environment.

UPDATED BY

AC56.1    AC560

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

IFS-RUN-GRP          Alpha 10                                    AC56.1
Run Grp              Batch identifier for grouping records to
                     be interfaced during one run of the
                     Subcontract Employee Interface program.

IFS-SUBCONT-EMP      Numeric 9                                   AC56.1
Subcont Emp          The subcontractor's ID.

IFS-DESCRIPTION      Alpha 30  (Lower Case)                      AC56.1
Description          Concatenation of part of the
                     sucontractor's last  name, part of the
                     subcontractor's  first name and middle
                     initial.

IFS-FICA-NBR         Alpha 15                                    AC56.1
Social Security      The subcontractor's social security
Number               number.

IFS-LAST-NAME        Alpha 30  (Lower Case)                      AC56.1
Last Name            The subcontractor's last name.

IFS-FIRST-NAME       Alpha 15  (Lower Case)                      AC56.1
First Name           The subcontractor's first name.

IFS-MIDDLE-INIT      Alpha 1                                     AC56.1
Middle Initial       The subcontractor's middle initial.

IFS-TITLE            Alpha 30  (Lower Case)                      AC56.1
Title                The subcontractor's job title.

IFS-PHONE-COUNTRY    Alpha 6                                     AC56.1
Telephone Country    The subcontractor's telephone country
Code                 code.

IFS-PHONE            Alpha 15                                    AC56.1
Telephone Number     The subcontractor's complete telephone
                     number (including the aea code).

IFS-PHONE-EXT        Alpha 5                                     AC56.1
Telephone Extension  The subcontractor's telephone extension
                     number.

IFS-E-MAIL-ADDR      Alpha 60                                    AC56.1
E Mail Addr          The subcontractor's E-mail address.

IFS-AP-COMPANY       Numeric 4                                   AC56.1
Ap Company           The Accounts Payable company associated
                     with the contractor (who is processed as
                     a vendor).

IFS-VENDOR           Alpha 9  (Right Justified)                  AC56.1
Vendor ID            The subcontractor's vendor ID.



IFS-PAY-FREQUENCY    Numeric 1                                   AC56.1
Pay Frequency        1 = Weekly
                     2 = Biweekly
                     3 = Semimonthly
                     4 = Monthly

                         ACIFSUB FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IFSSET1   RUN-GRP       This index retrieves subcontractor       AC56.1  AC560
          SUBCONT-EMP   information by run group.