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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CUTSET1
  1. COMPANY
  2. CUSTOMER
  3. PROCESS-LEVEL
PrimaryAC56.1, AC560, AR10.1, AR10.2, AR301, ARLL.1, BR00.1, BR00.2 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ARCOMPARCUSTOMERARPROCLEVLCUSTDESCARCUSTTOTS

One to one (4) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequired
CUT-COMPANY→ACO-COMPANY
ArcustomerARCUSTOMERRequired
CUT-COMPANY→ACM-COMPANY
CUT-CUSTOMER→ACM-CUSTOMER
ArproclevlARPROCLEVLRequired
CUT-COMPANY→APV-COMPANY
CUT-PROCESS-LEVEL→APV-PROCESS-LEVEL
CustomernameCUSTDESCRequired
ACO-CUST-GROUP→CUD-CUST-GROUP
ACM-CUSTOMER→CUD-CUSTOMER

Programs

Updated by (3)

Referenced by (94)