/DSD/HH_RAEC

DSD Route Settlement: Receipts/Expenditures | #transactional | Component: Download/Upload
Column Name Description
CLIENT FK Client
TOUR_ID FK DSD Route Settlement: Tour ID
VISIT_ID DSD - RA: Visit ID
CASH_ID DSD - RA: Receipts/Expenditures ID
Column Name Description
💲 Currency Key (CURR):
AMOUNT DSD - RA: Payment Amount
Column Name Description
Column Name Description
VALID_DATE Payment Cards: Valid To
Column Name Description
CASH_TYP DSD - RA: Receipts/Expenditures Indicator Show values
STATUS DSD - RA: Processing Status of the Data Record Show values
NOK DSD - RA: Data Record is Incorrect Show values
Column Name Description Domain name
PAYMT_DESCR Purpose of Bank Transfers TEXT40
CARDNR DSD - RA: HH Payment Card Number CHAR25
CHECKNR Check number CHCKN
BKNR Bank Number BANKL
ACCTNR Account Number of the Clearing Account KTO16
OI_CSH_POST Document Number of an Accounting Document BELNR
FISC_YEAR Fiscal Year GJAHR
CARD_GUID GUID of a Payment Card SYSUUID
Master Data Relations Join Conditions
Payment cards: Card type
  • /DSD/HH_RAEC.CLIENT == TVCIN.MANDT
  • /DSD/HH_RAEC.CARD_TYP == TVCIN.CCINS
Client /DSD/HH_RAEC.CLIENT == T000.MANDT
Company Code
  • /DSD/HH_RAEC.CLIENT == T001.MANDT
  • /DSD/HH_RAEC.COMPCOD == T001.BUKRS
Currency Key
  • /DSD/HH_RAEC.CLIENT == TCURC.MANDT
  • /DSD/HH_RAEC.CURR == TCURC.WAERS
DSD - RA: HH Payment Method