Field Listing for Table ENTITYMASTER

Field:ENTITYNAME Type: VARCHAR Length: 50
Field:BUSINESSCATEGORY Type: VARCHAR Length: 100
Field:PRODUCTSANDSERVICES Type: BLOB
Field:ENTITYADDRESS1 Type: VARCHAR Length: 50
Field:ENTITYADDRESS2 Type: VARCHAR Length: 50
Field:ENTITYADDRESS3 Type: VARCHAR Length: 50
Field:ENTITYPOSTALCODE Type: VARCHAR Length: 20
Field:ENTITYSTATE Type: VARCHAR Length: 20
Field:ENTITYCITY Type: VARCHAR Length: 30
Field:ENTITYCOUNTRY Type: VARCHAR Length: 30
Field:PRIMARYCONTACT Type: VARCHAR Length: 100
Field:ENTITYPHONE Type: VARCHAR Length: 20
Field:ENTITYFAX Type: VARCHAR Length: 20
Field:ENTITYEMAIL Type: VARCHAR Length: 100
Field:ENTITYMOBILE Type: VARCHAR Length: 20
Field:ENTITYWEB Type: VARCHAR Length: 100
Field:ENTITYNOTES Type: BLOB
Field:PHYSICALADDRESS1 Type: VARCHAR Length: 50
Field:PHYSICALADDRESS2 Type: VARCHAR Length: 50
Field:PHYSICALADDRESS3 Type: VARCHAR Length: 50
Field:PHYSICALPOSTALCODE Type: VARCHAR Length: 20
Field:PHYSICALSTATE Type: VARCHAR Length: 20
Field:PHYSICALCITY Type: VARCHAR Length: 30
Field:PHYSICALCOUNTRY Type: VARCHAR Length: 30
Field:ADDITIONALFIELD_1 Type: VARCHAR Length: 30
Field:ADDITIONALFIELD_2 Type: VARCHAR Length: 30
Field:ADDITIONALFIELD_3 Type: VARCHAR Length: 30
Field:ADDITIONALFIELD_4 Type: VARCHAR Length: 30
Field:ADDITIONALFIELD_5 Type: VARCHAR Length: 30
Field:ADDITIONALFIELD_6 Type: VARCHAR Length: 30
Field:ADDITIONALFIELD_7 Type: VARCHAR Length: 30
Field:ADDITIONALFIELD_8 Type: VARCHAR Length: 30
Field:ADDITIONALDATEFIELD_1 Type: DATE
Field:ADDITIONALDATEFIELD_2 Type: DATE
Field:ADDITIONALDATEFIELD_3 Type: DATE
Field:ADDITIONALDATEFIELD_4 Type: DATE
Field:ADDITIONALDATEFIELD_5 Type: DATE
Field:ADDITIONALDATEFIELD_6 Type: DATE
Field:ADDITIONALDATEFIELD_7 Type: DATE
Field:ADDITIONALDATEFIELD_8 Type: DATE
Field:SAMEPOSTALANDPHYSICAL Type: BOOLEAN
Field:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:SYSUNIQUEID Type: DOUBLE
Field:SYSUSERCREATED Type: VARCHAR Length: 30
Field:SYSUSERMODIFIED Type: VARCHAR Length: 30