Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACIFSUB


                              ACIFSUB FILE

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IFS-RUN-GRP            Alpha 10
Element: Base Name     Batch identifier for grouping records to
                       be interfaced during one run of the
                       Subcontract Employee Interface program.

IFS-SUBCONT-EMP        Numeric 9
Element: Subcont Emp   The subcontractor's ID.

IFS-DESCRIPTION        Alpha 30  (Lower Case)
Element: 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
Social Security        The subcontractor's social security
Number                 number.

IFS-LAST-NAME          Alpha 30  (Lower Case)
Element: Name          The subcontractor's last name.

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

IFS-MIDDLE-INIT        Alpha 1
Element: Ac Usage      The subcontractor's middle initial.

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

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

IFS-PHONE              Alpha 15
Element: Telephone NumbThe subcontractor's complete telephone
                       number (including the aea code).

IFS-PHONE-EXT          Alpha 5
Element: Telephone ExteThe subcontractor's telephone extension
                       number.

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

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

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



IFS-PAY-FREQUENCY      Numeric 1
Element: 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
          SUBCONT-EMP   information by run group.