Table DVRCTDA
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| DVRCTDA | DCA | Supplier date contracts | Geode GX |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| DCA0 | FCY+DVR+DEP+FAM+ITM | No | |
| DCA1 | FCY+SRTDSP+DVR+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=[DCA]CREUSR | Other | ||||
| DEP | Depositor | DEP | [DEP]DEP0=FCY;DEP | Other | ||||
| DLYUNT | Unit | M | 15 | 501 | ||||
| DLYVAL | Lead time | L | 3 | |||||
| DVR | Supplier | DVR | [DVR]DVR0=FCY;DVR | Other | ||||
| 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 | ||||
| SKN | Stock Status | SKN | [SKN]SKN0=FCY;SKN | Block | ||||
| SRTDSP | Sort | C | 4 | |||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[DCA]UPDUSR | Other |