PAYRQ_DRAFT - I_PAYMENTREQUESTTP I_PAYMENTREQUESTTP

I_PAYMENTREQUESTTP I_PAYMENTREQUESTTP information is stored in SAP table PAYRQ_DRAFT.
It is part of development package ODATA_PROCESS_FF_PAYMENTS in software component CA-GTF-FXU-FI-AP. This development package consists of objects that can be grouped under "oData Services - Process Free Form Payments".

Fields for table PAYRQ_DRAFT

Field Name	Description	Is Key	Data Element	Data Type	Length
MANDT	Client	X	MANDT	CLNT	6
DRAFTUUID	UUID serving as key (parent key, root key)	X	/BOBF/UUID	RAW	16
PAYMENTREQUEST	Payment Request Key Number		FARP_PRQ_KEYNO	CHAR	20
CREATEDBYUSER	Created By User		VDM_CREATEDBYUSERID	CHAR	24
ACCOUNTINGDOCUMENTCREATIONDATE	Accounting Document Entry Date		FARP_CPUDT	DATS	16
PAYMENTREQUESTAMOUNTINPAYTCRCY	Payment Request Amount in Payment Currency		FARP_PRQ_AMTFC	CURR	12
PAYMENTREQUESTCURRENCY	Payment Request Currency Key		FARP_PRQ_PACUR	CUKY	10
PAYMENTREQUESTAMOUNTINCCCRCY	Payment Request Amount in Local Currency		PRQ_AMTLC	CURR	12
COMPANYCODECURRENCY	Local Currency		HWAER	CUKY	10
PAYEENAME	Payee Name		FARP_PAYEE_NAME	CHAR	160
PAYEEBANKCOUNTRY	Payee Bank Country/Region		FARP_DZBNKS	CHAR	6
PAYEEBANKINTERNALID	Payee Bank Key		FARP_BNK_COM_DZBNKY	CHAR	30
BANKDETAILREFERENCE	Reference Specifications for Bank Details		FARP_PRQ_BKREF	CHAR	40
PAYEEBANKCONTROLKEY	Bank Control Key of the Payee's Bank		FARP_BNK_COM_DZBKON	CHAR	4
PAYEEBANK	Payee Bank Number		FARP_BNK_COM_DZBNKL	CHAR	30
PAYEEBANKACCOUNT	Bank Account Number of The Payee		FAP_BPA_DZBNKN	CHAR	36
BANKACCOUNTHOLDERNAME	Account Holder Name		BU_KOINH	CHAR	120
PAYEETITLE	Title of the payee		DZANRE	CHAR	30
PAYEEPOSTALCODE	Postal Code of the Payee		DZPSTL	CHAR	20
PAYEEPOBOX	P.O. box of the payee		DZPFAC	CHAR	20
POBOXPOSTALCODE	P.O. Box Postal Code		PSTL2	CHAR	20
PAYEEADDITIONALNAME2	Additional Name of the Payee 2		FARP_DZNME2	CHAR	70
PAYEEADDITIONALNAME3	Additional Name of the Payee 3		FARP_DZNME3	CHAR	70
PAYEEADDITIONALNAME4	Additional Name of the Payee 4		FARP_DZNME4	CHAR	70
PAYEECITYNAME	Payee City Name		FARP_DZORT1	CHAR	70
PAYEESTREET	Payee's Street		FARP_DZSTRA	CHAR	70
PAYEECOUNTRY	Payee Country/Region Key		FARP_DZLAND	CHAR	6
PAYEEREGION	Regional Code of the Payee		FARP_PRQ_DZREGI	CHAR	6
PAYEELANGUAGE	Payee Language Key		FARP_PRQ_DZSPRA	LANG	2
PAYEEFAXNUMBER	Fax Number of the Payee		FARP_TELFX	CHAR	62
PAYEETELEPHONENUMBER	Telephone Number of the Payee		FARP_TELF1	CHAR	32
PAYEEIBAN	IBAN of the Payee		DZIBAN	CHAR	68
REFERENCETYPETEXT	Reference Type Text		FARP_REFTXT	CHAR	100
PAYMENTREFERENCE	Payment Reference		KIDNO	CHAR	60
COMPANYCODE	Company Code		FIS_BUKRS	CHAR	8
BUSINESSAREA	Business Area		GSBER	CHAR	8
CUSTOMERSUPPLIERACCOUNT	Account Number		FARP_KTONR_AV	CHAR	70
CUSTOMER	Customer ID		FARP_CUSTOMER_ID	CHAR	20
SUPPLIER	Account Number of Supplier		FARP_SUPPLIER_ID	CHAR	20
DOCUMENTITEMTEXT	Item Text		FARP_SGTXT	CHAR	100
FINANCIALACCOUNTTYPE	Financial Account Type (Free Form Payments)		FINANCIALACCOUNTTYPE	CHAR	2
FINANCIALACCOUNTTYPENAME	Financial Account Type Name		FIS_FIN_ACC_TYPE_NAME	CHAR	120
PAYINGCOMPANYCODE	Paying Company Code		FARP_BNK_COM_DZBUKR	CHAR	8
HOUSEBANK	House Bank Key		FARP_HBKID	CHAR	10
HOUSEBANKACCOUNT	ID for Account Details		HKTID	CHAR	10
ACCOUNTINGDOCUMENT	Journal Entry		FARP_BELNR_D	CHAR	20
CLEARINGACCOUNTINGDOCUMENT	Clearing Journal Entry		FIS_AUGBL	CHAR	20
CLEARINGDATE	Clearing Date		AUGDT	DATS	16
CLEARINGFISCALYEAR	Fiscal Year		FIS_GJAHR	NUMC	8
PAYMENTMETHOD	List of Respected Payment Methods		DZWELS	CHAR	20
PAYMENTMETHODSUPPLEMENT	Payment Method Supplement		FARP_UZAWE	CHAR	4
ISSINGLEPAYMENT	Indicator: Individual Payment		FARP_PRQ_XPORE	CHAR	2
VALUEDATE	Value Date for the Sending Bank		FARP_PRQ_VALDT	DATS	16
DATAEXCHANGEINSTRUCTIONKEY	Instruction key for data medium exchange		FARP_BNK_COM_DTAWS	CHAR	4
DATAEXCHANGEINSTRUCTION1	Instruction Key 1		FARP_DTAT16	NUMC	4
DATAEXCHANGEINSTRUCTION2	Instruction Key 2		FARP_DTAT17	NUMC	4
DATAEXCHANGEINSTRUCTION3	Instruction Key 3		FARP_DTAT18	NUMC	4
DATAEXCHANGEINSTRUCTION4	Instruction Key 4		FARP_DTAT19	NUMC	4
ISURGENTPAYMENT	Urgent Payment		DTURG	CHAR	2
PAYMENTREQUESTORIGIN	Origin Indicator		FARP_FIBL_ORIGIN	CHAR	16
RELEASEDATE	Release Date for Payment		PRQ_RELDATE	DATS	16
RELEASEDBYUSER	User Who Carried Out the Release		PRQ_RELNAME	CHAR	24
PAYMENTREQUESTPOSTINGDATE	Day on Which Payment Request Was Posted		FARP_PRQ_POSTDATE	DATS	16
POSTINGCREATEDBYUSER	User Who Carried Out the Posting		PRQ_POSTNAME	CHAR	24
PAYTREQISRELEASEDFORPOSTING	Indicator: Released for Posting		FARP_PRQ_XRELD	CHAR	2
PAYTREQISCOMPLETED	Indicator: Complete		FARP_PRQ_XRELI	CHAR	2
PAYTREQISRELEASEDFORPAYMENT	Indicator: Released for Payment		FARP_PRQ_XRELP	CHAR	2
ISREVERSED	Indicator: Payment Request Is Reversed		FARP_PRQ_XREVE	CHAR	2
REVERSALREASON	Reason for Reversal or Inverse Posting		STGRD	CHAR	4
STATECENTRALBANKPAYMENTREASON	State Central Bank Indicator		FARP_PRQ_LZBKZ	CHAR	6
SUPPLYINGCOUNTRY	Supplying Country/Region		LANDL	CHAR	6
TAXID1	Tax Number 1		STCD1	CHAR	32
BANKCHAIN	ID for Bank Chain		CHAINID	CHAR	20
PAYMENTREQUESTTYPE	Payment Request Type		FARP_PAYRQ_TYPE	CHAR	16
CUSTOMERBANKTYPE	Customer Bank Details ID		FARP_BNK_COM_BVTYP	CHAR	8
SUPPLIERBANKTYPE	Supplier Bank Details ID		FARP_BNK_COM_BVTYP_SUPLR	CHAR	8
LASTCHANGEDBYUSER	Changed By		FARP_CHANGED_BY	CHAR	24
LASTCHANGETIME	Change Time		BNK_COM_CHANGE_TIME	TIMS	12
LASTCHANGEDATE	Last Change Date		TTET_DT_CHG_DATE	DATS	16
CREATIONTIME	Creation Time		TTET_DT_CR_TIME	TIMS	12
CREATIONDATETIME	Creation Date and Time		FARP_PRQ_CR_DATE	DEC	11
LASTCHANGEDATETIME	Change Date and Time		FARP_PRQ_CHG_DATE	DEC	11
PAYMENTREQUESTVARIANT	Variant Name		FIBL_OPVAR	CHAR	28
PAYMENTREPETITIVECODE	Repetitive Code		FARP_REPETITIVE_CODE	CHAR	40
FISCALYEAR	Fiscal Year		FIS_GJAHR	NUMC	8
BANKCOUNTRY	Country/Region Key of Bank		BANKS	CHAR	6
BANKINTERNALID	Bank Key of Our Bank		UBNKY	CHAR	30
GLACCOUNT	General Ledger Account		HKONT	CHAR	20
STATUSCODE	Status of Payment Request		FARP_PAYRQ_STATUS	CHAR	10
FISCALYEARVARIANT	Fiscal Year Variant		PERIV	CHAR	4
AMOUNTINADDITIONALCURRENCY1	Amount in Second Local Currency or Global Currency		DMBE2	CURR	12
ADDITIONALCURRENCY1	Currency Key of Second Local Currency		HWAE2	CUKY	10
AMOUNTINADDITIONALCURRENCY2	Amount in Third Local Currency or First Freely-Def. Currency		DMBE3	CURR	12
ADDITIONALCURRENCY2	Currency Key of Third Local Currency		HWAE3	CUKY	10
HASACTIVEENTITY	Draft - Indicator - Has active document		SDRAFT_HAS_ACTIVE	CHAR	2
.INCLUDE				SDRAFT_WRITE_DRAFT_ADMIN	0
DRAFTENTITYCREATIONDATETIME	Draft Created On		SDRAFT_CREATED_AT	DEC	11
DRAFTENTITYLASTCHANGEDATETIME	Draft Last Changed On		SDRAFT_LAST_CHANGED_AT	DEC	11
DRAFTADMINISTRATIVEDATAUUID	Technical ID for the Administrative Data of a Draft Document		SDRAFT_ADMIN_UUID	RAW	16
DRAFTENTITYCONSISTENCYSTATUS	Draft - Consistency Status		SDRAFT_CONSISTENCY_STATUS	CHAR	2
DRAFTENTITYOPERATIONCODE	Draft - Operation Code		SDRAFT_OPERATION_CODE	CHAR	2
.INCLUDE				PAYMENT_REQUEST_INCL_EWW_PS	0
DUMMY_PAYT_REQ_INCL_EWW_PS	Custom Fields: Dummy for Use in Extension Includes		CFD_DUMMY	CHAR	2