CMF_FISCAL_PROC_OPTIONS
This entity maintains a set of default options that determines how FDC system should work
Details
-
Schema: FUSION
-
Object owner: CMF
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
CMF_FISCAL_PROC_OPTIONS_PK |
FISCAL_PROC_OPTIONS_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| FISCAL_PROC_OPTIONS_ID | NUMBER | 18 | Yes | Identifier of fiscal process option | |
| PROCESS_OPTION_CODE | VARCHAR2 | 50 | Yes | Process Option Code represents the type of process | |
| COUNTRY_CODE | VARCHAR2 | 30 | Yes | Code of country where category is defined. It defines the country owner of the current record (E.g.: BR). | |
| DOCUMENT_TYPE_CODE | VARCHAR2 | 30 | Yes | Code of type of Fiscal Document. E.g.: Sales FD, Remittance FD, Complementary of Sales FD | |
| PROCESS_CODE | VARCHAR2 | 30 | Yes | Code of process flow in which a FD is involved. E.g.: Standard process, RMA, Drop Shipment | |
| FD_USAGE | VARCHAR2 | 30 | Yes | Fd usage will be like material pr freight | |
| ADDITIONAL_MATCH_RULE | VARCHAR2 | 2000 | Yes | It stores part of a SQL condition used for selecting Fiscal | |
| SOURCE_DOCUMENT_TYPE_CODE | VARCHAR2 | 30 | Yes | It defines the LOV for the Lines Tab while the type is referenced | |
| LINE_SRC_DOC_TYPE_CODE | VARCHAR2 | 30 | Yes | It points also to the original document that supports FD as well as Source Document Type Code. But a list of its possible values is limited by the value of Source Document Type. | |
| FD_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Code of currency of Fiscal Document | |
| SRC_DOC_CURRENCY_CODE | VARCHAR2 | 30 | Indicates whether Source Document currency and FD currency are the same or not. Possible values: - SAME_FD_CURR - OTHER_CURR | ||
| OPERATION_TYPE | VARCHAR2 | 1 | Yes | The types are: 0 ? Inbound 1 ? Outbound | |
| ELECTRONIC_MODEL | VARCHAR2 | 2000 | Yes | It is a list of the model codes that are considered as "electronic" | |
| SERIES_REQ | VARCHAR2 | 30 | Yes | Possible values are: NOT USED, ELECTRONIC, NOT ELECTRONIC, ALL | |
| SUB_SERIES_REQ | VARCHAR2 | 30 | Yes | Possible values are: NOT USED, ELECTRONIC, NOT ELECTRONIC, ALL | |
| FD_HEADER_LINE_RELATIONSHIP | VARCHAR2 | 10 | Yes | Determines how many lines the current FD can have | |
| ISSUER_TYPE | VARCHAR2 | 30 | Yes | Defines if the entity is a Third Party (Supplier or Customer) or an LE | |
| RECEIVER_TYPE | VARCHAR2 | 30 | Yes | Defines if the entity is a Third Party (Supplier or Customer) or an LE. | |
| SHIP_FROM_TYPE | VARCHAR2 | 30 | Defines if the entity is a Third Party (Supplier or Customer) or an LE. | ||
| SHIP_TO_TYPE | VARCHAR2 | 30 | Yes | Defines if the entity is a Third Party (Supplier or Customer) or an LE. | |
| UPDATE_REF_PHYSICAL_RECEIPT | VARCHAR2 | 1 | Yes | updates the Father's Physical Receipt information | |
| MANUAL_PR_QTTY_ENTRY_FLAG | VARCHAR2 | 1 | Yes | checks if it allows manual phy receipt | |
| PHYSICAL_RECPT_BY_ORDER_FD | VARCHAR2 | 1 | Yes | When "Y", the Physical Receipt Quantity will be derived from the referencing document. If more than a FD is found, the quantity should be summarized. | |
| COMPLEMENTARY_FLAG | VARCHAR2 | 1 | Yes | It defines whether the current FD is a Complementary FD (Tax, Price, or Quantity) or not. | |
| PARENT_PROCESS_OPT_ID | NUMBER | 18 | Identifier of parent process option | ||
| COMPLEMENTARY_LINE_TYPE | VARCHAR2 | 30 | it defines which types of complementary lines are allowed | ||
| CHARGE_ALLOCATION_FLAG | VARCHAR2 | 1 | Yes | Defines if the current FD is allowed having charges | |
| CHARGES_DISTRIBUTION_FLAG | VARCHAR2 | 1 | Yes | determine the behaviour of the charges Allocation UI | |
| INFORMATIVE_CHARGES | VARCHAR2 | 60 | Used to determine which charges will be only informative and will not be passed through any interface. | ||
| REFERENCE_ALLOWED_FLAG | VARCHAR2 | 1 | Yes | It goes along with Referenced FD Type element saying when the FD can reference another document | |
| CHARGE_ALLOCATION_1_FLAG | VARCHAR2 | 1 | Yes | If "Y", allows the Charge Allocation for the current FD. | |
| TAX_CALCULATION_FLAG | VARCHAR2 | 1 | Yes | If "Y", allows the Tax Calculation for the current FD. | |
| FISCAL_ATTRIBUTES_FLAG | VARCHAR2 | 1 | Yes | If "Y", allows the access for Fiscal attributes for the current FD | |
| LEGAL_PROCESSES_FLAG | VARCHAR2 | 1 | Yes | If "Y", allows the access to inform legal processes for the current FD. | |
| VALIDATION_FLAG | VARCHAR2 | 1 | Yes | If "Y", allows the Tolerance Validation for the current FD | |
| VALIDATE_REF_DOC_FLAG | VARCHAR2 | 1 | For related documents that depend from each other to be validated it is possible through this information to determine an automatic validation for the related document | ||
| HOLD_MGMT_FLAG | VARCHAR2 | 1 | If "Y", allows the Holds Management for the current FD | ||
| CHANGE_DOC_STATUS_FLAG | VARCHAR2 | 1 | Yes | If "Y", allows the UI Change Status function. | |
| DELETE_ALLOWED_FLAG | VARCHAR2 | 1 | Yes | If "Y", it will enable the UI Delete button. | |
| IFACE_RCV_FLAG | VARCHAR2 | 1 | Yes | If "Y", allows the Receiving Interface for the current FD | |
| IFACE_AP_FLAG | VARCHAR2 | 1 | Yes | If "Y", allows the Payables Interface for the current FD. | |
| PAYABLES_DOC_TYPE_CODE | VARCHAR2 | 30 | When there is the interface with payables for a fiscal document this attribute will be used to define the type of Invoice to be created | ||
| MATCH_REF_PREPAYMENT_FLAG | VARCHAR2 | 1 | Defines if the prepayments created at the entry of referenced FDs will be matched to the invoice being created by current FD | ||
| IFACE_CST_FLAG | VARCHAR2 | 1 | Yes | If "Y", allows the Costing Interface for the current FD. | |
| COST_DISTRIBUTION | VARCHAR2 | 30 | Yes | Defines if the current FD CST Iface decision is based on the current FD itself or in the referenced FD | |
| START_DATE | DATE | Yes | Start of period when process option is valid | ||
| END_DATE | DATE | End of period when process option is valid | |||
| 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_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. | ||
| 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. | |
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| COMPLEMENTARY_TYPE_MANUAL_PR | VARCHAR2 | 80 | Indicates the complementary types that require manual physical receipt quantity | ||
| EXCLUDED_TAXES_FROM_MISC_CHRGE | VARCHAR2 | 80 | Defines the taxes to be removed from the miscelaneous charge amount being interfaced to other products | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| CMF_FISCAL_PROC_OPTIONS_PK | Unique | Default | FISCAL_PROC_OPTIONS_ID, ORA_SEED_SET1 | |
| CMF_FISCAL_PROC_OPTIONS_PK1 | Unique | Default | FISCAL_PROC_OPTIONS_ID, ORA_SEED_SET2 | |
| CMF_FISCAL_PROC_OPTIONS_U1 | Unique | Default | COUNTRY_CODE, FISCAL_PROC_OPTIONS_ID | Obsolete |
| CMF_FISCAL_PROC_OPTIONS_U2 | Unique | Default | COUNTRY_CODE, PROCESS_OPTION_CODE, ORA_SEED_SET1 | |
| CMF_FISCAL_PROC_OPTIONS_U21 | Unique | Default | COUNTRY_CODE, PROCESS_OPTION_CODE, ORA_SEED_SET2 |