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=906;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 |