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

TABLE: FUN.FUN_NET_AR_TXNS_ALL

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

FUN_NET_AR_TXNS_ALL stores information about Receivables Transactions included in Netting Batch.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FUN_NET_AR_TXNS_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
ColumnCUSTOMER_TRX_ID
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15) Yes Batch Identifier.
CUSTOMER_TRX_ID NUMBER (15) Yes Customer Transaction Identifier.
OBJECT_VERSION_NUMBER NUMBER (15) Yes Object Version Number.
AR_TXN_RANK NUMBER (15) Yes Rank of the Customer Transaction.
TRANSACTION_AMT NUMBER
Yes Transaction Amount.
NETTED_AMT NUMBER

Netted Amount in Batch Currency
OPEN_AMT NUMBER
Yes Open Amount in Batch Currency.
TXN_CURR_NET_AMT NUMBER

Netting Amount in Transaction Currency.
TXN_CURR_OPEN_AMT NUMBER

Netting Open Amount in Transaction Currency.
CASH_RECEIPT_ID NUMBER (15)
Cash Receipt 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
,      CUSTOMER_TRX_ID
,      OBJECT_VERSION_NUMBER
,      AR_TXN_RANK
,      TRANSACTION_AMT
,      NETTED_AMT
,      OPEN_AMT
,      TXN_CURR_NET_AMT
,      TXN_CURR_OPEN_AMT
,      CASH_RECEIPT_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_AR_TXNS_ALL;

Dependencies

[top of page]

FUN.FUN_NET_AR_TXNS_ALL does not reference any database object

FUN.FUN_NET_AR_TXNS_ALL is referenced by following:

SchemaFUN
ViewFUN_NET_AR_TXNS_ALL#