Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCUSTOMER


                            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