|
|
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
Company The company number represents an BL32.2
established company and is entered on
all function codes.
BML-RECUR-INVOICE Alpha 10 BL30.3 BL30.5
Recurring Invoice This is the recurring invoice BL32.2
identifier.
BML-LINE-NBR Numeric 6 BL30.3 BL30.5
Line Number This field contains the line number. BL32.2
BML-ITEM Alpha 32 BL30.3 BL30.5
Item Number This field contains the item BL32.2
identifier.
BML-QUANTITY Signed 13.4 BL30.3 BL30.5
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
Sell Unit of Measure This field contains the stock unit of BL32.2
measure for the item.
BML-UNIT-PRICE Signed 13.5 BL30.3 BL30.5
Unit Price This field contains the unit price. BL32.2
BML-SPR-UOM Alpha 4 BL30.3 BL30.5
Selling Price Unit The pricing unit of measure for this BL32.2
of Measure line.
BML-ZERO-AFTER-USE Alpha 1 BL30.3 BL30.5
Zero After Use 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
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
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
Sales 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
Salesman Number 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
Salesman Number 2 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
Commission Rate for This field contains the commission rate BL32.2
Slsmn 1 of the primary sales representative.
This defaults from the customer file.
BML-COMM-RATE-2 Percent 7.5 (Percent) BL30.3 BL30.5
Commission Rate for This field contains the commission rate BL32.2
Slsmn 2 for the second sales representative.
This defaults from the customer file.
BML-COMM-SPLIT Percent 5.3 (Percent) BL30.3 BL30.5
Commission Split This field contains the commission BL32.2
Percentage split. This defaults from the customer
file.
BML-STD-COMM1 Alpha 4 BL30.3 BL30.5
Standard Comment 1 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
Standard Comment 2 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
Standard Comment 3 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
Last Misc Code Last sequence number used for add-on BL32.2
Sequence charges attached to this recurring
invoice line.
BML-LAST-COMM-SEQ Numeric 3 BL30.3 BL30.5
Last Comment This is the sequence number of the last BL32.2
Sequence Number comment line entered for this line.
BML-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.
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
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
|