[Home] [Help] [Dependency Information]
Object Name: | SY_REAS_CDS_B |
---|---|
Object Type: | TABLE |
Owner: | GMA |
FND Design Data: | GMA.SY_REAS_CDS_B |
Subobject Name: | |
Status: | VALID |
The Reason Code table is used to store Reason Code definitions which provide information on the increase or decrease in inventory. Reason codes are used to flag transactions and attach reasons to them.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SY_REAS_CDS_B_PK | NORMAL | UNIQUE | APPS_TS_SEED | REASON_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REASON_CODE | VARCHAR2 | (4) | Yes | Reason code. |
REASON_DESC1 | VARCHAR2 | (40) | Description of the reason code. | |
REASON_DESC2 | VARCHAR2 | (70) | Description of the reason code (not used). | |
REASON_TYPE | NUMBER | (5) | Yes | Indicates change type for the reason. |
FLOW_TYPE | NUMBER | (5) | Yes | Indicates inventory flow. -1=inflow; 1=outflow; 0=usage; 2=exclude. |
AUTH_STRING | VARCHAR2 | (90) | Unused. | |
DELETE_MARK | NUMBER | (5) | Yes | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
TRANS_CNT | NUMBER | (10) | Not currently used | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
REASON_ID | NUMBER | (15) | 'DIscrete Reason ID equivalent to the Reason Code' |
Cut, paste (and edit) the following text to query this object:
SELECT REASON_CODE
, REASON_DESC1
, REASON_DESC2
, REASON_TYPE
, FLOW_TYPE
, AUTH_STRING
, DELETE_MARK
, TEXT_CODE
, TRANS_CNT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REASON_ID
FROM GMA.SY_REAS_CDS_B;
GMA.SY_REAS_CDS_B does not reference any database object
GMA.SY_REAS_CDS_B is referenced by following:
|
|
|