AP_Invoice_Distributions_all and Expense Reports [message #190976] |
Sun, 03 September 2006 14:54 |
smulukutla
Messages: 45 Registered: May 2006
|
Member |
|
|
Our client is asking how the attribute columns in at_invoice_distributions populated? I know that they are used to capture the additional information for descriptive flexfield but our client is asking attribute1 column refers to what? What they are being used for? Is it defining the plant location or xyz etc. Any input on how to find this is appreciated.
Also Our Client want to know all the Expense Reports paid for the empolyees in 2006. I looked into the tables WF_NOTIFICATIONS, WF_ITEM_ACTIVITY_STATUSES, WF_ITEMS. They give the statuses of the Expense report but Are there any other tables which gives the $Amount paid information to the employees?
Thanks.
|
|
|
|
Re: AP_Invoice_Distributions_all and Expense Reports [message #191169 is a reply to message #190976] |
Tue, 05 September 2006 01:52 |
vin_odks
Messages: 153 Registered: July 2006 Location: -
|
Senior Member |
|
|
hi,
To add to
The link between Descriptive flexfield and the attribute column depends on its usage . It is left to the user to decide which attribute column should be used to store the values for the segment.
For more info refer to the Flexfield guide.
Regards
Vinod
|
|
|