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