Created
August 19, 2013 22:34
-
-
Save pixlkid/6275010 to your computer and use it in GitHub Desktop.
Sample GP object using entity framework code first approach
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
using System; | |
using System.Collections.Generic; | |
using System.Linq; | |
using System.Text; | |
using System.ComponentModel.DataAnnotations; | |
using System.ComponentModel.DataAnnotations.Schema; | |
namespace GPDb | |
{ | |
/// <summary> | |
/// Year-to-Date Transaction Open - Financial | |
/// </summary> | |
[Table("GL20000")] | |
public class GL20000 | |
{ | |
[Key] | |
[Column("DEX_ROW_ID")] | |
public int DexRowId { get; set; } | |
[Column("OPENYEAR")] | |
public short OpenYear { get; set; } | |
[Column("JRNENTRY")] | |
public int JournalEntry { get; set; } | |
[Column("RCTRXSEQ")] | |
public decimal RecurringTRXSequence { get; set; } | |
[Column("SOURCDOC")] | |
public string SourceDocument { get; set; } | |
[Column("REFRENCE")] | |
public string Reference { get; set; } | |
[Column("DSCRIPTN")] | |
public string Description { get; set; } | |
[Column("TRXDATE")] | |
public DateTime TRXDate { get; set; } | |
[Column("TRXSORCE")] | |
public string TRXSource { get; set; } | |
[Column("ACTINDX")] | |
public int AccountIndex { get; set; } | |
[Column("POLLDTRX")] | |
public byte PolledTransaction { get; set; } | |
[Column("LASTUSER")] | |
public string LastUser { get; set; } | |
[Column("LSTDTEDT")] | |
public DateTime LastDateEdited { get; set; } | |
[Column("USWHPSTD")] | |
public string UserWhoPosted { get; set; } | |
[Column("ORGNTSRC")] | |
public string OriginatingSource { get; set; } | |
[Column("ORGNATYP")] | |
public short OriginatingType { get; set; } | |
[Column("QKOFSET")] | |
public short QuickOffset { get; set; } | |
[Column("SERIES")] | |
public short Series { get; set; } | |
[Column("ORTRXTYP")] | |
public short OriginatingTRXType { get; set; } | |
[Column("ORCTRNUM")] | |
public string OriginatingControlNumber { get; set; } | |
[Column("ORMSTRID")] | |
public string OriginatingMasterID { get; set; } | |
[Column("ORMSTRNM")] | |
public string OriginatingMasterName { get; set; } | |
[Column("ORDOCNUM")] | |
public string OriginatingDocumentNumber { get; set; } | |
[Column("ORPSTDDT")] | |
public DateTime OriginatingPostedDate { get; set; } | |
[Column("ORTRXSRC")] | |
public string OriginatingTRXSource { get; set; } | |
[Column("OrigDTASeries")] | |
public short OriginatingDTASeries { get; set; } | |
[Column("OrigSeqNum")] | |
public int OriginatingSequenceNumber { get; set; } | |
[Column("SEQNUMBR")] | |
public int SequenceNumber { get; set; } | |
[Column("DTA_GL_Status")] | |
public short DTAGLStatus { get; set; } | |
[Column("DTA_Index")] | |
public decimal DTAIndex { get; set; } | |
[Column("CURNCYID")] | |
public string CurrencyID { get; set; } | |
[Column("CURRNIDX")] | |
public short CurrencyIndex { get; set; } | |
[Column("RATETPID")] | |
public string RateTypeID { get; set; } | |
[Column("EXGTBLID")] | |
public string ExchangeTableID { get; set; } | |
[Column("XCHGRATE")] | |
public decimal ExchangeRate { get; set; } | |
[Column("EXCHDATE")] | |
public DateTime ExchangeDate { get; set; } | |
[Column("TIME1")] | |
public DateTime Time { get; set; } | |
[Column("RTCLCMTD")] | |
public short RateCalculationMethod { get; set; } | |
[Column("NOTEINDX")] | |
public decimal NoteIndex { get; set; } | |
[Column("ICTRX")] | |
public byte ICTRX { get; set; } | |
[Column("ORCOMID")] | |
public string OriginatingCompanyID { get; set; } | |
[Column("ORIGINJE")] | |
public int OriginatingJournalEntry { get; set; } | |
[Column("PERIODID")] | |
public short PeriodID { get; set; } | |
[Column("CRDTAMNT")] | |
public decimal CreditAmount { get; set; } | |
[Column("DEBITAMT")] | |
public decimal DebitAmount { get; set; } | |
[Column("ORCRDAMT")] | |
public decimal OriginatingCreditAmount { get; set; } | |
[Column("ORDBTAMT")] | |
public decimal OriginatingDebitAmount { get; set; } | |
[Column("DOCDATE")] | |
public DateTime DocumentDate { get; set; } | |
[Column("PSTGNMBR")] | |
public int PostingNumber { get; set; } | |
[Column("PPSGNMBR")] | |
public int PeriodPostingNumber { get; set; } | |
[Column("DENXRATE")] | |
public decimal DenominationExchangeRate { get; set; } | |
[Column("MCTRXSTT")] | |
public short MCTransactionState { get; set; } | |
[Column("CorrespondingUnit")] | |
public string CorrespondingUnit { get; set; } | |
[Column("VOIDED")] | |
public byte Voided { get; set; } | |
[Column("Back_Out_JE")] | |
public int BackOutJE { get; set; } | |
[Column("Back_Out_JE_Year")] | |
public short BackOutJEYear { get; set; } | |
[Column("Correcting_JE")] | |
public int CorrectingJE { get; set; } | |
[Column("Correcting_JE_Year")] | |
public short CorrectingJEYear { get; set; } | |
[Column("Original_JE")] | |
public int OriginalJE { get; set; } | |
[Column("Original_JE_Seq_Num")] | |
public decimal OriginalJESeqNum { get; set; } | |
[Column("Original_JE_Year")] | |
public short OriginalJEYear { get; set; } | |
[Column("Ledger_ID")] | |
public short LedgerID { get; set; } | |
[Column("Adjustment_Transaction")] | |
public byte AdjustmentTransaction { get; set; } | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment