{{ model.title }}
This page is currently being edited by {{ model.editingBy }}.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 |