|
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
|