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 |
|---|---|---|
| RETX | 0770 | Open Receivable Text |
| REVB | 0038 | Revenue Budget Index |
| RGRP | 0296 | Revenue Group |
| RPAT | 0605 | MoDOT Recurring Payment Account |
| RPDT | 0606 | MoDOT Recurring Payment Distribution |
| RPET | 0607 | MODOT Recurring Payment Entry |
| RPHT | 0609 | MoDOT Recurring Payment History |
| RPMT | 0608 | MoDOT Recurring Payment Master |
| RPTG | 0037 | Reporting Category |
| RQST | 0256 | Requisition Status Inquiry |
| RSRC | 0041 | Revenue Source Index |
| RSTA | 0257 | Requisition Status Code |
| RTYP | 0290 | Revenue Type |
| RXTX | 0268 | Requisition Text |
| SHIP | 0258 | Shipping Address |
| SOBJ | 0042 | Sub-Object |
| SOPT | 0045 | System Control Options |
| SORG | 0043 | Sub-Organization |
| SPDT | 0514 | Sub-Project Description |
| SPEC | 0046 | System Special Accounts |
| SPIS | 0095 | Special Instructions |
| SPRG | 0509 | State-Bond Program |
| SPSR | 0515 | Sponsor |
| SREV | 0044 | Sub-Revenue Source |
| STCN | 0940 | Stimulus County/Region |
| STCT | 0942 | Stimulus Category |
| STDS | 0270 | Standard Specifications |
| STIM | 0939 | Stimulus Program Master |
| STPC | 0941 | Stimulus Program Code |
| STSP | 0938 | Stimulus Specifications Table |
| TPAR | 0764 | Third Party Billing |
| TRTT | 0388 | Transaction Type |
| TYPE | 0574 | Requisition Type |
| UNIT | 0261 | Unit of Measure |
| UTAB | 0419 | User ID by Name Inquiry |
| VCSC | 0554 | Vend Class Subclass Table |
| VEN4 | 0833 | Vendor |
| VEND | 0047 | Vendor Index |
| VENI | 0830 | Vendor Indicator |
| VITX | 0272 | Vendor Invoice Text |
| VPER | 0284 | Vendor Performance Inquiry |
| VTXT | 0386 | Vendor Text |
| WHSE | 0232 | Warehouse Management Index |
| WPJC | 0603 | MoDOT Work ID to Project/Job/Reporting Crosswalk |