Linha Microsiga Protheus - Inglês

Páginas filhas
  • Minha Casa Minha Vida Processing (FINA915 - SIGAFIN)

Versões comparadas

Versão antiga 1

changes.mady.by.user Otto Alexandre Monteiro Altorfer

Gravado em

comparado com

Nova versão Atual

changes.mady.by.user Otto Alexandre Monteiro Altorfer

Gravado em

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

This routine processes the file, on the TXT format, available by Caixa Econômica Federal - CEF to collect from the project Minha Casa Minha Vida, of bills originated from TIN x Protheus integration. The file is structured on Caixa Real State Credit interface layout and with constructors, on the Disbursement Schedule Section layout Clearance Schedule - CL (DCD_CL)

 


Main layoutinformation   


Name Attribute

Description

dtMovimento

Reference date of due contract calculation.

siglaConstrutora

Identifies the constructor or CNPJ group of constructors that will be added on file.

NumeroAPF

Enterprise ID number on administration system of CAIXA enterprises.

idContrato

Contract identifying number of enterprise unit finance on CAIXA processing system.

PAR

Installment Number.

SEQ

Sequential number of installment number.

DT PARCELA

Expected dates for installments clearance.

STATUS

Installment status:


LB - Cleared Blocked
LD - Cleared Unlocked
LM - Cleared Manual
LP - Cleared Paid
PD - Expected unlocked
PL - Expected Cleared
PR - Expected
RP – Resources Own Expected


Apart from statuses LM and LP, the values are changed at every event on the schedule caused by reformulation, postponement, unblocking, unit aggregation or installment waiver.



Image ModifiedImportant:

For this feature the TIN x Protheus integration must be configured. The field Bill Contract (E1_CTRBCO) is completed through this integration.


...

Query to layouton Caixa Econômica Federal Bank 


  • File import: Reading of TXT file and recording of registers with LP – Paid Clearance status, with the Waiting Processing status
  • Write-off processing, based on registers imported from file
  • Locates the receivable bill that has the same contract number (E1_CTRBCO), Expiration date (E1_VENCREA), Value (E1_SALDO+E1_SDACRES-E1_SDDECRE) and runs the receipt on the bank indicated on routine.
  •  Status of register imported is updated to Processed.

...