ACCUSTOMER

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.

REFERENCED BY
AC00.1 AC00.2 AC00.3 AC02.1 AC05.2 AC05.3
AC08.1 AC08.2 AC08.3 AC08.4 AC08.5 AC08.6
AC08.7 AC10.1 AC190 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC40.1 AC40.4 AC41.1 AC41.4
AC42.1 AC54.1 AC540 ACAC.1 BR00.1 BR00.2
BR02.3 BR09.1 BR10.1 BR10.9 BR120 BR121
BR122 BR123 BR140 BR145 BR151 BR152
BR156 BR157 BR16.1 BR19.1 BR19.3 BR190
BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR20.6
BR20.7 BR21.1 BR21.2 BR211 BR216 BR245
BR252 BR300 BR305 BR40.3 BR420 BR44.1
BR45.1 BR450 BR46.1 BR46.2 BR46.4 BR521
BR55.1 BR55.2 BR56.1 BR88.1 BR91.1 BRBD.2
BRIP.1


UPDATED BY
BR11.1 AC56.1 AC560 AR01.1 ARLL.1 BR17.1
BR48.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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CMRSET1 COMPANY
CUSTOMER
AC-CUSTOMER-ID
...
AC00.1 AC00.2
AC00.3 AC02.1
AC05.2 AC05.3
AC08.1 AC08.2
AC08.3 AC08.4
AC08.5 AC08.6
AC08.7 AC10.1
AC190 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC54.1
AC540 AC56.1
AC560 ACAC.1


ACCUSTOMER FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Accustbod ACCUSTBOD Not Required, Delete Cascades
CMR-COMPANY->YAK-COMPANY
CMR-CUSTOMER->YAK-CUSTOMER
CMR-AC-CUSTOMER-ID->YAK-AC-CUSTOMER-ID
Arcomp ARCOMP Required
CMR-COMPANY->ACO-COMPANY
Arcustomer ARCUSTOMER Required
CMR-COMPANY->ACM-COMPANY
CMR-CUSTOMER->ACM-CUSTOMER
Billto BILLTO Not Required
ACO-CUST-GROUP->ABS-CUST-GROUP
CMR-CUSTOMER->ABS-CUSTOMER
CMR-BILL-TO->ABS-BILL-TO
Custdesc CUSTDESC Required
ACO-CUST-GROUP->CUD-CUST-GROUP
CMR-CUSTOMER->CUD-CUSTOMER


ACCUSTOMER FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Achisthdr ACHISTHDR
CMR-COMPANY->HIH-COMPANY
CMR-CUSTOMER->HIH-CUSTOMER
  HIH-CONTRACT
  HIH-INVOICE-PREFIX
  HIH-INVOICE-NBR
  HIH-OBJ-ID
Acsrvcloc ACSRVCLOC
CMR-COMPANY->ASV-COMPANY
CMR-CUSTOMER->ASV-CUSTOMER
  ASV-SERVICE-LOC
Brcustau BRCUSTAU
CMR-COMPANY->CSA-COMPANY
CMR-CUSTOMER->CSA-CUSTOMER
CMR-AC-CUSTOMER-ID->CSA-AC-CUSTOMER-ID
  CSA-UNIQUE-I-D

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

Home
Contact Us



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