File: d_customer.srd
Size: 27257
Date: Mon, 28 Jan 2019 16:01:46 +0100
$PBExportHeader$d_customer.srd
release 12.6;
datawindow(units=0 timer_interval=0 color=1073741824 brushmode=0 transparency=0 gradient.angle=0 gradient.color=8421504 gradient.focus=0 gradient.repetition.count=0 gradient.repetition.length=100 gradient.repetition.mode=0 gradient.scale=100 gradient.spread=100 gradient.transparency=0 picture.blur=0 picture.clip.bottom=0 picture.clip.left=0 picture.clip.right=0 picture.clip.top=0 picture.mode=0 picture.scale.x=100 picture.scale.y=100 picture.transparency=0 processing=1 HTMLDW=no print.printername="" print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 0 print.canusedefaultprinter=yes print.prompt=no print.buttons=no print.preview.buttons=no print.cliptext=no print.overrideprintjob=no print.collate=yes print.background=no print.preview.background=no print.preview.outline=yes hidegrayline=no showbackcoloronxp=no picture.file="" grid.lines=0 grid.columnmove=no selected.mouse=no )
header(height=64 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
summary(height=0 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
footer(height=0 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
detail(height=72 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
table(column=(type=long update=yes updatewhereclause=yes key=yes name=id dbname="customer.id" )
 column=(type=char(15) update=yes updatewhereclause=yes name=fname dbname="customer.fname" )
 column=(type=char(20) update=yes updatewhereclause=yes name=lname dbname="customer.lname" )
 column=(type=char(35) update=yes updatewhereclause=yes name=address dbname="customer.address" )
 column=(type=char(20) update=yes updatewhereclause=yes name=city dbname="customer.city" )
 column=(type=char(2) update=yes updatewhereclause=yes name=state dbname="customer.state" )
 column=(type=char(10) update=yes updatewhereclause=yes name=zip dbname="customer.zip" )
 retrieve="PBSELECT(TABLE(NAME=~"customer~") COLUMN(NAME=~"customer.id~")COLUMN(NAME=~"customer.fname~")COLUMN(NAME=~"customer.lname~")COLUMN(NAME=~"customer.address~")COLUMN(NAME=~"customer.city~")COLUMN(NAME=~"customer.state~")COLUMN(NAME=~"customer.zip~"))" update="customer" updatewhere=1 updatekeyinplace=no )
data( 101,"Michaels","Devlin","3114 Pioneer Avenue","Rutherford","NJ","07070    ", 102,"Beth","Reiser","1033 Whippany Road ","New York","NY","10154", 103,"Erin","Niedringhaus","1990 Windsor Street ","Paoli","PA","19301", 104,"Meghan","Mason","550 Dundas Street East","Knoxville","TN","37919", 105,"Laura","McCarthy","1210 Highway 36 ","Carmel","IN","46032", 106,"Paul","Phillips","2000 Cherry Creek N. Dr. ","Middletown","CT","64579    ", 107,"Kelly","Colburn","18131 Vallco Parkway ","Raleigh","NC","27695-7209", 108,"Matthew","Goforth","11801 Wayzata Blvd. ","Chattanooga","TN","37421", 109,"Jessie","Gagliardo","2800 Park Avenue ","Hull","PQ","K1A 0H3", 110,"Michael","Agliori","13705 North Glebe Road ","Columbus","OH","43216", 111,"Dylan","Ricci","14700 Prosperity Avenue ","Syracuse","NY","13202", 112,"Shawn","McDonough","15175 S Main Street ","Brooklyn Park","MN","55428", 113,"Samuel","Kaiser","404 Bristol Street ","Minneapolis","MN","55041", 114,"Shane","Chopp","9925 Summer Street ","St Paul","MN","55104", 115,"Shannon","Phillips","20555 Cory Road ","St Paul","MN","55114", 116,"Brian","Gugliuzza","39111 Wyman Street ","Mamaroneck","NY","10543", 117,"Meredith","Morgan","9191 Galveston Drive ","Westerville","OH","43081", 118,"Kristina","Sanford","2196th Street ","Raleigh","NC","27695-7209", 119,"Tomm","Smith","3 Post Oak Blvd. ","South Laguna","CA","92677", 120,"Gertrude","Stein","4 Amon Carter Blvd. ","Elmsford","NY","10523", 121,"Pete","Elkins","23 Lawerence Street ","Carmel","IN","46032", 122,"Al","Dente","25 N.E. 38th Place ","McLean","VA","22102", 123,"Amanda","Lin","25 North Pine Grove ","Winnipeg","MB","R3C 3V6", 124,"Fanny","Farmer","110 Barnard Lane ","Wilmington","MA","01887", 125,"Sidney","Smelledge","125 Merritt Drive ","St. Louis","MO","63101", 126,"Sam","Ovar","5 Lindenwood Drive ","San Francisco","CA","94105", 127,"Mary","Lamm","10 McKinney","Sarasota","FL","34243", 128,"Hardy","Mums","11 5th Avenue S.W. ","Boston","MA","02106", 129,"Heinz","Fahrvergnugen","11 Armagh Street ","Baltimore","MD","21202", 130,"Sal","Monella","20th Eastlake Avenue  ","New Berlin","WI","53141", 131,"Daljit","Sinnot","145 Presidents Landing ","Bohemia","NY","11716", 132,"Marilyn","King","167 South Ulster","Fort Wayne","IN","46801", 133,"Moe","Bilhome","180 W. Colfax Avenue ","Burbank","CA","91505", 134,"Paddy","O'Furniture","1180 W. Las Colinas ","Mogadore","OH","44260", 135,"Belinda","Clarke","204 Constitution Avenue ","New York","NY","10001", 136,"Tommie","Wooten","1322 Hing Wai Building ","Plymouth","MN","55447", 137,"Polly","Morfek","879 Hopyard Road ","Ft. Wayne","IN","46808", 138,"Regus","Patoff","22 James Way ","Burlington","ON","L7N 5L1", 139,"Jai","Dimitros","236 Marineship Way ","Boston","MA","02201", 140,"Thomas","Thumb","250 North Vine Street ","Salt Lake City","UT","84180", 141,"Peter","Pyper","408 Beta Mall","Fort Wayne","IN","46801", 142,"Alfredo","Margolis","400 Bloor Street East","Kansas City","MO","64114", 143,"Peter","Piper","3100 Stevens Creek Blvd. ","Winnipeg","MB","R3C 3V6", 144,"Fangmei","Wan","4513 E. Hillsdale ","Stowe","MA","01775", 145,"John","Doe","357 Wellworth Ave ","Fairfax","VA","22030", 146,"Alberto","Yost","375 White Horse Road ","Spokane","WA","99216", 147,"Manoj","Lela","501 Third Avenue North ","Wood Bridge","NJ","07095", 148,"Beth","Crooker","501 College Road ","Winnepeg","MB","R3C 2P4", 149,"Hans","Uhnfitte","3700 West Wacker Dr ","Winnepeg","MB","R3C `2P4", 150,"Carl","Mason","1000 Powell Street ","Don Mills","ON","M3C 3N4", 151,"Balwinder","Sinitskaya","1133 Century Blvd ","Overland Park","KS","66210", 152,"Davey","Jones","1218 Inelt Business Ctr. ","Austin","NY","11746", 153,"Paul","Jones","1221 Innovation Drive ","Cincinnati","OH","45202", 154,"Marvin","Smythe","1291 North 27th Ave ","North Miami","FL","33181", 155,"Milo","Phipps","1380 Osterbrogade ","Lakewood","OH","44107", 156,"Sue","DuCode","1515 San Thomas Avenue ","St Louis","MO","63131", 157,"William","Watcom","1615 Silver Lake Road ","Chicago","IL","60645", 158,"Jack","Cass","3626 West Court Street ","Lexington","MA","02173", 159,"Rick","Shaw","3715 West Loop South ","West Bloomfield","MI","48324", 160,"Clara","Nette","3773 Wilshire Blvd ","Port Washington","NY","11050", 161,"Gene","Poole","3860 Vreeland Road ","Washington","DC","20581", 162,"Melba","Toste","3930 51st Ave North ","Powell","OH","43065", 163,"R.I.","Peese","4199 Buckingham ","Mississauga","ON","L4W 2S6", 164,"Aram","Najarian","200 Cambridge Center ","Danbury","CT","6811", 165,"Tamara","Mournen","42 Choke Cherry Road ","Ft. Wayne","IN","46808", 166,"Malcolm","Naddem","4255 Commerce Parkway ","Buford","GA","30518", 167,"Nicklas","Cara","1700 State Highway 249 ","Lakewood","OH","44107", 168,"Almen","de Joie","1750 Sweitzer Lane ","Huntington Beach","CA","92649", 169,"Laura","Terlemezian","240 First Street","Matthews","NC","28105", 170,"Manh","Neubauer","2140 Haddington Street ","Jacksonville","FL","32206", 171,"Vincent","Nahra","2180 Harwin Drive ","West Chicago","IL","60185-1120", 172,"Grace","Perez","395 Market Street ","Landover","MA","20785", 173,"Grover","Pendelton","239 Merritt Drive ","Clarksburg","MD","20871", 174,"Anabai","Zoblotny","12600 N.E. Airport Way ","Denver","CO","80225", 175,"Tawfik","Perkins","1270 N.W. 7th Avenue ","Victoria","BC","V8W 2B7", 176,"Helen","Shumovich","2800 Park Plaza #1800 ","Baltimore","MD","21209", 177,"Joseph","Zubenko","314 Stonehollow Drive ","Raleigh","NC","27695", 178,"Suresh","Naidu","321 Sycamore Drive","New London","CT","6320", 179,"Marsha","Nguyen","44 Dunlaney Gate Circle ","Miramar","FL","33027", 180,"Edith","Peros","50 Market Street ","Rochester","NY","14624", 181,"Emunah","Teeven","101 Wilshire Blvd. ","Washington","DC","20240", 182,"Leilani","Gardner","103 Campus Drive ","Acworth","CA","30102", 183,"Marilyn","Nakagama","105 Central Avenue ","Winter Park","FL","32792", 184,"Anoush","Serafina","4643 Greenway Place ","Overland Park","KS","66210", 185,"Serop","Belmont","4867 Hadley Lane","Hartford","CT","6115", 186,"Thao","Tenorio","5000 Midway Road ","Kansas City","MO","64105", 187,"Sebouh","Bensoul","8024 Van Ness Way ","Peoria","IL","61614", 188,"Vartan","Berenberg","1020 110th Avenue N.E. ","Northbrook","IL","60062", 189,"Herbert","Berejiklian","1535 Municiple Drive ","Cambridge","MA","02142", 190,"Randy","Arlington","1635 N Franklin Turnpike ","Detriot","MI","48214", 191,"Marta","Richards","10707 Northridge Road ","Miami","FL","33172", 192,"Rosanna","Beldov","1889 Northside Parkway ","Sioux City","IA","51102", 193,"Alfred","Newman","2721 Northeast 99th Way ","Kansas City","MO","64114", 194,"Jen-Chang","Chin","2770 Oyster Point Blvd ","Fairfax","VA","02203", 195,"Li-Hui","Jyh-Hwa","301 Potrero Avenue ","Atlanta","GA","30303", 196,"Ling Ling","Andrews","303 Roe Avenue ","Edmonton","AB","T5N 1S5", 197,"Maio","Chermak","330 Sycamore Road ","Atlanta","GA","30346", 198,"Sheng","Chen","1801 W. Six Mile Road ","San Ramon","CA","94583", 199,"Ella","Mentary","452 Embarcadero Center ","Rochester","NY","14644", 200,"Helen","Chau","1900 Yamato Road ","North Potomac","MD","20878", 201,"Amit","Singh","1986 Yonge Street","Overland Park","KS","66210", 202,"Bubba","Murphy","2401 N. 44th Street ","White Plains","NY","10604", 203,"Salton","Pepper","401 Boylston Street","Madison","WI","53705", 204,"Robert","Spaid","333 Town Center ","Jackson","MI","49202", 205,"Elmo","Smythe","2815 Plaza Street ","East Douglas","MA","01516", 206,"JohnPaul","Jones","2999 Post Oak Blvd. ","Reston","VA","22091", 207,"Wen-Chu","Donchek","2406 N. Mission ","Lisle","IL","60532", 208,"Derek","Suess","234 King George Drive","Albany","NY","12208", 209,"Laura","Boyle","130 Pillsbury Road","Los Altos","CA","94022", 220,"Lewis N.","Clark","245 Expedition Hwy","Laramie","WY","85293", 221,"Jack ","Johnson","45 Shoebox Lane","Santa Fe","NM","40420", 222,"Jane","Doe","57 Disk Drive","San Jose","CA","94020", 330,"John","Glenn","90 Rocket Pad","Orlando","FL","32200", 331,"Dominic","Johansen","33 West Street","New Orleans","LA","33552", 332,"Stanley","Jue","67 Bronco Circle","Houston","TX","77057", 333,"Harry","Jones","25 Software Rd","San Jose","CA","94020", 440,"Marie","Curie","210 Helping Hand Hwy","LeCroix","MA","02140", 441,"Elizibeth","Bordon","87 Grinding Stone Rd","New Bedford","MA","01801", 444,"Len","Manager","23 Network Way","Dallas","TX","76552", 550,"Tony","Antolini","6678 Sliver Road","Fargo","ND","60500", 551,"Tom","Cruz","789 Far Away Lane","Eugene","OR","98524", 552,"Janice","O'Toole","654 West Hill","Nashville","TN","37320", 553,"Stevie","Nickolas","77 Recordings Circle","Tacoma","WA","96521", 555,"Philipe","Fernandez","99 Main Street","Los Angeles","CA","90205", 661,"Jennifer","Stutzman","3 Back Pages Lane","Missola","IL","60505", 665,"William","Thompson","91 Washington Street","Manchester","NY","11700",) 
text(band=header alignment="0" text="Customer ID" border="0" color="33554432" x="9" y="8" height="52" width="370" html.valueishtml="0"  name=id_t visible="1"  font.face="MS Sans Serif" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="First Name" border="0" color="33554432" x="389" y="8" height="52" width="411" html.valueishtml="0"  name=fname_t visible="1"  font.face="MS Sans Serif" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="Last Name" border="0" color="33554432" x="809" y="8" height="52" width="526" html.valueishtml="0"  name=lname_t visible="1"  font.face="MS Sans Serif" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="Address" border="0" color="33554432" x="1344" y="8" height="52" width="869" html.valueishtml="0"  name=address_t visible="1"  font.face="MS Sans Serif" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="City" border="0" color="33554432" x="2222" y="8" height="52" width="526" html.valueishtml="0"  name=city_t visible="1"  font.face="MS Sans Serif" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="State" border="0" color="33554432" x="2757" y="8" height="52" width="169" html.valueishtml="0"  name=state_t visible="1"  font.face="MS Sans Serif" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
text(band=header alignment="0" text="Zip Code" border="0" color="33554432" x="2935" y="8" height="52" width="347" html.valueishtml="0"  name=zip_t visible="1"  font.face="MS Sans Serif" font.height="-8" font.weight="700"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=1 alignment="0" tabsequence=32766 border="0" color="33554432" x="9" y="8" height="60" width="370" format="[general]" html.valueishtml="0"  name=id  tag="Unique Identification number of the customer" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=2 alignment="0" tabsequence=32766 border="0" color="33554432" x="389" y="8" height="60" width="411" format="[general]" html.valueishtml="0"  name=fname  tag="First name of the customer" visible="1" edit.limit=15 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=3 alignment="0" tabsequence=32766 border="0" color="33554432" x="809" y="8" height="60" width="526" format="[general]" html.valueishtml="0"  name=lname  tag="Last name of the customer" visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=4 alignment="0" tabsequence=32766 border="0" color="33554432" x="1344" y="8" height="60" width="869" format="[general]" html.valueishtml="0"  name=address  tag="Mailing address of the customer" visible="1" edit.limit=35 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=5 alignment="0" tabsequence=32766 border="0" color="33554432" x="2222" y="8" height="60" width="526" format="[general]" html.valueishtml="0"  name=city  tag="City where the customer is located" visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=6 alignment="0" tabsequence=32766 border="0" color="33554432" x="2757" y="8" height="60" width="169" format="[general]" html.valueishtml="0"  name=state  tag="State where the customer is located" visible="1" edit.name="StateCode" dddw.name=d_dddw_states dddw.displaycolumn=state_id dddw.datacolumn=state_id dddw.percentwidth=550 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any dddw.vscrollbar=yes  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
column(band=detail id=7 alignment="0" tabsequence=32766 border="0" color="33554432" x="2935" y="8" height="60" width="347" format="[general]" html.valueishtml="0"  name=zip  tag="Zip Code where the customer is located" visible="1" edit.name="ZipCode" editmask.mask="#####-####" editmask.focusrectangle=no  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
htmltable(border="1" )
htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" pagingmethod=0 generatedddwframes="1" )
xhtmlgen() cssgen(sessionspecific="0" )
xmlgen(inline="0" )
xsltgen()
jsgen()
export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
import.xml()
export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )
export.xhtml()