DBA Data[Home] [Help] [Dependency Information]

TABLE: JE.JE_GR_AR_AP_TRNOVR_ITF

Object Details
Object Name: JE_GR_AR_AP_TRNOVR_ITF
Object Type: TABLE
Owner: JE
FND Design Data: TableJE.JE_GR_AR_AP_TRNOVR_ITF
Subobject Name:
Status: VALID


JE_GR_AR_AP_TURNOVER_ITF is a temporary table that stores customer/supplier transaction/invoice data extracted from Oracle Payables and Oracle Receivables. This interface table contains all the columns that are to be displayed by the two reports. The Customer/Supplier Turnover Report List and Customer/Supplier Turnover Report File Format programs uses this data to generate the reports in the required format. There is no primary key. This table is used only from release 11i onward.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JE_GR_AR_AP_TRNOVR_ITF_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
ColumnCUST_SUP_NUMBER
ColumnINV_TRX_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Yes Parent concurrent request ID of the report set
INV_TRX_ID NUMBER
Yes Invoice/transaction identifier
CUST_SUP_TYPE_CODE VARCHAR2 (30)
Customer/supplier type code
CUST_SUP_NAME VARCHAR2 (80) Yes Customer/supplier name
CUST_SUP_NUMBER VARCHAR2 (30) Yes Customer/supplier number
TAX_PAYER_ID VARCHAR2 (50)
Customer tax payer ID
VAT_REGISTRATION_NUMBER VARCHAR2 (20)
Supplier VAT registration number
SUPPLIER_SITE_CODE VARCHAR2 (15)
Supplier site code
PROFESSION VARCHAR2 (30)
Customer/supplier profession
ADDRESS_LINE1 VARCHAR2 (240)
Customer/supplier address line1
ADDRESS_LINE2 VARCHAR2 (240)
Customer/supplier address line2
ADDRESS_LINE3 VARCHAR2 (240)
Customer/supplier address line3
CITY VARCHAR2 (60)
Customer/supplier city
STATE VARCHAR2 (60)
Customer/supplier state
ZIP VARCHAR2 (60)
Customer/supplier ZIP
PROVINCE VARCHAR2 (60)
Customer/supplier province
COUNTRY VARCHAR2 (60)
Customer/supplier country
INV_TRX_NUMBER VARCHAR2 (50) Yes Invoice/transaction number
INV_TRX_DATE DATE
Yes Invoice/transaction date
INV_TRX_CURRENCY_CODE VARCHAR2 (15)
Invoice/transaction currency code
INV_TRX_AMOUNT NUMBER

Invoice/transaction amount in invoice currency
INV_TRX_TYPE VARCHAR2 (25) Yes Invoice/transaction type
ACCTD_INV_TRX_AMOUNT NUMBER

Invoice/transaction functional amount. It is null if the functional currency and invoice currency are the same.
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REQUEST_ID
,      INV_TRX_ID
,      CUST_SUP_TYPE_CODE
,      CUST_SUP_NAME
,      CUST_SUP_NUMBER
,      TAX_PAYER_ID
,      VAT_REGISTRATION_NUMBER
,      SUPPLIER_SITE_CODE
,      PROFESSION
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      CITY
,      STATE
,      ZIP
,      PROVINCE
,      COUNTRY
,      INV_TRX_NUMBER
,      INV_TRX_DATE
,      INV_TRX_CURRENCY_CODE
,      INV_TRX_AMOUNT
,      INV_TRX_TYPE
,      ACCTD_INV_TRX_AMOUNT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM JE.JE_GR_AR_AP_TRNOVR_ITF;

Dependencies

[top of page]

JE.JE_GR_AR_AP_TRNOVR_ITF does not reference any database object

JE.JE_GR_AR_AP_TRNOVR_ITF is referenced by following:

SchemaJE
ViewJE_GR_AR_AP_TRNOVR_ITF#