eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: EC.ECE_AR_TRX_HEADER_1

Object Details

Object Name:	ECE_AR_TRX_HEADER_1
Object Type:	TABLE
Owner:	EC
FND Design Data:	EC.ECE_AR_TRX_HEADER_1
Subobject Name:
Status:	VALID

ECE_AR_TRX_HEADER_1 contains customer invoice header data to support
the outbound Invoice (810/INVOIC) transaction. ECE_AR_TRX_HEADER_1 is
a continuation of ECE_AR_TRX_HEADERS, so there is a one-to-one
relationship between these two tables.

ECE_AR_TRX_HEADER_1 is based primarily on data stored in
RA_CUSTOMER_TRX and RA_CUSTOMER_TRX_LINES in Oracle
Receivables. In addition, if you are using Oracle Automotive, access
to WSH_DEPARTURES from the Oracle Order Management Departure Planning
module and VEH_ALLOWANCE_CHARGES from Oracle Automotive is included.

ECE_AR_TRX_HEADER_1 contains the customer invoice header information.
In addition, if you are using Oracle Automotive, equipment information
is retrieved from the Oracle Order Management Departure Planning module
and invoice header allowances and charges information is retrieved from
Oracle Automotive.

All columns denoted with "Int" or "Internal" represent Oracle
Applications internal values. All columns denoted with "Ext" or
"External" represent the equivalent external values sourced from the
ECE_XREF_DATA table if code conversion is enabled for the column.

Each row in ECE_AR_TRX_HEADER_1 is purged after the data is written to
the data file.

TRANSACTION_RECORD_ID is the unique key that links the
ECE_AR_TRX_HEADER_1 table to its corresponding extension table
ECE_AR_TRX_HEADER_1_X.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ECE_AR_TRX_HEADER_1_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	TRANSACTION_RECORD_ID

Columns

Name	Datatype	Length	Mandatory	Comments
COMMUNICATION_METHOD	VARCHAR2	(30)		Communication Method
TRANSACTION_TYPE	VARCHAR2	(30)		Transaction Type
TRANSACTION_ID	NUMBER		Yes	Transaction ID
TRANSACTION_RECORD_ID	NUMBER			Unique identifier that links the transaction base table to its associated extension table.
RUN_ID	NUMBER			Run ID
EQUIPMENT_PREFIX	VARCHAR2	(10)		Equipment Prefix
EQUIPMENT_NUMBER	VARCHAR2	(30)		Equipment Number
ROUTING_INSTRUCTIONS	VARCHAR2	(150)		Routing Instructions
PACKING_SLIP_NUMBER	VARCHAR2	(30)		Packing Slip Number
INTERFACE_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Invoice Header Interface Flexfield Context
INTERFACE_ATTRIBUTE1	VARCHAR2	(30)		Invoice Header Interface Flexfield 1
INTERFACE_ATTRIBUTE2	VARCHAR2	(30)		Invoice Header Interface Flexfield 2
INTERFACE_ATTRIBUTE3	VARCHAR2	(30)		Invoice Header Interface Flexfield 3
INTERFACE_ATTRIBUTE4	VARCHAR2	(30)		Invoice Header Interface Flexfield 4
INTERFACE_ATTRIBUTE5	VARCHAR2	(30)		Invoice Header Interface Flexfield 5
INTERFACE_ATTRIBUTE6	VARCHAR2	(30)		Invoice Header Interface Flexfield 6
INTERFACE_ATTRIBUTE7	VARCHAR2	(30)		Invoice Header Interface Flexfield 7
INTERFACE_ATTRIBUTE8	VARCHAR2	(30)		Invoice Header Interface Flexfield 8
INTERFACE_ATTRIBUTE9	VARCHAR2	(30)		Invoice Header Interface Flexfield 9
INTERFACE_ATTRIBUTE10	VARCHAR2	(30)		Invoice Header Interface Flexfield 10
INTERFACE_ATTRIBUTE11	VARCHAR2	(30)		Invoice Header Interface Flexfield 11
INTERFACE_ATTRIBUTE12	VARCHAR2	(30)		Invoice Header Interface Flexfield 12
INTERFACE_ATTRIBUTE13	VARCHAR2	(30)		Invoice Header Interface Flexfield 13
INTERFACE_ATTRIBUTE14	VARCHAR2	(30)		Invoice Header Interface Flexfield 14
INTERFACE_ATTRIBUTE15	VARCHAR2	(30)		Invoice Header Interface Flexfield 15
TRANSACTION_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Invoice Header Flexfield Context
TRANSACTION_ATTRIBUTE1	VARCHAR2	(150)		Invoice Header Flexfield 1
TRANSACTION_ATTRIBUTE2	VARCHAR2	(150)		Invoice Header Flexfield 2
TRANSACTION_ATTRIBUTE3	VARCHAR2	(150)		Invoice Header Flexfield 3
TRANSACTION_ATTRIBUTE4	VARCHAR2	(150)		Invoice Header Flexfield 4
TRANSACTION_ATTRIBUTE5	VARCHAR2	(150)		Invoice Header Flexfield 5
TRANSACTION_ATTRIBUTE6	VARCHAR2	(150)		Invoice Header Flexfield 6
TRANSACTION_ATTRIBUTE7	VARCHAR2	(150)		Invoice Header Flexfield 7
TRANSACTION_ATTRIBUTE8	VARCHAR2	(150)		Invoice Header Flexfield 8
TRANSACTION_ATTRIBUTE9	VARCHAR2	(150)		Invoice Header Flexfield 9
TRANSACTION_ATTRIBUTE10	VARCHAR2	(150)		Invoice Header Flexfield 10
TRANSACTION_ATTRIBUTE11	VARCHAR2	(150)		Invoice Header Flexfield 11
TRANSACTION_ATTRIBUTE12	VARCHAR2	(150)		Invoice Header Flexfield 12
TRANSACTION_ATTRIBUTE13	VARCHAR2	(150)		Invoice Header Flexfield 13
TRANSACTION_ATTRIBUTE14	VARCHAR2	(150)		Invoice Header Flexfield 14
TRANSACTION_ATTRIBUTE15	VARCHAR2	(150)		Invoice Header Flexfield 15
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REQUEST_ID	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
SHIP_FROM_CODE_INT	VARCHAR2	(3)		Ship From Code (Internal)
SHIP_FROM_CODE_EXT	VARCHAR2	(80)
DELIVERY_ID	VARCHAR2	(30)		Delivery ID
SHIP_FROM_CODE_EXT1	VARCHAR2	(80)		Ship From Code (External 1)
SHIP_FROM_CODE_EXT2	VARCHAR2	(80)		Ship From Code (External 2)
SHIP_FROM_CODE_EXT3	VARCHAR2	(80)		Ship From Code (External 3)
SHIP_FROM_CODE_EXT4	VARCHAR2	(80)		Ship From Code (External 4)
SHIP_FROM_CODE_EXT5	VARCHAR2	(80)		Ship From Code (External 5)
SHIP_FROM_CODE_INT_1	VARCHAR2	(3)		Ship From Code(Internal 1)

