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 |