P_Arbanktransactiondocitem_07

Retrieves Statement Item details | view: PARBKTRANDOCIT7 | Extraction: Not supported | Component: Information System
Column Name Description
StatementShortID Short Key for Bank Statement (Surrogate Key)
StatementItem Memo Record Number (Line Item Number in Bank Statement)
Column Name Description
💲 Account Currency Key (TransactionCurrency):
AmountInAccountCurrency Amount in Account Currency
FeeAmountInTransactionCrcy Fees in Account Currency
OverdueChargeAmtInTransacCrcy Overdue Charges from/to Partners in Account Currency
💲 Foreign Currency Key (Not Account Currency) (OriginalCurrency):
ForeignCurrencyAmount Foreign Currency Amount (Different from Account Currency)
FeeAmountInOriginalCrcy Fees in Foreign Currency (Not Same as Account Currency)
AmountInTransactionCurrency Amount in Account Currency
AmountInOriginalCurrency Foreign Currency Amount (Different from Account Currency)
Column Name Description
Column Name Description
StatementDate Statement Date
ValueDate Value Date of the Item to Be Cleared
BankPostingDate Posting Date at the Bank
PostingDate Posting Date in the Document
BillOfExchangeFailureDate Date of Failed Bills of Exchange in Japan
Column Name Description
BankDataStorageApplication Application Using Bank Data Storage Show values
InterpretationAlgorithm Interpretation Algorithm Show values
PaymentAdviceAccountType Payment Advice Account Type Show values
MemoLineIsChanged Note to Payee Has Been Changed Manually Show values
TreasuryContractType Contract Type Show values
ItemProcessingType Processing Type Show values
BankLedgerPostingIsSuppressed X - Standard (FI) Posting Should Be Suppressed Show values
SubledgerPostingIsSuppressed X - Standard (FI) Posting Should Be Suppressed Show values
MachineLrngBankStmntItemStatus Machine Learning Status of Item Show values
Column Name Description Domain name
HouseBank Short Key for a House Bank HBKID
HouseBankAccount ID for Account Details HKTID
StatementNumber Statement Number NUM5
StatementStatus Statement Status CHAR1
BankLedgerIsPosted Update 1 OK CHAR1
SubledgerIsPostedSuccessfully 2nd Update OK CHAR1
ItemGroup Bundle Number for Grouping Line Items CHAR2
PaymentTransaction Business Transaction Code CHAR3
PaymentAdviceAccount Account Number KTONR
IsInProcess Payment Advice Number AVSID
ExchangeRate Exchange Rate: Foreign Currency to Account Currency KURSF
DebitCreditCode Debit/Credit Key for Line Items (for Bank Purposes) CHAR1
BusinessPartnerName Business Partner CHAR55
PaymentManualTransacType Transaction VGMAN_EB
PaymentManualTransacTypeName Text, Length 40 TEXT40
PaymentAdvice Payment Advice Number AVSID
ValueDateTime Value Date Time TIME6
PaymentExternalTransacType External Business Transaction VGEXT_EB
PaymentTransactionDescription Bank Posting Text CHAR50
AccountingClerk Accounting Clerk CHAR2
CostCenter Cost Center CHAR10
BusinessArea Business Area CHAR4
ProfitCenter Profit Center PRCTR
TreasuryContract Contract Number RANL
DaybookEntry Daybook Number CHAR10
Cheque Check number CHCKN
PaymentMediumReference Check number CHCKN
CustomerReferenceNumber Check number CHCKN
ItemIsInterpreted Line Items Were Interpreted CHAR1
PostingErrorStatus Error Status CHAR4
BankLedgerDocument Document Number of an Accounting Document BELNR
FiscalYear Fiscal Year GJAHR
BankLedgerAcctgDocFiscalYear Fiscal Year of Bank Accounting Document GJAHR
BankPostingKey Text Key CHAR4
AcctDetnFreeDefinedAttribute Account modification KFMOD_EB
DocumentReferenceID Reference Document Number XBLNR1
AssignmentReference Assignment number ZUONR
PartnerBank Bank Number of Partner Bank BANKK
PartnerBankSWIFTCode SWIFT Code of Partner Bank SWIFT
PartnerBankAccount Account Number at the Partner Bank BANKN
FinancialAssetsMgmtStatus Financial Assets Management Status CHAR2
FinancialAssetsMgmtInfoField Financial Assets Management Information Field CHAR40
ItemDescription1 Additional Information 1 CHAR30
ItemDescription2 Additional Information 2 CHAR30
SubledgerDocument Subledger document number BELNR
SubledgerAcctgDocFiscalYear Fiscal Year of Subledger Accounting Document GJAHR
BankLedgerOnAccountDocument Payment on account document number BELNR
SubledgerOnAccountDocument Payment on account document number BELNR
PayerParty Account Number of an Alternative Payer KUNNR
BatchNumber Batch Number (Bundle Number) CHAR3
AccountingExchangeRate Exchange Rate (Different from Local Currency) KURSF
DocumentItemText Item Text TEXT50
PostingAlgorithm Posting Algorithm (Lockbox only) CHAR3
NumberOfSecondSubledgerDoc Number of Second Subledger Document BELNR
BankReference Bank Reference Number CHAR35
ReferenceDocument Reference Key AWKEY
ReferenceDocumentType Reference procedure AWTYP
PaymentReference Payment Reference CHAR30
ReturnReason Customer-to-Customer Reference CHAR35
DunningBlockingReason Dunning Block MANSP
IdNumberForCashMgmtAndForecast ID number for cash management and forecast IDENR
BankLedgerExternalApplication Application Indicator APPLK_BF
BankLedgerExtPostgErrorStatus Error Status CHAR4
BankLedgerExtPostingDocument Doc. no. (IDoc number, application document no., etc.) CHAR70
BankLedgerExtPostingRefDocType Reference procedure AWTYP
SubledgerExtPostingApplication Application Indicator APPLK_BF
SubledgerExtPostingErrorStatus Error Status CHAR4
SubledgerExtPostingDocument Doc. no. (IDoc number, application document no., etc.) CHAR70
SubledgerExtPostingRefDocType Reference procedure AWTYP
PartnerBankIBAN Partner Bank Account: IBAN IBAN
IsReversed null
PaymentAdviceAccountTypeName Short Text for Fixed Values DDTEXT
accdoc_tmp_doc_id Temporary Accounting Document ID FDC_ACCDOC_TMP_DOC_ID
vwezw_orig Payment Notes CHAR65
vwezw Payment Notes CHAR65
ItemIsReprocessed null
MemoLine1 Payment Notes CHAR65
posar null
PaymentTransactionCategory Transaction FEB_BSPROC_TATYP
HasAttachment null
LifeCycSts null
BankStatementItemDraftUUID Draft key (raw16) RAW16
BankStatementInternalID Temporary Accounting Document ID FDC_ACCDOC_TMP_DOC_ID
ProcessingStatus null
rootkeynull null
tmpidisnull null
AttachmentKey null
BankInternalID Bank Keys BANKK
BankAccount Bank account number BANKN
StatementPostingRuleName Text, Length 40 TEXT40
IsCompleted Line Item Completed CHAR1
ItemReprocessRsnName Reprocessing Reason TEXT60
BankStatementDateMonth null
BankStatementDateYear null
AdditionalInformation Additional information from file ADDITIONAL_INFO_EB
Master Data Relations Join Conditions
Bank Account Technical ID
  • Client
  • ?
  • Bank Account Technical ID
  • P_ARBANKTRANSACTIONDOCITEM_07.MANDT == FCLM_BAM_AMD.MANDT
  • P_ARBANKTRANSACTIONDOCITEM_07.[column in domain "FCLM_REVISION"] == FCLM_BAM_AMD.REVISION
  • P_ARBANKTRANSACTIONDOCITEM_07.BANKACCOUNTINTERNALID == FCLM_BAM_AMD.ACC_ID
