Skip to content

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

TABLE: FUN.FUN_NET_AP_INVS_ALL

Object Details
Object Name: FUN_NET_AP_INVS_ALL
Object Type: TABLE
Owner: FUN
FND Design Data: TableFUN.FUN_NET_AP_INVS_ALL
Subobject Name:
Status: VALID

FUN_NET_AP_INVS_ALL stores information about Payables invoices included in Netting Batch.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FUN_NET_AP_INVS_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
ColumnINVOICE_ID
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15) Yes Batch Identifier.
INVOICE_ID NUMBER (15) Yes Payables Invoice Identifier.
OBJECT_VERSION_NUMBER NUMBER (15) Yes Object Version Number.
AP_TXN_RANK NUMBER (15) Yes Rank of the Payables Invoice.
INVOICE_AMT NUMBER
Yes Invoice Amount.
NETTED_AMT NUMBER

Netted Amount in Batch Currency
OPEN_AMT NUMBER
Yes Open Amount in Batch Currency
INV_CURR_NET_AMT NUMBER

Netting Amount in Invoice Currency.
INV_CURR_OPEN_AMT NUMBER

Netting Open Amount in Invoice Currency
CHECK_ID NUMBER (15)
Check Id or Payment identifier
ORG_ID NUMBER (15) Yes Organization Identifier
CREATION_DATE DATE
Yes Standard Who column.
CREATED_BY NUMBER (15) Yes Standard Who column.
LAST_UPDATE_DATE DATE
Yes Standard Who column.
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield segment.
OPEN_AMOUNT_AFTERDISC NUMBER

APPLIED_DISC NUMBER

TXN_CURR_OPEN_AMOUNT_AFTERDISC NUMBER

Query Text

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


SELECT BATCH_ID
,      INVOICE_ID
,      OBJECT_VERSION_NUMBER
,      AP_TXN_RANK
,      INVOICE_AMT
,      NETTED_AMT
,      OPEN_AMT
,      INV_CURR_NET_AMT
,      INV_CURR_OPEN_AMT
,      CHECK_ID
,      ORG_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      OPEN_AMOUNT_AFTERDISC
,      APPLIED_DISC
,      TXN_CURR_OPEN_AMOUNT_AFTERDISC
FROM FUN.FUN_NET_AP_INVS_ALL;

Dependencies

[top of page]

FUN.FUN_NET_AP_INVS_ALL does not reference any database object

FUN.FUN_NET_AP_INVS_ALL is referenced by following:

SchemaFUN
ViewFUN_NET_AP_INVS_ALL#