|
|
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
Element: Company The company number represents an
established company and is entered on
all function codes.
BUL-RECUR-INVOICE Alpha 10
Element: Recur Invoice This is the recurring invoice
identifier.
BUL-CUSTOMER Alpha 9 (Right Justified)
Element: Customer NumbeThis field contains the number that
represents a customer.
BUL-SHIP-TO Numeric 4
Element: Ship-to Code This field contains the number
representing the ship to customer.
BUL-LINE-NBR Numeric 6
Element: Line Number This field contains the line number.
BUL-ITEM Alpha 32
Element: Item Number This field contains the item
identifier.
BUL-ITEM-DESC Alpha 30
Element: Item DescriptiThis field contains the description for
items.
BUL-LINE-TYPE Alpha 1
Element: Line Type This field contains the type of
inventory on this line.
N = Non-stock
X = Special Order
BUL-ZERO-AFTER-USE Alpha 1
Element: All Flag 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
Element: 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
Element: 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
Element: Adj Amt The total amount already billed against
this customer recurring invoice line.
BUL-SELL-UOM Alpha 4
Element: Unit of MeasurThis field contains the selling unit of
measure for the item.
BUL-UNIT-PRICE Signed 13.5
Element: Base Price
BUL-SPR-UOM Alpha 4
Element: Unit of MeasurThis is the pricing unit of measure for
this line.
BUL-FREQUENCY Alpha 1
Element: 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
Element: Authority CodeThis is the cycle code. Cycle code is
used to separate recurring invoices into
groups within frequency for processing.
BUL-START-DATE Numeric 8 (yyyymmdd)
Element: 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)
Element: 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
Element: Sales TerritorThis field contains the sales territory.
BUL-SALESMAN Numeric 4
Element: Salesman NumbeThis 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
Element: Salesman NumbeThis field contains the code
representing the second sales
representative.
BUL-COMM-RATE-1 Percent 7.5 (Percent)
Element: Chrg Rate This field contains the commission rate
of the primary sales representative.
BUL-COMM-RATE-2 Percent 7.5 (Percent)
Element: Chrg Rate This field contains the commission rate
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
Element: Standard CommeStandard comment code 1. Code to
represent a group of comments.
BUL-STD-COMM2 Alpha 4
Element: Standard CommeStandard comment code 2. Code to
represent a group of comments.
BUL-STD-COMM3 Alpha 4
Element: Standard CommeStandard comment code 3. Code to
represent a group of comments.
BUL-LAST-MISC-SEQ Numeric 3
Element: Sequence NumbeLast sequence number used for add-on
charges for this customer recurring
invoice line.
BUL-LAST-COMM-SEQ Numeric 3 BLI2.1
Element: Sequence Number
BUL-MAST-LINE-NBR Numeric 6
Element: Line Number Line number of the recurring invoice
line that caused this customer recurring
invoice line.
BUL-UNBILLED-AMT Derived
Element: Unbilled Amt Amount yet to be billed against this
line.
BUL-TOTAL-VALUE Derived
Element: Total Value Total amount to be billed against this
line.
BUL-IC-UOM-1 Derived
Element: Ic Uom 1 This field contains the first inventory
unit of measure for the item.
BUL-IC-UOM-2 Derived
Element: Ic Uom 2 This field contains the second
inventory unit of measure for the item.
BUL-IC-UOM-3 Derived
Element: Ic Uom 3 This field contains the third inventory
unit of measure for the item.
BUL-IC-UOM-4 Derived
Element: Ic Uom 4 This field contains the fourth
inventory unit of measure for the item.
BUL-IC-UOM-5 Derived
Element: Ic Uom 5 This field contains the fifth inventory
unit of measure for the item.
BUL-IC-UOM-6 Derived
Element: Ic Uom 6 This field contains the sixth inventory
unit of measure for the item.
BUL-STS-INDEX Derived
Element: Sts Index This field determines which inventory
unit of measure is used for display
purposes.
BUL-STS-M Derived
Element: Sts M This field contains the multiplier.
BUL-STS-MULT Derived
Element: Sts Mult This field contains the sales to stock
multiplier.
BUL-PTS-INDEX Derived
Element: Pts Index This field determines which unit of
measure to use in pricing.
BUL-PTS-M Derived
Element: Pts M This field contains the pricing
multiplier.
BUL-PTS-MULT Derived
Element: Pts Mult This field contains the pricing unit of
measure multiplier.
BUL-ITEM-16 Derived
Element: 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 -> -COMPANY (XXXXXXXXXX)
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
|