Query Text

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


SELECT COMMUNICATION_METHOD
,      TRANSACTION_TYPE
,      TRANSACTION_ID
,      TRANSACTION_RECORD_ID
,      RUN_ID
,      EQUIPMENT_PREFIX
,      EQUIPMENT_NUMBER
,      ROUTING_INSTRUCTIONS
,      PACKING_SLIP_NUMBER
,      INTERFACE_ATTRIBUTE_CATEGORY
,      INTERFACE_ATTRIBUTE1
,      INTERFACE_ATTRIBUTE2
,      INTERFACE_ATTRIBUTE3
,      INTERFACE_ATTRIBUTE4
,      INTERFACE_ATTRIBUTE5
,      INTERFACE_ATTRIBUTE6
,      INTERFACE_ATTRIBUTE7
,      INTERFACE_ATTRIBUTE8
,      INTERFACE_ATTRIBUTE9
,      INTERFACE_ATTRIBUTE10
,      INTERFACE_ATTRIBUTE11
,      INTERFACE_ATTRIBUTE12
,      INTERFACE_ATTRIBUTE13
,      INTERFACE_ATTRIBUTE14
,      INTERFACE_ATTRIBUTE15
,      TRANSACTION_ATTRIBUTE_CATEGORY
,      TRANSACTION_ATTRIBUTE1
,      TRANSACTION_ATTRIBUTE2
,      TRANSACTION_ATTRIBUTE3
,      TRANSACTION_ATTRIBUTE4
,      TRANSACTION_ATTRIBUTE5
,      TRANSACTION_ATTRIBUTE6
,      TRANSACTION_ATTRIBUTE7
,      TRANSACTION_ATTRIBUTE8
,      TRANSACTION_ATTRIBUTE9
,      TRANSACTION_ATTRIBUTE10
,      TRANSACTION_ATTRIBUTE11
,      TRANSACTION_ATTRIBUTE12
,      TRANSACTION_ATTRIBUTE13
,      TRANSACTION_ATTRIBUTE14
,      TRANSACTION_ATTRIBUTE15
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SHIP_FROM_CODE_INT
,      SHIP_FROM_CODE_EXT
,      DELIVERY_ID
,      SHIP_FROM_CODE_EXT1
,      SHIP_FROM_CODE_EXT2
,      SHIP_FROM_CODE_EXT3
,      SHIP_FROM_CODE_EXT4
,      SHIP_FROM_CODE_EXT5
,      SHIP_FROM_CODE_INT_1
FROM EC.ECE_AR_TRX_HEADER_1;

Dependencies

[top of page]

EC.ECE_AR_TRX_HEADER_1 does not reference any database object

EC.ECE_AR_TRX_HEADER_1 is referenced by following:

APPS: ECE_AR_TRX_HEADER_1