CMF_FISCAL_DOC_DISTRIBUTIONS

Details

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

Primary Key

Name	Columns
CMF_FISCAL_DOC_DISTS_PK	FISCAL_DOC_DISTRIBUTION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
FISCAL_DOC_DISTRIBUTION_ID	NUMBER		18	Yes	Identifier of Fiscal Document Distribution.
FISCAL_DOC_SCHEDULE_ID	NUMBER		18	Yes	Identifier of Fiscal Document Schedule.
FISCAL_DOC_LINE_ID	NUMBER		18	Yes	Indicates sequence for each line under each Fiscal Document Header.
FISCAL_DOC_HEADER_ID	NUMBER		18	Yes	Indicates the Document Header of the line.
REF_FISCAL_DOC_HEADER_ID	NUMBER		18		Indicates Reference Document Header identifier.
REF_FISCAL_DOC_LINE_ID	NUMBER		18		Indicates Reference Document Line Identifier.
REF_FISCAL_DOC_SCHEDULE_ID	NUMBER		18		Indicates Reference Document Schedule identifier.
DISTRIBUTION_NUM	NUMBER				Fiscal Document Distribution number.
SOURCE_DOC_ID1	NUMBER		18		Internal Ids to locate the source document. Example: PO Header Id for PO.
SOURCE_DOC_ID2	NUMBER		18		Internal Ids to locate the source document line. Example: PO Line Id for PO.
SOURCE_DOC_ID3	NUMBER		18		Internal Ids to locate the source document schedule. Example: PO Schedule Id for PO.
SOURCE_DOC_ID4	NUMBER		18		Internal Ids to locate the source document distribution. Example: PO Distribution Id for PO.
SHIPPING_UOM_CODE	VARCHAR2	20			Unit of measure that the supplier is requested to ship in.
CONSUMED_QTY	NUMBER				Supplier consigned Inventory consumed quantity.
CONSUMED_AMOUNT	NUMBER				Transaction Amount in purchase order currency. Applicable for fixed price lines.
SECONDARY_UOM_CODE	VARCHAR2	20			The secondary unit of measure code of the inventory item at the fiscal document schedule from the source document.
SECONDARY_UOM_CONSUMED_QTY	NUMBER				The schedule allocated quantity in the secondary unit of measure of the inventory item.
DESTINATION_TYPE_CODE	VARCHAR2	25			This column stores the destination type code when the receiving transaction is created.
DESTINATION_ORGANIZATION_ID	NUMBER		18		This column stores Receiving organization unique identifier where the receiving transaction is created.
DESTINATION_SUBINVENTORY	VARCHAR2	10			This column stores the destination subinventory name for the receiving transaction.
RCV_TRANSACTION_ID	NUMBER		18		This column stores the unique identifier for the current receiving transaction row.
RECEIPT_NUM	VARCHAR2	30			This column stores the receipt number.
RECEIPT_LINE_NUM	NUMBER		18		This column will store the line number corresponding to the receipt.
TRANSACTION_TYPE	VARCHAR2	25			Receiving transaction type. References FND_LOOKUP_VALUES_B.LOOKUP_CODE, where lookup_type is RCV_TRANSACTION_TYPE.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
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.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
CMF_FISCAL_DOC_DISTS_N1	Non Unique	Default	FISCAL_DOC_SCHEDULE_ID, RCV_TRANSACTION_ID
CMF_FISCAL_DOC_DISTS_U1	Unique	Default	FISCAL_DOC_DISTRIBUTION_ID