Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 01 Jun 2001 @ 15:29:58 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Transaction Debits and Credits
From:   Ronan McGuirk

Hi Folks,

This query concerns the representation of debit and credit financial transactions in a Data Warehouse table.

We're designing a single transaction table into which we will load financial transactions from multiple operational sources.

Each transaction row will include a Transaction_Type and Transaction_Amount column.

Some sources distinguish between credits and debits by the sign in Transaction Amount data (ie. credits are positive values, debits are negative values).

Other sources distinguish between credits and debits by ranges of codes in the Transaction Type data (eg.'2201' = deposit account credit, '8801' = deposit account debit) and hold only positive values in Transaction Amount data.

We want to choose one or other approach to implement in our Data Warehouse table.

From your experience, which do you consider to be best practice for identifying debit and credit transactions - (a) positive/negative sign on amounts or (b) separate type code??

Any suggestions gratefully received!


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020