| 
 | 
                             BLRIMMISC FILE
                         Recurring Invoice AOC
This file stores the add-on charges attached to a recurring invoice or its
line items.  These will be copied to any customer recurring invoice created
from this recurring invoice.
REFERENCED BY
BL230
UPDATED BY
BL130     BL30.1    BL30.2    BL30.3    BL30.5    BL31.1
BL31.2    BL31.3    BL31.5    BL31.7    BL32.1    BL32.2
BL32.3    BL32.4    BL330
FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY
BMM-COMPANY            Numeric 4                                 BL30.2  BL30.5
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.
BMM-RECUR-INVOICE      Alpha 10                                  BL30.2  BL30.5
Element: Recur Invoice This is the recurring invoice
                       identifier.
BMM-LINE-NBR           Numeric 6                                 BL30.2  BL30.5
Element: Line Nbr      This field contains the line number.
BMM-SEQ                Numeric 3                                 BL30.2  BL30.5
Element: Seq           This field contains the record sequence
                       number.
BMM-MISC               Alpha 16                                  BL30.2  BL30.5
Element: Misc          The add-on charge code. Must exist in
                       the add-on charge master file.
BMM-ZERO-AFTER-USE     Alpha 1                                   BL30.2  BL30.5
Element: All Flag      Indicates whether the charge amount
                       associated with the customer service
                       contract line is to be cleared once the
                       invoice is created. This is valid only
                       for flat amount type of charges.
                       Y = Yes
                       N = No
BMM-START-DATE         Numeric 8  (yyyymmdd)                     BL30.2  BL30.5
Element: Start Date    The date on which this specific charge
                       went into effect. This field, along with
                       stop date, determines whether this
                       charge is added to the customer
                       recurring invoice when it is created.
BMM-STOP-DATE          Numeric 8  (yyyymmdd)                     BL30.2  BL30.5
Element: Stop Date     The date on which this specific charge
                       is no longer in effect. This will
                       determine whether this add-on charge is
                       created for any customer recurring
                       invoices created from this recurring
                       invoice.
BMM-TAX-EXEMPT-CD      Alpha 1                                   BL30.2  BL30.5
Element: Tax Exempt Cd Code indicating the taxing status. E -
                       Exempt, T - Taxable.
                         BLRIMMISC FILE INDEX
NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN
BMMSET1   COMPANY                                                BL130   BL230
          RECUR-INVOICE                                          BL30.1  BL30.2
          LINE-NBR                                               BL30.3  BL30.5
          SEQ                                                    BL31.1  BL31.2
                                                                 BL31.3  BL31.5
                                                                 BL31.7  BL32.1
                                                                 BL32.2  BL32.3
                                                                 BL32.4  BL330
                         BLRIMMISC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH
Blrimsgblk     BLRIMSGBLK   Not Required
                            BMM-COMPANY          -> MSG-COMPANY
                            BMM-RECUR-INVOICE    -> MSG-RECUR-INVOICE
                            BMM-LINE-NBR         -> MSG-LINE-NBR
                            BMM-SEQ              -> MSG-SEQ
Oecompany      OECOMPANY    Required
                            BMM-COMPANY          -> OEC-COMPANY
Oemastsrvc     BLRIMAST     Required
                            BMM-COMPANY          -> BRM-COMPANY
                            BMM-RECUR-INVOICE    -> BRM-RECUR-INVOICE
Oemisc         OEMISC       Required
                            When BRM-CURRENCY-CODE != Spaces
                            BMM-COMPANY          -> OEM-COMPANY
                            BMM-MISC             -> OEM-MISC
                            BRM-CURRENCY-CODE    -> OEM-CURRENCY-CODE
Oemsline       BLRIMLINE    Required
                            When BMM-LINE-NBR != Zeroes
                            BMM-COMPANY          -> BML-COMPANY
                            BMM-RECUR-INVOICE    -> BML-RECUR-INVOICE
                            BMM-LINE-NBR         -> BML-LINE-NBR
                         BLRIMMISC FILE RELATIONS
ONE TO MANY RELATIONS
RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH
Oecsmisc       BLRICMISC
                            BMM-COMPANY          -> BUM-COMPANY
                            BMM-RECUR-INVOICE    -> BUM-RECUR-INVOICE
                            BMM-LINE-NBR         -> BUM-MAST-LINE-NBR
                            BMM-SEQ              -> BUM-MAST-SEQ
                                                    BUM-CUSTOMER
 |