性能价格比最好的手机服务 3 months of 5GB 4G LTE a month and unlimited talk and text for only $20 bucks.
您还在为孩子留学美国而烦恼吗?快找德美留学!不用考托福和SAT,成绩优异者保证进美国名校;英语不达标的,进优质大学。1对1,精准投,超常规,不录取不收费! 网址:www.demei.info

Author Topic: 求助:有accouting 或者financial background 的同学,能不能给几个财务方面常见的的report的例子  (Read 21987 times)

weiweikunlun

  • Core Package
  • Jr. Member
  • *
  • Posts: 56
  • Karma: +0/-0
求助,如题,能不能给几个常见的financial report的column, filter 和 parameter? 今天面试,人家说想找financial background的人,谢了!老师说让我看AP database, 我也看了,受益匪浅,但我也希望大家能给我给我点例子,谢谢!

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4063
  • Karma: +35/-11
Google: sample financial report
You will get many of them.

weiweikunlun

  • Core Package
  • Jr. Member
  • *
  • Posts: 56
  • Karma: +0/-0

如月

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1721
  • Karma: +17/-2
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'

qinglian

  • Core Package
  • Newbie
  • *
  • Posts: 26
  • Karma: +0/-0
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
...

weiweikunlun

  • Core Package
  • Jr. Member
  • *
  • Posts: 56
  • Karma: +0/-0