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.
UPDATED BY
BLI2.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BUL-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
BUL-RECUR-INVOICE Alpha 10
Recur Invoice This is the recurring invoice
identifier.
BUL-CUSTOMER Alpha 9 (Right Justified)
Customer Number This field contains the number that
represents a customer.
BUL-SHIP-TO Numeric 4
Ship-to Code This field contains the number
representing the ship to customer.
BUL-LINE-NBR Numeric 6
Line Number This field contains the line number.
BUL-ITEM Alpha 32
Item Number This field contains the item
identifier.
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
Zero After Use This flag indicates whether the
quantity field is to be zeroed after
creation of the actual invoice for each
period.
BUL-QUANTITY Signed 13.4
Quantity This is the total quantity to be billed
for this customer recurring invoice
item.
BUL-SKIP-FLAG Alpha 1
Skip Emp/App if no Skip this period flag. Only valid if
Detail Flag zero after use is set to Yes. This lets
you pass the edit ensuring that all zero
after use lines have been set up for a
billing period and still skip billing a
line.
BUL-INVOICE-QTY Signed 13.4
Invoice Quantity This is the quantity to be billed on
the next invoice created for this
customer recurring invoice line.
BUL-BILLED-AMOUNT Signed 15.2
Billed Amount The total amount already billed against
this customer recurring invoice line.
BUL-SELL-UOM Alpha 4
Sell Unit of Measure This field contains the selling unit of
measure for the item.
BUL-UNIT-PRICE Signed 13.5
Unit Price This field contains the unit price.
BUL-SPR-UOM Alpha 4
Selling Price Unit This is the pricing unit of measure for
of Measure this line.
BUL-FREQUENCY Alpha 1
Frequency This is the frequency code for this
recurring invoice.
W = Weekly
S = Semi-Monthly
M = Monthly
Q = Quarterly
Y = Yearly
U = User Defined
BUL-CYCLE-CODE Alpha 3
Cycle Code This is the cycle code. Cycle code is
used to separate recurring invoices into
groups within frequency for processing.
BUL-START-DATE Numeric 8 (yyyymmdd)
Start Date This is the starting date. Invoices
created from this customer recurring
invoice after this date and prior to the
stop date will include this item.
BUL-STOP-DATE Numeric 8 (yyyymmdd)
Stop Date This is the stop date. Invoice created
for this customer recurring invoice
after this date will not include this
line.
BUL-TERRITORY Alpha 4
Sales Territory This field contains the sales territory.
BUL-SALESMAN Numeric 4
Salesman Number This field contains the code that
represents the primary sales
representative of this line. If left
blank, this defaults from the order
header.
BUL-SALESMAN-2 Numeric 4
Salesman Number 2 This field contains the code
representing the second sales
representative.
BUL-COMM-RATE-1 Percent 7.5 (Percent)
Commission Rate for This field contains the commission rate
Slsmn 1 of the primary sales representative.
BUL-COMM-RATE-2 Percent 7.5 (Percent)
Commission Rate for This field contains the commission rate
Slsmn 2 for the second sales representative.
BUL-COMM-SPLIT Percent 5.3 (Percent)
Commission Split This field contains the commission
Percentage split. This defaults from the customer
master.
BUL-STD-COMM1 Alpha 4
Std Comm1 Standard comment code 1. Code to
represent a group of comments.
BUL-STD-COMM2 Alpha 4
Std Comm2 Standard comment code 2. Code to
represent a group of comments.
BUL-STD-COMM3 Alpha 4
Std Comm3 Standard comment code 3. Code to
represent a group of comments.
BUL-LAST-MISC-SEQ Numeric 3
Last Misc Code Last sequence number used for add-on
Sequence charges for this customer recurring
invoice line.
BUL-LAST-COMM-SEQ Numeric 3 BLI2.1
Last Comment This is the sequence number of the last
Sequence Number comment line entered for this
requisition line.
BUL-MAST-LINE-NBR Numeric 6
Mast Line Nbr Line number of the recurring invoice
line that caused this customer recurring
invoice line.
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 BLI2.1
RECUR-INVOICE
CUSTOMER
LINE-NBR
BULSET2 COMPANY Subset
RECUR-INVOICE Where MAST-LINE-NBR != Zeroes
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
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
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
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
|
