| View Name: | MARIDocumentDraftHead |
| Based on table: | MPDocumentDraftHead |
| Group: | Group: DocumentDraftHead |
| Description: | Header for the draft document |
| ClassID: | 347. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| DocumentDraftID | DocumentDraftID INT Primary |
||
| DocumentType | DocumentType INT |
clsImportDraftDocument_eDraftDocumentType | |
| DocumentViewMode | DocumentViewMode INT |
||
| DocumentTemplate | DocumentTemplate INT |
||
| DocumentCreationDate | DocumentCreationDate Datetime |
||
| DocumentDate | DocumentDate Datetime |
||
| DraftStatus | DraftStatus INT |
clsImportDraftDocument_eDraftStatus | |
| Period | Period INT |
MARIPeriods.Period | |
| OptionMemo | OptionMemo NTEXT |
||
| ProcessDate | ProcessDate Datetime |
||
| ProcessID | ProcessID NVARCHAR (4) |
||
| DraftDocNumber | DraftDocNumber INT Index |
||
| DraftDocNumberVisible | DraftDocNumberVisible NVARCHAR (20) |
||
| Company | Company SMALLINT Index |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| BPLId | BPLId INT |
BranchID | OINF.BPLId |
| DocSeries | DocSeries INT |
NNM1.Seris | |
| DocNumSegment | DocNumSegment INT |
OINV.Secment | |
| DocSeriesString | DocSeriesString NVARCHAR (3) |
OINV.SeriesStr | |
| DocSeriesSubString | DocSeriesSubString NVARCHAR (3) |
OINV.SubStr | |
| SequenceCode | SequenceCode INT |
OINV.SeqCode | |
| SequenceSerial | SequenceSerial INT |
||
| SequenceModel | SequenceModel NVARCHAR (10) |
Field for Brazil | OINV.Model |
| DeferrTax | DeferrTax SMALLINT (0=false,-1=true) |
||
| PTICode | PTICode NVARCHAR (5) |
Localization Argentina | OPOR.PTICode |
| Letter | Letter NVARCHAR (1) |
Localization Argentina | OPOR.Letter |
| FolNumFrom | FolNumFrom INT |
Localization Argentina | OPOR.FolNumFrom |
| FolNumTo | FolNumTo INT |
Localization Argentina | OPOR.FolNumTo |
| FolSeries | FolSeries INT |
Localization Argentina | OPOR.FolSeries |
| Indicator | Indicator NVARCHAR (2) |
Localization Argentina SELECT * FROM OIDC | OPOR.Indicator |
| ImportEnt | ImportEnt INT |
Localization Argentina | OPOR.ImportEnt |
| FiscDocNum | FiscDocNum NVARCHAR (100) |
Localization Poland | OPOR.FiscDocNum |
| PaymentRef | PaymentRef NVARCHAR (27) |
||
| DocYear | DocYear Datetime |
||
| ShipmentType | ShipmentType INT |
||
| A0AddressNr | A0AdressNr INT |
||
| A0CardCode | A0Empfaenger NVARCHAR (20) Index |
OCRD.CardCode | |
| A0Salutation | A0Anrede NVARCHAR (50) |
||
| A0Name1 | A0Name1 NVARCHAR (100) |
||
| A0Name2 | A0Name2 NVARCHAR (50) |
||
| A0Name3 | A0Zusatz NVARCHAR (50) |
||
| A0OneTimeCustomer | A0Einmalkunde SMALLINT |
||
| A0Matchcode | A0Matchcode NVARCHAR (100) |
||
| A0Street | A0Strasse NVARCHAR (100) |
||
| A0StreetNumber | A0Hausnummer NVARCHAR (100) |
||
| A0Country | A0Land NVARCHAR (3) |
||
| A0ZIP | A0PLZ NVARCHAR (20) |
||
| A0City | A0Ort NVARCHAR (100) |
||
| A0County | A0Bezirk NVARCHAR (100) |
||
| A0State | A0Bundesland NVARCHAR (3) |
||
| A0Block | A0Gebaeude NVARCHAR (100) |
||
| A0ContactPerson | A0AnsprechpartnerID INT |
OCPR.CntctCode | |
| A0AddressName1 | A0AdressName NVARCHAR (50) |
||
| A0AddressName2 | A0AdressName2 NVARCHAR (50) |
||
| A0AddressName3 | A0AdressName3 NVARCHAR (50) |
||
| A0Building | A0GebaeudeStockwerk NTEXT |
||
| A0AddressMemo | A0AdressMemo NTEXT |
||
| A0CardFName | A0CardFName NVARCHAR (100) |
||
| A0AddrType | A0AddrType NVARCHAR (100) |
||
| A0AddressLineNum | A0AdressLineNum INT |
||
| A0GlbLocNum | A0GlbLocNum NVARCHAR (50) |
||
| A0Longitude | A0Longitude Float |
||
| A0Latitude | A0Latitude Float |
||
| A1BusinessPartner | A1BusinessPartner NVARCHAR (20) |
OCRD.CardCode | |
| A1Salutation | A1Anrede NVARCHAR (50) |
||
| A1Name1 | A1Name1 NVARCHAR (100) |
||
| A1Name2 | A1Name2 NVARCHAR (50) |
||
| A1Name3 | A1Zusatz NVARCHAR (50) |
||
| A1Matchcode | A1Matchcode NVARCHAR (100) |
||
| A1Street | A1Strasse NVARCHAR (100) |
||
| A1StreetNum | A1Hausnummer NVARCHAR (100) |
||
| A1Country | A1Land NVARCHAR (3) |
||
| A1ZIP | A1PLZ NVARCHAR (20) |
||
| A1City | A1Ort NVARCHAR (100) |
||
| A1County | A1Bezirk NVARCHAR (100) |
||
| A1State | A1Bundesland NVARCHAR (3) |
||
| A1Block | A1Gebaeude NVARCHAR (100) |
||
| A1ContactPerson | A1AnsprechpartnerID INT |
OCPR.CntctCode | |
| A1AddressName1 | A1AdressName NVARCHAR (50) |
||
| A1AddressName2 | A1AdressName2 NVARCHAR (50) |
||
| A1AddressName3 | A1AdressName3 NVARCHAR (50) |
||
| A1Building | A1GebaeudeStockwerk NTEXT |
||
| A1AddressMemo | A1AdressMemo NTEXT |
||
| A1CardFName | A1CardFName NVARCHAR (100) |
||
| A1AddrType | A1AddrType NVARCHAR (100) |
||
| A1AddressLineNum | A1AdressLineNum INT |
||
| A1GlbLocNum | A1GlbLocNum NVARCHAR (50) |
||
| A1Longitude | A1Longitude Float |
||
| A1Latitude | A1Latitude Float |
||
| ApprovalMode | ApprovalMode SMALLINT Index |
||
| ApprovedOn | ApprovedOn Datetime |
||
| ApprovedBy | ApprovedBy NVARCHAR (4) |
MARIUser.ApprovedBy (WHERE BenutzerTyp=1) | |
| ApprovedByEmployee | ApprovedByEmployee NVARCHAR (20) |
MARIEmployeeMaster.ApprovedByEmployee | |
| ApprovalText | ApprovalText NTEXT |
||
| NetPositionTotalSys | NetPositionTotalSys NUMERIC(19,6) |
||
| NetPositionTotalLoc | NetPositionTotalLoc NUMERIC(19,6) |
||
| NetPositionTotalFc | NetPositionTotalFc NUMERIC(19,6) |
||
| NetValueSys | NetValueSys NUMERIC(19,6) |
||
| NetValueLoc | NetValueLoc NUMERIC(19,6) |
||
| NetValueFc | NetValueFc NUMERIC(19,6) |
||
| TotalValueSys | TotalValueSys NUMERIC(19,6) |
||
| TotalValueLoc | TotalValueLoc NUMERIC(19,6) |
||
| TotalValueFc | TotalValueFc NUMERIC(19,6) |
||
| TaxValueSys | TaxValueSys NUMERIC(19,6) |
||
| TaxValueLoc | TaxValueLoc NUMERIC(19,6) |
||
| TaxValueFc | TaxValueFc NUMERIC(19,6) |
||
| CurrencySys | CurrencySys NVARCHAR (3) |
||
| CurrencyLoc | CurrencyLoc NVARCHAR (3) |
||
| CurrencyFC | CurrencyFC NVARCHAR (3) |
||
| CurrencyRateLoc | CurrencyRateLoc Float |
||
| CurrencyRateFC | CurrencyRateFc Float |
||
| Reference1 | Reference1 NVARCHAR (100) |
||
| Reference2 | Reference2 NVARCHAR (100) |
||
| Reference3 | Reference3 NVARCHAR (254) |
||
| RefDate1 | RefDate1 Datetime |
||
| RefDate2 | RefDate2 Datetime |
||
| RefDate3 | RefDate3 Datetime |
||
| PaymentBlock | PaymentBlock SMALLINT (0=false,-1=true) |
||
| PaymentBlockRef | PaymentBlockRef INT |
||
| DiscountPercent | DiscountPercent NUMERIC(19,6) |
||
| DiscountBaseSys | DiscountBaseSys NUMERIC(19,6) |
||
| DiscountBaseLoc | DiscountBaseLoc NUMERIC(19,6) |
||
| DiscountBaseFc | DiscountBaseFc NUMERIC(19,6) |
||
| DiscountValueSys | DiscountValueSys NUMERIC(19,6) |
||
| DiscountValueLoc | DiscountValueLoc NUMERIC(19,6) |
||
| DiscountValueFc | DiscountValueFc NUMERIC(19,6) |
||
| AvailabilityCheck | AvailabilityCheck INT |
||
| AvailabilityCheckDate | AvailabilityCheckDate Datetime |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIDocumentDraftHeadApproval | Approval or workflow list for the draft document |
| MARIDocumentDraftHeadLink | Linked contracts and purchase processes |
| MARIDocumentDraftInstallments | Payment conditions and installments |
| MARIDocumentDraftPosition | Positions based on the order of the paper document |
| MARIDocumentDraftTax | Tax information |
| MARIContainerLine | Container Lines to see the goods in the container |