MOO_IMP_REVN_LINE

Details

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

Primary Key

Name	Columns
MOO_IMP_REVN_LINE_SET_PK	INTERFACE_ROW_ID, BATCH_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
INTERFACE_ROW_ID	NUMBER		18	Yes	links this row with the rows in the errors table
BATCH_ID	NUMBER		18	Yes	Unique Identifier for a Batch
IMPORT_STATUS_CODE	VARCHAR2	30			status of the import row
REVN_CREATION_DATE	TIMESTAMP				Stores the create date of the revenue record.
CREATION_DATE	TIMESTAMP				Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64			Who column: indicates the user who created the row.
LAST_UPDATED_BY	VARCHAR2	64			Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP				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.
USER_LAST_UPDATE_DATE	TIMESTAMP				Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server).
REVN_ID	NUMBER		18		Unique Identifier for the revenue
REVN_NUMBER	VARCHAR2	30			User editable revenue number. Defaulted from REVN_ID. Needs to be unique. Cannot be null
OPTY_ID	NUMBER		18		Opportunity ID
OPTY_NUMBER	VARCHAR2	30			Opportunity Number. This is a public surrogate key.
ACTION_CODE	VARCHAR2	30			Indicates if the record is meant for insert, update, or delete.
INTERNAL_ACTION_CODE	VARCHAR2	30			System determined action code
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.
FILE_RECORD_NUM	NUMBER		10		FILE_RECORD_NUM
CUST_PARTY_ID	NUMBER		18		Target party id (customer or prospect)
CUST_PARTY_NUMBER	VARCHAR2	30			Unique identification number for this customer party
CUST_ORIG_SYSTEM	VARCHAR2	30			Original System ID for the customer party
CUST_ORIG_SYSTEM_REFERENCE	VARCHAR2	255			Original System Reference for the customer party
CUST_ACCOUNT_ID	NUMBER		18		Customer account ID
CUST_ACCOUNT_NUMBER	VARCHAR2	30			Unique identification number for this customer account
CUST_ACT_ORIG_SYSTEM	VARCHAR2	30			Unique identification number for this customer account
CUST_ACT_ORIG_SYSTEM_REFERENCE	VARCHAR2	255			Original System Reference for the customer account
BU_ORG_ID	NUMBER		18		Business Unit ID, derived from oppty
REVN_AMT_CURCY_CODE	VARCHAR2	15			Currency code for all monetary amounts except Predicted Revenue
PROD_GROUP_ID	NUMBER		18		Opportunity revenue line set-enabled product group
PROD_GROUP_NUMBER	VARCHAR2	50			used to retrieve prod_group_id from QSC_PROD_GROUP_B when it's not supplied
PROD_GROUP_INTERNAL_NAME	VARCHAR2	80			Product group internal name, when prod_group_id is not populated, this column is used to get prod_group_id from QSC_PROD_GROUPS_B(_TL)
INTERNAL_OPTY_OVN	NUMBER		9		The Object Version Number of the Opportunity record which will be affected by this instruction.
INTERNAL_OVN	NUMBER		9		The Object Version Number of the record being updated. Used for Optimistic Locking as part of Incremental Update.

Indexes

Index	Uniqueness	Tablespace	Columns
MOO_IMP_REVN_LINE_SET_N1	Non Unique	Default	REVN_ID, BATCH_ID, OPTY_ID, IMPORT_STATUS_CODE
MOO_IMP_REVN_LINE_SET_PK1	Unique	Default	INTERFACE_ROW_ID, BATCH_ID