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. |
|
||
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 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
BRCSET1 |
COMPANY RECUR-INVOICE CUSTOMER |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Arcomp | ARCOMP |
Required
| ||||||||||||
Arcustomer | ARCUSTOMER |
Required
| ||||||||||||
Cucodes | CUCODES |
Not Required
| ||||||||||||
Custdesc | CUSTDESC |
Required
| ||||||||||||
Holdcodes | HOLDCODES |
Not Required
| ||||||||||||
Iclocation | ICLOCATION |
Required
| ||||||||||||
Oecommhdr1 | OECOMMHDR |
Not Required
| ||||||||||||
Oecommhdr2 | OECOMMHDR |
Not Required
| ||||||||||||
Oecommhdr3 | OECOMMHDR |
Not Required
| ||||||||||||
Oecompany | OECOMPANY |
Required
| ||||||||||||
Oeproclev | OEPROCLEV |
Required
| ||||||||||||
Salesman | SALESREP |
Required
| ||||||||||||
Salesman 2 | SALESREP |
Required
| ||||||||||||
Terms | TERMS |
Required
| ||||||||||||
Territory | TERITORY |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Oecscomm | BLRICCOMM |
| |||||||||||||||
Oecsline | BLRICLINE |
|
All trademarks and registered trademarks are the property of their
respective owners.