eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FII.FII_AR_TRX_DIST_F_DLOG

Object Details

Object Name:	FII_AR_TRX_DIST_F_DLOG
Object Type:	TABLE
Owner:	FII
FND Design Data:	FII.FII_AR_TRX_DIST_F_DLOG
Subobject Name:
Status:	VALID

This is a delete log table for the Accounts Receivable Revenue Fact table FII_AR_TRX_DIST_F). The columns of the delete log table are same as those of the fact table. Whenever a record is updated in the Accounts ReceivableRevenue Fact table, the old record is stored in the delete log table. The delete log is primarily used for the derived facts.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
AGREEMENT_NAME	VARCHAR2	(30)	The agreement name for the order.
INVOICE_LINE_MEMO	VARCHAR2	(50)	Invoice line memo description.
SALES_ORDER_LINE_NUMBER	VARCHAR2	(30)	Sales order line number.
SALES_ORDER_SOURCE	VARCHAR2	(50)	The source of the sales order.
ORIGINAL_INVOICE_NUM	VARCHAR2	(30)	The original invoice number.
ORIGINAL_INVOICE_LINE_NUM	VARCHAR2	(10)	The original invoice line number.
INTERFACE_LINE_CONTEXT	VARCHAR2	(30)	Interface line context for the transaction line.
INVOICE_ID	VARCHAR2	(25)	A source system generated identifier for the transaction.
INVOICE_DIST_ID	VARCHAR2	(25)	A source system generated identifier for the transaction line distribution.
ORIGINAL_INVOICE_ID	VARCHAR2	(15)	A source system generated identifier for the transaction.
ORIGINAL_INVOICE_LINE_ID	VARCHAR2	(25)	A source system generated identifier for the transaction line.
END_USER_CUSTOMER_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the trading partner dimension at the lowest level.
RESELLER_CUSTOMER_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the trading partner dimension at the lowest level.
INVOICE_DATE_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the time dimension at the lowest level.
SALES_ORDER_DATE_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the time dimension at the lowest level.
INTERNAL_FLAG	VARCHAR2	(3)	For Internal purpose only.
AMT_B	NUMBER		Distribution amount in the functional currency.
AMT_G	NUMBER		Distribution amount in the warehouse global currency.
AMT_T	NUMBER		Distribution amount in the transaction currency.
FUNCTIONAL_CURRENCY_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the functional currency dimension at the lowest level.
BILL_TO_CUSTOMER_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the trading partner dimension at the lowest level.
BILL_TO_SITE_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the geography dimension at the lowest level.
CAMPAIGN_ACTL_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the campaign dimension at the lowest level.
CAMPAIGN_INIT_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the campaign dimension at the lowest level.
ACCOUNT_ID	NUMBER		A source system generated identifier for the account.
CELL_ACTL_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the target segment dimension at the lowest level.
CELL_INIT_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the target segment dimension at the lowest level.
INVOICE_LINE_ID	VARCHAR2	(25)	A source system generated identifier for the transaction line.
INVOICE_LINE_NUMBER	VARCHAR2	(10)	Line number for a specific transaction number.
EVENT_OFFER_ACTL_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the event dimension at the lowest level.
EVENT_OFFER_INIT_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the event dimension at the lowest level.
EVENT_OFFER_REG_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the event dimension at the lowest level.
EXCHANGE_RATE	NUMBER		Currency exchange rate from the source system.
GL_ACCT10_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Accounting Flexfield dimension.
GL_ACCT1_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Accounting Flexfield dimension.
GL_ACCT2_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Accounting Flexfield dimension.
GL_ACCT3_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Accounting Flexfield dimension.
GL_ACCT4_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Accounting Flexfield dimension.
GL_ACCT5_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Accounting Flexfield dimension.
GL_ACCT6_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Accounting Flexfield dimension.
GL_ACCT7_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Accounting Flexfield dimension.
GL_ACCT8_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Accounting Flexfield dimension.
GL_ACCT9_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Accounting Flexfield dimension.
GL_DATE_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the time dimension at the lowest level.
SET_OF_BOOKS_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the set of books dimension at the lowest level.
INSTANCE_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the instance dimension at the lowest level.
ITEM_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the item dimension at the lowest level.
QTY_CREDITED	NUMBER		Quantity credited for this line.
INVOICE_LINE_QTY	NUMBER		Quantity invoiced for this line.
ORDER_LINE_QTY	NUMBER		Quantity ordered for this line.
MARKET_SEGMENT_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the market segment dimension at the lowest level.
MEDIA_ACTL_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the media channel dimension at the lowest level.
MEDIA_INIT_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the media channel dimension at the lowest level.
OFFER_ACTL_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the offer dimension at the lowest level.
OFFER_INIT_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the offer dimension at the lowest level.
ORGANIZATION_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the organization dimension at the lowest level.
PARENT_ITEM_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the item dimension at the lowest level.
PAYMENT_TERM_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the payment terms dimension at the lowest level.
PRIM_SALESREP_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the person dimension at the lowest level.
PROJECT_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the project dimension at the lowest level.
SALESCHANNEL_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the sales channel dimension at the lowest level.
SALESREP_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the person dimension at the lowest level.
SHIP_TO_CUSTOMER_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the trading partner dimension at the lowest level.
SHIP_TO_SITE_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the geography dimension at the lowest level.
SIC_CODE_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the standard industry code, SIC, dimension at the lowest level.
SOLD_TO_CUSTOMER_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the trading partner dimension at the lowest level.
SOLD_TO_SITE_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the geography dimension at the lowest level.
SOURCE_LIST_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the source list dimension at the lowest level.
TRANSACTION_CURRENCY_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the transaction currency dimension at the lowest level.
UNIT_SELLING_PRICE	NUMBER		Selling price per unit for a transaction line.
SO_LINE_SELLING_PRICE	NUMBER		Selling price for sales order line.
UOM_FK_KEY	NUMBER		A foreign key generated by the warehouse system that points to the unit of measure dimension at the lowest level.
USER_FK1_KEY	NUMBER		A foreign key generated by the warehouse that points to the user defined foreign key.
USER_FK2_KEY	NUMBER		A foreign key generated by the warehouse that points to the user defined foreign key.
USER_FK3_KEY	NUMBER		A foreign key generated by the warehouse that points to the user defined foreign key.
USER_FK4_KEY	NUMBER		A foreign key generated by the warehouse that points to the user defined foreign key.
USER_FK5_KEY	NUMBER		A foreign key generated by the warehouse that points to the user defined foreign key.
USER_MEASURE1	NUMBER		User defined measure identifier.
USER_MEASURE2	NUMBER		User defined measure identifier.
USER_MEASURE3	NUMBER		User defined measure identifier.
USER_MEASURE4	NUMBER		User defined measure identifier.
USER_MEASURE5	NUMBER		User defined measure identifier.
CAMPAIGN_STATUS_INIT_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the campaign status dimension at the lowest level.
CAMPAIGN_STATUS_ACTL_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the campaign status dimension at the lowest level.
AGREEMENT_TYPE	VARCHAR2	(30)	Code used to group agreements.
INVOICE_SOURCE_NAME	VARCHAR2	(50)	Batch source name.
PROCESS_TYPE	VARCHAR2	(1)	The source of how invoices are entered into the receivables system.
EXCHANGE_RATE_TYPE	VARCHAR2	(30)	Currency exchange rate type from the source system.
INSTANCE	VARCHAR2	(40)	Instance identifier.
LINE_TYPE	VARCHAR2	(3)	The type of receivables invoice line. LIN, Regular Invoice Line. FRT, Freight Line. TAX, Tax Line. QTY, Quantity Line. ADJ, Adjustment Line.
ORDER_LINE_ID	VARCHAR2	(50)	A source system generated identifier for the sales order line.
SALES_ORDER_NUMBER	VARCHAR2	(30)	Sales order number.
INVOICE_REASON	VARCHAR2	(30)	Invoice reason.
INVOICE_PK	VARCHAR2	(120)	This is a unique key for the AR Revenue Fact. It is a concatenation of Oracle Applications Customer Transaction Line and GL Distribution table.
INVOICE_PK_KEY	NUMBER		This is the primary key for the AR Revenue Fact. This key is generated by the invoice unique key.
INVOICE_NUMBER	VARCHAR2	(30)	A document number that is created in Oracle Receivables.
USER_ATTRIBUTE1	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE10	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE11	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE12	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE13	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE14	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE15	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE2	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE3	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE4	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE5	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE6	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE7	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE8	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE9	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE16	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE17	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE18	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE19	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE20	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE21	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE22	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE23	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE24	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE25	VARCHAR2	(240)	User defined attribute value.
EXCHANGE_DATE	DATE		Date of the currency exchange rate.
GL_DATE	DATE		General Ledger date.
INVOICE_DATE	DATE		Transaction date.
TRANSACTION_STATUS	VARCHAR2	(1)	Invoice or adjustment status. O, Open. C, Closed.
TRANSACTION_CLASS	VARCHAR2	(3)	A way to classify different types of transactions in Oracle Receivables. INV, Regular Invoice. CM, Credit Memo. DM, Debit Memo. CB, Charge Back. GUR, Guarentee. DEP, Deposit. ADJ, Adjustment. NULL, Unspecified Transaction Class.
GL_POSTED_DATE	DATE		Date posted to General Ledger.
CREATION_DATE	DATE		Standard who column - date when this row was created.
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
ACCOUNT_TYPE	VARCHAR2	(4)	The Account Type as defined in General Ledger. REV, Revenue. LIB, Liabilities. AST, Assets. EXP, Expenses. EQT, Owners Equity.
ACCOUNT_CLASS	VARCHAR2	(3)	The Account Class as defined in Account Receivables. REV, Revenue. FREIGHT. TAX. REC, Receivables. UNBILL, Unbilled Receivable. UNEARN, Unearned Revenue.
COMPANY_CC_ORG_FK_KEY	NUMBER		A foreign key generated by the warehouse for company_cost_center_org_id that points to the organization dimension at the lowest level.
SALESRESOURCE_FK_KEY	NUMBER		A foreign key generated by the warehouse for salesperson that points to the sales resource dimension at the lowest level.
PRIM_SALESRESOURCE_FK_KEY	NUMBER		A foreign key generated by the warehouse for primary salesperson that points to the sales resource dimension at the lowest level.

