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