Lawson Insight Technical Documentation |
|
BLRIMAST
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BRM-COMPANY Numeric 4 BL130 BL30.1
Element: Company Identifies the AP company if the BL30.2 BL30.3
resource type = V. Identifies the HR BL30.5 BL31.1
company if the resource type = E. It is BL31.2 BL31.3
blank for type A, P or Q resources. BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BRM-RECUR-INVOICE Alpha 10 BL130 BL30.1
Element: Recur 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
BRM-DESCRIPTION Alpha 30 (Lower Case) BL130 BL30.1
Element: Description This field displays 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
BRM-INVC-TYPE Alpha 4 BL130 BL30.1
Element: Invc 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
BRM-LIST-NAME Alpha 14 BL130 BL30.1
Element: 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
BRM-CURRENCY-CODE Alpha 5 BL130 BL30.1
Element: 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
BRM-TERMS-CD Alpha 5 BL130 BL30.1
Element: Term 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
BRM-REFERENCE Alpha 10 (Lower Case) BL130 BL30.1
Element: 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
BRM-PROCESS-LEVEL Alpha 5 BL130 BL30.1
Element: 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
BRM-LOCATION Alpha 5 BL130 BL30.1
Element: Location 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
BRM-TERRITORY Alpha 4 BL130 BL30.1
Element: 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
BRM-SALESMAN Numeric 4 BL130 BL30.1
Element: Salesman 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
BRM-SALESMAN-2 Numeric 4 BL130 BL30.1
Element: Salesman 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
BRM-COMM-RATE-1 Percent 7.5 (Percent) BL130 BL30.1
Element: Chrg Rate This field contains the commission rate BL30.2 BL30.3
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
BRM-COMM-RATE-2 Percent 7.5 (Percent) BL130 BL30.1
Element: Chrg Rate This field contains the commission rate BL30.2 BL30.3
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
BRM-COMM-SPLIT Percent 5.3 (Percent) BL130 BL30.1
Element: Comm Split This field contains the commission BL30.2 BL30.3
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
BRM-FREQUENCY Alpha 1 BL130 BL30.1
Element: 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
Y = Yearly
U = User Defined
BRM-CYCLE-CODE Alpha 3 BL130 BL30.1
Element: Auth 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
BRM-BILL-MONTH Numeric 2 BL130 BL30.1
Element: Curr Period 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.
01 = January
02 = February
03 = March
04 = April
05 = May
06 = June
07 = July
08 = August
09 = September
10 = October
11 = November
12 = December
BRM-BILL-DAY Numeric 2 BL130 BL30.1
Element: 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,
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
Element: 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
5 = Thursday
6 = Friday
7 = Saturday
BRM-NBR-OF-INVCS Numeric 3 BL130 BL30.1
Element: Nbr Of Invcs 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
BRM-START-DATE Numeric 8 (yyyymmdd) BL130 BL30.1
Element: 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
BRM-STOP-DATE Numeric 8 (yyyymmdd) BL130 BL30.1
Element: 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
BRM-CURR-BILL-DATE Numeric 8 (yyyymmdd) BL130 BL30.1
Element: 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
the next billing date.
BRM-ACTIVITY Alpha 15 BL130 BL30.1
Element: 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
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
Element: Acct 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
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
Element: Std Comm 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
BRM-STD-COMM2 Alpha 4 BL130 BL30.1
Element: Std Comm 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
BRM-STD-COMM3 Alpha 4 BL130 BL30.1
Element: Std Comm 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
BRM-TRANS-USER1 Alpha 10 BL130 BL30.1
Element: Trans User1 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
BRM-TRANS-USER2 Alpha 15 BL130 BL30.1
Element: Agent 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
BRM-TRANS-USER3 Numeric 8 (yyyymmdd) BL130 BL30.1
Element: Trans User3 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
BRM-TRANS-USER4 Numeric 9 BL130 BL30.1
Element: Trans User4 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
BRM-TRANS-USER5 Signed 18.2 BL130 BL30.1
Element: Intl Amt 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
BRM-LAST-LINE-NBR Numeric 6 BL130 BL30.1
Element: Line Nbr 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
BRM-LAST-MISC-SEQ Numeric 3 BL130 BL30.1
Element: Seq Last sequence number used for add-on BL30.2 BL30.3
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
BRM-LAST-COMM-SEQ Numeric 3 BL130 BL30.1
Element: Seq This is the sequence number of the last BL30.2 BL30.3
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
BRM-USED-FL Alpha 1 BL130 BL30.1
Element: Used Fl 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
BRM-TAX-CODE Alpha 10 BL130 BL30.1
Element: Tax Code This field contains a code representing BL30.2 BL30.3
specific tax information. This must be BL30.5 BL31.1
valid Tax Code. BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BRM-TAX-EXEMPT-CD Alpha 1 BL130 BL30.1
Element: Tax Exempt Cd Code indicating the taxing status. E - BL30.2 BL30.3
Exempt, T - Taxable. BL30.5 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
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
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
|