| Table Name: | MPDocumentInvoiceFlow |
| View Name: | MARIDocumentInvoiceFlow |
| Group: | |
| Description: | InvoicePaymentReportStore |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| DocumentFlowID | DocumentFlowID INT Primary |
||
| DocumentType | DocumentType INT |
||
| DocumentReference | DocumentReference INT Index |
||
| SalesContractArchiveID | SalesContractArchiveID INT |
MPVKVertraege.VertragsID | |
| SalesContractArchiveMatchcode | SalesContractArchiveMatchcode NVARCHAR (100) |
||
| SalesContractID | SalesContractID INT |
MPVKVertraege.VertragsID | |
| SalesContractMatchcode | SalesContractMatchcode NVARCHAR (100) |
||
| Project | Project NVARCHAR (20) |
MPProjektstamm.Projektnummer | |
| ProjectManager | ProjectManager NVARCHAR (20) |
MPPersonenstamm.Personalnummer | |
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| PositionsDueUntil | PositionsDueUntil Datetime |
||
| CurrencySys | CurrencySys NVARCHAR (3) |
||
| CurrencyLoc | CurrencyLoc NVARCHAR (3) |
||
| CurrencyFC | CurrencyFC NVARCHAR (3) |
||
| CurrencyRateLoc | CurrencyRateLoc Float |
||
| CurrencyRateFc | CurrencyRateFC Float |
||
| ArchivedContractVolumeSys | ArchivedContractVolumeSys NUMERIC(19,6) |
||
| ArchivedContractVolumeLoc | ArchivedContractVolumeLoc NUMERIC(19,6) |
||
| ArchivedContractVolumeFc | ArchivedContractVolumeFc NUMERIC(19,6) |
||
| ContractVolumeSys | ContractVolumeSys NUMERIC(19,6) |
||
| ContractVolumeLoc | ContractVolumeLoc NUMERIC(19,6) |
||
| ContractVolumeFc | ContractVolumeFc NUMERIC(19,6) |
||
| ContractPositionValueSys | ContractPositionValueSys NUMERIC(19,6) |
||
| ContractPositionValueLoc | ContractPositionValueLoc NUMERIC(19,6) |
||
| ContractPositionValueFc | ContractPositionValueFc NUMERIC(19,6) |
||
| TotalInvoiceSys | TotalInvoiceSys NUMERIC(19,6) |
||
| TotalInvoiceLoc | TotalInvoiceLoc NUMERIC(19,6) |
||
| TotalInvoiceFc | TotalInvoiceFc NUMERIC(19,6) |
||
| RetentionPercent | RetentionPercent NUMERIC(19,6) |
||
| TotalRetentionSys | TotalRetentionSys NUMERIC(19,6) |
||
| TotalRetentionLoc | TotalRetentionLoc NUMERIC(19,6) |
||
| TotalRetentionFc | TotalRetentionFc NUMERIC(19,6) |
||
| TotalPaidSys | TotalPaidSys NUMERIC(19,6) |
||
| TotalPaidLoc | TotalPaidLoc NUMERIC(19,6) |
||
| TotalPaidFc | TotalPaidFc NUMERIC(19,6) |
||
| TotalDownPaymentValueSys | TotalDownPaymentValueSys NUMERIC(19,6) |
||
| TotalDownPaymentValueLoc | TotalDownPaymentValueLoc NUMERIC(19,6) |
||
| TotalDownPaymentValueFc | TotalDownPaymentValueFc NUMERIC(19,6) |
||
| CurrentPaymentDueSys | CurrentPaymentDueSys NUMERIC(19,6) |
||
| CurrentPaymentDueLoc | CurrentPaymentDueLoc NUMERIC(19,6) |
||
| CurrentPaymentDueFc | CurrentPaymentDueFc NUMERIC(19,6) |
||
| BalanceToFinishSys | BalanceToFinishSys NUMERIC(19,6) |
||
| BalanceToFinishLoc | BalanceToFinishLoc NUMERIC(19,6) |
||
| BalanceToFinishFc | BalanceToFinishFc NUMERIC(19,6) |
||
| TotalClaimedSys | TotalClaimedSys NUMERIC(19,6) |
||
| TotalClaimedLoc | TotalClaimedLoc NUMERIC(19,6) |
||
| TotalClaimedFc | TotalClaimedFc NUMERIC(19,6) |
| Table | Description |
|---|---|
| MPDocumentInvoiceFlowPosition | InvoicePaymentReportStore Positions |