Table: BKSQLVOU_NE

BKSQL_VOU_ID              | Type: INTEGER         | Len: 10
BKSQL_VOU_DATE            | Type: DATE            | Len: 10
BKSQL_VOU_REF             | Type: CHAR            | Len: 40
BKSQL_VOU_TAMT            | Type: DOUBLE          | Len: 15
BKSQL_VOU_BATCH           | Type: CHAR            | Len: 10
BKSQL_VOU_CHQID           | Type: INTEGER         | Len: 10
BKSQL_VOU_SUBID           | Type: INTEGER         | Len: 10
BKSQL_VOU_PAYEE           | Type: CHAR            | Len: 40
BKSQL_VOU_VNO             | Type: CHAR            | Len: 15
BKSQL_VOU_CHQ             | Type: CHAR            | Len: 20
BKSQL_VOU_CURR            | Type: CHAR            | Len: 3
BKSQL_VOU_USER            | Type: CHAR            | Len: 20
BKSQL_VOU_DESC            | Type: CHAR            | Len: 1024
BKSQL_VOU_STAT            | Type: INTEGER         | Len: 10

Data Example:

Array
(
    [BKSQL_VOU_ID] => 1
    [BKSQL_VOU_DATE] => 2026-03-20
    [BKSQL_VOU_REF] => RPR20260310051-FT                       
    [BKSQL_VOU_TAMT] => 3270000
    [BKSQL_VOU_BATCH] => 274776    
    [BKSQL_VOU_CHQID] => 1000024
    [BKSQL_VOU_SUBID] => 0
    [BKSQL_VOU_PAYEE] => Gloria Naiman Massawe                   
    [BKSQL_VOU_VNO] => B000139        
    [BKSQL_VOU_CHQ] => 139                 
    [BKSQL_VOU_CURR] => TZS
    [BKSQL_VOU_USER] => Mageta Mageta       
    [BKSQL_VOU_DESC] => Recovery Rectifier Transportation and Installation 4 Sites as per attached Budget                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
    [BKSQL_VOU_STAT] => 3
)

Table: BKSQLVOL_NE

BKSQL_VOL_ID              | Type: INTEGER         | Len: 10
BKSQL_VOL_REF             | Type: CHAR            | Len: 60
BKSQL_VOL_GLID            | Type: INTEGER         | Len: 10
BKSQL_VOL_AMT             | Type: DOUBLE          | Len: 15
BKSQL_VOL_SUB             | Type: CHAR            | Len: 3
BKSQL_VOL_SUBAC           | Type: CHAR            | Len: 10
BKSQL_VOL_LINE            | Type: INTEGER         | Len: 10
BKSQL_VOL_DESC            | Type: CHAR            | Len: 60

Data Example:

Array
(
    [BKSQL_VOL_ID] => 1
    [BKSQL_VOL_REF] => RPR20260310051-FT                                           
    [BKSQL_VOL_GLID] => 1000012
    [BKSQL_VOL_AMT] => 3270000
    [BKSQL_VOL_SUB] =>    
    [BKSQL_VOL_SUBAC] =>           
    [BKSQL_VOL_LINE] => 1
    [BKSQL_VOL_DESC] => Petty Cash - MAMBO                                          
)