| Description | Column | Datatype |
|---|---|---|
| Portfolio | por_s | char (2) |
| Company | com_s | char (2) |
| Region | reg_s | char (2) |
| Office | off_s | char (3) |
| Lease | lse_s | char (10) |
| Asset | unit_s | char (10) |
| Run date | d_run_s | datetime |
| Run time | t_run_s | char (6) |
| Sybase timestamp | timestamp | timestamp |
| Allowance for bad debt | allow_d | double precision |
| Asset disposition date | d_unit_disp_s | datetime |
| Gain | gain_d | double precision |
| Gain/loss transaction originator (P/T/B/S/A)
P - Payoff T - Termination B - Batch payoff S - Sale of asset A - GL adjustmnents |
gnls_orig_c | char (1) |
| Loss | loss_d | double precision |
| Net book value at payoff | nbv_pay_d | double precision |
| Proceeds of sale | pro_sale_d | double precision |
| Index name | Piece 1 | Piece 2 | Piece 3 | Piece 4 | Piece 5 | Piece 6 | Piece 7 | Piece 8 |
|---|---|---|---|---|---|---|---|---|
| rgg_idx0 | por_s | com_s | reg_s | off_s | lse_s | unit_s | d_run_s | t_run_s |