Export File Layout

  • Originally included in SmartFusion for the Town of Hillsborough, NC

For Daily/ Historical Actual Export

Field Comments
Account Number fl141.cacct
Fund fl141Segments.Fund
Fund Name csi21.cfunddesc
Fund Category Not included
Department fl141Segments.Department
Department Name csi25.cdeptdesc
Division Not included
Division Name Not included
Object Category Not included
Object Category Name Not included
Object fl141Segments.Object
Object Name csi23.cobjname
Account Type ListCode.Description for Type 'ACCTTYPE'
Function fl141Segments.Func
Function Name csi22.cfuncdesc
Location fl141Segments.Location
Location Name csi24.clocdesc
Object Group fl141Segments.ObjectGroup
Object Group Name csi30.cprogdesc
Cost Center fl141Segments.CostCenter
Cost Center Name csi36.ccostdesc
Job Class fl141Segments.JobClass
Job Class Name csi35.cjobdesc
Modifier fl141Segments.Modifier
Modifier Name csi34.cmodifdesc
Fiscal Year
Unique Transaction Identifier fl144id
Effective Date fl144.dposting
Last Edit Date fl144.ModifyDateTime
Transaction Amount fl144.ypostamt
Debit Amount fl144.ypostamt > 0
Credit Amount fl144.ypostamt < 0
Description fl144.cpostref
System fl144.cmodcode
Check Number fl144.icheckno
Check Date ap128.dcheck
Vendor Number ap121.cvndrno
Vendor Name ap121.cname
Invoice Number ap122.cinvoiceno
Purchase Order Number in102.ipono
Encumbrance Amount Function GetAccountEncumbrancePointInTimeBudgetReport()

For Daily/Historical Budget Export

Field Comments
Account Number fl141.cacct
Fund fl141Segments.Fund
Fund Name csi21.cfunddesc
Fund Category Not included
Department fl141Segments.Department
Department Name csi25.cdeptdesc
Division Not included
Division Name Not included
Object Category Not included
Object Category Name Not included
Object fl141Segments.Object
Object Name csi23.cobjname
Account Type ListCode.Description for Type 'ACCTTYPE'
Function fl141Segments.Func
Function Name csi22.cfuncdesc
Location fl141Segments.Location
Location Name csi24.clocdesc
Object Group fl141Segments.ObjectGroup
Object Group Name csi30.cprogdesc
Cost Center fl141Segments.CostCenter
Cost Center Name csi36.ccostdesc
Job Class fl141Segments.JobClass
Job Class Name csi35.cjobdesc
Modifier fl141Segments.Modifier
Modifier Name csi34.cmodifdesc
Fiscal Year
Current Budget Amount Adopted Budget Amount - YTD used - Encumbrances
Adopted Budget Amount Approved + Amendments