1. Tables and Views for Financials
  2. JE_FR_DAS2_VEN_SUMMARY_T

JE_FR_DAS2_VEN_SUMMARY_T

Five digits (from tenth position) of Tax Registration Number of Legal Entity and Legal Reporting Unit

Details

  • Schema: FUSION

  • Object owner: JE

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

JE_FR_DAS2_VEN_SUMMARY_T_PK

VEN_SUMMARY_ID

Columns

Name Datatype Length Precision Not-null Comments
LEGAL_ENTITY_ID NUMBER 18 Yes Legal entity identifier
LOCATION_PROFILE_ID NUMBER 18 Trading community architecture location profile identifier
VEN_SUMMARY_ID NUMBER 18 Yes Vendor Summary Id
PROGRAM_NAME VARCHAR2 30 Identifies the concurrent program
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PROGRAM_APP_NAME VARCHAR2 50 Identifies the Application name spawning the Concurrent Request
ESTABLISHMENT_ID NUMBER 18 Yes Establishment identifier
SIREN_ETAB NUMBER 9 1st nine digits of tax registration number of Legal Entity
NIC_ETAB NUMBER 5 Five digits (from tenth position) of Tax Registration Number of Legal Entity and Legal Reporting Unit
SECTION_DAS VARCHAR2 2 String "00"
VALIDITE NUMBER 4 Value entered for the year parameter of the French DAS2 Verification report
TYPE_DAS VARCHAR2 1 String "4" or "5"
TYPE_ENREG VARCHAR2 3 String "210"
SIRET_BENEF VARCHAR2 14 Tax Identification Number. First 14 digits from the Tax Registration number
NOM VARCHAR2 30 Last name of supplier contact
PRENOM VARCHAR2 20 First name of supplier contact
RAISON_SOCIALE VARCHAR2 50 Supplier name
PROFESSION VARCHAR2 30 Type of minority-owned business of supplier
ADR_COMPL VARCHAR2 32 1st address line of supplier site
Z1 VARCHAR2 1 Space
ADR_NUM VARCHAR2 4 Space
ADR_TYPE VARCHAR2 1 Space
Z2 VARCHAR2 1 Space
ADR_VOIE VARCHAR2 26 Space
ADR_INSEE VARCHAR2 5 String "00000"
Z3 VARCHAR2 1 Space
ADR_COMMUNE VARCHAR2 26 City of supplier site address
ADR_CPOSTAL VARCHAR2 5 Postal code of supplier site address
Z4 VARCHAR2 1 Space
ADR_BUR_DIST VARCHAR2 26 City of supplier site address
DHON_H NUMBER 10 Sum of amounts or base amounts for the income tax type
DCOM_C NUMBER 10 Sum of amounts or base amounts for the income tax type
DCO_CO NUMBER 10 Sum of amounts or base amounts for the income tax type
DRIS_R NUMBER 10 Sum of amounts or base amounts for the income tax type
DJE_JP NUMBER 10 Sum of amounts or base amounts for the income tax type
DDA_DA NUMBER 10 Sum of amounts or base amounts for the income tax types
DDI_I NUMBER 10 Sum of amounts or base amounts for the income tax type
DAU_AR NUMBER 10 Sum of amounts or base amounts for the income tax type
INDE NUMBER 10 Sum of amounts or base amounts for income tax types "INDE/R", "INDE/F" and "INDE/P"
AVAN NUMBER 10 Sum of amounts or base amounts for income tax types "AVAN/A", "AVAN/N","AVAN/L" and "AVAN/V"
RETE NUMBER 10 Sum of amounts or base amounts for income tax types "RETE/", "RETE/D" and "RETE/R"
NAT_AVAN_NOUR VARCHAR2 1 If the amount is paid for the income tax type
NAT_AVAN_LOGE VARCHAR2 1 If the amount is paid for the income tax type
NAT_AVAN_VOIT VARCHAR2 1 If the amount is paid for the income tax type
NAT_AVAN_AUTR VARCHAR2 1 Value entered for the year parameter of the French DAS2 Verification report
Z5 VARCHAR2 1 Space
NAT_RETE_ALLO VARCHAR2 1 If the amount is paid for the income tax type
NAT_RETE_REMB VARCHAR2 1 If the amount is paid for the income tax type
NAT_RETE_PRIS VARCHAR2 1 If the amount is paid for the income tax type
NAT_TVA_REDUI VARCHAR2 1 If the amount is paid for the income tax type
NAT_TVA_DISPE VARCHAR2 1 If the amount is paid for the income tax type
TVA_NETTE NUMBER 10 Sum of amounts or base amounts for income tax type "TVA/47"
Z6 VARCHAR2 240 Space
SEGMENT1 VARCHAR2 30 Key Flexfield: segment of the key flexfield.
AGE_11 NUMBER 11 Sum of amounts or base amounts for the income tax type
SET_OF_BOOKS_ID NUMBER 18 Yes Accounting books defining column
VENDOR_SITE_ID NUMBER 18 Yes Supplier site identifier
CHECK_NUMBER NUMBER 18 Yes Check number
INVOICE_NUM VARCHAR2 50 Yes Invoice number
VENDOR_SITE_CODE VARCHAR2 240 Yes Supplier site code name
TAX_IDENTIFICATION_NUM VARCHAR2 20 Yes Tax identification number
VENDOR_NAME VARCHAR2 80 Yes Supplier name
TYPE_1099 VARCHAR2 10 Type of 1099
INVOICE_DATE DATE Invoice date
INVOICE_AMOUNT NUMBER Invoice amount
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
JE_FR_DAS2_VEN_SUMMARY_T xle_entity_profiles LEGAL_ENTITY_ID
JE_FR_DAS2_VEN_SUMMARY_T gl_ledgers SET_OF_BOOKS_ID
JE_FR_DAS2_VEN_SUMMARY_T xle_etb_profiles ESTABLISHMENT_ID

Indexes

Index Uniqueness Tablespace Columns
JE_FR_DAS2_VEN_SUMMARY_T_U1 Unique Default VEN_SUMMARY_ID
JE_FR_DAS2_VEN_SUMM_T_N1 Non Unique Default LEGAL_ENTITY_ID, ESTABLISHMENT_ID, VENDOR_SITE_ID