Transfer to AP CYMA File Format

This format for the transfer to AP ASCII file is compatible with CYMA (version 10).

NOTE that this format is for use with ePO only.

When a user selects the CYMA format and runs the transfer to AP, a comma-separated (.CSV) file is created in the following format.

CYMA Version 10 (.csv) File Format

Field	Field Name	Description
1	GL Account	The expense code.
2	Unit Number	Blank field.
3	Description	The line item description.
4	Vendor Account	The vendor ID.
5	Vendor Name	The long name of the vendor.
6	NORM	Hard-coded as NORM.
7	Posting Date	The Posting Date based on the month and year of the current period, and the transfer number for the entity/propertycompany during that month and year.
8	Invoice #	The invoice number.
9	Invoice Date	The invoice date.
10	Batch #	The Batch ID that the invoice transaction was recorded.
11	Amount	The invoice amount.

Samples (2 records):

"6030","","line 1","10777","10-7 Cleaning and Services","NORM","08/01/2011","08/09/2011.001","08/09/2011","18688","300.00"

"5100 01","","Rent.Com","10777","10-7 Cleaning and Services","NORM","08/01/2011","cb122Invoice","08/15/2011","18690","815.00"