/PF1/DB_ORDER - Payment Order in the Payment Engine
Payment Order in the Payment Engine information is stored in SAP table /PF1/DB_ORDER.
It is part of development package /PF1/PO_PERSISTENCY_LAYER in software component FIN-FSCM-PF. This development package consists of objects that can be grouped under "PO Processing Persistence Layer".
It is part of development package /PF1/PO_PERSISTENCY_LAYER in software component FIN-FSCM-PF. This development package consists of objects that can be grouped under "PO Processing Persistence Layer".
Fields for table /PF1/DB_ORDER
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| .INCLUDE | X | /PF1/STR_BPE_TECH_KEY | 0 | |||
| CLIENT | Client | X | MANDT | CLNT | 6 | * |
| GUID | Globally Unique Identifier | X | GUID | RAW | 16 | |
| .INCLUDE | GRP_BUSINESS_DATA | /PF1/STR_PO_ORDER_NEW | 0 | |||
| .INCLUDE | BUS_KEY | /PF1/STR_PO_PO_KEY_BUSINESS | 0 | |||
| CLEARING_AREA | Clearing Area | /PF1/DTE_BPE_CLEARING_AREA | CHAR | 12 | /PF1/T_CLAREA | |
| PO_DATE | Payment Order Date | /PF1/DTE_PO_PO_DATE | DATS | 16 | ||
| PO_NO | Payment Order Number From Number Range | /PF1/DTE_PO_PO_SECONDARY_KEY | NUMC | 24 | ||
| .INCLUDE | /PF1/STR_PO_POADMINDATA | 0 | ||||
| TECH_STAT | Technical Status of Payment Order | /PF1/DTE_PO_TECH_STAT | CHAR | 6 | * | |
| PREV_TECH_STAT | Previous Technical Status of Payment Order | /PF1/DTE_PO_PREV_TECH_STAT | CHAR | 6 | * | |
| DISP_STAT | External Status | /PF1/DTE_BPE_DISPATCH_STATE | CHAR | 12 | * | |
| PO_TYPE | Payment Order Type | /PF1/DTE_PO_PO_TYPE | CHAR | 12 | /PF1/T_POTYPE | |
| PROC_DATE | Order Processing Date in Advanced Payment Mgmt | /PF1/DTE_PO_PROC_DATE | DATS | 16 | ||
| PROC_TIME | Order Processing Time in Advanced Payment Management | /PF1/DTE_PO_PROC_TIM | TIMS | 12 | ||
| PL_PROC_DATE | Execution Date (Planned) | /PF1/DTE_PO_PO_PLANNEDPROCDATE | DATS | 16 | ||
| PL_PROC_TIME | Execution Time (Planned) | /PF1/DTE_PO_PO_PLANNEDPROCTIME | TIMS | 12 | ||
| PRIORITY | Payment Priority | /PF1/DTE_PO_PO_PRIORITY | CHAR | 4 | ||
| REVERSAL_CODE | Return/Rejection Reason | /PF1/DTE_BPE_REVERSAL_CODE | CHAR | 12 | /PF1/T_REVERSE | |
| FILE_NUMBER | File Number | /PF1/DTE_BPE_FH_FILE_NO | CHAR | 8 | ||
| FILE_CRDATE | File Creation Date | /PF1/DTE_BPE_FH_FILE_CRDATE | DATS | 16 | ||
| FLG_FH_ERROR | Payment Order Error Flag | /PF1/DTE_FH_FLG_PO_ERROR | CHAR | 2 | ||
| FLG_ENFORCE_PROC | Forced Processing Identification | /PF1/DTE_PO_FLG_ENFORCE_PROC | CHAR | 2 | ||
| PO_SIZE | Flag for Small or Large Order Size Category | /PF1/DTE_FH_ORDER_SIZE | CHAR | 2 | ||
| FLG_EH_ERROR | Payment Order Error Flag due to EH Checks | /PF1/DTE_EH_FLG_PO_ERROR | CHAR | 2 | ||
| IPO_RESUB_STAT | Technical Status of Payment Order | /PF1/DTE_PO_TECH_STAT | CHAR | 6 | ||
| FLG_LISTENER_REG | Event Listener Registered | /PF1/DTE_OBJECT_LISTENER_REG | CHAR | 2 | ||
| UPDATE_COUNTER | Lock Counter for Optimistic Stateless Updates | /PF1/DTE_LOCK_COUNTER | DEC | 3 | ||
| BTCHBOOKG | Batch Booking Indicator | /PF1/DTE_PO_BTCHBOOKG | CHAR | 2 | ||
| TECH_PRIORITY | Payment Order Technical Priority | /PF1/DTE_PO_PO_TECH_PRIORITY | NUMC | 6 | ||
| PROCESS | Creation Process of Payment Object | /PF1/DTE_PO_PI_PROCESS | CHAR | 8 | * | |
| SEGMENTATION_KEY | Segmentation Criteria for DB Tables | /PF1/DTE_BPE_SEGMENTATION_KEY | CHAR | 4 | ||
| .INCLUDE | /PF1/STR_PO_PO_GENREF | 0 | ||||
| .INCLUDE | GRP_SND | /PF1/STR_PO_PO_SNDREF | 0 | |||
| .INCLUDE | GRP_SND_INT | /PF1/STR_PO_PO_SNDREFINT | 0 | |||
| SND_INT_COUNTRY | Bank Country/Region (Internal Sender) | /PF1/DTE_PO_BNKCNTRY_INT_SND | CHAR | 6 | T005 | |
| SND_INT_BANKKEY | Bank Key (Internal Sender) | /PF1/DTE_PO_BANKCODE_INT_SND | CHAR | 30 | ||
| SND_INT_BIC | Bank Identifier Code (BIC) of Internal Sender | /PF1/DTE_PO_BIC_INT_SND | CHAR | 22 | ||
| SND_INT_IBAN | IBAN (Internal Sender) | /PF1/DTE_PO_IBAN_INT_SND | CHAR | 68 | ||
| SND_INT_ACC | Account Number (Internal Sender) | /PF1/DTE_PO_PO_SND_ACCNT | CHAR | 68 | ||
| SND_INT_ACC_CUR | Account Currency (Internal Sender) | /PF1/DTE_PO_PO_SND_AC_CUR | CUKY | 10 | * | |
| SND_INT_ACC_HLDR | Sender Name | /PF1/DTE_PO_PO_SND_NAME | CHAR | 160 | ||
| SND_INT_REF | Reference (Internal Sender) | /PF1/DTE_PO_PO_SND_INT_REF | CHAR | 70 | ||
| SND_COMPANY_CODE | Company Code | BUKRS | CHAR | 8 | ||
| SND_BAM_ID | Bank Account Technical ID | FCLM_BAM_ACC_ID | NUMC | 20 | ||
| .INCLUDE | GRP_RCV | /PF1/STR_PO_PO_RCVREF | 0 | |||
| RCV_COUNTRY | Bank Country/Region Recipient | /PF1/DTE_PO_BNKCNTRY_RCV | CHAR | 6 | T005 | |
| RCV_BANKKEY | Bank Key Recipient | /PF1/DTE_PO_BANKCODE_RCV | CHAR | 30 | ||
| RCV_BIC | Bank Identifier Code (BIC) of Recipient | /PF1/DTE_PO_BIC_RCV | CHAR | 22 | ||
| RCV_NAME | Recipient Name | /PF1/DTE_PO_PO_RCV_NAME | CHAR | 160 | ||
| REF_EXT_PO | External Payment Order Number | /PF1/DTE_PO_PO_EXTERNAL_REF | CHAR | 70 | ||
| IN_OUT_FORMAT | Format | /PF1/DTE_BPE_FORMAT | CHAR | 20 | /PF1/T_FORMAT | |
| MEDIUM | Medium | /PF1/DTE_BPE_MEDIUM | CHAR | 8 | /PF1/T_MEDIUM | |
| CHANNEL | Channel | /PF1/DTE_BPE_CHANNEL | CHAR | 20 | /PF1/T_CHANNEL | |
| FLG_ADD_INFO | (Additional) Information for Payment Order Available | /PF1/DTE_PO_PO_FLG_ADD_INFO | CHAR | 2 | ||
| RISK_SCORE | Risk Score | /PF1/DTE_BPE_RISK_SCORE | INT2 | 2 | ||
| .INCLUDE | GRP_IDOC | /PF1/STR_PO_IDOC_REFERENCES | 0 | |||
| PAYMENT_METHOD | Payment Method for This Payment | RZAWE | CHAR | 2 | * | |
| PAYMENT_METHOD_SUPPLEMENT | Payment method supplement | UZAWE | CHAR | 4 | * | |
| .INCLUDE | GRP_PMTTPINF | /PF1/STR_ISO_PMT_TP_INFO | 0 | |||
| LCL_INSTRUMENT | ISO20022: Local Instrument Code or Proprietary Code | /PF1/DTE_LOCAL_INSTRUMENT | CHAR | 70 | ||
| CATEGORY_PURPOSE_CODE | ISO20022: Category Purpose Code or Proprietary Code | /PF1/DTE_CATEGORYPURPOSECDPRTY | CHAR | 70 | ||
| SERVICE_LEVEL | ISO20022: Service Level Code or Proprietary Code | /PF1/DTE_SERVICE_LEVEL_CD_PRTY | CHAR | 70 | ||
| .INCLUDE | OL_KEY | /PF1/STR_FH_OL_KEY_BUSINESS | 0 | |||
| OL_DATE | Object List Date | /PF1/DTE_FH_OL_DATE | DATS | 16 | ||
| OL_NO | Object List Number from Number Range (Secondary Key) | /PF1/DTE_FH_OL_SECONDARY_KEY | NUMC | 24 | ||
| .INCLUDE | /PF1/STR_PO_PO_ITEMCOUNT | 0 | ||||
| CNT_ORP_ITEMS | Number of Ordering Party Items | /PF1/DTE_PO_CNT_ORP_ITEMS | NUMC | 16 | ||
| CNT_RCP_ITEMS | Number of Recipient Items | /PF1/DTE_PO_CNT_RCP_ITEMS | NUMC | 16 | ||
| CNT_CLR_ITEMS | Number of Clearing Items | /PF1/DTE_PO_CNT_CLR_ITEMS | NUMC | 16 | ||
| CNT_TOV_ITEMS | Number of Turnover Items | /PF1/DTE_PO_CNT_TOV_ITEMS | NUMC | 16 | ||
| .INCLUDE | /PF1/STR_PO_PO_ITEM_SUM | 0 | ||||
| SUM_ITEMS | Sum of Amounts | /PF1/DTE_PO_AMNT_SUM_ITEMS | CURR | 12 | ||
| SUM_CURR | Currency of Recipient Items | /PF1/DTE_PO_CURR_SUM_ITEMS | CUKY | 10 | * | |
| RELEASE_AMOUNT | Amount Calculated for Release | /PF1/DTE_BPE_RELEASE_AMOUNT | CURR | 12 | ||
| RELEASE_CURR | Release Currency | /PF1/DTE_BPE_RELEASE_CURRENCY | CUKY | 10 | * | |
| .INCLUDE | COLLECTOR_KEY | /PF1/STR_PO_PO_COLLECTOR_REF | 0 | |||
| REF_COLL_DATE | Payment Batch Date | /PF1/DTE_CP_COLLECTOR_DATE | DATS | 16 | ||
| REF_COLL_NO | Payment Batch Number from Number Range (Secondary Key) | /PF1/DTE_CP_CO_SECONDARY_KEY | NUMC | 20 | ||
| REF_COLL_SEQ_NO | Sequence Number of Payment Batch | /PF1/DTE_CP_SEQUENCE_NO | NUMC | 10 | ||
| .INCLUDE | /PF1/STR_PO_ORDER_REL_PROCESS | 0 | ||||
| RELEASE_ACTIVITY | Activity for Release and Authorization Check | /PF1/ACTIV_AUTH | CHAR | 4 | ||
| RELEASE_STATUS | Release Status | /PF1/DTE_PO_RELEASE_STATUS | CHAR | 4 | ||
| .INCLUDE | /PF1/STR_PO_ORDER_EV | 0 | ||||
| FLG_EV_STATUS | Execution Status of Each Check | /PF1/DTE_PO_FLG_CHK_EV_STATUS | CHAR | 120 | ||
| EV_ID_ORDER | Check Set ID for Payment Order Enrichment and Validation | /PF1/DTE_BPE_ORDER_EV_ID | NUMC | 12 | ||
| EV_ID_X_ITEM | Check Set ID for Cross Item Enrichment and Validation | /PF1/DTE_BPE_ITEM_EV_ID | NUMC | 12 | ||
| CONTINUE_EV | Enrichment & Validation Continuation Status | /PF1/DTE_PO_FLG_CONTINUE_EV | CHAR | 2 | ||
| CHECK_SUM_METHOD | Function Name | /PF1/DTE_BPE_FUNCTION_NAME | CHAR | 60 | * | |
| FLG_DUP_CHECK | Duplicate Check | /PF1/DTE_PO_FLG_DUPCK | CHAR | 2 | ||
| FLG_DUP_CHECKSUM | Internal or External Checksum | /PF1/DTE_PO_FLG_DUP_SUM | CHAR | 2 | ||
| TIMESTAMP_SBM_PS | File Submission Time | /PF1/DTE_PO_TIM_STAMP_SUBM | CHAR | 28 | ||
| PO_AUTH_FLAG | Flag for Authorization Check | /PF1/DTE_PO_AUTHO_FLAG | CHAR | 2 | ||
| CHECKSUM | Order Checksum | /PF1/DTE_PO_CHECKSUM | CHAR | 400 | ||
| TIMESTAMP_FCT_PS | Timestamp Functional Submission/Output (Adv. Payment Mgmt) | /PF1/DTE_PO_TIM_STAMP_FCT | CHAR | 28 | ||
| PAYMENT_SCENARIO | Payment Scenario Description | /PF1/DTE_PAYM_SCENARIO | CHAR | 2 | ||
| ORP_SPLIT | Ordering Party Item Split | /PF1/DTE_BPE_SPLIT_INDI | CHAR | 2 | ||
| .INCLUDE | SLA_KEY | /PF1/STR_PO_ORDER_SLA | 0 | |||
| REF_CUST_GRP | Customer Group | /PF1/DTE_BPE_CUST_GRP | CHAR | 22 | ||
| REF_CUSTOMER | Customer | /PF1/DTE_BPE_CUSTOMER | CHAR | 22 | ||
| REF_CUST_SGM | Customer Segment | /PF1/DTE_BPE_CUST_SGM | CHAR | 22 | ||
| .INCLUDE | /PF1/STR_PO_ORDER_REF_REC | 0 | ||||
| REF_RECALL_DATE | Payment Recall Date | /PF1/DTE_PO_PO_KEY_DATE | DATS | 16 | ||
| REF_RECALL_NO | Payment Recall Number | /PF1/DTE_RECALL_ID | NUMC | 24 | ||
| .INCLUDE | /PF1/STR_PO_AUTH_DATA_PO | 0 | ||||
| AUTH_PENDING | Pending Authorization Indicator | /PF1/DTE_PO_AUTH_PENDING | CHAR | 4 | ||
| AUTH_PO_ID | Payment Order ID of the Authorization System | /PF1/DTE_PO_AUTH_PO_ID | CHAR | 64 | ||
| AUTH_TIMESTAMP | Timestamp of the Authorization | /PF1/DTE_PO_AUTH_TIMESTAMP | CHAR | 28 | ||
| .INCLUDE | /PF1/STR_PO_VALUE_DATE_PO | 0 | ||||
| ORP_VAL_DATE_1 | (OBSOLETE) Ordering Party Value Date 1 | /PF1/DTE_PO_ORP_VAL_DATE_1 | DATS | 16 | ||
| ORP_VAL_DATE_2 | (OBSOLETE) Ordering Party Value Date 2 | /PF1/DTE_PO_ORP_VAL_DATE_2 | DATS | 16 | ||
| FLG_HOLD_VALDATE | (OBSOLETE) Holds Value Date Indicator | /PF1/DTE_PO_FLG_HOLD_VAL_DATE | CHAR | 2 | ||
| .INCLUDE | /PF1/STR_PO_PO_SEPA | 0 | ||||
| SETT_DATE | (OBSOLETE) Interbank Settlement Date | /PF1/DTE_PO_SETT_DATE | DATS | 16 | ||
| DUE_DATE | Due Date Specified by Ordering Party | /PF1/DTE_PO_DUE_DATE | DATS | 16 | ||
| .INCLUDE | /PF1/STR_PO_MULTI_COLLECTOR | 0 | ||||
| FLG_MULTI_COLL | Flag to identify this CA / Collec / PO for Multi Collection | /PF1/DTE_BPE_FLG_MULTI_COLLECT | CHAR | 2 | ||
| FLG_MULTI_PROC | Flag to Check Whether Batch is Already Processed | /PF1/DTE_BPE_FLG_MULTI_PROC | CHAR | 2 | ||
| .INCLUDE | AFX_STATUS_DATA_EXT | 0 | ||||
| ARCHIVE_STATUS | Archiving Status | TYP_ARCHIVE_STATUS | CHAR | 2 | ||
| ARCHIVE_FLUD | Resubmission Date | TYP_ARCHIVE_FLUD | DATS | 16 | ||
| REJECTION | Rejection Reason | TYP_REJECTION | CHAR | 4 | ||
| .INCLUDE | GRP_ADMIN | /PF1/STR_BPE_DBADMIN | 0 | |||
| CRUSR | Creating User | /PF1/DTE_BPE_CRUSR | CHAR | 24 | ||
| CRDAT | Creation Date | /PF1/DTE_BPE_CRDAT | DATS | 16 | ||
| CRTIM | Creation Time | /PF1/DTE_BPE_CRTIM | TIMS | 12 | ||
| CHUSR | Last User Change | /PF1/DTE_BPE_CHUSR | CHAR | 24 | ||
| CHDAT | Change Date | /PF1/DTE_BPE_CHDAT | DATS | 16 | ||
| CHTIM | Changed Time | /PF1/DTE_BPE_CHTIM | TIMS | 12 | ||
| RLUSR | User Who Released Object | /PF1/DTE_BPE_RLUSR | CHAR | 24 | ||
| RLDAT | Release Date | /PF1/DTE_BPE_RLDAT | DATS | 16 | ||
| RLTIM | Release Time | /PF1/DTE_BPE_RLTIM | TIMS | 12 |