[Home] [Help] [Dependency Information]
Object Name: | JL_AR_AP_TRX_DGI_CODES |
---|---|
Object Type: | TABLE |
Owner: | JL |
FND Design Data: | JL.JL_AR_AP_TRX_DGI_CODES |
Subobject Name: | |
Status: | VALID |
JL_AR_AP_TRX_DGI_CODES stores DGI transaction codes associated to the different combinations of legal transaction categories and transaction letters. This code will be defaulted automatically when entering invoices and will be used for legal reporting purposes.
This table corresponds to the Transaction Type Codes window.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JL_AR_AP_TRX_DGI_CODES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TRX_CATEGORY_LETTER_ID |
JL_AR_AP_TRX_DGI_CODES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TRX_CATEGORY
TRX_LETTER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRX_CATEGORY_LETTER_ID | NUMBER | (15) | Yes | Identifier of a combination of legal transaction category and transaction letter |
TRX_CATEGORY | VARCHAR2 | (30) | Yes | Legal transaction category |
TRX_LETTER | VARCHAR2 | (1) | Yes | Transaction letter |
DGI_CODE | VARCHAR2 | (30) | Yes | DGI code |
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 | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive Flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column |
Cut, paste (and edit) the following text to query this object:
SELECT TRX_CATEGORY_LETTER_ID
, TRX_CATEGORY
, TRX_LETTER
, DGI_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM JL.JL_AR_AP_TRX_DGI_CODES;
JL.JL_AR_AP_TRX_DGI_CODES does not reference any database object
JL.JL_AR_AP_TRX_DGI_CODES is referenced by following:
|
|
|