PKG_DICT: AccountView Source Data Structures
read only per partition
- Catalogus:
AccountView - Label: Source Data Structures
Kan alleen gegevens ophalen.
Tabelkolommen
De kolommen van de tabel PKG_DICT worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
AV_DEC |
int32 |
Target Field Decimals | |||
AV_LEN |
int32 |
Target Field Length | |||
AV_ |
varchar2 |
Target Field Name | |||
AV_ |
varchar2 |
Target Field Type | |||
CP_ |
char |
Allow Code Page Translation | |||
FILE_ |
varchar2 |
Source File Location | |||
FILE_ |
varchar2 |
Source File Name | |||
FLD_ |
int32 |
Source Field Decimals | |||
FLD_ |
varchar2 |
Source Field Description | |||
FLD_ |
int32 |
Display Width | |||
FLD_ |
int32 |
Source Field Length | |||
FLD_ |
varchar2 |
Memo File Name | |||
FLD_ |
varchar2 |
Source Field Name | |||
FLD_ |
int32 |
Field Offset | |||
FLD_ |
int32 |
Field order | |||
FLD_ |
decimal |
Reserved Field 1 | |||
FLD_ |
decimal |
Reserved Field 2 | |||
FLD_ |
varchar2 |
Source Field Type | |||
IN_DBC |
char |
Table Is Part of Database | |||
MAP_ID |
varchar2 |
Field Mapper ID | |||
MAP_ |
varchar2 |
Tabel ID | |||
NULL_ |
char |
Allow NULL Values | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
TBL_ |
varchar2 |
Tabel Omschrijving | |||
TBL_ |
varchar2 |
Tabelnaam |