0FG_DO01

Federal Government line items | #TRAN | Extraction method: F1 | Delta: NEWE | Component: Federal Government
Tables used: GLREFAT882T881RSZGLOBVRSCURTRT ... +5 more
Column Name Description
RLDNR Ledger
Column Name Description
💲 Currency Key (CURRUNIT):
DEBIT Total Debit Postings
CREDIT Total Credit Postings
TURNOVER Sales of the Period
Column Name Description
Column Name Description
BUDAT Posting Date in the Document
WSDAT Value Date for Currency Translation
BLDAT Document Date in Document
CPUDT Day On Which Accounting Document Was Entered
CPUTM Time of Entry
ASSET_ACQDATE_9 Asset Value Date
Column Name Description
DOCCT Document Category Show values
REFDOCCT Reference Document Category 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_REIMBUR Reimbursable Show values
FLG_AUTHOR Authority Type Show values
FLG_BEA Budget Enforcement Act Category Show values
XSPLITMOD Item Changed by Document Splitting Show values
XSKRL Indicator: Line Item Not Liable to Cash Discount? 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_9 Budgetary Impact Show values
FLG_PYA_9 Prior Year Adjustment Code Show values
TP_AVTYPE_9 Availability Type Code (A) for Trading Partner Show values
AVTYPE_9 Availability Type Code (A) Show values
CURTYPE Currency type Show values
UPMOD BW Delta Process: Record Mode Show values
VALUTYP Valuation View 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
RVERS Version RVERS
RYEAR Fiscal Year GJAHR
POPER Posting period POPER
DOCNR Document Number of an Accounting Document BELNR
DOCLN Six-Character Posting Item for Ledger DOCLN6
RBUKRS Company Code BUKRS
RACCT Account Number SAKNR
RBUSA Business Area GSBER
RPRCTR Profit Center PRCTR
RCNTR Cost Center KOSTL
RPROJK Work Breakdown Structure Element (WBS Element) PS_POSNR
RFAREA Functional Area FKBER
RFUND Fund BP_GEBER
RFIPEX Commitment Item FM_FIPEX
RFISTL Funds Center FISTL
RORDNR Order Number AUFNR
RVBUND Company ID of Trading Partner RCOMP
RAGNCY_LCTN_CODE Agency Location Code FMFG_ALC
RFINUSE Application of Funds FM_FINUSE
LOGSYS Logical system LOGSYS
FMFG_SUBKEY_9 Subkey for FMUSFGT CHAR10
BLSTATUS_9 Budgetary ledger status FMFG_BLSTATUS
SGTXT Item Text TEXT50
DOCTY FI-SL Document Type DOCTY
ACTIV Business Transaction CHAR4
REFDOCNR Reference document number of an accounting document BELNR
REFRYEAR Reference fiscal year GJAHR
REFDOCLN Six-Digit Number of the Reference Posting Line BUZEI6
REFACTIV FI-SL Business Reference Transaction CHAR4
USNAM User Name XUBNAME
AWTYP Reference procedure AWTYP
AWORG Reference Organizational Units AWORG
PMT_OFFICE Payment Office FMFG_PMT_OFF
COHORT Reporting Year for Cohort FM_COHORT
PUBLAW Public Law Cited FM_PUBLAW
LEGIS Type of Legislation FM_LEGIS
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
AWID Reference document: Current identification AWID
BELNR Document Number of an Accounting Document BELNR
BUZEI Number of Line Item Within Accounting Document BUZEI
LINETYPE Item Category LINETYPE
FUND_TYPE FM Fund Type FM_FUNDTYPE
FM_AREA Financial Management Area FIKRS
MWSKZ Tax on sales/purchases code MWSKZ
CO_AREA Controlling Area CACCD
SGL_ACCOUNT Standard General Ledger Account for US Federal Government FM_SGL_ACCOUNT
BDGT_FUNC_CLSS Classification of Data According to Major Purpose CHAR3
FMCMMTSTR_9 FM Commitment String For Budgetary Ledger FMCMMTSTR
TRANSFER_AGCY_9 Transfer Agency FMFG_TRANSFER
TRANSFER_ACCT_9 Transfer Account FMFG_TRAN_ACCT
MEASURE Funded Program FM_MEASURE
XBLNR Reference Document Number XBLNR1
LIFNR Account Number of Supplier LIFNR
KUNNR Customer Number KUNNR
PROG_REPT_CAT_9 Program Reporting Category FMFG_PROGRAM_REPORT_CATEGORY
BUDGET_PD_9 Budget Period FM_BUDGET_PERIOD
ASSETMAINO_9 Main Asset Number BF_ANLN1
ASSETSUBNO_9 Asset Subnumber BF_ANLN2
MOVEMENTTYPE_9 Asset Transaction Type BWASL
NPLNR_9 Network Number for Account Assignment AUFNR
APLZL_9 Internal counter CIM_COUNT
AUFPL_9 Routing number of operations in the order AUFPL
PRZNR_9 Business Process CO_PRZNR
IMKEY_9 Internal Key for Real Estate Object IMKEY
INTRENO_9 Internal Real Estate Master Data Code VVINTRENO
APPOR_CATB_DTL_9 Apportionment Category B Program Code
PROGRAM_IND_9 Disaster Emergency Fund Code FMFG_DISASTER_EMER_FUND_CODE3
TP_SUBLEVL_9 Sublevel Prefix (SP) for Trading Partner FMFG_SUBLEVL
TP_AGENCID_9 Agency Identifier (AID) for Trading Partner FMFG_AGENCID
TP_ALTRAID_9 Allocation Transfer Agency Identifier (ATA) Trading Partner FMFG_ALTRAID
TP_BEGPER_9 Beginning Period of Availability (BPOA) for Trading Partner FMFG_BEGPER
TP_ENDPER_9 Ending Period of Availability (EPOA) for Trading Partner FMFG_ENDPER
TP_MAIN_ACCT_9 Main Account for Trading Partner
TP_SUB_ACCT_9 Subaccount for Trading Partner
BETC_9 Business Event Type Code CHAR10
TP_BETC_9 Business Event Type Code for Trading Partner
TREASURY_OFFS_9 Treasury Offset Program Eligibility
GARNISHMENT_9 Garnishment
SUBLEVL_9 Sublevel Prefix (SP) FMFG_SUBLEVL
AGENCID_9 Agency Identifier (AID) FMFG_AGENCID
ALTRAID_9 Allocation Transfer Agency Identifier (ATA) FMFG_ALTRAID
BEGPER_9 Beginning Period of Availability (BPOA) FMFG_BEGPER
ENDPER_9 Ending Period of Availability (EPOA) FMFG_ENDPER
SUB_ACCT_9 Subaccount FM_SUB_ACCT
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
VALUETYPE Value type for Reporting RSVTYPE
FISCPER Fiscal year / period RSFISCPER
FISCVAR Fiscal year variant RSFISCVAR
CHARTACCTS Chart of Accounts KTOPL
PROG_REPT_CAT Program Reporting Category (out) FMFG_PROGRAM_REPORT_CATEGORY