DFKKEXC_PAYINFO

Information for Payment Medium | #transactional | Component: Contract Accounts Receivable and Payable
Column Name Description
MANDT Client
OFFIC Branch in Cash Journal
CHDSK Cash Desk
PAYID ID of External Payment
PAYTP Category of Payment/Payment Lot Show values
POSNR Item Number of External Payment
Column Name Description
💲 Currency Key (CCWAE):
AUTWR Payment cards: Authorized amount
💲 Currency Key (WAERS):
BETRW Amount in Transaction Currency with +/- Sign
Column Name Description
Column Name Description
DATAB Payment cards: Valid from
DATBI Payment Cards: Valid To
AUDAT Payment cards: Authorization date
AUTIM Payment cards: Authorization time
EXPDT Payment Cards: Authorization Expiry Date
EXPTM Payment Cards: Authorization Expiration Time
BUDAT Posting Date in the Document
VALUT Value date
Column Name Description
PAYTP Category of Payment/Payment Lot Show values
ENCTP Type of Encryption Show values
AUART Payment Cards: Authorization Type Show values
XPGRO Post Office Bank Current Account Show values
Column Name Description Domain name
CCNUM Payment cards: Card number CCNUM
CCFOL Payment cards: Payment card suffix CHAR10
CCNAME Payment cards: Name of cardholder TEXT40
CGUID GUID of a Payment Card SYSUUID
AUNUM Payment cards: Authorization number CHAR25
AUTRA Payment Cards: Authorization Reference Number CHAR25
EXTMP Payment Cards: Auth. Expiration Time Stamp (External) CHAR40
AUTMP Payment Cards: Authorization Timestamp (External) CHAR40
AUCID Payment Cards: Payment ID (Authorization with Billing) CHAR40
AVREF Payment Card: Payment Advice Note Reference with Settlement TXT40
DP_AUTH_REL_ID Unique identifier of a previous successful authorization FAR_DP_AUTH_REL_ID
DP_FRAUD_RISK Code of Fraud Risk DP_FRAUD_RISK_CODE
CHCKN Check number CHCKN
BANKL Bank Number BANKL
BANKS Country/Region Key of Bank LAND1
BANKN Bank account number BANKN
BKONT Bank Control Key BKONT
BKREF Reference Details for Bank Details CHAR20
PSTNO Number of Postal Order
Master Data Relations Join Conditions
Company Code
  • DFKKEXC_PAYINFO.MANDT == T001.MANDT
  • DFKKEXC_PAYINFO.BUKRS == T001.BUKRS
Payment Card Type
  • DFKKEXC_PAYINFO.MANDT == TB033.MANDT
  • DFKKEXC_PAYINFO.CCINS == TB033.CCINS
Payment cards: Merchant ID at the clearing house
  • DFKKEXC_PAYINFO.MANDT == TCCM.MANDT
  • DFKKEXC_PAYINFO.MERCH == TCCM.MERCH
Currency Key
  • DFKKEXC_PAYINFO.MANDT == TCURC.MANDT
  • DFKKEXC_PAYINFO.WAERS == TCURC.WAERS