Database Table: BUYORG

Reserved for IBM internal use.

Column Name Column Type Column Description
BUADDR1 VARCHAR (50)
NULL
Reserved for IBM internal use.
BUADDR2 VARCHAR (50)
NULL
Reserved for IBM internal use.
BUADDR3 VARCHAR (50)
NULL
Reserved for IBM internal use.
BUCITY VARCHAR (30)
NULL
Reserved for IBM internal use.
BUCNTRY VARCHAR (30)
NULL
Reserved for IBM internal use.
BUEMAIL VARCHAR (80)
NULL
Reserved for IBM internal use.
BUFAX VARCHAR (80)
NULL
Reserved for IBM internal use.
BUFIELD1 VARCHAR (30)
NULL
Reserved for IBM internal use.
BUFIELD2 VARCHAR (30)
NULL
Reserved for IBM internal use.
BUFIELD3 VARCHAR (30)
NULL
Reserved for IBM internal use.
BUNAME VARCHAR (80)
NOT NULL
Reserved for IBM internal use.
BUPHONE VARCHAR (80)
NULL
Reserved for IBM internal use.
BURFNBR INTEGER
NOT NULL
Reserved for IBM internal use.
BUSHRFNBR INTEGER
NOT NULL
Reserved for IBM internal use.
BUSTATE VARCHAR (20)
NULL
Reserved for IBM internal use.
BUZIPC VARCHAR (20)
NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034847030 BURFNBR Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_130 BURFNBR BUADDR BABURFNBR Cascade
F_131 BURFNBR BUCONT BCBURFNBR Cascade
F_437 BURFNBR MBINFO MBBURFNBR Cascade
F_744 BURFNBR SHBTB SBBURFNBR Cascade