| 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 | DOCUMENT_GUID | Object Identity in Database Format | nvarchar | 32 | 0 | CHAR | (N' ') | No | TRACT_DOCUMENT | TPM_DB_OS_GUID | Allow NULL? |
| 3 | ITEM_NUMBER | Accounting Document Line Item Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | POSNR_ACC | Allow NULL? |
| 4 | PC_GUID | Object Identity in Database Format | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | TRACT_POSCONTEXT | TPM_DB_OS_GUID | Allow NULL? |
| 5 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TRDC_DFLOWTYPE | TPM_DIS_FLOWTYPE | Allow NULL? |
| 6 | SZART | Payment Transaction | char | 1 | 0 | CHAR | (N' ') | Yes | | TPM_SZART | Allow NULL? |
| 7 | AA_REF | Account Assignment Reference of Position Management | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | TPM_AA_REF | Allow NULL? |
| 8 | ACC_SYMBOL | Account Symbol for Account Assignment Reference | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | TRAC_ACCSYMB | TPM_ACC_SYMBOL | Allow NULL? |
| 9 | POSTING_CAT | Posting Category | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | TPM_POSTING_CAT | |
| 10 | POSTING_KEY | Posting Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BSCHL | Allow NULL? |
| 11 | GL_ACCOUNT | G/L Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SAKNR | Allow NULL? |
| 12 | POSITION_AMT | Amount in Transaction Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_FOREIGN_AMT | |
| 13 | POSITION_CURR | Transaction Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TPM_FOREIGN_CURR | Allow NULL? |
| 14 | LOCAL_AMT | Amount (Local Currency) | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_LOCAL_AMT | |
| 15 | LOCAL_CURR | Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TPM_LOCAL_CURR | Allow NULL? |
| 16 | TRDFLOWNR | Number of a Distributor Flow | int | 10 | 0 | INT4 | ((0)) | Yes | | TPM_TRDFLOWNR | Allow NULL? |
| 17 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
| 18 | REVERSAL_BELNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
| 19 | BUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | BUZEI | Allow NULL? |
| 20 | LOGVO | Logical Transaction | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | LOGVO | Allow NULL? |
| 21 | BLART | Document Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BLART | Allow NULL? |
| 22 | PAYMENT_DATE | Payment Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TPM_PAYMENT_DATE | Allow NULL? |
| 23 | KUNNR | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNNR | Allow NULL? |
| 24 | ZTERM | Terms of Payment Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DZTERM | Allow NULL? |
| 25 | ZLSCH | Payment Method | char | 1 | 0 | CHAR | (N' ') | Yes | * | DZLSCH | Allow NULL? |
| 26 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | UZAWE | Allow NULL? |
| 27 | ZLSPR | Payment Block Key | char | 1 | 0 | CHAR | (N' ') | Yes | * | DZLSPR | Allow NULL? |
| 28 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TB_RPZAHL_NEW | Allow NULL? |
| 29 | RPBANK | Partner bank details | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | TB_RPBANK | Allow NULL? |
| 30 | HOUSE_BANK | Short key for own house bank | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | TB_RHABKI | Allow NULL? |
| 31 | HOUSE_BANK_ACC | Short key for house bank account | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | TB_RHKTID | Allow NULL? |
| 32 | SIGN | Direction of flow | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SSIGN | Allow NULL? |
| 33 | LZBKZ | State Central Bank Indicator | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LZBKZ | Allow NULL? |
| 34 | LANDL | Supplying Country | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LANDL | Allow NULL? |
| 35 | ALLOCNR | Assignment Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | DZUONR | Allow NULL? |
| 36 | SGTXT | Item Text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | SGTXT | Allow NULL? |
| 37 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
| 38 | KOSTL | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KOSTL | Allow NULL? |
| 39 | RMVCT | Transaction Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | RMVCT | Allow NULL? |
| 40 | VBUND | Company ID | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | VBUND | Allow NULL? |
| 41 | KONTRAHENT | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TB_KUNNR_NEW | Allow NULL? |
| 42 | ISSUER | Issuer Identity Key | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | REPKE_NEW | Allow NULL? |
| 43 | SUB_FLOW_NUMBER | Number of a Distributor Flow | int | 10 | 0 | INT4 | ((0)) | Yes | | TPM_TRDFLOWNR | Allow NULL? |
| 44 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | SEPA_MNDID | Allow NULL? |
