JG_FSCL_DOC_TYPES
This table contains Fiscal Document Types definitions to be used by fiscal document processing of Remittance Fiscal Document, Symbolic Remittance Fiscal Document and Sale Fiscal Document.
Details
-
Schema: FUSION
-
Object owner: JG
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
Name | Columns |
---|---|
JG_FSCL_DOC_TYPES_PK |
FISCAL_DOCUMENT_TYPE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
FISCAL_DOCUMENT_TYPE_ID | NUMBER | 18 | Yes | Fiscal document type identifier. | Active | |
FISCAL_DOC_TYPE | VARCHAR2 | 30 | Yes | Fiscal document type of the transaction. Valid values are Remittance Fiscal Document, Symbolic Remittance Fiscal Document, and Sale Fiscal Document. | Active | |
COUNTRY_CODE | VARCHAR2 | 2 | Yes | Country code for which the fiscal document type is defined. | Active | |
REFERENCE_FSCL_DOC_TYPE | VARCHAR2 | 30 | Fiscal document type that is used as a reference fiscal document when a reference to another fiscal document is required. For example, the symbolic remittance fiscal document needs to provide the details of the remittance fiscal document as the reference fiscal document. | Active | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
JG_FSCL_DOC_TYPES_U1 | Unique | FUSION_TS_TX_IDX | FISCAL_DOCUMENT_TYPE_ID | Active |
JG_FSCL_DOC_TYPES_U2 | Unique | FUSION_TS_TX_IDX | FISCAL_DOC_TYPE, COUNTRY_CODE | Active |