|
In this section: |
VIDEOTR2 contains sample data about customer, rental, and purchase information for a video rental business. It consists of four segments.
FILENAME=VIDEOTR2, SUFFIX=FOC SEGNAME=CUST, SEGTYPE=S1 FIELDNAME=CUSTID, ALIAS=CIN, FORMAT=A4, $ FIELDNAME=LASTNAME, ALIAS=LN, FORMAT=A15, $ FIELDNAME=FIRSTNAME, ALIAS=FN, FORMAT=A10, $ FIELDNAME=EXPDATE, ALIAS=EXDAT, FORMAT=YMD, $ FIELDNAME=PHONE, ALIAS=TEL, FORMAT=A10, $ FIELDNAME=STREET, ALIAS=STR, FORMAT=A20, $ FIELDNAME=CITY, ALIAS=CITY, FORMAT=A20, $ FIELDNAME=STATE, ALIAS=PROV, FORMAT=A4, $ FIELDNAME=ZIP, ALIAS=POSTAL_CODE, FORMAT=A9, $ FIELDNAME=EMAIL, ALIAS=EMAIL, FORMAT=A18, $ SEGNAME=TRANSDAT, SEGTYPE=SH1, PARENT=CUST FIELDNAME=TRANSDATE, ALIAS=OUTDATE, FORMAT=HYYMDI, $ SEGNAME=SALES, SEGTYPE=S2, PARENT=TRANSDAT FIELDNAME=TRANSCODE, ALIAS=TCOD, FORMAT=I3, $ FIELDNAME=QUANTITY, ALIAS=NO, FORMAT=I3S, $ FIELDNAME=TRANSTOT, ALIAS=TTOT, FORMAT=F7.2S, $ SEGNAME=RENTALS, SEGTYPE=S2, PARENT=TRANSDAT FIELDNAME=MOVIECODE, ALIAS=MCOD, FORMAT=A6, INDEX=I, $ FIELDNAME=COPY, ALIAS=COPY, FORMAT=I2, $ FIELDNAME=RETURNDATE, ALIAS=INDATE, FORMAT=YMD, $ FIELDNAME=FEE, ALIAS=FEE, FORMAT=F5.2S, $
SECTION 01
STRUCTURE OF FOCUS FILE VIDEOTR2 ON 05/15/03 AT 16.45.48
CUST
01 S1
**************
*CUSTID **
*LASTNAME **
*FIRSTNAME **
*EXPDATE **
* **
***************
**************
I
I
I
I TRANSDAT
02 I SH1
**************
*TRANSDATE **
* **
* **
* **
* **
***************
**************
I
+-----------------+
I I
I SALES I RENTALS
03 I S2 04 I S2
************** **************
*TRANSCODE ** *MOVIECODE **I
*QUANTITY ** *COPY **
*TRANSTOT ** *RETURNDATE **
* ** *FEE **
* ** * **
*************** ***************
************** **************