|
|
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 This 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 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 Nbr 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 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 BL130 BL31.1
Element: Item Desc This field contains the description for BL31.2 BL31.3
items. BL31.5 BL31.7
BL32.3 BL32.4
BUL-LINE-TYPE Alpha 1 BL130 BL31.1
Element: Line Type This field contains the type of BL31.2 BL31.3
inventory on this line. BL31.5 BL31.7
N = Non-stock BL32.3 BL32.4
X = Special Order
I = Inventory
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
Element: Skip Flag Skip this period flag. Only valid if BL31.2 BL31.3
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: Uom This 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 BL31.2 BL31.3
BL31.5 BL31.7
BL32.3 BL32.4
BUL-SPR-UOM Alpha 4 BL130 BL31.1
Element: Uom This 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: Auth Code This 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: Territory This 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 This 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 This 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
Element: Comm Split This field contains the commission BL31.2 BL31.3
split. This defaults from the customer BL31.5 BL31.7
master. BL32.3 BL32.4
BUL-STD-COMM1 Alpha 4 BL130 BL31.1
Element: Std Comm Standard 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: Std Comm Standard 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: Std Comm Standard 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: Seq Last 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: Seq This field contains the record sequence BL31.2 BL31.3
number. BL31.5 BL31.7
BL32.3 BL32.4
BLI2.1
BUL-MAST-LINE-NBR Numeric 6 BL130 BL31.1
Element: Line Nbr 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.
BUL-TAX-CODE Alpha 10 BL130 BL31.1
Element: Tax Code This field contains a code representing BL31.2 BL31.3
specific tax information. This must be BL31.5 BL31.7
valid Tax Code. BL32.3 BL32.4
BUL-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
BUL-ACTIVITY Alpha 15 BL130 BL31.1
Element: Activity Activities are the processes or BL31.2 BL31.3
procedures that produce work. Cost BL31.5 BL31.7
objects (products, services, customers, BL32.3 BL32.4
and so on) are the reasons for
performing the activity.
BUL-ACCT-CATEGORY Alpha 5 BL130 BL31.1
Element: Acct Category Account categories are groupings of BL31.2 BL31.3
costs, revenues, or a combination of BL31.5 BL31.7
both used for reporting and inquiries BL32.3 BL32.4
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
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
BULSET2 COMPANY Subset BL30.3 BL30.5
RECUR-INVOICE Where MAST-LINE-NBR != Zeroes BL32.2 BLI2.1
MAST-LINE-NBR
CUSTOMER
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
When BUL-LINE-TYPE = "I"
And BUL-LINE-TYPE = "N"
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
|
