rglc Table: General Ledger Account
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rglc Table: General Ledger Account

Parent Table

Name Description
rgl General Ledger

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5
rglc_idx0 por_s com_s reg_s off_s unique_l

   
Columns
Name DescriptionDatatype ¿? Allow Null
por_s
Portfolio
CHAR(2) no
com_s
Company
CHAR(2) no
reg_s
Region
CHAR(2) no
off_s
Office
CHAR(3) no
unique_l
Record number (possible values are 0 to 850)
NUMBER(10) no
stamp_l
Record modification stamp
NUMBER(10) no
dr_d
Debit
NUMBER(15,2) yes
cr_d
Credit
NUMBER(15,2) yes
mtd_dr_d
Debit M-T-D
NUMBER(15,2) yes
mtd_cr_d
Credit M-T-D
NUMBER(15,2) yes
gl_bal_d
Balance
NUMBER(15,2) yes
gl_type_c
GL account type (C/D)
  C - credit
  D - debit
CHAR(1) yes