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 |