BEGIN DATA BASE SALES ;
PASSWORDS:
11 CREDIT ;
12 BUYER ;
13 dockhand;
14 CLERK ;
18 manager ;
ITEMS:
CITY , X12(12,13,14/11);
CREDIT-RATING , R2(/14);
CUSTOMER# , J2;
DATE , X6;
DELIVERED-DATE , X6(/14);
FIRST-NAME , X10(14/11);
INITIAL , U2(14/11);
LAST-NAME , X16(14/11);
LAST-SHIP-DATE , X6(12/);
LOCATION-BIN , Z2(/13);
ON-HAND-QTY , J2(14/12);
OTHER-VENDORS , 3X16;
PART-INFO , X60;
PRICE , J2(14/);
PRODUCT# , U8;
PRODUCT-DESCRIPT , X20;
PURCHASED-DATE , X6(11/14);
QUANTITY , I1(/14);
STATE , X2(12,13,14/11);
STREET , X26(12,13,14/11);
TAX , J2(14/);
TOTAL , J2(11,14/);
UNIT-COST , P8(/12);
VENDOR , X16(12,13/);
ZIP , X6(12,13,14/11);
SETS:
NAME: DATE-MASTER ,A;
ENTRY: DATE (3) ;
CAPACITY: 365(19);
NAME: CUSTOMER ,M(14/11,18);
ENTRY: CUSTOMER# (1) ,
LAST-NAME ,
FIRST-NAME ,
INITIAL ,
STREET ,
CITY ,
STATE ,
ZIP ,
CREDIT-RATING ;
CAPACITY: 201(7);
NAME: PRODUCT ,M(13,14/12,18);
ENTRY: PRODUCT# (2) ,
PRODUCT-DESCRIPT ;
CAPACITY: 300(16);
NAME: VENDOR ,M(13/12,18);
ENTRY: VENDOR (1) ,
STREET ,
CITY ,
STATE ,
ZIP ;
CAPACITY: 201(12);
NAME: INVENTORY ,D(12,14/13,18);
ENTRY: PRODUCT# ( PRODUCT ),
ON-HAND-QTY ,
VENDOR (!VENDOR ),
OTHER-VENDORS ,
UNIT-COST ,
LAST-SHIP-DATE ( DATE-MASTER ),
LOCATION-BIN ,
PART-INFO ;
CAPACITY: 452(4);
NAME: SALES ,D(11/14,18);
ENTRY: CUSTOMER# ( CUSTOMER (PURCHASED-DATE )),
PRODUCT# (!PRODUCT ),
QUANTITY ,
PRICE ,
TAX ,
TOTAL ,
PURCHASED-DATE ( DATE-MASTER ),
DELIVERED-DATE ( DATE-MASTER );
CAPACITY: 504(14);
END.
|