jump to main menu jump to subject menu jump to content jump to footer
go image

Division Director

Charles Ghini


Information Systems
200 East Gaines Street
Tallahassee, FL 32399-0318
850-413-3184
design placeholder only

FLAIR File Layout Display

File Layout
Navigation

Help Desk Home  >   FLAIR File Layouts  >   Auxiliary Batch Add / Update File Layouts  >  File Layout Display

File Layout Display

Vendor Employee Update Input Record Format

 I.  Security Header Record:

     Position     Format      Description

       1-1          A1        Header Record Identifier - H
       2-12         A11       Organization
      13-19         A7        User Name


II.  Vendor Employee Update Record:

     Position     Format      Description

       1-6          A6        Filler
       7-15         A9        Vendor Number
      16-16         A1        Filler
      17-32         A16       Vendor Name - Last
      33-48         A16       Vendor Name - First
      49-49         A1        Vendor Name - Middle Initial
      50-65         A16       Vendor Short Name
      66-76         N11       Organization L1-L5
      77-85         N9        Other Identification Number
      86-101        A16       Description
     102-132        A31       Address Line 1
     133-163        A31       Address Line 2
     164-194        A31       Address Line 3
     195-210        A16       City
     211-212        A2        State
     213-221        N9        Zip Code
     222-252        A31       Country
     253-253        N1        Status
     254-259        A6        Filler
     260-263        A4        Filler
     264-269        N6        Filler
     270-275        N6        Filler

Note:  Fields on the vendor employee record may be overridden by input of
       another data code or may be erased by input of a '-' in the first
       position of the input field.  The fields which may be erased are
       noted in the field requirements below.

 

 

 


      Field Name                        Requirements
  
      Security Header Record:
      Security Header Indicator         Required – Value ‘H’
      Organization                      Required
      User Name                         Required

      Update Detail Record:
      Vendor Number                     Required - Must be numeric
      Vendor Short Name                 Optional
      Organization L1-L5                Optional - Must be numeric (1)
      Other Identification Number       Optional - Must be numeric (1)
      Description                       Optional (1)
      Address Line 1                    Optional (1)
      Address Line 2                    Optional (1)
      Address Line 3                    Optional (1)
      City                              Optional (1)
      State                             Optional (1)
      Zip Code                          Optional - Must be numeric (1)
      Country                           Optional (1)
      Status                            Optional - Must be 1, 2, 3, or 4 (1)

After the employee record is updated the record must pass the following edits:
     If address is present city, state and zip are required.
     If address, city, state and zip are present, country is not allowed.
     Total vendor name (lines 1 and 2) and address may not exceed five lines.

(1) May be erased.

File Layout
Navigation

DIS HelpDesk  >   File Layouts  >   Auxiliary Batch Add / Update File Layouts   >  File Layout Display