RM10101

RM Distribution Work File - Sales

RM_Distribution_WORK

Physical Name Friendly Name Physical Type
TRXSORCE TRX Source char(13)
POSTED Posted tinyint
POSTEDDT Posted Date datetime
PSTGSTUS Posting Status smallint
CHANGED Changed tinyint
DOCNUMBR Document Number char(21)
DCSTATUS Document Status smallint
DISTTYPE Distribution Type smallint
RMDTYPAL RM Document Type-All smallint
SEQNUMBR Sequence Number int
CUSTNMBR Customer Number char(15)
DSTINDX Distribution Account Index int
DEBITAMT Debit Amount decimal(19,5)
CRDTAMNT Credit Amount decimal(19,5)
PROJCTID Project ID char(15)
USERID User ID char(15)
CATEGUSD Category Used smallint
CURNCYID Currency ID char(15)
CURRNIDX Currency Index smallint
ORCRDAMT Originating Credit Amount decimal(19,5)
ORDBTAMT Originating Debit Amount decimal(19,5)
DistRef Distribution Reference char(31)
/* Generated @ https://www.gptablereference.com/2010/Table/RM10101 on 4/16/2014 */
SELECT
CATEGUSD as [Category Used],
CHANGED as [Changed],
CRDTAMNT as [Credit Amount],
CURNCYID as [Currency ID],
CURRNIDX as [Currency Index],
CUSTNMBR as [Customer Number],
DCSTATUS as [Document Status],
DEBITAMT as [Debit Amount],
DistRef as [Distribution Reference],
DISTTYPE as [Distribution Type],
DOCNUMBR as [Document Number],
DSTINDX as [Distribution Account Index],
ORCRDAMT as [Originating Credit Amount],
ORDBTAMT as [Originating Debit Amount],
POSTED as [Posted],
POSTEDDT as [Posted Date],
PROJCTID as [Project ID],
PSTGSTUS as [Posting Status],
RMDTYPAL as [RM Document Type-All],
SEQNUMBR as [Sequence Number],
TRXSORCE as [TRX Source],
USERID as [User ID]
FROM RM10101
Uses System.ComponentModel.DataAnnotations;

/// <summary>
/// RM Distribution Work File
/// Generated @ https://www.gptablereference.com/2010/Table/RM10101 on 4/16/2014
/// </summary>

public class RM10101{
public int CategoryUsed{get;set;}
public bool Changed{get;set;}
public decimal CreditAmount{get;set;}
[StringLength(15)]
public string CurrencyID{get;set;}
public int CurrencyIndex{get;set;}
[StringLength(15)]
public string CustomerNumber{get;set;}
public int DocumentStatus{get;set;}
public decimal DebitAmount{get;set;}
[StringLength(30)]
public string DistributionReference{get;set;}
public int DistributionType{get;set;}
[StringLength(20)]
public string DocumentNumber{get;set;}
public Int64 DistributionAccountIndex{get;set;}
public decimal OriginatingCreditAmount{get;set;}
public decimal OriginatingDebitAmount{get;set;}
public bool Posted{get;set;}
public DateTime PostedDate{get;set;}
[StringLength(15)]
public string ProjectID{get;set;}
public int PostingStatus{get;set;}
public int RMDocumentType-All{get;set;}
public Int64 SequenceNumber{get;set;}
[StringLength(13)]
public string TRXSource{get;set;}
[StringLength(15)]
public string UserID{get;set;}
}
Other Receivables Open Transaction Files Tables