Posted on June 18th, 2010 by Sanjit Anand |
Print This Post
|
Email This Post
| Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today |
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
- AWT_GROUP_ID
- AP_EXPENSE_REPORT_LINES_ALL
- AWT_GROUP_ID
Hope this helps.
Related Posts