CRANALYST

AR Credit Analysts

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.

REFERENCED BY
AR08.1 AR206 AR210 AR217


UPDATED BY
AR06.1 AR09.1 AR10.1 AR301 AR501 AR550
TX140 AR01.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CAN-COMPANY
Element: Company		Numeric 4
The number representing an AR company.
AR06.1
CAN-CREDIT-ANLYST
Element: 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
Element: Credit Analyst Name		Alpha 30 (Lower Case)
The name/description of the credit responsibility.
AR06.1
CAN-PHONE-NMBR
Element: Phone		Alpha 15
Credit analyst's telephone number.
AR06.1
CAN-PHONE-EXT
Element: Phone Ext		Alpha 5
Telephone extension number.
AR06.1
CAN-USED-FL
Element: 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


CRANALYST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CANSET1 COMPANY
CREDIT-ANLYST
AR01.1 AR06.1
AR08.1 AR09.1
AR10.1 AR206
AR210 AR217
AR301 AR501
AR550 TX140


CRANALYST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
CAN-COMPANY->ACO-COMPANY


CRANALYST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Creditsel ARCDSELECT Delete Cascades
CAN-COMPANY->SEL-COMPANY
CAN-CREDIT-ANLYST->SEL-CREDIT-ANLYST
  SEL-DATE
  SEL-SYS-TIME
  SEL-CUSTOMER
  SEL-SELECT-LEVEL

File created: Wed Jun 08 20:47:56 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.