ARCDSELECT

AR Credit Selects

The AR Credit Selects file contains customer records that have been selected for credit review or dunning letter generation via AR170 (Customer Review Selection) or AR160 (Dunning Letter Creation), or via AR17 (Comments).
UPDATED BY
AR06.1 AR17.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SEL-COMPANY
Element: Company		Numeric 4
The number representing an AR company.
AR17.1
SEL-CREDIT-ANLYST
Element: Credit Analyst		Alpha 4
Credit analyst assigned to the selected customer.
AR17.1
SEL-DATE
Element: Date		Numeric 8 (yyyymmdd)
System date this customer was selected via AR170 (Customer Review Selection) or AR160 (Dunning Letter Creation).
AR17.1
SEL-SYS-TIME
Element: System Time		Numeric 6 (hhmmss)
System time this customer record was selected via AR170 (Customer Review Selection) or AR160 (Dunning Letter Creation)
AR17.1
SEL-CUSTOMER
Element: Customer		Alpha 9 (Right Justified)
Customer number of the selected customer.
AR17.1
SEL-SELECT-LEVEL
Element: Selection Level		Alpha 1
Indicates the level of the selection. Valid values are: C = Company level N = National account level
AR17.1
SEL-STATUS
Element: Record Status		Numeric 1
Status of the selected customer record. Valid values are: 0 = Open status - needs review 2 = Reviewed 9 = Dunning Letter Select (AR160) or Comments (AR17.1) source
AR17.1
SEL-CRED-ACTION
Element: Credit Action		Alpha 1
Indicates what action the analyst took when reviewing the selected customer's credit review record. Valid values are: C = Called N = No problem O = Other action
SEL-HOLD-FLAG
Element: On Hold Flag		Alpha 1
This indicates whether or not the customer was put on credit hold. Valid values are: N = Not put on hold Y = Credit hold on customer
AR17.1
SEL-DUNNING-NBR
Element: Dunning Number		Numeric 2
Indicates whether a dunning letter (past due notice) is to be created. If a dunning letter is to be printed, this field will be greater than 00.
AR17.1
SEL-NEW-REVIEW
Element: Next Review Date		Numeric 8 (yyyymmdd)
Date user can specify indicating when this customer should next be reviewed.
SEL-REVIEW-FL
Element: Review Flag		Alpha 1
This flag will indicate if the customer credit limit was reviewed. If it was, the system date will be moved to the Credit Limit Date field in the customer file. Valid values are: N = Credit Limit not reviewed Y = Credit Limit was reviewed
AR17.1
SEL-TYPE
Element: Review Reason		Alpha 2
Identifies the reason the record was selected. It will be updated by AR160 (Dunning Letter Creation), and AR170 (Customer Review Selection). Valid values are:
1 = Review date reached
2 = Credit limit date review
3 = Exceeded credit limit
4 = Exceeded aging limit


ARCDSELECT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SELSET1 COMPANY
CREDIT-ANLYST
DATE
SYS-TIME
CUSTOMER
SELECT-LEVEL
AR06.1
SELSET2 COMPANY
CREDIT-ANLYST
DATE
SYS-TIME
CUSTOMER
SELECT-LEVEL
Subset
WhereSTATUS =Zeroes
SELSET3 COMPANY
CREDIT-ANLYST
CUSTOMER
SELECT-LEVEL
Subset
WhereSTATUS =Zeroes
SELSET4 COMPANY
CUSTOMER
SELECT-LEVEL
Subset
WhereDUNNING-NBR >Zeroes
AR17.1


ARCDSELECT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Aranalyst CRANALYST Required
SEL-COMPANY->CAN-COMPANY
SEL-CREDIT-ANLYST->CAN-CREDIT-ANLYST
Arcomp ARCOMP Required
SEL-COMPANY->ACO-COMPANY
Arcustomer ARCUSTOMER Required
SEL-COMPANY->ACM-COMPANY
SEL-CUSTOMER->ACM-CUSTOMER
Custdesc CUSTDESC Required
ACO-CUST-GROUP->CUD-CUST-GROUP
SEL-CUSTOMER->CUD-CUSTOMER

File created: Thu Jun 09 11:08:55 2016

Home
Contact Us



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