Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNCARRIER


                             BNCARRIER FILE

                           Insurance Carrier

The Insurance Carrier file contains information about insurance carriers.

The Benefits system tracks insurance carriers for all benefit plans.

REFERENCED BY

BN106     BN15.1    BN201     BN215     BN320     BN331

UPDATED BY

BN01.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BCR-INS-CARRIER        Alpha 4                                   BN01.1
Element: Insurance CarrContains the code that represents the
                       insurer.

BCR-CARRIER-ID         Alpha 30  (Lower Case)                    BN01.1
Ins. Carrier           Contains the insurer's identification
Identification         number.

BCR-NAME               Alpha 30  (Lower Case)                    BN01.1
Element: Ins. Carrier NContains the insurer's name.

BCR-ADDR1              Alpha 30  (Lower Case)                    BN01.1
Element: Address 1     Contains the first line of the
                       insurer's address.

BCR-ADDR2              Alpha 30  (Lower Case)                    BN01.1
Element: Address 2     Contains the second line of the
                       insurer's address.

BCR-ADDR3              Alpha 30  (Lower Case)                    BN01.1
Element: Address 3     Contains the third line of the
                       insurer's address.

BCR-ADDR4              Alpha 30  (Lower Case)                    BN01.1
Element: Address 4     Contains the fourth line of the
                       insurer's address.

BCR-CITY               Alpha 18  (Lower Case)                    BN01.1
Element: City          Contains the city of the insurer's
                       address.

BCR-STATE              Alpha 2                                   BN01.1
Element: State or ProviContains the state of the insurer's
                       address.

BCR-POSTAL-CODE        Alpha 10  (Lower Case)                    BN01.1
Element: Postal Code   Contains the postal code of the
                       insurer's address.

BCR-LAST-NAME          Alpha 30  (Lower Case)                    BN01.1
Element: Name          Contains the last name of the person to
                       contact at the insurer.

BCR-FIRST-NAME         Alpha 15  (Lower Case)                    BN01.1
Element: First Name    Contains the first name of the person
                       to contact at the insurer.

BCR-MIDDLE-INIT        Alpha 1                                   BN01.1
Element: Middle InitialContains the middle initial of the
                       person to contact at the insurer.

BCR-PHONE-COUNTRY      Alpha 6                                   BN01.1
Telephone Country      Contains the prefix of the insurer's
Code                   telephone number.

BCR-PHONE-NUMBER       Alpha 15                                  BN01.1
Element: Telephone NumbContains the insurer's telephone number.

BCR-PHONE-EXT          Alpha 5
Element: Telephone ExteContains the extension of the insurer's
                       telephone number.

BCR-FAX-COUNTRY        Alpha 6                                   BN01.1
Telephone Country      Contains the prefix of the insurer's
Code                   fax number.

BCR-FAX-NUMBER         Alpha 15                                  BN01.1
Element: Telephone NumbContains the insurer's fax number.

BCR-FAX-EXT            Alpha 5
Element: Telephone ExteContains the extension of the insurer's
                       fax number.

BCR-TELEX-NUMBER       Alpha 15                                  BN01.1
Element: Telephone NumbContains the insurer's telex number.

BCR-CMT-TEXT           Alpha 60  (Lower Case)                    BN01.1
Element: Comment Text  Contains comment text about the insurer.

BCR-COUNTRY-CODE       Alpha 2                                   BN01.1
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

                         BNCARRIER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BCRSET1   INS-CARRIER                                            BN01.1  BN106
                                                                 BN15.1  BN201
                                                                 BN215   BN320
                                                                 BN331

                         BNCARRIER FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Country        INSTCTRYCD   Required
                            When (BCR-COUNTRY-CODE != Spaces )

                            BCR-COUNTRY-CODE    -> INT-COUNTRY-CODE