| 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 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | | BKK_TTYPE | Allow NULL? |
| 3 | XINPMNT | Transaction Type Initiates a Credit | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_INPMNT | Allow NULL? |
| 4 | XCHK_BUPA | Business Partner Check | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_CHKBUP | Allow NULL? |
| 5 | XCHK_ACCNT | Account Check | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_CHKACC | Allow NULL? |
| 6 | XCHK_VALUE | Indicator: Process Checks for Value Date? | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_CHKVAL | Allow NULL? |
| 7 | XCHK_LIMIT | Limit Checks | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_CHKLIM | Allow NULL? |
| 8 | XCHEQUE | Indicator: Check with Check Management | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XCHEQ | Allow NULL? |
| 9 | CASHB_TYPE | Means of Payment Position Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TBKKA1 | BKK_CASHBT | Allow NULL? |
| 10 | XDIRDEB | Check if Direct Debit Order Available | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_DIRDEB | Allow NULL? |
| 11 | XCOLAUTH | Check for Collection Authorization Agreement | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_COLAUT | Allow NULL? |
| 12 | XSUBTOCOL | Indicator: Subject to Final Payment (S.F.P.) | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_SUBCOL | Allow NULL? |
| 13 | VALUE_REQ | Indicator: Value Date Specification Allowed | char | 1 | 0 | NUMC | (N'0') | Yes | | BKK_VALREQ | Allow NULL? |
| 14 | XMORE_RCV | Indicator: Several Recipients Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XMRCV | Allow NULL? |
| 15 | XPAYM_NOTE | Indicator: Display Payment Notes | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XPAYNTE | Allow NULL? |
| 16 | XPRI_PPROC | Indicator: Priority in Postprocessing | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XPRIPP | Allow NULL? |
| 17 | XREVERSAL | Indicator: Reversing Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XREVER | Allow NULL? |
| 18 | XNAMECHECK | Account Call-Up Check | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XNAMECHECK | Allow NULL? |
| 19 | XDIA_POC | Indicator: Online Entry Internal Order Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XDIAPC | Allow NULL? |
| 20 | XDIA_POR | Indicator: Online Entry Return Order Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XDIAPR | Allow NULL? |
| 21 | XDIA_POF | Indicator: Online Entry Foreign Payment Order Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XDIAPF | Allow NULL? |
| 22 | XDIALOG_PO | Indicator: Online Entry External Payment Order Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XDIAPO | Allow NULL? |
| 23 | XDIALOG_PI | Indicator: Online Entry Payment Item Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XDIAPI | Allow NULL? |
| 24 | XDIA_SO | Online Entry Standing Order | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_DIASO | Allow NULL? |
| 25 | XSUPPRS_REFACC | Indicator: Suppress Ref. Bank Statement on Bank Statement | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XSUPPREF | Allow NULL? |
| 26 | XERR_MANDATE | Mandate Check | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_FLG_MND_CHK | Allow NULL? |
| 27 | XCHK_EXTD_MND | Indicator: Execute Extended Mandate Checks | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_FLG_CHK_EXTD_MND | Allow NULL? |
| 28 | XCHK_PRENOTE | Prenote Check | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_FLG_PRENOTE_CHK | Allow NULL? |
| 29 | XNO_DEL | Indicator: External Sender/Turnover Item May not Be Deleted | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XNODEL | Allow NULL? |
| 30 | XMEMO_ITEM | Items are memo items | char | 1 | 0 | CHAR | (N' ') | Yes | | BCA_US_XMEMO | Allow NULL? |
| 31 | XESCHEAT | Indicator: Internal Transaction | char | 1 | 0 | CHAR | (N' ') | Yes | | BCA_US_XESCHEAT | Allow NULL? |
| 32 | XAIREL | Interest Penalty Calculation | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_AI_REL | Allow NULL? |
| 33 | XBLNOT | Operation Relevant to Notice Period Lock | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_BL_NO | Allow NULL? |
| 34 | XFXNET | Indicator: Foreign exchange netting enabled | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XFXNET | Allow NULL? |
