IBY_XCC_EXTRACT

Details

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

Columns

Name	Datatype	Length	Precision	Not-null	Comments
DATA_SET_ID	NUMBER		18		Unique sequence generated by Budgetary Control for every budget control call.
SOURCE_HEADER_ID_1	VARCHAR2	30		Yes	Stores the identifier of the payment which needs to be budget controlled. Value is same as the PAYMENT_ID column of the IBY_PAYMENTS_ALL table.
SOURCE_HEADER_ID_2	VARCHAR2	30			This column is currently unused.
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_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates 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.
TRANSACTION_NUMBER	VARCHAR2	240			Indicates the transaction number.
SOURCE_LINE_ID_1	VARCHAR2	30		Yes	Stores the payment ID of the payment which needs to be budget controlled. Same as the Payment_ID of the IBY_PAYMENTS_ALL table. Same as SOURCE_HEADER_ID_1.
SOURCE_LINE_ID_2	VARCHAR2	30			Stores the invoice identifier of the payment which needs to be budget controlled. Value is same as the INVOICE_ID column of the AP_INVOICES_ALL table.
SOURCE_LINE_ID_3	VARCHAR2	30			Code combination identifier derived by overlaying the account segment of the cash account to the expense account.
SOURCE_LINE_ID_4	VARCHAR2	30			This column is currently unused.
SOURCE_LINE_ID_5	VARCHAR2	30			This column is currently unused.
SOURCE_LINE_ID_6	VARCHAR2	30			This column is currently unused.
LINE_NUM	NUMBER		18		Code used to control the order in which budget lines are processed.
LEDGER_ID	NUMBER		18		Primary ledger of the transaction or distribution. Required when an associated ledger is available for the transaction or distribution.
BUSINESS_UNIT_ID	NUMBER		18		Business unit that owns the transaction or distribution. Required when an associated business unit is available for the transaction or distribution.
TRANSACTION_SUBTYPE_CODE	VARCHAR2	30			Payment subtype code. Used to allow enablement at a level lower than the transaction.
BUDGET_DATE	DATE				Date used for reserving funds for this distribution by budgetary control.
ACCOUNTING_DATE	DATE				Date used for accounting this distribution.
ENTERED_CURRENCY	VARCHAR2	15			This column stores the payment currency.
ENTERED_AMOUNT	NUMBER				This column stores the payment amount.
BUDGET_CODE_CONCAT_SEGS	VARCHAR2	800			New concatenated account segment derived by overlaying the account segment of the cash account to the expense account. Used to generate the code combination identifier if it's not already present.
CASH_CODE_COMBINATION_ID	NUMBER		18		Cash account code combination identifier for the bank account used during payment.
EXPENSE_CODE_COMBINATION_ID	NUMBER		18		Unique expense account code combination identifier of the invoice being paid.
PAYMENT_SERVICE_REQUEST_ID	NUMBER		18	Yes	Payment process request or quick payment request identifier.
CALL_APP_PAY_SERVICE_REQ_CODE	VARCHAR2	255			Payment process request or quick payment request code.

Indexes

Index	Uniqueness	Tablespace	Columns
IBY_XCC_EXTRACT_N1	Non Unique	Default	PAYMENT_SERVICE_REQUEST_ID
IBY_XCC_EXTRACT_N2	Non Unique	Default	NVL("SOURCE_LINE_ID_3",'N')
IBY_XCC_EXTRACT_N3	Non Unique	Default	SOURCE_HEADER_ID_1
IBY_XCC_EXTRACT_N4	Non Unique	Default	DATA_SET_ID