自2006年至今, 帮全球无数人能做会说高薪转行做数据, 进大公司! inquiries@usalaotu.com 650-648-3646
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
Home
首页
首页 Home page
学生登录 Student login
注册新课 Register course
联系我们 Contact us
注册新课
Help
Calendar
Login
Register
USA LaoTu 高薪转行做数据第一平台
»
名校名师出高徒,师资强,同学多,热气高,点子好,经验多,出实招,透实底,多干货,求职快!
»
财务转行美国找工作高薪数据分析师 Database Analyst
»
求助:有accouting 或者financial background 的同学,能不能给几个财务方面常见的的report的例子
好用的手机公司, 新年大促销: 3 month FREE! $15/Month 5GB data and text
« previous
next »
Print
Pages: [
1
]
Author
Topic: 求助:有accouting 或者financial background 的同学,能不能给几个财务方面常见的的report的例子 (Read 51140 times)
weiweikunlun
Core Package
Jr. Member
Posts: 56
Karma: +0/-0
求助:有accouting 或者financial background 的同学,能不能给几个财务方面常见的的report的例子
«
on:
October 13, 2015, 04:48:55 PM »
求助,如题,能不能给几个常见的financial report的column, filter 和 parameter? 今天面试,人家说想找financial background的人,谢了!老师说让我看AP database, 我也看了,受益匪浅,但我也希望大家能给我给我点例子,谢谢!
Logged
USA LaoTu Support Team
Administrator
Hero Member
Posts: 4810
Karma: +35/-11
Re: 求助:有accouting 或者financial background 的同学,能不能给几个财务方面常见的的report的例子
«
Reply #1 on:
October 13, 2015, 08:19:06 PM »
Google: sample financial report
You will get many of them.
Logged
weiweikunlun
Core Package
Jr. Member
Posts: 56
Karma: +0/-0
Re: 求助:有accouting 或者financial background 的同学,能不能给几个财务方面常见的的report的例子
«
Reply #2 on:
October 13, 2015, 09:29:09 PM »
Yes, I will do that. Thanks
Logged
如月
Core Package
Hero Member
Posts: 1742
Karma: +17/-2
Re: 求助:有accouting 或者financial background 的同学,能不能给几个财务方面常见的的report的例子
«
Reply #3 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'
Logged
qinglian
Core Package
Newbie
Posts: 26
Karma: +0/-0
Re: 求助:有accouting 或者financial background 的同学,能不能给几个财务方面常见的的report的例子
«
Reply #4 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
...
Logged
weiweikunlun
Core Package
Jr. Member
Posts: 56
Karma: +0/-0
Re: 求助:有accouting 或者financial background 的同学,能不能给几个财务方面常见的的report的例子
«
Reply #5 on:
October 15, 2015, 08:00:38 PM »
谢谢大家了!!!
Logged
Print
Pages: [
1
]
« previous
next »
USA LaoTu 高薪转行做数据第一平台
»
名校名师出高徒,师资强,同学多,热气高,点子好,经验多,出实招,透实底,多干货,求职快!
»
财务转行美国找工作高薪数据分析师 Database Analyst
»
求助:有accouting 或者financial background 的同学,能不能给几个财务方面常见的的report的例子