ARCUSTTOTS – AR Customer PL Inclusions

System
Accounts Receivable (AR)
Prefix
CUT
Primary key
COMPANY, CUSTOMER, PROCESS-LEVEL
Fields
4
Updated by
3 programs
Referenced by
94 programs

ARCUSTTOTS is the AR Customer PL Inclusions table in Lawson Accounts Receivable (prefix CUT). It is indexed by COMPANY, CUSTOMER, PROCESS-LEVEL (CUTSET1). It is related 1:1 to ARCOMP, ARCUSTOMER, ARPROCLEVL and CUSTDESC. It is updated by AR10.1, AR10.2 and AR301 and referenced by AC56.1, AC560, ARLL.1, BR00.1, BR00.2, BR02.3, BR10.1, BR10.9 and 86 more. The table has 4 fields, 1 index and 4 documented relations.

About ARCUSTTOTS

The AR Customer Process Level Inclusions file will hold the information regarding a customer's inclusion Process Levels for invoicing (maintained and created in AR10.2 (Customer Process Level Inclusions). If a set of inclusion Process Levels is defined, only open items with Process Level values within the inclusion set will be allowed to be added.

Fields (4)

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

Field / columnTypeDescription & valuesUpdated by
CUT-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.AR10.2
CUT-CUSTOMER PK
CUSTOMER		Alpha 9 (Right Justified)Customer number.AR10.2
CUT-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5Process Level that is included (invoicing restricted to) for invoicing.AR10.2
CUT-PL-EXCL-FL
PL_EXCL_FL		Alpha 1Process level exclusion flag. Used in conjunction with the process level inclusion flag in the customer file. Valid values are: allowed
  • I Process level invoice allowed
  • Blank Process level invoice not
AR10.2

Indexes (1)

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

IndexKeysFlagsConditionUsed in
CUTSET1COMPANY, CUSTOMER, PROCESS-LEVELPrimaryAC56.1, AC560, AR10.1, AR10.2, AR301, ARLL.1, BR00.1, BR00.2 +22 more (list truncated in source)

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequiredCUT-COMPANY → ACO-COMPANY
ArcustomerARCUSTOMERRequiredCUT-COMPANY → ACM-COMPANY, CUT-CUSTOMER → ACM-CUSTOMER
ArproclevlARPROCLEVLRequiredCUT-COMPANY → APV-COMPANY, CUT-PROCESS-LEVEL → APV-PROCESS-LEVEL
CustomernameCUSTDESCRequiredACO-CUST-GROUP → CUD-CUST-GROUP, ACM-CUSTOMER → CUD-CUSTOMER

Programs

Updated by (3)

Referenced by (94)