Reprocessing Reason Code
  • Client
  • Reprocessing Reason Code
  • Reprocessing Reason Code
  • P_ARBANKTRANSACTIONDOCITEM_07.MANDT == FEB_REPRO_RRC.MANDT
  • P_ARBANKTRANSACTIONDOCITEM_07.ITEMREPROCESSREASON == FEB_REPRO_RRC.REPROCREASONCODE
  • P_ARBANKTRANSACTIONDOCITEM_07.BANKSTMNTITEMREPROCESSREASON == FEB_REPRO_RRC.REPROCREASONCODE
Company code
  • Company Code
  • Client
  • P_ARBANKTRANSACTIONDOCITEM_07.COMPANYCODE == T001.BUKRS
  • P_ARBANKTRANSACTIONDOCITEM_07.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • P_ARBANKTRANSACTIONDOCITEM_07.CURRENCY == TCURC.WAERS
  • P_ARBANKTRANSACTIONDOCITEM_07.MANDT == TCURC.MANDT
Reprocessing Reason Code
  • Client
  • Reprocessing Reason Code
  • Reprocessing Reason Code
  • P_ARBANKTRANSACTIONDOCITEM_07.MANDT == FEB_REPRO_RRC.MANDT
  • P_ARBANKTRANSACTIONDOCITEM_07.ITEMREPROCESSREASON == FEB_REPRO_RRC.REPROCREASONCODE
  • P_ARBANKTRANSACTIONDOCITEM_07.BANKSTMNTITEMREPROCESSREASON == FEB_REPRO_RRC.REPROCREASONCODE
Foreign currency (not account currency)
  • Foreign Currency Key (Not Account Currency)
  • Client
  • P_ARBANKTRANSACTIONDOCITEM_07.ORIGINALCURRENCY == TCURC.WAERS
  • P_ARBANKTRANSACTIONDOCITEM_07.MANDT == TCURC.MANDT
Partner Bank
  • Country/Region Key of Partner Bank
  • Client
  • P_ARBANKTRANSACTIONDOCITEM_07.PARTNERBANKCOUNTRY == T005.LAND1
  • P_ARBANKTRANSACTIONDOCITEM_07.MANDT == T005.MANDT
Input Help for Posting Rule (Internal Activity)
  • Posting Rule
  • Client
  • P_ARBANKTRANSACTIONDOCITEM_07.POSTINGRULE == T028D.VGINT
  • P_ARBANKTRANSACTIONDOCITEM_07.MANDT == T028D.MANDT