BUADDR

This table is deprecated and is provided for backward compatibility only.

Column Descriptions:

NameTypeDescription
BARFNBRINTEGER NOT NULLReserved for IBM internal use.
BABURFNBRINTEGER NOT NULLReserved for IBM internal use.
BACODEVARCHAR (17) NOT NULLReserved for IBM internal use.
BACDTYPECHAR (2)Reserved for IBM internal use.
BATYPECHAR (2) NOT NULLReserved for IBM internal use.
BANAMEVARCHAR (80)Reserved for IBM internal use.
BAADDR1VARCHAR (50)Reserved for IBM internal use.
BAADDR2VARCHAR (30)Reserved for IBM internal use.
BAADDR3VARCHAR (50)Reserved for IBM internal use.
BACITYVARCHAR (30)Reserved for IBM internal use.
BASTATEVARCHAR (20)Reserved for IBM internal use.
BACNTRYVARCHAR (30)Reserved for IBM internal use.
BAZIPCVARCHAR (20)Reserved for IBM internal use.
BASGRFNBRINTEGERReserved for IBM internal use.
BAFIELD1VARCHAR (30)Reserved for IBM internal use.
BAFIELD2VARCHAR (30)Reserved for IBM internal use.
BAFIELD3VARCHAR (30)Reserved for IBM internal use.
OPTCOUNTERSMALLINTReserved for IBM internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>BARFNBRPrimary Key
I0000048BACODE+BABURFNBR+BATYPEUnique Index
I0000484BABURFNBRNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_130BABURFNBRBUYORGBURFNBRCascade