Search Results ar invoice amount

The IGI_CIS_PAYMENT_VOUCHERS_ALL table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical repository for storing Construction Industry Scheme (CIS) payment voucher records. CIS is a UK tax mechanism requiring contractors to deduct tax from subcontractor payments, and this table facilitates compliance by capturing payment voucher details. Below is a detailed breakdown of its structure, purpose, and integration within Oracle EBS.

Purpose and Functional Context

The table is part of Oracle's Payables module, specifically designed to manage CIS-related transactions. It stores payment vouchers generated for subcontractor payments, ensuring proper tax deductions and reporting per UK regulations. Key functionalities include:

Tracking gross payment amounts, tax deductions, and net payments to subcontractors.
Linking vouchers to invoices, contractors, and subcontractors for audit trails.
Supporting CIS reporting (e.g., monthly returns to HMRC).

Key Columns and Relationships

The table's structure includes columns to manage voucher metadata, financial data, and CIS-specific attributes:

Primary Key: PAYMENT_VOUCHER_ID uniquely identifies each voucher.
Foreign Keys: Columns like INVOICE_ID (links to AP_INVOICES_ALL) and VENDOR_ID (links to PO_VENDORS) integrate with Payables and Suppliers.
CIS Attributes: TAX_DEDUCTION_RATE, NET_PAYMENT_AMOUNT, and STATUS_FLAG (e.g., 'Pending', 'Processed').
Audit Columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE track changes.

Integration with Oracle EBS Modules

The table interacts with:

Oracle Payables: Vouchers reference invoices (AP_INVOICES_ALL) and payments (AP_PAYMENT_SCHEDULES_ALL).
Oracle General Ledger: Posting voucher data to GL via AP_ACCOUNTING_EVENTS_ALL.
CIS Reports: Data feeds into statutory reports like CIS300 (monthly returns).

Technical Considerations

Multi-Org Support: The _ALL suffix indicates multi-org visibility, with ORG_ID segregating data by operating unit.
Indexing: Indexes on PAYMENT_VOUCHER_ID, INVOICE_ID, and STATUS_FLAG optimize query performance.
Custom Extensions: Customers may extend the table with custom columns for additional CIS requirements.

Data Flow Example

A subcontractor invoice is entered in Payables.
The CIS engine creates a voucher in IGI_CIS_PAYMENT_VOUCHERS_ALL, calculating tax deductions.
Upon payment, the voucher status updates to 'Processed', and GL entries are generated.
CIS reports extract data from this table for HMRC submissions.

Compliance and Best Practices

Data Integrity: Ensure mandatory columns (e.g., SUBCONTRACTOR_ID) are populated.
Archiving: Archive historical vouchers to maintain performance.
Security: Restrict access via Oracle's Data Access Layer (DAL) or VPD policies.

Conclusion

The IGI_CIS_PAYMENT_VOUCHERS_ALL table is a cornerstone of CIS compliance in Oracle EBS, enabling accurate tax deductions, payment tracking, and reporting. Its integration with Payables and GL ensures seamless financial operations while adhering to UK tax laws. Proper configuration and maintenance of this table are essential for organizations leveraging Oracle EBS in the construction sector.

