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