|
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.
|