| View Name: | MARIDocumentDraftPosition |
| Based on table: | MPDocumentDraftPosition |
| Group: | Group: DocumentDraftHead |
| Description: | Positions based on the order of the paper document |
| ClassID: | 349. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| DocumentDraftID | DocumentDraftID INT Index |
MARIDocumentDraftHead.DocumentDraftID | |
| DocumentDraftPosID | DocumentDraftPosID INT Primary |
||
| PosType | PosType SMALLINT |
clsImportDraftDocumentPos_eDraftPositionType | |
| Company | Company SMALLINT |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| PositionIndex | Index INT |
||
| PositionText | Position NVARCHAR (20) |
||
| PositionStatus | PositionStatus SMALLINT |
||
| ItemNumber | ItemNumber NVARCHAR (50) |
OITM.ItemCode | |
| TravelExpenseType | TravelExpenseType NVARCHAR (20) |
MARITravelExpenseTypes.TravelExpenseType | |
| ServiceType | ServiceType NVARCHAR (20) |
MARIServices.ServiceType | |
| EquipmentSubject | EquipmentSubject NVARCHAR (20) |
MARIEquipmentCategorySubject.EquipmentSubject | |
| EquipmentCode | EquipmentCode NVARCHAR (20) |
MARIEquipmentMaster.EquipmentCode | |
| EquipmentCategory | EquipmentCategory INT |
MARIEquipmentCategory.EquipmentCategory | |
| SubCatNum | SubCatNum NVARCHAR (20) |
||
| MPInsID | MPInsID INT |
MARICustomerServiceObject.MPInsID | |
| Description1 | Description1 NVARCHAR (200) |
||
| Description2 | Description2 NVARCHAR (200) |
||
| DeliveryWeek | DeliveryWeek INT |
||
| DeliveryDate | DeliveryDate Datetime |
||
| DeliveryTime | DeliveryTime INT |
||
| RentalStartDate | RentalStartDate Datetime |
||
| TaxCode | TaxCode NVARCHAR (10) |
||
| TaxPercent | TaxPercent NUMERIC(19,6) |
||
| TaxClass | TaxClass SMALLINT |
||
| TaxManual | TaxManual SMALLINT (0=false,-1=true) |
||
| TaxSubTable | TaxSubTable SMALLINT (0=false,-1=true) |
||
| TaxWtLiable | TaxWtLiable SMALLINT (0=false,-1=true) |
||
| TaxUsage | TaxUsage INT |
||
| TaxCSTcode | TaxCSTcode NVARCHAR (4) |
||
| TaxCFOPcode | TaxCFOPcode NVARCHAR (6) |
||
| LocationID | LocationID INT |
||
| Quantity | Quantity NUMERIC(19,6) |
||
| QuantityRequest | QuantityRequest NUMERIC(19,6) |
||
| QuantityMakeOrBuy | QuantityMakeOrBuy NUMERIC(19,6) |
||
| Quantity4Service | Quantity4Service NUMERIC(19,6) |
||
| QuantityUnit | QuantityUnit NVARCHAR (20) |
||
| QuantityType | QuantityType INT |
||
| QuantityCount | QuantityCount NUMERIC(19,6) |
||
| QuantityDuration | QuantityDuration NUMERIC(19,6) |
||
| CountText | CountText NVARCHAR (100) |
||
| QuantityFormularID | QuantityFormularID INT Index |
||
| NetUnitPriceSys | NetUnitPriceSys NUMERIC(19,6) |
||
| NetUnitPriceLoc | NetUnitPriceLoc NUMERIC(19,6) |
||
| NetUnitPriceFC | NetUnitPriceFC NUMERIC(19,6) |
||
| NetTotalSys | NetTotalSys NUMERIC(19,6) |
||
| NetTotalLoc | NetTotalLoc NUMERIC(19,6) |
||
| NetTotalFC | NetTotalFC NUMERIC(19,6) |
||
| RebatePercent | RebatePercent NUMERIC(19,6) |
||
| RebateValueSys | RebateValueSys NUMERIC(19,6) |
||
| RebateValueLoc | RebateValueLoc NUMERIC(19,6) |
||
| RebateValueFC | RebateValueFC NUMERIC(19,6) |
||
| CurrencySys | CurrencySys NVARCHAR (3) |
||
| CurrencyLoc | CurrencyLoc NVARCHAR (3) |
||
| CurrencyFC | CurrencyFC NVARCHAR (3) |
||
| CurrencyRateLoc | CurrencyRateLoc Float |
||
| CurrencyRateFC | CurrencyRateFc Float |
||
| PositionInfo | PositionInfo NTEXT |
||
| AccountingInfo | AccountingInfo NTEXT |
||
| Reference1 | Reference1 NVARCHAR (50) |
||
| Reference2 | Reference2 NVARCHAR (50) |
||
| Reference3 | Reference3 NVARCHAR (50) |
||
| RefDate1 | RefDate1 Datetime |
||
| RefDate2 | RefDate2 Datetime |
||
| RefDate3 | RefDate3 Datetime |
||
| QualityProcess | QualityProcess INT |
||
| QualityProcessSales | QualityProcessSales INT |
||
| QualityStatus | QualityStatus INT |
||
| ChargeMode | ChargeMode SMALLINT |
||
| Height1 | Height1 NUMERIC(19,6) |
||
| Hght1Unit | Hght1Unit SMALLINT |
||
| Width1 | Width1 NUMERIC(19,6) |
||
| Wdth1Unit | Wdth1Unit SMALLINT |
||
| Length1 | Length1 NUMERIC(19,6) |
||
| Len1Unit | Len1Unit SMALLINT |
||
| Volume | Volume NUMERIC(19,6) |
||
| VolUnit | VolUnit SMALLINT |
||
| Weight1 | Weight1 NUMERIC(19,6) |
||
| Wght1Unit | Wght1Unit SMALLINT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIDocumentDraftPositionLink | Linked positions in the sales contract and or purchase process |
| MARIDocumentDraftPositionLinkTax | Linked positions in the sales contract and or purchase process sub tax |
| MARIContainerLine | Container Lines to see the goods in the container |