SAM II Financial File Layouts

Advantage Tables - Full Backups

These record layouts are for the SAM II Advantage table backups that are created for the Data Warehouse nightly loads. The files contain all records on the SAM II Advantage table being backed up. They are created in each nightly cycle and are stored as generation datasets on disk. The files are named: OAAMS.DWPROD.LFSEQ.tablename.

Table Name Table Number Description
ABCP 0220 ABC Classification Parameter
ACAT 0004 Activity Category
ACCT 0001 Account Type
ACLS 0005 Activity Class
ACTV 0003 Activity Index
AGCL 0713 Agency Class
AGCT 0714 Agency Category
AGCY 0008 Agency Index
AGFA 0460 Agency Federal Aid Inquiry
AGGP 0715 Agency Group
AGPR 0455 Agency Project Inquiry
AGTP 0716 Agency Type
ALLC 0181 Allocation Group Control Reference
ALLT 0009 Allotment Inquiry
ALOG 0579 Approval Log
APPR 0010 Appropriation Index
APRD 0002 Accounting Period
ATYP 0007 Activity Type
BACC 0011 Balance Sheet Account Index
BANK 0015 Bank Account
BAS2 0813 Basis Code Definition
BBAL 0012 Balance Sheet Account Balance
BCAT 0013 Balance Sheet Category
BCLS 0014 Balance Sheet Class
BDIT 0481 Bid Tracking Information
BDMH 0277 Bid Master Header
BDML 0278 Bid Mast Line
BGRP 0297 Balance Sheet Group
BIDH 0279 Bid Tracking Header
BIDL 0283 Bid Tracking Line
BIDR 0279 Bid Response Input
BILL 0550 Billing Address
BOBC 0806 Budget Object Class
BPCC 0787 Billing Profile Collection Cycle
BPRO 0786 Billing Profile
BUYT 0242 Buyer
CAAT 0566 Cost Allocation Account Type
CADO 0571 Cost Allocation Distribution Options
CHRG 0056 Charge Class
CLDT 0016 Calendar Date
COCL 0406 Commodity Class
COMM 0017 Commodity Index
CSCC 0408 Commodity Sub-Class by Commodity Class
CUSC 0760 Customer Credit History Inquiry
DATE 0160 Date
DDGR 0491 Drawdown Group
DDRQ 0486 Drawdown Request
EFTA 0891 Electronic Funds Transfer Type
EFTT 0890 Electronic Funds Transfer
EXPB 0018 Expense Budget Index
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
OGRP 0295 Object Group
OLOG 0584 Override Log
OPCH 0901 Open Check Header Inquiry
OPCL 0902 Open Check Line Inquiry
OPPC 0247 Open Purchase Order Commodity Line Inquiry
OPPH 0245 Open Purchase Order Header Inquiry
OPPL 0246 Open Purchase Order Account Line Inquiry
OPVH 0032 Open Payment Voucher Header Inquiry
OPVL 0033 Open Payment Voucher Line Inquiry
ORCH 0248 Open Receiver Header Inquiry
ORCL 0249 Open Receiver Line Inquiry
OREH 0747 Open Receivable Header Inquiry
OREL 0768 Open Receivable Line Inquiry
ORGN 0034 Organization Index
ORQC 0252 Open Requisition Commodity Line Inquiry
ORQH 0250 Open Requisition Header Inquiry
ORQL 0251 Open Requisition Account Line Inquiry
OSRC 0227 Open Stock Requisition Line Inquiry
OSRH 0228 Open Stock Requisition Header Inquiry
OSRL 0226 Open Stock Requisition Account Line Inquiry
OTRH 0229 Open Stock Transfer Receipt Header Inquiry
OTRL 0230 Open Stock Transfer Receipt Line Inquiry
OTYP 0294 Object Type
OVIH 0253 Open Vendor Invoice Header Inquiry
OVIL 0254 Open Vendor Invoice Line Inquiry
PACC 0183 Pool Accumulation Inquiry
PACT 0512 Phase/Activity
PASC 0276 Price Agreement Security
PASM 0274 Price Agreement Summary
PATX 0273 Price Agreement Text
PAVC 0275 Price Agreement Vendor/Commodity
PAVT 0758 Price Agreement Vendor Text
PBDF 0180 Pool/Base Definition Reference
PBFS 0505 Funding Source
PCTX 0759 Price Agreement Commodity Text
PERF 0057 Performance Actual Inquiry
PFST 0500 Project Funding Source Inquiry
PGPV 0517 Program Provider
PMTB 0058 Performance
PRBL 0454 Project Budget Line Inquiry
PROV 0036 Provider
PRPH 0452 Project Phase
PRST 0451 Project Status Code
PSHD 0777 Payment Schedule
PTEX 0269 Purchasing Text
RCAT 0039 Revenue Category
RCLS 0040 Revenue Class
RCTX 0271 Requisition Text
REJV 0211 Recurring Journal Voucher
REPV 0212 Recurring Payment Voucher
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