Reference > Database > WebSphere Commerce database tables > B
WebSphere Commerce database table: BUYORG
Reserved for IBM internal use.
Column Name Column Type Description BURFNBR INTEGER NOT NULL Reserved for IBM internal use. BUNAME VARCHAR(80) NOT NULL Reserved for IBM internal use. BUSHRFNBR INTEGER NOT NULL Reserved for IBM internal use. BUPHONE VARCHAR(80) Reserved for IBM internal use. BUEMAIL VARCHAR(80) Reserved for IBM internal use. BUFAX VARCHAR(80) Reserved for IBM internal use. BUADDR1 VARCHAR(50) Reserved for IBM internal use. BUADDR2 VARCHAR(50) Reserved for IBM internal use. BUADDR3 VARCHAR(50) Reserved for IBM internal use. BUCITY VARCHAR(30) Reserved for IBM internal use. BUSTATE VARCHAR(20) Reserved for IBM internal use. BUCNTRY VARCHAR(30) Reserved for IBM internal use. BUZIPC VARCHAR(20) Reserved for IBM internal use. BUFIELD1 VARCHAR(30) Reserved for IBM internal use. BUFIELD2 VARCHAR(30) Reserved for IBM internal use. BUFIELD3 VARCHAR(30) Reserved for IBM internal use. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030305620 BURFNBR Primary Key
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_130 BABURFNBR BUADDR BURFNBR Cascade F_131 BCBURFNBR BUCONT BURFNBR Cascade F_437 MBBURFNBR MBINFO BURFNBR Cascade F_744 SBBURFNBR SHBTB BURFNBR Cascade _vcc_freeselect_bottom_