LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexesParent

rglc Table: General Ledger Account

Description Column Datatype
Portfolio por_s char (2)
Company com_s char (2)
Region reg_s char (2)
Office off_s char (3)
Record number unique_l number (10)
Oracle row stamp stamp_l number (10)
Debit dr_d number (15,2)
Credit cr_d number (15,2)
Debit M-T-D mtd_dr_d number (15,2)
Credit M-T-D mtd_cr_d number (15,2)
Balance gl_bal_d number (15,2)
G/L account type - credit/debit (C/D) gl_type_c char (1)

rglc Indexes:

Index name Piece 1 Piece 2 Piece 3 Piece 4 Piece 5
rglc_idx0 por_s com_s reg_s off_s unique_l


HomeTableIndexesParent