Activity Customer

This file contains customer information from BR11.1 (Customer), It includes customer, customer type, billable percentage, invoice information, bill-to number, and retainer information. This file also contains pay request options for grantors for Grant Management Billing. Use GM14.1 (Pay Request Options) to create and maintain grantor pay request options. Pay request options are assigned to the Grant for Grant Billing via GM15 (Grant). GM14 is essentially a slimmed down version of BR11 (Customer).

REFERENCED BY

AC10.1	AC190	AC40.1	AC40.4	AC41.1	AC41.4
AC42.1	AC54.1	AC540	ACAC.1	BR00.1	BR00.2
BR02.3	BR10.1	BR10.9	BR122	BR123	BR140
BR152	BR156	BR17.1	BR190	BR40.3	BR44.1
BR45.1	BR450	BR46.1	BR46.2	BR46.4	BR56.1
BRIP.1	BR09.1

UPDATED BY

AC56.1	AC560	AR01.1	ARLL.1	BR11.1	BR120
BR121	BR145	BR151	BR157	BR16.1	BR19.1
BR20.1	BR20.2	BR20.3	BR20.4	BR20.5	BR20.7
BR21.2	BR211	BR216	BR245	BR252	BR300
BR420	BR48.1	BR521	BR55.2	BR91.1	WH20.2
WH20.7

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
CMR-CUSTOMER Element: Customer	Alpha 9 (Right Justified) Required key. This is the name of the customer.	BR11.1
CMR-CONTACT-CODE Element: Contact Code	Alpha 5	BR11.1
CMR-PERC-BILLABLE Element: Billable Percentage	Signed 7.4 This field defines what percentage of the charges to a customer is billable.	BR11.1
CMR-INVC-PREFIX Element: Invoice Prefix	Alpha 2 This field contains the invoice prefix that is assigned from either the company or process level, depending on the invoice-level option chosen.	BR11.1
CMR-INVC-OPTIONS Element: Invc Options	Alpha 1 A = Account Category B = Contract Category Group C = Attribute D = Resource E = Summary Account Category F = Cost Classification	BR11.1
CMR-INVC-FORMAT Element: Invc Format	Alpha 1 S = Standard Invoice C = Customized Invoice F = Fax E = EDI V = Custom Vat	BR11.1
CMR-BILL-TO Element: Bill To	Numeric 4 This is the number to bill.	BR11.1
CMR-PROCESS-LEVEL Element: Process Level	Alpha 5 This field contains the process level, which is the reporting hierarchy below company.	BR11.1
CMR-TAX-CODE Element: Tax Code	Alpha 10 This field contains a code representing specific tax information. This must be valid Tax Code.	BR11.1
CMR-TAX-EXEMPT-CD Element: Tax Exempt Cd	Alpha 1 Code indicating the taxing status. E - Exempt, T - Taxable.	BR11.1
CMR-TAX-PRINT Element: Tax Print	Alpha 1 This field determines how to summarize the tax codes/amounts on the invoice. Options are: S - Single, M - Multiple M = Multiple sum by code/level S = Single tax line	BR11.1
CMR-AR-INT-OPTION Element: Ar Int Option	Alpha 1 S = Summary D = Detail A = Activity/Acct Cat	BR11.1
CMR-CM-PREFIX Element: Cm Prefix	Alpha 2	BR11.1
CMR-EXCEED-OPTION Element: Exceed Option	Alpha 1 I = Include E = Exclude	BR11.1
CMR-INVC-SUMM-OPT Element: Invc Summ Opt	Alpha 1 D = Detail Only S = Invoice Summary Only	BR11.1
CMR-INVC-OPTION-2 Element: Invc Option 2	Alpha 1 A = Account Category B = Contract Category Group C = Attribute D = Resource E = Summary Account Category	BR11.1
CMR-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.	BR11.1
CMR-AC-CUSTOMER-ID Element: Ac Customer Id	Alpha 5	BR11.1
CMR-CUMULATIVE-FL Element: Cumulative Fl	Alpha 1 Y = Yes N = No	BR11.1
CMR-COMPANY-NAME Element: Company Name	Derived
CMR-CUST-NAME Element: Cust Name	Derived
CMR-AR-SEARCH-NAME Element: Ar Search Name	Derived
CMR-LOCK-BOX Element: Lock Box	Alpha 2
CMR-SERVICE-LOC Element: Service Loc	Numeric 4 A user defined code identifying a customer's service location.	BR11.1
CMR-BILL-TO-GRP Element: Bill To Grp	Numeric 4 Used to identify a group of AR bill-to addresses used for customer invoicing in the BR system.	BR11.1
CMR-FEE-EXCEED-OPT Element: Fee Exceed Opt	Alpha 1 The Fee Ceiling Overage maintained on the Customer (BR11). The valid values are: I = Include E = Exclude	BR11.1
CMR-JURIS-CODE Element: Juris Code	Alpha 3	BR11.1
CMR-INVC-OPTION-3 Element: Invc Options	Alpha 1 A = Account Category B = Contract Category Group C = Attribute D = Resource E = Summary Account Category	BR11.1
CMR-INVC-OPTION-4 Element: Invc Options	Alpha 1 A = Account Category B = Contract Category Group C = Attribute D = Resource E = Summary Account Category	BR11.1
CMR-INVC-OPTION-5 Element: Invc Options	Alpha 1 A = Account Category B = Contract Category Group C = Attribute D = Resource E = Summary Account Category	BR11.1
CMR-TAX-CALC-FLAG Element: Tax Calc Flag	Alpha 1 This flag determines whether tax will be calculated at a detail level or summary level. If calculated at a detail level, tax amounts will be calculated separately for each invoice line. If calculated at a summary level, taxable amount for a tax code for the whole invoice will be determined, and tax will be calculated on that summarized taxable amount. 1 = Detail 2 = Summary	BR11.1

ACCUSTOMER FILE INDEX

ACCUSTOMER FILE RELATIONS

ONE TO ONE RELATIONS

ACCUSTOMER FILE RELATIONS

ONE TO MANY RELATIONS

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