Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: AP.AP_INVOICES_ALL#

Object Details
Object Name: AP_INVOICES_ALL#
Object Type: VIEW
Owner: AP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INVOICE_ID NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
VENDOR_ID NUMBER (15)
INVOICE_NUM VARCHAR2 (50) Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
INVOICE_CURRENCY_CODE VARCHAR2 (15) Yes
PAYMENT_CURRENCY_CODE VARCHAR2 (15) Yes
PAYMENT_CROSS_RATE NUMBER
Yes
INVOICE_AMOUNT NUMBER

VENDOR_SITE_ID NUMBER (15)
AMOUNT_PAID NUMBER

DISCOUNT_AMOUNT_TAKEN NUMBER

INVOICE_DATE DATE

SOURCE VARCHAR2 (25)
INVOICE_TYPE_LOOKUP_CODE VARCHAR2 (25)
DESCRIPTION VARCHAR2 (240)
BATCH_ID NUMBER (15)
AMOUNT_APPLICABLE_TO_DISCOUNT NUMBER

TAX_AMOUNT NUMBER

TERMS_ID NUMBER (15)
TERMS_DATE DATE

PAYMENT_METHOD_LOOKUP_CODE VARCHAR2 (25)
PAY_GROUP_LOOKUP_CODE VARCHAR2 (25)
ACCTS_PAY_CODE_COMBINATION_ID NUMBER (15)
PAYMENT_STATUS_FLAG VARCHAR2 (1)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
BASE_AMOUNT NUMBER

VAT_CODE VARCHAR2 (15)
LAST_UPDATE_LOGIN NUMBER (15)
EXCLUSIVE_PAYMENT_FLAG VARCHAR2 (1)
PO_HEADER_ID NUMBER (15)
FREIGHT_AMOUNT NUMBER

GOODS_RECEIVED_DATE DATE

INVOICE_RECEIVED_DATE DATE

VOUCHER_NUM VARCHAR2 (50)
APPROVED_AMOUNT NUMBER

RECURRING_PAYMENT_ID NUMBER (15)
EXCHANGE_RATE NUMBER

EXCHANGE_RATE_TYPE VARCHAR2 (30)
EXCHANGE_DATE DATE

EARLIEST_SETTLEMENT_DATE DATE

ORIGINAL_PREPAYMENT_AMOUNT NUMBER

DOC_SEQUENCE_ID NUMBER

DOC_SEQUENCE_VALUE NUMBER

DOC_CATEGORY_CODE VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE_CATEGORY VARCHAR2 (150)
APPROVAL_STATUS VARCHAR2 (25)
APPROVAL_DESCRIPTION VARCHAR2 (240)
INVOICE_DISTRIBUTION_TOTAL NUMBER

POSTING_STATUS VARCHAR2 (15)
PREPAY_FLAG VARCHAR2 (1)
AUTHORIZED_BY VARCHAR2 (25)
CANCELLED_DATE DATE

CANCELLED_BY NUMBER (15)
CANCELLED_AMOUNT NUMBER

TEMP_CANCELLED_AMOUNT NUMBER

PROJECT_ACCOUNTING_CONTEXT VARCHAR2 (30)
USSGL_TRANSACTION_CODE VARCHAR2 (30)
USSGL_TRX_CODE_CONTEXT VARCHAR2 (30)
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
EXPENDITURE_TYPE VARCHAR2 (30)
EXPENDITURE_ITEM_DATE DATE

PA_QUANTITY NUMBER (22)
EXPENDITURE_ORGANIZATION_ID NUMBER (15)
PA_DEFAULT_DIST_CCID NUMBER (15)
VENDOR_PREPAY_AMOUNT NUMBER

PAYMENT_AMOUNT_TOTAL NUMBER

AWT_FLAG VARCHAR2 (1)
AWT_GROUP_ID NUMBER (15)
REFERENCE_1 VARCHAR2 (30)
REFERENCE_2 VARCHAR2 (30)
ORG_ID NUMBER (15)
PRE_WITHHOLDING_AMOUNT NUMBER

GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
AUTO_TAX_CALC_FLAG VARCHAR2 (1)
PAYMENT_CROSS_RATE_TYPE VARCHAR2 (30)
PAYMENT_CROSS_RATE_DATE DATE

PAY_CURR_INVOICE_AMOUNT NUMBER

MRC_BASE_AMOUNT VARCHAR2 (2000)
MRC_EXCHANGE_RATE VARCHAR2 (2000)
MRC_EXCHANGE_RATE_TYPE VARCHAR2 (2000)
MRC_EXCHANGE_DATE VARCHAR2 (2000)
GL_DATE DATE
Yes
AWARD_ID NUMBER (15)
PAID_ON_BEHALF_EMPLOYEE_ID NUMBER (15)
AMT_DUE_CCARD_COMPANY NUMBER

AMT_DUE_EMPLOYEE NUMBER

APPROVAL_READY_FLAG VARCHAR2 (1) Yes
APPROVAL_ITERATION NUMBER (9)
WFAPPROVAL_STATUS VARCHAR2 (50) Yes
REQUESTER_ID NUMBER (15)
VALIDATION_REQUEST_ID NUMBER (15)
VALIDATED_TAX_AMOUNT NUMBER

QUICK_CREDIT VARCHAR2 (1)
CREDITED_INVOICE_ID NUMBER (15)
DISTRIBUTION_SET_ID NUMBER (15)
APPLICATION_ID NUMBER (15)
PRODUCT_TABLE VARCHAR2 (30)
REFERENCE_KEY1 VARCHAR2 (150)
REFERENCE_KEY2 VARCHAR2 (150)
REFERENCE_KEY3 VARCHAR2 (150)
REFERENCE_KEY4 VARCHAR2 (150)
REFERENCE_KEY5 VARCHAR2 (150)
TOTAL_TAX_AMOUNT NUMBER

SELF_ASSESSED_TAX_AMOUNT NUMBER

TRX_BUSINESS_CATEGORY VARCHAR2 (240)
USER_DEFINED_FISC_CLASS VARCHAR2 (240)
TAXATION_COUNTRY VARCHAR2 (30)
DOCUMENT_SUB_TYPE VARCHAR2 (150)
SUPPLIER_TAX_INVOICE_NUMBER VARCHAR2 (150)
SUPPLIER_TAX_INVOICE_DATE DATE

SUPPLIER_TAX_EXCHANGE_RATE NUMBER

TAX_INVOICE_RECORDING_DATE DATE

TAX_INVOICE_INTERNAL_SEQ VARCHAR2 (150)
HISTORICAL_FLAG VARCHAR2 (1)
FORCE_REVALIDATION_FLAG VARCHAR2 (1)
BANK_CHARGE_BEARER VARCHAR2 (30)
REMITTANCE_MESSAGE1 VARCHAR2 (150)
REMITTANCE_MESSAGE2 VARCHAR2 (150)
REMITTANCE_MESSAGE3 VARCHAR2 (150)
UNIQUE_REMITTANCE_IDENTIFIER VARCHAR2 (30)
URI_CHECK_DIGIT VARCHAR2 (2)
SETTLEMENT_PRIORITY VARCHAR2 (30)
PAYMENT_REASON_CODE VARCHAR2 (30)
PAYMENT_REASON_COMMENTS VARCHAR2 (240)
PAYMENT_METHOD_CODE VARCHAR2 (30)
DELIVERY_CHANNEL_CODE VARCHAR2 (30)
QUICK_PO_HEADER_ID NUMBER (15)
NET_OF_RETAINAGE_FLAG VARCHAR2 (1)
RELEASE_AMOUNT_NET_OF_TAX NUMBER

CONTROL_AMOUNT NUMBER

