BNBROKER

REFERENCED BY
BN33.4 BN534 BN205


UPDATED BY
BN01.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BRK-BROKER
Element: Broker
Alpha 4
BN01.2
BRK-NAME
Element: Name
Alpha 30 (Lower Case)
Displays the company description.
BN01.2
BRK-ACTIVE-FLAG
Element: Active Flag
Alpha 1
The Active flag of the credit card type.
A = Active
I = Inactive
BN01.2
BRK-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
BN01.2
BRK-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
BN01.2
BRK-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
BN01.2
BRK-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
BN01.2
BRK-CITY
Element: City
Alpha 18 (Lower Case)
This field contains the city of the address.
BN01.2
BRK-STATE
Element: State
Alpha 2
This field contains the two-character state code of the address.
BN01.2
BRK-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
BN01.2
BRK-POSTAL-CODE
Element: Postal Code
Alpha 10 (Lower Case)
This field contains the postal code.
BN01.2
BRK-LAST-NAME
Element: Last Name
Alpha 30 (Lower Case)
Contains the last name of the manager in charge.
BN01.2
BRK-FIRST-NAME
Element: First Name
Alpha 15 (Lower Case)
Contains the first name of the manager in charge.
BN01.2
BRK-MIDDLE-INIT
Element: Middle Init
Alpha 1
Contains the middle initial of the manager in charge.
BN01.2
BRK-PHONE-COUNTRY
Element: Phone Country
Alpha 6
This field contains the prefix of the telephone number. For example, the country or city code.
BN01.2
BRK-PHONE-NUMBER
Element: Phone
Alpha 15
Phone number.
BN01.2
BRK-PHONE-EXT
Element: Phone Ext
Alpha 5
This field contains the telephone extension number.
BN01.2
BRK-FAX-COUNTRY
Element: Phone Country
Alpha 6
This field contains the prefix of the telephone number. For example, the country or city code.
BN01.2
BRK-FAX-NUMBER
Element: Phone
Alpha 15
Phone number.
BN01.2
BRK-FAX-EXT
Element: Phone Ext
Alpha 5
This field contains the telephone extension number.
BRK-EMAIL-ADDRESS
Element: Email Address
Alpha 60 (Lower Case)
e-mail address.
BN01.2
BRK-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
BN01.2
BRK-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN01.2
BRK-USER-ID
Element: User
Alpha 10 (Lower Case)
BN01.2


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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Country INSTCTRYCD Not Required
BRK-COUNTRY-CODE->INT-COUNTRY-CODE


File created: Thu Jun 09 11:09:52 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.