| View Name: | MARIDocumentInvoiceFlowPosition |
| Based on table: | MPDocumentInvoiceFlowPosition |
| Group: | |
| Description: | InvoicePaymentReportStore Positions |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| DocumentFlowPosID | DocumentFlowPosID INT Primary |
||
| DocumentFlowID | DocumentFlowID INT Index |
MARIDocumentInvoiceFlow.DocumentFlowID | |
| ContractPositionID | ContractPositionID INT |
MARIContractPositions.ContractPositionID | |
| DocumentPositionID | DocumentPositionID INT |
MARIContractDocumentPositions.DocumentPositionID | |
| PositionOrder | PositionOrder INT Index |
||
| PosText | PosText NVARCHAR (20) |
||
| ContractPosDescription1 | ContractPosDescription1 NVARCHAR (200) |
||
| ContractPosDescription2 | ContractPosDescription2 NVARCHAR (200) |
||
| ContractPosPositionInfo | ContractPosPositionInfo NTEXT |
||
| ContractPosAccountingInfo | ContractPosAccountingInfo NTEXT |
||
| ContractPositionValueSys | ContractPositionValueSys NUMERIC(19,6) |
||
| ContractPositionValueLoc | ContractPositionValueLoc NUMERIC(19,6) |
||
| ContractPositionValueFC | ContractPositionValueFC NUMERIC(19,6) |
||
| InvoicedYetSys | InvoicedYetSys NUMERIC(19,6) |
||
| InvoicedYetLoc | InvoicedYetLoc NUMERIC(19,6) |
||
| InvoicedYetFC | InvoicedYetFC NUMERIC(19,6) |
||
| InvoicedNowSys | InvoicedNowSys NUMERIC(19,6) |
||
| InvoicedNowLoc | InvoicedNowLoc NUMERIC(19,6) |
||
| InvoicedNowFC | InvoicedNowFC NUMERIC(19,6) |
||
| FutureInvoiceValueSys | FutureInvoiceValueSys NUMERIC(19,6) |
||
| FutureInvoiceValueLoc | FutureInvoiceValueLoc NUMERIC(19,6) |
||
| FutureInvoiceValueFC | FutureInvoiceValueFC NUMERIC(19,6) |
||
| RetentionPercent | RetentionPercent NUMERIC(19,6) |
||
| RetentionSys | RetentionSys NUMERIC(19,6) |
||
| RetentionLoc | RetentionLoc NUMERIC(19,6) |
||
| RetentionFC | RetentionFC NUMERIC(19,6) |
||
| QuantityContractPosition | QuantityContractPosition NUMERIC(19,6) |
||
| QuantityInvoicedYet | QuantityInvoicedYet NUMERIC(19,6) |
||
| QuantityNow | QuantityNow NUMERIC(19,6) |
||
| QuantityOpen | QuantityOpen NUMERIC(19,6) |
||
| ClaimedYetSys | ClaimedYetSys NUMERIC(19,6) |
||
| ClaimedYetLoc | ClaimedYetLoc NUMERIC(19,6) |
||
| ClaimedYetFC | ClaimedYetFC NUMERIC(19,6) |
||
| ClaimedNowSys | ClaimedNowSys NUMERIC(19,6) |
||
| ClaimedNowLoc | ClaimedNowLoc NUMERIC(19,6) |
||
| ClaimedNowFC | ClaimedNowFC NUMERIC(19,6) |
||
| FutureClaimedValueSys | FutureClaimedValueSys NUMERIC(19,6) |
||
| FutureClaimedValueLoc | FutureClaimedValueLoc NUMERIC(19,6) |
||
| FutureClaimedValueFC | FutureClaimedValueFC NUMERIC(19,6) |