CMF_FISCAL_DOC_SCHEDULES
This table will store Fiscal Document Schedule information.
Details
-
Schema: FUSION
-
Object owner: CMF
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CMF_FISCAL_DOC_SCHEDULES_PK |
FISCAL_DOC_SCHEDULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| FISCAL_DOC_SCHEDULE_ID | NUMBER | 18 | Yes | Identifier of Fiscal Document Schedule. | |
| USER_EXCHANGE_RATE | NUMBER | User entered rate of conversion to the currency of source document PO. | |||
| SOURCE_REF_DOC_LINE_ID | NUMBER | 18 | Identifies a line in the source document related to this fiscal document header. Example: shipment line associated with ASN/ASNB in case of drop ship seller flow or consumption advice line in case of consigned flow. | ||
| SD_UOM_CODE | VARCHAR2 | 3 | Stores source document UOM code. | ||
| SFO_AGREEMENT_FTR_ID | NUMBER | 18 | Stores supply chain financial agreement ID. | ||
| SD_PRICE_CURRENCY | VARCHAR2 | 15 | Source Document price currency value will be stored in this field. | ||
| SCHEDULE_NUMBER | NUMBER | Number of Schedule in a Fiscal Document 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. | |
| 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. | ||
| FISCAL_DOC_HEADER_ID | NUMBER | 18 | Yes | Indicates the Document Header of the line. | |
| FISCAL_DOC_LINE_ID | NUMBER | 18 | Yes | Indicates sequence for each line under each Fiscal Document Header. | |
| SOURCE_DOC_TYPE | VARCHAR2 | 30 | Yes | Stores type of source document for the line(PO/IMT/RMA). | |
| 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. | ||
| RECEIVED_QTY | NUMBER | Physically received quantity for a schedule. | |||
| RECEIPT_NUM | VARCHAR2 | 30 | Receipt number generated by the receiving. | ||
| SD_PRICE | NUMBER | This column will record the source document price. | |||
| ALLOCATED_QTY_IN_FDL_UOM | NUMBER | The schedule allocated quantity in the fiscal document transaction UOM. | |||
| SD_SECONDARY_UOM_CODE | VARCHAR2 | 30 | The secondary unit of measure code of the inventory item at the fiscal document schedule from the source document. | ||
| ALLOC_QTY_IN_SD_SECONDARY_UOM | NUMBER | The schedule allocated quantity in the secondary unit of measure of the inventory item. | |||
| RECEIVING_ORGANIZATION_ID | NUMBER | 18 | The Organization identifier of the receiving location from the source document. | ||
| ALLOCATED_AMOUNT | NUMBER | Allocated amount for a schedule. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CMF_FISCAL_DOC_SCHEDULES_N1 | Non Unique | Default | SOURCE_DOC_TYPE, SOURCE_DOC_ID1, SOURCE_DOC_ID2, SOURCE_DOC_ID3 |
| CMF_FISCAL_DOC_SCHEDULES_N2 | Non Unique | Default | FISCAL_DOC_LINE_ID |
| CMF_FISCAL_DOC_SCHEDULES_U1 | Unique | Default | FISCAL_DOC_SCHEDULE_ID |