addressmultilinepoview

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

POID

INT

10

0

po.id

Implied Constraint

R

REMITADDRESS1

VARCHAR

90

√

null

REMITADDRESS2

VARCHAR

90

√

null

REMITADDRESS3

VARCHAR

90

√

null

SHIPTOADDRESS1

VARCHAR

90

√

null

SHIPTOADDRESS2

VARCHAR

90

√

null

SHIPTOADDRESS3

VARCHAR

90

√

null

Relationships

Close relationships within degrees of separation

View Definition

select `fishbowl`.`po`.`id` AS `POID`,(case when (locate('\n',`fishbowl`.`po`.`remitAddress`) > 0) then substr(`fishbowl`.`po`.`remitAddress`,1,(locate('\n',`fishbowl`.`po`.`remitAddress`) - 1)) else `fishbowl`.`po`.`remitAddress` end) AS `REMITADDRESS1`,(case when ((locate('\n',`fishbowl`.`po`.`remitAddress`) > 0) and (locate('\n',`fishbowl`.`po`.`remitAddress`,(locate('\n',`fishbowl`.`po`.`remitAddress`) + 1)) = 0)) then substr(`fishbowl`.`po`.`remitAddress`,(locate('\n',`fishbowl`.`po`.`remitAddress`) + 1)) when ((locate('\n',`fishbowl`.`po`.`remitAddress`) > 0) and (locate('\n',`fishbowl`.`po`.`remitAddress`,(locate('\n',`fishbowl`.`po`.`remitAddress`) + 1)) > 0)) then substr(`fishbowl`.`po`.`remitAddress`,(locate('\n',`fishbowl`.`po`.`remitAddress`) + 1),(locate('\n',`fishbowl`.`po`.`remitAddress`,(locate('\n',`fishbowl`.`po`.`remitAddress`) + 1)) - (locate('\n',`fishbowl`.`po`.`remitAddress`) + 1))) else '' end) AS `REMITADDRESS2`,(case when (locate('\n',`fishbowl`.`po`.`remitAddress`,(locate('\n',`fishbowl`.`po`.`remitAddress`) + 1)) > 0) then substr(`fishbowl`.`po`.`remitAddress`,(locate('\n',`fishbowl`.`po`.`remitAddress`,(locate('\n',`fishbowl`.`po`.`remitAddress`) + 1)) + 1)) else '' end) AS `REMITADDRESS3`,(case when (locate('\n',`fishbowl`.`po`.`shipToAddress`) > 0) then substr(`fishbowl`.`po`.`shipToAddress`,1,(locate('\n',`fishbowl`.`po`.`shipToAddress`) - 1)) else `fishbowl`.`po`.`shipToAddress` end) AS `SHIPTOADDRESS1`,(case when ((locate('\n',`fishbowl`.`po`.`shipToAddress`) > 0) and (locate('\n',`fishbowl`.`po`.`shipToAddress`,(locate('\n',`fishbowl`.`po`.`shipToAddress`) + 1)) = 0)) then substr(`fishbowl`.`po`.`shipToAddress`,(locate('\n',`fishbowl`.`po`.`shipToAddress`) + 1)) when ((locate('\n',`fishbowl`.`po`.`shipToAddress`) > 0) and (locate('\n',`fishbowl`.`po`.`shipToAddress`,(locate('\n',`fishbowl`.`po`.`shipToAddress`) + 1)) > 0)) then substr(`fishbowl`.`po`.`shipToAddress`,(locate('\n',`fishbowl`.`po`.`shipToAddress`) + 1),(locate('\n',`fishbowl`.`po`.`shipToAddress`,(locate('\n',`fishbowl`.`po`.`shipToAddress`) + 1)) - (locate('\n',`fishbowl`.`po`.`shipToAddress`) + 1))) else '' end) AS `SHIPTOADDRESS2`,(case when (locate('\n',`fishbowl`.`po`.`shipToAddress`,(locate('\n',`fishbowl`.`po`.`shipToAddress`) + 1)) > 0) then substr(`fishbowl`.`po`.`shipToAddress`,(locate('\n',`fishbowl`.`po`.`shipToAddress`,(locate('\n',`fishbowl`.`po`.`shipToAddress`) + 1)) + 1)) else '' end) AS `SHIPTOADDRESS3` from `fishbowl`.`po`

Possibly Referenced Tables/Views

po