Linha Microsiga Protheus - Inglês

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

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 layout information   


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.



Important:

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


Query to layout on 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.

If the system does not locate the bill, it will edit the status to Process Failure, to make it possible to conciliate system information with data provided by the bank.


Procedure

  1. Click in File Import, the Import wizard is displayed. Click Next.
  2. In File, click Open and enter the location of .TXT file, submitted by Caixa Econômica Federal.
  3. Click Next.
  4. The process table MCMV (FJP) is saved with file registers with Status LP – Cleared Paid, and the subtitle waiting processing.
  5. Select the bill and click BX Processing.
  6. Enter parameters according to process needs. Click OK.

     The system writes-off finance bills according to contract information, as long as values and expiration dates are equal.