Table KPYIMPHDR
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| KPYIMPHDR | KPH | Sage 50/Murano payroll header | Financials | MUIMP |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| KPYH0 | RECID | No | |
| KPYH1 | GRPGAS | Yes | MURAN |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCDAT | Accounting date | D | ||||||
| AUUID | Single identifier | AUUID | ||||||
| BPRMURANO | Employee | A | 30 | MURAN | ||||
| CDE | Default dimensions | CDE | [CDE]CDE0=CDE;[V]GSUPCLE | Block | ||||
| CHGRAT | Rate | RCU | MURAN | |||||
| COD | Automatic journal | GAU | [GAU]GAU0=[KPH]COD | Block | MURAN | |||
| CPY | Company | CPY | [CPY]CPY0=[KPH]CPY | Block | ||||
| CPYNAM | Company name | A | 90 | |||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[KPH]CREUSR | Other | ||||
| CUR | Currency | CUR | [TCU]TCU0=[KPH]CUR | Block | ||||
| FCY | Site | FCY | [FCY]FCY0=[KPH]FCY | Delete | ||||
| FLGDET | Detailed | M | 4 | 1 | MURAN | |||
| FLGVAL | Validated | M | 4 | 1 | MURAN | |||
| GRPGAS | Group entry | A | 30 | MURAN | ||||
| GTE | Entry type | GTE | [GTE]GTE0=GTE;[V]GSUPCLE | Block | ||||
| IMPFIL | Import file | A | 50 | |||||
| INTREF | Internal reference | A | 8 | |||||
| LOT | Lot | A | 20 | MURAN | ||||
| NUM | Journal | VCR | ||||||
| NUMMURANO | Number | L | 8 | MURAN | ||||
| ORIPAY | Origin | M | 10 | 1 | MURAN | |||
| RECID | Identifier | A | 25 | |||||
| REF | Your reference | A | 50 | |||||
| RPODAT | Report date | D | ||||||
| RPONAM | Report name | A | 75 | |||||
| RPOTIM | Report time | A | 10 | |||||
| SRCFIL | File name | A | 50 | |||||
| STA | Posted | M | 4 | 1 | ||||
| STALOT | Status | MM | 15 | 617 | MURAN | |||
| TMPFCY | Site | A | 90 | |||||
| TOT | Total | MD1 | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[KPH]UPDUSR | Other |