 |
Lawson Insight Technical Documentation |
|
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
AC170 AC190 AC192 AC40.1 AC40.4 AC41.1
AC41.4 AC42.1 AC530 AC54.1 AC540 AC551
AC70.1 AC70.4 AR42.2 AR42.7 AR560 BR00.1
BR00.2 BR02.3 BR10.1 BR120 BR121 BR131
BR20.2 BR20.7 BR21.1 BR211 BR40.3 BR420
BR450 BRIP.1 PHI3.1 WH20.7
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
W = Custom without page breaks
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
A = Actiivty/Acct Cat
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 AC170 AC190
CUSTOMER AC192 AC40.1
AC-CUSTOMER-ID AC40.4 AC41.1
AC41.4 AC42.1
AC530 AC54.1
AC540 AC551
AC70.1 AC70.4
AR42.2 AR42.7
AR560 BR00.1
BR00.2 BR02.3
BR10.1 BR11.1
BR120 BR121
BR131 BR20.2
BR20.7 BR21.1
BR211 BR40.3
...
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
|