DBA Data[Home] [Help] [Dependency Information]

TABLE: GML.OP_CGLD_CLS

Object Details
Object Name: OP_CGLD_CLS
Object Type: TABLE
Owner: GML
FND Design Data: TableGML.OP_CGLD_CLS
Subobject Name:
Status: VALID


Customer GL account classes are defined in this table. The GL class is assigned to a customer to group customers for assignment of GL accounts for sales transactions.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OP_CGLD_CLS_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCUSTGL_CLASS
Columns
Name Datatype Length Mandatory Comments
CUSTGL_CLASS VARCHAR2 (8) Yes Customer gl class; uniquely identifies record. Assigned to customer in customer master table op_cust_mst. Used in gl mapping.
CUSTGL_CLASS_DESC VARCHAR2 (70) Yes Description of customer gl class
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
TRANS_CNT NUMBER (10)
Not currently used
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CUSTGL_CLASS
,      CUSTGL_CLASS_DESC
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
FROM GML.OP_CGLD_CLS;

Dependencies

[top of page]

GML.OP_CGLD_CLS does not reference any database object

GML.OP_CGLD_CLS is referenced by following:

SchemaAPPS
SynonymOP_CGLD_CLS