invantive documentation
Invantive Support ForumsLog In / Sign Up

PKG_DICT: AccountView Source Data Structures

read only per partition

  • Catalog: AccountView
  • Label: Source Data Structures

Can only retrieve data.

Table Columns

The columns of the table PKG_DICT are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
AV_DEC int32 Target Field Decimals
AV_LEN int32 Target Field Length
AV_NAME varchar2(10) Target Field Name
AV_TYPE varchar2(1) Target Field Type
CP_ALLOW char Allow Code Page Translation
FILE_LOCN varchar2(30) Source File Location
FILE_NAME varchar2(40) Source File Name
FLD_DEC int32 Source Field Decimals
FLD_DESC varchar2(150) Source Field Description
FLD_DSP int32 Display Width
FLD_LEN int32 Source Field Length
FLD_MEM varchar2(13) Memo File Name
FLD_NAME varchar2(30) Source Field Name
FLD_OFFSET int32 Field Offset
FLD_ORDER int32 Field order
FLD_RSD1 decimal Reserved Field 1
FLD_RSD2 decimal Reserved Field 2
FLD_TYPE varchar2(3) Source Field Type
IN_DBC char Table Is Part of Database
MAP_ID varchar2(10) Field Mapper ID
MAP_NAME varchar2(30) Table ID
NULL_ALLOW char Allow NULL Values
partition_code varchar2 Partition code
partition_name varchar2 Partition name
TBL_DESC varchar2(150) Table Description
TBL_NAME varchar2(40) Table Name