Input data for IGYTSALE

As input to our program, the distributor collected information about its customers, salespeople, and products, coded the information, and produced an input file.

This input file, called IGYTABLE, is loaded into three separate tables for use during transaction processing. The format of the file is as follows, with an explanation of the items below:

This image shows the input data format for the sample sales application. Link to detail.

  1. Record type
  2. Customer code
  3. Customer name
  4. Product code
  5. Product description
  6. Product unit price
  7. Salesperson number
  8. Salesperson name
  9. Date of hire
  10. Commission rate

The value of field 1 (C, P, or S) determines the format of the input record. The following sample shows a section of IGYTABLE:


S1111Edyth Phillips 062484042327
S1122Chuck Morgan   052780084425
S1133Art Tung       022882061728
S1144Billy Jim Bob  010272121150
S1155Chris Preston  122083053377
S1166Al Willie Roz  111276100000
P01Footballs           0000620
P02Football Equipment  0032080
P03Football Uniform    0004910
P04Basketballs         0002220
P05Basketball Rim/Board0008830
P06Basketball Uniform  0004220
C01L. A. Sports
C02Gear Up
C03Play Outdoors
C04Sports 4 You
C05Sports R US
C06Stay Active
C07Sport Shop
C08Stay Sporty
C09Hot Sports
C10The Sportsman
C11Playing Ball
C12Sports Play
. . .

In addition, the distributor collected information about sales transactions. Each transaction represents an individual salesperson's sales to a particular customer. The customer can purchase from one to five items during each transaction. The transaction information is coded and put into an input file, called IGYTRANA. The format of this file is as follows, with an explanation of the items below:

This image shows the format of input file IGYTRANA. Link to detail.

  1. Sales order number
  2. Invoiced items (number of different items ordered)
  3. Date of sale (year month day hour minutes seconds)
  4. Sales area
  5. Salesperson number
  6. Customer code
  7. Date of shipment (year month day hour minutes seconds)
  8. Product code
  9. Quantity sold

Fields 8 and 9 occur one to eight times depending on the number of different items ordered (field 2). The following sample shows a section of IGYTRANA:


A00001119900227010101CNTRL VALLEY11442019900228259999
A00004119900310100530CNTRL VALLEY11441019900403150099
A00005119900418222409CNTRL VALLEY11441219900419059900
A00006119900523151010CNTRL VALLEY11442019900623250004
      419990324591515SAN DIEGO    11615        60200132200110522045100
B11114419901111003301SAN DIEGO   11661519901114260200132200110522041100
A00007119901115003205CNTRL VALLEY11332019901117120023
C00125419900118101527SF BAY AREA 11331519900120160200112200250522145111
B11116419901201132013SF BAY AREA 11331519901203060200102200110522045102
B11117319901201070833SAN Diego   1165661990120333020o132200120522041100
B11118419901221191544SAN DIEGO   11661419901223160200142200130522040300
B11119419901210211544SAN DIEGO   11221219901214060200152200160522050500
B11120419901212000816SAN DIEGO   11220419901213150200052200160522040100
B11121419901201131544SAN DIEGO   11330219901203120200112200140522250100
B11122419901112073312SAN DIEGO   11221019901113100200162200260522250100
B11123919901110123314SAN DIEGO   11660919901114260200270500110522250100140010
B11124219901313510000SAN DIEGO   116611        1 0200042200120a22141100
B11125419901215012510SAN DIEGO   11661519901216110200162200130522141111
B11126119901111000034SAN DIEGO   11331619901113260022
B11127119901110154100SAN DIEGO   11221219901113122000
B11128419901110175001SAN DIEGO   11661519901113260200132200160521041104
. . .