| Schema help - AP module [message #127009] |
Thu, 07 July 2005 18:23  |
rboarman
Messages: 1
Registered: July 2005
|
Junior Member |
|
|
Hello,
I’m hoping for some schema help with our Oracle Financials AP module. Specifically, we’re trying to extract information out about invoices, expense accounts and vendors.
For example, we have an account 5150 which is Travel Expenses. From the INVOICES_ALL table, how do I determine the account and the name of the account? The CODE_COMBINATIONS table seems like the place to start but I don’t see any account names.
Can anyone point me to some documentation?
Thank you in advance,
Rick
|
|
|
|
| Re: Schema help - AP module [message #127038 is a reply to message #127009] |
Fri, 08 July 2005 03:03  |
adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway
|
Senior Member |
|
|
Go to Top Tech Docs on Metalink. There you will find the ETRM (Electronic Technical Reference Manual). Among other things it has a complete description of all tables in the E-Business Suite with description of their columns.
As to your problem you can find what column correspond to what segment in the account code combination by looking in the FND_ID_FLEXS, FND_ID_FLEX_STRUCTURES and FND_ID_FLEX_SEGMENTS tables.
--
Aleksander Dragnes
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
