Bank account balance - Cockpit
In ScopeTechnical: FQM_FLOW | ID: SAP-FI-FQM_FLOW-BANK_ACCOUNT_BALANCE
Opening bank account balances are loaded into SAP Cash Management (FQM) to provide an accurate starting liquidity position on the go-live date. Without this object, cash management reports and bank...
See how this object fits into Finance
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Unknown
- Typical Sources
- Legacy SAP ERPTreasury Management SystemBank Statement Extract
Classification
- Information Type
- Transaction
- Object Type
- cockpit
Target Structure
- Load Approach
- Excel
- Target Objects
- FQM_FLOW
Field Definitions(5)
Rules & Considerations(146)
validation
constraint
Sample Load Data(4)
| _scenario | BUKRSR | HBKIDR | AMOUNTR | HOUSE_BANK_IDR | HOUSE_BANK_ACCOUNT_IDR | FUND | HKTID | MANDT | OWNER | CLEARED | DELETED | FLOW_ID | RBLBETR | ROOT_ID | DAYS_DUE | VALID_TO | FLOW_TYPE | GRANT_NBR | FLG_ACTUAL | REL_STATUS | VALID_FROM | CREATE_USER | PAYMENT_DATE | PAYMENT_MODE | BASELINE_DATE | DOCUMENT_DATE | FLOW_CATEGORY | FQM_FLOW.FUND | ORIGIN_SYSTEM | PAYMENT_BLOCK | FI_FISCAL_YEAR | FQM_FLOW.OWNER | ORIGIN_FLOW_ID | PARENT_FLOW_ID | PAYMENT_METHOD | PROCESS_STATUS | TRANSACTION_ID | CERTAINTY_LEVEL | CLEARING_FLOW_ID | CREATE_TIMESTAMP | FI_CLEARING_ITEM | FI_FISCAL_PERIOD | FQM_FLOW.CLEARED | FQM_FLOW.DELETED | FQM_FLOW.FLOW_ID | FQM_FLOW.ROOT_ID | LAST_UPDATE_USER | ORIGIN_SYSTEM_RL | PAYMENT_CURRENCY | SOFTWARE_VERSION | TRANSACTION_DATE | FQM_FLOW.DAYS_DUE | FQM_FLOW.VALID_TO | ORIGIN_FLOW_ID_RL | FI_DOCUMENT_NUMBER | FQM_FLOW.FLOW_TYPE | FQM_FLOW.GRANT_NBR | ORIGIN_APPLICATION | ORIGIN_DOCUMENT_ID | CASH_DISCOUNT_DAYS1 | CASH_DISCOUNT_DAYS2 | FI_INVOICE_ITEM_REF | FQM_FLOW.FLG_ACTUAL | FQM_FLOW.REL_STATUS | FQM_FLOW.VALID_FROM | FI_CLEARING_DOCUMENT | FI_INVOICE_REFERENCE | FQM_FLOW.CREATE_USER | TRANSACTION_CATEGORY | FI_DOCUMENT_LINE_ITEM | FQM_FLOW.PAYMENT_DATE | FQM_FLOW.PAYMENT_MODE | LAST_UPDATE_TIMESTAMP | ORIGIN_APPLICATION_RL | ORIGIN_DOCUMENT_ID_RL | ORIGIN_TRANSACTION_ID | PARENT_TRANSACTION_ID | CASH_DISCOUNT_PERCENT1 | CASH_DISCOUNT_PERCENT2 | FQM_FLOW.BASELINE_DATE | FQM_FLOW.DOCUMENT_DATE | FQM_FLOW.FLOW_CATEGORY | FQM_FLOW.ORIGIN_SYSTEM | FQM_FLOW.PAYMENT_BLOCK | ORIGIN_TRANS_QUALIFIER | FQM_FLOW.FI_FISCAL_YEAR | FQM_FLOW.ORIGIN_FLOW_ID | FQM_FLOW.PARENT_FLOW_ID | FQM_FLOW.PAYMENT_METHOD | FQM_FLOW.PROCESS_STATUS | FQM_FLOW.TRANSACTION_ID | FQM_FLOW.CERTAINTY_LEVEL | ORIGIN_TRANSACTION_ID_RL | FI_CREDIT_DEBIT_INDICATOR | FQM_FLOW.CLEARING_FLOW_ID | FQM_FLOW.CREATE_TIMESTAMP | FQM_FLOW.FI_CLEARING_ITEM | FQM_FLOW.FI_FISCAL_PERIOD | FQM_FLOW.LAST_UPDATE_USER | FQM_FLOW.ORIGIN_SYSTEM_RL | FQM_FLOW.PAYMENT_CURRENCY | FQM_FLOW.SOFTWARE_VERSION | FQM_FLOW.TRANSACTION_DATE | ORIGIN_TRANS_QUALIFIER_RL | FI_INVOICE_FISCAL_YEAR_REF | FQM_FLOW.ORIGIN_FLOW_ID_RL | FQM_FLOW.FI_DOCUMENT_NUMBER | FQM_FLOW.ORIGIN_APPLICATION | FQM_FLOW.ORIGIN_DOCUMENT_ID | FQM_FLOW.CASH_DISCOUNT_DAYS1 | FQM_FLOW.CASH_DISCOUNT_DAYS2 | FQM_FLOW.FI_INVOICE_ITEM_REF | FQM_FLOW.FI_CLEARING_DOCUMENT | FQM_FLOW.FI_INVOICE_REFERENCE | FQM_FLOW.TRANSACTION_CATEGORY | FQM_FLOW.FI_DOCUMENT_LINE_ITEM | FQM_FLOW.LAST_UPDATE_TIMESTAMP | FQM_FLOW.ORIGIN_APPLICATION_RL | FQM_FLOW.ORIGIN_DOCUMENT_ID_RL | FQM_FLOW.ORIGIN_TRANSACTION_ID | FQM_FLOW.PARENT_TRANSACTION_ID | FQM_FLOW.CASH_DISCOUNT_PERCENT1 | FQM_FLOW.CASH_DISCOUNT_PERCENT2 | FQM_FLOW.ORIGIN_TRANS_QUALIFIER | FQM_FLOW.ORIGIN_TRANSACTION_ID_RL | FQM_FLOW.FI_CREDIT_DEBIT_INDICATOR | FQM_FLOW.ORIGIN_TRANS_QUALIFIER_RL | FQM_FLOW.FI_INVOICE_FISCAL_YEAR_REF |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1000 | HBGB1 | 125000.00 | HBGB1 | MAIN | FM001 | MAIN | 100 | CASH_MGMT | SAMPLE | SAMPLE | 000000000000001 | 125000.00 | 000000000000000 | 0 | 999912312359599999999999999 | OB | G000000000000001 | X | R | 202401010000000000000000000 | MIG_USER | 20240101 | A | 20240101 | 20231231 | 10 | FM001 | LEGACY_ERP | A | 0000 | SAMPLE | ITEM_001 | 000000000000000 | B | A | 001 | C | 000000000000000 | 202401011030000000000000000 | 00100 | 003 | S | S | 0001 | 0001 | MIG_USER | LEGACY_A | EUR | 0 | 20240101 | 100.00 | 100.00 | RL_FLOW_881 | 1900004521 | OB | SAMPLE | FI | LEGACY_BAL_20240101_GBP | 0 | 0 | 000000 | X | R | 100.00 | SAMPLE | INV-99872 | MIG_USER | OBAL | 000000 | 20240101 | SAMPLE | 202401011030000000000000000 | FI | LEGACY_DOC_999 | OPEN_BAL_MAIN_ACC | 000000000000000 | 0.0 | 0.0 | 20240101 | 20231231 | 0001 | LEGACY_ERP | A | B | 0000 | SAMPLE | 0001 | SAMPL | SA | 0001 | C | RL_TXN_552 | S | 0001 | 100.00 | 100.00 | 003 | MIG_USER | LEGACY_A | EUR | 1 | 20240101 | SAMPLE | 0000 | SAMPLE | 1900004521 | SAMP | SAMPLE | 0 | 0 | 0001 | SAMPLE | INV-99872 | SAMPLE | 0001 | 100.00 | SAMP | SAMPLE | SAMPLE | 0001 | 100.00 | 100.00 | SAMP | SAMPLE | S | SAMP | 0000 |
| Closed historical record with successor reference | 2000 | HBG02 | 125000.01 | HBG02 | NAIN | FM001 | NAIN | 100 | C02 | TAMPLE | S | 0000000000000002 | 125000.01 | 0000000000000001 | 0 | 20231231 | PB | G000000000000001 | X | R | 20221231 | MIGUSER02 | 20240208 | B | 20240207 | 20240206 | 000011 | — | LEGACYER02 | A | 0001 | — | ITEM00102 | 0000000000000001 | C | A | 0000000000000002 | D | 0000000000000001 | 202401011030000000000000000.0000001 | 100 | 01 | — | — | — | — | MIGUSER02 | LEGACYA02 | USD | 1 | 20240207 | — | — | RLFLOW88102 | 1900004502 | — | — | GI | LEGACYBAL20240101GBP02 | 0 | 0 | 001 | — | — | — | TAMPLE | INV9987202 | — | PBAL | 001 | — | — | 202401011030000000000000000.0000001 | GI | LEGACYDOC99902 | OPENBALMAINACC02 | 0000000000000001 | 0.001 | 0.001 | — | — | — | — | — | C | — | — | — | — | — | — | — | RLTXN55202 | S | — | — | 100 | — | — | — | — | — | — | TAMPLE | 0001 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
| New record with minimal optional data | 3000 | HBG03 | 125000.02 | HBG03 | MCIN | — | MCIN | — | — | — | — | 0000000000000003 | 125000.02 | 0000000000000002 | — | 99991231 | OD | — | — | — | 20250101 | — | — | — | — | — | — | — | — | — | — | — | ITEM00103 | 0000000000000002 | — | — | 0000000000000003 | E | 0000000000000002 | — | — | — | — | — | — | — | — | — | EUR | — | 20240315 | — | — | RLFLOW88103 | 1900004503 | — | — | — | LEGACYBAL20240101GBP03 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | LEGACYDOC99903 | OPENBALMAINACC03 | 0000000000000002 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | RLTXN55203 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |
Example values from field definitions
- BUKRSR
- 1000
- HBKIDR
- HBGB1
- AMOUNTR
- 125000.00
- HOUSE_BANK_IDR
- HBGB1
- HOUSE_BANK_ACCOUNT_IDR
- MAIN
- FUND
- FM001
- HKTID
- MAIN
- MANDT
- 100
- OWNER
- CASH_MGMT
- CLEARED
- SAMPLE
- DELETED
- SAMPLE
- FLOW_ID
- 000000000000001
- RBLBETR
- 125000.00
- ROOT_ID
- 000000000000000
- DAYS_DUE
- 0
- VALID_TO
- 999912312359599999999999999
- FLOW_TYPE
- OB
- GRANT_NBR
- G000000000000001
- FLG_ACTUAL
- X
- REL_STATUS
- R
- VALID_FROM
- 202401010000000000000000000
- CREATE_USER
- MIG_USER
- PAYMENT_DATE
- 20240101
- PAYMENT_MODE
- A
- BASELINE_DATE
- 20240101
- DOCUMENT_DATE
- 20231231
- FLOW_CATEGORY
- 10
- FQM_FLOW.FUND
- FM001
- ORIGIN_SYSTEM
- LEGACY_ERP
- PAYMENT_BLOCK
- A
- FI_FISCAL_YEAR
- 0000
- FQM_FLOW.OWNER
- SAMPLE
- ORIGIN_FLOW_ID
- ITEM_001
- PARENT_FLOW_ID
- 000000000000000
- PAYMENT_METHOD
- B
- PROCESS_STATUS
- A
- TRANSACTION_ID
- 001
- CERTAINTY_LEVEL
- C
- CLEARING_FLOW_ID
- 000000000000000
- CREATE_TIMESTAMP
- 202401011030000000000000000
- FI_CLEARING_ITEM
- 00100
- FI_FISCAL_PERIOD
- 003
- FQM_FLOW.CLEARED
- S
- FQM_FLOW.DELETED
- S
- FQM_FLOW.FLOW_ID
- 0001
- FQM_FLOW.ROOT_ID
- 0001
- LAST_UPDATE_USER
- MIG_USER
- ORIGIN_SYSTEM_RL
- LEGACY_A
- PAYMENT_CURRENCY
- EUR
- SOFTWARE_VERSION
- 0
- TRANSACTION_DATE
- 20240101
- FQM_FLOW.DAYS_DUE
- 100.00
- FQM_FLOW.VALID_TO
- 100.00
- ORIGIN_FLOW_ID_RL
- RL_FLOW_881
- FI_DOCUMENT_NUMBER
- 1900004521
- FQM_FLOW.FLOW_TYPE
- OB
- FQM_FLOW.GRANT_NBR
- SAMPLE
- ORIGIN_APPLICATION
- FI
- ORIGIN_DOCUMENT_ID
- LEGACY_BAL_20240101_GBP
- CASH_DISCOUNT_DAYS1
- 0
- CASH_DISCOUNT_DAYS2
- 0
- FI_INVOICE_ITEM_REF
- 000000
- FQM_FLOW.FLG_ACTUAL
- X
- FQM_FLOW.REL_STATUS
- R
- FQM_FLOW.VALID_FROM
- 100.00
- FI_CLEARING_DOCUMENT
- SAMPLE
- FI_INVOICE_REFERENCE
- INV-99872
- FQM_FLOW.CREATE_USER
- MIG_USER
- TRANSACTION_CATEGORY
- OBAL
- FI_DOCUMENT_LINE_ITEM
- 000000
- FQM_FLOW.PAYMENT_DATE
- 20240101
- FQM_FLOW.PAYMENT_MODE
- SAMPLE
- LAST_UPDATE_TIMESTAMP
- 202401011030000000000000000
- ORIGIN_APPLICATION_RL
- FI
- ORIGIN_DOCUMENT_ID_RL
- LEGACY_DOC_999
- ORIGIN_TRANSACTION_ID
- OPEN_BAL_MAIN_ACC
- PARENT_TRANSACTION_ID
- 000000000000000
- CASH_DISCOUNT_PERCENT1
- 0.0
- CASH_DISCOUNT_PERCENT2
- 0.0
- FQM_FLOW.BASELINE_DATE
- 20240101
- FQM_FLOW.DOCUMENT_DATE
- 20231231
- FQM_FLOW.FLOW_CATEGORY
- 0001
- FQM_FLOW.ORIGIN_SYSTEM
- LEGACY_ERP
- FQM_FLOW.PAYMENT_BLOCK
- A
- ORIGIN_TRANS_QUALIFIER
- B
- FQM_FLOW.FI_FISCAL_YEAR
- 0000
- FQM_FLOW.ORIGIN_FLOW_ID
- SAMPLE
- FQM_FLOW.PARENT_FLOW_ID
- 0001
- FQM_FLOW.PAYMENT_METHOD
- SAMPL
- FQM_FLOW.PROCESS_STATUS
- SA
- FQM_FLOW.TRANSACTION_ID
- 0001
- FQM_FLOW.CERTAINTY_LEVEL
- C
- ORIGIN_TRANSACTION_ID_RL
- RL_TXN_552
- FI_CREDIT_DEBIT_INDICATOR
- S
- FQM_FLOW.CLEARING_FLOW_ID
- 0001
- FQM_FLOW.CREATE_TIMESTAMP
- 100.00
- FQM_FLOW.FI_CLEARING_ITEM
- 100.00
- FQM_FLOW.FI_FISCAL_PERIOD
- 003
- FQM_FLOW.LAST_UPDATE_USER
- MIG_USER
- FQM_FLOW.ORIGIN_SYSTEM_RL
- LEGACY_A
- FQM_FLOW.PAYMENT_CURRENCY
- EUR
- FQM_FLOW.SOFTWARE_VERSION
- 1
- FQM_FLOW.TRANSACTION_DATE
- 20240101
- ORIGIN_TRANS_QUALIFIER_RL
- SAMPLE
- FI_INVOICE_FISCAL_YEAR_REF
- 0000
- FQM_FLOW.ORIGIN_FLOW_ID_RL
- SAMPLE
- FQM_FLOW.FI_DOCUMENT_NUMBER
- 1900004521
- FQM_FLOW.ORIGIN_APPLICATION
- SAMP
- FQM_FLOW.ORIGIN_DOCUMENT_ID
- SAMPLE
- FQM_FLOW.CASH_DISCOUNT_DAYS1
- 0
- FQM_FLOW.CASH_DISCOUNT_DAYS2
- 0
- FQM_FLOW.FI_INVOICE_ITEM_REF
- 0001
- FQM_FLOW.FI_CLEARING_DOCUMENT
- SAMPLE
- FQM_FLOW.FI_INVOICE_REFERENCE
- INV-99872
- FQM_FLOW.TRANSACTION_CATEGORY
- SAMPLE
- FQM_FLOW.FI_DOCUMENT_LINE_ITEM
- 0001
- FQM_FLOW.LAST_UPDATE_TIMESTAMP
- 100.00
- FQM_FLOW.ORIGIN_APPLICATION_RL
- SAMP
- FQM_FLOW.ORIGIN_DOCUMENT_ID_RL
- SAMPLE
- FQM_FLOW.ORIGIN_TRANSACTION_ID
- SAMPLE
- FQM_FLOW.PARENT_TRANSACTION_ID
- 0001
- FQM_FLOW.CASH_DISCOUNT_PERCENT1
- 100.00
- FQM_FLOW.CASH_DISCOUNT_PERCENT2
- 100.00
- FQM_FLOW.ORIGIN_TRANS_QUALIFIER
- SAMP
- FQM_FLOW.ORIGIN_TRANSACTION_ID_RL
- SAMPLE
- FQM_FLOW.FI_CREDIT_DEBIT_INDICATOR
- S
- FQM_FLOW.ORIGIN_TRANS_QUALIFIER_RL
- SAMP
- FQM_FLOW.FI_INVOICE_FISCAL_YEAR_REF
- 0000
Closed historical record with successor reference
- BUKRSR
- 2000
- HBKIDR
- HBG02
- AMOUNTR
- 125000.01
- HOUSE_BANK_IDR
- HBG02
- HOUSE_BANK_ACCOUNT_IDR
- NAIN
- FUND
- FM001
- HKTID
- NAIN
- MANDT
- 100
- OWNER
- C02
- CLEARED
- TAMPLE
- DELETED
- S
- FLOW_ID
- 0000000000000002
- RBLBETR
- 125000.01
- ROOT_ID
- 0000000000000001
- DAYS_DUE
- 0
- VALID_TO
- 20231231
- FLOW_TYPE
- PB
- GRANT_NBR
- G000000000000001
- FLG_ACTUAL
- X
- REL_STATUS
- R
- VALID_FROM
- 20221231
- CREATE_USER
- MIGUSER02
- PAYMENT_DATE
- 20240208
- PAYMENT_MODE
- B
- BASELINE_DATE
- 20240207
- DOCUMENT_DATE
- 20240206
- FLOW_CATEGORY
- 000011
- FQM_FLOW.FUND
- —
- ORIGIN_SYSTEM
- LEGACYER02
- PAYMENT_BLOCK
- A
- FI_FISCAL_YEAR
- 0001
- FQM_FLOW.OWNER
- —
- ORIGIN_FLOW_ID
- ITEM00102
- PARENT_FLOW_ID
- 0000000000000001
- PAYMENT_METHOD
- C
- PROCESS_STATUS
- A
- TRANSACTION_ID
- 0000000000000002
- CERTAINTY_LEVEL
- D
- CLEARING_FLOW_ID
- 0000000000000001
- CREATE_TIMESTAMP
- 202401011030000000000000000.0000001
- FI_CLEARING_ITEM
- 100
- FI_FISCAL_PERIOD
- 01
- FQM_FLOW.CLEARED
- —
- FQM_FLOW.DELETED
- —
- FQM_FLOW.FLOW_ID
- —
- FQM_FLOW.ROOT_ID
- —
- LAST_UPDATE_USER
- MIGUSER02
- ORIGIN_SYSTEM_RL
- LEGACYA02
- PAYMENT_CURRENCY
- USD
- SOFTWARE_VERSION
- 1
- TRANSACTION_DATE
- 20240207
- FQM_FLOW.DAYS_DUE
- —
- FQM_FLOW.VALID_TO
- —
- ORIGIN_FLOW_ID_RL
- RLFLOW88102
- FI_DOCUMENT_NUMBER
- 1900004502
- FQM_FLOW.FLOW_TYPE
- —
- FQM_FLOW.GRANT_NBR
- —
- ORIGIN_APPLICATION
- GI
- ORIGIN_DOCUMENT_ID
- LEGACYBAL20240101GBP02
- CASH_DISCOUNT_DAYS1
- 0
- CASH_DISCOUNT_DAYS2
- 0
- FI_INVOICE_ITEM_REF
- 001
- FQM_FLOW.FLG_ACTUAL
- —
- FQM_FLOW.REL_STATUS
- —
- FQM_FLOW.VALID_FROM
- —
- FI_CLEARING_DOCUMENT
- TAMPLE
- FI_INVOICE_REFERENCE
- INV9987202
- FQM_FLOW.CREATE_USER
- —
- TRANSACTION_CATEGORY
- PBAL
- FI_DOCUMENT_LINE_ITEM
- 001
- FQM_FLOW.PAYMENT_DATE
- —
- FQM_FLOW.PAYMENT_MODE
- —
- LAST_UPDATE_TIMESTAMP
- 202401011030000000000000000.0000001
- ORIGIN_APPLICATION_RL
- GI
- ORIGIN_DOCUMENT_ID_RL
- LEGACYDOC99902
- ORIGIN_TRANSACTION_ID
- OPENBALMAINACC02
- PARENT_TRANSACTION_ID
- 0000000000000001
- CASH_DISCOUNT_PERCENT1
- 0.001
- CASH_DISCOUNT_PERCENT2
- 0.001
- FQM_FLOW.BASELINE_DATE
- —
- FQM_FLOW.DOCUMENT_DATE
- —
- FQM_FLOW.FLOW_CATEGORY
- —
- FQM_FLOW.ORIGIN_SYSTEM
- —
- FQM_FLOW.PAYMENT_BLOCK
- —
- ORIGIN_TRANS_QUALIFIER
- C
- FQM_FLOW.FI_FISCAL_YEAR
- —
- FQM_FLOW.ORIGIN_FLOW_ID
- —
- FQM_FLOW.PARENT_FLOW_ID
- —
- FQM_FLOW.PAYMENT_METHOD
- —
- FQM_FLOW.PROCESS_STATUS
- —
- FQM_FLOW.TRANSACTION_ID
- —
- FQM_FLOW.CERTAINTY_LEVEL
- —
- ORIGIN_TRANSACTION_ID_RL
- RLTXN55202
- FI_CREDIT_DEBIT_INDICATOR
- S
- FQM_FLOW.CLEARING_FLOW_ID
- —
- FQM_FLOW.CREATE_TIMESTAMP
- —
- FQM_FLOW.FI_CLEARING_ITEM
- 100
- FQM_FLOW.FI_FISCAL_PERIOD
- —
- FQM_FLOW.LAST_UPDATE_USER
- —
- FQM_FLOW.ORIGIN_SYSTEM_RL
- —
- FQM_FLOW.PAYMENT_CURRENCY
- —
- FQM_FLOW.SOFTWARE_VERSION
- —
- FQM_FLOW.TRANSACTION_DATE
- —
- ORIGIN_TRANS_QUALIFIER_RL
- TAMPLE
- FI_INVOICE_FISCAL_YEAR_REF
- 0001
- FQM_FLOW.ORIGIN_FLOW_ID_RL
- —
- FQM_FLOW.FI_DOCUMENT_NUMBER
- —
- FQM_FLOW.ORIGIN_APPLICATION
- —
- FQM_FLOW.ORIGIN_DOCUMENT_ID
- —
- FQM_FLOW.CASH_DISCOUNT_DAYS1
- —
- FQM_FLOW.CASH_DISCOUNT_DAYS2
- —
- FQM_FLOW.FI_INVOICE_ITEM_REF
- —
- FQM_FLOW.FI_CLEARING_DOCUMENT
- —
- FQM_FLOW.FI_INVOICE_REFERENCE
- —
- FQM_FLOW.TRANSACTION_CATEGORY
- —
- FQM_FLOW.FI_DOCUMENT_LINE_ITEM
- —
- FQM_FLOW.LAST_UPDATE_TIMESTAMP
- —
- FQM_FLOW.ORIGIN_APPLICATION_RL
- —
- FQM_FLOW.ORIGIN_DOCUMENT_ID_RL
- —
- FQM_FLOW.ORIGIN_TRANSACTION_ID
- —
- FQM_FLOW.PARENT_TRANSACTION_ID
- —
- FQM_FLOW.CASH_DISCOUNT_PERCENT1
- —
- FQM_FLOW.CASH_DISCOUNT_PERCENT2
- —
- FQM_FLOW.ORIGIN_TRANS_QUALIFIER
- —
- FQM_FLOW.ORIGIN_TRANSACTION_ID_RL
- —
- FQM_FLOW.FI_CREDIT_DEBIT_INDICATOR
- —
- FQM_FLOW.ORIGIN_TRANS_QUALIFIER_RL
- —
- FQM_FLOW.FI_INVOICE_FISCAL_YEAR_REF
- —
New record with minimal optional data
- BUKRSR
- 3000
- HBKIDR
- HBG03
- AMOUNTR
- 125000.02
- HOUSE_BANK_IDR
- HBG03
- HOUSE_BANK_ACCOUNT_IDR
- MCIN
- FUND
- —
- HKTID
- MCIN
- MANDT
- —
- OWNER
- —
- CLEARED
- —
- DELETED
- —
- FLOW_ID
- 0000000000000003
- RBLBETR
- 125000.02
- ROOT_ID
- 0000000000000002
- DAYS_DUE
- —
- VALID_TO
- 99991231
- FLOW_TYPE
- OD
- GRANT_NBR
- —
- FLG_ACTUAL
- —
- REL_STATUS
- —
- VALID_FROM
- 20250101
- CREATE_USER
- —
- PAYMENT_DATE
- —
- PAYMENT_MODE
- —
- BASELINE_DATE
- —
- DOCUMENT_DATE
- —
- FLOW_CATEGORY
- —
- FQM_FLOW.FUND
- —
- ORIGIN_SYSTEM
- —
- PAYMENT_BLOCK
- —
- FI_FISCAL_YEAR
- —
- FQM_FLOW.OWNER
- —
- ORIGIN_FLOW_ID
- ITEM00103
- PARENT_FLOW_ID
- 0000000000000002
- PAYMENT_METHOD
- —
- PROCESS_STATUS
- —
- TRANSACTION_ID
- 0000000000000003
- CERTAINTY_LEVEL
- E
- CLEARING_FLOW_ID
- 0000000000000002
- CREATE_TIMESTAMP
- —
- FI_CLEARING_ITEM
- —
- FI_FISCAL_PERIOD
- —
- FQM_FLOW.CLEARED
- —
- FQM_FLOW.DELETED
- —
- FQM_FLOW.FLOW_ID
- —
- FQM_FLOW.ROOT_ID
- —
- LAST_UPDATE_USER
- —
- ORIGIN_SYSTEM_RL
- —
- PAYMENT_CURRENCY
- EUR
- SOFTWARE_VERSION
- —
- TRANSACTION_DATE
- 20240315
- FQM_FLOW.DAYS_DUE
- —
- FQM_FLOW.VALID_TO
- —
- ORIGIN_FLOW_ID_RL
- RLFLOW88103
- FI_DOCUMENT_NUMBER
- 1900004503
- FQM_FLOW.FLOW_TYPE
- —
- FQM_FLOW.GRANT_NBR
- —
- ORIGIN_APPLICATION
- —
- ORIGIN_DOCUMENT_ID
- LEGACYBAL20240101GBP03
- CASH_DISCOUNT_DAYS1
- —
- CASH_DISCOUNT_DAYS2
- —
- FI_INVOICE_ITEM_REF
- —
- FQM_FLOW.FLG_ACTUAL
- —
- FQM_FLOW.REL_STATUS
- —
- FQM_FLOW.VALID_FROM
- —
- FI_CLEARING_DOCUMENT
- —
- FI_INVOICE_REFERENCE
- —
- FQM_FLOW.CREATE_USER
- —
- TRANSACTION_CATEGORY
- —
- FI_DOCUMENT_LINE_ITEM
- —
- FQM_FLOW.PAYMENT_DATE
- —
- FQM_FLOW.PAYMENT_MODE
- —
- LAST_UPDATE_TIMESTAMP
- —
- ORIGIN_APPLICATION_RL
- —
- ORIGIN_DOCUMENT_ID_RL
- LEGACYDOC99903
- ORIGIN_TRANSACTION_ID
- OPENBALMAINACC03
- PARENT_TRANSACTION_ID
- 0000000000000002
- CASH_DISCOUNT_PERCENT1
- —
- CASH_DISCOUNT_PERCENT2
- —
- FQM_FLOW.BASELINE_DATE
- —
- FQM_FLOW.DOCUMENT_DATE
- —
- FQM_FLOW.FLOW_CATEGORY
- —
- FQM_FLOW.ORIGIN_SYSTEM
- —
- FQM_FLOW.PAYMENT_BLOCK
- —
- ORIGIN_TRANS_QUALIFIER
- —
- FQM_FLOW.FI_FISCAL_YEAR
- —
- FQM_FLOW.ORIGIN_FLOW_ID
- —
- FQM_FLOW.PARENT_FLOW_ID
- —
- FQM_FLOW.PAYMENT_METHOD
- —
- FQM_FLOW.PROCESS_STATUS
- —
- FQM_FLOW.TRANSACTION_ID
- —
- FQM_FLOW.CERTAINTY_LEVEL
- —
- ORIGIN_TRANSACTION_ID_RL
- RLTXN55203
- FI_CREDIT_DEBIT_INDICATOR
- —
- FQM_FLOW.CLEARING_FLOW_ID
- —
- FQM_FLOW.CREATE_TIMESTAMP
- —
- FQM_FLOW.FI_CLEARING_ITEM
- —
- FQM_FLOW.FI_FISCAL_PERIOD
- —
- FQM_FLOW.LAST_UPDATE_USER
- —
- FQM_FLOW.ORIGIN_SYSTEM_RL
- —
- FQM_FLOW.PAYMENT_CURRENCY
- —
- FQM_FLOW.SOFTWARE_VERSION
- —
- FQM_FLOW.TRANSACTION_DATE
- —
- ORIGIN_TRANS_QUALIFIER_RL
- —
- FI_INVOICE_FISCAL_YEAR_REF
- —
- FQM_FLOW.ORIGIN_FLOW_ID_RL
- —
- FQM_FLOW.FI_DOCUMENT_NUMBER
- —
- FQM_FLOW.ORIGIN_APPLICATION
- —
- FQM_FLOW.ORIGIN_DOCUMENT_ID
- —
- FQM_FLOW.CASH_DISCOUNT_DAYS1
- —
- FQM_FLOW.CASH_DISCOUNT_DAYS2
- —
- FQM_FLOW.FI_INVOICE_ITEM_REF
- —
- FQM_FLOW.FI_CLEARING_DOCUMENT
- —
- FQM_FLOW.FI_INVOICE_REFERENCE
- —
- FQM_FLOW.TRANSACTION_CATEGORY
- —
- FQM_FLOW.FI_DOCUMENT_LINE_ITEM
- —
- FQM_FLOW.LAST_UPDATE_TIMESTAMP
- —
- FQM_FLOW.ORIGIN_APPLICATION_RL
- —
- FQM_FLOW.ORIGIN_DOCUMENT_ID_RL
- —
- FQM_FLOW.ORIGIN_TRANSACTION_ID
- —
- FQM_FLOW.PARENT_TRANSACTION_ID
- —
- FQM_FLOW.CASH_DISCOUNT_PERCENT1
- —
- FQM_FLOW.CASH_DISCOUNT_PERCENT2
- —
- FQM_FLOW.ORIGIN_TRANS_QUALIFIER
- —
- FQM_FLOW.ORIGIN_TRANSACTION_ID_RL
- —
- FQM_FLOW.FI_CREDIT_DEBIT_INDICATOR
- —
- FQM_FLOW.ORIGIN_TRANS_QUALIFIER_RL
- —
- FQM_FLOW.FI_INVOICE_FISCAL_YEAR_REF
- —
Rule Validation Summary
- Source Rule Count
- 146
- Governed Rule Count
- 146
