Table KPYIMPTRAN
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| KPYIMPTRAN | KPT | Sage 50 import transcribe | Financials | MUIMP |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| KPYT0 | TYP+INVALUE+COA+FCY+ACC | No | |
| KPUT1 | TYP+COA+FCY | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACC | Account | GAC | [GAC]GAC0=COA;ACC | Block | ||||
| ACCDAT | Report date | M | 4 | 1 | ||||
| AUUID | Single identifier | AUUID | ||||||
| CCE | Analytical dimension | A | 15 | |||||
| CDE | Default dimensions | CDE | [CDE]CDE0=CDE;[V]GSUPCLE | Block | ||||
| COA | Chart of accounts | COA | [COA]COA0=[KPT]COA | Delete | ||||
| CONTRA | Offset | M | 4 | 1 | ||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[KPT]CREUSR | Other | ||||
| FCY | Site | FCY | [FCY]FCY0=[KPT]FCY | Delete | ||||
| GAU | Automatic journal | GAU | [GAU]GAU0=[KPT]GAU | Other | ||||
| GTE | Entry type | GTE | [GTE]GTE0=GTE;[V]GSUPCLE | Block | ||||
| INVALUE | Source value | A | 100 | |||||
| TYP | Type | M | 15 | 3700 | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[KPT]UPDUSR | Other |