OIREUPLKXXXX

SSR PC: Template for generated DTF tables (header) | #template | Component: Service Station Retailing
Column Name Description
MANDT FK Client
GJAHR Fiscal Year
UPLNR SSR PC: DTF payment card transaction number (internal)
Column Name Description
💲 Currency Key (WAERS):
BRTWR SSR PC: Gross value
Column Name Description
Column Name Description
UPLDAT SSR PC: Upload date
UPLTIM SSR PC: Upload time
VKDAT SSR PC: Sales date at the service station
VKTIM SSR PC: Time of sale
DATAB SSR PC: Valid from date of the payment card
DATBI SSR PC: Expiry date of payment card
BLDAT SSR PC: Black list date
SETTLDAT SSR PC: Settlement date to the clearing house
RECON_DAT Reconciliation run date
ERDAT Date on which the record was created
ERTIM Time of creation
AEDAT Last Changed On
AETIM Time of day the record was changed
Column Name Description
ENCTP Type of Encryption Show values
ECPRZ SSR PC: Check digit of account number Show values
COMPFL SSR PC: Complaint status flag Show values
SRCID SSR PC: Data source indicator Show values
DCIND SSR PC: DTF - Debit/credit indicator for a PC transaction Show values
WROFLAG SSR PC: Write off flag for complaint transactions Show values
Column Name Description Domain name
TERMID SSR PC: Terminal ID at business location CHAR20
TERMNR SSR PC: Receipt number of terminal at bus. location NUMC10
CASHIER SSR PC: Number of the cashier CHAR10
CSHNAME SSR PC: Name of the cashier CHAR35
CCNUM SSR PC: Payment card number OIRE_CCNUM
SSR_ADDINFO SSR PC: Additional payment card information CHAR20
CCFOL Payment cards: Payment card suffix CHAR10
AUTNR SSR PC: Authorization number CHAR20
BLVER SSR PC: Version of black list CHAR20
CGUID GUID of a Payment Card SYSUUID
CRYPTIC_HASH Hash Value of a Payment Card Number
TRCNR SSR PC: Trace number NUMC10
AID SSR PC: Authorization ID for EC cards CHAR08
AIDPA SSR PC: Authorization ID parameter CHAR10
ECTYP SSR PC: EC card type CCTYP
ECFOL SSR PC: EC card suffix NUMC2
ECBHS SSR PC: Industry main key CHAR2
ECBLZ SSR PC: Bank number CHAR10
ECSEP SSR PC: Field separator CHAR1
ECKTO SSR PC: Account number of the customer NUMC24
ISSUER SSR PC: EC card issuer CHAR2
MILES SSR PC: Odometer reading NUMC6
VEHICLE SSR PC: Number of the vehicle (fleet cards) CHAR6
DRIVER SSR PC: Driver number (for fleet cards) CHAR6
STORNO SSR PC: Reversal indicator CHAR1
STFLG SSR PC: Statistical update of PC data CHAR1
LINKYEAR Document link number year GJAHR
LINKNR Link number NUMC10
SETTLNR SSR PC: CH settlement and/or transmission document number OIRE_SETTLNR
SETTITEM SSR PC: Settlement document item number POSNR
TRNSMNR SSR PC: Transmission number OIRE_SETTLNR
DTFNR SSR PC: Preceding DTF doc. number in case of a reversal CHAR14
RECON_NO Reconciliation run number OIRE_RECON_NO
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
Master Data Relations Join Conditions
SSR PC: Clearing house
  • SSR PC: Clearing house
  • Client
  • OIREUPLKXXXX.CHOBJ == OIRECH.CHOBJ
  • OIREUPLKXXXX.MANDT == OIRECH.MANDT
SSR PC: Complaint Results -> OIRECOMPRES
  • SSR PC: Complaint result
  • Client
Client OIREUPLKXXXX.MANDT == T000.MANDT
Business Location
  • Business location identifier (IS-Oil MRN)
  • Client
  • OIREUPLKXXXX.PBLNR == OIFSPBL.PBLNR
  • OIREUPLKXXXX.MANDT == OIFSPBL.MANDT
SSR PC: Customer sales status
  • SSR PC: Customer sales status
  • Client
SSR PC: Splitting result
SSR PC: Payment card type
  • SSR PC: Payment card type
  • Client
SSR PC: Payment card category
  • SSR PC: Payment card category
  • Client
SSR PC: Validation routine OIREUPLKXXXX.VAL_ROUTINE == OIRE_VAL_VAL.VAL_ROUTINE
currency check field for DTF Header OIREUPLKXXXX
  • OIREUPLKXXXX.MANDT == TCURC.MANDT
  • OIREUPLKXXXX.WAERS == TCURC.WAERS