









Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
The logic for interacting with a database table named it_ad. The interactions include fetching records, inserting new records, updating existing records, and setting up the form for adding or updating records. The form fields, mandatory fields, and validation rules are specified for each interaction. The logic also includes tables and fields for validation checks and non-editable fields for displaying information only.
Typology: Essays (university)
1 / 15
This page cannot be seen from the preview
Don't miss anything!
Select Find Add
Item Name Alternative Description Type
Logic:
Table Name IT_AD
Table Action Fetch
Form Fields Table Fields Item Name AD_IT_NM Alternative Description AD_IT_AD Type AD_AD_TY
click on 'Find' button Relevant Fields should be fetched from table IT_AD
Save Cancel
Item No
Type Alternative Description
M M
Logic:
Table Name IT_AD
Table Action Insert
Form Fields Table Fields (^) Mandatory (Y/N)
Item Name AD_IT_NM (^) Y
Alternative Description AD_IT_AD^ Y Type AD_AD_TY (^) Y
Validation (system should give error if the value doesn't exist for each field)
table - IT_MT, field IM_IT_NM
table - CL_CD, field CL_CL_CD where CL_SO_CD = 'IN' and CL_TY_PE = 'AD'
e, the form should be closed and return to first screen
Save Cancel Options
Item No M
Type Alternative Description
M M
Note
M Mandatory fields
Non editable fields, only display the information
Logic:
Table Name IT_AD
Table Action Update
Form Fields Table Fields (^) Mandatory (Y/N) Validation (system should give err
Item Name AD_IT_NM (^) Y table - IT_MT, field IM_IT_NM
alidation (system should give error if the value doesn't exist for each field)
able - IT_MT, field IM_IT_NM
able - CL_CD, field CL_CL_CD where CL_SO_CD = 'IN' and CL_TY_PE = 'AD'
to the table, the form should be closed and return to first screen
Save Cancel Options
Item No M
Type Alternative Description
M M
Logic:
Table Name IT_AD
Table Action Insert
Form Fields Table Fields (^) MandatoryValidation (system should give error if the value doesn't e
Item Name AD_IT_NM (^) Y table - IT_MT, field IM_IT_NM
Alternative Descr
Type AD_AD_TY Y table - CL_CD, field CL_CL_CD where CL_SO_CD = 'IN' and
Click on Save button Records should be inserted to table IT_AD. After saving records into the table, the form should be c