| 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 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 3 | RFHA | Financial Transaction | nvarchar | 13 | 0 | CHAR | (N' ') | No | * | TB_RFHA | Allow NULL? |
| 4 | DZTERM | Payment or Delivery Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | TB_DZTERM | Allow NULL? |
| 5 | TYPE | Type of tax | nvarchar | 5 | 0 | CHAR | (N' ') | No | | IDCFMBR_TAXTYPE | Allow NULL? |
| 6 | PC_RFHA | Financial Transaction | nvarchar | 13 | 0 | CHAR | (N' ') | No | * | TB_RFHA | Allow NULL? |
| 7 | BUPRC | Closing/Sale Price for Position | decimal | 15 | 6 | DEC | ((0)) | Yes | | IDCFMCLPRICE | |
| 8 | PERCENT | Percentage Rate to Determine Derived Amount | decimal | 10 | 7 | DEC | ((0)) | Yes | | TB_PABSATZ | |
| 9 | BZBETR | Amount that Changes the Position | decimal | 13 | 2 | CURR | ((0)) | Yes | | TB_BBBETR | |
| 10 | ASTUECK | Number of reference securities | decimal | 15 | 5 | DEC | ((0)) | Yes | | REFASTUECK | |
| 11 | BAL_QTY | Total position available | decimal | 15 | 5 | DEC | ((0)) | Yes | | VVAGESVERF | |
| 12 | BAL_AMT | Currency amount | decimal | 31 | 2 | CURR | ((0)) | Yes | | SRMCURR | |
| 13 | T_RESULT | Amount (Position Currency) | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_POSITION_AMT | |
| 14 | PROV_IRRF | Payment amount in payment currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | TB_BZBETR | |
| 15 | ADJ_IRRF | Adjustment IRRF Accrual | decimal | 13 | 2 | CURR | ((0)) | Yes | | IDCFMBRSETX_ADJ | |
| 16 | SGSART | Product Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | VVSART | Allow NULL? |
| 17 | RANL | Security ID Number | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | * | VVRANLW | Allow NULL? |
| 18 | RLDEPO | Securities Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | RLDEPO | Allow NULL? |
| 19 | WBBETR | Currency of Position Amount | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TB_WBBETR | Allow NULL? |
| 20 | AA_REF | Account Assignment Reference of Position Management | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | TPM_AA_REF | Allow NULL? |
| 21 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
| 22 | KOSTL | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KOSTL | Allow NULL? |
| 23 | TEXT | Log message from external program | nvarchar | 128 | 0 | CHAR | (N' ') | Yes | | BTCXPGMSG | Allow NULL? |
| 24 | RVRS | Reversal indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SSTORNO | Allow NULL? |
| 25 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
| 26 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 27 | REV_BELNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
| 28 | REV_BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 29 | TAX_RFHA | Financial Transaction | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | * | TB_RFHA | Allow NULL? |
| 30 | REV_REASON | Reason for Reversal | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | IDCFM_REVREASON | Allow NULL? |
