WebSphere Commerce database table: BUADDR

Reserved for IBM internal use.


Column Description(s):
Column NameColumn TypeDescription
BARFNBR INTEGER NOT NULL Reserved for IBM internal use.
BABURFNBR INTEGER NOT NULL Reserved for IBM internal use.
BACODE VARCHAR(17) NOT NULL Reserved for IBM internal use.
BACDTYPE CHAR(2) Reserved for IBM internal use.
BATYPE CHAR(2) NOT NULL Reserved for IBM internal use.
BANAME VARCHAR(80) Reserved for IBM internal use.
BAADDR1 VARCHAR(50) Reserved for IBM internal use.
BAADDR2 VARCHAR(30) Reserved for IBM internal use.
BAADDR3 VARCHAR(50) Reserved for IBM internal use.
BACITY VARCHAR(30) Reserved for IBM internal use.
BASTATE VARCHAR(20) Reserved for IBM internal use.
BACNTRY VARCHAR(30) Reserved for IBM internal use.
BAZIPC VARCHAR(20) Reserved for IBM internal use.
BASGRFNBR INTEGER Reserved for IBM internal use.
BAFIELD1 VARCHAR(30) Reserved for IBM internal use.
BAFIELD2 VARCHAR(30) Reserved for IBM internal use.
BAFIELD3 VARCHAR(30) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000048 BACODE+BABURFNBR+BATYPE Unique Index
SQL050212031202900 BARFNBR Primary Key
I0000484 BABURFNBR Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_130 BABURFNBR BUYORG BURFNBR Cascade

Feedback