Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNBROKER


                             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: Active Flag   The Active flag of the credit card
                       type.
                       A = Active
                       I = Inactive

BRK-ADDR1              Alpha 30  (Lower Case)                    BN01.2
Element: Addr1         This field contains the first line of
                       address information.

BRK-ADDR2              Alpha 30  (Lower Case)                    BN01.2
Element: Addr1         This field contains the first line of
                       address information.

BRK-ADDR3              Alpha 30  (Lower Case)                    BN01.2
Element: Addr1         This field contains the first line of
                       address information.

BRK-ADDR4              Alpha 30  (Lower Case)                    BN01.2
Element: Addr1         This field contains the first 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         This 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 Init   Contains the middle initial of the
                       manager in charge.

BRK-PHONE-COUNTRY      Alpha 6                                   BN01.2
Element: Phone Country This field contains the prefix of the
                       telephone number. For example, the
                       country or city code.


BRK-PHONE-NUMBER       Alpha 15                                  BN01.2
Element: Phone         Phone number.

BRK-PHONE-EXT          Alpha 5                                   BN01.2
Element: Phone Ext     This field contains the telephone
                       extension number.

BRK-FAX-COUNTRY        Alpha 6                                   BN01.2
Element: Phone Country This field contains the prefix of the
                       telephone number. For example, the
                       country or city code.


BRK-FAX-NUMBER         Alpha 15                                  BN01.2
Element: Phone         Phone number.

BRK-FAX-EXT            Alpha 5
Element: Phone Ext     This field contains the telephone
                       extension number.

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

                         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