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. |
|
||
SEL-CREDIT-ANLYST Element: Credit Analyst | Alpha 4 Credit analyst assigned to the selected customer. |
|
||
SEL-DATE Element: Date | Numeric 8 (yyyymmdd) System date this customer was selected via AR170 (Customer Review Selection) or AR160 (Dunning Letter Creation). |
|
||
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) |
|
||
SEL-CUSTOMER Element: Customer | Alpha 9 (Right Justified) Customer number of the selected customer. |
|
||
SEL-SELECT-LEVEL Element: Selection Level | Alpha 1 Indicates the level of the selection. Valid values are: C = Company level N = National account level |
|
||
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 |
|
||
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 |
|
||
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. |
|
||
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 |
|
||
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 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SELSET1 |
COMPANY CREDIT-ANLYST DATE SYS-TIME CUSTOMER SELECT-LEVEL |
|
| ||||||||||||||
SELSET2 |
COMPANY CREDIT-ANLYST DATE SYS-TIME CUSTOMER SELECT-LEVEL |
|
|||||||||||||||
SELSET3 |
COMPANY CREDIT-ANLYST CUSTOMER SELECT-LEVEL |
|
|||||||||||||||
SELSET4 |
COMPANY CUSTOMER SELECT-LEVEL |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Aranalyst | CRANALYST |
Required
| ||||||
Arcomp | ARCOMP |
Required
| ||||||
Arcustomer | ARCUSTOMER |
Required
| ||||||
Custdesc | CUSTDESC |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.