BNBROKER – No description in the Lawson data dictionary

System
Benefits (BN)
Prefix
BRK
Primary key
BROKER
Fields
24
Updated by
1 program
Referenced by
3 programs

BNBROKER is a Lawson Benefits table (prefix BRK); no description in the lawson data dictionary. It is indexed by BROKER (BRKSET1). It is related 1:1 to INSTCTRYCD. It is updated by BN01.2 and referenced by BN205, BN33.4 and BN534. The table has 24 fields, 1 index and 1 documented relation.

About BNBROKER

No description in the Lawson data dictionary.

Fields (24)

Column = COBOL field name without the BRK- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
BRK-BROKER PK
BROKER		Alpha 4—BN01.2
BRK-NAME
NAME		Alpha 30 (Lower Case)Displays the company description.BN01.2
BRK-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1The Active flag of the credit card type.
  • A Active
  • I Inactive
BN01.2
BRK-ADDR1
ADDR1		Alpha 30 (Lower Case)This field contains the first line of address information.BN01.2
BRK-ADDR2
ADDR2		Alpha 30 (Lower Case)This field contains the first line of address information.BN01.2
BRK-ADDR3
ADDR3		Alpha 30 (Lower Case)This field contains the first line of address information.BN01.2
BRK-ADDR4
ADDR4		Alpha 30 (Lower Case)This field contains the first line of address information.BN01.2
BRK-CITY
CITY		Alpha 58 (Lower Case)This field contains the city of the address.BN01.2
BRK-STATE
STATE		Alpha 2This field contains the two-character state code of the address.BN01.2
BRK-COUNTRY-CODE
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).BN01.2
BRK-POSTAL-CODE
POSTAL_CODE		Alpha 10 (Lower Case)This field contains the postal code.BN01.2
BRK-LAST-NAME
LAST_NAME		Alpha 30 (Lower Case)Contains the last name of the manager in charge.BN01.2
BRK-FIRST-NAME
FIRST_NAME		Alpha 15 (Lower Case)Contains the first name of the manager in charge.BN01.2
BRK-MIDDLE-INIT
MIDDLE_INIT		Alpha 1Contains the middle initial of the manager in charge.BN01.2
BRK-PHONE-COUNTRY
PHONE_COUNTRY		Alpha 6This field contains the prefix of the telephone number. For example, the country or city code.BN01.2
BRK-PHONE-NUMBER
PHONE_NUMBER		Alpha 15Phone number.BN01.2
BRK-PHONE-EXT
PHONE_EXT		Alpha 5This field contains the telephone extension number.BN01.2
BRK-FAX-COUNTRY
FAX_COUNTRY		Alpha 6This field contains the prefix of the telephone number. For example, the country or city code.BN01.2
BRK-FAX-NUMBER
FAX_NUMBER		Alpha 15Phone number.BN01.2
BRK-FAX-EXT
FAX_EXT		Alpha 5This field contains the telephone extension number.—
BRK-EMAIL-ADDRESS
EMAIL_ADDRESS		Alpha 60 (Lower Case)e-mail address.BN01.2
BRK-DATE-STAMP
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
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.BN01.2
BRK-USER-ID
USER_ID		Alpha 10 (Lower Case)—BN01.2

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BRKSET1BROKERPrimaryBN01.2, BN205, BN33.4, BN534

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CountryINSTCTRYCDNot RequiredBRK-COUNTRY-CODE → INT-COUNTRY-CODE

Programs

Updated by (1)

Referenced by (3)