Query Text

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


SELECT AGREEMENT_NAME
,      INVOICE_LINE_MEMO
,      SALES_ORDER_LINE_NUMBER
,      SALES_ORDER_SOURCE
,      ORIGINAL_INVOICE_NUM
,      ORIGINAL_INVOICE_LINE_NUM
,      INTERFACE_LINE_CONTEXT
,      INVOICE_ID
,      INVOICE_DIST_ID
,      ORIGINAL_INVOICE_ID
,      ORIGINAL_INVOICE_LINE_ID
,      END_USER_CUSTOMER_FK_KEY
,      RESELLER_CUSTOMER_FK_KEY
,      INVOICE_DATE_FK_KEY
,      SALES_ORDER_DATE_FK_KEY
,      INTERNAL_FLAG
,      AMT_B
,      AMT_G
,      AMT_T
,      FUNCTIONAL_CURRENCY_FK_KEY
,      BILL_TO_CUSTOMER_FK_KEY
,      BILL_TO_SITE_FK_KEY
,      CAMPAIGN_ACTL_FK_KEY
,      CAMPAIGN_INIT_FK_KEY
,      ACCOUNT_ID
,      CELL_ACTL_FK_KEY
,      CELL_INIT_FK_KEY
,      INVOICE_LINE_ID
,      INVOICE_LINE_NUMBER
,      EVENT_OFFER_ACTL_FK_KEY
,      EVENT_OFFER_INIT_FK_KEY
,      EVENT_OFFER_REG_FK_KEY
,      EXCHANGE_RATE
,      GL_ACCT10_FK_KEY
,      GL_ACCT1_FK_KEY
,      GL_ACCT2_FK_KEY
,      GL_ACCT3_FK_KEY
,      GL_ACCT4_FK_KEY
,      GL_ACCT5_FK_KEY
,      GL_ACCT6_FK_KEY
,      GL_ACCT7_FK_KEY
,      GL_ACCT8_FK_KEY
,      GL_ACCT9_FK_KEY
,      GL_DATE_FK_KEY
,      SET_OF_BOOKS_FK_KEY
,      INSTANCE_FK_KEY
,      ITEM_FK_KEY
,      QTY_CREDITED
,      INVOICE_LINE_QTY
,      ORDER_LINE_QTY
,      MARKET_SEGMENT_FK_KEY
,      MEDIA_ACTL_FK_KEY
,      MEDIA_INIT_FK_KEY
,      OFFER_ACTL_FK_KEY
,      OFFER_INIT_FK_KEY
,      ORGANIZATION_FK_KEY
,      PARENT_ITEM_FK_KEY
,      PAYMENT_TERM_FK_KEY
,      PRIM_SALESREP_FK_KEY
,      PROJECT_FK_KEY
,      SALESCHANNEL_FK_KEY
,      SALESREP_FK_KEY
,      SHIP_TO_CUSTOMER_FK_KEY
,      SHIP_TO_SITE_FK_KEY
,      SIC_CODE_FK_KEY
,      SOLD_TO_CUSTOMER_FK_KEY
,      SOLD_TO_SITE_FK_KEY
,      SOURCE_LIST_FK_KEY
,      TRANSACTION_CURRENCY_FK_KEY
,      UNIT_SELLING_PRICE
,      SO_LINE_SELLING_PRICE
,      UOM_FK_KEY
,      USER_FK1_KEY
,      USER_FK2_KEY
,      USER_FK3_KEY
,      USER_FK4_KEY
,      USER_FK5_KEY
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      CAMPAIGN_STATUS_INIT_FK_KEY
,      CAMPAIGN_STATUS_ACTL_FK_KEY
,      AGREEMENT_TYPE
,      INVOICE_SOURCE_NAME
,      PROCESS_TYPE
,      EXCHANGE_RATE_TYPE
,      INSTANCE
,      LINE_TYPE
,      ORDER_LINE_ID
,      SALES_ORDER_NUMBER
,      INVOICE_REASON
,      INVOICE_PK
,      INVOICE_PK_KEY
,      INVOICE_NUMBER
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE16
,      USER_ATTRIBUTE17
,      USER_ATTRIBUTE18
,      USER_ATTRIBUTE19
,      USER_ATTRIBUTE20
,      USER_ATTRIBUTE21
,      USER_ATTRIBUTE22
,      USER_ATTRIBUTE23
,      USER_ATTRIBUTE24
,      USER_ATTRIBUTE25
,      EXCHANGE_DATE
,      GL_DATE
,      INVOICE_DATE
,      TRANSACTION_STATUS
,      TRANSACTION_CLASS
,      GL_POSTED_DATE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      ACCOUNT_TYPE
,      ACCOUNT_CLASS
,      COMPANY_CC_ORG_FK_KEY
,      SALESRESOURCE_FK_KEY
,      PRIM_SALESRESOURCE_FK_KEY
FROM FII.FII_AR_TRX_DIST_F_DLOG;

Dependencies

[top of page]

FII.FII_AR_TRX_DIST_F_DLOG does not reference any database object

FII.FII_AR_TRX_DIST_F_DLOG is referenced by following:

APPS: FII_AR_TRX_DIST_F_DLOG