TRPRT_PAYMENTS

Persistent Data for Payment Requests | #transactional | Component: Transfer to Financial Accounting
Column Name Description
MANDT Client
OS_GUID Globally Unique Identifier
Column Name Description
💲 Payment Currency (PAYMENT_CURR):
PAYMENT_AMT Payment Amount
Column Name Description
Column Name Description
PAYMENT_DATE Payment Date
REVERSAL_DATE Posting Date in the Document
CREATE_DATE First Entered On
CREATE_TIME Time of Creation
CHANGE_DATE Last Edited On
CHANGE_TIME Last Edited At
Column Name Description
SPAYRQ Generate Payment Request Show values
SPRSNG Individual payment required Show values
SCSPAY Same Direction Necessary for Joint Payment? Show values
SIGN Direction of Flow Show values
SPRGRD Determine Grouping Definition Show values
PAYMENT_STATE Status of Payment Request Show values
RELEASE_STATE Release Status for Payment Requests Show values
URGENT Indicator: Extremely Urgent Payment Show values
DTAMS Report key for data medium exchange Show values
PAYMENT_CAT Payment Request Category Show values
Column Name Description Domain name
COMPANY_CODE Company Code BUKRS
PRQ_KEYNO Key Number for Payment Request PRQ_KEYNO
PAYMENT_AWKEY Payment Reference Key AWKEY
BUSTRANSID Identifier of the Distributor Business Transaction SYSUUID
VALUATION_AREA Treasury Valuation Area TPM_VAL_AREA
ITEM_NUMBER Accounting Document Line Item Number POSNR_ACC
FLOW_NUMBER Number of a Distributor Flow TPM_TRDFLOWNR
BELNR Document Number of an Accounting Document BELNR
BUZEI Number of Line Item Within Accounting Document BUZEI
POSTING_YEAR Fiscal Year GJAHR
PAYGR Grouping Field for Automatic Payments CHAR20
HOUSE_BANK Short Key for Own House Bank HBKID
HOUSE_BANK_ACC Short Key for House Bank Account HKTID
RPZAHL Payer/Payee BU_PARTNER
RPBANK Partner Bank Details BVTYP
ZWELS List of Respected Payment Methods ZWELS
RPCODE Repetitive Code RPCODE
RP_TEXT Reference Text for Repetitive Code XTEXT50
KUNNR Customer Number KUNNR
GL_ACCOUNT General Ledger Account SAKNR
CLEARING_ACC G/L Account for Bank Clearing Account SAKNR
FI_REV_REASON Reason for Reversal or Inverse Posting STGRD
TR_REV_REASON Reason for Reversal SSTOGRD
SGTXT Item Text TEXT50
SWIFT_TEXT SWIFT Text PRQ_SWTXT
DTAWS Instruction Key for Data Medium Exchange DTAWS
DTWS1 Instruction Key 1 DTWSX
DTWS2 Instruction Key 2 DTWSX
DTWS3 Instruction key 3 DTWSX
DTWS4 Instruction key 4 DTWSX
SUB_FLOW_NUMBER Number of a Distributor Flow TPM_TRDFLOWNR
UZAWE Payment method supplement UZAWE
CLASS_OID Globally Unique Identifier SYSUUID
POSITION_OID Object Identity in Database Format TPM_DB_OS_GUID
CREATE_NAME Entered By SYCHAR12
CREATE_TCODE Transaction Code TCODE
CHANGE_NAME Employee ID SYCHAR12
CHANGE_TCODE Transaction Code TCODE
MNDID Unique Reference to Mandate for each Payee ID035