USA LaoTu 高薪转行做数据第一平台
名校名师出高徒,师资强,同学多,热气高,点子好,经验多,出实招,透实底,多干货,求职快! => 财务转行美国找工作高薪数据分析师 Database Analyst => Topic started by: weiweikunlun on October 13, 2015, 04:48:55 PM
-
求助,如题,能不能给几个常见的financial report的column, filter 和 parameter? 今天面试,人家说想找financial background的人,谢了!老师说让我看AP database, 我也看了,受益匪浅,但我也希望大家能给我给我点例子,谢谢!
-
Google: sample financial report
You will get many of them.
-
Yes, I will do that. Thanks
-
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'
-
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
...
-
谢谢大家了!!!