rapd Table: Application Document
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rapd Table: Application Document

Parent Table

Name Description
rap Application

Indexes

Name Segment 1 Segment 2
rapd_idx0 app_s unique_l

    
Columns
Name DescriptionDatatype ¿? Allow Null
app_s
Application
CHAR(10) no
unique_l
Record number (possible values are 1 to 50)
NUMBER(10) no
stamp_l
Record modification stamp
NUMBER(10) no
d_doc_rec_s
Document received date
DATE yes
doc_st_s
Documentation required status code
CHAR(4) yes
doc_rec_c
Document received (X/' ')
CHAR(1) yes
doc_ltr_c
Missing document letter indicator (X/' ')
CHAR(1) yes
doc_s
Documentation list
VARCHAR2(20) yes
doc_name_s
Document file name
VARCHAR2(36) yes
d_doc_create_s
Document create date
DATE yes
opr_s
Operator initials
CHAR(3) yes
restricted_c
Restricted element (Y/N)
CHAR(1) yes
doc_id_s
Document ID
CHAR(10) yes