ARCDSELECT FILE
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).
UPDATED BY
AR06.1 AR160 AR161 AR17.1 AR170 AR70.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SEL-COMPANY Numeric 4 AR160 AR17.1
Company The company number represents an AR170 AR70.2
established company and is entered on
all function codes.
SEL-CREDIT-ANLYST Alpha 4 AR160 AR17.1
Credit Analyst Credit analyst assigned to the selected AR170 AR70.2
customer.
SEL-DATE Numeric 8 (yyyymmdd) AR160 AR17.1
Date System date this customer was selected AR170 AR70.2
via AR170 (Customer Review Selection) or
AR160 (Dunning Letter Creation).
SEL-SYS-TIME Numeric 6 (hhmmss) AR160 AR17.1
System Time System time this customer record was AR170 AR70.2
selected via AR170 (Customer Review
Selection) or AR160 (Dunning Letter
Creation)
SEL-CUSTOMER Alpha 9 (Right Justified) AR160 AR17.1
Customer Customer number of the selected AR170 AR70.2
customer.
SEL-SELECT-LEVEL Alpha 1 AR160 AR17.1
Selection Level Indicates the level of the selection. AR170 AR70.2
Valid values are:
C = Company level
N = National account level
SEL-STATUS Numeric 1 AR160 AR17.1
Record Status Status of the selected customer record. AR70.2
Valid values are:
0 = Open status - needs review
2 = Reviewed
9 = AR160 (Dunning Letter Creation)
source
SEL-CRED-ACTION Alpha 1 AR160 AR70.2
Credit Action 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 Alpha 1 AR160 AR70.2
On Hold Flag 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
SEL-DUNNING-NBR Numeric 2 AR160 AR161
Dunning Number Indicates whether a dunning letter AR17.1 AR70.2
(past due notice) is to be created. If a
dunning letter is to be printed, this
field will be greater than 00.
SEL-NEW-REVIEW Numeric 8 (yyyymmdd) AR160 AR70.2
Next Review Date Date user can specify indicating when
this customer should next be reviewed.
SEL-REVIEW-FL Alpha 1 AR160 AR170
Review Flag This flag will indicate if the customer AR70.2
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
SEL-TYPE Alpha 2 AR160 AR170
Review Reason 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
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 This is the primary path used to access AR06.1 AR170
CREDIT-ANLYST credit select records.
DATE
SYS-TIME
CUSTOMER
SELECT-LEVEL
SELSET2 COMPANY This path is used to access those AR70.1 AR70.2
CREDIT-ANLYST credit select records which have not
DATE been reviewed for display online.
SYS-TIME Subset
CUSTOMER Where STATUS = Zeroes
SELECT-LEVEL
SELSET3 COMPANY This path is used to access those AR170 AR70.2
CREDIT-ANLYST credit select records which have not
CUSTOMER been reviewed for batch processing.
SELECT-LEVEL Subset
Where STATUS = Zeroes
SELSET4 COMPANY This path is used to process credit AR160 AR161
CUSTOMER select records which will produce AR17.1 AR70.2
SELECT-LEVEL dunning letters.
Subset
Where DUNNING-NBR > Zeroes
ARCDSELECT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
