| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | RBAENINT | Position Change - Internal Number | nvarchar | 16 | 0 | CHAR | (N' ') | No | | JBDBAENINT | Allow NULL? |
| 3 | RBAENEXT | Position Change - External Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | JBDBAENEXT | Allow NULL? |
| 4 | SBAENTYP | Category of Position Change | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | JBDBAENTYP | Allow NULL? |
| 5 | SBAENKMKNZ | Indicator for Corporate Action | char | 1 | 0 | CHAR | (N' ') | Yes | | JBDBAENKMKNZ | Allow NULL? |
| 6 | BUKRS | Company Code of Source Position | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | JBBUKRSQ | Allow NULL? |
| 7 | REFBUKRS | Company Code of Target Position | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | JBBUKRSZ | Allow NULL? |
| 8 | RLDEPO | Source Securities Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | JBDEPOQ | Allow NULL? |
| 9 | REFRLDEPO | Target Securities Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | JBDEPOZ | Allow NULL? |
| 10 | RANL | Source Security ID Number | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | * | JBRANLQ | Allow NULL? |
| 11 | REFRANL | Target Securities ID Number | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | * | JBRANLZ | Allow NULL? |
| 12 | ZAEHLER | Numerator in Split, Swap and Booking Relationship | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | JBTZAEHLER | Allow NULL? |
| 13 | NENNER | Denominator in Split, Swap and Booking Relationship | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | JBTNENNER | Allow NULL? |
| 14 | DERFAS | Created on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | JBDERFAS | Allow NULL? |
| 15 | TERFAS | Time of entry | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | JBTERFAS | Allow NULL? |
| 16 | SSTORNO | Reversal Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | JBSTORNO | Allow NULL? |
| 17 | DATBAEN | Date of Position Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | JBDATBAEN | Allow NULL? |
| 18 | TIMBAEN | Exact Time of Position Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | JBTIMBAEN | Allow NULL? |