DCT_ASP: AccountView Web catalogues
read only per partition
- Catalog:
AccountView - Label: Web catalogues
Can only retrieve data.
Table Columns
The columns of the table DCT_ASP 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 |
|---|---|---|---|---|---|
ASP_ |
char |
Active | |||
ASP_ |
varchar2 |
Catalogue description | |||
ASP_ |
varchar2 |
Sales order email | |||
ASP_ID |
varchar2 |
Catalogue code | |||
ASP_ |
decimal |
Type | |||
ASP_ |
varchar2 |
When | |||
CNG_ |
datetime |
Date modified | |||
CNG_NR |
int32 |
Change number | |||
CNG_ |
varchar2 |
Employee last modified | |||
DSP_ |
int32 |
Max. number of levels | |||
IMG_ |
varchar2 |
Image | |||
INP_ |
datetime |
Entry date | |||
INP_ |
varchar2 |
Entered by employee | |||
LST_ |
datetime |
Last download | |||
LST_ |
datetime |
Last upload | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
REC_ |
char |
Customised | |||
STGY_ |
varchar2 |
ASP format | |||
SUB_NR |
varchar2 |
Reference customer | |||
TPL_ |
varchar2 |
Item template | |||
TPL_ |
varchar2 |
Item list template | |||
TPL_ |
varchar2 |
Item category template | |||
URL_ |
varchar2 |
Shop URL | |||
URL_ |
varchar2 |
Upload URL | |||
USR_ID |
varchar2 |
User | |||
USR_ |
varchar2 |
Password | |||
WEB_ |
char |
Available online |