| View Name: | MARITravelAccountingHeader |
| Based on table: | MPReise2BuchungKopf |
| Group: | Group: TravelTrip |
| Description: | Travel Expenses Module: Accounting Header |
| ClassID: | 159. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| TravelEntryID | ReiseBuchungsID INT Primary |
||
| TravelEntryHeadType | ReiseBuchungsKopfTyp INT |
||
| DocDate | BelegDatum Datetime |
||
| Period | Periode INT Index |
MARIPeriods.Period | |
| EmployeeNumber | Personalnummer NVARCHAR (20) Index |
MARIEmployeeMaster.EmployeeNumber | |
| TravelTemplateVersion | ReiseTemplateVersion INT |
||
| Valid | Gueltig SMALLINT |
||
| Posted | Gebucht SMALLINT |
||
| PostedAt | GebuchtAm Datetime |
||
| PostedUser | GebuchtID NVARCHAR (10) Index |
||
| Creditor | Kreditor NVARCHAR (20) |
OCRD.CardCode | |
| CreditCardCreditor | KreditorKreditkarte NVARCHAR (20) |
OCRD.CardCode | |
| Company | Mandant SMALLINT |
Company | MARISysConnections.Company (WHERE ConnectionType=6) |
| OpenItemNumber | OPNr NVARCHAR (20) |
||
| TripInfo | ReiseInfo NTEXT |
||
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Inactive | InAktiv SMALLINT Index |
Hide dataset | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARITravelPostingDocument | Travel Expenses Module: Posting document |
| MARITravelTripLine | Travel Expenses Module: Trip receipt line |