PO_SESSION_GT

The Global Temporary table stores the PO related information to perform submission check validation.

Details

• Schema: FUSION

• Object owner: PO

• Object type: TABLE

Columns

Name

KEYNUMBER18YesKEY INDEX_NUM1NUMBERINDEX_NUM1 INDEX_NUM2NUMBERINDEX_NUM2 INDEX_CHAR1VARCHAR2100INDEX_CHAR1 INDEX_CHAR2VARCHAR2100INDEX_CHAR2 CHAR6VARCHAR24000CHAR6 NUM1NUMBERNUM1 NUM2NUMBERNUM2 NUM3NUMBERNUM3 NUM4NUMBERNUM4 NUM5NUMBERNUM5 NUM6NUMBERNUM6 NUM7NUMBERNUM7 NUM8NUMBERNUM8 NUM9NUMBERNUM9 NUM10NUMBERNUM10 CHAR1VARCHAR24000CHAR1 CHAR2VARCHAR24000CHAR2 CHAR5VARCHAR24000CHAR5 DATE1DATEDATE1 COLUMN1VARCHAR220COLUMN1 COLUMN2VARCHAR220COLUMN2 COLUMN3VARCHAR220COLUMN3 DATE2DATEDATE2 CHAR3VARCHAR24000CHAR3 CHAR4VARCHAR24000CHAR4 VARCHAR30_1VARCHAR230VARCHAR30_1 VARCHAR30_2VARCHAR230VARCHAR30_2 VARCHAR30_3VARCHAR230VARCHAR30_3 VARCHAR30_4VARCHAR230VARCHAR30_4 VARCHAR30_5VARCHAR230VARCHAR30_5 VARCHAR30_6VARCHAR230VARCHAR30_6 VARCHAR30_7VARCHAR230VARCHAR30_7 VARCHAR30_8VARCHAR230VARCHAR30_8 VARCHAR30_9VARCHAR230VARCHAR30_9 VARCHAR30_10VARCHAR230VARCHAR30_10

Indexes

Index	Uniqueness	Columns
PO_SESSION_GT_N1	Non Unique	KEY
PO_SESSION_GT_N2	Non Unique	INDEX_NUM1
PO_SESSION_GT_N3	Non Unique	INDEX_NUM2
PO_SESSION_GT_N4	Non Unique	INDEX_CHAR1
PO_SESSION_GT_N5	Non Unique	INDEX_CHAR2