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
BL31.1 BL31.2 BL31.3 BL31.5 BL31.7 BL32.3
BL32.4 BL331 BLI2.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BRC-COMPANY Numeric 4 BL31.1 BL31.2
Company The company number represents an BL31.3 BL31.5
established company and is entered on BL31.7 BL32.3
all function codes. BL32.4
BRC-RECUR-INVOICE Alpha 10 BL31.1 BL31.2
Recur Invoice This is the recurring invoice BL31.3 BL31.5
identifier. BL31.7 BL32.3
BL32.4
BRC-CUSTOMER Alpha 9 (Right Justified) BL31.1 BL31.2
Customer Number This field contains the number that BL31.3 BL31.5
represents a customer. BL31.7 BL32.3
BL32.4
BRC-SHIP-TO Numeric 4 BL31.1 BL31.2
Ship-to Code This field contains the number BL31.3 BL31.5
representing the ship to customer. BL31.7 BL32.3
BL32.4
BRC-CONTACT Alpha 20 BL31.1 BL31.2
Primary Contact This is the name of the main contact. BL31.3 BL31.5
BL31.7 BL32.3
BL32.4
BRC-PHONE-NBR Numeric 10 BL31.1 BL31.2
Telephone Number The phone number of the manager in BL31.3 BL31.5
charge. BL31.7 BL32.3
BL32.4
BRC-CURRENCY-CODE Alpha 5 BL31.1 BL31.2
Currency Code This field contains the company's base BL31.3 BL31.5
currency code defined in the General BL31.7 BL32.3
Ledger system. BL32.4
BRC-HOLD-CODE Alpha 4 BL31.1 BL31.2
Hold Code This field contains the hold code. Hold BL31.3 BL31.5
codes are set up in the Accounts BL31.7 BL32.3
Receivable system. BL32.4
BRC-TERMS-CD Alpha 5 BL31.1 BL31.2
Terms Code This is the terms code to use for BL31.3 BL31.5
invoices created for the customer BL31.7 BL32.3
recurring invoice. It is optional. If BL32.4
blank, the terms code for the customer
is used.
BRC-REFERENCE Alpha 10 (Lower Case) BL31.1 BL31.2
Reference The reference number associated with BL31.3 BL31.5
the transaction. BL31.7 BL32.3
BL32.4
BRC-PROCESS-LEVEL Alpha 5 BL31.1 BL31.2
Process Level This field contains the process level, BL31.3 BL31.5
which is the reporting hierarchy below BL31.7 BL32.3
company. BL32.4
BRC-LOCATION Alpha 5 BL31.1 BL31.2
Location Code This field contains a valid stock BL31.3 BL31.5
location within the company inventory. BL31.7 BL32.3
BL32.4
BRC-TERRITORY Alpha 4 BL31.1 BL31.2
Sales Territory This field contains the sales territory. BL31.3 BL31.5
BL31.7 BL32.3
BL32.4
BRC-SALESMAN Numeric 4 BL31.1 BL31.2
Salesman Number This field contains the code that BL31.3 BL31.5
represents the primary sales BL31.7 BL32.3
representative of this line. If left BL32.4
blank, this defaults from the customer.
BRC-SALESMAN-2 Numeric 4 BL31.1 BL31.2
Salesman Number 2 This field contains the code BL31.3 BL31.5
representing the second sales BL31.7 BL32.3
representative. This defaults from the BL32.4
customer.
BRC-COMM-RATE-1 Percent 7.5 (Percent) BL31.1 BL31.2
Commission Rate for This field contains the commission rate BL31.3 BL31.5
Slsmn 1 of the primary sales representative. BL31.7 BL32.3
This defaults from customer. BL32.4
BRC-COMM-RATE-2 Percent 7.5 (Percent) BL31.1 BL31.2
Commission Rate for This field contains the commission rate BL31.3 BL31.5
Slsmn 2 for the second sales representative. BL31.7 BL32.3
This defaults from customer. BL32.4
BRC-COMM-SPLIT Percent 5.3 (Percent) BL31.1 BL31.2
Commission Split This field contains the commission BL31.3 BL31.5
Percentage split. This defaults from the customer. BL31.7 BL32.3
BL32.4
BRC-INVOICE-COUNT Numeric 3 BL31.1 BL31.2
Invoice Count Number of invoices already created BL31.3 BL31.5
against this customer recurring invoice. BL31.7 BL32.3
Compared to the recurring invoice number BL32.4
of invoices to control creation of
invoices for this customer recurring
invoice.
BRC-FREQUENCY Alpha 1 BL31.1 BL31.2
Frequency Frequency for this customer recurring BL31.3 BL31.5
invoice. BL31.7 BL32.3
BL32.4
BRC-CYCLE-CODE Alpha 3 BL31.1 BL31.2
Cycle Code Cycle code. Used to group customer BL31.3 BL31.5
recurring invoices within frequency code BL31.7 BL32.3
to manage the workload. BL32.4
BRC-START-DATE Numeric 8 (yyyymmdd) BL31.1 BL31.2
Start Date Start date. No invoices are created for BL31.3 BL31.5
this customer recurring invoice prior to BL31.7 BL32.3
this date. BL32.4
BRC-STOP-DATE Numeric 8 (yyyymmdd) BL31.1 BL31.2
Stop Date Stop date. No invoices are created for BL31.3 BL31.5
this customer recurring invoice after BL31.7 BL32.3
this date. BL32.4
BRC-ACTIVITY Alpha 15 BL31.1 BL31.2
Activity Activities are the processes or BL31.3 BL31.5
procedures that produce work. Cost BL31.7 BL32.3
objects (products, services, customers, BL32.4
and so on) are the reasons for
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 BL31.1 BL31.2
Account Category Account categories are groupings of BL31.3 BL31.5
costs, revenues, or a combination of BL31.7 BL32.3
both used for reporting and inquiries BL32.4
for activities in the Activity
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 BL31.1 BL31.2
Trans User1 User field 1. BL31.3 BL31.5
BL31.7 BL32.3
BL32.4
BRC-TRANS-USER2 Alpha 15 BL31.1 BL31.2
Trans User2 User field 2. BL31.3 BL31.5
BL31.7 BL32.3
BL32.4
BRC-TRANS-USER3 Numeric 8 (yyyymmdd) BL31.1 BL31.2
Trans User3 User field 3. BL31.3 BL31.5
BL31.7 BL32.3
BL32.4
BRC-TRANS-USER4 Numeric 9 BL31.1 BL31.2
Trans User4 User field 4. BL31.3 BL31.5
BL31.7 BL32.3
BL32.4
BRC-TRANS-USER5 Signed 13.2 BL31.1 BL31.2
Trans User5 User field 5. BL31.3 BL31.5
BL31.7 BL32.3
BL32.4
BRC-STD-COMM1 Alpha 4 BL31.1 BL31.2
Std Comm1 Standard comment code 1. Code for a BL31.3 BL31.5
group of comments. BL31.7 BL32.3
BL32.4
BRC-STD-COMM2 Alpha 4 BL31.1 BL31.2
Std Comm2 Standard comment code 2. Code for a BL31.3 BL31.5
group of comments. BL31.7 BL32.3
BL32.4
BRC-STD-COMM3 Alpha 4 BL31.1 BL31.2
Std Comm3 Standard comment code 3. Code for a BL31.3 BL31.5
group of comments. BL31.7 BL32.3
BL32.4
BRC-LAST-LINE-NBR Numeric 6 BL31.1 BL31.2
Last Line Number This is the number of the last line BL31.3 BL31.5
item added. It is used to determine the BL31.7 BL32.3
number when the next line is added. BL32.4
BRC-LAST-MISC-SEQ Numeric 3 BL31.1 BL31.2
Last Misc Code Last sequence number for add-on charges BL31.3 BL31.5
Sequence for this customer recurring invoice. BL31.7 BL32.3
BL32.4
BRC-LAST-COMM-SEQ Numeric 3 BL31.1 BL31.2
Last Comment This is the sequence number of the last BL31.3 BL31.5
Sequence Number comment line entered for this line. BL31.7 BL32.3
BL32.4 BLI2.1
BRC-EP-TYPE Alpha 5 BL31.1 BL31.2
Ep Type BL31.3 BL31.5
BL31.7 BL32.3
BL32.4
BRC-EP-ACCOUNT Alpha 32 BL31.1 BL31.2
Ep Account BL31.3 BL31.5
BL31.7 BL32.3
BL32.4
BRC-EP-EXP-DATE Numeric 8 (yyyymmdd) BL31.1 BL31.2
Ep Exp Date BL31.3 BL31.5
BL31.7 BL32.3
BL32.4
BLRICUST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BRCSET1 COMPANY BL231 BL30.1
RECUR-INVOICE BL30.2 BL30.3
CUSTOMER 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
BLI2.1
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
|
