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_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, 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 | 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 | 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 | Who column: indicates the date and time of the creation of the row. | Active | |||
CREATED_BY | VARCHAR2 | 64 | 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 | ||
AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | |||
AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | |||
AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
JG_FSCL_DOC_TYPES_N1_ | Non Unique | Default | FISCAL_DOCUMENT_TYPE_ID | |
JG_FSCL_DOC_TYPES_U1_ | Unique | FUSION_TS_TX_IDX | LAST_UPDATE_DATE, LAST_UPDATED_BY, FISCAL_DOCUMENT_TYPE_ID | Active |