|
|
API OBTC
OBTC - Internal Bank Operation Codes Table
OBTC SQL Table
G/L Accounts OACT SQL Table
Distribution Rule OOCR SQL Table
Project Codes OPRJ SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | 0 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| InOpCode KEY UNIQUE | Internal Bank Operation Code Name | nVarChar | 15 | CODE_NAME | Yes | |||
| PstTrans | Posting Transaction | VarChar | 1) Bank Transfer 2) Incoming Bill of Exchange 3) Outgoing Bill of Exchange 4) Outgoing Checks 5) Deposit | 1 | 1 | |||
| BPorAct | BP or Account | VarChar | C) BP A) Account | 1 | C | |||
| PstMethod | BP Posting Method | VarChar | A) G/L Account from/to Bank Account C) Business Partner from/to Bank Account J) Bank Interim Account from/to Bank Account E) External Reconciliation I) Ignore | 1 | C | |||
| ActFee | Account Fee | nVarChar | 15 | OACT G/L Accounts | ||||
| ProjFee | Project Fee | nVarChar | 20 | OPRJ Project Codes | ||||
| PrftCntFee | Fee Distribution Rule | nVarChar | 8 | OOCR Distribution Rule | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| Descript | Operation Description | nVarChar | 40 | |||||
| PrftCntFe2 | Fee Distribution Rule2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| PrftCntFe3 | Fee Distribution Rule3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| PrftCntFe4 | Fee Distribution Rule4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| PrftCntFe5 | Fee Distribution Rule5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users |
Table relationship map
SELECT statement
SELECT
OBTC.AbsEntry AS 'Internal Number',
OBTC.InOpCode AS 'Internal Bank Operation Code Name',
OBTC.PstTrans AS 'Posting Transaction',
OBTC.BPorAct AS 'BP or Account',
OBTC.PstMethod AS 'BP Posting Method',
OBTC.ActFee AS 'Account Fee',
OBTC.ProjFee AS 'Project Fee',
OBTC.PrftCntFee AS 'Fee Distribution Rule',
OBTC.LogInstanc AS 'Log Instance',
OBTC.UpdateDate AS 'Date of Update',
OBTC.UserSign AS 'User Signature',
OBTC.Descript AS 'Operation Description',
OBTC.PrftCntFe2 AS 'Fee Distribution Rule2',
OBTC.PrftCntFe3 AS 'Fee Distribution Rule3',
OBTC.PrftCntFe4 AS 'Fee Distribution Rule4',
OBTC.PrftCntFe5 AS 'Fee Distribution Rule5',
OBTC.UserSign2 AS 'Updating User'
FROM OBTC AS OBTC
Related information
OBTC SQL Table
G/L Accounts OACT SQL Table
Distribution Rule OOCR SQL Table
Project Codes OPRJ SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
