howto: Interface to Finance 


The ‘Build AP Interface” option on Menu 47 creates a file of check requests which can be – assuming that the receiving financial system supports importing data files – sent to finance electronically.

DC1030-1 Create Day Care A/P Interface 6/10/96
SELECT 8:07:08


A/P Batch#...... _______ (Blank = New Batch)


Enter Batch# only if re-processing a PREVIOUS Batch

...

* *
Output Queue: PRT04_____ # of Copies: __1_ Hold?: N Save?: N


* *

ENTER F2 = Chg Print Defaults F3 = End


Format of the Day Interface file

The Interface file is detail file. It contains one record per Service Unit per child per vendor.

Field Text Len Dec 
DCYEAR ATTENDANCE YR 4 0 
DCRMTH ATTENDANCE MONTH 2 0 Month the service was received
DCPSER SERVICE CODE 5 The funding source program – eg, SS, START, TANF
DCVND# VENDOR NUMBER 5 0 
DCVSTE VENDOR SITE 2 0 
DCPER# PERSON NUMBER 9 0 
DCVSU SERVICE UNIT 1 ONECase code for 100/75/50 – eg F/Q/P/S/1/2 
DCLSEQ SEQUENCE# 7 0 
DCFTYP FEE TYPE 1 A=Regular Care , E=Enhancement , D=Food Fee 
DCRPYR REPORTING YR 4 0 
DCRPMO REPORTING MONTH 2 0 
DCVNID AP VENDOR ID 12 ID used by Accounts Payable system 
DCFEET TOTAL CHARGES 7 2 
DCFEEC CO-PAY FEE 7 2 
DCFEEV VENDOR GROSS 7 2 
DCFEED VENDOR DUE 7 2 
DCBCH# VOUCHER BATCH# 7 0 
DCDVCH VOUCHER DATE 8 0 
DCVCH# VOUCHER # 9 0 
DCANFD ACCT# FUND 3 0 Fund field defined on Fund Account option on menu 48
DCANAG ACCT# AGENCY 3 0 
DCANOR ACCT# ORG 4 0 
DCANSO ACCT# SUB-ORG 2 0 
DCANOB ACCT# OBJECT 4 0 
DCANSB ACCT# SUB-OBJ 2 0 
DCAPB# A/P BATCH# 7 0 

The Interface Report
The program produces a report. Even though the file is a detail file, the report summarizes the detail into one line per vendor per account number.

Interface to OneFinancials
If you are using the Cox and Company financial system know as OneFinancials, the program creates APAYB and APAYD records.