[Home] [Help] [Dependency Information]

TABLE: EC.ECE_AR_TRX_ALLOWANCE_CHARGES

Object Details

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

ECE_AR_TRX_ALLOWANCE_CHARGES contains allowance and charge
information for the customer invoice to support the outbound Invoice
(810/INVOIC) transaction.

ECE_AR_TRX_ALLOWANCE_CHARGES is based primarily on data stored
in RA_CUSTOMER_TRX_LINES in Oracle Receivables. In addition, if you
are using Oracle Automotive, access to VEH_ALLOWANCE_CHARGES
from Oracle Automotive is included.

ECE_AR_TRX_ALLOWANCE_CHARGES contains allowance and charge
information for the customer invoice header and invoice line.

Each row in ECE_AR_TRX_ALLOWANCE_CHARGES is associated with one
row in ECE_AR_TRX_LINES/ECE_AR_TRX_HEADERS/ECE_AR_TRX_HEADER_1.
There is a one to many relationship between ECE_AR_TRX_LINES/
ECE_AR_TRX_HEADERS/ECE_AR_TRX_HEADER_1 and
ECE_AR_TRX_ALLOWANCE_CHARGES.

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_ALLOWANCE_CHARGES is purged after the data is
written to the data file.

TRANSACTION_RECORD_ID is the unique key that links the
ECE_AR_TRX_ALLOWANCE_CHARGES table to its corresponding extension
table ECE_AR_TRX_ALLOWANCE_CHARGES_X.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ECE_AR_TRX_ALLOWANCE_CHARGE_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	TRANSACTION_RECORD_ID

Columns

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
,      LINE_NUMBER
,      HEADER_DETAIL_INDICATOR
,      ALLOWANCE_CHARGE_INDICATOR
,      ALLOWANCE_CHARGE_AMOUNT
,      SPECIAL_SERVICES_CODE
,      SPECIAL_SERVICES_CODE_EXT1
,      SPECIAL_SERVICES_CODE_EXT2
,      SPECIAL_SERVICES_CODE_EXT3
,      SPECIAL_SERVICES_CODE_EXT4
,      SPECIAL_SERVICES_CODE_EXT5
,      SPECIAL_CHARGES_CODE
,      SPECIAL_CHARGES_CODE_EXT1
,      SPECIAL_CHARGES_CODE_EXT2
,      SPECIAL_CHARGES_CODE_EXT3
,      SPECIAL_CHARGES_CODE_EXT4
,      SPECIAL_CHARGES_CODE_EXT5
,      METHOD_HANDLING_CODE
,      METHOD_HANDLING_CODE_EXT1
,      METHOD_HANDLING_CODE_EXT2
,      METHOD_HANDLING_CODE_EXT3
,      METHOD_HANDLING_CODE_EXT4
,      METHOD_HANDLING_CODE_EXT5
,      ALLOWANCE_CHARGE_DESC
,      AGENCY_QUALIFIER_CODE
,      ALLOWANCE_CHARGE_RATE
,      ALLOWANCE_CHARGE_PCT_QUALIFIER
,      ALLOWANCE_CHARGE_PCT
,      ALLOWANCE_CHARGE_UOM_CODE
,      ALLOWANCE_CHARGE_QUANTITY
,      AC_ATTRIBUTE_CATEGORY
,      AC_ATTRIBUTE1
,      AC_ATTRIBUTE2
,      AC_ATTRIBUTE3
,      AC_ATTRIBUTE4
,      AC_ATTRIBUTE5
,      AC_ATTRIBUTE6
,      AC_ATTRIBUTE7
,      AC_ATTRIBUTE8
,      AC_ATTRIBUTE9
,      AC_ATTRIBUTE10
,      AC_ATTRIBUTE11
,      AC_ATTRIBUTE12
,      AC_ATTRIBUTE13
,      AC_ATTRIBUTE14
,      AC_ATTRIBUTE15
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM EC.ECE_AR_TRX_ALLOWANCE_CHARGES;

Dependencies

[top of page]

EC.ECE_AR_TRX_ALLOWANCE_CHARGES does not reference any database object

EC.ECE_AR_TRX_ALLOWANCE_CHARGES is referenced by following:

APPS

ECE_AR_TRX_ALLOWANCE_CHARGES