[Home] [Help] [Dependency Information]
Object Name: | EDW_ARTT_TYPE_LSTG |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.EDW_ARTT_TYPE_LSTG |
Subobject Name: | |
Status: | VALID |
This is the staging table for the transaction type level table. Before transaction type information is loaded into the warehouse, data is temporarily held in the staging table for verification and cleansing.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRX_TYPE_PK | VARCHAR2 | (120) | The unique identifier for transaction type | |
ROW_ID | VARCHAR2 | (20) | Row identifier | |
TRX_CODE_FK | VARCHAR2 | (40) | Foreign key to transaction quickcode | |
TRX_CODE_FK_KEY | NUMBER | System generated foreign key to the transaction quickcode | ||
TRX_TYPE_DP | VARCHAR2 | (240) | Unique transaction type name | |
NAME | VARCHAR2 | (80) | Name of the transaction type | |
TRANSACTION_TYPE | VARCHAR2 | (40) | Brief description of transaction type | |
ALLOW_FRT_FLAG | VARCHAR2 | (20) | Yes/No flag indicates whether freight is allowed on transaction | |
ALLOW_OVAPP_FLAG | VARCHAR2 | (20) | Yes / No flag indicates whether applications can exceed the transaction amount | |
CREATION_SIGN | VARCHAR2 | (40) | Determines allowable signs for transactions | |
DEFAULT_STATUS | VARCHAR2 | (40) | Status to default for transactions of this type | |
DESCRIPTION | VARCHAR2 | (80) | Detailed description of transaction type | |
STATUS | VARCHAR2 | (40) | Transaction type status flag | |
TAX_CALC_FLAG | VARCHAR2 | (40) | Yes / No flag indicates whether tax is allowed on transactions | |
CM_TYPE_ID | NUMBER | Transaction type identifier of subsequent credit memos | ||
DEFAULT_TERM | NUMBER | Term to default for transactions of this type | ||
END_DATE | DATE | Transaction type end date | ||
GL_ID_CLEARING | NUMBER | Clearing account identifier | ||
GL_ID_FREIGHT | NUMBER | Freight account identifier | ||
GL_ID_REC | NUMBER | Receivables account identifier | ||
GL_ID_REV | NUMBER | Revenue account identifier | ||
GL_ID_TAX | NUMBER | Tax account identifier | ||
GL_ID_UNBILLED | NUMBER | Unbilled account identifier | ||
GL_ID_UNEARNED | NUMBER | Unearned account identifier | ||
ORG_ID | NUMBER | Organization identifier | ||
RULE_SET_ID | NUMBER | Application rule set identifer for this transaction type | ||
SET_OF_BOOKS_ID | NUMBER | Set of books identifier | ||
START_DATE | DATE | Transaction type start date | ||
SUB_TRX_TYPE_ID | NUMBER | Transaction type for transactions related to a commitment of this type | ||
INSTANCE | VARCHAR2 | (40) | Instance identifier | |
USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE6 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE7 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE8 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE9 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE10 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE11 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE12 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE13 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE14 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE15 | VARCHAR2 | (240) | User defined attribute | |
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
OPERATION_CODE | VARCHAR2 | (30) | Code used by the collection program to determine wheather to insert/update/delete this record. | |
ERROR_CODE | VARCHAR2 | (2000) | Coded used to store error messages | |
COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record |
Cut, paste (and edit) the following text to query this object:
SELECT TRX_TYPE_PK
, ROW_ID
, TRX_CODE_FK
, TRX_CODE_FK_KEY
, TRX_TYPE_DP
, NAME
, TRANSACTION_TYPE
, ALLOW_FRT_FLAG
, ALLOW_OVAPP_FLAG
, CREATION_SIGN
, DEFAULT_STATUS
, DESCRIPTION
, STATUS
, TAX_CALC_FLAG
, CM_TYPE_ID
, DEFAULT_TERM
, END_DATE
, GL_ID_CLEARING
, GL_ID_FREIGHT
, GL_ID_REC
, GL_ID_REV
, GL_ID_TAX
, GL_ID_UNBILLED
, GL_ID_UNEARNED
, ORG_ID
, RULE_SET_ID
, SET_OF_BOOKS_ID
, START_DATE
, SUB_TRX_TYPE_ID
, INSTANCE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, USER_ATTRIBUTE6
, USER_ATTRIBUTE7
, USER_ATTRIBUTE8
, USER_ATTRIBUTE9
, USER_ATTRIBUTE10
, USER_ATTRIBUTE11
, USER_ATTRIBUTE12
, USER_ATTRIBUTE13
, USER_ATTRIBUTE14
, USER_ATTRIBUTE15
, REQUEST_ID
, OPERATION_CODE
, ERROR_CODE
, COLLECTION_STATUS
FROM FII.EDW_ARTT_TYPE_LSTG;
FII.EDW_ARTT_TYPE_LSTG does not reference any database object
FII.EDW_ARTT_TYPE_LSTG is referenced by following:
|
|
|