ACCUSTOMER FILE
Activity Customer
This file contains customer information from AC15.2 (Activity Customer), It
includes customer, customer type, billable percentage, invoice information,
bill-to number, and retainer information.
REFERENCED BY
AC01.1 AC105 AC112 AC120 AC121 AC123
AC13.3 AC160 AC165 AC170 AC190 AC191
AC196 AC198 AC203 AC206 AC207 AC210
AC213 AC218 AC240 AC258 AC261 AC265
AC290 AC295 AC297 AC298 AC30.3 AC310
AC32.1 AC34.1 AC35.1 AC36.1 AC40.1 AC40.4
AC400 AC401 AC41.1 AC41.4 AC410 AC412
AC42.1 AC420 AC421 AC440 AC460 AC471
AC472 AC473 AC480 AC490 AC493 AC494
AC530 AC54.1 AC540 AC55.1 AC551 AC70.1
AC70.4 AC90.1 AC92.1 AC93.1 AC94.1 AC95.1
AC97.1 ACBA.1 ACVW.1 SE90.1 AR250 AR251
AR30.5 AR42.2 AR42.7 AR560 BL00.1 BL01.1
BL121 BL123 BL200 BL201 BR00.1 BR00.2
BR02.3 BR10.1 BR120 BR121 BR142 BR200
BR202 BR204 BR205 BR21.1 BR210 BR211
BR220 BR265 BR40.3 BR400 BR405 BR420
BR430 BR450 BRCC.1 BRIP.1 MX123 MX500
PHI3.1
UPDATED BY
BR11.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CMR-CUSTOMER Alpha 9 (Right Justified) BR11.1
Customer Required key. This is the name of the
customer.
CMR-CONTACT-CODE Alpha 5 BR11.1
Contact Code
CMR-PERC-BILLABLE Signed 7.4 BR11.1
Billable Percentage This field defines what percentage of
the charges to a customer is billable.
CMR-INVC-PREFIX Alpha 2 BR11.1
Invoice Prefix This 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
Invc Options S = Summary
F = Full Detail
A = Detail Summed by Acct Category
M = Detail Summed by Matrix Value
B = Summary and Full Detail
C = Summ and Detail by Acct Cat
V = Summ and Detail by Matrix Val
CMR-INVC-FORMAT Alpha 1 BR11.1
Invc Format S = Standard Invoice
C = Customized Invoice
F = Fax
E = EDI
X = Fax and Standard Invoice
I = EDI and Standard Invoice
CMR-BILL-TO Numeric 4 BR11.1
Bill To This is the number to bill.
CMR-PROCESS-LEVEL Alpha 5 BR11.1
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
CMR-TAX-CODE Alpha 10 BR11.1
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
Tax Exempt Code
CMR-TAX-PRINT Alpha 1 BR11.1
Tax Print
CMR-AR-INT-OPTION Alpha 1 BR11.1
Ar Int Option S = Summary
D = Detail
CMR-CM-PREFIX Alpha 2 BR11.1
Cm Prefix
CMR-EXCEED-OPTION Alpha 1 BR11.1
Exceed Option I = Include
E = Exclude
CMR-INVC-SUMM-OPT Alpha 1 BR11.1
Invc Summ Opt A = Acct Category
B = Acct Cat Class
C = Attribute
D = Resource
CMR-INVC-OPTION-2 Alpha 1 BR11.1
Invc Option 2 A = Acct Category
B = Acct Cat Class
C = Attribute
D = Resource
CMR-COMPANY Numeric 4 BR11.1
Company The company number represents an
established company and is entered on
all function codes.
CMR-AC-CUSTOMER-ID Alpha 5 BR11.1
Ac Customer Id
CMR-CUMULATIVE-FL Alpha 1 BR11.1
Cumulative Fl Y = Yes
N = No
CMR-COMPANY-NAME Derived
Company Name
CMR-CUST-NAME Derived
Cust Name
CMR-AR-SEARCH-NAME Derived
Ar Search Name
CMR-LOCK-BOX Alpha 2
Lock Box
ACCUSTOMER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CMRSET1 COMPANY AC01.1 AC105
CUSTOMER AC112 AC120
AC-CUSTOMER-ID AC121 AC123
AC13.3 AC160
AC165 AC170
AC190 AC191
AC196 AC198
AC203 AC206
AC207 AC210
AC213 AC218
AC240 AC258
AC261 AC265
AC290 AC295
AC297 AC298
AC30.3 AC310
...
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
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-AC-CUSTOMER-ID
Acinvhdr ACINVHDR
CMR-COMPANY -> IVH-COMPANY
CMR-CUSTOMER -> IVH-CUSTOMER
IVH-CONTRACT
IVH-INVOICE-PREFIX
IVH-INVOICE-NBR
IVH-AC-CUSTOMER-ID
|
