BLRICLINE FILE
Cust. Recurring Invc Item
This file contains the line items for customer recurring invoices. It is
usually created from a line on the recurring invoice. However, you can enter
additional line items manually.
REFERENCED BY
BL231 BL34.1 BL30.3 BL30.5
UPDATED BY
BL31.1 BL31.2 BL31.3 BL31.5 BL31.7 BL32.3
BL32.4 BL33.1 BL331 BLI2.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BUL-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 BL33.1
BUL-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 BL33.1
BUL-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 BL33.1
BUL-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
BUL-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 BL33.1
BUL-ITEM Alpha 32 BL31.1 BL31.2
Item Number This field contains the item BL31.3 BL31.5
identifier. BL31.7 BL32.3
BL32.4 BL33.1
BUL-ITEM-DESC Alpha 30
Item Description This field contains the description for
items.
BUL-LINE-TYPE Alpha 1
Line Type This field contains the type of
inventory on this line.
N = Non-stock
X = Special Order
BUL-ZERO-AFTER-USE Alpha 1 BL31.1 BL31.2
Zero After Use This flag indicates whether the BL31.3 BL31.5
quantity field is to be zeroed after BL31.7 BL32.3
creation of the actual invoice for each BL32.4
period.
BUL-QUANTITY Signed 13.4 BL31.1 BL31.2
Quantity This is the total quantity to be billed BL31.3 BL31.5
for this customer recurring invoice BL31.7 BL32.3
item. BL32.4 BL33.1
BUL-SKIP-FLAG Alpha 1 BL31.1 BL31.2
Skip Emp/App if no Skip this period flag. Only valid if BL31.3 BL31.5
Detail Flag zero after use is set to Yes. This lets BL31.7 BL32.3
you pass the edit ensuring that all zero BL32.4 BL33.1
after use lines have been set up for a
billing period and still skip billing a
line.
BUL-INVOICE-QTY Signed 13.4 BL31.1 BL31.2
Invoice Quantity This is the quantity to be billed on BL31.3 BL31.5
the next invoice created for this BL31.7 BL32.3
customer recurring invoice line. BL32.4
BUL-BILLED-AMOUNT Signed 15.2 BL31.1 BL31.2
Billed Amount The total amount already billed against BL31.3 BL31.5
this customer recurring invoice line. BL31.7 BL32.3
BL32.4
BUL-SELL-UOM Alpha 4 BL31.1 BL31.2
Sell Unit of Measure This field contains the selling unit of BL31.3 BL31.5
measure for the item. BL31.7 BL32.3
BL32.4
BUL-UNIT-PRICE Signed 13.5 BL31.1 BL31.2
Unit Price This field contains the unit price. BL31.3 BL31.5
BL31.7 BL32.3
BL32.4
BUL-SPR-UOM Alpha 4 BL31.1 BL31.2
Selling Price Unit This is the pricing unit of measure for BL31.3 BL31.5
of Measure this line. BL31.7 BL32.3
BL32.4
BUL-FREQUENCY Alpha 1 BL31.1 BL31.2
Frequency This is the frequency code for this BL31.3 BL31.5
recurring invoice. BL31.7 BL32.3
W = Weekly BL32.4
S = Semi-Monthly
M = Monthly
Q = Quarterly
Y = Yearly
U = User Defined
BUL-CYCLE-CODE Alpha 3 BL31.1 BL31.2
Cycle Code This is the cycle code. Cycle code is BL31.3 BL31.5
used to separate recurring invoices into BL31.7 BL32.3
groups within frequency for processing. BL32.4
BUL-START-DATE Numeric 8 (yyyymmdd) BL31.1 BL31.2
Start Date This is the starting date. Invoices BL31.3 BL31.5
created from this customer recurring BL31.7 BL32.3
invoice after this date and prior to the BL32.4
stop date will include this item.
BUL-STOP-DATE Numeric 8 (yyyymmdd) BL31.1 BL31.2
Stop Date This is the stop date. Invoice created BL31.3 BL31.5
for this customer recurring invoice BL31.7 BL32.3
after this date will not include this BL32.4
line.
BUL-TERRITORY Alpha 4 BL31.1 BL31.2
Sales Territory This field contains the sales territory. BL31.3 BL31.5
BL31.7 BL32.3
BL32.4
BUL-SALESMAN Numeric 4 BL31.1 BL31.2
Salesman Number This field contains the code that BL31.3 BL31.5
represents the primary sales BL31.7 BL32.3
representative of this line. If left BL32.4
blank, this defaults from the order
header.
BUL-SALESMAN-2 Numeric 4 BL31.1 BL31.2
Salesman Number 2 This field contains the code BL31.3 BL31.5
representing the second sales BL31.7 BL32.3
representative. BL32.4
BUL-COMM-RATE-1 Percent 7.5 (Percent) BL31.1 BL31.2
Commission Rate for This field contains the commission rate BL31.3 BL31.5
Slsmn 1 of the primary sales representative. BL31.7 BL32.3
BL32.4
BUL-COMM-RATE-2 Percent 7.5 (Percent) BL31.1 BL31.2
Commission Rate for This field contains the commission rate BL31.3 BL31.5
Slsmn 2 for the second sales representative. BL31.7 BL32.3
BL32.4
BUL-COMM-SPLIT Percent 5.3 (Percent) BL31.1 BL31.2
Commission Split This field contains the commission BL31.3 BL31.5
Percentage split. This defaults from the customer BL31.7 BL32.3
master. BL32.4
BUL-STD-COMM1 Alpha 4 BL31.1 BL31.2
Std Comm1 Standard comment code 1. Code to BL31.3 BL31.5
represent a group of comments. BL31.7 BL32.3
BL32.4
BUL-STD-COMM2 Alpha 4 BL31.1 BL31.2
Std Comm2 Standard comment code 2. Code to BL31.3 BL31.5
represent a group of comments. BL31.7 BL32.3
BL32.4
BUL-STD-COMM3 Alpha 4 BL31.1 BL31.2
Std Comm3 Standard comment code 3. Code to BL31.3 BL31.5
represent a group of comments. BL31.7 BL32.3
BL32.4
BUL-LAST-MISC-SEQ Numeric 3 BL31.1 BL31.2
Last Misc Code Last sequence number used for add-on BL31.3 BL31.5
Sequence charges for this customer recurring BL31.7 BL32.3
invoice line. BL32.4
BUL-LAST-COMM-SEQ Numeric 3 BL31.1 BL31.2
Last Comment This is the sequence number of the last BL31.3 BL31.5
Sequence Number comment line entered for this BL31.7 BL32.3
requisition line. BL32.4 BLI2.1
BUL-MAST-LINE-NBR Numeric 6 BL31.1 BL31.2
Mast Line Nbr Line number of the recurring invoice BL31.3 BL31.5
line that caused this customer recurring BL31.7 BL32.3
invoice line. BL32.4
BUL-UNBILLED-AMT Derived
Unbilled Amt Amount yet to be billed against this
line.
BUL-TOTAL-VALUE Derived
Total Value Total amount to be billed against this
line.
BUL-IC-UOM-1 Derived
Ic Uom 1 This field contains the first inventory
unit of measure for the item.
BUL-IC-UOM-2 Derived
Ic Uom 2 This field contains the second
inventory unit of measure for the item.
BUL-IC-UOM-3 Derived
Ic Uom 3 This field contains the third inventory
unit of measure for the item.
BUL-IC-UOM-4 Derived
Ic Uom 4 This field contains the fourth
inventory unit of measure for the item.
BUL-IC-UOM-5 Derived
Ic Uom 5 This field contains the fifth inventory
unit of measure for the item.
BUL-IC-UOM-6 Derived
Ic Uom 6 This field contains the sixth inventory
unit of measure for the item.
BUL-STS-INDEX Derived
Sts Index This field determines which inventory
unit of measure is used for display
purposes.
BUL-STS-M Derived
Sts M This field contains the multiplier.
BUL-STS-MULT Derived
Sts Mult This field contains the sales to stock
multiplier.
BUL-PTS-INDEX Derived
Pts Index This field determines which unit of
measure to use in pricing.
BUL-PTS-M Derived
Pts M This field contains the pricing
multiplier.
BUL-PTS-MULT Derived
Pts Mult This field contains the pricing unit of
measure multiplier.
BUL-ITEM-16 Derived
Item 16 This field contains the first 16
characters of the item's identifier.
This information is used by inquiries
and reports.
BLRICLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BULSET1 COMPANY BL231 BL31.1
RECUR-INVOICE BL31.2 BL31.3
CUSTOMER BL31.5 BL31.7
LINE-NBR BL32.3 BL32.4
BL331 BL34.1
BLI2.1
BULSET2 COMPANY Subset BL30.3 BL30.5
RECUR-INVOICE Where MAST-LINE-NBR != Zeroes BL32.2
MAST-LINE-NBR
CUSTOMER
BULSET3 COMPANY KeyChange, Subset
FREQUENCY Where QUANTITY = Zeroes
CYCLE-CODE And SKIP-FLAG = "N"
ITEM
RECUR-INVOICE
CUSTOMER
LINE-NBR
BULSET4 COMPANY KeyChange, Subset BL33.1
FREQUENCY Where ZERO-AFTER-USE = "Y"
CYCLE-CODE
ITEM
RECUR-INVOICE
CUSTOMER
LINE-NBR
BULSET5 COMPANY Subset
RECUR-INVOICE Where QUANTITY = Zeroes
CUSTOMER And SKIP-FLAG = "N"
LINE-NBR
BLRICLINE 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
BUL-COMPANY -> ACM-COMPANY
BUL-CUSTOMER -> ACM-CUSTOMER
Blricsgblk BLRICSGBLK Not Required
BUL-COMPANY -> CGM-COMPANY
BUL-RECUR-INVOICE -> CGM-RECUR-INVOICE
BUL-CUSTOMER -> CGM-CUSTOMER
BUL-LINE-NBR -> CGM-LINE-NBR
Zeroes -> CGM-SEQ
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
BUL-CUSTOMER -> CUD-CUSTOMER
Iccompany ICCOMPANY Required
BUL-COMPANY -> ICC-COMPANY
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
BUL-ITEM -> ITE-ITEM
Oecommhdr1 OECOMMHDR Not Required
Valid When BUL-STD-COMM1 != Spaces
BUL-COMPANY -> OCH-COMPANY
BUL-STD-COMM1 -> OCH-STD-COMM
Oecommhdr2 OECOMMHDR Not Required
Valid When BUL-STD-COMM2 != Spaces
BUL-COMPANY -> OCH-COMPANY
BUL-STD-COMM2 -> OCH-STD-COMM
Oecommhdr3 OECOMMHDR Not Required
Valid When BUL-STD-COMM3 != Spaces
BUL-COMPANY -> OCH-COMPANY
BUL-STD-COMM3 -> OCH-STD-COMM
Oecompany OECOMPANY Required
BUL-COMPANY -> OEC-COMPANY
Oecustsrvc BLRICUST Required
BUL-COMPANY -> BRC-COMPANY
BUL-RECUR-INVOICE -> BRC-RECUR-INVOICE
BUL-CUSTOMER -> BRC-CUSTOMER
Oemastsrvc BLRIMAST Required
BUL-COMPANY -> BRM-COMPANY
BUL-RECUR-INVOICE -> BRM-RECUR-INVOICE
Oemsline BLRIMLINE Not Required
BUL-COMPANY -> BML-COMPANY
BUL-RECUR-INVOICE -> BML-RECUR-INVOICE
BUL-LINE-NBR -> BML-LINE-NBR
Salesman SALESREP Required
When BUL-SALESMAN != Zeroes
BUL-COMPANY -> SAW-COMPANY
BUL-SALESMAN -> SAW-SALESMAN
Salesman2 SALESREP Required
When BUL-SALESMAN-2 != Zeroes
BUL-COMPANY -> SAW-COMPANY
BUL-SALESMAN-2 -> SAW-SALESMAN
Territory TERITORY Required
When BUL-TERRITORY != Spaces
BUL-COMPANY -> TRY-COMPANY
BUL-TERRITORY -> TRY-TERRITORY
BLRICLINE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Blriccomm BLRICCOMM
BUL-COMPANY -> BUC-COMPANY
BUL-RECUR-INVOICE -> BUC-RECUR-INVOICE
BUL-CUSTOMER -> BUC-CUSTOMER
BUL-LINE-NBR -> BUC-LINE-NBR
BUC-SEQ
Oecscomm BLRICCOMM
BUL-COMPANY -> BUC-COMPANY
BUL-RECUR-INVOICE -> BUC-RECUR-INVOICE
BUL-CUSTOMER -> BUC-CUSTOMER
BUL-LINE-NBR -> BUC-LINE-NBR
BUC-SEQ
Oecsmisc BLRICMISC
BUL-COMPANY -> BUM-COMPANY
BUL-RECUR-INVOICE -> BUM-RECUR-INVOICE
BUL-CUSTOMER -> BUM-CUSTOMER
BUL-LINE-NBR -> BUM-LINE-NBR
BUM-SEQ
|
