01. OVERVIEW
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.
02. EXAMPLE OF USE
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)) |
03. TABLES USED
TABLE | DESCRIPTION |
|---|---|
SE5 | Bank Transaction |
SEL | Collection Receipts |
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas