Table BAPPOINT
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| BAPPOINT | BAP | Appointment | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| APP0 | APTNUM | No | |
| APP1 | APTWEE | Yes | |
| APP2 | APTDAT+APTHOU+APTNUM | No | |
| APP3 | APTWEE+APTDAT+APTHOU | Yes | |
| APP4 | APTDATX | Yes | |
| APP5 | APTCMP | Yes | |
| APP6 | APTORIADI+APTORIVCR+APTORIVCRL | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| APTADD | Address | 3 | CAD | |||||
| APTCCNNUM | Contact to visit | 10 | AIN | [AIN]AIN0=[BAP]APTCCNNUM | Block | |||
| APTCMGNUM | Campaign code | CMG | [CMG]CMG0=[BAP]APTCMGNUM | Block | ||||
| APTCMP | BP | BPR | [BPR]BPR0=[BAP]APTCMP | Block | ||||
| APTCODADD | Address code | ADR | ||||||
| APTCOR | Outlook contact | 10 | COR | [COR]COR0=[BAP]APTCOR | Block | |||
| APTCRY | Country | CRY | [TCY]TCY0=[BAP]APTCRY | Block | ||||
| APTCTY | City | CTY | ||||||
| APTDAT | Appointment date | D | ||||||
| APTDATEND | Last appointment | D | ||||||
| APTDATX | Week conversion | D | ||||||
| APTDON | Completed | M | 4 | 1 | ||||
| APTDUR | Appointment duration | HM | ||||||
| APTEML | Email address | MAI | ||||||
| APTHOU | Appointment time | HM | ||||||
| APTHOUEND | End time | HM | ||||||
| APTMOB | Mobile phone | TEL | ||||||
| APTNUM | Appointment chrono | VCR | ||||||
| APTOBJ | Summary objective | CLX | ||||||
| APTOPGNUM | Operation code | VCR | ||||||
| APTOPGTYP | Operation type | AOB | [AOB]ABREV=[BAP]APTOPGTYP | Block | ||||
| APTORI | Source | M | 15 | 2994 | ||||
| APTORIADI | Source | ADI | [ADI]CODE=439;APTORIADI | Block | ||||
| APTORIAOB | Object code | AOB | [AOB]ABREV=[BAP]APTORIAOB | Block | ||||
| APTORITYP | Source type | M | 15 | 3037 | ||||
| APTORIVCR | Document no. | VCR | ||||||
| APTORIVCRL | Line no. | L | 8 | |||||
| APTPJT | Project | PJT | [PIM]PIM0=[BAP]APTPJT | Block | ||||
| APTPLC | Location | M | 955 | |||||
| APTRECADD | Recording | AIN | [AIN]AIN0=[BAP]APTRECADD | Block | ||||
| APTREPNUM | Sales rep | 10 | REP | [REP]REP0=[BAP]APTREPNUM | Block | |||
| APTRER | Reservation | 15 | RRS | [RRS]RRS0=[BAP]APTRER | Block | |||
| APTRPO | Overview | CLX | ||||||
| APTSAO | Satisfaction | ADI | [ADI]CODE=437;APTSAO | Block | ||||
| APTSAT | County | SAT | ||||||
| APTTEL | Telephone | TEL | ||||||
| APTTYP | Category | ADI | [ADI]CODE=433;APTTYP | Block | ||||
| APTTYPADD | Type | M | 15 | 954 | ||||
| APTWEE | Appointment week | C | 4 | |||||
| APTZIP | Postal code | POS | ||||||
| ATPADDCMT | Address description | CLX | ||||||
| ATPREPMNA | Organizer | REP | [REP]REP0=[BAP]ATPREPMNA | Block | ||||
| AUUID | Single identifier | AUUID | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREHOU | Creation time | HM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| FULDAY | Entire day | M | 4 | 1 | ||||
| NUMFULOBJ | Chrono txt file | CLC | ||||||
| NUMFULRPO | Chrono txt file | CLC | ||||||
| OBJFLG | Flag text file | C | 2 | |||||
| RPOFLG | Flag text file | C | 2 | |||||
| SALFCY | Sales site | FCY | [FCY]FCY0=[BAP]SALFCY | Block | ||||
| TYPFULOBJ | Type text file | CLT | ||||||
| TYPFULRPO | Type text file | CLT | ||||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |