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