CST_ACCT_DEFINITIONS

Details

Schema: FUSION
Object owner: CST
Object type: TABLE
Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ACCOUNTING_DEFINITION_ID	NUMBER		18	Yes	Surrogate identifying the accounting definition line.
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.
EVENT_CLASS_CODE	VARCHAR2	30		Yes	Reference to event class for which the accounting template is defined.
EVENT_TYPE_CODE	VARCHAR2	30			Reference to the event type for which the accounting template is defined.
EXPENSE_TRANSACTION_FLAG	VARCHAR2	1			Identifies whether a transaction is an asset or expense transaction. Expense = Y, Asset = N.
FOB_POINT	NUMBER		1		Indicates if the FOB Point for which the accounting definition is valid. Note this is only applicable for the intransit transfers. Possible values are: Receipt, Shipment
INTERCOMPANY_INVOICE_FLAG	VARCHAR2	1			Identifies if the inter-company invoice is enabled for a transaction. Y = Yes, N= No
OVERHEAD_FLAG	VARCHAR2	1			Indicates if the Account definition is applicable for overheads.
TRANSACTION_TYPE	VARCHAR2	10			Indicates if the transaction is of type issue or receipt.
TRANSACTION_FLOW_TYPE	NUMBER		18		Transaction Flow Identifier, 1 - Internal Drop Shipment, 2 - Global Procurement, 3 - Customer Drop Shipment, 4 - Intransit Interorg Transfer, 5 - Direct Interorg Transfer, 6 - Intraorg Transfer, 7 - Transfer Order Intransit Interorg Transfer, 8 - Transfer Order Direct Interorg Transfer, 9 - Transfer Order Intraorg Transfer, 10 - TIR/TIRR at ownership change in procuring org for consigned PO, 11 - TIRR of TO Return with Scrap or null for others.
COST_COMPONENT_CODE	VARCHAR2	30			Identifies the cost component. Values are based on the seeded cost components in the lookup type CST_COMPONENT_CODES
LINE_NO	NUMBER		5	Yes	Line number of the accounting template line for an event.
ACCOUNTING_LINE_TYPE	VARCHAR2	30		Yes	Journal Line type of the accounting template line.
DR_CR_SIGN	VARCHAR2	6		Yes	Indicate whether the amount for this line is: Dr, Cr
REVERSE_SIGN_FLAG	VARCHAR2	1		Yes	Indicates if the debit/credit signs should be changes if the amounts are negative.
SOURCE_TABLE	VARCHAR2	30		Yes	Indicates the name of the table from which the distribution will be created.
USE_TXN_CURR_AMOUNT	VARCHAR2	1			Indicates if the transaction currency amounts are used for accounting enteries as entered amounts.
USE_TXN_ACCOUNT	VARCHAR2	1			Indicates if the accounts entered on the transaction are used for accounting enteries as entered account.
DISTRIBUTION_TYPE	VARCHAR2	30			Indicates the distribtuion type. Useful if the same event type may go into different accounting line types; depending on some attribute on the cost.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Columns
CST_ACCT_DEFINITIONS_GT_N1	Non Unique	EVENT_CLASS_CODE, EVENT_TYPE_CODE, SOURCE_TABLE, EXPENSE_TRANSACTION_FLAG, OVERHEAD_FLAG, TRANSACTION_TYPE, FOB_POINT