1. Tables and Views for Financials
  2. JG_FSCL_HDRS_ATRB_INT

JG_FSCL_HDRS_ATRB_INT

This interface table contains additional transaction header level attributes required for fiscal document. This table would be used with Fiscal Document Capture and Receivables applications to receive additional attributes for interfaced transactions.

Details

  • Schema: FUSION

  • Object owner: JG

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

JG_FSCL_HDR_ATRB_PK

INTERFACE_HDR_ID

Columns

Name Datatype Length Precision Not-null Comments Status
INTERFACE_HDR_ID NUMBER 18 Yes Interface header identifier of the document. Active
APP_SHORT_NAME VARCHAR2 30 Yes Application short name of the transaction. 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_NUMBER VARCHAR2 150 Yes Numeric identifier of a transaction. Active
FISCAL_DOC_DATE DATE Yes Date when fiscal document is issued. 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 Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 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
LOAD_REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. 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
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. 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
MAT_ISSUE_RECPT_DATE DATE Material issue or receipt date for the transaction. Active
MAT_ISSUE_RECPT_HOUR DATE Material issue or receipt hour for the transaction. Active
TEMP_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
COMMITMENT_STATEMENT_IDENT VARCHAR2 30 Statement of commitment identification. Active
PURCHASE_CONTRACT VARCHAR2 60 Purchase contract information for reporting to tax authority. Active
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.
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.
BATCH_NAME VARCHAR2 30 Identifies the set of records to be processed.
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.
FISCAL_DOC_KEY VARCHAR2 64 Fiscal document access key composed by concatenation of fiscal document number and other fiscal document information. It is used as unique identifier for the tax authority system.
DOC_NUM NUMBER 18 Unique number that is assigned to a document, such as fiscal document number or tax invoice number.
TRX_FD_TYPE_DETERMINANT VARCHAR2 30 Fiscal document type determinant, which indicates if single or multiple fiscal documents are required for a transaction.
TAX_AUTH_DOC_NUMBER NUMBER 18 Certificate number provided by the muncipality on payment of taxes.
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 of 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.
LEGAL_ENTITY_IDENTIFIER VARCHAR2 30 Unique number used to identify a legal entity; either manually set by the user or composed of the country of registration and the registration number of the identifying jurisdiction if automatically generated.
LEGAL_REP_UNIT_NAME VARCHAR2 240 Name of the legal reporting unit.
ORG_ID NUMBER 18 Indicates the identifier of the business unit associated to the row.
BU_NAME VARCHAR2 240 Indicates the name of the business unit associated to the row.
VENDOR_ID NUMBER 18 Identifier for the supplier associated to the payables transaction.
VENDOR_NUM VARCHAR2 30 Number to identify the supplier associated to the payables transaction.
VENDOR_NAME VARCHAR2 240 Name to identify the supplier associated to the payables transaction.
SERIES VARCHAR2 10 Tax document series, to be filled with zero when there is no series.
SERVICE_SERIES VARCHAR2 10 Fiscal document series for provisional receipt of services for the city tax authority.
BATCH_SOURCE_SEQ_ID NUMBER 18 Batch source sequence identifier.
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.
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_INT_N1 Non Unique Default APP_SHORT_NAME, ORG_ID, BATCH_NAME, FISCAL_DOC_DATE, TRX_NUMBER
JG_FSCL_HDRS_ATRB_INT_N2 Non Unique Default REQUEST_ID
JG_FSCL_HDRS_ATRB_INT_U1 Unique FUSION_TS_TX_IDX INTERFACE_HDR_ID Active
JG_FSCL_HDRS_ATRB_INT_U2 Unique FUSION_TS_TX_IDX APP_SHORT_NAME, ENTITY_CODE, EVENT_CLASS_CODE, TRX_NUMBER Active