rut Table: User Defined Tables Description
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rut Table: User Defined Tables Description

Indexes

Name Segment 1 Segment 2
rut_idx0 por_s udt_type_s

  
Columns
Name DescriptionDatatype ¿? Allow Null
por_s
Portfolio
char(2) no
udt_type_s
User defined table type (APP/CUS/LES/LSE/UNI/VND)
  APP - Application tables
  CUS - Customer tables
  LES - Lessee tables
  LSE - Lease tables
  UNI - Asset tables
  VND - Vendor tables
char(3) no
timestamp
Record modification stamp
timestamp yes
tcod_s
User defined table code check (Y/N)
char(12) yes
tir_s
User defined table input required (Y/N)
char(12) yes
tedt_s
User defined table edit check (D/N/$/0-7/' ')
  D - date
  N - integer
  $ - dollar amount
  0-7 - number of decimal places
  ' ' - no edit check
char(12) yes
txfer_s
User defined application table to transfer to lease (Y/N)
char(12) yes
thed1_s
User defined table header [1]
char(12) yes
thed2_s
User defined table header [2]
char(12) yes
thed3_s
User defined table header [3]
char(12) yes
thed4_s
User defined table header [4]
char(12) yes
thed5_s
User defined table header [5]
char(12) yes
thed6_s
User defined table header [6]
char(12) yes
thed7_s
User defined table header [7]
char(12) yes
thed8_s
User defined table header [8]
char(12) yes
thed9_s
User defined table header [9]
char(12) yes
thed10_s
User defined table header [10]
char(12) yes
thed11_s
User defined table header [11]
char(12) yes
thed12_s
User defined table header [12]
char(12) yes