AP_WHT_ITF
This is an interface table that stores all the records for the submission of the AP Withholding Tax extract program for the AP Withholding Tax Report functionality. AP_WHT_ITF is a denormalized table used for storing the Organization Name and Address, Supplier and Supplier site identifications, Invoice information and invoice distributions for withholding tax. Each row in this table corresponds to an invoice distribution for withholding tax matching the user parameters specified while running the AP Withholding Tax Extract program. This information can then be published by using RXi or standard reports.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: SUMMARY
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| ORGANIZATION_NAME | VARCHAR2 | 240 | Yes | Name of the organization for which you want to create a withholding tax report to comply with the internal needs of your company. | |
| FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Functional currency code of the invoice. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| ADDRESS_LINE1 | VARCHAR2 | 240 | First address line for the organization. | ||
| ADDRESS_LINE2 | VARCHAR2 | 240 | Second address line for the organization. | ||
| ADDRESS_LINE3 | VARCHAR2 | 240 | Third address line for the organization. | ||
| CITY | VARCHAR2 | 60 | City name for the organization. | ||
| ZIP | VARCHAR2 | 60 | Postal code for the organization. | ||
| PROVINCE | VARCHAR2 | 150 | Province name for the organization. | ||
| STATE | VARCHAR2 | 150 | State name for the organization. | ||
| COUNTRY | VARCHAR2 | 60 | Country name for the organization. | ||
| TAX_AUTHORITY | VARCHAR2 | 80 | Yes | Name of the financial authority to which the withholding amount is paid. | |
| SUPPLIER_TYPE | VARCHAR2 | 25 | Supplier type that you want to report on. | ||
| SUPPLIER_NAME | VARCHAR2 | 240 | Yes | Supplier name from supplier tables related to the invoice. | |
| TAXPAYER_ID | VARCHAR2 | 30 | Supplier tax identification number related to the invoice. | ||
| SUPPLIER_NUMBER | VARCHAR2 | 30 | Yes | Supplier number from supplier tables related to the invoice. | |
| SUPPLIER_SITE_CODE | VARCHAR2 | 15 | Yes | Supplier site code from supplier tables related to the invoice. | |
| VAT_REGISTRATION_NUMBER | VARCHAR2 | 20 | Supplier's VAT Registration Number | ||
| SUPPLIER_ADDRESS_LINE1 | VARCHAR2 | 240 | First line address on the supplier invoice. | ||
| SUPPLIER_ADDRESS_LINE2 | VARCHAR2 | 240 | Second line address on the supplier invoice. | ||
| SUPPLIER_ADDRESS_LINE3 | VARCHAR2 | 240 | Third line address on the supplier invoice. | ||
| SUPPLIER_CITY | VARCHAR2 | 60 | Name of the city on the supplier invoice. | ||
| SUPPLIER_STATE | VARCHAR2 | 150 | Name of the state on the supplier invoice. | ||
| SUPPLIER_ZIP | VARCHAR2 | 60 | Postal code on the supplier invoice. | ||
| SUPPLIER_PROVINCE | VARCHAR2 | 150 | Name of the province on the supplier invoice. | ||
| SUPPLIER_COUNTRY | VARCHAR2 | 60 | Name of the country on the supplier invoice. | ||
| INVOICE_NUM | VARCHAR2 | 50 | Yes | Invoice number that appears in the invoice tables. | |
| INVOICE_AMOUNT | NUMBER | Yes | Invoice amount in transaction currency. | ||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Transaction currency code used on the invoice. | |
| INVOICE_DATE | DATE | Yes | Invoice date that appears in the invoice tables. | ||
| INV_GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| INV_GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| INV_GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| INV_GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| INV_GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| INV_GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| INV_GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| INV_GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| INV_GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| INV_GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| INV_GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| INV_GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| INV_GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| INV_GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| INV_GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| INV_GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| INV_GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| INV_GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| INV_GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| INV_GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| PV_GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| PV_GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| PV_GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| PV_GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| PV_GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| PV_GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| PV_GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| PV_GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| PV_GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| PV_GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| PV_GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| PV_GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| PV_GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| PV_GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| PV_GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| PV_GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| PV_GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| PV_GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| PV_GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| PV_GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| AWT_CODE | VARCHAR2 | 15 | Yes | Withholding tax code on the invoice. | |
| AWT_RATE | NUMBER | Yes | Withholding tax rate on the invoice. | ||
| AWT_AMOUNT | NUMBER | Yes | Amount withheld from the invoice. | ||
| AWT_BASE_AMOUNT | NUMBER | Yes | The amount of the withholding in functional currency for the ledger. | ||
| AWT_GROUP_NAME | VARCHAR2 | 25 | Name of the withholding tax group with which the withholding tax code is associated. | ||
| AWT_GL_DATE | DATE | Yes | Accounting date of the withholding. | ||
| AWT_GROSS_AMOUNT | NUMBER | Amount subject to withholding tax | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |