Table CLTCTDA
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| CLTCTDA | CCA | Customer date contracts | Geode GX |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| CCA0 | FCY+DLVCLT+DEP+FAM+ITM | No | |
| CCA1 | FCY+SRTDSP+DLVCLT+DEP+FAM+ITM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[CCA]CREUSR | Other | ||||
| DEP | Depositor | DEP | [DEP]DEP0=FCY;DEP | Other | ||||
| DLVCLT | Ship to | CLT | [CLT]CLT0=FCY;DLVCLT | Other | ||||
| DLYUNT | Unit | M | 15 | 501 | ||||
| DLYVAL | Lead time | L | 3 | |||||
| ENAFLG | Active | M | 4 | 1 | ||||
| FAM | Family | FAM | [FAM]FAM0=FCY;DEP;FAM | Other | ||||
| FCY | Site | FCY | [FCY]FCY0=FCY | Block | ||||
| ITM | Product | ITM | [ITM]ITM0=FCY;DEP;ITM | Other | ||||
| SRTDSP | Sort | C | 4 | |||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[CCA]UPDUSR | Other |