| 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 | PDKEY | Number of Payment Specification | nvarchar | 12 | 0 | NUMC | (N'000000000000') | No | | PDKEY_KK | Allow NULL? |
| 3 | PDTYP | Category of Payment Specification | char | 1 | 0 | CHAR | (N' ') | Yes | | PDTYP_KK | Allow NULL? |
| 4 | GPARV | Business Partner Acting as Payer in Payment Transactions | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | GPARV_KK | Allow NULL? |
| 5 | VKONV | Contract account used for payment transactions | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | VKONV_IP | Allow NULL? |
| 6 | PDREF | Reference Number of Payment Specification | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | PDREF_KK | Allow NULL? |
| 7 | EIGBV | Own Bank Details | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | * | EIGBV_KK | Allow NULL? |
| 8 | PYMET | Payment Method | char | 1 | 0 | CHAR | (N' ') | Yes | TFK042Z | PYMET_KK | Allow NULL? |
| 9 | BKVID | Bank details ID | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BU_BKVID | Allow NULL? |
| 10 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | SEPA_MNDID | Allow NULL? |
| 11 | CCARD_ID | Payment Card ID | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | BU_CCID | Allow NULL? |
| 12 | PYBUK | Company Code for Automatic Payment Transactions | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PYBUK_KK | Allow NULL? |
| 13 | BETRW | Payment Amount of Payment Specification | decimal | 13 | 2 | CURR | ((0)) | Yes | | BETRW_INDPAY | |
| 14 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 15 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 16 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 17 | ERTIM | Time of Entry | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CPUTM | Allow NULL? |
| 18 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 19 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 20 | AETIM | Time of Entry | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CPUTM | Allow NULL? |
| 21 | DOC1T | Payment Document Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | DOC1T_KK | Allow NULL? |
| 22 | DOC1R | Reference to Payment Document | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | DOC1R_KK | Allow NULL? |
| 23 | LAUFD | Date ID | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LAUFD_KK | Allow NULL? |
| 24 | LAUFI | Identification for the payment run | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | LAUFI_PAY | Allow NULL? |
| 25 | C4EYE | Check Reason for Workflows Acc. to Dual Control Principle | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | C4EYE_KK | Allow NULL? |
| 26 | DTAWS | Instruction key for data medium exchange | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | DTAWS | Allow NULL? |
| 27 | DTAMS | Indicator for Data Medium Exchange | char | 1 | 0 | CHAR | (N' ') | Yes | | DTAMS | Allow NULL? |
| 28 | TXTSL | Text key for the code line on the form | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | TXTSL_042Z | Allow NULL? |
| 29 | TXERG | Text key supplement | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | TXERG | Allow NULL? |
| 30 | STAIP | Payment Specification: Status | char | 1 | 0 | CHAR | (N' ') | Yes | | STAIP_KK | Allow NULL? |
| 31 | AUSFD | Payment Specification: Execution Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AUSFD_INDPAY | Allow NULL? |
| 32 | PYTXT | Text for Payment | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | PYTXT_KK | Allow NULL? |
| 33 | XFINI | Processing Status for Payment Specification | char | 1 | 0 | CHAR | (N' ') | Yes | | XFINI_INDPAY | Allow NULL? |
| 34 | VALTO | Expiry Date of Payment Specification | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VALTO_IP | Allow NULL? |
| 35 | PYTYP | Payment Type Notified | char | 1 | 0 | CHAR | (N' ') | Yes | | PYTYP_KK | Allow NULL? |
| 36 | FDGRP | Planning Group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T035 | FDGRP_KK | Allow NULL? |
| 37 | FDLEV | Planning level | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T036 | FDLEV_KK | Allow NULL? |
| 38 | FDZTG | Additional Days for Cash Management | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | FDZTG_KK | Allow NULL? |
| 39 | FDWBT | Planning amount in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | FDWBT | |
| 40 | SPZAH | Lock Reason for Automatic Payment | char | 1 | 0 | CHAR | (N' ') | Yes | TFK008 | SPZAH_KK | Allow NULL? |
| 41 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | CURR | ((0)) | Yes | | BETRH_KK | |
| 42 | HERKF | Origin of Payment Specification | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | HERKF_IP_KK | Allow NULL? |
| 43 | CCINS | Payment card type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TB033 | CC_INSTITUTE | Allow NULL? |
| 44 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | * | CCNUM | Allow NULL? |
| 45 | CCFOL | Payment cards: Payment card suffix | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CCFOL | Allow NULL? |
| 46 | DATAB | Payment cards: Valid from | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CC_DATAB | Allow NULL? |
| 47 | DATBI | Payment Cards: Valid To | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CC_DATBI | Allow NULL? |
| 48 | CCNAME | Payment cards: Name of cardholder | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | CCNAME | Allow NULL? |
| 49 | AUNUM | Payment cards: Authorization number | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | AUNUM_KK | Allow NULL? |
| 50 | AUDAT | Payment cards: Authorization date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AUDAT_CC | Allow NULL? |
| 51 | AUTIM | Payment cards: Authorization time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AUTIM | Allow NULL? |
| 52 | CGUID | GUID of a Payment Card | varbinary | 16 | 0 | RAW | | Yes | | CARD_GUID | |
| 53 | ENCTP | Type of Encryption | char | 1 | 0 | CHAR | (N' ') | Yes | | CCSECA_ENCTYPE | Allow NULL? |
| 54 | SKTOW | Cash Discount Amount in Currency of Payment Specification | decimal | 13 | 2 | CURR | ((0)) | Yes | | SKTOW_INDPAY | |
