0FG_DC02

Federal Government totals | #TRAN | Extraction method: F1 | Delta: ADDD | Component: Federal Government
Tables used: GLREFA, T882, T881, RSZGLOBV, RSCURTRT ... +5 more
Column Name Description
RLDNR Ledger
RVERS Version
RYEAR Fiscal Year
RTCUR Currency Key
RBUKRS Company Code
RACCT Account Number
RBUSA Business Area
RPRCTR Profit Center
RCNTR Cost Center
RPROJK Work Breakdown Structure Element (WBS Element)
RFAREA Functional Area
RFUND Fund
RFIPEX Commitment Item
RFISTL Funds Center
RORDNR Order Number
RVBUND Company ID of Trading Partner
RAGNCY_LCTN_CODE Agency Location Code
RFINUSE Application of Funds
LOGSYS Logical system
FMFG_SUBKEY_9 Subkey for FMUSFGT
BLSTATUS_9 Budgetary ledger status
FUND_TYPE FM Fund Type
FM_AREA Financial Management Area
CO_AREA Controlling Area
SGL_ACCOUNT Standard General Ledger Account for US Federal Government
MEASURE Funded Program
BUDGET_PD_9 Budget Period
VALUETYPE Value type for Reporting
CURTYPE Currency type Show values
FISCPER Fiscal year / period
Column Name Description
💲 Currency Key (CURRUNIT):
BALANCE Accumulated Balance
DEBIT Total Debit Postings
CREDIT Total Credit Postings
TURNOVER Sales of the Period
Column Name Description
Column Name Description
Column Name Description
CURTYPE Currency type Show values
UPMOD BW Delta Process: Record Mode Show values
VALUTYP Valuation View Show values
FLG_COVERED Covered Indicator Show values
FLG_CUSTODIAL Custodial Indicator Show values
FLG_ENTITY Entity Indicator Show values
FLG_EXCHANGE Exchange Indicator Show values
FLG_FEDERAL Federal/Nonfederal Code Show values
FLG_APPORT Apportionment Category Show values
FLG_AVAIL Availability Time Show values
FLG_BORROW Borrowing Source Show values
FLG_DEFINITE Definite/Indef indicator Show values
FLG_PARTNER Transaction Partner Show values
FLG_BEA Budget Enforcement Act Category Show values
FLG_REIMBUR Reimbursable Show values
FLG_AUTHOR Authority Type Show values
YEAR_BDGT_AUTH_9 Year of Budget Authority Show values
FLG_ADVANCE_9 Advanced Flag Show values
DEFENSE_INDIC_9 Defense Indicator / Reduction Type Show values
BDGT_IMPACT Budgetary Impact Show values
FLG_PYA Prior Year Adjustment Code Show values
AVTYPE Availability Type Code (A) Show values
FUNDINYEAR Fund flagged to be used in fiscal year Show values
FUNDEARMARKED Fund flagged as earmarked Show values
Column Name Description Domain name
FISCVAR Fiscal year variant RSFISCVAR
CHARTACCTS Chart of Accounts KTOPL
BUREAU Federal Bureau FM_BUREAU
BUSINESS_LINE Business Line FM_BUSINESS_LINE
FGDPRTMNT Federal Department FM_DEPARTMENT
FGDPRTMNT_PART Federal Department Partner FM_DEPARTMENT
FUND_ACC_SYMBL Main Account FM_MAIN_ACCT
LEGIS Type of Legislation FM_LEGIS
COHORT Reporting Year for Cohort FM_COHORT
PUBLAW Public Law Cited FM_PUBLAW
TRANSFER_AGCY_9 Transfer Agency FMFG_TRANSFER
TRANSFER_ACCT_9 Transfer Account FMFG_TRAN_ACCT
PROG_REPT_CAT Program Reporting Category FMFG_PROGRAM_REPORT_CATEGORY
APPOR_CATB_DTL_9 Apportionment Category B Program Code
PROGRAM_IND Disaster Emergency Fund Code FMFG_DISASTER_EMER_FUND_CODE3
TP_AGENCID Agency Identifier (AID) for Trading Partner FMFG_AGENCID
TP_MAIN_ACCT Main Account for Trading Partner
BETC Business Event Type Code CHAR10
SUBLEVL Sublevel Prefix (SP) FMFG_SUBLEVL
AGENCID Agency Identifier (AID) FMFG_AGENCID
ALTRAID Allocation Transfer Agency Identifier (ATA) FMFG_ALTRAID
BEGPER Beginning Period of Availability (BPOA) FMFG_BEGPER
ENDPER Ending Period of Availability (EPOA) FMFG_ENDPER
SUB_ACCT Subaccount FM_SUB_ACCT