Posted on June 18th, 2010 by Sanjit Anand |
Print This Post
|
Email This Post
This post is more for BSA's , IT Analyst and developer for more technical insights.
WHT Codes and Groups
- AP_TAX_CODES_ALL - this Hold WHT code name and description
- AP_AWT_TAX_RATES_ALL- This hold WHT rate
- AP_AWT_GROUPS WHT - This hold group name and description
- AP_AWT_GROUP_TAXES_ALL WHT - This hold group associated with WHT code
Here are the details for WHT related columns in the important tables:
- AP_INVOICES_ALL
- AWT_FLAG
- AWT_GROUP_ID
- PAY_AWT_GROUP_ID
- AP_INVOICE_LINES_ALL
- LINE_TYPE_LOOKUP_CODE (=AWT)
- LINE_SOURCE (=AUTO WITHHOLDING)
- AWT_GROUP_ID
- PAY_AWT_GROUP_ID
- AP_INVOICE_DISTRIBUTIONS_ALL
- AWT_FLAG
- AWT_GROUP_ID
- AWT_TAX_RATE_ID
- AWT_GROSS_AMOUNT
- AWT_INVOICE_ID (invoice id of WHT invoice)
- AWT_ORIGIN_GROUP_ID
- AWT_INVOICE_PAYMENT_ID
- AWT_WITHHELD_AMT
- WITHHOLDING_TAX_CODE_ID
- AWT_RELATED_ID
- PAY_AWT_GROUP_ID
- AP_INVOICES_INTERFACE
- AWT_GROUP_ID
- AWT_GROUP_NAME
- PAY_AWT_GROUP_ID
- PAY_AWT_GROUP_NAME
- AP_INVOICE_LINES_INTERFACE
- AWT_GROUP_ID
- AWT_GROUP_NAME
- PAY_AWT_GROUP_ID
- PAY_AWT_GROUP_NAME
- AP_EXPENSE_REPORT_HEADERS_ALL
- AP_EXPENSE_REPORT_LINES_ALL
Hope this helps.
Posted in Oracle Payable | No Comments »
Posted on June 10th, 2010 by Sanjit Anand | Print This Post
| Email This Post
True, it has been a while since I have posted anything, mostly due to being too busy with work to consider posting. This might sound like a lame excuse- but then its unfortunately true. Of late, I have so many things- good band and ugly too- going on in my life leaving me busy ..super busy....
One of the good things has been noticing upon logging in, to see my blog crossing 2.18 millions page view, and that I have now up to 1427 subscribed users. Nice number- makes me feel really good. There are 571 comments pending for last 2 qtr to be cleared out. Recently upgraded to blogging software 2.9.2 from 2.3, which makes life somewhat easy.
Let’s see. Many other things happening around are keeping me on my toes. But it’s time I got some of my routines back. And hey, blogging used to be one of my routine activitiess. I read somewhere that for something to become an actual routine in your life you must do it regularly, methodically, religiously for 6 months and then it becomes a true blue routine in your life. Will start sharing some more things from new exposed area like salesForce.com, QlikView, Jira, DataHub etc. very soon.
Going forward, maybe I should contemplate making this site multilingual. What say?
Once again THANK YOU to everyone who visiting your site regularly.:)
Posted in Misc | 8 Comments »
