Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Financial Analytics > Extract, Transform, and Load for SAP R/3 >

Siebel General Ledger Analytics Information for Nonsales Transactions for SAP R/3

Loading transaction information other than sales is handled in the same fashion as sales order lines and invoice lines data. All the transactions from TS_STAGE_GL that do not exist in TS_STAGE_IV_HDR are selected. Also the tables TS_STAGE_IV_HDR, TS_STAGE_SO_HDR, and TS_STAGE_GL join to get the keys, split the transactions and set the Balance ID. In addition, a lookup is performed on the TS_STAGE_FIN_STMT staging table. Data then loads into the six staging areas.