OIRE_RECON_DET - Detailed reconciliation data
Detailed reconciliation data information is stored in SAP table OIRE_RECON_DET.
It is part of development package OIR_E in software component IS-OIL-DS-SSR. This development package consists of objects that can be grouped under "SSR Card processing (IS-Oil Sevice Station Retailing)".
It is part of development package OIR_E in software component IS-OIL-DS-SSR. This development package consists of objects that can be grouped under "SSR Card processing (IS-Oil Sevice Station Retailing)".
Fields for table OIRE_RECON_DET
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
UPLNR | Clearing House Upload Number (internal) | X | OIRE_UPLNR_RECON | CHAR | 20 | OIRE_RECON_ADM |
POSNR | Item number of a recon. upload number | X | OIRE_POSNR_RECON | NUMC | 12 | |
PBLNR | Business location identifier (IS-Oil MRN) | OIF_PBLNR | CHAR | 20 | OIFSPBL | |
CCINS | SSR PC: Payment card type | OIRE_CCINS | CHAR | 8 | OIREPCTYP | |
CCNUM | SSR PC: Payment card number | OIRE_CCNUM | CHAR | 50 | ||
SALES_TIMESTMP | Sales timestamp (Format: YYYYMMDDhhmmss) | OIRE_SALES_TIMESTAMP_UTC | DEC | 8 | ||
TERMNR | SSR PC: Receipt number of terminal at bus. location | OIRE_TERMNR | NUMC | 20 | ||
BRTWR | SSR PC: Gross value | OIRE_BRTWR | CURR | 7 | ||
WAERS | Currency Key | WAERS | CUKY | 10 | * | |
AUTNR | SSR PC: Authorization number | OIRE_AUTNR | CHAR | 40 | ||
SSMID | SSR PC: Service station merchant ID | OIRE_SSMID | CHAR | 40 | ||
SSMIDT | SSR PC: Service station merchant ID text | OIRE_SSMIDTX | CHAR | 100 | ||
RECON_NO | Reconciliation run number | OIRE_RECON_NO | CHAR | 20 | * | |
SETTLNR | SSR PC: CH settlement and/or transmission document number | OIRE_SETTLNR | CHAR | 20 | * | |
CGUID | GUID of a Payment Card | CARD_GUID | RAW | 16 | ||
ENCTP | Type of Encryption | CCSECA_ENCTYPE | CHAR | 2 | ||
CRYPTIC_HASH | Hash Value of a Payment Card Number | CCSECA_CRYPTIC_HASH | CHAR | 80 |