|
|
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
Element: Company The company number represents an
established company and is entered on
all function codes.
BRC-RECUR-INVOICE Alpha 10
Element: Recur Invoice This is the recurring invoice
identifier.
BRC-CUSTOMER Alpha 9 (Right Justified)
Element: Customer NumbeThis field contains the number that
represents a customer.
BRC-SHIP-TO Numeric 4
Element: Ship-to Code This field contains the number
representing the ship to customer.
BRC-CONTACT Alpha 20
Element: Primary ContacThis is the name of the main contact.
BRC-PHONE-NBR Numeric 10
Element: Telephone NumbThe phone number of the manager in
charge.
BRC-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company's base
currency code defined in the General
Ledger system.
BRC-HOLD-CODE Alpha 4
Element: Hold Code This field contains the hold code. Hold
codes are set up in the Accounts
Receivable system.
BRC-TERMS-CD Alpha 5
Element: 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)
Element: Requester The reference number associated with
the transaction.
BRC-PROCESS-LEVEL Alpha 5
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
BRC-LOCATION Alpha 5
Element: Location Code This field contains a valid stock
location within the company inventory.
BRC-TERRITORY Alpha 4
Element: Sales TerritorThis field contains the sales territory.
BRC-SALESMAN Numeric 4
Element: Salesman NumbeThis 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
Element: Salesman NumbeThis field contains the code
representing the second sales
representative. This defaults from the
customer.
BRC-COMM-RATE-1 Percent 7.5 (Percent)
Element: Chrg Rate This field contains the commission rate
of the primary sales representative.
This defaults from customer.
BRC-COMM-RATE-2 Percent 7.5 (Percent)
Element: Chrg Rate This field contains the commission rate
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
Element: 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
Element: Frequency Frequency for this customer recurring
invoice.
BRC-CYCLE-CODE Alpha 3
Element: Authority CodeCycle code. Used to group customer
recurring invoices within frequency code
to manage the workload.
BRC-START-DATE Numeric 8 (yyyymmdd)
Element: Date Start date. No invoices are created for
this customer recurring invoice prior to
this date.
BRC-STOP-DATE Numeric 8 (yyyymmdd)
Element: Date Stop date. No invoices are created for
this customer recurring invoice after
this date.
BRC-ACTIVITY Alpha 15
Element: 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
Element: Account CategoAccount 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
Element: Cust User1 User field 1.
BRC-TRANS-USER2 Alpha 15
Element: Agent User field 2.
BRC-TRANS-USER3 Numeric 8 (yyyymmdd)
Element: Date User field 3.
BRC-TRANS-USER4 Numeric 9
Element: Cust User5 User field 4.
BRC-TRANS-USER5 Signed 13.2
Element: Par Value User field 5.
BRC-STD-COMM1 Alpha 4
Element: Standard CommeStandard comment code 1. Code for a
group of comments.
BRC-STD-COMM2 Alpha 4
Element: Standard CommeStandard comment code 2. Code for a
group of comments.
BRC-STD-COMM3 Alpha 4
Element: Standard CommeStandard comment code 3. Code for a
group of comments.
BRC-LAST-LINE-NBR Numeric 6
Element: 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
Element: Sequence NumbeLast sequence number for add-on charges
for this customer recurring invoice.
BRC-LAST-COMM-SEQ Numeric 3 BLI2.1
Element: Sequence NumbeThis is the sequence number of the last
comment line entered for this line.
BRC-EP-TYPE Alpha 5
Element: Ep Type
BRC-EP-ACCOUNT Alpha 32
Element: Ep Account
BRC-EP-EXP-DATE Numeric 8 (yyyymmdd)
Element: 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
|
