CMF_FD_SCHEDULES_INT
Stores the fiscal document schedules information which are being interfaced.
Details
-
Schema: FUSION
-
Object owner: CMF
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
CMF_FD_SCHEDULES_INT_PK |
FD_SCHEDULES_INT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| FD_SCHEDULES_INT_ID | NUMBER | 18 | Yes | Identifier of the Fiscal Document Schedule which is being interfaced. | |
| FD_LINES_INT_ID | NUMBER | 18 | Yes | Identifier of the Fiscal Document Line which is being interfaced. | |
| FD_HEADERS_INT_ID | NUMBER | 18 | Yes | Identifier of the Fiscal Document Header which is being interfaced. | |
| DOCUMENT_SCHEDULE_ID | NUMBER | 18 | Yes | Identifier of the Fiscal Document Schedule which is being interfaced. | |
| DOCUMENT_LINE_ID | NUMBER | 18 | Yes | Identifier of the Fiscal Document Line which is being interfaced. | |
| DOCUMENT_HEADER_ID | NUMBER | 18 | Yes | Identifier of the Fiscal Document Header which is being interfaced. | |
| SCHEDULE_NUMBER | NUMBER | Indicates the sequence of schedule numbers for 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. | |
| SOURCE_DOC_TYPE | VARCHAR2 | 30 | Yes | Indicates the type of Source Document for the line like PO, IMT, RMA. | |
| SOURCE_DOC_ID1 | NUMBER | 18 | Internal Ids to locate the source document. E.g. PO Header Id for PO | ||
| SOURCE_DOC_ID2 | NUMBER | 18 | Internal Ids to locate the source document. E.g. PO Line Id for PO | ||
| SOURCE_DOC_ID3 | NUMBER | 18 | Internal Ids to locate the source document. E.g. PO Schedule Id for PO | ||
| RECEIVED_QTY | NUMBER | Allocated quantity from the source document for a schedule will be stored in this column. | |||
| RECEIPT_NUM | VARCHAR2 | 30 | Receipt number generated by the receiving will be stored in this column. | ||
| SD_PRICE | NUMBER | This column will store the price information from the source document. | |||
| SD_UOM_CODE | VARCHAR2 | 3 | This column will store the UOM code from the source document. | ||
| SD_PRICE_CURRENCY | VARCHAR2 | 15 | This column will store the price currency from the source document. | ||
| USER_EXCHANGE_RATE | NUMBER | This column will store the user exchange rate from the source document. | |||
| SOURCE_REF_DOC_LINE_ID | NUMBER | 18 | Identifies a line in the source document related to this fiscal document header. E.g. shipment line associated with ASN/ASNB in case of drop ship seller flow or consumption advice line in case of consigned flow. | ||
| 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. | ||
| ALLOC_QTY_IN_SD_SECONDARY_UOM | NUMBER | The schedule allocated quantity in the secondary unit of measure of the inventory item. | |||
| 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. | ||
| ALLOCATED_QTY_IN_FDL_UOM | NUMBER | The schedule allocated quantity in the fiscal document transaction UOM. | |||
| RECEIVING_ORGANIZATION_ID | NUMBER | 18 | The Organization identifier of the receiving location from the source document. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CMF_FD_SCHEDULES_INT_U1 | Unique | Default | FD_SCHEDULES_INT_ID |