BOE_COL_ITEM

Collection item data table | #itemdata | Component: Cash Management China
Column Name Description
MANDT Client
DB_KEY Global Unique ID for table
PARENT_KEY Global Unique ID for table
ROOT_KEY Global Unique ID for table
Column Name Description
SPESW Bank Charges in Document Currency
💲 Currency Key (WAERS):
WRBTR Amount in document currency
Column Name Description
Column Name Description
BOE_CO_DATE collection date
BOE_PLAN_CO_DATE Planning Collection Date
VALUT Value date
Column Name Description
SHKZG Debit/Credit Indicator Show values
Column Name Description Domain name
BUKRS Company Code BUKRS
ACTION_KEY Global Unique ID for table UUID
BOE_COMMENT Comment BOE_COMMENT
BOE_COL_BANK_COUNTRY Country/Region Key of Bank LAND1
BOE_COL_BANK_NUMBER Bank Keys BANKK
BOE_COL_BANK Name of Financial Institution TEXT60
BSCHL Posting Key BSCHL
HKONT General Ledger Account SAKNR
GSBER Business Area GSBER
PRCTR Profit Center PRCTR
SGTXT Item Text TEXT50
KOSTL Cost Center KOSTL
HBKID Short Key for a House Bank HBKID
HKTID ID for Account Details HKTID
OFFSET_ACCOUNT G/L Account Number SAKNR
CREATED_BY User Name UNAME
CREATED_AT UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
CHANGED_BY User Name UNAME
CHANGED_AT UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
ID for Account Details
  • Company Code
  • ID for Account Details
  • Client
  • Short Key for a House Bank
  • BOE_COL_ITEM.BUKRS == T012K.BUKRS
  • BOE_COL_ITEM.BOE_COL_ACCOUNT_ID == T012K.HKTID
  • BOE_COL_ITEM.MANDT == T012K.MANDT
  • BOE_COL_ITEM.BOE_COL_HOUSE_BANK == T012K.HBKID
Short Key for a House Bank
  • Short Key for a House Bank
  • Company Code
  • BOE_COL_ITEM.MANDT == T012.MANDT
  • BOE_COL_ITEM.BOE_COL_HOUSE_BANK == T012.HBKID
  • BOE_COL_ITEM.BUKRS == T012.BUKRS
Reason Code for Payments
  • Company Code
  • Reason Code for Payments
  • Client
  • BOE_COL_ITEM.BUKRS == T053R.BUKRS
  • BOE_COL_ITEM.RSTGR == T053R.RSTGR
  • BOE_COL_ITEM.MANDT == T053R.MANDT
Reason Code for Payments
  • Company Code
  • Reason Code for Payments
  • Client
  • BOE_COL_ITEM.BUKRS == T053R.BUKRS
  • BOE_COL_ITEM.RSTGR_DIS == T053R.RSTGR
  • BOE_COL_ITEM.MANDT == T053R.MANDT