好用的手机公司, 新年大促销: 3 month FREE! $15/Month 5GB data and text

Author Topic: 求助:有accouting 或者financial background 的同学,能不能给几个财务方面常见的的report的例子  (Read 50790 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: 4803
  • Karma: +35/-11
Google: sample financial report
You will get many of them.

weiweikunlun

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

如月

  • Core Package
  • Hero Member
  • *
  • Posts: 1742
  • 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