SAM II Financial File Layouts
Advantage Ledger Files
Listed below are record layouts for the SAM II Advantage Financial Ledgers. The files are created during nightly or monthly processing and are stored as generation datasets on disk.
| Table Name | Table Number | Description |
|---|---|---|
| EXPD | 0733 | Expense Budget Detail Inquiry |
| FADF | 0139 | Acquisition Depreciation Changes Inquiry |
| FADM | 0162 | Acquisition/Disposition |
| FAGL | 0237 | Fixed Asset Group Location Inquiry |
| FAGY | 0021 | Fund Agency Index |
| FAIM | 0904 | Fixed Asset Infastructure Maintenance |
| FAIT | 0465 | Federal Aid Interface |
| FALC | 0552 | Fixed Assets Location Inquiry |
| FAPP | 0453 | Federal Highway Appropriation |
| FAPV | 0187 | Generated Fixed Asset Acquisition Transaction Inquiry |
| FAS1 | 0178 | Fixed Asset Summary Inquiry |
| FAST | 0466 | Federal Aid Status |
| FATP | 0184 | Fixed Asset Type |
| FBAL | 0022 | Fund Balance |
| FBLT | 0462 | Federal Aid Budget Line Inquiry |
| FBT1 | 0179 | Fixed Asset Betterment Inquiry |
| FCAT | 0292 | Fund Category |
| FCCA | 0311 | Function Category |
| FCCL | 0312 | Function Class |
| FCGR | 0313 | Function Group |
| FCLG | 0177 | Fixed Asset Catalog |
| FCTP | 0314 | Function Type |
| FDGP | 0293 | Fund Group |
| FEAG | 0467 | Federal Agency |
| FGCS | 0172 | Fixed Asset Group Class |
| FGCT | 0186 | Fixed Asset Group Category |
| FGRP | 0185 | Fixed Asset Group |
| FHIS | 0903 | Fixed Asset History Inquiry |
| FLCS | 0175 | Fixed Asset Location Class |
| FLCT | 0174 | Fixed Asset Location Category |
| FLOC | 0173 | Fixed Asset Location |
| FSYR | 0019 | Fiscal Year |
| FTYP | 0023 | Fund Type |
| FUNC | 0310 | Function |
| FUND | 0020 | Fund Index |
| GASB | 0731 | GASB Type |
| GBMJ | 0730 | GASB Major Type |
| GVFA | 0464 | Government-Wide Federal Aid Inquiry |
| ICPE | 0812 | Inquiry Cost Percentage Entry |
| INVN | 0223 | Inventory Inquiry |
| ITMG | 0225 | Item Group |
| JOBT | 0050 | Job Index |
| JORG | 0099 | Job Organization |
| MPAH | 0803 | Price Agreement Header Modification Header |
| MPSM | 0804 | Price Agreement Summary Mod Inquiry |
| MWBE | 0931 | MBE/WBE Subcontracting Percentage |
| NOTE | 0393 | Note Table |
| OBJT | 0025 | Object Index |
| OCAT | 0026 | Object Category |
| OCLS | 0027 | Object Class |