Menu Close

FACT_FINANCIALTRANSACTIONLINEITEM

 

ColumnComments
FINANCIALTRANSACTIONLINEITEMFACTID
FINANCIALTRANSACTIONLINEITEMSYSTEMID
FINANCIALTRANSACTIONFACTID
FINANCIALTRANSACTIONSYSTEMID
FINANCIALTRANSACTIONSEQUENCEID
FINANCIALTRANSACTIONLOOKUPID
REVENUECODEDIMID
REVENUEFLAGDIMID
REVENUECHANNELDIMID
FINANCIALTRANSACTIONDATEDIMID
FINANCIALTRANSACTIONDATE
FINANCIALTRANSACTIONPOSTDATEDIMID
FINANCIALTRANSACTIONPOSTDATE
CONSTITUENTDIMID
CONSTITUENTSYSTEMID
APPEALDIMID
MARKETINGSEGMENTDIMID
MARKETINGSOURCECODEDIMID
MARKETINGCONSTITUENTFACTID
FINANCIALTRANSACTIONAMOUNT
FINANCIALTRANSACTIONRECEIPTAMOUNTNote that Atlas calculates the receipt amount at the revenue level, NOT the revenue split level. This is the receipt amount for the whole transaction.
BASECURRENCYDIMID
FINANCIALTRANSACTIONBASEAMOUNT
FINANCIALTRANSACTIONDATETIMEOFFSET
ACCOUNTSYSTEMDIMID
APPUSERDIMID
CHECKNUMBER
CREDITCARDTYPEDIMID
CHECKFUZZYDATE
GLREVENUECATEGORYDIMID
FINANCIALTRANSACTIONLINEITEMPOSTDATEDIMID
FINANCIALTRANSACTIONLINEITEMPOSTDATE
DESIGNATIONDIMID
PURPOSELEVEL1DIMID
PURPOSELEVEL2DIMID
PURPOSELEVEL3DIMID
PURPOSELEVEL4DIMID
PURPOSELEVEL5DIMID
EVENTREGISTRANTFACTID
FINANCIALTRANSACTIONLINEITEMAMOUNT
FINANCIALTRANSACTIONLINEITEMBASEAMOUNT
CHANGEDDATEDIMID
CHANGEDDATE
ISINCLUDED
SOURCEDIMID
ETLCONTROLID
BATCHNUMBER
SOURCELINEITEMFACTID
FINANCIALTRANSACTIONLINEITEMADJUSTMENTSYSTEMID
ADJUSTMENTCONSTITUENTDIMID
ADJUSTMENTDATEDIMID
ADJUSTMENTDATE
ADJUSTMENTREASONDIMID
TRANSACTIONBALANCE
LINEITEMBALANCE
TRANSACTIONCURRENCYDIMID
MARKETINGSEGMENTATIONDIMID
FINANCIALTRANSACTIONLINEITEMTRANSACTIONAMOUNT
REVENUESCHEDULEDIMID
ADDEDDATE
ADDEDDATEDIMID
OTHERPAYMENTMETHODDIMID
PLANNEDGIFTDIMID
REVERSEDFINANCIALTRANSACTIONLINEITEMSYSTEMID
REVERSEDFINANCIALTRANSACTIONLINEITEMFACTID
OTHERREVENUETYPEDIMID

Leave a Reply