|
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), or via AR17 (Comments).
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
Element: Company The number representing an AR company. AR170 AR70.2
SEL-CREDIT-ANLYST Alpha 4 AR160 AR17.1
Element: Credit AnalystCredit analyst assigned to the selected AR170 AR70.2
customer.
SEL-DATE Numeric 8 (yyyymmdd) AR160 AR17.1
Element: 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
Element: 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
Element: Customer Customer number of the selected AR170 AR70.2
customer.
SEL-SELECT-LEVEL Alpha 1 AR160 AR17.1
Element: Selection LeveIndicates 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
Element: Record Status Status of the selected customer record. AR70.2
Valid values are:
0 = Open status - needs review
2 = Reviewed
9 = Dunning Letter Select (AR160) or
Comments (AR17.1) source
SEL-CRED-ACTION Alpha 1 AR160 AR70.2
Element: 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 AR17.1
Element: On Hold Flag This indicates whether or not the AR170 AR70.2
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
Element: Dunning NumberIndicates 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
Element: Next Review DaDate user can specify indicating when
this customer should next be reviewed.
SEL-REVIEW-FL Alpha 1 AR160 AR17.1
Element: Review Flag This flag will indicate if the customer AR170 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
Element: 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
ARCDSELECT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SELSET1 COMPANY AR06.1 AR170
CREDIT-ANLYST
DATE
SYS-TIME
CUSTOMER
SELECT-LEVEL
SELSET2 COMPANY Subset AR70.1 AR70.2
CREDIT-ANLYST Where STATUS = Zeroes
DATE
SYS-TIME
CUSTOMER
SELECT-LEVEL
SELSET3 COMPANY Subset AR170 AR70.2
CREDIT-ANLYST Where STATUS = Zeroes
CUSTOMER
SELECT-LEVEL
SELSET4 COMPANY Subset AR160 AR161
CUSTOMER Where DUNNING-NBR > Zeroes AR17.1 AR70.2
SELECT-LEVEL
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
|