1. Tables and Views for Financials
  2. JG_FSCL_DOC_HDRS_ALL

JG_FSCL_DOC_HDRS_ALL

This table contains transaction header level attributes required for generating fiscal document. Product teams would populate this table with their transaction header attributes prior to calling the fiscal document generation process.

Details

  • Schema: FUSION

  • Object owner: JG

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

JG_FSCL_DOC_HEADER_PK

DOC_HDR_ID

Columns

Name Datatype Length Precision Not-null Comments Status
DOC_HDR_ID NUMBER 18 Yes Carrier or party site identifier that provided freight services for shipment. 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_DATE DATE Yes Date on which the transaction occurred. Active
TRX_CURRENCY_CODE VARCHAR2 15 The three-letter ISO (International Organization for Standardization) code associated with a currency of the transaction. Active
CURRENCY_CONVERSION_DATE DATE The date as of which a conversion rate is used to convert an amount into another currency. Active
CURRENCY_CONVERSION_RATE NUMBER Exchange rate at which the principal unit of one currency can be converted into another currency. Active
CURRENCY_CONVERSION_TYPE VARCHAR2 30 Source of a currency conversion rate, such as user defined, spot, or corporate. Active
TRX_FD_TYPE_DETERMINANT VARCHAR2 30 Fiscal document type determinant, which indicates if single or multiple fiscal documents are required for a transaction. Active
PO_NUMBER VARCHAR2 60 Number of a commercial document that is used to request a seller to supply a product or service in return for payment. Active
FREIGHT_PARTY_ID NUMBER 18 Carrier or party who provided freight service for the shipment. Active
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row. Active
EVENT_TYPE_CODE VARCHAR2 30 Yes Application event type for the transaction. Active
TRX_LEVEL_TYPE VARCHAR2 30 Yes Column to record the level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. Active
HDR_TRX_USER_KEY1 VARCHAR2 150 First component of the user composite key to uniquely identify the transaction. Active
HDR_TRX_USER_KEY2 VARCHAR2 150 Second component of the user composite key to uniquely identify the transaction. Active
HDR_TRX_USER_KEY3 VARCHAR2 150 Third component of the user composite key to uniquely identify the transaction. Active
HDR_TRX_USER_KEY4 VARCHAR2 150 Fourth component of the user composite key to uniquely identify the transaction. Active
HDR_TRX_USER_KEY5 VARCHAR2 150 Fifth component of the user composite key to uniquely identify the transaction. Active
HDR_TRX_USER_KEY6 VARCHAR2 150 Sixth component of the user composite key to uniquely identify the transaction. Active
LEDGER_ID NUMBER 18 Yes Ledger identifier for the self-contained accounting information set for single or multiple legal or management entities. Active
MINIMUM_ACCOUNTABLE_UNIT NUMBER Minimum accountable unit of the entered currency. Active
PRECISION NUMBER Precision of the transaction currency. Active
LEGAL_ENTITY_ID NUMBER 18 Yes Legal entity identifier for the transaction. Active
ESTABLISHMENT_ID NUMBER 18 Establishment identifier of the first party associated with the transaction. Active
DEFAULT_TAXATION_COUNTRY VARCHAR2 2 Country where the transaction is deemed to have taken place for taxation purposes. Active
TRX_NUMBER VARCHAR2 150 Numeric identifier of a transaction. Active
TRX_DESCRIPTION VARCHAR2 240 Description of the transaction. Active
TRX_COMMUNICATED_DATE DATE Printed or Received date of the transaction. Active
TRX_DUE_DATE DATE Payment due date of the transaction. Active
DOCUMENT_SUB_TYPE VARCHAR2 240 Set up document fiscal classifications to classify transactions that require special documentation to accompany the transaction, as designated by the tax authority. Active
SUPPLIER_TAX_INVOICE_NUMBER VARCHAR2 150 Transaction number on the supplier tax invoice. Active
SUPPLIER_TAX_INVOICE_DATE DATE Transaction date on the supplier tax invoice. Active
TAX_INVOICE_DATE DATE Transaction date for tax invoice generated by Receivables. Active
TAX_INVOICE_NUMBER VARCHAR2 150 Number for tax invoice generated by Receivables. Active
RELATED_DOC_APPLICATION_ID NUMBER 18 Related document application identifier. Active
RELATED_DOC_ENTITY_CODE VARCHAR2 30 Transaction type of the related document. Active
RELATED_DOC_EVENT_CLASS_CODE VARCHAR2 30 Related document event class code. Active
RELATED_DOC_TRX_ID NUMBER 18 Primary transaction identifier of the related document. Active
REL_DOC_HDR_TRX_USER_KEY1 VARCHAR2 150 First component of the user composite key for uniquely identifying the related document. Active
REL_DOC_HDR_TRX_USER_KEY2 VARCHAR2 150 Second component of the user composite key for uniquely identifying the related document. Active
REL_DOC_HDR_TRX_USER_KEY3 VARCHAR2 150 Third component of the user composite key for uniquely identifying the related document. Active
REL_DOC_HDR_TRX_USER_KEY4 VARCHAR2 150 Fourth component of the user composite key for uniquely identifying the related document. Active
REL_DOC_HDR_TRX_USER_KEY5 VARCHAR2 150 Fifth component of the user composite key for the uniquely identifying related document. Active
REL_DOC_HDR_TRX_USER_KEY6 VARCHAR2 150 Sixth component of the user composite key for the uniquely identifying related document. Active
RELATED_DOC_NUMBER VARCHAR2 150 Transaction number of the related document. Active
RELATED_DOC_DATE DATE Document date of the related transaction. Active
HDR_GL_DATE DATE Transaction header level accounting date. 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
RNDG_BILL_FROM_PARTY_SITE_ID NUMBER 18 Party site identifier for the bill-from party site of the transaction used for rounding of tax amounts. Active
RNDG_BILL_TO_PARTY_SITE_ID NUMBER 18 Party site identifier for the bill-to party site of the transaction used for rounding of tax amounts. Active
RNDG_SHIP_FROM_PARTY_SITE_ID NUMBER 18 Party site identifier for the ship-from party site of the transaction used for rounding of tax amounts. Active
RNDG_SHIP_TO_PARTY_SITE_ID NUMBER 18 Party site identifier for the ship-to party site of the transaction used for rounding of tax amounts. Active
ROUNDING_BILL_FROM_PARTY_ID NUMBER 18 Party identifier for the bill-from party of the transaction used for rounding of tax amounts. Active
ROUNDING_BILL_TO_PARTY_ID NUMBER 18 Party identifier for the bill-to party of the transaction used for rounding of tax amounts. Active
ROUNDING_SHIP_FROM_PARTY_ID NUMBER 18 Party identifier for the ship-from party of the transaction used for rounding of tax amounts. Active
ROUNDING_SHIP_TO_PARTY_ID NUMBER 18 Party identifier for the ship-to party of the transaction used for rounding of tax amounts. Active
FREIGHT_SERVICE_VALUE NUMBER Freight service value charged by the carrier responsible for the transportation of goods. 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
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.
FREIGHT_PARTY_SITE_ID NUMBER 18 Carrier or party site that provided freight services for shipment.
SEAL_NUMBER VARCHAR2 60 Seal number on the freight invoice of the transporter.
PORT_OF_ENTRY_CODE VARCHAR2 30 Location code where foreign goods are cleared through a custom house.
PROVNL_TAX_DETERMINATION_DATE DATE Transaction date of the original transaction in case of lease management when a lease contract is revised.
TRX_BATCH_ID NUMBER 18 Transaction batch identifier in a table.
RECEIPT_SOURCE_CODE VARCHAR2 25 Source type of a shipment associated with a transaction.
FSCL_DOC_COMPLETION_FLAG VARCHAR2 1 Indicates whether the transaction can be completed before the fiscal document is generated. Valid values are Y and N.

Indexes

Index Uniqueness Tablespace Columns Status
JG_FSCL_DOC_HDRS_U1 Unique FUSION_TS_TX_IDX DOC_HDR_ID Active
JG_FSCL_DOC_HDRS_U2 Unique FUSION_TS_TX_IDX APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID Active