In the Inclusion/Deletion of different receipts (FINA087A), the table that should be used for accounting is SEL, however the table SE5 will be positioned to support complementary data.
CT5_LANPAD |
575 |
CT5_SEQUEN |
1 |
CT5_DESC |
MISCELLANEOUS RECEIPTS - INCLUSION OF A RECEIPT |
CT5_DC |
3 |
CT5_DEBITO |
1234 |
CT5_CREDIT |
1235 |
CT5_MOEDAS |
12222 |
CT5_VLR01 |
IF(SEL->EL_TIPODOC = 'DC',SEL->EL_VALOR,0) |
CT5_HIST |
'575:001 - REC DIV: ' + SE5->('BENEF.: 'E5_BENEF' HIST.: '+E5_HISTOR) |
CT5_ORIGEM |
'575:001 ' + SEL->('TIPO: 'EL_TIPO' RECIBO: 'EL_RECIBO' DT EMIS.: '+DTOC(EL_EMISSAO)) |
CT5_LANPAD |
575 |
CT5_SEQUEN |
2 |
CT5_DESC |
MISCELLANEOUS RECEIPTS - INCLUSION OF A RECEIPT |
CT5_DC |
3 |
CT5_DEBITO |
1234 |
CT5_CREDIT |
1235 |
CT5_MOEDAS |
12222 |
CT5_VLR01 |
IF(SEL->EL_TIPODOC = 'TB',SEL->EL_VALOR,0) |
CT5_HIST |
'575:001 - REC DIV: ' + SE5->('BENEF.: 'E5_BENEF' HIST.: '+E5_HISTOR) |
CT5_ORIGEM |
'575:001 ' + SEL->('TIPO: 'EL_TIPO' RECIBO: 'EL_RECIBO' DT EMIS.: '+DTOC(EL_EMISSAO)) |
CT5_LANPAD |
576 |
CT5_SEQUEN |
1 |
CT5_DESC |
MISCELLANEOUS RECEIPTS - REVERSAL OF A RECEIPT |
CT5_DC |
3 |
CT5_DEBITO |
1235 |
CT5_CREDIT |
1234 |
CT5_MOEDAS |
12222 |
CT5_VLR01 |
IF(SEL->EL_TIPODOC = 'DC',SEL->EL_VALOR,0) |
CT5_HIST |
'576:001 - REC DIV: ' + SE5->('BENEF.: 'E5_BENEF' HIST.: '+E5_HISTOR) |
CT5_ORIGEM |
'576:001 ' + SEL->('TIPO: 'EL_TIPO' RECIBO: 'EL_RECIBO' DT EMIS.: '+DTOC(EL_EMISSAO)) |
CT5_LANPAD |
576 |
CT5_SEQUEN |
2 |
CT5_DESC |
MISCELLANEOUS RECEIPTS - REVERSAL OF A RECEIPT |
CT5_DC |
3 |
CT5_DEBITO |
1235 |
CT5_CREDIT |
1234 |
CT5_MOEDAS |
12222 |
CT5_VLR01 |
IF(SEL->EL_TIPODOC = 'TB',SEL->EL_VALOR,0) |
CT5_HIST |
'576:001 - REC DIV: ' + SE5->('BENEF.: 'E5_BENEF' HIST.: '+E5_HISTOR) |
CT5_ORIGEM |
'576:001 ' + SEL->('TIPO: 'EL_TIPO' RECIBO: 'EL_RECIBO' DT EMIS.: '+DTOC(EL_EMISSAO)) |
TABLE |
DESCRIPTION |
SE5 |
Bank Transaction |
SEL |
Collection Receipts |