Lookup Type: INVOICE TYPE 12.1.1
product: IGI - Public Sector Financials International , meaning: Invoice Type , description: Invoice Type ,
Lookup Type: INVOICE TYPE 12.2.2
product: IGI - Public Sector Financials International , meaning: Invoice Type , description: Invoice Type ,
Lookup Type: IGI_EXP_AR_TRAN_TYPES 12.1.1
product: IGI - Public Sector Financials International , meaning: Exchange Protocol AR Transaction Types , description: Exchange Protocol AR Transaction Types ,
Lookup Type: IGI_EXP_AR_TRAN_TYPES 12.2.2
product: IGI - Public Sector Financials International , meaning: Exchange Protocol AR Transaction Types , description: Exchange Protocol AR Transaction Types ,
View: IGI_STP_PACKAGES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGI.IGI_STP_PACKAGES_V, object_name:IGI_STP_PACKAGES_V, status:VALID, product: IGI - Public Sector Financials International , description: View which displays information on Single Third Party netting transactions batch. , implementation_dba_data: APPS.IGI_STP_PACKAGES_V ,
View: IGI_STP_PACKAGES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:IGI.IGI_STP_PACKAGES_V, object_name:IGI_STP_PACKAGES_V, status:VALID, product: IGI - Public Sector Financials International , description: View which displays information on Single Third Party netting transactions batch. , implementation_dba_data: APPS.IGI_STP_PACKAGES_V ,
View: IGI_CBR_AP_INV_DIST_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGI.IGI_CBR_AP_INV_DIST_V, object_name:IGI_CBR_AP_INV_DIST_V, status:VALID, product: IGI - Public Sector Financials International , description: This view returns all the invoice distributions that have been posted , implementation_dba_data: APPS.IGI_CBR_AP_INV_DIST_V ,
View: IGI_CBR_AP_INV_DIST_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:IGI.IGI_CBR_AP_INV_DIST_V, object_name:IGI_CBR_AP_INV_DIST_V, status:VALID, product: IGI - Public Sector Financials International , description: This view returns all the invoice distributions that have been posted , implementation_dba_data: APPS.IGI_CBR_AP_INV_DIST_V ,
View: IGI_RPI_INVOICE_HISTORY_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGI.IGI_RPI_INVOICE_HISTORY_V, object_name:IGI_RPI_INVOICE_HISTORY_V, status:VALID, product: IGI - Public Sector Financials International , description: Contains invoice history informaion for a single standing charge , implementation_dba_data: APPS.IGI_RPI_INVOICE_HISTORY_V ,
View: IGI_RPI_INVOICE_HISTORY_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:IGI.IGI_RPI_INVOICE_HISTORY_V, object_name:IGI_RPI_INVOICE_HISTORY_V, status:VALID, product: IGI - Public Sector Financials International , description: Contains invoice history informaion for a single standing charge , implementation_dba_data: APPS.IGI_RPI_INVOICE_HISTORY_V ,
View: IGI_STP_AR_BAL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGI.IGI_STP_AR_BAL, object_name:IGI_STP_AR_BAL, status:VALID, product: IGI - Public Sector Financials International , description: Displays all Receivables transactions available for Single Third Party netting. , implementation_dba_data: APPS.IGI_STP_AR_BAL ,
View: IGI_STP_AR_BAL 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:IGI.IGI_STP_AR_BAL, object_name:IGI_STP_AR_BAL, status:VALID, product: IGI - Public Sector Financials International , description: Displays all Receivables transactions available for Single Third Party netting. , implementation_dba_data: APPS.IGI_STP_AR_BAL ,
View: IGI_MPP_AP_DIST_MERGE_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:IGI.IGI_MPP_AP_DIST_MERGE_V, object_name:IGI_MPP_AP_DIST_MERGE_V, status:VALID, product: IGI - Public Sector Financials International , description: Contains information for both Core and OPSFI Invoice Distributions forms , implementation_dba_data: APPS.IGI_MPP_AP_DIST_MERGE_V ,
View: IGI_MPP_AP_DIST_MERGE_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGI.IGI_MPP_AP_DIST_MERGE_V, object_name:IGI_MPP_AP_DIST_MERGE_V, status:VALID, product: IGI - Public Sector Financials International , description: Contains information for both Core and OPSFI Invoice Distributions forms , implementation_dba_data: APPS.IGI_MPP_AP_DIST_MERGE_V ,
View: IGI_CIS_INVOICE_PAYMENTS 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:IGI.IGI_CIS_INVOICE_PAYMENTS, object_name:IGI_CIS_INVOICE_PAYMENTS, status:VALID, product: IGI - Public Sector Financials International , description: Displays records of invoice payments coupled with CIS Payment Voucher details. , implementation_dba_data: APPS.IGI_CIS_INVOICE_PAYMENTS ,
View: IGI_CIS_INVOICE_PAYMENTS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGI.IGI_CIS_INVOICE_PAYMENTS, object_name:IGI_CIS_INVOICE_PAYMENTS, status:VALID, product: IGI - Public Sector Financials International , description: Displays records of invoice payments coupled with CIS Payment Voucher details. , implementation_dba_data: APPS.IGI_CIS_INVOICE_PAYMENTS ,
View: IGI_AP_INV_DISTRIBUTIONS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGI.IGI_AP_INV_DISTRIBUTIONS_V, object_name:IGI_AP_INV_DISTRIBUTIONS_V, status:VALID, product: IGI - Public Sector Financials International , description: Provides invoice distribution lines which fall within flexfield ranges assigned to department approvers. , implementation_dba_data: APPS.IGI_AP_INV_DISTRIBUTIONS_V ,
View: IGI_AP_INV_DISTRIBUTIONS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:IGI.IGI_AP_INV_DISTRIBUTIONS_V, object_name:IGI_AP_INV_DISTRIBUTIONS_V, status:VALID, product: IGI - Public Sector Financials International , description: Provides invoice distribution lines which fall within flexfield ranges assigned to department approvers. , implementation_dba_data: APPS.IGI_AP_INV_DISTRIBUTIONS_V ,
View: IGI_CIS_CERT_INV_PMT_VCH_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:IGI.IGI_CIS_CERT_INV_PMT_VCH_V, object_name:IGI_CIS_CERT_INV_PMT_VCH_V, status:VALID, product: IGI - Public Sector Financials International , description: Displays Invoice and Invoice Payment details along with associated CIS Withholding Tax Certificate details and CIS Payment Voucher details. , implementation_dba_data: APPS.IGI_CIS_CERT_INV_PMT_VCH_V ,
View: IGI_CIS_CERT_INV_PMT_VCH_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGI.IGI_CIS_CERT_INV_PMT_VCH_V, object_name:IGI_CIS_CERT_INV_PMT_VCH_V, status:VALID, product: IGI - Public Sector Financials International , description: Displays Invoice and Invoice Payment details along with associated CIS Withholding Tax Certificate details and CIS Payment Voucher details. , implementation_dba_data: APPS.IGI_CIS_CERT_INV_PMT_VCH_V ,
Concurrent Program: IGIRRPIV 12.2.2
execution_filename: IGIRRPIV , product: IGI - Public Sector Financials International , user_name: Standing Charges - Preliminary Invoice Report , description: Standing Charges - Preliminary Invoice Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: IGIPMSIT 12.1.1
execution_filename: IGIPMSDA.Synchronize_transfer , product: IGI - Public Sector Financials International , user_name: Multi Period Posting - Invoice Transfer , description: Multi Period Posting - Invoice Transfer , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: IGIPMSIT 12.2.2
execution_filename: IGIPMSDA.Synchronize_transfer , product: IGI - Public Sector Financials International , user_name: Multi Period Posting - Invoice Transfer , description: Multi Period Posting - Invoice Transfer , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: IGIRDNVR 12.1.1
execution_filename: IGIRDNVR , product: IGI - Public Sector Financials International , user_name: Dunning Letters - Dunning Invoice Charge Report , description: Dunning Letters - Dunning Invoice Charge Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: IGIRDNVR 12.2.2
execution_filename: IGIRDNVR , product: IGI - Public Sector Financials International , user_name: Dunning Letters - Dunning Invoice Charge Report , description: Dunning Letters - Dunning Invoice Charge Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: IGIRRPIV 12.1.1
execution_filename: IGIRRPIV , product: IGI - Public Sector Financials International , user_name: Standing Charges - Preliminary Invoice Report , description: Standing Charges - Preliminary Invoice Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: IGIPSAPR 12.1.1
execution_filename: IGIPSAPR , product: IGI - Public Sector Financials International , user_name: IGIPSAPR , description: Secondary Invoice Approval : Secondary Approval of Invoices , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: IGIPSAPR 12.2.2
execution_filename: IGIPSAPR , product: IGI - Public Sector Financials International , user_name: IGIPSAPR , description: Secondary Invoice Approval : Secondary Approval of Invoices , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: IGIPSIAP 12.1.1
execution_filename: IGIPSIAP , product: IGI - Public Sector Financials International , user_name: IGIPSIAP , description: Secondary Invoice Approval : Secondary Approval of Invoices , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: IGIPSIAP 12.2.2
execution_filename: IGIPSIAP , product: IGI - Public Sector Financials International , user_name: IGIPSIAP , description: Secondary Invoice Approval : Secondary Approval of Invoices , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: IGIRRPIV_XML 12.2.2
product: IGI - Public Sector Financials International , user_name: Standing Charges: Preliminary Invoice Register (XML) - Not Supported: Reserved For Future Use , description: Standing Charges: Preliminary Invoice Register , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Lookup Type: DUNNING_CHARGE_TYPE 12.1.1
product: IGI - Public Sector Financials International , meaning: Dunning Charge Type , description: Dunning Charge Type ,
Lookup Type: DUNNING_CHARGE_TYPE 12.2.2
product: IGI - Public Sector Financials International , meaning: Dunning Charge Type , description: Dunning Charge Type ,
Concurrent Program: IGIPSIAP_XML 12.1.1
product: IGI - Public Sector Financials International , user_name: Secondary Invoice Approval : Flexfield Assignments (XML) - Not Supported: Reserved For Future Use , description: Secondary Invoice Approval : Flexfield Assignments , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Concurrent Program: IGIPSIAP_XML 12.2.2
product: IGI - Public Sector Financials International , user_name: Secondary Invoice Approval : Flexfield Assignments (XML) - Not Supported: Reserved For Future Use , description: Secondary Invoice Approval : Flexfield Assignments , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Concurrent Program: IGIPSAPR_XML 12.1.1
product: IGI - Public Sector Financials International , user_name: Secondary Invoice Approval : Secondary Approval of Invoices (XML) , description: Secondary Invoice Approval : Secondary Approval of Invoices , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: IGIRRPIV_XML 12.1.1
product: IGI - Public Sector Financials International , user_name: Standing Charges: Preliminary Invoice Register (XML) , description: Standing Charges: Preliminary Invoice Register , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: IGIPSAPR_XML 12.2.2
product: IGI - Public Sector Financials International , user_name: Secondary Invoice Approval : Secondary Approval of Invoices (XML) - Not Supported: Reserved For Future Use , description: Secondary Invoice Approval : Secondary Approval of Invoices , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Concurrent Program: IGIRCABJP 12.2.2
execution_filename: IGIRCABJP.ReportCBR , product: IGI - Public Sector Financials International , user_name: Combined Basis Reports: AR Generate Data , description: Combined Basis Reports: AR Generate Data , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: IGIRCABJP 12.1.1
execution_filename: IGIRCABJP.ReportCBR , product: IGI - Public Sector Financials International , user_name: Combined Basis Reports: AR Generate Data , description: Combined Basis Reports: AR Generate Data , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Lookup Type: IGI_IAC_ADJUSTMENT_TYPES 12.2.2
product: IGI - Public Sector Financials International , meaning: IGI Inflation Accounting Adjustment Types , description: IGI Inflation Accounting Adjustment Types ,
Lookup Type: IGI_IAC_ADJUSTMENT_TYPES 12.1.1
product: IGI - Public Sector Financials International , meaning: IGI Inflation Accounting Adjustment Types , description: IGI Inflation Accounting Adjustment Types ,
Table: IGI_CIS_PAYMENT_VOUCHERS_ALL 12.2.2
owner:IGI, object_type:TABLE, fnd_design_data:IGI.IGI_CIS_PAYMENT_VOUCHERS_ALL, object_name:IGI_CIS_PAYMENT_VOUCHERS_ALL, status:VALID, product: IGI - Public Sector Financials International , description: Stores CIS Payment Voucher details for Invoice Payments , implementation_dba_data: IGI.IGI_CIS_PAYMENT_VOUCHERS_ALL ,
Table: IGI_INVOICE_DISTRIBUTIONS_ALL 12.1.1
owner:IGI, object_type:TABLE, fnd_design_data:IGI.IGI_INVOICE_DISTRIBUTIONS_ALL, object_name:IGI_INVOICE_DISTRIBUTIONS_ALL, status:VALID, product: IGI - Public Sector Financials International , description: Invoice distribution line information , implementation_dba_data: IGI.IGI_INVOICE_DISTRIBUTIONS_ALL ,
Table: IGI_INVOICE_DISTRIBUTIONS_ALL 12.2.2
owner:IGI, object_type:TABLE, fnd_design_data:IGI.IGI_INVOICE_DISTRIBUTIONS_ALL, object_name:IGI_INVOICE_DISTRIBUTIONS_ALL, status:VALID, product: IGI - Public Sector Financials International , description: Invoice distribution line information , implementation_dba_data: IGI.IGI_INVOICE_DISTRIBUTIONS_ALL ,
Table: IGI_SAP_GROUP_ALL 12.2.2
owner:IGI, object_type:TABLE, fnd_design_data:IGI.IGI_SAP_GROUP_ALL, object_name:IGI_SAP_GROUP_ALL, status:VALID, product: IGI - Public Sector Financials International , description: List of groups, secondary approvers and their associated invoice clerks. , implementation_dba_data: IGI.IGI_SAP_GROUP_ALL ,
Table: IGI_SAP_INVOICE_CLERK 12.1.1
owner:IGI, object_type:TABLE, fnd_design_data:IGI.IGI_SAP_INVOICE_CLERK, object_name:IGI_SAP_INVOICE_CLERK, status:VALID, product: IGI - Public Sector Financials International , description: List of invoice clerks assigned to secondary approvers. , implementation_dba_data: IGI.IGI_SAP_INVOICE_CLERK ,
Table: IGI_AR_CORR_PAY_SCHED_ALL 12.1.1
owner:IGI, object_type:TABLE, fnd_design_data:IGI.IGI_AR_CORR_PAY_SCHED_ALL, object_name:IGI_AR_CORR_PAY_SCHED_ALL, status:VALID, product: IGI - Public Sector Financials International , description: Invoice and correspondence information for invoices selected for dunning , implementation_dba_data: IGI.IGI_AR_CORR_PAY_SCHED_ALL ,
Table: IGI_AR_CORR_PAY_SCHED_ALL 12.2.2
owner:IGI, object_type:TABLE, fnd_design_data:IGI.IGI_AR_CORR_PAY_SCHED_ALL, object_name:IGI_AR_CORR_PAY_SCHED_ALL, status:VALID, product: IGI - Public Sector Financials International , description: Invoice and correspondence information for invoices selected for dunning , implementation_dba_data: IGI.IGI_AR_CORR_PAY_SCHED_ALL ,
Table: IGI_INSTALMENT_AUDIT_ALL 12.2.2
owner:IGI, object_type:TABLE, fnd_design_data:IGI.IGI_INSTALMENT_AUDIT_ALL, object_name:IGI_INSTALMENT_AUDIT_ALL, status:VALID, product: IGI - Public Sector Financials International , description: Records one record for each change made to the payment terms of an invoice , implementation_dba_data: IGI.IGI_INSTALMENT_AUDIT_ALL ,