| View Name: | MARIPayrollLineAttachment |
| Based on table: | MPLohnZeileAnhang |
| Group: | Group: PayrollTypes |
| Description: | Payroll Interface: Export Lines Source Details |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| LineAttachmentID | ZeilenAnhangID INT Primary |
||
| LineID | ZeilenID INT Index |
MARIPayrollLine.LineID | |
| SourcePeriod | QuellPeriode INT |
MARIPeriods.SourcePeriod | |
| CommissionRateSys | ProvisionsSatzSys NUMERIC(19,6) |
||
| CommissionRateLoc | ProvisionsSatzLoc NUMERIC(19,6) |
||
| CommissionValueSys | ProvisionsBetragSys NUMERIC(19,6) |
||
| CommissionValueLoc | ProvisionsBetragLoc NUMERIC(19,6) |
||
| CommissionThresholdValueSys | ProvisionsSchwellBetragSys NUMERIC(19,6) |
||
| CommissionThresholdValueLoc | ProvisionsSchwellBetragLoc NUMERIC(19,6) |
||
| CommissionAdvanceValueSys | ProvisionsVorschussBetragSys NUMERIC(19,6) |
||
| CommissionAdvanceValueLoc | ProvisionsVorschussBetragLoc NUMERIC(19,6) |
||
| CommissionValuePeriodSys | ProvisionsAnspruchSys NUMERIC(19,6) |
||
| CommissionValuePeriodLoc | ProvisionsAnspruchLoc NUMERIC(19,6) |
||
| CommissionValuePreviousSys | BetragVormonatSys NUMERIC(19,6) |
||
| CommissionValuePreviousLoc | BetragVormonatLoc NUMERIC(19,6) |
||
| LineIDPrevious | ZeilenIDVormonat INT |
MARIPayrollLine.LineIDPrevious | |
| CommissionValueResultSys | AbrechnungsBetragSys NUMERIC(19,6) |
||
| CommissionValueResultLoc | AbrechnungsBetragLoc NUMERIC(19,6) |
||
| CurrencySys | WKZSys NVARCHAR (3) |
||
| CurrencyCompany | WKZLoc NVARCHAR (3) |