Skip to content

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

VIEW: APPS.APFV_AP_INVOICES

Object Details
Object Name: APFV_AP_INVOICES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLAP.APFV_AP_INVOICES
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Shows information about invoices, which are documents containing details of charges to be remitted or deducted in a payment to a supplier.


[View Source]

Columns
Name Datatype Length Mandatory Comments
INVOICE_NUMBER VARCHAR2 (50) Yes
INVOICE_DATE DATE

INVOICE_DESCRIPTION VARCHAR2 (240)
INVOICE_DISCOUNTABLE_AMOUNT NUMBER

INVOICE_ENTERED_AMOUNT NUMBER

INVOICE_FREIGHT_AMOUNT NUMBER

INVOICE_FUNCTIONAL_AMOUNT NUMBER

INVOICE_RECEIVED_DATE DATE

INVOICE_POSTING_STATUS VARCHAR2 (15)
AWT_FLAG VARCHAR2 (1)
INVOICE_SEQUENCE_NUMBER NUMBER

INVOICE_SOURCE VARCHAR2 (25)
_LA:SOURCE_DESCRIPTON CHAR (49)
INVOICE_TYPE_CODE VARCHAR2 (25)
_LA:INVOICE_TYPE_DESCRIPTION CHAR (73)
PAY_ALONE_FLAG VARCHAR2 (1)
PAY_GROUP VARCHAR2 (25)
PAYMENT_CURRENCY_INVOICE_AMT NUMBER

INV_TO_PMT_RATE NUMBER
Yes
INV_TO_PMT_RATE_TYPE VARCHAR2 (30)
INV_TO_PMT_RATE_DATE DATE

PAYMENT_METHOD VARCHAR2 (30)
PAYMENT_STATUS VARCHAR2 (1)
_LA:PMT_STATUS_DESCRIPTION CHAR (78)
MANUALLY_APPROVED_DESCRIPTION VARCHAR2 (240)
PAYMENT_TERMS_DATE DATE

TAX_AMOUNT NUMBER

TAX_CALCULATION_LEVEL VARCHAR2 (1)
USSGL_TRANSACTION_CODE VARCHAR2 (30)
MANUALLY_APPROVED_STATUS VARCHAR2 (25)
INVOICE_APPROVED_AMOUNT NUMBER

INVOICE_CANCELED_AMOUNT NUMBER

INVOICE_CANCELED_DATE DATE

INV_TO_FUNCTIONAL_EXCH_RATE NUMBER

INV_TO_FUNCTIONAL_EXCH_TYPE VARCHAR2 (30)
INV_TO_FUNCTIONAL_EXCH_DATE DATE

BATCH_ID NUMBER (15)
VENDOR_ID NUMBER (15)
VENDOR_SITE_ID NUMBER (15)
INVOICE_CURRENCY_CODE VARCHAR2 (15) Yes
PAYMENT_CURRENCY_CODE VARCHAR2 (15) Yes
TERMS_ID NUMBER (15)
INVOICE_ID NUMBER (15) Yes
PO_HEADER_ID NUMBER (15)
PROJECT_ID NUMBER (15)
PROJECT_TASK_ID NUMBER (15)
PA_EXPENDITURE_TYPE VARCHAR2 (30)
PA_EXPENDITURE_ITEM_DATE DATE

PA_QUANTITY NUMBER (22)
PA_REFERENCE_1 VARCHAR2 (30)
PA_REFERENCE_2 VARCHAR2 (30)
_DF CHAR (25)
_DF:GLBL CHAR (25)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
ORG_ID NUMBER (15)
Query Text

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


SELECT INVOICE_NUMBER
,      INVOICE_DATE
,      INVOICE_DESCRIPTION
,      INVOICE_DISCOUNTABLE_AMOUNT
,      INVOICE_ENTERED_AMOUNT
,      INVOICE_FREIGHT_AMOUNT
,      INVOICE_FUNCTIONAL_AMOUNT
,      INVOICE_RECEIVED_DATE
,      INVOICE_POSTING_STATUS
,      AWT_FLAG
,      INVOICE_SEQUENCE_NUMBER
,      INVOICE_SOURCE
,      _LA:SOURCE_DESCRIPTON
,      INVOICE_TYPE_CODE
,      _LA:INVOICE_TYPE_DESCRIPTION
,      PAY_ALONE_FLAG
,      PAY_GROUP
,      PAYMENT_CURRENCY_INVOICE_AMT
,      INV_TO_PMT_RATE
,      INV_TO_PMT_RATE_TYPE
,      INV_TO_PMT_RATE_DATE
,      PAYMENT_METHOD
,      PAYMENT_STATUS
,      _LA:PMT_STATUS_DESCRIPTION
,      MANUALLY_APPROVED_DESCRIPTION
,      PAYMENT_TERMS_DATE
,      TAX_AMOUNT
,      TAX_CALCULATION_LEVEL
,      USSGL_TRANSACTION_CODE
,      MANUALLY_APPROVED_STATUS
,      INVOICE_APPROVED_AMOUNT
,      INVOICE_CANCELED_AMOUNT
,      INVOICE_CANCELED_DATE
,      INV_TO_FUNCTIONAL_EXCH_RATE
,      INV_TO_FUNCTIONAL_EXCH_TYPE
,      INV_TO_FUNCTIONAL_EXCH_DATE
,      BATCH_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      INVOICE_CURRENCY_CODE
,      PAYMENT_CURRENCY_CODE
,      TERMS_ID
,      INVOICE_ID
,      PO_HEADER_ID
,      PROJECT_ID
,      PROJECT_TASK_ID
,      PA_EXPENDITURE_TYPE
,      PA_EXPENDITURE_ITEM_DATE
,      PA_QUANTITY
,      PA_REFERENCE_1
,      PA_REFERENCE_2
,      _DF
,      _DF:GLBL
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ORG_ID
FROM APPS.APFV_AP_INVOICES;

Dependencies

[top of page]

APPS.APFV_AP_INVOICES references the following:

SchemaAPPS
SynonymAP_INVOICES

APPS.APFV_AP_INVOICES is not referenced by any database object