BLRICMISC FILE
Cust. Recurring Invoice AOC
This file stores the add-on charges for customer recurring invoices and
invoice line items. Usually they are created from the recurring invoice
add-on charges. However, the user can add additional add-on charges manually.
REFERENCED BY
BL231 BL30.2 BL30.5
UPDATED BY
BL31.1 BL31.2 BL31.3 BL31.5 BL31.7 BL32.3
BL32.4 BL331 BL34.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BUM-COMPANY Numeric 4 BL31.1 BL31.2
Company The company number represents an BL31.3 BL31.5
established company and is entered on BL31.7 BL32.3
all function codes. BL32.4 BL34.1
BUM-RECUR-INVOICE Alpha 10 BL31.1 BL31.2
Recur Invoice This is the recurring invoice BL31.3 BL31.5
identifier. BL31.7 BL32.3
BL32.4 BL34.1
BUM-CUSTOMER Alpha 9 (Right Justified) BL31.1 BL31.2
Customer Number This field contains the number that BL31.3 BL31.5
represents a customer. BL31.7 BL32.3
BL32.4 BL34.1
BUM-SHIP-TO Numeric 4 BL31.1 BL31.2
Ship-to Code This field contains the number BL31.3 BL31.5
representing the ship to customer. BL31.7 BL32.3
BL32.4
BUM-LINE-NBR Numeric 6 BL31.1 BL31.2
Line Number This field contains the line number. BL31.3 BL31.5
BL31.7 BL32.3
BL32.4 BL34.1
BUM-SEQ Numeric 3 BL31.1 BL31.2
Sequence Number This field contains the record sequence BL31.3 BL31.5
number. BL31.7 BL32.3
BL32.4 BL34.1
BUM-MISC Alpha 16 BL31.1 BL31.2
Misc Add-on charge code. Must be valid in BL31.3 BL31.5
the add-on charge master file. BL31.7 BL32.3
BL32.4 BL34.1
BUM-ZERO-AFTER-USE Alpha 1 BL31.1 BL31.2
Zero After Use Flag to determine whether the amount BL31.3 BL31.5
field is zeroed out after each creation BL31.7 BL32.3
of an invoice against this customer BL32.4
recurring invoice add-on charge.
BUM-AMOUNT Currency 15.2 BL31.1 BL31.2
Amount This is the total amount to be billed BL31.3 BL31.5
for this charge. BL31.7 BL32.3
BL32.4 BL34.1
BUM-BILLED-AMOUNT Signed 15.2 BL31.1 BL31.2
Billed Amount This is the amount billed to date for BL31.3 BL31.5
this charge. BL31.7 BL32.3
BL32.4
BUM-PRICE Signed 15.2 BL31.1 BL31.2
Price This field contains the flat amount BL31.3 BL31.5
that is applied as an add-on charge per BL31.7 BL32.3
billing. BL32.4
BUM-SKIP-FLAG Alpha 1 BL31.1 BL31.2
Skip Emp/App if no Flag to indicate that this add-on BL31.3 BL31.5
Detail Flag charge is to be skipped the next time an BL31.7 BL32.3
invoice is created for this customer BL32.4 BL34.1
recurring invoice. Only valid if the
zero after use flag is set on.
BUM-FREQUENCY Alpha 1 BL31.1 BL31.2
Frequency Frequency for this customer recurring BL31.3 BL31.5
invoice. BL31.7 BL32.3
W = Weekly BL32.4
S = Semi-Monthly
M = Monthly
Q = Quarterly
Y = Yearly
U = User Defined
BUM-CYCLE-CODE Alpha 3 BL31.1 BL31.2
Cycle Code Cycle code. Used to group customer BL31.3 BL31.5
recurring invoices within frequency code BL31.7 BL32.3
to manage the work load. BL32.4
BUM-START-DATE Numeric 8 (yyyymmdd) BL31.1 BL31.2
Start Date Start date. Any invoice created for BL31.3 BL31.5
this customer recurring invoice prior to BL31.7 BL32.3
this date will not include this add-on BL32.4
charge.
BUM-STOP-DATE Numeric 8 (yyyymmdd) BL31.1 BL31.2
Stop Date Stop date. Any invoice created for this BL31.3 BL31.5
customer recurring invoice after this BL31.7 BL32.3
date will not include this add-on BL32.4
charge.
BUM-MAST-LINE-NBR Numeric 6 BL31.1 BL31.2
Mast Line Nbr Line number of the recurring invoice BL31.3 BL31.5
add-on charge that triggered this BL31.7 BL32.3
customer recurring invoice add-on BL32.4
charge.
BUM-MAST-SEQ Numeric 3 BL31.1 BL31.2
Mast Seq Sequence number of the recurring BL31.3 BL31.5
invoice add-on charge that triggered BL31.7 BL32.3
creation of this customer recurring BL32.4
invoice add-on charge.
BLRICMISC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BUMSET1 COMPANY BL231 BL31.1
RECUR-INVOICE BL31.2 BL31.3
CUSTOMER BL31.5 BL31.7
LINE-NBR BL32.3 BL32.4
SEQ BL331
BUMSET2 COMPANY Subset BL30.2 BL30.5
RECUR-INVOICE Where MAST-LINE-NBR != Zeroes
MAST-LINE-NBR
MAST-SEQ
CUSTOMER
BUMSET3 COMPANY KeyChange, Subset
FREQUENCY Where AMOUNT = Zeroes
CYCLE-CODE And SKIP-FLAG = "N"
MISC
RECUR-INVOICE
CUSTOMER
LINE-NBR
SEQ
BUMSET4 COMPANY KeyChange, Subset BL34.1
FREQUENCY Where ZERO-AFTER-USE = "Y"
CYCLE-CODE
MISC
RECUR-INVOICE
CUSTOMER
LINE-NBR
SEQ
BUMSET5 COMPANY Subset
RECUR-INVOICE Where AMOUNT = Zeroes
CUSTOMER And SKIP-FLAG = "N"
LINE-NBR
SEQ
BLRICMISC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
BUL-COMPANY -> ACO-COMPANY (ACOSET1)
Arcustomer ARCUSTOMER Required
BUM-COMPANY -> ACM-COMPANY
BUM-CUSTOMER -> ACM-CUSTOMER
Blricsgblk BLRICSGBLK Not Required
BUM-COMPANY -> CGM-COMPANY
BUM-RECUR-INVOICE -> CGM-RECUR-INVOICE
BUM-CUSTOMER -> CGM-CUSTOMER
BUM-LINE-NBR -> CGM-LINE-NBR
BUM-SEQ -> CGM-SEQ
Custdesc CUSTDESC Not Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
BUM-CUSTOMER -> CUD-CUSTOMER
Oecompany OECOMPANY Required
BUL-COMPANY -> OEC-COMPANY
Oecsline BLRICLINE Required
BUM-COMPANY -> BUL-COMPANY
BUM-RECUR-INVOICE -> BUL-RECUR-INVOICE
BUM-CUSTOMER -> BUL-CUSTOMER
BUM-LINE-NBR -> BUL-LINE-NBR
Oecustsrvc BLRICUST Required
BUM-COMPANY -> BRC-COMPANY
BUM-RECUR-INVOICE -> BRC-RECUR-INVOICE
BUM-CUSTOMER -> BRC-CUSTOMER
Oemastsrvc BLRIMAST Required
BUM-COMPANY -> BRM-COMPANY
BUM-RECUR-INVOICE -> BRM-RECUR-INVOICE
Oemisc OEMISC Required
BUM-COMPANY -> OEM-COMPANY
BUM-MISC -> OEM-MISC
BRC-CURRENCY-CODE -> OEM-CURRENCY-CODE
Oemsmisc BLRIMMISC Not Required
BUM-COMPANY -> BMM-COMPANY
BUM-RECUR-INVOICE -> BMM-RECUR-INVOICE
BUM-LINE-NBR -> BMM-LINE-NBR
BUM-SEQ -> BMM-SEQ
|
