|
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
BL130 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 BL130 BL31.1
Element: Company Identifies the AP company if the BL31.2 BL31.3
resource type = V. Identifies the HR BL31.5 BL31.7
company if the resource type = E. It is BL32.3 BL32.4
blank for type A, P or Q resources. BL34.1
BUM-RECUR-INVOICE Alpha 10 BL130 BL31.1
Element: Recur Invoice This is the recurring invoice BL31.2 BL31.3
identifier. BL31.5 BL31.7
BL32.3 BL32.4
BL34.1
BUM-CUSTOMER Alpha 9 (Right Justified) BL130 BL31.1
Element: Customer This field contains the number that BL31.2 BL31.3
represents a customer. BL31.5 BL31.7
BL32.3 BL32.4
BL34.1
BUM-SHIP-TO Numeric 4 BL130 BL31.1
Element: Ship To This field contains the number BL31.2 BL31.3
representing the ship to customer. BL31.5 BL31.7
BL32.3 BL32.4
BUM-LINE-NBR Numeric 6 BL130 BL31.1
Element: Line Nbr This field contains the line number. BL31.2 BL31.3
BL31.5 BL31.7
BL32.3 BL32.4
BL34.1
BUM-SEQ Numeric 3 BL130 BL31.1
Element: Seq This field contains the record sequence BL31.2 BL31.3
number. BL31.5 BL31.7
BL32.3 BL32.4
BL34.1
BUM-MISC Alpha 16 BL130 BL31.1
Element: Misc Add-on charge code. Must be valid in BL31.2 BL31.3
the add-on charge master file. BL31.5 BL31.7
BL32.3 BL32.4
BL34.1
BUM-ZERO-AFTER-USE Alpha 1 BL130 BL31.1
Element: All Flag Flag to determine whether the amount BL31.2 BL31.3
field is zeroed out after each creation BL31.5 BL31.7
of an invoice against this customer BL32.3 BL32.4
recurring invoice add-on charge.
BUM-AMOUNT Signed 18.2 BL130 BL31.1
Element: Intl Amt This is the total amount to be billed BL31.2 BL31.3
for this charge. BL31.5 BL31.7
BL32.3 BL32.4
BL34.1
BUM-BILLED-AMOUNT Signed 18.2 BL130 BL31.1
Element: Intl Amt This is the amount billed to date for BL31.2 BL31.3
this charge. BL31.5 BL31.7
BL32.3 BL32.4
BUM-PRICE Signed 18.2 BL130 BL31.1
Element: Intl Amt This field contains the flat amount BL31.2 BL31.3
that is applied as an add-on charge per BL31.5 BL31.7
billing. BL32.3 BL32.4
BUM-SKIP-FLAG Alpha 1 BL130 BL31.1
Element: Skip Flag Flag to indicate that this add-on BL31.2 BL31.3
charge is to be skipped the next time an BL31.5 BL31.7
invoice is created for this customer BL32.3 BL32.4
recurring invoice. Only valid if the BL34.1
zero after use flag is set on.
BUM-FREQUENCY Alpha 1 BL130 BL31.1
Element: Frequency Frequency for this customer recurring BL31.2 BL31.3
invoice. BL31.5 BL31.7
W = Weekly BL32.3 BL32.4
S = Semi-Monthly
M = Monthly
Q = Quarterly
Y = Yearly
U = User Defined
BUM-CYCLE-CODE Alpha 3 BL130 BL31.1
Element: Auth Code Cycle code. Used to group customer BL31.2 BL31.3
recurring invoices within frequency code BL31.5 BL31.7
to manage the work load. BL32.3 BL32.4
BUM-START-DATE Numeric 8 (yyyymmdd) BL130 BL31.1
Element: Start Date Start date. Any invoice created for BL31.2 BL31.3
this customer recurring invoice prior to BL31.5 BL31.7
this date will not include this add-on BL32.3 BL32.4
charge.
BUM-STOP-DATE Numeric 8 (yyyymmdd) BL130 BL31.1
Element: Stop Date Stop date. Any invoice created for this BL31.2 BL31.3
customer recurring invoice after this BL31.5 BL31.7
date will not include this add-on BL32.3 BL32.4
charge.
BUM-MAST-LINE-NBR Numeric 6 BL130 BL31.1
Element: Line Nbr Line number of the recurring invoice BL31.2 BL31.3
add-on charge that triggered this BL31.5 BL31.7
customer recurring invoice add-on BL32.3 BL32.4
charge.
BUM-MAST-SEQ Numeric 3 BL130 BL31.1
Element: Seq Sequence number of the recurring BL31.2 BL31.3
invoice add-on charge that triggered BL31.5 BL31.7
creation of this customer recurring BL32.3 BL32.4
invoice add-on charge.
BUM-TAX-EXEMPT-CD Alpha 1 BL130 BL31.1
Element: Tax Exempt Cd Code indicating the taxing status. E - BL31.2 BL31.3
Exempt, T - Taxable. BL31.5 BL31.7
BL32.3 BL32.4
BLRICMISC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BUMSET1 COMPANY BL130 BL231
RECUR-INVOICE BL31.1 BL31.2
CUSTOMER BL31.3 BL31.5
LINE-NBR BL31.7 BL32.3
SEQ BL32.4 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 BL130
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 BL130
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
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
|