|
|
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 Number This field contains the line number. BL32.2
BML-ITEM Alpha 32 BL30.3 BL30.5
Element: Item Number 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: Unit of MeasurThis 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 This field contains the unit price. BL32.2
BML-SPR-UOM Alpha 4 BL30.3 BL30.5
Element: Unit of MeasurThe 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: Sales TerritorSales 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 NumbeThis 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 NumbeThis 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
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
Element: Standard CommeStandard 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: Standard CommeStandard 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: Standard CommeStandard 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: Sequence NumbeLast 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: Sequence NumbeThis 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.
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
|
