|
|
BNBROKER FILE
REFERENCED BY
BN205 BN33.4 BN534
UPDATED BY
BN01.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BRK-BROKER Alpha 4 BN01.2
Element: Broker
BRK-NAME Alpha 30 (Lower Case) BN01.2
Element: Name Displays the company description.
BRK-ACTIVE-FLAG Alpha 1 BN01.2
Element: Status The Active flag of the credit card
type.
A = Active
I = Inactive
BRK-ADDR1 Alpha 30 (Lower Case) BN01.2
Element: Address 1 This field contains the first line of
address information.
BRK-ADDR2 Alpha 30 (Lower Case) BN01.2
Element: Address 1 This field contains the second line of
address information.
BRK-ADDR3 Alpha 30 (Lower Case) BN01.2
Element: Address 1 This field contains the third line of
address information.
BRK-ADDR4 Alpha 30 (Lower Case) BN01.2
Element: Address 1 This field contains the fourth line of
address information.
BRK-CITY Alpha 18 (Lower Case) BN01.2
Element: City This field contains the city of the
address.
BRK-STATE Alpha 2 BN01.2
Element: State or ProviThis field contains the two-character
state code of the address.
BRK-COUNTRY-CODE Alpha 2 BN01.2
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
BRK-POSTAL-CODE Alpha 10 (Lower Case) BN01.2
Element: Postal Code This field contains the postal code.
BRK-LAST-NAME Alpha 30 (Lower Case) BN01.2
Element: Last Name Contains the last name of the manager
in charge.
BRK-FIRST-NAME Alpha 15 (Lower Case) BN01.2
Element: First Name Contains the first name of the manager
in charge.
BRK-MIDDLE-INIT Alpha 1 BN01.2
Element: Middle InitialContains the middle initial of the
manager in charge.
BRK-PHONE-COUNTRY Alpha 6 BN01.2
Telephone Country This field contains the prefix of the
Code telephone number. For example, the
country or city code.
BRK-PHONE-NUMBER Alpha 15 BN01.2
Element: Telephone NumbContains the telephone number,
including area code.
BRK-PHONE-EXT Alpha 5 BN01.2
Element: Telephone ExteThis field contains the telephone
extension number.
BRK-FAX-COUNTRY Alpha 6 BN01.2
Telephone Country This field contains the prefix of the
Code fax number. For example, the country or
city code.
BRK-FAX-NUMBER Alpha 15 BN01.2
Element: Telephone NumbThis field contains the fax number.
BRK-FAX-EXT Alpha 5
Element: Telephone ExteThis field contains the fax number
extension.
BRK-EMAIL-ADDRESS Alpha 60 (Lower Case) BN01.2
Element: Email Address e-mail address.
BRK-DATE-STAMP Numeric 8 (yyyymmdd) BN01.2
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
BRK-TIME-STAMP Numeric 6 (hhmmss) BN01.2
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
BRK-USER-ID Alpha 10 (Lower Case) BN01.2
Element: User Contains the user ID of the person who
last changed this record.
BNBROKER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BRKSET1 BROKER BN01.2 BN205
BN33.4 BN534
BNBROKER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Country INSTCTRYCD Not Required
BRK-COUNTRY-CODE -> INT-COUNTRY-CODE
|
