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 |