| 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 | T000 | MANDT | Allow NULL? |
| 2 | BKKRS | Bank Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | TBKK01 | BKK_BKKRS | Allow NULL? |
| 3 | DOCNO_TMP | Document Number for Planned Payment Items | nvarchar | 12 | 0 | NUMC | (N'000000000000') | No | * | BKK_DOCNOTMP | Allow NULL? |
| 4 | POSNO | Position in Item | nvarchar | 3 | 0 | NUMC | (N'000') | No | | BKK_POSNO | Allow NULL? |
| 5 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | * | BKK_DOCNO | Allow NULL? |
| 6 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BKK_ACCNT | Allow NULL? |
| 7 | BANKS | Bank country key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | BANKS | Allow NULL? |
| 8 | BANKL | Bank Keys | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | BANKK | Allow NULL? |
| 9 | SWIFT | SWIFT/BIC for International Payments | nvarchar | 11 | 0 | CHAR | (N' ') | Yes | | SWIFT | Allow NULL? |
| 10 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BKK_ACEXT | Allow NULL? |
| 11 | BKS | Bank Control Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKK_BKS | Allow NULL? |
| 12 | ACNUM_IBAN | International Bank Account Number | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BKK_ACIBAN | Allow NULL? |
| 13 | ALT_ACEXT | Original Account Number | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BKK_ALTACE | Allow NULL? |
| 14 | ALT_IBAN | Original IBAN | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BKK_ALTIBA | Allow NULL? |
| 15 | BUPA_NO | Business Partner Account Holder | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BKK_ACHOLD | Allow NULL? |
| 16 | BUPA_NAME | Account holder name | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | BKK_NAME | Allow NULL? |
| 17 | REFNO_CR | Reference Number of Creation | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BKK_CRNO | Allow NULL? |
| 18 | REFNO_PAYM | Reference Number from Payment Transactions | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BKK_PAYMNO | Allow NULL? |
| 19 | REFNO_PN | Daybook number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BKK_PNNO | Allow NULL? |
| 20 | DATE_CR | Creation Date of the Data Medium | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_CRDATD | Allow NULL? |
| 21 | DATE_VALUE | Value date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_VALDAT | Allow NULL? |
| 22 | DATE_POST | Posting date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_PSTDAT | Allow NULL? |
| 23 | DATE_COL | Date of Subject to Final Payment Balance | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_CDATE | Allow NULL? |
| 24 | TCUR | Transaction Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | BKK_TCUR | Allow NULL? |
| 25 | T_AMOUNT | Amount in Transaction Currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | BKK_TAMNT | |
| 26 | T_CHARGE | Charge in Transaction Currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | BKK_TCHARG | |
| 27 | NACUR | Reporting Account Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | BKK_NACUR | Allow NULL? |
| 28 | NA_AMOUNT | Amount in Information Account Currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | BKK_NAAMNT | |
| 29 | NA_CHARGE | Charge in Reporting Currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | BKK_NACHARG | |
| 30 | ACUR | Account Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | BKK_ACUR | Allow NULL? |
| 31 | A_AMOUNT | Amount in Account Currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | BKK_AAMNT | |
| 32 | A_CHARGE | Charge in Account Currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | BKK_ACHARG | |
| 33 | EXCHNGRATE | Exchange Rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | BKK_EXRATE | |
| 34 | MEDIUM | Medium | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TBKKG1 | BKK_MEDIUM | Allow NULL? |
| 35 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BKK_PAYMET | Allow NULL? |
| 36 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TBKKG3 | BKK_TTYPE | Allow NULL? |
| 37 | S_TRNSTYPE | Source Transaction Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BKK_STTYPE | Allow NULL? |
| 38 | RETURNK | Return Reason | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | BKK_RKEY | Allow NULL? |
| 39 | COUNTRY | Country | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | BKK_CNTRY | Allow NULL? |
| 40 | X_ACTCHK_E | Indicator: Error in Check Digits for Account | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_ACTCHK | Allow NULL? |
| 41 | CHEQUE_TYP | Means of Payment Position Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BKK_CASHBT | Allow NULL? |
| 42 | CHEQUE_NO | Check Number (External) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BKK_CHEQEX | Allow NULL? |
| 43 | ITEMCNT | Number of Processed Items | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | BKK_ITCNT | Allow NULL? |
| 44 | BUTXT | Posting Text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | BKK_BUTXT | Allow NULL? |
| 45 | REMARK | Comment on Order/Item | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | BKK_REMARK | Allow NULL? |
| 46 | ITEMTYPE | Type of Payment Item | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKK_ITTYPE | Allow NULL? |
| 47 | PROCESS | Processes in BCA | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TBKKIPROC | BKK_PROCSS | Allow NULL? |
| 48 | ITEMSTATUS | Status of Payment Item | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKK_ITSTAT | Allow NULL? |
| 49 | REF_ACEXT | Reference Account Number | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BKK_REFACN | Allow NULL? |
| 50 | REF_BKS | Bank Control Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKK_BKS | Allow NULL? |
| 51 | REF_IBAN | Reference IBAN | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BKK_REFIBA | Allow NULL? |
| 52 | REF_NAME | Reference Name of Account Holder | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | BKK_REFNAM | Allow NULL? |
| 53 | REF_BANKS | Reference Country Key of Bank | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | BKK_REFBKS | Allow NULL? |
| 54 | REF_BANKL | Reference Bank Key | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | BKK_REFBKL | Allow NULL? |
| 55 | REF_SWIFT | SWIFT/BIC for International Payments | nvarchar | 11 | 0 | CHAR | (N' ') | Yes | | SWIFT | Allow NULL? |
| 56 | XNOGLITEM | Indicator: No Update in General Ledger | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XGLITM | Allow NULL? |
| 57 | XVALDATSET | Indicator: Value Date was Specified | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_VDTSET | Allow NULL? |
| 58 | XPOSTPRIOR | Indicator: Posting to prior period | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_PSTPRI | Allow NULL? |
| 59 | XPRI_PPROC | Indicator: Priority in Postprocessing | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XPRIPP | Allow NULL? |
| 60 | XREVERSE | Indicator: Reversal Item | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XREV | Allow NULL? |
| 61 | REVERSE_NO | Reversal no. | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | * | BKK_REVNO | Allow NULL? |
| 62 | REVERSE_PS | Reversal Item | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | BKK_REVPOS | Allow NULL? |
| 63 | TRNSF_BK_B | Reference Bank Area from Transfer Posting (Orig. Docu.) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BKK_TRFBKB | Allow NULL? |
| 64 | TRNSF_NO_B | Reference Document Number from Transfer Posting (Source Doc) | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | * | BKK_TRFDCB | Allow NULL? |
| 65 | TRNSF_PS_B | Reference Position Number from Trans.Posting (Orig.Document) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | BKK_TRFPSB | Allow NULL? |
| 66 | TRNSF_BK_F | Reference Bank Area from Transfer Posting | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BKK_TRFBKF | Allow NULL? |
| 67 | TRNSF_NO_F | Reference Document Number from Transfer Posting | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | * | BKK_TRFDCF | Allow NULL? |
| 68 | TRNSF_PS_F | Reference Position Number from Transfer Posting | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | BKK_TRFPSF | Allow NULL? |
| 69 | REF_PO_BK | Reference Field: Bank Area Generating Payment Order | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BKK_REFPOB | Allow NULL? |
| 70 | REF_PO_NO | Reference Field: Number Generating Payment Order | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | | BKK_REFPOD | Allow NULL? |
| 71 | REF_PO_PS | Reference Field: Position Generating Payment Order | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | BKK_REFPOP | Allow NULL? |
| 72 | XCHK_CHQUE | Indicator: Check for the Check (Cheque) Switched Off? | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XCHKCH | Allow NULL? |
| 73 | XCHK_VALUE | Indicator, value date check exluded? | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XCHKV | Allow NULL? |
| 74 | XCHK_LIMIT | Indicator, limit check excluded? | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XCHKL | Allow NULL? |
| 75 | XCHK_ACLCK | Indicator, account block check excluded? | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XCHKAC | Allow NULL? |
| 76 | XCHK_BPLCK | Indicator, business partner check excluded? | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XCHKBP | Allow NULL? |
| 77 | XCHK_MANDATE | Exclude Mandate Check | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_FLG_EXC_MND_CHK | Allow NULL? |
| 78 | XCHK_PRENOTE | Exclude Prenote Check | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_FLG_EXC_PRENOTE_CHK | Allow NULL? |
| 79 | XCHK_EXTD_MND | Indicator: Extended Mandate Check Excluded? | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_FLG_EXC_EXTD_MND_CHK | Allow NULL? |
| 80 | XERR_SYST | Indicator, error Customizing/master data? | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XSYSRT | Allow NULL? |
| 81 | XERR_ENQUE | Indicator, error in blocking account balance? | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XENQRT | Allow NULL? |
| 82 | XERR_CHQUE | Indicator, error in position management check? | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XCHQRT | Allow NULL? |
| 83 | XERR_VALUE | Indicator, error in value date check? | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XVALRT | Allow NULL? |
| 84 | XERR_LIMIT | Indicator, error in limit check? | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XLIMRT | Allow NULL? |
| 85 | XERR_ACLCK | Indicator, error in account check? | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XACCRT | Allow NULL? |
| 86 | XERR_BPLCK | Indicator, error in business partner check? | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XBUPRT | Allow NULL? |
| 87 | XERR_CUREX | Indicator, error due to block/currency changeover? | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XCURRT | Allow NULL? |
| 88 | XERR_PSTFU | Indicator - Posting Date is in the Future | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XPFURT | Allow NULL? |
| 89 | XERR_MANDATE | Error in Mandate Lock Check | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_FLG_MND_IND | Allow NULL? |
| 90 | XERR_PRENOTE | Error in Prenote Check | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_FLG_PRENOTE_IND | Allow NULL? |
| 91 | XERR_EXTD_MND | Indicator - Error in Extended Mandate Checks | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_FLG_ERR_EXTD_MND | Allow NULL? |
| 92 | CRUSR | User who created the object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BKK_CRUSR | Allow NULL? |
| 93 | CRDAT | Date on which the object was created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_CRDAT | Allow NULL? |
| 94 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BKK_CRTIM | Allow NULL? |
| 95 | CHUSR | Last user to change object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BKK_CHUSR | Allow NULL? |
| 96 | CHDAT | Date on which the object was last changed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_CHDAT | Allow NULL? |
| 97 | CHTIM | Time at Which Object was Last Changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BKK_CHTIM | Allow NULL? |
| 98 | RLUSR | User who released object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BKK_RLUSR | Allow NULL? |
| 99 | RLDAT | Date on which object was released | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_RLDAT | Allow NULL? |
| 100 | RLTIM | Time at Which Object Was Released | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BKK_RLTIM | Allow NULL? |
| 101 | PUBLIC_CONT_L1 | Public Field Length 35 | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BCA_DTE_CHAR035 | Allow NULL? |
| 102 | PUBLIC_CONT_L2 | Public Field Length 35 | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BCA_DTE_CHAR035 | Allow NULL? |
| 103 | PUBLIC_CONT_L3 | Public Field Length 35 | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BCA_DTE_CHAR035 | Allow NULL? |
| 104 | PUBLIC_CONT_L4 | Public Field Length 35 | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BCA_DTE_CHAR035 | Allow NULL? |
| 105 | PUBLIC_CONT_S1 | Public Field Length 20 | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BCA_DTE_CHAR020 | Allow NULL? |
| 106 | PUBLIC_CONT_S2 | Public Field Length 20 | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BCA_DTE_CHAR020 | Allow NULL? |
| 107 | PRENOTE_REF_NO | Prenote Reference ID | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_PRENOTE_REF_ID | Allow NULL? |
| 108 | DATE_DUE | Due Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_DTE_DATE_DUE | Allow NULL? |
| 109 | UCI | Creditor Identification | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_CRD_ID | Allow NULL? |
| 110 | MANDATE_ID | Mandate Reference | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_MND_ID | Allow NULL? |
| 111 | RECONC_SYSTEM | Identification of Supplying System | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_SYST_FROM | Allow NULL? |
| 112 | RECONC_APPL | Reconciliation - Supplying Application ID | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_APPL_FROM | Allow NULL? |
| 113 | RECONC_NO | Reconciliation Unit - Additional ID | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_RECONC_NO | Allow NULL? |
| 114 | ITEMCNT8 | Extended Number of Processed Items | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | BKK_ITCNT8 | Allow NULL? |
| 115 | XNO_DEL | Indicator: External Sender/Turnover Item May not Be Deleted | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XNODEL | Allow NULL? |
| 116 | NTCUR | Reporting Transaction Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | BKK_NTCUR | Allow NULL? |
| 117 | NT_AMOUNT | Amount in Reporting Transaction Currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | BKK_NTAMNT | |
| 118 | NT_CHARGE | Charge in Reporting Transaction Currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | BKK_NTCHARG | |
| 119 | TAX_YEAR | Tax-year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | RTP_US_TAXYEAR | Allow NULL? |
| 120 | AMOUNT_ID | Amount identifier code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | RTP_US_AMN_ID | Allow NULL? |
| 121 | CONTRIB_ID | Contribution identifier | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | RTP_US_CON_ID | Allow NULL? |
| 122 | IRS_DCODE | Retirement plan distribution code | char | 1 | 0 | CHAR | (N' ') | Yes | | RTP_US_IRS | Allow NULL? |
| 123 | IRS_SCODE | Retirement plan distribution sub-code | char | 1 | 0 | CHAR | (N' ') | Yes | | RTP_US_IRS_SUB | Allow NULL? |
| 124 | WH_AMOUNT_TOTAL | Total fed withholding amount for IRA distribution payment | decimal | 17 | 2 | CURR | ((0)) | Yes | | RTP_US_WH_AMOUNT_TOTAL | |
| 125 | XMEMO_ITEM | Items are memo items | char | 1 | 0 | CHAR | (N' ') | Yes | | BCA_US_XMEMO | Allow NULL? |
