Skip to content

Instantly share code, notes, and snippets.

@pixlkid
Created August 19, 2013 22:34
Show Gist options
  • Save pixlkid/6275010 to your computer and use it in GitHub Desktop.
Save pixlkid/6275010 to your computer and use it in GitHub Desktop.
Sample GP object using entity framework code first approach
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