The obj_payments object is derived from the obj_acc_doc object, which consolidates detailed accounting document information from SAP tables BSEG (Accounting Document Segment) and BKPF (Accounting Document Header). The obj_payments object further enriches this data by joining it with payment-related information from the SAP tables REGUP (Process Automation: Line Items), REGUV (Process Automation: Withholding Tax), and REGUH (Process Automation: Document Header). This object provides a comprehensive view of payment transactions, supporting detailed financial analysis and reporting needs.

Columns and Descriptions

• data_source_id: ID of the data source.

• data_source_id_translated: Description of the data source.

• obj_row_relevant_to_date: Internal creation date of the row in the object.

• run_on: REGUV.LAUFD

• identification: REGUV.LAUFI

• paying_co_code: REGUP.ZBUKR

• customer: REGUP.KUNNR

• payment_docno: REGUP.VBLNR

• company_code: REGUP.BUKRS

• document_number: REGUP.BELNR

• fiscal_year: REGUP.GJAHR

• line_item: REGUP.BUZEI

• purchase_order_number: EKBE.EBELN

• purchase_order_item: EKBE.EBELP

• vendor: REGUP.LIFNR

• vendor_translated: LFA1.NAME1

• indicator_only_prop: REGUP.XVORL

• production_run_carried_out: REGUV.XECHT

• payment_recipient: REGUP.EMPFG

• payment_doc_user_id: BKPF.USNAM user of canceled payment document

• payment_doc_username: BKPF.USNAM user description of canceled payment document

• indicator_payment_docno_canceled: BKPF.STBLG reversed with indicator of canceled payment document

• company_code_translated: T001.BUTX company code description

• user_id: BKPF.USNAM

• username: BKPF.USNAM description

• branch: REGUP.FILKD

• pymt_meth: REGUP.ZLSCH

• house_bank: REGUP.HBKID

• partbank_type: REGUP.BVTYP

• item_indicator: REGUP.POKEN

• reference: REGUP.XBLNR

• document_type: REGUP.BLART

• posting_date: REGUP.BUDAT

• document_date: REGUP.BLDAT

• account_type: REGUP.KOART

• posting_key: REGUP.BSCHL

• gl: REGUP.HKONT

• gl_account: REGUP.SAKNR

• special_gl_ind: REGUP.UMSKZ

• transacttype: REGUP.UMSKS

• trgspgl_ind: REGUP.ZUMSK

• debit_credit: REGUP.SHKZG

• currency: REGUP.WAERS

• amount_in_local_curr: REGUP.DMBTR

• amount_in_doc_curr: REGUP.WRBTR

• risk_amount_in_usd: REGUP.WRBTR converted to USD

• valuation_diff: REGUP.BDIFF

• business_area: REGUP.GSBER

• tax_code: REGUP.MWSKZ

• lc_tax: REGUP.MWSTS

• tax_amount: REGUP.WMWST

• tax_code1: REGUP.MWSK1

• amount_in_local_curr_for_tax_dist1: REGUP.DMBT1

• amount_in_foreign_curr_for_tax_breakdown1: REGUP.WRBT1

• tax_code2: REGUP.MWSK2

• amount_in_local_curr_for_tax_dist2: REGUP.DMBT2

• amount_in_foreign_curr_for_tax_breakdown2: REGUP.WRBT2

• tax_code3: REGUP.MWSK3

• amount_in_local_curr_for_tax_dist3: REGUP.DMBT3

• amount_in_foreign_curr_for_tax_breakdown3: REGUP.WRBT3

• text: REGUP.SGTXT

• baseline_date: REGUP.ZFBDT

• payt_terms: REGUP.ZTERM -- deprecated column

• pay_terms: REGUP.ZTERM

• pay_terms_translated: REGUP.ZTERM description

• days_1: REGUP.ZBD1T

• days_2: REGUP.ZBD2T

• days_net: REGUP.ZBD3T

• payment_days: Different in days between baseline_date REGUP.ZFBDT and run_on REGUV.LAUFD

• payment_diff_days_1: payment_days less days_1 REGUP.ZBD1T

• payment_diff_days_2: payment_days less days_2 REGUP.ZBD2T

• payment_diff_days_net: payment_days less days_net REGUP.ZBD3T

• due_date_1: Add days_1 REGUP.ZBD1T to the baseline_date REGUP.ZFBDT

• due_date_2: Add days_2 REGUP.ZBD2T to the baseline_date REGUP.ZFBDT

• due_date_net: Add days_net REGUP.ZBD3T to the baseline_date REGUP.ZFBDT

• discpercent_1: REGUP.ZBD1P

• discpercent_2: REGUP.ZBD2P

• disc_base: REGUP.SKFBT

• discount_amt: REGUP.SKNTO

• disc_amount: REGUP.WSKTO

• fixed: REGUP.ZBFIX

• pmnt_block: REGUP.ZLSPR

• block_level: REGUP.SPLEV

• invoice_refer: REGUP.XREBZ

• custtariff_no: REGUP.ZOLLT

• customs_date: REGUP.ZOLLD

• scb_ind: REGUP.LZBKZ

• suppl_cntry: REGUP.LANDL

• service_ind: REGUP.DIEKZ

• w_tax_code: REGUP.QSSKZ

• w_tax_base: REGUP.QSSHB

• withholding_tax_in_doc_currency: REGUP.QBSHB

• withholding_tax_in_local_currency: REGUP.QBSHH

• por_number: REGUP.ESRNR

• por_refno: REGUP.ESRRE

• check_digit: REGUP.ESRPZ

• cash_discdays: REGUP.ZBDXT

• cash_discount: REGUP.ZBDXP

• maximum_cash_discount_local: REGUP.MSHBT

• maximum_cash_discount_foreign: REGUP.MSFBT

• order_number: REGUP.AUFNR

• asset: REGUP.ANLN1

• sub_number: REGUP.ANLN2

• purchasing_doc: REGUP.EBELN

• item: REGUP.EBELP

• indicator_down_payment: REGUP.XANET

• net_document_type: REGUP.XNETB

• indicator_document: REGUP.XNACH

• payment_methods: REGUP.ZWELS

• trading_partner: REGUP.VBUND

• vat_reg_no: REGUP.STCEG

• destcountry: REGUP.EGBLD

• cust_vend_country: REGUH.LAND1

• payee_country: REGUH.ZLAND

• bank_country: REGUH.ZBNKS

• document_type_translated: REGUH.ZBNKS

• paying_co_code_translated: REGUP.ZBUKR description

• cust_vend_country_translated: REGUH.LAND1 description

• bank_country_translated: REGUH.ZBNKS description

• payee_country_translated: REGUH.ZLAND description