The file K_INTSUPL contains one record for each location/supplier to be loaded into Replenish.

IS_COMP        1          COLHDG('Company ID')                 
IS_LOCN        5          COLHDG('Location ID')                
IS_BUYR        5          COLHDG('Buyer' 'group ID')             
IS_SUPL       10          COLHDG('Supplier' 'ID')            
IS_SUPLSUB    10          COLHDG('Supplier' 'Sub ID')            
IS_BIRTH      10          COLHDG('Supplier' 'trans' 'birth')              
IS_NAME       40          COLHDG('Supplier' 'Name')              
IS_LEADTM      3  0       COLHDG('Lead' 'time' 'in days')      
IS_ORCYCLE     3  0       COLHDG('Order cycle' 'in days')      

Field explanations:

Company ID

IS_COMP        1          COLHDG('Company' 'ID')

This 1 character value is used throughout the Replenish system to identify the company being processed.

Examples:    Company name    code
             Brandon Company   B
             Johnson Limited   J
             Daniels Auto      D

Location ID

IS_LOCN        5          COLHDG('Location' 'ID')

This 5 character value is used to identify the distribution center where this product is being replenished.

Examples:    Loc ID    Location name
             01        Charlotte, NC
             02        Raleigh, NC

             001       Columbia, SC
             002       New York, NY
             003       Chicago, IL

             KTY01     Lexington, KY
             TEX01     Houston, TX
             TEX02     Dallas, TX

Buy Group ID

IS_BUYR        5          COLHDG('Buy' 'group' 'ID')

Identify the Buy Group for this supplier record.

Supplier ID

IS_SUPL       10          COLHDG('Supplier' 'ID')

This value contains the product’s regular supplier ID.

Examples:    Supplier ID    Supplier Name
             ABCDEFGHIJ     ABC Company
             00010          Wizzard Mfg

Sub supplier ID

IS_SUPLSUB     10          COLHDG('Sub' 'supplier' 'ID')

This value will allow a supplier to be sub-divided into separate sections for review purposes. Leave this value blank if all products are to be reviewed together.

Examples:    Supplier ID Sub ID  Supplier Name
             ABCDEFGHIJ  FROZEN  ABC Company A - Frozen   
             ABCDEFGHIJ  FRIDGE  ABC Company B - Fridge
             ABCDEFGHIJ  DRY     ABC Company C - Dry
             00010       PINTS   Wizzard Mfg 3 - Pints
             00010       QUARTS  Wizzard Mfg 2 - Quarts
             00010       GALLONS Wizzard Mfg 1 - Gallons

Supplier Transaction Birth

IS_BIRTH     10  L       COLHDG('Supplier' 'trans' 'birth')

This is the date this file was built for the supplier. This will be created automatically.

Supplier Name

IS_NAME       40          COLHDG('Supplier' 'Name')

This value contains the name of the supplier.

Lead time In Days

IS_LEADTM      3  0       COLHDG('Lead' 'time' 'in days')

This value signifies the lead time for the supplier in days.

Order Cycle In Days

IS_ORCYCLE     3  0       COLHDG('Order cycle' 'in days')

This value contains the order cycle for the supplier in days.

K3S Application Integration

K_INTSUPL - Supplier Interface File