OIRE_RECON_DET

Detailed reconciliation data | #transactional | Component: Service Station Retailing
Column Name Description
MANDT FK Client
UPLNR FK Clearing House Upload Number (internal)
POSNR Item number of a recon. upload number
Column Name Description
💲 Currency Key (WAERS):
BRTWR SSR PC: Gross value
Column Name Description
Column Name Description
Column Name Description
ENCTP Type of Encryption Show values
Column Name Description Domain name
CCNUM SSR PC: Payment card number OIRE_CCNUM
SALES_TIMESTMP Sales timestamp (Format: YYYYMMDDhhmmss) TZNTSTMPS
TERMNR SSR PC: Receipt number of terminal at bus. location NUMC10
AUTNR SSR PC: Authorization number CHAR20
SSMID SSR PC: Service station merchant ID OIRE_SSMID
SSMIDT SSR PC: Service station merchant ID text OIRE_SSMIDTX
RECON_NO Reconciliation run number OIRE_RECON_NO
SETTLNR SSR PC: CH settlement and/or transmission document number OIRE_SETTLNR
CGUID GUID of a Payment Card SYSUUID
CRYPTIC_HASH Hash Value of a Payment Card Number
Master Data Relations Join Conditions
SSR PC: Payment card type
  • SSR PC: Payment card type
  • Client
Client OIRE_RECON_DET.MANDT == T000.MANDT
Business location identifier (IS-Oil MRN)
  • Business location identifier (IS-Oil MRN)
  • Client
  • OIRE_RECON_DET.PBLNR == OIFSPBL.PBLNR
  • OIRE_RECON_DET.MANDT == OIFSPBL.MANDT