ACCUSTOMER – Activity Customer

System
AC Billing Revenue (BR)
Prefix
CMR
Primary key
COMPANY, CUSTOMER, AC-CUSTOMER-ID
Fields
31
Updated by
9 programs
Referenced by
79 programs

ACCUSTOMER is the Activity Customer table in Lawson AC Billing Revenue (prefix CMR). It is indexed by COMPANY, CUSTOMER, AC-CUSTOMER-ID (CMRSET1). It is related 1:1 to ACCUSTBOD, ARCOMP, ARCUSTOMER, BILLTO and CUSTDESC and 1:M to ACHISTHDR, ACSRVCLOC and BRCUSTAU. It is updated by AC56.1, AC560, AR01.1, ARLL.1, BR11.1, BR17.1, BR48.1, WH20.2 and 1 more and referenced by AC00.1, AC00.2, AC00.3, AC02.1, AC05.2, AC05.3, AC08.1, AC08.2 and 71 more. The table has 31 fields, 1 index and 8 documented relations.

About ACCUSTOMER

This file contains customer information from BR11.1 (Customer), It includes customer, customer type, billable percentage, invoice information, bill-to number, and retainer information.

Fields (31)

Column = COBOL field name without the CMR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
CMR-CUSTOMER PK
CUSTOMER		Alpha 9 (Right Justified)Required key. This is the name of the customer.BR11.1
CMR-CONTACT-CODE
CONTACT_CODE		Alpha 5—BR11.1
CMR-PERC-BILLABLE
PERC_BILLABLE		Signed 7.4This field defines what percentage of the charges to a customer is billable.BR11.1
CMR-INVC-PREFIX
INVC_PREFIX		Alpha 2This 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
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
INVC_FORMAT		Alpha 1—
  • S Standard Invoice
  • C Customized Invoice
  • F Fax
  • E EDI
  • V Custom Vat
BR11.1
CMR-BILL-TO
BILL_TO		Numeric 4This is the number to bill.BR11.1
CMR-PROCESS-LEVEL
PROCESS_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.BR11.1
CMR-TAX-CODE
TAX_CODE		Alpha 10This field contains a code representing specific tax information. This must be valid Tax Code.BR11.1
CMR-TAX-EXEMPT-CD
TAX_EXEMPT_CD		Alpha 1Code indicating the taxing status. E - Exempt, T - Taxable.BR11.1
CMR-TAX-PRINT
TAX_PRINT		Alpha 1This 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
AR_INT_OPTION		Alpha 1—
  • S Summary
  • D Detail
  • A Activity/Acct Cat
BR11.1
CMR-CM-PREFIX
CM_PREFIX		Alpha 2—BR11.1
CMR-EXCEED-OPTION
EXCEED_OPTION		Alpha 1—
  • I Include
  • E Exclude
BR11.1
CMR-INVC-SUMM-OPT
INVC_SUMM_OPT		Alpha 1—
  • D Detail Only
  • S Invoice Summary Only
BR11.1
CMR-INVC-OPTION-2
INVC_OPTION_2		Alpha 1—
  • A Account Category
  • B Contract Category Group
  • C Attribute
  • D Resource
  • E Summary Account Category
BR11.1
CMR-COMPANY PK
COMPANY		Numeric 4Identifies 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 PK
AC_CUSTOMER_ID		Alpha 5—BR11.1
CMR-CUMULATIVE-FL
CUMULATIVE_FL		Alpha 1—
  • Y Yes
  • N No
BR11.1
CMR-COMPANY-NAME
COMPANY_NAME		Derived——
CMR-CUST-NAME
CUST_NAME		Derived——
CMR-AR-SEARCH-NAME
AR_SEARCH_NAME		Derived——
CMR-LOCK-BOX
LOCK_BOX		Alpha 2——
CMR-SERVICE-LOC
SERVICE_LOC		Numeric 4A user defined code identifying a customer's service location.BR11.1
CMR-BILL-TO-GRP
BILL_TO_GRP		Numeric 4Used to identify a group of AR bill-to addresses used for customer invoicing in the BR system.BR11.1
CMR-FEE-EXCEED-OPT
FEE_EXCEED_OPT		Alpha 1The Fee Ceiling Overage maintained on the Customer (BR11). The valid values are:
  • I Include
  • E Exclude
BR11.1
CMR-JURIS-CODE
JURIS_CODE		Alpha 3—BR11.1
CMR-INVC-OPTION-3
INVC_OPTION_3		Alpha 1—
  • A Account Category
  • B Contract Category Group
  • C Attribute
  • D Resource
  • E Summary Account Category
BR11.1
CMR-INVC-OPTION-4
INVC_OPTION_4		Alpha 1—
  • A Account Category
  • B Contract Category Group
  • C Attribute
  • D Resource
  • E Summary Account Category
BR11.1
CMR-INVC-OPTION-5
INVC_OPTION_5		Alpha 1—
  • A Account Category
  • B Contract Category Group
  • C Attribute
  • D Resource
  • E Summary Account Category
BR11.1
CMR-TAX-CALC-FLAG
TAX_CALC_FLAG		Alpha 1This 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

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CMRSET1COMPANY, CUSTOMER, AC-CUSTOMER-IDPrimaryAC00.1, AC00.2, AC00.3, AC02.1, AC05.2, AC05.3, AC08.1, AC08.2 +22 more (list truncated in source)

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
AccustbodACCUSTBODNot Required, Delete CascadesCMR-COMPANY → YAK-COMPANY, CMR-CUSTOMER → YAK-CUSTOMER, CMR-AC-CUSTOMER-ID → YAK-AC-CUSTOMER-ID
ArcompARCOMPRequiredCMR-COMPANY → ACO-COMPANY
ArcustomerARCUSTOMERRequiredCMR-COMPANY → ACM-COMPANY, CMR-CUSTOMER → ACM-CUSTOMER
BilltoBILLTONot RequiredACO-CUST-GROUP → ABS-CUST-GROUP, CMR-CUSTOMER → ABS-CUSTOMER, CMR-BILL-TO → ABS-BILL-TO
CustdescCUSTDESCRequiredACO-CUST-GROUP → CUD-CUST-GROUP, CMR-CUSTOMER → CUD-CUSTOMER

One to many (3) — child tables

RelationTableRulesConditionField map
AchisthdrACHISTHDRCMR-COMPANY → HIH-COMPANY, CMR-CUSTOMER → HIH-CUSTOMER, → HIH-CONTRACT, → HIH-INVOICE-PREFIX, → HIH-INVOICE-NBR, → HIH-OBJ-ID
AcsrvclocACSRVCLOCCMR-COMPANY → ASV-COMPANY, CMR-CUSTOMER → ASV-CUSTOMER, → ASV-SERVICE-LOC
BrcustauBRCUSTAUCMR-COMPANY → CSA-COMPANY, CMR-CUSTOMER → CSA-CUSTOMER, CMR-AC-CUSTOMER-ID → CSA-AC-CUSTOMER-ID, → CSA-UNIQUE-I-D

Programs

Updated by (9)

Referenced by (79)