I_CADocumentGLItemPaymentData

Payment Data for GL Document Item | view: ICADOCGLIPAY | TRAN | Extraction: Not supported | Component: Contract Accounts Receivable and Payable
Tables used: DFKKOPKC
Column Name Description
CADocumentNumber Number of a FI-CA Document
CAGLItemNumber Item Number in FI-CA Document
Column Name Description
💲 Currency Key (AuthorizationCurrency):
AuthorizedAmountInAuthznCrcy Payment cards: Authorized amount
💲 Currency Key (TransactionCurrency):
CAAmountInTransactionCurrency Amount in Transaction Currency with +/- Sign
CASettlementChargeAmountInTC Charge for Billed Payment in Transacton Currency
💲 Payment Cards: Settlement Currency (SettlementCurrency):
CASettlmtAmountInSettlmtCrcy Payment Cards: Settled Amount
Column Name Description
Column Name Description
PaymentCardValidityStartDate Payment cards: Valid from
PaymentCardValidityEndDate Payment Cards: Valid To
AuthorizationDate Payment cards: Authorization date
AuthorizationTime Payment cards: Authorization time
AuthorizationExpirationDate Payment Cards: Authorization Expiry Date
AuthorizationExpirationTime Payment Cards: Authorization Expiration Time
CAPostingDate Posting Date in the Document
ValueDate Value date
CreationDate Created On
CreationTime Time of Data Entry
Column Name Description
CAAuthorizationType Payment Cards: Authorization Type Show values
CAPaymentBillingStatus Billing Status Show values
CAPaytCardSupplementIsResent Payment Card Supplement Was Resent Show values
EncryptionType Type of Encryption Show values
OriginalSourceOfCredit Origin of Credit Memo Posting Show values
Column Name Description Domain name
PaytCardByDigitalPaymentSrvc Payment cards: Card number CCNUM
PaymentCardSequenceNumber Payment cards: Payment card suffix CHAR10
PaymentCardHolderName Payment cards: Name of cardholder TEXT40
PaymentCardMaskedNumber Masked Payment Card Number ( Digital Payment ) DP_MASK_NUMBER
CAAuthznByDigitalPaytSrvc Payment cards: Authorization number CHAR25
CAAuthorizationByAcquirer Payment Cards: Authorization Reference Number CHAR25
CAPaymentIDAuthznWithBilling Payment Cards: Payment ID (Authorization with Billing) CHAR40
CASettlementPaymentAdviceRef Payment Card: Payment Advice Note Reference with Settlement TXT40
PaymentCardAuthznRelationID Unique identifier of a previous successful authorization FAR_DP_AUTH_REL_ID
DigitalPaymentFraudRisk Code of Fraud Risk DP_FRAUD_RISK_CODE
CASettlementDocument Document Number of Billing Document OPBEL_KK
CAReturnLot Returns Lot for a Non-Billable Payment KEYR1_KK
CAReturnReason Returns Reason for Non-Billable Payments RLGRD_KK
CAPaymentCardSettlementID Payment Card Billing ID CHAR32
CreatedByUser Name of Person Who Created Object BNAME
PaymentCardUUID GUID of a Payment Card SYSUUID
CAKeyForPaymentCardSupplement Key for Payment Card Supplement
PaymentRefByPaytSrvcProvider Payment Reference of Payment Service Provider COM_WEC_PSP_TRANSACTION_ID
OriglPaytRefByPaytSrvcProvider Payment Reference of Payment Service Provider COM_WEC_PSP_TRANSACTION_ID
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • I_CADOCUMENTGLITEMPAYMENTDATA.MANDT == T001.MANDT
  • I_CADOCUMENTGLITEMPAYMENTDATA.COMPANYCODE == T001.BUKRS
Payment cards: Merchant ID at the clearing house
  • Payment cards: Merchant ID at the clearing house
  • Client
  • I_CADOCUMENTGLITEMPAYMENTDATA.MERCHANTBYCLEARINGHOUSE == TCCM.MERCH
  • I_CADOCUMENTGLITEMPAYMENTDATA.MANDT == TCCM.MANDT
Payment Card Type
  • Payment Card Type
  • Client
  • I_CADOCUMENTGLITEMPAYMENTDATA.PAYMENTCARDTYPE == TB033.CCINS
  • I_CADOCUMENTGLITEMPAYMENTDATA.MANDT == TB033.MANDT
Currency Key
  • Client
  • Currency Key
  • I_CADOCUMENTGLITEMPAYMENTDATA.MANDT == TCURC.MANDT
  • I_CADOCUMENTGLITEMPAYMENTDATA.TRANSACTIONCURRENCY == TCURC.WAERS