|
|
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
AC190 AC192 AC40.1 AC40.4 AC41.1 AC41.4
AC42.1 AC530 AC54.1 AC540 AC551 AR42.2
AR42.7 AR560 BR00.1 BR00.2 BR02.3 BR10.1
BR120 BR121 BR122 BR123 BR131 BR15.1
BR151 BR152 BR156 BR157 BR16.1 BR20.2
BR20.7 BR21.1 BR211 BR252 BR40.3 BR420
BR450 BR521 BR55.1 BR55.2 BR56.1 BR901
BR91.1 BRIP.1 BRPI.1 PHI3.1 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 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
Element: Invc Format S = Standard Invoice
C = Customized Invoice
F = Fax
E = EDI
X = Fax and Standard Invoice
I = EDI and Standard Invoice
W = Custom without page breaks
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 Code
CMR-TAX-PRINT Alpha 1 BR11.1
Element: Tax Print
CMR-AR-INT-OPTION Alpha 1 BR11.1
Element: Ar Int Option S = Summary
D = Detail
A = Actiivty/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 A = Acct Category
B = Acct Cat Class
C = Attribute
D = Resource
CMR-INVC-OPTION-2 Alpha 1 BR11.1
Element: Invc Option 2 A = Acct Category
B = Acct Cat Class
C = Attribute
D = Resource
CMR-COMPANY Numeric 4 BR11.1
Element: Company The company number represents an
established company and is entered on
all function codes.
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
ACCUSTOMER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CMRSET1 COMPANY AC190 AC192
CUSTOMER AC40.1 AC40.4
AC-CUSTOMER-ID AC41.1 AC41.4
AC42.1 AC530
AC54.1 AC540
AC551 AR42.2
AR42.7 AR560
BR00.1 BR00.2
BR02.3 BR10.1
BR11.1 BR120
BR121 BR122
BR123 BR131
BR15.1 BR151
BR152 BR156
BR157 BR16.1
...
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
|
