In this section: |
Gotham Grinds is a group of data sources that contain sample data about a specialty items company.
FILENAME=GGDEMOG, SUFFIX=FOC SEGNAME=DEMOG01, SEGTYPE=S1 FIELD=ST, ALIAS=E02, FORMAT=A02, INDEX=I,TITLE='State', DESC='State',$ FIELD=HH, ALIAS=E03, FORMAT=I09, TITLE='Number of Households', DESC='Number of Households',$ FIELD=AVGHHSZ98,ALIAS=E04, FORMAT=I09, TITLE='Average Household Size', DESC='Average Household Size',$ FIELD=MEDHHI98, ALIAS=E05, FORMAT=I09, TITLE='Median Household Income', DESC='Median Household Income',$ FIELD=AVGHHI98, ALIAS=E06, FORMAT=I09, TITLE='Average Household Income', DESC='Average Household Income',$ FIELD=MALEPOP98,ALIAS=E07, FORMAT=I09, TITLE='Male Population', DESC='Male Population',$ FIELD=FEMPOP98, ALIAS=E08, FORMAT=I09, TITLE='Female Population', DESC='Female Population',$ FIELD=P15TO1998,ALIAS=E09, FORMAT=I09, TITLE='15 to 19', DESC='Population 15 to 19 years old',$ FIELD=P20TO2998,ALIAS=E10, FORMAT=I09, TITLE='20 to 29', DESC='Population 20 to 29 years old',$ FIELD=P30TO4998,ALIAS=E11, FORMAT=I09, TITLE='30 to 49', DESC='Population 30 to 49 years old',$ FIELD=P50TO6498,ALIAS=E12, FORMAT=I09, TITLE='50 to 64', DESC='Population 50 to 64 years old',$ FIELD=P65OVR98, ALIAS=E13, FORMAT=I09, TITLE='65 and over', DESC='Population 65 and over',$
SECTION 01 STRUCTURE OF FOCUS FILE GGDEMOG ON 05/15/03 AT 12.26.05 GGDEMOG 01 S1 ************** *ST **I *HH ** *AVGHHSZ98 ** *MEDHHI98 ** * ** *************** **************
FILENAME=GGORDER, SUFFIX=FOC,$ SEGNAME=ORDER01, SEGTYPE=S1,$ FIELD=ORDER_NUMBER, ALIAS=ORDNO1, FORMAT=I6, TITLE='Order,Number', DESC='Order Identification Number',$ FIELD=ORDER_DATE, ALIAS=DATE, FORMAT=MDY, TITLE='Order,Date', DESC='Date order was placed',$ FIELD=STORE_CODE, ALIAS=STCD, FORMAT=A5, TITLE='Store,Code', DESC='Store Identification Code (for order)',$ FIELD=PRODUCT_CODE, ALIAS=PCD, FORMAT=A4, TITLE='Product,Code', DESC='Product Identification Code (for order)',$ FIELD=QUANTITY, ALIAS=ORDUNITS, FORMAT=I8, TITLE='Ordered,Units', DESC='Quantity Ordered',$ SEGNAME=ORDER02, SEGTYPE=KU, PARENT=ORDER01, CRFILE=GGPRODS, CRKEY=PCD, CRSEG=PRODS01 ,$
SECTION 01 STRUCTURE OF FOCUS FILE GGORDER ON 05/15/03 AT 16.45.48 GGORDER 01 S1 ************** *ORDER_NUMBER** *ORDER_DATE ** *STORE_CODE ** *PRODUCT_CODE** * ** *************** ************** I I I I ORDER02 02 I KU .............. :PRODUCT_ID :K :PRODUCT_DESC: :VENDOR_CODE : :VENDOR_NAME : : : :............:
FILENAME=GGPRODS, SUFFIX=FOC SEGNAME=PRODS01, SEGTYPE=S1 FIELD=PRODUCT_ID, ALIAS=PCD, FORMAT=A4, INDEX=I, TITLE='Product,Code', DESC='Product Identification Code',$ FIELD=PRODUCT_DESCRIPTION, ALIAS=PRODUCT, FORMAT=A16, TITLE='Product', DESC='Product Name',$ FIELD=VENDOR_CODE, ALIAS=VCD, FORMAT=A4, INDEX=I, TITLE='Vendor ID', DESC='Vendor Identification Code',$ FIELD=VENDOR_NAME, ALIAS=VENDOR, FORMAT=A23, TITLE='Vendor Name', DESC='Vendor Name',$ FIELD=PACKAGE_TYPE, ALIAS=PACK, FORMAT=A7, TITLE='Package', DESC='Packaging Style',$ FIELD=SIZE, ALIAS=SZ, FORMAT=I2, TITLE='Size', DESC='Package Size',$ FIELD=UNIT_PRICE, ALIAS=UNITPR, FORMAT=D7.2, TITLE='Unit,Price', DESC='Price for one unit',$
SECTION 01 STRUCTURE OF FOCUS FILE GGPRODS ON 05/15/03 AT 12.26.05 GGPRODS 01 S1 ************** *PRODUCT_ID **I *PRODUCT_DESC**I *VENDOR_CODE ** *VENDOR_NAME ** * ** *************** **************
FILENAME=GGSALES, SUFFIX=FOC SEGNAME=SALES01, SEGTYPE=S1 FIELD=SEQ_NO, ALIAS=SEQ, FORMAT=I5, TITLE='Sequence#', DESC='Sequence number in database',$ FIELD=CATEGORY, ALIAS=E02, FORMAT=A11, INDEX=I, TITLE='Category', DESC='Product category',$ FIELD=PCD, ALIAS=E03, FORMAT=A04, INDEX=I, TITLE='Product ID', DESC='Product Identification code (for sale)',$ FIELD=PRODUCT, ALIAS=E04, FORMAT=A16, TITLE='Product', DESC='Product name',$ FIELD=REGION, ALIAS=E05, FORMAT=A11, INDEX=I, TITLE='Region', DESC='Region code',$ FIELD=ST, ALIAS=E06, FORMAT=A02, INDEX=I, TITLE='State', DESC='State',$ FIELD=CITY, ALIAS=E07, FORMAT=A20, TITLE='City', DESC='City',$ FIELD=STCD, ALIAS=E08, FORMAT=A05, INDEX=I, TITLE='Store ID', DESC='Store identification code (for sale)',$ FIELD=DATE, ALIAS=E09, FORMAT=I8YYMD, TITLE='Date', DESC='Date of sales report',$ FIELD=UNITS, ALIAS=E10, FORMAT=I08, TITLE='Unit Sales', DESC='Number of units sold',$ FIELD=DOLLARS, ALIAS=E11, FORMAT=I08, TITLE='Dollar Sales', DESC='Total dollar amount of reported sales',$ FIELD=BUDUNITS, ALIAS=E12, FORMAT=I08, TITLE='Budget Units', DESC='Number of units budgeted',$ FIELD=BUDDOLLARS, ALIAS=E13, FORMAT=I08, TITLE='Budget Dollars', DESC='Total sales quota in dollars',$
SECTION 01 STRUCTURE OF FOCUS FILE GGSALES ON 05/15/03 AT 12.26.05 GGSALES 01 S1 ************** *SEQ_NO ** *CATEGORY **I *PCD **I *PRODUCT **I * ** *************** **************
FILENAME=GGSTORES, SUFFIX=FOC SEGNAME=STORES01, SEGTYPE=S1 FIELD=STORE_CODE, ALIAS=E02, FORMAT=A05, INDEX=I, TITLE='Store ID', DESC='Franchisee ID Code',$ FIELD=STORE_NAME, ALIAS=E03, FORMAT=A23, TITLE='Store Name', DESC='Store Name',$ FIELD=ADDRESS1, ALIAS=E04, FORMAT=A19, TITLE='Contact', DESC='Franchisee Owner',$ FIELD=ADDRESS2, ALIAS=E05, FORMAT=A31, TITLE='Address', DESC='Street Address',$ FIELD=CITY, ALIAS=E06, FORMAT=A22, TITLE='City', DESC='City',$ FIELD=STATE, ALIAS=E07, FORMAT=A02, INDEX=I, TITLE='State', DESC='State',$ FIELD=ZIP, ALIAS=E08, FORMAT=A06, TITLE='Zip Code', DESC='Postal Code',$
SECTION 01 STRUCTURE OF FOCUS FILE GGSTORES ON 05/15/03 AT 12.26.05 GGSTORES 01 S1 ************** *STORE_CODE **I *STORE_NAME ** *ADDRESS1 ** *ADDRESS2 ** * ** *************** **************
|
Information Builders |