1. Tables and Views for Financials
  2. JG_FSCL_HDRS_ATRB_EXT_ALL

JG_FSCL_HDRS_ATRB_EXT_ALL

This table contains additional transaction header level attributes required for generating fiscal document. These attributes are populated through the UI component provided by Fiscal Document Generation (FDG). For inbound fiscal document, this table is populated by the FDG process once the document is successfully validated.

Details

  • Schema: FUSION

  • Object owner: JG

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

JG_FSCL_HDR_ATRB_EXT_PK

DOC_EXT_HDR_ID

Columns

Name Datatype Length Precision Not-null Comments Status
DOC_EXT_HDR_ID NUMBER 18 Yes Document extension header identifier. Active
APPLICATION_ID NUMBER 18 Yes Identifier of a functional area within a software suite of products. For example: Financials, or Payroll. Active
ENTITY_CODE VARCHAR2 30 Yes Entity code of the transaction, which indicates the type of transaction being created. Active
EVENT_CLASS_CODE VARCHAR2 30 Yes Application event class of the transaction, such as requisition, purchase order and agreement, and release. Active
TRX_ID NUMBER 18 Yes System-generated identification number of a transaction. Active
TRX_NUMBER VARCHAR2 150 Yes Numeric identifier of a transaction. Active
MAT_ISSUE_RECPT_DATE DATE Material issue or receipt date for the transaction. Active
SERVICE_TYPE VARCHAR2 5 Type of service document provided in the associated transaction such as RPS for regular service FD, RPS-M for Mixed FD and RPS-C for Fiscal Coupon related FD. Active
FREIGHT_TYPE VARCHAR2 2 Type of freight applicable to the fiscal document. Active
PAYMENT_OPTION VARCHAR2 30 Payment option of the transaction. Valid values are 0 for cash payment, 1 for installment payment, and 2 for others. Active
WAGON_IDENTIFICATION VARCHAR2 30 Wagon identification for freight invoices. Active
FERRY_IDENTIFICATION VARCHAR2 30 Ferry identification for freight invoices. Active
QUANTITY_CARRIED NUMBER Quantity of goods carried, such as number of boxes. Active
GOODS_TYPE_CARRIED VARCHAR2 60 Type of carried goods applicable for freight invoice. Active
GOODS_BRAND_CARRIED VARCHAR2 60 Brand of carried goods applicable for freight invoice. Active
CONTAINER_IDENTIFIER NUMBER Unique identifier for a container of carried goods. Active
NET_WEIGHT NUMBER Net weight recorded in kilograms. Active
GROSS_WEIGHT NUMBER Gross weight measured in kilograms. Active
SEAL_NUMBER VARCHAR2 60 Seal number provided in freight invoice of the transporter. Active
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row. Active
COMMITMENT_STATEMENT_IDENT VARCHAR2 30 Statement of commitment identification. Active
PURCHASE_CONTRACT VARCHAR2 60 Purchase contract information for reporting to tax authority. 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
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
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. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
MAT_ISSUE_RECPT_HOUR DATE Material issue or receipt hour of the transaction.
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
INDUSTRY_TYPE VARCHAR2 30 A unique identifier of the industry associated with the transaction.
SERIES VARCHAR2 10 Tax document series, to be filled with zero when there is no series.
FISCAL_DOC_DATE DATE Date when the fiscal document is issued.
DOC_NATURE VARCHAR2 30 Fiscal document nature. Possible values are 1 for standard, 2 for complementary, and 3 for adjustment.
SERVICE_SITUATION VARCHAR2 30 Operation situation code under the simplified taxation system.
LEGAL_REPORTING_UNIT_ID NUMBER 18 Legal reporting unit identifier.
CONTINGENCY_TYPE VARCHAR2 2 The fiscal document contingency type. Valid values are Security Form, Contingency System of National Environment, and Declaration of Issuance Provided in Contingency.
FREIGHT_PARTY_SITE_ID NUMBER 18 Carrier or party site identifier that provided freight services for shipment.
TRX_FD_TYPE_DETERMINANT VARCHAR2 30 Fiscal document type determinant, which indicates if single or multiple fiscal documents are required for a transaction.
REF_DOC_NUM NUMBER 18 Reference document number of the transaction.
REF_FISCAL_DOC_KEY VARCHAR2 50 Key identifier for a reference fiscal document.
REF_FISCAL_DOC_DATE DATE Date on which the reference transaction occurred.
REF_MODEL VARCHAR2 3 Model for the fiscal document associated with the reference transaction.
REF_SERIES VARCHAR2 10 Tax document series of the reference document.
REF_DOC_ISSUER_STATE_CODE VARCHAR2 30 State code for the reference document issuer.
REF_ISSUER_TAXPAYER_ID VARCHAR2 30 Tax registration identifier for the reference document taxpayer.
REF_RURAL_FLAG VARCHAR2 1 Y or N indicates whether the reference document was issued in rural area.
REF_COMPLEMENTARY_FD_FLAG VARCHAR2 1 Y or N indicates whether the reference document is fiscal document where document nature is complementary and issued for correction of the original fiscal document.
SERVICE_TAX_PAID_FLAG VARCHAR2 1 Y or N indicates whether ISS tax has been paid to the municipality.
TAX_SETTLEMENT_DATE DATE Date on the certificate provided by the muncipality on payment of taxes.
WHT_SOCIAL_INTG_PROG_AMT NUMBER Total withheld amount of contribution for the social integration program.
WHT_SS_FINANCING_AMT NUMBER Total withheld amount of contribution for the social security financing.
SERVICE_SERIES VARCHAR2 10 Tax document series for services fiscal documents.
FSCL_ATTRIB_TEMPLATE_CODE VARCHAR2 30 The default template to be used for the defaulting fiscal attributes.
ACCOUNTING_REQD_FLAG VARCHAR2 1 Indicates whether the Fiscal Document should be accounted for on the tax authority approval.
ISSUING_PURPOSE_CODE VARCHAR2 30 Issuing purpose for a communication service fiscal document. Values include Regular, Adjustment, Substitution.
BILLING_TYPE_CODE VARCHAR2 30 Billing type used in a communication service fiscal document. Values include Regular, Centralized or Co-billing.
APPROVER_SITE_CODE VARCHAR2 30 Tax authority approver site used for a communication service fiscal document approval.
REF_HASH_CODE VARCHAR2 64 Hash code stamped on an approved fiscal document model 21 so that a new communication fiscal document may replace it to correct issues.
REF_SUBSTITUTION_REASON VARCHAR2 240 Free text field for the user to provide the reason for substitution.
SUBSTITUTION_OPTION_CODE VARCHAR2 30 Indicates if a transaction is a substitution or sustituted fiscal document.
REF_SOURCE_TYPE_CODE VARCHAR2 30 The source type of a fiscal document used as a reference.

Indexes

Index Uniqueness Tablespace Columns Status
JG_FSCL_HDRS_ATRB_EXT_U1 Unique FUSION_TS_TX_IDX DOC_EXT_HDR_ID Active
JG_FSCL_HDRS_ATRB_EXT_U2 Unique FUSION_TS_TX_IDX APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID Active