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