BLRICUST

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
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
BRC-RECUR-INVOICE
Element: Recur Invoice
Alpha 10
This is the recurring invoice identifier.
BRC-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
This field contains the number that represents a customer.
BRC-SHIP-TO
Element: Ship To
Numeric 4
This field contains the number representing the ship to customer.
BRC-CONTACT
Element: Contact
Alpha 20
This is the name of the main contact.
BRC-PHONE-NBR
Element: Phone Nbr
Numeric 10
The phone number of the manager in charge.
BRC-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company's base currency code defined in the General Ledger system.
BRC-HOLD-CODE
Element: Hold Code
Alpha 4
This field contains the hold code. Hold codes are set up in the Accounts Receivable system.
BRC-TERMS-CD
Element: Term Code
Alpha 5
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
Element: Reference
Alpha 10 (Lower Case)
The reference number associated with the transaction.
BRC-PROCESS-LEVEL
Element: Process Level
Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
BRC-LOCATION
Element: Location
Alpha 5
This field contains a valid stock location within the company inventory.
BRC-TERRITORY
Element: Territory
Alpha 4
This field contains the sales territory.
BRC-SALESMAN
Element: Salesman
Numeric 4
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
Element: Salesman
Numeric 4
This field contains the code representing the second sales representative. This defaults from the customer.
BRC-COMM-RATE-1
Element: Chrg Rate
Percent 7.5 (Percent)
This field contains the commission rate of the primary sales representative. This defaults from customer.
BRC-COMM-RATE-2
Element: Chrg Rate
Percent 7.5 (Percent)
This field contains the commission rate for the second sales representative. This defaults from customer.
BRC-COMM-SPLIT
Element: Comm Split
Percent 5.3 (Percent)
This field contains the commission split. This defaults from the customer.
BRC-INVOICE-COUNT
Element: Invoice Count
Numeric 3
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
Element: Frequency
Alpha 1
Frequency for this customer recurring invoice.
BRC-CYCLE-CODE
Element: Auth Code
Alpha 3
Cycle code. Used to group customer recurring invoices within frequency code to manage the workload.
BRC-START-DATE
Element: Start Date
Numeric 8 (yyyymmdd)
Start date. No invoices are created for this customer recurring invoice prior to this date.
BRC-STOP-DATE
Element: Stop Date
Numeric 8 (yyyymmdd)
Stop date. No invoices are created for this customer recurring invoice after this date.
BRC-ACTIVITY
Element: Activity
Alpha 15
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
Element: Acct Category
Alpha 5
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
Element: Trans User1
Alpha 10
User field 1.
BRC-TRANS-USER2
Element: Agent
Alpha 15
User field 2.
BRC-TRANS-USER3
Element: Trans User3
Numeric 8 (yyyymmdd)
User field 3.
BRC-TRANS-USER4
Element: Trans User4
Numeric 9
User field 4.
BRC-TRANS-USER5
Element: Intl Amt
Signed 18.2
User field 5.
BRC-STD-COMM1
Element: Std Comm
Alpha 4
Standard comment code 1. Code for a group of comments.
BRC-STD-COMM2
Element: Std Comm
Alpha 4
Standard comment code 2. Code for a group of comments.
BRC-STD-COMM3
Element: Std Comm
Alpha 4
Standard comment code 3. Code for a group of comments.
BRC-LAST-LINE-NBR
Element: Line Nbr
Numeric 6
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
Element: Seq
Numeric 3
Last sequence number for add-on charges for this customer recurring invoice.
BRC-LAST-COMM-SEQ
Element: Seq
Numeric 3
This is the sequence number of the last comment line entered for this line.
BLI2.1
BRC-EP-TYPE
Element: Ep Type
Alpha 5
BRC-EP-ACCOUNT
Element: Ep Account
Alpha 32
BRC-EP-EXP-DATE
Element: Ep Exp Date
Numeric 8 (yyyymmdd)
BRC-BILL-TO
Element: Bill To
Numeric 4
This field contains the mailing address for the invoice. Bill to addresses are maintained in the Accounts Receviable Bill To form AR09.4.
BRC-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
BRC-TAX-EXEMPT-CD
Element: Tax Exempt Cd
Alpha 1
Code indicating the taxing status. E - Exempt, T - Taxable.
BRC-PO-NUMBER
Element: Cust Po Nbr
Alpha 22


BLRICUST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BRCSET1 COMPANY
RECUR-INVOICE
CUSTOMER
BLI2.1


BLRICUST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 11:09:27 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.