| 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 | BKKRS | Bank Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BKK_BKKRS | Allow NULL? |
| 3 | PAORN | Payment order number | nvarchar | 12 | 0 | NUMC | (N'000000000000') | No | | BKK_PAORN | Allow NULL? |
| 4 | POSNO | Item in Payment Order | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | BKK_POPOS | Allow NULL? |
| 5 | BKKRS_ITEM | Bank Area Items in Payment Order | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BKK_BKKRSI | 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 | * | 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 | BUPA_NO | Business Partner Account Holder | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BKK_ACHOLD | Allow NULL? |
| 14 | BUPA_NAME | Account holder name | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | BKK_NAME | Allow NULL? |
| 15 | X_ACTCHK_E | Indicator: Error in Check Digits for Account | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_ACTCHK | Allow NULL? |
| 16 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TBKKG3 | BKK_TTYPE | Allow NULL? |
| 17 | MEDIUM | Medium | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TBKKG1 | BKK_MEDIUM | Allow NULL? |
| 18 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BKK_PAYMET | Allow NULL? |
| 19 | BUTXT | Posting Text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | BKK_BUTXT | Allow NULL? |
| 20 | DATE_VALUE | Value date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_VALDAT | Allow NULL? |
| 21 | XVALDATSET | Indicator: Value Date was Specified | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_VDTSET | Allow NULL? |
| 22 | TCUR | Transaction Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | BKK_TCUR | Allow NULL? |
| 23 | T_AMOUNT | Amount in Transaction Currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | BKK_TAMNT | |
| 24 | T_CHARGE | Charge in Transaction Currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | BKK_TCHARG | |
| 25 | NACUR | Reporting Account Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | BKK_NACUR | Allow NULL? |
| 26 | NA_AMOUNT | Amount in Information Account Currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | BKK_NAAMNT | |
| 27 | NA_CHARGE | Charge in Reporting Currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | BKK_NACHARG | |
| 28 | ACUR | Account Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | BKK_ACUR | Allow NULL? |
| 29 | A_AMOUNT | Amount in Account Currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | BKK_AAMNT | |
| 30 | A_CHARGE | Charge in Account Currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | BKK_ACHARG | |
| 31 | EXCHNGRATE | Exchange Rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | BKK_EXRATE | |
| 32 | CHEQUE_TYP | Means of Payment Position Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BKK_CASHBT | Allow NULL? |
| 33 | CHEQUE_NO | Check Number (External) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BKK_CHEQEX | Allow NULL? |
| 34 | XCHK_CHQUE | Indicator: Check for the Check (Cheque) Switched Off? | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XCHKCH | Allow NULL? |
| 35 | XCHK_VALUE | Indicator, value date check exluded? | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XCHKV | Allow NULL? |
| 36 | XCHK_LIMIT | Indicator, limit check excluded? | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XCHKL | Allow NULL? |
| 37 | XCHK_ACLCK | Indicator, account block check excluded? | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XCHKAC | Allow NULL? |
| 38 | XCHK_BPLCK | Indicator, business partner check excluded? | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XCHKBP | Allow NULL? |
| 39 | XCHK_MANDATE | Exclude Mandate Check | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_FLG_EXC_MND_CHK | Allow NULL? |
| 40 | XCHK_PRENOTE | Exclude Prenote Check | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_FLG_EXC_PRENOTE_CHK | Allow NULL? |
| 41 | XCHK_EXTD_MND | Indicator: Extended Mandate Check Excluded? | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_FLG_EXC_EXTD_MND_CHK | Allow NULL? |
| 42 | PUBLIC_CONT_L1 | Public Field Length 35 | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BCA_DTE_CHAR035 | Allow NULL? |
| 43 | PUBLIC_CONT_L2 | Public Field Length 35 | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BCA_DTE_CHAR035 | Allow NULL? |
| 44 | PUBLIC_CONT_L3 | Public Field Length 35 | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BCA_DTE_CHAR035 | Allow NULL? |
| 45 | PUBLIC_CONT_L4 | Public Field Length 35 | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BCA_DTE_CHAR035 | Allow NULL? |
| 46 | PUBLIC_CONT_S1 | Public Field Length 20 | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BCA_DTE_CHAR020 | Allow NULL? |
| 47 | PUBLIC_CONT_S2 | Public Field Length 20 | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BCA_DTE_CHAR020 | Allow NULL? |
| 48 | MANDATE_ID | Mandate Reference | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_MND_ID | Allow NULL? |
| 49 | UCI | Creditor Identification | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_CRD_ID | Allow NULL? |
| 50 | PRENOTE_REF_NO | Prenote Reference ID | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_PRENOTE_REF_ID | Allow NULL? |
| 51 | PO_MGUID | SEPA Mandate: GUID of Mandate | varbinary | 16 | 0 | RAW | | Yes | | SEPA_MGUID | |
| 52 | PO_MVERS | Version of Mandate used for Enrichment | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | BKK_DTE_MANDATE_ENRICH_VERSION | Allow NULL? |
| 53 | RECONC_SYSTEM | Identification of Supplying System | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_SYST_FROM | Allow NULL? |
| 54 | RECONC_APPL | Reconciliation - Supplying Application ID | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_APPL_FROM | Allow NULL? |
| 55 | RECONC_NO | Reconciliation Unit - Additional ID | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | BKK_DTE_RECONC_NO | Allow NULL? |
| 56 | TAX_YEAR | Tax-year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | RTP_US_TAXYEAR | Allow NULL? |
| 57 | AMOUNT_ID | Amount identifier code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | RTP_US_AMN_ID | Allow NULL? |
| 58 | CONTRIB_ID | Contribution identifier | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | RTP_US_CON_ID | Allow NULL? |
| 59 | IRS_DCODE | Retirement plan distribution code | char | 1 | 0 | CHAR | (N' ') | Yes | | RTP_US_IRS | Allow NULL? |
| 60 | IRS_SCODE | Retirement plan distribution sub-code | char | 1 | 0 | CHAR | (N' ') | Yes | | RTP_US_IRS_SUB | Allow NULL? |
| 61 | WH_AMOUNT_TOTAL | Total fed withholding amount for IRA distribution payment | decimal | 17 | 2 | CURR | ((0)) | Yes | | RTP_US_WH_AMOUNT_TOTAL | |
| 62 | XMEMO_ITEM | Items are memo items | char | 1 | 0 | CHAR | (N' ') | Yes | | BCA_US_XMEMO | Allow NULL? |
| 63 | REBOOK | Payment Items Were Transfer Posted | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_REBOOK | Allow NULL? |
| 64 | AI_POST | Posting Decision: Interest Penalty | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_AI_POST | Allow NULL? |
| 65 | REF_ACEXT | Reference Account Number | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BKK_REFACN | Allow NULL? |
| 66 | REF_IBAN | Reference IBAN | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BKK_REFIBA | Allow NULL? |
| 67 | REF_NAME | Reference Name of Account Holder | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | BKK_REFNAM | Allow NULL? |
| 68 | REF_BANKS | Reference Country Key of Bank | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | BKK_REFBKS | Allow NULL? |
| 69 | REF_BANKL | Reference Bank Key | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | BKK_REFBKL | Allow NULL? |
| 70 | REF_SWIFT | Reference SWIFT Code | nvarchar | 11 | 0 | CHAR | (N' ') | Yes | | BKK_REFSWIFT | Allow NULL? |
