BLRICUST FILE
Customer Recurring Invoice
This file stores the header information for customer recurring invoices. Most
of this data defaults from the associated recurring invoice. However, the
user can then add or modify that information for this specific customer.
REFERENCED BY
BL231 BL30.1 BL30.2 BL30.3 BL30.5 BL33.1
BL330 BL34.1
UPDATED BY
BL130 BL31.1 BL31.2 BL31.3 BL31.5 BL31.7
BL32.3 BL32.4 BL331 BL960
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BRC-COMPANY Numeric 4 BL130 BL31.1
Company The company number represents an BL31.2 BL31.3
established company and is entered on BL31.5 BL31.7
all function codes. BL32.3 BL32.4
BL960
BRC-RECUR-INVOICE Alpha 10 BL130 BL31.1
Recurring Invoice This is the recurring invoice BL31.2 BL31.3
identifier. BL31.5 BL31.7
BL32.3 BL32.4
BL960
BRC-CUSTOMER Alpha 9 (Right Justified) BL130 BL31.1
Customer Number This field contains the number that BL31.2 BL31.3
represents a customer. BL31.5 BL31.7
BL32.3 BL32.4
BL960
BRC-SHIP-TO Numeric 4 BL130 BL31.1
Ship-to Code This field contains the number BL31.2 BL31.3
representing the ship-to customer. BL31.5 BL31.7
BL32.3 BL32.4
BL960
BRC-CONTACT Alpha 20 BL130 BL31.1
Primary Contact This is the name of the main contact. BL31.2 BL31.3
BL31.5 BL31.7
BL32.3 BL32.4
BL960
BRC-PHONE-NBR Numeric 10 BL130 BL31.1
Telephone Number The phone number of the manager in BL31.2 BL31.3
charge. BL31.5 BL31.7
BL32.3 BL32.4
BL960
BRC-CURRENCY-CODE Alpha 5 BL130 BL31.1
Currency Code This field contains the company's base BL31.2 BL31.3
currency code defined in the General BL31.5 BL31.7
Ledger system. BL32.3 BL32.4
BL960
BRC-HOLD-CODE Alpha 4 BL130 BL31.1
Hold Code This field contains the hold code. Hold BL31.2 BL31.3
codes are set up in the Accounts BL31.5 BL31.7
Receivable system. BL32.3 BL32.4
BL960
BRC-TERMS-CD Alpha 5 BL130 BL31.1
Terms Code This is the terms code to use for BL31.2 BL31.3
invoices created for the customer BL31.5 BL31.7
recurring invoice. It is optional. If BL32.3 BL32.4
blank, the terms code for the customer BL960
is used.
BRC-REFERENCE Alpha 10 (Lower Case) BL130 BL31.1
Reference The reference number associated with BL31.2 BL31.3
the transaction. BL31.5 BL31.7
BL32.3 BL32.4
BL960
BRC-PROCESS-LEVEL Alpha 5 BL130 BL31.1
Process Level This field contains the process level, BL31.2 BL31.3
which is the reporting hierarchy below BL31.5 BL31.7
company. BL32.3 BL32.4
BL960
BRC-LOCATION Alpha 5 BL130 BL31.1
Location Code This field contains a valid stock BL31.2 BL31.3
location within the company inventory. BL31.5 BL31.7
BL32.3 BL32.4
BL960
BRC-TERRITORY Alpha 4 BL130 BL31.1
Sales Territory This field contains the sales territory. BL31.2 BL31.3
BL31.5 BL31.7
BL32.3 BL32.4
BL960
BRC-SALESMAN Numeric 4 BL130 BL31.1
Salesman Number This field contains the code that BL31.2 BL31.3
represents the primary sales BL31.5 BL31.7
representative of this line. If left BL32.3 BL32.4
blank, this defaults from the customer. BL960
BRC-SALESMAN-2 Numeric 4 BL130 BL31.1
Salesman Number 2 This field contains the code BL31.2 BL31.3
representing the second sales BL31.5 BL31.7
representative. This defaults from the BL32.3 BL32.4
customer. BL960
BRC-COMM-RATE-1 Percent 7.5 (Percent) BL130 BL31.1
Commission Rate for This field contains the commission rate BL31.2 BL31.3
Slsmn 1 of the primary sales representative. BL31.5 BL31.7
This defaults from customer. BL32.3 BL32.4
BL960
BRC-COMM-RATE-2 Percent 7.5 (Percent) BL130 BL31.1
Commission Rate for This field contains the commission rate BL31.2 BL31.3
Slsmn 2 for the second sales representative. BL31.5 BL31.7
This defaults from customer. BL32.3 BL32.4
BL960
BRC-COMM-SPLIT Percent 5.3 (Percent) BL130 BL31.1
Commission Split This field contains the commission BL31.2 BL31.3
Percentage split. This defaults from the customer. BL31.5 BL31.7
BL32.3 BL32.4
BL960
BRC-INVOICE-COUNT Numeric 3 BL130 BL31.1
Invoice Count Number of invoices already created BL31.2 BL31.3
against this customer recurring invoice. BL31.5 BL31.7
Compared to the recurring invoice number BL32.3 BL32.4
of invoices to control creation of BL960
invoices for this customer recurring
invoice.
BRC-FREQUENCY Alpha 1 BL130 BL31.1
Frequency Frequency for this customer recurring BL31.2 BL31.3
invoice. BL31.5 BL31.7
BL32.3 BL32.4
BL960
BRC-CYCLE-CODE Alpha 3 BL130 BL31.1
Cycle Code Cycle code. Used to group customer BL31.2 BL31.3
recurring invoices within frequency code BL31.5 BL31.7
to manage the workload. BL32.3 BL32.4
BL960
BRC-START-DATE Numeric 8 (yyyymmdd) BL130 BL31.1
Start Date Start date. No invoices are created for BL31.2 BL31.3
this customer recurring invoice prior to BL31.5 BL31.7
this date. BL32.3 BL32.4
BL960
BRC-STOP-DATE Numeric 8 (yyyymmdd) BL130 BL31.1
Stop Date Stop date. No invoices are created for BL31.2 BL31.3
this customer recurring invoice after BL31.5 BL31.7
this date. BL32.3 BL32.4
BL960
BRC-ACTIVITY Alpha 15 BL130 BL31.1
Activity Activities are the processes or BL31.2 BL31.3
procedures that produce work. Cost BL31.5 BL31.7
objects (products, services, customers, BL32.3 BL32.4
and so on) are the reasons for BL960
performing the activity. Activities and
cost object activities are used
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.
BRC-ACCT-CATEGORY Alpha 5 BL130 BL31.1
Account Category Account categories are groupings of BL31.2 BL31.3
costs, revenues, or a combination of BL31.5 BL31.7
both used for reporting and inquiries BL32.3 BL32.4
for activities in the Activity BL960
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.
BRC-TRANS-USER1 Alpha 10 BL130 BL31.1
Trans User 1 User field 1. BL31.2 BL31.3
BL31.5 BL31.7
BL32.3 BL32.4
BL960
BRC-TRANS-USER2 Alpha 15 BL130 BL31.1
Trans User 2 User field 2. BL31.2 BL31.3
BL31.5 BL31.7
BL32.3 BL32.4
BL960
BRC-TRANS-USER3 Numeric 8 (yyyymmdd) BL130 BL31.1
Trans User 3 User field 3. BL31.2 BL31.3
BL31.5 BL31.7
BL32.3 BL32.4
BL960
BRC-TRANS-USER4 Numeric 9 BL130 BL31.1
Trans User 4 User field 4. BL31.2 BL31.3
BL31.5 BL31.7
BL32.3 BL32.4
BL960
BRC-TRANS-USER5 Signed 13.2 BL130 BL31.1
Trans User 5 User field 5. BL31.2 BL31.3
BL31.5 BL31.7
BL32.3 BL32.4
BL960
BRC-STD-COMM1 Alpha 4 BL130 BL31.1
Standard Comment 1 Standard comment code 1. Code for a BL31.2 BL31.3
group of comments. BL31.5 BL31.7
BL32.3 BL32.4
BL960
BRC-STD-COMM2 Alpha 4 BL130 BL31.1
Standard Comment 2 Standard comment code 2. Code for a BL31.2 BL31.3
group of comments. BL31.5 BL31.7
BL32.3 BL32.4
BL960
BRC-STD-COMM3 Alpha 4 BL130 BL31.1
Standard Comment 3 Standard comment code 3. Code for a BL31.2 BL31.3
group of comments. BL31.5 BL31.7
BL32.3 BL32.4
BL960
BRC-LAST-LINE-NBR Numeric 6 BL130 BL31.1
Last Line Number This is the number of the last line BL31.2 BL31.3
item added. It is used to determine the BL31.5 BL31.7
number when the next line is added. BL32.3 BL32.4
BL960
BRC-LAST-MISC-SEQ Numeric 3 BL130 BL31.1
Last Misc Code Last sequence number for add-on charges BL31.2 BL31.3
Sequence for this customer recurring invoice. BL31.5 BL31.7
BL32.3 BL32.4
BL960
BRC-LAST-COMM-SEQ Numeric 3 BL130 BL31.1
Last Comment This is the sequence number of the last BL31.2 BL31.3
Sequence Number comment line entered for this line. BL31.5 BL31.7
BL32.3 BL32.4
BL960
BLRICUST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BRCSET1 COMPANY BL130 BL231
RECUR-INVOICE BL30.1 BL30.2
CUSTOMER 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 BL960
BLRICUST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
BRC-COMPANY -> ACO-COMPANY
Arcustomer ARCUSTOMER Required
BRC-COMPANY -> ACM-COMPANY
BRC-CUSTOMER -> ACM-CUSTOMER
Blricsgblk BLRICSGBLK Not Required
BRC-COMPANY -> CGM-COMPANY
BRC-RECUR-INVOICE -> CGM-RECUR-INVOICE
BRC-CUSTOMER -> CGM-CUSTOMER
Zeroes -> CGM-LINE-NBR
Zeroes -> CGM-SEQ
Cucodes CUCODES Not Required
Valid When BRC-CURRENCY-CODE != Spaces
BRC-CURRENCY-CODE -> CUC-CURRENCY-CODE
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
BRC-CUSTOMER -> CUD-CUSTOMER
Holdcodes HOLDCODES Not Required
Valid When BRC-HOLD-CODE != Spaces
ACO-CUST-GROUP -> HDD-CUST-GROUP
BRC-HOLD-CODE -> HDD-HOLD-CODE
Iclocation ICLOCATION Required
When BRC-LOCATION != Spaces
BRC-COMPANY -> ICL-COMPANY
BRC-LOCATION -> ICL-LOCATION
Oecommhdr1 OECOMMHDR Not Required
Valid When BRC-STD-COMM1 != Spaces
BRC-COMPANY -> OCH-COMPANY
BRC-STD-COMM1 -> OCH-STD-COMM
Oecommhdr2 OECOMMHDR Not Required
Valid When BRC-STD-COMM2 != Spaces
BRC-COMPANY -> OCH-COMPANY
BRC-STD-COMM2 -> OCH-STD-COMM
Oecommhdr3 OECOMMHDR Not Required
Valid When BRC-STD-COMM3 != Spaces
BRC-COMPANY -> OCH-COMPANY
BRC-STD-COMM3 -> OCH-STD-COMM
Oecompany OECOMPANY Required
BRC-COMPANY -> OEC-COMPANY
Oemastsrvc BLRIMAST Required
BRC-COMPANY -> BRM-COMPANY
BRC-RECUR-INVOICE -> BRM-RECUR-INVOICE
Oeproclev OEPROCLEV Required
BRC-COMPANY -> OEP-COMPANY
BRC-PROCESS-LEVEL -> OEP-PROCESS-LEVEL
Salesman SALESREP Required
When BRC-SALESMAN != Zeroes
BRC-COMPANY -> SAW-COMPANY
BRC-SALESMAN -> SAW-SALESMAN
Salesman 2 SALESREP Required
When BRC-SALESMAN-2 != Zeroes
BRC-COMPANY -> SAW-COMPANY
BRC-SALESMAN-2 -> SAW-SALESMAN
Terms TERMS Required
When BRC-TERMS-CD != Spaces
BRC-TERMS-CD -> TMS-TERMS-CD
Territory TERITORY Required
When BRC-TERRITORY != Spaces
BRC-COMPANY -> TRY-COMPANY
BRC-TERRITORY -> TRY-TERRITORY
BLRICUST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oecscomm BLRICCOMM
BRC-COMPANY -> BUC-COMPANY
BRC-RECUR-INVOICE -> BUC-RECUR-INVOICE
BRC-CUSTOMER -> BUC-CUSTOMER
Zeroes -> BUC-LINE-NBR
BUC-SEQ
Oecsline BLRICLINE
BRC-COMPANY -> BUL-COMPANY
BRC-RECUR-INVOICE -> BUL-RECUR-INVOICE
BRC-CUSTOMER -> BUL-CUSTOMER
BUL-LINE-NBR
Oecsmisc BLRICMISC
BRC-COMPANY -> BUM-COMPANY
BRC-RECUR-INVOICE -> BUM-RECUR-INVOICE
BRC-CUSTOMER -> BUM-CUSTOMER
Zeroes -> BUM-LINE-NBR
BUM-SEQ
Oecsmisc All BLRICMISC
BRC-COMPANY -> BUM-COMPANY
BRC-RECUR-INVOICE -> BUM-RECUR-INVOICE
BRC-CUSTOMER -> BUM-CUSTOMER
BUM-LINE-NBR
BUM-SEQ
|