CRANALYST – AR Credit Analysts

System: Accounts Receivable (AR)
Prefix: CAN
Primary key: COMPANY, CREDIT-ANLYST
Fields: 6
Updated by: 7 programs
Referenced by: 5 programs

CRANALYST is the AR Credit Analysts table in Lawson Accounts Receivable (prefix CAN). It is indexed by COMPANY, CREDIT-ANLYST (CANSET1). It is related 1:1 to ARCOMP and 1:M to ARCDSELECT. It is updated by AR06.1, AR09.1, AR10.1, AR301, AR501, AR550 and TX140 and referenced by AR01.1, AR08.1, AR206, AR210 and AR217. The table has 6 fields, 1 index and 2 documented relations.

About CRANALYST

The AR Credit Analysts file contains credit analyst records. These records act as an identifier of a credit analyst that will be assigned to customer records. Credit anlyst codes are used for selection and sort criteria in various forms and reports.

Fields (6)

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

Field / column	Type	Description & values	Updated by
`CAN-COMPANY` PK COMPANY	Numeric 4	The number representing an AR company.	AR06.1
`CAN-CREDIT-ANLYST` PK CREDIT_ANLYST	Alpha 4	Credit Analyst. Code or identifier of a credit analyst or definition of responsibility that will be assigned to a customer.	AR06.1
`CAN-NAME` NAME	Alpha 30 (Lower Case)	The name/description of the credit responsibility.	AR06.1
`CAN-PHONE-NMBR` PHONE_NMBR	Alpha 15	Credit analyst's telephone number.	AR06.1
`CAN-PHONE-EXT` PHONE_EXT	Alpha 5	Telephone extension number.	AR06.1
`CAN-USED-FL` USED_FL	Alpha 1	This field indicates whether or not this credit analyst has been used, (assigned to a customer). Valid values are: `N` No `Y` Yes	AR06.1, AR09.1, AR10.1, AR301, AR501, AR550, TX140

Indexes (1)

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

Index	Keys	Flags	Condition	Used in
`CANSET1`	`COMPANY`, `CREDIT-ANLYST`	Primary		AR01.1, AR06.1, AR08.1, AR09.1, AR10.1, AR206, AR210, AR217 +4 more

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Arcomp	ARCOMP	Required		`CAN-COMPANY` → `ACO-COMPANY`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Creditsel	ARCDSELECT	Delete Cascades		`CAN-COMPANY` → `SEL-COMPANY`, `CAN-CREDIT-ANLYST` → `SEL-CREDIT-ANLYST`, → `SEL-DATE`, → `SEL-SYS-TIME`, → `SEL-CUSTOMER`, → `SEL-SELECT-LEVEL`

Programs

Updated by (7)

AR06.1 Credit Analyst
AR09.1 Customer Group Address
AR10.1 Customer
AR301 Customer Purge
AR501 Customer Conversion
AR550 Customer Interface
TX140 Vertex Geocode Update

Referenced by (5)

AR01.1 Company
AR08.1 Customer Defaults
AR206 Operational Setup 1 Listing
AR210 Customer Listing
AR217 Comments Listing