PARTY_ID NUMBER (15)
PARTY_SITE_ID NUMBER (15)
PAY_PROC_TRXN_TYPE_CODE VARCHAR2 (30)
PAYMENT_FUNCTION VARCHAR2 (30)
CUST_REGISTRATION_CODE VARCHAR2 (50)
CUST_REGISTRATION_NUMBER VARCHAR2 (30)
PORT_OF_ENTRY_CODE VARCHAR2 (30)
EXTERNAL_BANK_ACCOUNT_ID NUMBER (15)
VENDOR_CONTACT_ID NUMBER (15)
INTERNAL_CONTACT_EMAIL VARCHAR2 (2000)
DISC_IS_INV_LESS_TAX_FLAG VARCHAR2 (1)
EXCLUDE_FREIGHT_FROM_DISCOUNT VARCHAR2 (1)
PAY_AWT_GROUP_ID NUMBER (15)
ORIGINAL_INVOICE_AMOUNT NUMBER

DISPUTE_REASON VARCHAR2 (100)
REMIT_TO_SUPPLIER_NAME VARCHAR2 (240)
REMIT_TO_SUPPLIER_ID NUMBER (15)
REMIT_TO_SUPPLIER_SITE VARCHAR2 (240)
REMIT_TO_SUPPLIER_SITE_ID NUMBER (15)
RELATIONSHIP_ID NUMBER (15)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INVOICE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      VENDOR_ID
,      INVOICE_NUM
,      SET_OF_BOOKS_ID
,      INVOICE_CURRENCY_CODE
,      PAYMENT_CURRENCY_CODE
,      PAYMENT_CROSS_RATE
,      INVOICE_AMOUNT
,      VENDOR_SITE_ID
,      AMOUNT_PAID
,      DISCOUNT_AMOUNT_TAKEN
,      INVOICE_DATE
,      SOURCE
,      INVOICE_TYPE_LOOKUP_CODE
,      DESCRIPTION
,      BATCH_ID
,      AMOUNT_APPLICABLE_TO_DISCOUNT
,      TAX_AMOUNT
,      TERMS_ID
,      TERMS_DATE
,      PAYMENT_METHOD_LOOKUP_CODE
,      PAY_GROUP_LOOKUP_CODE
,      ACCTS_PAY_CODE_COMBINATION_ID
,      PAYMENT_STATUS_FLAG
,      CREATION_DATE
,      CREATED_BY
,      BASE_AMOUNT
,      VAT_CODE
,      LAST_UPDATE_LOGIN
,      EXCLUSIVE_PAYMENT_FLAG
,      PO_HEADER_ID
,      FREIGHT_AMOUNT
,      GOODS_RECEIVED_DATE
,      INVOICE_RECEIVED_DATE
,      VOUCHER_NUM
,      APPROVED_AMOUNT
,      RECURRING_PAYMENT_ID
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      EARLIEST_SETTLEMENT_DATE
,      ORIGINAL_PREPAYMENT_AMOUNT
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      DOC_CATEGORY_CODE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      APPROVAL_STATUS
,      APPROVAL_DESCRIPTION
,      INVOICE_DISTRIBUTION_TOTAL
,      POSTING_STATUS
,      PREPAY_FLAG
,      AUTHORIZED_BY
,      CANCELLED_DATE
,      CANCELLED_BY
,      CANCELLED_AMOUNT
,      TEMP_CANCELLED_AMOUNT
,      PROJECT_ACCOUNTING_CONTEXT
,      USSGL_TRANSACTION_CODE
,      USSGL_TRX_CODE_CONTEXT
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      PA_QUANTITY
,      EXPENDITURE_ORGANIZATION_ID
,      PA_DEFAULT_DIST_CCID
,      VENDOR_PREPAY_AMOUNT
,      PAYMENT_AMOUNT_TOTAL
,      AWT_FLAG
,      AWT_GROUP_ID
,      REFERENCE_1
,      REFERENCE_2
,      ORG_ID
,      PRE_WITHHOLDING_AMOUNT
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      AUTO_TAX_CALC_FLAG
,      PAYMENT_CROSS_RATE_TYPE
,      PAYMENT_CROSS_RATE_DATE
,      PAY_CURR_INVOICE_AMOUNT
,      MRC_BASE_AMOUNT
,      MRC_EXCHANGE_RATE
,      MRC_EXCHANGE_RATE_TYPE
,      MRC_EXCHANGE_DATE
,      GL_DATE
,      AWARD_ID
,      PAID_ON_BEHALF_EMPLOYEE_ID
,      AMT_DUE_CCARD_COMPANY
,      AMT_DUE_EMPLOYEE
,      APPROVAL_READY_FLAG
,      APPROVAL_ITERATION
,      WFAPPROVAL_STATUS
,      REQUESTER_ID
,      VALIDATION_REQUEST_ID
,      VALIDATED_TAX_AMOUNT
,      QUICK_CREDIT
,      CREDITED_INVOICE_ID
,      DISTRIBUTION_SET_ID
,      APPLICATION_ID
,      PRODUCT_TABLE
,      REFERENCE_KEY1
,      REFERENCE_KEY2
,      REFERENCE_KEY3
,      REFERENCE_KEY4
,      REFERENCE_KEY5
,      TOTAL_TAX_AMOUNT
,      SELF_ASSESSED_TAX_AMOUNT
,      TAX_RELATED_INVOICE_ID
,      TRX_BUSINESS_CATEGORY
,      USER_DEFINED_FISC_CLASS
,      TAXATION_COUNTRY
,      DOCUMENT_SUB_TYPE
,      SUPPLIER_TAX_INVOICE_NUMBER
,      SUPPLIER_TAX_INVOICE_DATE
,      SUPPLIER_TAX_EXCHANGE_RATE
,      TAX_INVOICE_RECORDING_DATE
,      TAX_INVOICE_INTERNAL_SEQ
,      LEGAL_ENTITY_ID
,      HISTORICAL_FLAG
,      FORCE_REVALIDATION_FLAG
,      BANK_CHARGE_BEARER
,      REMITTANCE_MESSAGE1
,      REMITTANCE_MESSAGE2
,      REMITTANCE_MESSAGE3
,      UNIQUE_REMITTANCE_IDENTIFIER
,      URI_CHECK_DIGIT
,      SETTLEMENT_PRIORITY
,      PAYMENT_REASON_CODE
,      PAYMENT_REASON_COMMENTS
,      PAYMENT_METHOD_CODE
,      DELIVERY_CHANNEL_CODE
,      QUICK_PO_HEADER_ID
,      NET_OF_RETAINAGE_FLAG
,      RELEASE_AMOUNT_NET_OF_TAX
,      CONTROL_AMOUNT
,      PARTY_ID
,      PARTY_SITE_ID
,      PAY_PROC_TRXN_TYPE_CODE
,      PAYMENT_FUNCTION
,      CUST_REGISTRATION_CODE
,      CUST_REGISTRATION_NUMBER
,      PORT_OF_ENTRY_CODE
,      EXTERNAL_BANK_ACCOUNT_ID
,      VENDOR_CONTACT_ID
,      INTERNAL_CONTACT_EMAIL
,      DISC_IS_INV_LESS_TAX_FLAG
,      EXCLUDE_FREIGHT_FROM_DISCOUNT
,      PAY_AWT_GROUP_ID
,      ORIGINAL_INVOICE_AMOUNT
,      DISPUTE_REASON
,      REMIT_TO_SUPPLIER_NAME
,      REMIT_TO_SUPPLIER_ID
,      REMIT_TO_SUPPLIER_SITE
,      REMIT_TO_SUPPLIER_SITE_ID
,      RELATIONSHIP_ID
FROM AP.AP_INVOICES_ALL#;

Dependencies

[top of page]

AP.AP_INVOICES_ALL# references the following:

SchemaAP
TableAP_INVOICES_ALL
AP.AP_INVOICES_ALL# is referenced by following:

SchemaAPPS
SynonymAP_INVOICES
SynonymAP_INVOICES_ALL
TriggerIGI_SIA_AP_INVOICES_ALL_T1
TriggerITG_IP_INVOICES_ALL_ARI
TriggerJAI_AP_IA_ARIUD_T1
TriggerJAI_AP_IA_BRIUD_T1
TriggerJAI_AP_IA_DTC_BRIUD_T1
TriggerOIE_UPDATE_EXP_STATUS