| Columns |
|---|
| Name |
Description |
Datatype ¿? |
Allow Null |
| por_s |
Portfolio |
char(2) |
no |
| udf_type_s |
User defined field type (APP/CUS/LES/LSE/UNI/VND)
APP - Application fields
CUS - Customer fields
LES - Lessee fields
LSE - Lease fields
UNI - Asset fields
VND - Vendor fields |
char(3) |
no |
| timestamp |
Record modification stamp |
timestamp |
yes |
| fcod_s |
User defined field code check (Y/N) |
char(51) |
yes |
| fir_s |
User defined field input required (Y/N) |
char(51) |
yes |
| fedt_s |
User defined field edit check (D/N/$/0-7/' ')
D - date
N - integer
$ - dollar amount
0-7 - number of decimal places
' ' - no edit check |
char(51) |
yes |
| fxfer_s |
Transfer user defined application field to lease (Y/N) |
char(51) |
yes |
| fhed1_s |
User defined field header [1] |
char(25) |
yes |
| fhed2_s |
User defined field header [2] |
char(25) |
yes |
| fhed3_s |
User defined field header [3] |
char(25) |
yes |
| fhed4_s |
User defined field header [4] |
char(25) |
yes |
| fhed5_s |
User defined field header [5] |
char(25) |
yes |
| fhed6_s |
User defined field header [6] |
char(25) |
yes |
| fhed7_s |
User defined field header [7] |
char(25) |
yes |
| fhed8_s |
User defined field header [8] |
char(25) |
yes |
| fhed9_s |
User defined field header [9] |
char(25) |
yes |
| fhed10_s |
User defined field header [10] |
char(25) |
yes |
| fhed11_s |
User defined field header [11] |
char(25) |
yes |
| fhed12_s |
User defined field header [12] |
char(25) |
yes |
| fhed13_s |
User defined field header [13] |
char(25) |
yes |
| fhed14_s |
User defined field header [14] |
char(25) |
yes |
| fhed15_s |
User defined field header [15] |
char(25) |
yes |
| fhed16_s |
User defined field header [16] |
char(25) |
yes |
| fhed17_s |
User defined field header [17] |
char(25) |
yes |
| fhed18_s |
User defined field header [18] |
char(25) |
yes |
| fhed19_s |
User defined field header [19] |
char(25) |
yes |
| fhed20_s |
User defined field header [20] |
char(25) |
yes |
| fhed21_s |
User defined field header [21] |
char(25) |
yes |
| fhed22_s |
User defined field header [22] |
char(25) |
yes |
| fhed23_s |
User defined field header [23] |
char(25) |
yes |
| fhed24_s |
User defined field header [24] |
char(25) |
yes |
| fhed25_s |
User defined field header [25] |
char(25) |
yes |
| fhed26_s |
User defined field header [26] |
char(25) |
yes |
| fhed27_s |
User defined field header [27] |
char(25) |
yes |
| fhed28_s |
User defined field header [28] |
char(25) |
yes |
| fhed29_s |
User defined field header [29] |
char(25) |
yes |
| fhed30_s |
User defined field header [30] |
char(25) |
yes |
| fhed31_s |
User defined field header [31] |
char(25) |
yes |
| fhed32_s |
User defined field header [32] |
char(25) |
yes |
| fhed33_s |
User defined field header [33] |
char(25) |
yes |
| fhed34_s |
User defined field header [34] |
char(25) |
yes |
| fhed35_s |
User defined field header [35] |
char(25) |
yes |
| fhed36_s |
User defined field header [36] |
char(25) |
yes |
| fhed37_s |
User defined field header [37] |
char(25) |
yes |
| fhed38_s |
User defined field header [38] |
char(25) |
yes |
| fhed39_s |
User defined field header [39] |
char(25) |
yes |
| fhed40_s |
User defined field header [40] |
char(25) |
yes |
| fhed41_s |
User defined field header [41] |
char(25) |
yes |
| fhed42_s |
User defined field header [42] |
char(25) |
yes |
| fhed43_s |
User defined field header [43] |
char(25) |
yes |
| fhed44_s |
User defined field header [44] |
char(25) |
yes |
| fhed45_s |
User defined field header [45] |
char(25) |
yes |
| fhed46_s |
User defined field header [46] |
char(25) |
yes |
| fhed47_s |
User defined field header [47] |
char(25) |
yes |
| fhed48_s |
User defined field header [48] |
char(25) |
yes |
| fhed49_s |
User defined field header [49] |
char(25) |
yes |
| fhed50_s |
User defined field header [50] |
char(25) |
yes |
| fhed51_s |
User defined field header [51] |
char(25) |
yes |
DBMS Platform Selector |
Database Reference |
LeasePak Database Objects |
Data Model |
Additional Information