Transfer to AP Timberline File Format

Transfer to AP—Timberline File Format

This format for the transfer to AP is an ASCII file that is compatible with Timberline.

Note

This format is for use with ePO only.

When a user selects the Timberline format and runs the Transfer to AP process, a comma-separated (.csv) file is created in the following format.

Timberline File Format

This is a comma-separated file with all Alpha data type fields in double quotes.
At least one APD (Distribution Line) per API (Invoice Line) is required for each invoice exported from the AMSI database. There can be multiple ADPs for each invoice, but at a minimum one ADP separates each API.
Every field in the layout must be represented, although the application does not populate all fields. The layout consists of fields 1–14 for API Invoice and 1–17 for API Distribution. If a field is not used, it will be represented by empty " ", and then separated by commas.

Field	Field Name	Field Type	Length	Values or Format
Record—API Invoice
1	API	Format ID		API
2	Vendor	Alpha	10
3	Invoice	Alpha	15
4	Description	Alpha	30
5	Amount	Numeric
6	Invoice Date	Date		mm/dd/yyyy
7	Payment Date	Date		mm/dd/yyyy
8	Accounting Date	Date		mm/dd/yyyy
9	Summary Payee Name	Alpha	30
10	Summary Payee Address 1	Alpha	33
11	Summary Payee Address 2	Alpha	33
12	Summary Payee City	Alpha	30
13	Summary Payee State	Alpha	4
14	Summary Payee Zip	Alpha	10
Record—API Distribution
1	APD	Format ID		APD
2	Contract / P.O.	Alpha	12
3	Contract / P.O. Line Item	Numeric	5
7	Expense Account	Alpha	19	PropertyIDCompanyID-Expense Code
11	Amount	Numeric
13	1099 Exempt	Check Box
15	Description	Alpha	30

Samples (API and APD are separate lines):

"API","10777","08/09/2011.001","testing month end create recur","300.00","08/09/2011","08/09/2011","08/09/2011","10-7 Cleaning and Services","28317 Courtney Ln.","","Ponchatoula","LA","70454"

"APD","","","","","","CB122-6030","","","","300.00","","N","","line 1","",""

"API","10777","cb122Invoice","815.00","815.00","08/15/2011","08/15/2011","08/15/2011","10-7 Cleaning and Services","28317 Courtney Ln.","","Ponchatoula","LA","70454"

"APD","","","","","","CB122-5100 01","","","","815.00","","N","","Rent.Com","",""