FA_INVOICE_TRANSACTIONS

FA_INVOICE_TRANSACTIONS tracks all the transactions you perform on invoice lines within Oracle Assets. . Oracle Assets inserts rows in this table and in FA_TRANSACTION_HEADERS each time you perform a transaction on an invoice line. . TRANSACTION_TYPE identifies the type of transaction: . {{FB}}INVOICE ADDITION{{F0}} {{TAB}}Created by the CIP Adjustments form when you add an invoice line. . {{FB}}INVOICE ADJUSTMENT{{F0}} {{TAB}}Created by the CIP Adjustments form when you perform a cost change on an invoice line. . {{FB}}INVOICE DELETE{{F0}} {{TAB}}Created by the CIP Adjustments form when you delete an invoice line. . {{FB}}INVOICE REINSTATE{{F0}} {{TAB}}Created by the CIP Adjustments form when you reinstate an invoice line you previously deleted. . {{FB}}INVOICE TRANSFER{{F0}} {{TAB}}Created by the Transfer Invoices form when you transfer an invoice between CIP assets or between a CIP and a capitalized asset. . {{FB}}MASS ADDITION{{F0}} {{TAB}}Created by the mass additions posting program when you send mass additions to Oracle Assets. . DATE_EFFECTIVE is the date on which you entered the transaction into Oracle Assets. . INVOICE_TRANSACTION_ID uniquely identifies each invoice transaction. . .

Details

• Schema: FUSION

• Object owner: FA

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
FA_INVOICE_TRANSACTIONS_PK	INVOICE_TRANSACTION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
INVOICE_TRANSACTION_ID	NUMBER		18	Yes	Unique identification number for the invoice transaction
BOOK_TYPE_CODE	VARCHAR2	30		Yes	Book name
TRANSACTION_TYPE	VARCHAR2	20		Yes	Type of invoice transaction
DATE_EFFECTIVE	DATE			Yes	System date when the transaction occurred
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Foreign Keys

Table	Foreign Table	Foreign Key Column
FA_INVOICE_TRANSACTIONS	fa_book_controls	BOOK_TYPE_CODE
fa_asset_invoices	fa_invoice_transactions	INVOICE_TRANSACTION_ID_OUT
fa_asset_invoices	fa_invoice_transactions	INVOICE_TRANSACTION_ID_IN
fa_transaction_headers	fa_invoice_transactions	INVOICE_TRANSACTION_ID
fa_mc_asset_invoices	fa_invoice_transactions	INVOICE_TRANSACTION_ID_OUT
fa_mc_asset_invoices	fa_invoice_transactions	INVOICE_TRANSACTION_ID_IN
fa_trx_references	fa_invoice_transactions	INVOICE_TRANSACTION_ID
fa_mc_books_rates	fa_invoice_transactions	INVOICE_TRANSACTION_ID

Indexes

Index	Uniqueness	Columns
FA_INVOICE_TRANSACTIONS_U1	Unique	INVOICE_TRANSACTION_ID
FA_INVOICE_TRANSACTIONS_N1	Non Unique	BOOK_TYPE_CODE, DATE_EFFECTIVE