AVIP_DRAFT - I_PAYMENTADVICETP I_PAYMENTADVICEITEMTP

I_PAYMENTADVICETP I_PAYMENTADVICEITEMTP information is stored in SAP table AVIP_DRAFT.
It is part of development package ODATA_PAYMENTADVICES in software component CA-GTF-FXU-FI-AR. This development package consists of objects that can be grouped under "oData Services - Payment Advices".

Fields for table AVIP_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
PARENTDRAFTUUID	UUID serving as key (parent key, root key)		/BOBF/UUID	RAW	16
COMPANYCODE	Company Code		BUKRS	CHAR	8
PAYMENTADVICEACCOUNTTYPE	Payment Advice Account Type		KOART_AV	CHAR	2
PAYMENTADVICEACCOUNT	Customer ID		FARP_CUSTOMER_ID	CHAR	20
PAYMENTADVICE	Payment Advice Number		FARP_PA_AVSID	CHAR	32
PAYMENTADVICEITEM	Payment Advice Item		AVSPO	NUMC	10
COMPANYCODEFOREDIT	Company Code		BUKRS	CHAR	8
PAYTADVICEACCOUNTTYPEFOREDIT	Payment Advice Account Type		KOART_AV	CHAR	2
PAYMENTADVICEACCOUNTFOREDIT	Customer ID		FARP_CUSTOMER_ID	CHAR	20
PAYMENTADVICEFOREDIT	Payment Advice Number		FARP_PA_AVSID	CHAR	32
PAYMENTADVICEITEMFOREDIT	Payment Advice Item		AVSPO	NUMC	10
PAYMENTADVICEALTVACCOUNT	Alternative Account (Payment Advice Management)		ABWKO_AV	CHAR	20
ALTERNATIVECOMPANYCODE	Alternative Company Code (Payment Advice Management)		FARP_ABWBU_AV	CHAR	8
ACCOUNTINGDOCUMENT	Document		FARP_PA_BELNR_D	CHAR	20
DOCUMENTREFERENCEID	Reference Document Number provided by the Customer/Supplier		FARP_XBLNR1	CHAR	32
BILLINGDOCUMENT	Billing Document		VBELN_VF	CHAR	20
BRANCHACCOUNT	Account Number of the Branch		FARP_FILKD	CHAR	20
ACCOUNTINGDOCUMENTCREATIONDATE	Journal Entry Date		FARP_PA_CPUDT	DATS	16
BUSINESSAREA	Business Area		GSBER	CHAR	8
BUSINESSAREANAME	Business Area Description		FARP_GTEXT	CHAR	60
ASSIGNMENTREFERENCE	Assignment number		FARP_DZUONR	CHAR	36
PAYTDIFFERENCEREASONEXTCODE	External Reason Code for Payment Differences		RSTGR_EXT	CHAR	6
DOCUMENTITEMTEXT	Item Description		FARP_PA_SGTXT	CHAR	100
TAXAMOUNTINCOCODECRCY	Tax Amount in Local Currency		FARP_MWSTS	CURR	12
TAXCODE	Tax on sales/purchases code		MWSKZ	CHAR	4
GROSSAMOUNTINPAYMENTCURRENCY	Gross Amount		WRBTR_AV	CURR	12
NETPAYMENTAMOUNTINPAYTCURRENCY	Net Payment Amount with +/- Sign		NEBTR_AV	CURR	12
CASHDISCOUNTAMOUNTINPAYTCRCY	Cash Discount Amount with +/- Sign		WSKTO_AV	CURR	12
FISCALYEAR	Fiscal Year		GJAHR	NUMC	8
ACCOUNTINGDOCUMENTITEM	Posting View Item		FARP_BUZEI	NUMC	6
PAYMENTADVICEALTVACCOUNTTYPE	Account Type		FARP_ABWKA_AV	CHAR	2
CASHDISCOUNTPERCENT	Selected Cash Discount Percentage Rate		DZBDXP	DEC	3
CASHDISCOUNTDAYS	Selected cash discount days		DZBDXT	DEC	2
DIFFERENCEAMOUNTINCOCODECRCY	Amount Difference in Local Currency		FARP_DIFHW	CURR	12
DIFFERENCEAMOUNT	Amount Difference in Foreign Currency		FARP_DIFFW	CURR	12
DIFFAMTINADDITIONALCURRENCY1	Amount Difference in Second Local Currency		FARP_DIFH2	CURR	12
DIFFAMTINADDITIONALCURRENCY2	Amount Difference in Third Local Currency		FARP_DIFH3	CURR	12
ITEMISACTIVATED	Indicator: Items Activated?		FARP_XAKTP	CHAR	2
CASHDISCOUNTISACTIVATED	Indicator: Cash Discount Activated?		FARP_XAKTS	CHAR	2
ISPARTIALPAYMENT	Indicator: Partial Payments		FARP_XPPMT	CHAR	2
PAYTDIFFRSDLBALISCARRIEDFWD	Indicator: Carryforward Residual Bal. for Payt Difference?		FARP_XVORT	CHAR	2
PAYMENTDIFFERENCEREASON	Reason Code for Payments		RSTGR	CHAR	6
PAYMENTDIFFERENCEREASONNAME	Reason Code Short Text		TXT20_053	CHAR	40
PAYMENTDIFFERENCEREASONDESC	Payment Difference Reason Code Description		FARP_PA_REASONCODE_DESC	CHAR	80
CURRENCY	Currency Key		WAERS	CUKY	10
REFERENCE1IDBYBUSINESSPARTNER	Business Partner Reference Key 1		FARP_XREF1	CHAR	24
REFERENCE2IDBYBUSINESSPARTNER	Business Partner Reference Key 2		FARP_XREF2	CHAR	24
DELIVERYDOCUMENT	Delivery		VBELN_VL	CHAR	20
INVOICEDATE	Document Date		FARP_PA_REDAT	DATS	16
PURCHASINGDOCREFERENCEBYCUST	Customer Reference		BSTNK	CHAR	40
ISPOSTEDONACCOUNT	Indicator: Posting on Account		XACON	CHAR	2
PAYMENTADVICESTATUS	Payment Advice Status		FARP_ASTAT_AVIK	CHAR	2
DEDUCTIONAMOUNTINPAYTCURRENCY	Deduction Amount		ABBTR_AV	CURR	12
PAYMENTREFERENCE	Payment Reference		FARP_KIDNO	CHAR	60
TAXCALCULATIONPROCEDURE	Procedure (Pricing, Output Control, Acct. Det., Costing,...)		FARP_KALSM_D	CHAR	12
TOTALCOUNT	Number of Subitems		FARP_NUMBER_OF_SUBITEMS	INT4	4
ADDITIONALCURRENCY1	Additional Currency 1		FIS_HWAE2	CUKY	10
ADDITIONALCURRENCY2	Additional Currency 2		FIS_HWAE3	CUKY	10
COMPANYCODECURRENCY	Currency Key		WAERS	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