Table TMPFUP0
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| TMPFUP0 | TF0 | Campaign criteria | A/P-A/R accounting | FUP |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| TFP0 | QURNUM | No | |
| TFP1 | CREDAT+QURNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCLI | Customer prepayments | M | 4 | 1 | ||||
| AGIO | Late charge calculation | M | 4 | 1 | ||||
| ALLBPC | All customers | M | 4 | 1 | ||||
| ALLBPCGRU | All group customers | M | 4 | 1 | ||||
| ALLBPCRSK | All risk customers | M | 4 | 1 | ||||
| ALLCLS | All classes | M | 4 | 1 | ||||
| ALLFCY | All sites | M | 4 | 1 | ||||
| ALLFGP | All reminder groups | M | 4 | 1 | ||||
| ALLPAM | All payment methods | M | 4 | 1 | ||||
| ALLREP | All sales reps. | M | 4 | 1 | REC | |||
| ALLREP1 | All representatives 1 | M | 4 | 1 | ||||
| ALLREP2 | All representatives 2 | M | 4 | 1 | ||||
| ALLSAC | All control accounts | M | 4 | 1 | ||||
| ALLTSCCOD | All stat groups | M | 4 | 1 | ||||
| ALLUSR | All users | M | 4 | 1 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BPCDEB | From customer | BPR | [BPR]BPR0=[TF0]BPCDEB | Block | ||||
| BPCFIN | To customer | BPR | [BPR]BPR0=[TF0]BPCFIN | Block | ||||
| BPCGRU | Group customer | BPR | [BPR]BPR0=[TF0]BPCGRU | Block | ||||
| BPCRSKEND | Risk BP | BPR | [BPR]BPR0=[TF0]BPCRSKEND | Block | ||||
| BPCRSKSTR | Risk BP | BPR | [BPR]BPR0=[TF0]BPCRSKSTR | Block | ||||
| BPRFUP | Reminded BP | M | 15 | 672 | ||||
| CLS | Class | M | 15 | 212 | ||||
| CMT | Comment | A | 250 | |||||
| COA | Chart of accounts | COA | [COA]COA0=[TF0]COA | Block | ||||
| CPY | Company | AGC | [AGF]AGF0=[TF0]CPY | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | AUS | [AUS]CODUSR=[TF0]CREUSR | Other | ||||
| CRI | Criteria | AFR | 250 | |||||
| ECRAN | Screen | GFP | [GFP]GFP0=[TF0]ECRAN | Block | ||||
| FCY | Site | FCY | [FCY]FCY0=[TF0]FCY | Block | ||||
| FGP | Reminder group | FGP | [FGP]FGP0=[TF0]FGP | Block | FUP | |||
| FLGFUP | M | 4 | 1 | |||||
| FUPLEVEND | Level of reminder | C | 4 | |||||
| FUPLEVSTR | Level of reminder | C | 4 | |||||
| GRPSAC | Control group | GSC | [GSC]GSC0=COA;GRPSAC;1 | Block | ||||
| PAM | Payment method | TAM | [TAM]TAM0=PAM;[V]GSUPCLE | Block | ||||
| QURNUM | Campaign number | FUP | [TF0]TFP0=[TF0]QURNUM | BSRA | ||||
| REFDAT | Reference date | D | ||||||
| REPDEB | From sales rep | REP | [REP]REP0=[TF0]REPDEB | Block | REC | |||
| REPDEB1 | From sales rep | REP | [REP]REP0=[TF0]REPDEB1 | Block | ||||
| REPDEB2 | From sales rep | REP | [REP]REP0=[TF0]REPDEB2 | Block | ||||
| REPFIN | To sales rep | REP | [REP]REP0=[TF0]REPFIN | Block | REC | |||
| REPFIN1 | To sales rep | REP | [REP]REP0=[TF0]REPFIN1 | Block | ||||
| REPFIN2 | To sales rep | REP | [REP]REP0=[TF0]REPFIN2 | Block | ||||
| SAC | Control | SAC | ||||||
| TSCCOD | Statistical group | ADI | [ADI]CODE=indice+30;TSCCOD(indice) | Other | STC | |||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | AUS | [AUS]CODUSR=[TF0]UPDUSR | Other | ||||
| USR | User code | AUS | [AUS]CODUSR=[TF0]USR | Delete | ||||
| VALIDE | Validated campaign | M | 4 | 1 |