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

TABLE: GML.PO_VGLD_CLS

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


Vendor GL account classes are defined in this table. The GL class is assigned to a vendor to group vendors for assignment of GL accounts for receiving transactions.
Vendor GL classes defined in OPM can be entered on the Supplier in Oracle Purchasing via specific descriptive flexfields which are defined for this information.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_VGLD_CLS_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnVENDGL_CLASS
Columns
Name Datatype Length Mandatory Comments
VENDGL_CLASS VARCHAR2 (8) Yes Vendor gl class.
VENDGL_CLASS_DESC VARCHAR2 (70) Yes Description.
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
TRANS_CNT NUMBER (10)
Not currently used
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
DELETE_MARK NUMBER (5) Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion.
Query Text

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


SELECT VENDGL_CLASS
,      VENDGL_CLASS_DESC
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      TRANS_CNT
,      TEXT_CODE
,      DELETE_MARK
FROM GML.PO_VGLD_CLS;

Dependencies

[top of page]

GML.PO_VGLD_CLS does not reference any database object

GML.PO_VGLD_CLS is referenced by following:

SchemaAPPS
SynonymPO_VGLD_CLS