Table LEAD
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| LEAD | LDS | Leads | CRM activities |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| LDS0 | PSTNUM | No | |
| LDS2 | PSTTYP+PSTNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| BPAADD | Default address | ADR | ||||||
| BUS | Business | ADI | [ADI]CODE=425;BUS | Block | ||||
| CPYCAF | Business result | MD1 | ||||||
| CPYCRN | Site registration number | CRT | ||||||
| CPYCRY | Country | CRY | [TCY]TCY0=[LDS]CPYCRY | Block | ||||
| CPYEFF | Headcount | A | 4 | |||||
| CPYNAF | SIC code | NAF | ||||||
| CPYNAM | Company name | NAM | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CUR | Currency | CUR | [TCU]TCU0=[LDS]CUR | Block | ||||
| DATFIRCNT | First contact date | D | ||||||
| FNC | Function | M | 15 | 233 | ||||
| FNCLIB | Function description | A | 50 | |||||
| MSS | Role | ADI | [ADI]CODE=414;MSS | Block | ||||
| NUMCLOB | Chrono txt file | CLC | ||||||
| ORIPPT | Source | ADI | [ADI]CODE=413;ORIPPT | Block | ||||
| PSTITR | Interest | M | 15 | 3041 | ||||
| PSTNUM | Code | LDS | [LDS]LDS0=[LDS]PSTNUM | Delete | ||||
| PSTORI | Source | M | 15 | 3042 | ||||
| PSTORITYP | Source type | M | 15 | 3037 | ||||
| PSTORIVCR | Original document no. | VCR | ||||||
| PSTORIVCRL | Original line no. | L | 8 | |||||
| PSTREP | Supervisor | REP | [REP]REP0=[LDS]PSTREP | Block | ||||
| PSTSTA | Status | M | 15 | 3040 | ||||
| PSTTYP | Type | M | 15 | 7811 | ||||
| SRV | Department | A | 30 | |||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |