| 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 | ZNB_KEY | Business Operation Number (Loans) | nvarchar | 15 | 0 | CHAR | (N' ') | No | | RBO | Allow NULL? |
| 3 | LFDNR | Sequence Number | nvarchar | 3 | 0 | CHAR | (N' ') | No | | LFDNR | Allow NULL? |
| 4 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 5 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
| 6 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 7 | BUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | BUZEI | Allow NULL? |
| 8 | TCODE | Transaction Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | TCODE_BKPF | Allow NULL? |
| 9 | VALUT | Value date of the item to be cleared | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VALUT_EB | Allow NULL? |
| 10 | AZIDT | Bank statement identification | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | AZIDT_EB | Allow NULL? |
| 11 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | KUKEY_EB | Allow NULL? |
| 12 | ESNUM | Memo record number (line item number in bank statement) | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | ESNUM_EB | Allow NULL? |
| 13 | LAUFI | Additional Identification | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | LAUFI | Allow NULL? |
| 14 | LAUFD | Date on Which the Program Is to Be Run | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LAUFD | Allow NULL? |
| 15 | KUNNR | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNNR | Allow NULL? |
| 16 | PARTN | Business Partner | nvarchar | 55 | 0 | CHAR | (N' ') | Yes | | PARTN_EB | Allow NULL? |
| 17 | WRBTR | Foreign currency amount (different from account cuurency) | decimal | 13 | 2 | CURR | ((0)) | Yes | | FWBTR_EB | |
| 18 | WAERS | Foreign currency key (unequal to account currency) | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FWAER_EB | Allow NULL? |
| 19 | DMBTR | Amount in account currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | KWBTR_EB | |
| 20 | HWAER | Account Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | KWAER_EB | Allow NULL? |
| 21 | HBBLZ | Bank number of our bank | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | UBNKL | Allow NULL? |
| 22 | HBLD1 | Bank country key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | BANKS | Allow NULL? |
| 23 | KTONR | Bank account number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | KTONR_EB | Allow NULL? |
| 24 | KTOIH | Bank account holder | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | KTOIH_EB | Allow NULL? |
| 25 | AZDAT | Statement Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AZDAT_EB | Allow NULL? |
| 26 | AZNUM | Statement number | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | AZNUM_EB | Allow NULL? |
| 27 | EFART | Input Type | char | 1 | 0 | CHAR | (N' ') | Yes | | EFART_EB | Allow NULL? |
| 28 | BUDAT | Posting date in the document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT_EB | Allow NULL? |
| 29 | VGINT | Posting rule | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VGINT_EB | Allow NULL? |
| 30 | BUTXT | Bank posting text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | BUTXT_EB | Allow NULL? |
| 31 | PABKS | Country key of partner bank | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | PABKS_EB | Allow NULL? |
| 32 | PABLZ | Bank number of partner bank | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | PABLZ_EB | Allow NULL? |
| 33 | PAKTO | Account number at the partner bank | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | PAKTO_EB | Allow NULL? |
| 34 | RZAWE | Payment Method for This Payment | char | 1 | 0 | CHAR | (N' ') | Yes | * | RZAWE | Allow NULL? |
| 35 | TXTVV | Financial Assets Management Information Field | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | TXTVV_EB | Allow NULL? |
| 36 | INFO1 | Additional information 1 | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | INFO1_EB | Allow NULL? |
| 37 | INFO2 | Additional information 2 | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | INFO2_EB | Allow NULL? |
| 38 | VERTT | Contract Number | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | RANL | Allow NULL? |
| 39 | VERTN | Contract Type | char | 1 | 0 | CHAR | (N' ') | Yes | | RANTYP | Allow NULL? |
| 40 | FEBREIDX | Row Index of Internal Tables | int | 10 | 0 | INT4 | ((0)) | Yes | | SYTABIX | Allow NULL? |
| 41 | VWEZW1 | Character field with length 27 | nvarchar | 27 | 0 | CHAR | (N' ') | Yes | | CHAR27 | Allow NULL? |
| 42 | VWEZW2 | Character field with length 27 | nvarchar | 27 | 0 | CHAR | (N' ') | Yes | | CHAR27 | Allow NULL? |
