|
BLRIMLINE FILE
Recurring Invoice Item
This file stores the line items for this recurring invoice. These line items
will be created on any customer recurring invoice associated with this
recurring invoice.
REFERENCED BY
BL230
UPDATED BY
BL130 BL30.1 BL30.2 BL30.3 BL30.5 BL31.1
BL31.2 BL31.3 BL31.5 BL31.7 BL32.1 BL32.2
BL32.3 BL32.4 BL330
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BML-COMPANY Numeric 4 BL30.3 BL30.5
Element: Company Identifies the AP company if the BL32.2
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
BML-RECUR-INVOICE Alpha 10 BL30.3 BL30.5
Element: Recur Invoice This is the recurring invoice BL32.2
identifier.
BML-LINE-NBR Numeric 6 BL30.3 BL30.5
Element: Line Nbr This field contains the line number. BL32.2
BML-ITEM Alpha 32 BL30.3 BL30.5
Element: Item This field contains the item BL32.2
identifier.
BML-QUANTITY Signed 13.4 BL30.3 BL30.5
Element: Quantity This field contains the quantity to be BL32.2
billed each period. It is required if
the zero after use flag is set off.
BML-SELL-UOM Alpha 4 BL30.3 BL30.5
Element: Uom This field contains the stock unit of BL32.2
measure for the item.
BML-UNIT-PRICE Signed 18.5 BL30.3 BL30.5
Element: Intl Cost BL32.2
BML-SPR-UOM Alpha 4 BL30.3 BL30.5
Element: Uom The pricing unit of measure for this BL32.2
line.
BML-ZERO-AFTER-USE Alpha 1 BL30.3 BL30.5
Element: All Flag Indicates whether the quantity field in BL32.2
the customer contract service line is to
be cleared once the current invoice is
created. This option is useful for
charges that vary from invoice to
invoice, based on some metering.
Y = Yes
N = No
BML-START-DATE Numeric 8 (yyyymmdd) BL30.3 BL30.5
Element: Start Date Indicates when this line went into BL32.2
effect. This line will be added to a
customer recurring invoice created after
this date, provided the creation date is
not greater than the stop date.
BML-STOP-DATE Numeric 8 (yyyymmdd) BL30.3 BL30.5
Element: Stop Date The stop date for this line. After this BL32.2
date, this line will no longer be added
to the customer recurring invoice when
it is created.
BML-TERRITORY Alpha 4 BL30.3 BL30.5
Element: Territory Sales territory. If left blank, the BL32.2
territory will default from the customer
when the actual invoices are created for
this recurring invoice line.
BML-SALESMAN Numeric 4 BL30.3 BL30.5
Element: Salesman This field contains the code that BL32.2
represents the primary sales
representative of this line. If left
blank, this defaults from the customer
file.
BML-SALESMAN-2 Numeric 4 BL30.3 BL30.5
Element: Salesman This field contains the code BL32.2
representing the second sales
representative. This defaults from the
customer file.
BML-COMM-RATE-1 Percent 7.5 (Percent) BL30.3 BL30.5
Element: Chrg Rate This field contains the commission rate BL32.2
of the primary sales representative.
This defaults from the customer file.
BML-COMM-RATE-2 Percent 7.5 (Percent) BL30.3 BL30.5
Element: Chrg Rate This field contains the commission rate BL32.2
for the second sales representative.
This defaults from the customer file.
BML-COMM-SPLIT Percent 5.3 (Percent) BL30.3 BL30.5
Element: Comm Split This field contains the commission BL32.2
split. This defaults from the customer
file.
BML-STD-COMM1 Alpha 4 BL30.3 BL30.5
Element: Std Comm Standard comment code points to a group BL32.2
of comments to be copied onto invoices
created for this recurring invoice line.
BML-STD-COMM2 Alpha 4 BL30.3 BL30.5
Element: Std Comm Standard comment code points to a group BL32.2
of comments to be copied onto invoices
created for this recurring invoice line.
BML-STD-COMM3 Alpha 4 BL30.3 BL30.5
Element: Std Comm Standard comment code points to a group BL32.2
of comments to be copied onto invoices
created for this recurring invoice line.
BML-LAST-MISC-SEQ Numeric 3 BL30.3 BL30.5
Element: Seq Last sequence number used for add-on BL32.2
charges attached to this recurring
invoice line.
BML-LAST-COMM-SEQ Numeric 3 BL30.3 BL30.5
Element: Seq This is the sequence number of the last BL32.2
comment line entered for this line.
BML-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.
BML-TAX-CODE Alpha 10 BL30.3 BL30.5
Element: Tax Code This field contains a code representing BL32.2
specific tax information. This must be
valid Tax Code.
BML-TAX-EXEMPT-CD Alpha 1 BL30.3 BL30.5
Element: Tax Exempt Cd Code indicating the taxing status. E - BL32.2
Exempt, T - Taxable.
BML-ACTIVITY Alpha 15 BL30.3 BL30.5
Element: Activity Activities are the processes or BL32.2
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
BML-ACCT-CATEGORY Alpha 5 BL30.3 BL30.5
Element: Acct Category Account categories are groupings of BL32.2
costs, revenues, or a combination of
both used for reporting and inquiries
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
BML-ITEM-DESC Alpha 30 (Lower Case) BL30.3 BL30.5
Element: Description This field displays the description. BL32.2
BML-LINE-TYPE Alpha 1 BL30.3 BL30.5
Element: Line Type This field contains the type of BL32.2
inventory on this line.
I = Inventory
N = Non-Stock
X = Special
BLRIMLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BMLSET1 COMPANY BL130 BL230
RECUR-INVOICE BL30.1 BL30.2
LINE-NBR BL30.3 BL30.5
BL31.1 BL31.2
BL31.3 BL31.5
BL31.7 BL32.1
BL32.2 BL32.3
BL32.4 BL330
BLRIMLINE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Blrimsgblk BLRIMSGBLK Not Required
BML-COMPANY -> MSG-COMPANY
BML-RECUR-INVOICE -> MSG-RECUR-INVOICE
BML-LINE-NBR -> MSG-LINE-NBR
Zeroes -> MSG-SEQ
Iccompany ICCOMPANY Required
BML-COMPANY -> ICC-COMPANY
Itemmast ITEMMAST Required
When BML-LINE-TYPE = "N"
Or BML-LINE-TYPE = "I"
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
BML-ITEM -> ITE-ITEM
Oecommhdr1 OECOMMHDR Not Required
Valid When BML-STD-COMM1 != Spaces
BML-COMPANY -> OCH-COMPANY
BML-STD-COMM1 -> OCH-STD-COMM
Oecommhdr2 OECOMMHDR Not Required
Valid When BML-STD-COMM2 != Spaces
BML-COMPANY -> OCH-COMPANY
BML-STD-COMM2 -> OCH-STD-COMM
Oecommhdr3 OECOMMHDR Not Required
Valid When BML-STD-COMM3 != Spaces
BML-COMPANY -> OCH-COMPANY
BML-STD-COMM3 -> OCH-STD-COMM
Oecompany OECOMPANY Required
BML-COMPANY -> OEC-COMPANY
Oemastsrvc BLRIMAST Required
BML-COMPANY -> BRM-COMPANY
BML-RECUR-INVOICE -> BRM-RECUR-INVOICE
Salesman SALESREP Required
When BML-SALESMAN != Zeroes
BML-COMPANY -> SAW-COMPANY
BML-SALESMAN -> SAW-SALESMAN
Salesman 2 SALESREP Required
When BML-SALESMAN-2 != Zeroes
BML-COMPANY -> SAW-COMPANY
BML-SALESMAN-2 -> SAW-SALESMAN
Territory TERITORY Required
When BML-TERRITORY != Spaces
BML-COMPANY -> TRY-COMPANY
BML-TERRITORY -> TRY-TERRITORY
BLRIMLINE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oecsline BLRICLINE
BML-COMPANY -> BUL-COMPANY
BML-RECUR-INVOICE -> BUL-RECUR-INVOICE
BML-LINE-NBR -> BUL-MAST-LINE-NBR
BUL-CUSTOMER
Oemscomm BLRIMCOMM
BML-COMPANY -> BMC-COMPANY
BML-RECUR-INVOICE -> BMC-RECUR-INVOICE
BML-LINE-NBR -> BMC-LINE-NBR
BMC-SEQ
Oemsmisc BLRIMMISC
BML-COMPANY -> BMM-COMPANY
BML-RECUR-INVOICE -> BMM-RECUR-INVOICE
BML-LINE-NBR -> BMM-LINE-NBR
BMM-SEQ
|