Database Table: BUADDR

Reserved for IBM internal use.

Column Name Column Type Column Description
BAADDR1 VARCHAR (50)
NULL
Reserved for IBM internal use.
BAADDR2 VARCHAR (30)
NULL
Reserved for IBM internal use.
BAADDR3 VARCHAR (50)
NULL
Reserved for IBM internal use.
BABURFNBR INTEGER
NOT NULL
Reserved for IBM internal use.
BACDTYPE CHARACTER (2)
NULL
Reserved for IBM internal use.
BACITY VARCHAR (30)
NULL
Reserved for IBM internal use.
BACNTRY VARCHAR (30)
NULL
Reserved for IBM internal use.
BACODE VARCHAR (17)
NOT NULL
Reserved for IBM internal use.
BAFIELD1 VARCHAR (30)
NULL
Reserved for IBM internal use.
BAFIELD2 VARCHAR (30)
NULL
Reserved for IBM internal use.
BAFIELD3 VARCHAR (30)
NULL
Reserved for IBM internal use.
BANAME VARCHAR (80)
NULL
Reserved for IBM internal use.
BARFNBR INTEGER
NOT NULL
Reserved for IBM internal use.
BASGRFNBR INTEGER
NULL
Reserved for IBM internal use.
BASTATE VARCHAR (20)
NULL
Reserved for IBM internal use.
BATYPE CHARACTER (2)
NOT NULL
Reserved for IBM internal use.
BAZIPC VARCHAR (20)
NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
I0000048 BACODE, BABURFNBR, BATYPE Unique Index
SQL030416034845430 BARFNBR Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_130 BABURFNBR BUYORG BURFNBR Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable