/PF1/DB_ROUTE

Database Table for Route | #masterdata | Component: Payment Factory
Column Name Description
CLIENT FK Client
CLEARING_AREA FK Clearing Area
ROUTE_ID Route ID
RELEASE_STATUS Release Status Show values
Column Name Description
Column Name Description
Column Name Description
CLEARING_START Begin of Clearing
CLEARING_END End of Clearing
CRDAT Creation Date
CRTIM Creation Time
CHDAT Change Date
CHTIM Changed Time
RLDAT Release Date
RLTIM Release Time
ARCHIVE_FLUD Resubmission Date
Column Name Description
RELEASE_STATUS Release Status Show values
ROUTE_STATUS Route Status Show values
FLG_INTERNAL Internal Route Show values
FLG_LOCK_OUTPUT Lock Outgoing Payment Orders for Route/Clearing Agreement Show values
FLG_CLEARING_TIME Cut-Off Time - Channel Availability Show values
CLEARING_TZ_SEL Time Zone Selection for Clearing Time Show values
RELEASE_STATUSCD Release Status Show values
ARCHIVE_STATUS Archiving Status Show values
Column Name Description Domain name
CL_INSTITUT Clearing Institute BU_PARTNER
ROUTE_BANKKEY Bank Key for Account at Route BANKK
ROUTE_ACCT_NO Account Number for Account at Route /PF1/DOM_BPE_ACCT
ROUTE_IBAN IBAN for Account at Route /PF1/DOM_BPE_IBAN
ROUTE_HOLDERNAME Account Holder for Account at Route /PF1/DOM_BPE_HOLDERNAME
VA_RULESET Rule Set ID of Value Date Agreement /PF1/DOM_RP_RULESET_ID
NODE_ID Globally Unique Identifier
CRUSR Creating User USNAM
CHUSR Last User Change USNAM
RLUSR User Who Released Object USNAM
REJECTION Rejection Reason
Master Data Relations Join Conditions
Posting Item Area
  • Clearing Area
  • Account Managing Area
Bank Account Technical ID
  • ?
  • Bank Account Technical ID
Company Code
  • /PF1/DB_ROUTE.CLIENT == T001.MANDT
  • /PF1/DB_ROUTE.BUKRS == T001.BUKRS
Calendar for Value Calculation /PF1/DB_ROUTE.CALENDAR == TFACD.IDENT
Clearing Area /PF1/DB_ROUTE.CLIENT == /PF1/T_CLAREA.MANDT
Time Zone of Clearing Time
  • /PF1/DB_ROUTE.CLIENT == TTZZ.CLIENT
  • /PF1/DB_ROUTE.CLEARING_TZ == TTZZ.TZONE
Client /PF1/DB_ROUTE.CLIENT == T000.MANDT
Account Currency for Route Account
  • /PF1/DB_ROUTE.CLIENT == TCURC.MANDT
  • /PF1/DB_ROUTE.DEFAULT_CURRENCY == TCURC.WAERS
Foreign Exchange Application
  • Foreign Exchange Application
  • Client
  • ?
Bank Country/Region for Account at Route
  • Bank Country/Region for Account at Route
  • Client
  • /PF1/DB_ROUTE.ROUTE_COUNTRY == T005.LAND1
  • /PF1/DB_ROUTE.CLIENT == T005.MANDT