LeasePak 5.1a Database Reference (Sybase)

HomeTableIndexes

rpx Table: Batch Payoff Detail

Description Column Datatype
Batch date d_batch_s datetime
Batch number batch_num_s char (6)
Batch sequence number batch_seq_num_s char (8)
Batch detail number batch_det_num_s char (4)
Sybase timestamp timestamp timestamp
Lease lse_s char (10)
Invoice number invo_s char (8)
Method method_s char (4)
Payoff effective date d_payoff_eff_s datetime
Payoff source payoff_src_s char (4)
Payoff rating payoff_rat_s char (5)
Check number chk_num_s char (10)
Amount received received_d double precision
Allow to override allow_ovr_s char (8)
Payoff bank code payoff_bank_s char (4)
Processed indicator (Y/N) processed_c char (1)
Operator initials opr_s char (3)
Portfolio por_s char (2)

rpx Indexes:

Index name Piece 1 Piece 2 Piece 3 Piece 4
rpx_idx0 d_batch_s batch_num_s batch_seq_num_s batch_det_num_s


HomeTableIndexes

(c) Copyright 2004 McCue Systems, Inc.