|
|
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
BL130 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 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. BL33.1
BUL-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
BL33.1
BUL-CUSTOMER Alpha 9 (Right Justified) BL130 BL31.1
Element: Customer NumbeThis field contains the number that BL31.2 BL31.3
represents a customer. BL31.5 BL31.7
BL32.3 BL32.4
BL33.1
BUL-SHIP-TO Numeric 4 BL130 BL31.1
Element: Ship-to Code This field contains the number BL31.2 BL31.3
representing the ship to customer. BL31.5 BL31.7
BL32.3 BL32.4
BUL-LINE-NBR Numeric 6 BL130 BL31.1
Element: Line Number This field contains the line number. BL31.2 BL31.3
BL31.5 BL31.7
BL32.3 BL32.4
BL33.1
BUL-ITEM Alpha 32 BL130 BL31.1
Element: Item Number This field contains the item BL31.2 BL31.3
identifier. BL31.5 BL31.7
BL32.3 BL32.4
BL33.1
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 BL130 BL31.1
Element: All Flag This flag indicates whether the BL31.2 BL31.3
quantity field is to be zeroed after BL31.5 BL31.7
creation of the actual invoice for each BL32.3 BL32.4
period.
BUL-QUANTITY Signed 13.4 BL130 BL31.1
Element: Quantity This is the total quantity to be billed BL31.2 BL31.3
for this customer recurring invoice BL31.5 BL31.7
item. BL32.3 BL32.4
BL33.1
BUL-SKIP-FLAG Alpha 1 BL130 BL31.1
Skip Emp/App if no Skip this period flag. Only valid if BL31.2 BL31.3
Detail Flag zero after use is set to Yes. This lets BL31.5 BL31.7
you pass the edit ensuring that all zero BL32.3 BL32.4
after use lines have been set up for a BL33.1
billing period and still skip billing a
line.
BUL-INVOICE-QTY Signed 13.4 BL130 BL31.1
Element: Quantity This is the quantity to be billed on BL31.2 BL31.3
the next invoice created for this BL31.5 BL31.7
customer recurring invoice line. BL32.3 BL32.4
BUL-BILLED-AMOUNT Signed 18.2 BL130 BL31.1
Element: Intl Amt The total amount already billed against BL31.2 BL31.3
this customer recurring invoice line. BL31.5 BL31.7
BL32.3 BL32.4
BUL-SELL-UOM Alpha 4 BL130 BL31.1
Element: Unit of MeasurThis field contains the selling unit of BL31.2 BL31.3
measure for the item. BL31.5 BL31.7
BL32.3 BL32.4
BUL-UNIT-PRICE Signed 18.5 BL130 BL31.1
Element: Intl Cost This field contains the unit price. BL31.2 BL31.3
BL31.5 BL31.7
BL32.3 BL32.4
BUL-SPR-UOM Alpha 4 BL130 BL31.1
Element: Unit of MeasurThis is the pricing unit of measure for BL31.2 BL31.3
this line. BL31.5 BL31.7
BL32.3 BL32.4
BUL-FREQUENCY Alpha 1 BL130 BL31.1
Element: Frequency This is the frequency code for this BL31.2 BL31.3
recurring invoice. BL31.5 BL31.7
W = Weekly BL32.3 BL32.4
S = Semi-Monthly
M = Monthly
Q = Quarterly
Y = Yearly
U = User Defined
BUL-CYCLE-CODE Alpha 3 BL130 BL31.1
Element: Authority CodeThis is the cycle code. Cycle code is BL31.2 BL31.3
used to separate recurring invoices into BL31.5 BL31.7
groups within frequency for processing. BL32.3 BL32.4
BUL-START-DATE Numeric 8 (yyyymmdd) BL130 BL31.1
Element: Start Date This is the starting date. Invoices BL31.2 BL31.3
created from this customer recurring BL31.5 BL31.7
invoice after this date and prior to the BL32.3 BL32.4
stop date will include this item.
BUL-STOP-DATE Numeric 8 (yyyymmdd) BL130 BL31.1
Element: Stop Date This is the stop date. Invoice created BL31.2 BL31.3
for this customer recurring invoice BL31.5 BL31.7
after this date will not include this BL32.3 BL32.4
line.
BUL-TERRITORY Alpha 4 BL130 BL31.1
Element: Sales TerritorThis field contains the sales territory. BL31.2 BL31.3
BL31.5 BL31.7
BL32.3 BL32.4
BUL-SALESMAN Numeric 4 BL130 BL31.1
Element: Salesman NumbeThis field contains the code that BL31.2 BL31.3
represents the primary sales BL31.5 BL31.7
representative of this line. If left BL32.3 BL32.4
blank, this defaults from the order
header.
BUL-SALESMAN-2 Numeric 4 BL130 BL31.1
Element: Salesman NumbeThis field contains the code BL31.2 BL31.3
representing the second sales BL31.5 BL31.7
representative. BL32.3 BL32.4
BUL-COMM-RATE-1 Percent 7.5 (Percent) BL130 BL31.1
Element: Chrg Rate This field contains the commission rate BL31.2 BL31.3
of the primary sales representative. BL31.5 BL31.7
BL32.3 BL32.4
BUL-COMM-RATE-2 Percent 7.5 (Percent) BL130 BL31.1
Element: Chrg Rate This field contains the commission rate BL31.2 BL31.3
for the second sales representative. BL31.5 BL31.7
BL32.3 BL32.4
BUL-COMM-SPLIT Percent 5.3 (Percent) BL130 BL31.1
Commission Split This field contains the commission BL31.2 BL31.3
Percentage split. This defaults from the customer BL31.5 BL31.7
master. BL32.3 BL32.4
BUL-STD-COMM1 Alpha 4 BL130 BL31.1
Element: Standard CommeStandard comment code 1. Code to BL31.2 BL31.3
represent a group of comments. BL31.5 BL31.7
BL32.3 BL32.4
BUL-STD-COMM2 Alpha 4 BL130 BL31.1
Element: Standard CommeStandard comment code 2. Code to BL31.2 BL31.3
represent a group of comments. BL31.5 BL31.7
BL32.3 BL32.4
BUL-STD-COMM3 Alpha 4 BL130 BL31.1
Element: Standard CommeStandard comment code 3. Code to BL31.2 BL31.3
represent a group of comments. BL31.5 BL31.7
BL32.3 BL32.4
BUL-LAST-MISC-SEQ Numeric 3 BL130 BL31.1
Element: Sequence NumbeLast sequence number used for add-on BL31.2 BL31.3
charges for this customer recurring BL31.5 BL31.7
invoice line. BL32.3 BL32.4
BUL-LAST-COMM-SEQ Numeric 3 BL130 BL31.1
Element: Sequence NumbeThis is the sequence number of the last BL31.2 BL31.3
comment line entered for this BL31.5 BL31.7
requisition line. BL32.3 BL32.4
BLI2.1
BUL-MAST-LINE-NBR Numeric 6 BL130 BL31.1
Element: Line Number Line number of the recurring invoice BL31.2 BL31.3
line that caused this customer recurring BL31.5 BL31.7
invoice line. BL32.3 BL32.4
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 BL130 BL231
RECUR-INVOICE BL31.1 BL31.2
CUSTOMER BL31.3 BL31.5
LINE-NBR BL31.7 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 BL130
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
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
|
