|
|
ACCUSTOMER FILE
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
AC190 AC40.1 AC40.4 AC41.1 AC41.4 AC42.1
AC54.1 AC540 AC56.1 AC560 ACAC.1 AR01.1
AR33.5 AR42.2 AR42.7 AR44.3 AR502 AR560
ARLL.1 BL00.1 BL01.1 BL120 BL121 BL122
BL123 BL130 BL20.1 BL20.3 BL200 BL201
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
BL92.1 BL98.1 BR00.1 BR00.2 BR02.3 BR09.1
BR10.1 BR10.9 BR120 BR121 BR122 BR123
BR131 BR140 BR145 BR151 BR152 BR156
BR157 BR16.1 BR17.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 BR40.3 BR420 BR45.1 BR450
BR46.1 BR46.2 BR46.4 BR48.1 BR521 BR55.1
BR55.2 BR56.1 BR91.1 BRIP.1 ET540 PW110
WH20.7
UPDATED BY
BR11.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CMR-CUSTOMER Alpha 9 (Right Justified) BR11.1
Element: Customer Required key. This is the name of the
customer.
CMR-CONTACT-CODE Alpha 5 BR11.1
Element: Contact Code
CMR-PERC-BILLABLE Signed 7.4 BR11.1
Element: Billable PerceThis field defines what percentage of
the charges to a customer is billable.
CMR-INVC-PREFIX Alpha 2 BR11.1
Element: Invoice PrefixThis field contains the invoice prefix
that is assigned from either the company
or process level, depending on the
invoice-level option chosen.
CMR-INVC-OPTIONS Alpha 1 BR11.1
Element: Invc Options A = Account Category
B = Contract Category Group
C = Attribute
D = Resource
E = Summary Account Category
CMR-INVC-FORMAT Alpha 1 BR11.1
Element: Invc Format S = Standard Invoice
C = Customized Invoice
F = Fax
E = EDI
V = Custom Vat
CMR-BILL-TO Numeric 4 BR11.1
Element: Bill To This is the number to bill.
CMR-PROCESS-LEVEL Alpha 5 BR11.1
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
CMR-TAX-CODE Alpha 10 BR11.1
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
CMR-TAX-EXEMPT-CD Alpha 1 BR11.1
Element: Tax Exempt Cd Code indicating the taxing status. E -
Exempt, T - Taxable.
CMR-TAX-PRINT Alpha 1 BR11.1
Element: Tax Print 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
CMR-AR-INT-OPTION Alpha 1 BR11.1
Element: Ar Int Option S = Summary
D = Detail
A = Activity/Acct Cat
CMR-CM-PREFIX Alpha 2 BR11.1
Element: Cm Prefix
CMR-EXCEED-OPTION Alpha 1 BR11.1
Element: Exceed Option I = Include
E = Exclude
CMR-INVC-SUMM-OPT Alpha 1 BR11.1
Element: Invc Summ Opt D = Detail Only
S = Invoice Summary Only
CMR-INVC-OPTION-2 Alpha 1 BR11.1
Element: Invc Option 2 A = Account Category
B = Contract Category Group
C = Attribute
D = Resource
E = Summary Account Category
CMR-COMPANY Numeric 4 BR11.1
Element: Company 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.
CMR-AC-CUSTOMER-ID Alpha 5 BR11.1
Element: Ac Customer Id
CMR-CUMULATIVE-FL Alpha 1 BR11.1
Element: Cumulative Fl Y = Yes
N = No
CMR-COMPANY-NAME Derived
Element: Company Name
CMR-CUST-NAME Derived
Element: Cust Name
CMR-AR-SEARCH-NAME Derived
Element: Ar Search Name
CMR-LOCK-BOX Alpha 2
Element: Lock Box
CMR-SERVICE-LOC Numeric 4 BR11.1
Element: Service Loc A user defined code identifying a
customer's service location.
CMR-BILL-TO-GRP Numeric 4 BR11.1
Element: Bill To Grp Used to identify a group of AR bill-to
addresses used for customer invoicing in
the BR system.
CMR-FEE-EXCEED-OPT Alpha 1 BR11.1
Element: Fee Exceed OptThe Fee Ceiling Overage maintained on
the Customer (BR11).
The valid values are:
I = Include
E = Exclude
CMR-JURIS-CODE Alpha 3 BR11.1
Element: Juris Code
CMR-INVC-OPTION-3 Alpha 1 BR11.1
Element: Invc Options A = Account Category
B = Contract Category Group
C = Attribute
D = Resource
E = Summary Account Category
CMR-INVC-OPTION-4 Alpha 1 BR11.1
Element: Invc Options A = Account Category
B = Contract Category Group
C = Attribute
D = Resource
E = Summary Account Category
CMR-INVC-OPTION-5 Alpha 1 BR11.1
Element: Invc Options A = Account Category
B = Contract Category Group
C = Attribute
D = Resource
E = Summary Account Category
CMR-TAX-CALC-FLAG Alpha 1 BR11.1
Element: Tax Calc Flag 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
ACCUSTOMER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CMRSET1 COMPANY AC190 AC40.1
CUSTOMER AC40.4 AC41.1
AC-CUSTOMER-ID AC41.4 AC42.1
AC54.1 AC540
AC56.1 AC560
ACAC.1 AR01.1
AR33.5 AR42.2
AR42.7 AR44.3
AR502 AR560
ARLL.1 BL00.1
BL01.1 BL120
BL121 BL122
BL123 BL130
BL20.1 BL20.3
BL200 BL201
...
ACCUSTOMER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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 RELATED
NAME 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
|
