BNBROKER FILE
REFERENCED BY
HR00.1 HR01.1 PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BRK-BROKER Alpha 4
Broker
BRK-NAME Alpha 30 (Lower Case)
Name Displays the company description.
BRK-ACTIVE-FLAG Alpha 1
Status The Active flag of the credit card
type.
A = Active
I = Inactive
BRK-ADDR1 Alpha 30 (Lower Case)
Address 1 This field contains the first line of
address information.
BRK-ADDR2 Alpha 30 (Lower Case)
Address 2 This field contains the second line of
address information.
BRK-ADDR3 Alpha 30 (Lower Case)
Address 3 This field contains the third line of
address information.
BRK-ADDR4 Alpha 30 (Lower Case)
Address 4 This field contains the fourth line of
address information.
BRK-CITY Alpha 18 (Lower Case)
City This field contains the city of the
address.
BRK-STATE Alpha 2
State or Province This field contains the two-character
state code of the address.
BRK-COUNTRY-CODE Alpha 2
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)
Postal Code This field contains the postal code.
BRK-LAST-NAME Alpha 30 (Lower Case)
Last Name Contains the last name of the manager
in charge.
BRK-FIRST-NAME Alpha 15 (Lower Case)
First Name Contains the first name of the manager
in charge.
BRK-MIDDLE-INIT Alpha 1
Middle Initial Contains the middle initial of the
manager in charge.
BRK-PHONE-COUNTRY Alpha 6
Telephone Country This field contains the prefix of the
Code telephone number. For example, the
country or city code.
BRK-PHONE-NUMBER Alpha 15
Telephone Number Contains the telephone number,
including area code.
BRK-PHONE-EXT Alpha 5
Telephone Extension This field contains the telephone
extension number.
BRK-FAX-COUNTRY Alpha 6
Fax Country This field contains the prefix of the
fax number. For example, the country or
city code.
BRK-FAX-NUMBER Alpha 15
Fax Number This field contains the fax number.
BRK-FAX-EXT Alpha 5
Fax Extension This field contains the fax number
extension.
BRK-EMAIL-ADDRESS Alpha 60 (Lower Case)
Email Address
BRK-DATE-STAMP Numeric 8 (yyyymmdd)
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)
Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
BRK-USER-ID Alpha 10 (Lower Case)
User ID Name 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 HR00.1 HR01.1
PBIP.1 PR197
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
|
