Table KPYIMPDTL
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| KPYIMPDTL | KPD | Sage 50/Murano payroll detail | Financials | MUIMP |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| KPYD0 | RECID+LINENO | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACC | Account | 10 | GAC | [GAC]GAC0=COA(indice);ACC(indice) | Delete | |||
| ACC_CODE | Code | A | 20 | |||||
| AMTCUR | Amount | MD1 | ||||||
| AUUID | Single identifier | AUUID | ||||||
| CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Other | ANA | |||
| CCEACC_CODE | Code | A | 20 | |||||
| CCECOSTCENTR | Cost Centre | A | 20 | |||||
| CCEDEPT | Department | A | 20 | |||||
| CCEEMPLOYEE | Employee | A | 15 | |||||
| COA | Chart of accounts | 10 | COA | [COA]COA0=[KPD]COA | Block | |||
| COSTCENTRE | Cost Centre | A | 20 | |||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[KPD]CREUSR | Other | ||||
| DEPT | Department | A | 20 | |||||
| DIE | Dimension type code | DIE | [DIE]DIE0=[KPD]DIE | Block | ANA | |||
| DSP | Distribution | DSP | [DSP]DSP0=DSP;1 | Other | MURAN | |||
| EMPLOYEE | Employee | A | 10 | |||||
| GRPGAS | Group entry | A | 30 | MURAN | ||||
| LED | Ledger | 10 | LED | [LED]LED0=[KPD]LED | Delete | MURAN | ||
| LINENO | Line no. | L | 4 | |||||
| NARRATIVE | Narrative | A | 50 | |||||
| NUMMURANO | Number | L | 8 | MURAN | ||||
| QTY | Quantity | QTY | MURAN | |||||
| RECID | Identifier | A | 25 | |||||
| REFNO | Report line | A | 50 | |||||
| SNS | Sign | C | 2 | |||||
| SRC_LINE | Source line | A | 10 | |||||
| TMPACC1 | Source account | A | 50 | |||||
| TRSDAT | Transaction date | D | ||||||
| UOM | Unit | UOM | [TUN]TUN0=[KPD]UOM | Delete | MURAN | |||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[KPD]UPDUSR | Other |