Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

No items, feed is empty.

WHT Technical Brief

Posted on June 18th, 2010 by Sanjit Anand |Print This Post Print This Post |Email 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

Posted in Oracle Payable | No Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.