USA LaoTu 高薪转行做数据第一平台

名校名师出高徒，师资强，同学多，热气高，点子好，经验多，出实招，透实底，多干货，求职快！ => 财务转行美国找工作高薪数据分析师 Database Analyst => Topic started by: weiweikunlun on October 13, 2015, 04:48:55 PM

Title: 求助：有accouting 或者financial background 的同学，能不能给几个财务方面常见的的report的例子
Post by: weiweikunlun on October 13, 2015, 04:48:55 PM

求助，如题，能不能给几个常见的financial report的column, filter 和 parameter? 今天面试，人家说想找financial background的人，谢了！老师说让我看AP database, 我也看了，受益匪浅，但我也希望大家能给我给我点例子，谢谢！

Title: Re: 求助：有accouting 或者financial background 的同学，能不能给几个财务方面常见的的report的例子
Post by: USA LaoTu Support Team on October 13, 2015, 08:19:06 PM

Google: sample financial report
You will get many of them.

Title: Re: 求助：有accouting 或者financial background 的同学，能不能给几个财务方面常见的的report的例子
Post by: weiweikunlun on October 13, 2015, 09:29:09 PM

Yes, I will do that. Thanks

Title: Re: 求助：有accouting 或者financial background 的同学，能不能给几个财务方面常见的的report的例子
Post by: 如月 on October 14, 2015, 07:40:52 AM

For GLTrialBalance (GeneralLedger)

Tables and Columns:
Period :
  Period
  PeriodDescription
  ShortDescription
  PeriodEndDate
  Year
  Month

Legal Entity:
   LegalEntity
  LegalEntityDescription
  LegalEntityShortDescription 
  ExtendedTaxName
  LegalEntityType
  LegalEntityTypeDescription
  RecordBeginDate
  RecordEndDate

Child Legal Entity
Account
     Account
    AccountDescription
    AccountShortDescription
    AccountEffectiveStatus 
    AccountEffectiveDate 
    ZEnterableFlag
    AccountType
    StatisticsAccount
Market
    Market
   MarketDescription
   MarketShortDescription
   MarketEffectiveDate
   MarketEffectiveStatus
   MarketEnterableFlag
   MarketRollupBeginDate
   MarketRollupEndDate

Cost Center
Location
Business Unit
Trail Balance   
    DataSource
          PostedTotalAmt
 

Parameters:


WHERE
   (SOURCE_SYSTEM = ' ' OR SOURCE_SYSTEM IS NULL)
   AND 
   TTB.PERIOD_ID  = 201212
   AND
   LER.ROLLUP_NAME  = 'Legal Entity'
   AND
   LE.LEGAL_ENTITY_ID  ='10001' ---legal entity
   AND
   GA.ACCOUNT  ='110001'

Title: Re: 求助：有accouting 或者financial background 的同学，能不能给几个财务方面常见的的report的例子
Post by: qinglian on October 14, 2015, 03:28:51 PM

Well put RuYue. let me add something regarding transaction related table:

columns:
TransactionID
UserID
CancelTime
ChargeOrCredit
Amount
Balance
BilledOrPaidDate
DueDate
RateCode
ComCode
JurisCode
Note
CostcenterCode
InvoiceID
InvoiceDate
AccountID
...

Title: Re: 求助：有accouting 或者financial background 的同学，能不能给几个财务方面常见的的report的例子
Post by: weiweikunlun on October 15, 2015, 08:00:38 PM

谢谢大家了！！！