[Home] [Help] [Dependency Information]
Object Name: | FUN_TRX_TYPE_AR_MAPS |
---|---|
Object Type: | TABLE |
Owner: | FUN |
FND Design Data: | FUN.FUN_TRX_TYPE_AR_MAPS |
Subobject Name: | |
Status: | VALID |
FUN_TRX_TYPE_AR_MAPS stores the mapping between the Intercompany transaction type and the Receivables Transaction Type and Receivables Memo Line. This mapping is used to create Receivables invoices when the Intercompany transactions are transferred into Receivables.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRX_TYPE_MAP_ID | NUMBER | (15) | Yes | System generated primary key. |
TRX_TYPE_ID | NUMBER | (15) | Yes | Transaction type identifier. Foreign key to FUN_TRX_TYPES.TRX_TYPE_ID |
ORG_ID | NUMBER | (15) | Yes | Operating unit identifier for which the mapping has been defined. |
MEMO_LINE_ID | NUMBER | (15) | Yes | Memo line identifier. Foreign key to AR_MEMO_LINES_ALL_B.MEMO_LINE_ID. |
AR_TRX_TYPE_ID | NUMBER | (15) | Yes | AR Transaction type identifier. Foreign key to RA_CUST_TRX_TYPES_ALL. CUST_TRX_TYPE_ID. |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield context. | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column. |
CREATION_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. |
Cut, paste (and edit) the following text to query this object:
SELECT TRX_TYPE_MAP_ID
, TRX_TYPE_ID
, ORG_ID
, MEMO_LINE_ID
, AR_TRX_TYPE_ID
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM FUN.FUN_TRX_TYPE_AR_MAPS;
FUN.FUN_TRX_TYPE_AR_MAPS does not reference any database object
FUN.FUN_TRX_TYPE_AR_MAPS is referenced by following:
|
|
|