BLRIMAST FILE
Recurring Invoice
The Recurring Invoice file stores the parameters for a specific type of
service or combination of services. This sets the default for all customer
recurring invoices having the same recurring invoice number.
REFERENCED BY
BL230 BL231 BL232 BL33.1 BL331 BL34.1
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 BL961
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BRM-COMPANY Numeric 4 BL130 BL30.1
Company The company number represents an BL30.2 BL30.3
established company and is entered on BL30.5 BL31.1
all function codes. BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-RECUR-INVOICE Alpha 10 BL130 BL30.1
Recurring Invoice The unique recurring invoice identifier. BL30.2 BL30.3
BL30.5 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-DESCRIPTION Alpha 30 (Lower Case) BL130 BL30.1
Description This field contains the description. BL30.2 BL30.3
BL30.5 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-INVC-TYPE Alpha 4 BL130 BL30.1
Invoice Type The invoice type for invoices created BL30.2 BL30.3
for this recurring invoice. BL30.5 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-LIST-NAME Alpha 14 BL130 BL30.1
List Name The price list to use for all invoices BL30.2 BL30.3
created for this recurring invoice. If BL30.5 BL31.1
you do not enter this, the price list BL31.2 BL31.3
for the customer will be used when BL31.5 BL31.7
creating the invoices. BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-CURRENCY-CODE Alpha 5 BL130 BL30.1
Currency Code This field contains the company's base BL30.2 BL30.3
currency code established in the General BL30.5 BL31.1
Ledger system. BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-TERMS-CD Alpha 5 BL130 BL30.1
Terms Code The terms code to use for invoices BL30.2 BL30.3
created because of the recurring BL30.5 BL31.1
invoice. If left blank, the customer's BL31.2 BL31.3
terms code is used when the invoices are BL31.5 BL31.7
created. BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-REFERENCE Alpha 10 (Lower Case) BL130 BL30.1
Reference The reference number associated with BL30.2 BL30.3
the transaction. BL30.5 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-PROCESS-LEVEL Alpha 5 BL130 BL30.1
Process Level This field contains the process level, BL30.2 BL30.3
which is the reporting hierarchy below BL30.5 BL31.1
company. BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-LOCATION Alpha 5 BL130 BL30.1
Location Code This field contains a valid stock BL30.2 BL30.3
location within the company inventory. BL30.5 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-TERRITORY Alpha 4 BL130 BL30.1
Sales Territory Sales territory. Invoices created for BL30.2 BL30.3
this recurring invoice will have this BL30.5 BL31.1
territory code. If left blank, the BL31.2 BL31.3
invoice territory will default from the BL31.5 BL31.7
customer at the time of creation. BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-SALESMAN Numeric 4 BL130 BL30.1
Salesman Number This field contains the code that BL30.2 BL30.3
represents the primary sales BL30.5 BL31.1
representative of this line. If left BL31.2 BL31.3
blank, this defaults from the customer BL31.5 BL31.7
file. BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-SALESMAN-2 Numeric 4 BL130 BL30.1
Salesman Number 2 This field contains the code BL30.2 BL30.3
representing the second sales BL30.5 BL31.1
representative. This defaults from the BL31.2 BL31.3
customer file. BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-COMM-RATE-1 Percent 7.5 (Percent) BL130 BL30.1
Commission Rate for This field contains the commission rate BL30.2 BL30.3
Slsmn 1 of the primary sales representative. BL30.5 BL31.1
This defaults from the customer file. BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-COMM-RATE-2 Percent 7.5 (Percent) BL130 BL30.1
Commission Rate for This field contains the commission rate BL30.2 BL30.3
Slsmn 2 for the second sales representative. BL30.5 BL31.1
This defaults from the customer file. BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-COMM-SPLIT Percent 5.3 (Percent) BL130 BL30.1
Commission Split This field contains the commission BL30.2 BL30.3
Percentage split. This defaults from the customer BL30.5 BL31.1
file. BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-FREQUENCY Alpha 1 BL130 BL30.1
Frequency The billing frequency. This option BL30.2 BL30.3
determines how often a customer getting BL30.5 BL31.1
this service is billed. BL31.2 BL31.3
W = Weekly BL31.5 BL31.7
S = Semi-Monthly BL32.1 BL32.2
M = Monthly BL32.3 BL32.4
Q = Quarterly BL961
Y = Yearly
U = User Defined
BRM-CYCLE-CODE Alpha 3 BL130 BL30.1
Cycle Code The user-defined cycle code. Used to BL30.2 BL30.3
group recurring invoices for creation at BL30.5 BL31.1
a level lower than frequency. BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-BILL-MONTH Numeric 2 BL130 BL30.1
Bill Month Indicates which month the invoice is BL30.2 BL30.3
due. This is valid only for quarterly BL30.5 BL31.1
and yearly billing frequencies. For a BL31.2 BL31.3
quarterly frequency, the valid values BL31.5 BL31.7
are 1 through 3, and for a yearly BL32.1 BL32.2
frequency, valid values are 1 through BL32.3 BL32.4
12. BL961
BRM-BILL-DAY Numeric 2 BL130 BL30.1
Bill Day The day of the month an invoice is due. BL30.2 BL30.3
This field is used for computing the BL30.5 BL31.1
billing date; it is valid for BL31.2 BL31.3
semi-monthly, monthly, quarterly, and BL31.5 BL31.7
yearly billing frequencies. For a BL32.1 BL32.2
semi-monthly invoice, values 1 through BL32.3 BL32.4
15 are valid and for other frequencies, BL961
values 1 through 31 are valid. If the
day entered is greater than the
available number of days in a billing
month, the last day of that month is
used to compute the billing date.
BRM-BILL-DAY-OF-WK Numeric 1 BL130 BL30.1
Bill Day of Week The day of the week the invoice is for. BL30.2 BL30.3
This is valid only for weekly billing BL30.5 BL31.1
frequency. BL31.2 BL31.3
1 = Sunday BL31.5 BL31.7
2 = Monday BL32.1 BL32.2
3 = Tuesday BL32.3 BL32.4
4 = Wednesday BL961
5 = Thursday
6 = Friday
7 = Saturday
BRM-NBR-OF-INVCS Numeric 3 BL130 BL30.1
Number of Invoices The total number of invoices to be BL30.2 BL30.3
created for this recurring invoice. BL30.5 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-START-DATE Numeric 8 (yyyymmdd) BL130 BL30.1
Start Date Indicates when the template went into BL30.2 BL30.3
effect. This determines when a customer BL30.5 BL31.1
recurring invoice can be created. BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-STOP-DATE Numeric 8 (yyyymmdd) BL130 BL30.1
Stop Date The stop date for this template. After BL30.2 BL30.3
this date, a customer service contract BL30.5 BL31.1
can no longer be created. An existing BL31.2 BL31.3
customer recurring invoice can still be BL31.5 BL31.7
effective after this date. BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-CURR-BILL-DATE Numeric 8 (yyyymmdd) BL130 BL30.1
Current Billing Date This indicates the current billing date BL30.2 BL30.3
for this recurring invoice. This is used BL30.5 BL31.1
as the basis to calculate the next BL31.2 BL31.3
billing date for all billing frequencies BL31.5 BL31.7
except the user-defined frequency. If BL32.1 BL32.2
this field has zero value, the current BL32.3 BL32.4
date is used as the basis to calculate BL961
the next billing date.
BRM-ACTIVITY Alpha 15 BL130 BL30.1
Activity Activities are the processes or BL30.2 BL30.3
procedures that produce work. Cost BL30.5 BL31.1
objects (products, services, customers, BL31.2 BL31.3
and so on) are the reasons for BL31.5 BL31.7
performing the activity. Activities and BL32.1 BL32.2
cost object activities are used BL32.3 BL32.4
synonymously in the Activity Management BL961
system. Direct costs are posted to
activities, and indirect costs are
allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two types of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
BRM-ACCT-CATEGORY Alpha 5 BL130 BL30.1
Account Category Account categories are groupings of BL30.2 BL30.3
costs, revenues, or a combination of BL30.5 BL31.1
both used for reporting and inquiries BL31.2 BL31.3
for activities in the Activity BL31.5 BL31.7
Management system. All transactions are BL32.1 BL32.2
posted to an account category within an BL32.3 BL32.4
activity. You can assign a specific BL961
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.
BRM-STD-COMM1 Alpha 4 BL130 BL30.1
Standard Comment 1 The standard comment code. This comment BL30.2 BL30.3
code will be attached to all customer BL30.5 BL31.1
recurring invoices created. BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-STD-COMM2 Alpha 4 BL130 BL30.1
Standard Comment 2 The standard comment code. This comment BL30.2 BL30.3
code will be attached to all customer BL30.5 BL31.1
recurring invoices created. BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-STD-COMM3 Alpha 4 BL130 BL30.1
Standard Comment 3 The standard comment code. This comment BL30.2 BL30.3
code will be attached to all customer BL30.5 BL31.1
recurring invoices created. BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-TRANS-USER1 Alpha 10 BL130 BL30.1
Trans User 1 User field 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
BL961
BRM-TRANS-USER2 Alpha 15 BL130 BL30.1
Trans User 2 User field 2. BL30.2 BL30.3
BL30.5 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-TRANS-USER3 Numeric 8 (yyyymmdd) BL130 BL30.1
Trans User 3 User field 3. BL30.2 BL30.3
BL30.5 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-TRANS-USER4 Numeric 9 BL130 BL30.1
Trans User 4 User field 4. BL30.2 BL30.3
BL30.5 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-TRANS-USER5 Signed 13.2 BL130 BL30.1
Trans User 5 User field 5. BL30.2 BL30.3
BL30.5 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-LAST-LINE-NBR Numeric 6 BL130 BL30.1
Last Line Number This is the number of the last line BL30.2 BL30.3
item added. It is used to determine the BL30.5 BL31.1
number when the next line is added. BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-LAST-MISC-SEQ Numeric 3 BL130 BL30.1
Last Misc Code Last sequence number used for add-on BL30.2 BL30.3
Sequence charges for this recurring invoice. BL30.5 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-LAST-COMM-SEQ Numeric 3 BL130 BL30.1
Last Comment This is the sequence number of the last BL30.2 BL30.3
Sequence Number comment line entered for this line. BL30.5 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL961
BRM-USED-FL Alpha 1 BL130 BL30.1
Used Flag to indicate whether this recurring BL30.2 BL30.3
invoice has or did have any customer BL30.5 BL31.1
recurring invoices created for it. BL31.2 BL31.3
Y = Yes BL31.5 BL31.7
N = No BL32.1 BL32.2
BL32.3 BL32.4
BL961
BLRIMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BRMSET1 COMPANY BL130 BL230
RECUR-INVOICE BL231 BL232
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 BL33.1
BL330 BL331
BL34.1 BL961
BRMSET2 COMPANY KeyChange BL130
FREQUENCY
RECUR-INVOICE
BLRIMAST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Blrimsgblk BLRIMSGBLK Not Required
BRM-COMPANY -> MSG-COMPANY
BRM-RECUR-INVOICE -> MSG-RECUR-INVOICE
Zeroes -> MSG-LINE-NBR
Zeroes -> MSG-SEQ
Cucodes CUCODES Required
BRM-CURRENCY-CODE -> CUC-CURRENCY-CODE
Iclocation ICLOCATION Required
When BRM-LOCATION != Spaces
BRM-COMPANY -> ICL-COMPANY
BRM-LOCATION -> ICL-LOCATION
Oecommhdr1 OECOMMHDR Not Required
Valid When BRM-STD-COMM1 != Spaces
BRM-COMPANY -> OCH-COMPANY
BRM-STD-COMM1 -> OCH-STD-COMM
Oecommhdr2 OECOMMHDR Not Required
Valid When BRM-STD-COMM2 != Spaces
BRM-COMPANY -> OCH-COMPANY
BRM-STD-COMM2 -> OCH-STD-COMM
Oecommhdr3 OECOMMHDR Not Required
Valid When BRM-STD-COMM3 != Spaces
BRM-COMPANY -> OCH-COMPANY
BRM-STD-COMM3 -> OCH-STD-COMM
Oecompany OECOMPANY Required
BRM-COMPANY -> OEC-COMPANY
Oeinvctype OEINVCTYPE Required
BRM-COMPANY -> OIN-COMPANY
BRM-INVC-TYPE -> OIN-INVC-TYPE
Oeprclist OEPRCLIST Not Required
Valid When BRM-LIST-NAME != Spaces
BRM-COMPANY -> OPL-COMPANY
Spaces -> OPL-CUSTOMER
BRM-LIST-NAME -> OPL-LIST-NAME
Spaces -> OPL-PROMOTION
Oeproclev OEPROCLEV Required
BRM-COMPANY -> OEP-COMPANY
BRM-PROCESS-LEVEL -> OEP-PROCESS-LEVEL
Salesman SALESREP Required
When BRM-SALESMAN != Zeroes
BRM-COMPANY -> SAW-COMPANY
BRM-SALESMAN -> SAW-SALESMAN
Salesman2 SALESREP Required
When BRM-SALESMAN-2 != Zeroes
BRM-COMPANY -> SAW-COMPANY
BRM-SALESMAN-2 -> SAW-SALESMAN
Terms TERMS Required
When BRM-TERMS-CD != Spaces
BRM-TERMS-CD -> TMS-TERMS-CD
Territory TERITORY Required
When BRM-TERRITORY != Spaces
BRM-COMPANY -> TRY-COMPANY
BRM-TERRITORY -> TRY-TERRITORY
BLRIMAST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oecustsrvc BLRICUST
BRM-COMPANY -> BRC-COMPANY
BRM-RECUR-INVOICE -> BRC-RECUR-INVOICE
BRC-CUSTOMER
Oemscomm BLRIMCOMM
BRM-COMPANY -> BMC-COMPANY
BRM-RECUR-INVOICE -> BMC-RECUR-INVOICE
Zeroes -> BMC-LINE-NBR
BMC-SEQ
Oemsline BLRIMLINE
BRM-COMPANY -> BML-COMPANY
BRM-RECUR-INVOICE -> BML-RECUR-INVOICE
BML-LINE-NBR
Oemsmisc BLRIMMISC
BRM-COMPANY -> BMM-COMPANY
BRM-RECUR-INVOICE -> BMM-RECUR-INVOICE
Zeroes -> BMM-LINE-NBR
BMM-SEQ
|