Laserfiche WebLink
Statement of Work <br />—15 <br />3. ACCELA AUTOMATION STANDARD TABLE FOR OWNERS ASSOCIATED TO <br />PARCELS <br />PARCEL OWNER Table <br />Seq <br />Input Field <br />Output ABPT Label <br />Field <br />Data type <br />Description of Data <br />1 <br />SOURCE_SEQ_NBR* <br />Source_seq_nbr <br />Number <br />Source sequence number, <br />which identifies client's data. <br />2 <br />L1_PARCEL_NBR* <br />Parcel Number <br />Varchar(24) <br />Parcel number to associate <br />to the owner <br />3 <br />Ll–OWNER–STATUS <br />Owner status <br />Varchar(l) <br />Valid values are'I' or'A'. If <br />'I' then T, otherwise will load <br />A' <br />4 <br />1-1_OWNER TITLE <br />Owner title <br />Varchar255 <br />5 <br />L1 OWNER FULL NAME' <br />Owner 1 <br />Varchar 220 <br />Primary owner. <br />6 <br />ISPRIMARY <br />Primary <br />Varchar(1) <br />'Y' for primary owner. 'N' for <br />all other owners. If null will <br />default to 'N.' <br />A parcel can have multiple <br />owners, but only one owner <br />can be prima . <br />7 <br />L1_OWNER_FNAME <br />Owner first <br />name <br />Varchar(70) <br />8 <br />1-1_OWNER MNAME <br />Middle name <br />Varchar 70 <br />9 <br />1-1_OWNER LNAME <br />Last name <br />Varchar 70 <br />10 <br />L1_ADDRESS1 <br />Address 1 <br />Varchar 40 <br />11 <br />L1_ADDRESS2 <br />Address 2 <br />Varchar 40 <br />12 <br />L1_ADDRESS3 <br />Address 3 <br />Varchar 40 <br />13 <br />1 1-1_CITY <br />I City <br />Varchar 30 <br />14 <br />1-1_STATE <br />State <br />Varchar 30 <br />15 <br />L1–ZIP <br />Zip <br />Varchar10 <br />16 <br />Ll–COUNTRY <br />Owner country <br />Varchar30 <br />17 <br />1-1_PHONE <br />Phone <br />Varchar 40 <br />18 <br />1-1_FAX <br />Fax <br />Varchar 40 <br />19 <br />L1–MAIL ADDRESS1 <br />Mail address 1 <br />Varchar 100 <br />20 <br />L1–MAIL ADDRESS2 <br />Mail address 2 <br />Varchar 40 <br />21 <br />L1–MAIL ADDRESS3 <br />Mail Address 3 <br />Varchar 40 <br />22 <br />1-1—MAIL—CITY <br />Mail City <br />Varchar 32 <br />23 <br />1-1_MAIL STATE <br />Mail State <br />Varchar 30 <br />24 <br />Ll MAIL ZIP <br />Mail zip <br />Varchar 10 <br />25 <br />1-1_MAIL COUNTRY <br />Mail country <br />Varchar 30 <br />26 <br />L1—TAX—ID <br />Tax id <br />Varchar 20 <br />27 <br />Ll–EVENT <br />Event id <br />Number <br />28 <br />L1 EMAIL <br />Email <br />Varchar 70 <br />29 <br />Ll–PHONE–COUNTRY–CODE <br />Phone country <br />code <br />Varchar(3) <br />Phone number country code <br />30 <br />Ll–FAX–COUNTRY–CODE <br />Fax country <br />code <br />Varchar(3) <br />Fax number country code <br />9 2015 Accela Inc. Page 29 <br />