| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PDKEY | Number of Payment Specification | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | VALDT | Date to Which Payment Specification Was Valid | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | VALTM | Time to Which Payment Specification Was Valid | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | PDTYP | Category of Payment Specification | char | 1 | 0 | | | | Allow NULL? |
| 6 | GPARV | Business Partner Acting as Payer in Payment Transactions | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | VKONV | Contract account used for payment transactions | nvarchar | 12 | 0 | | | | Allow NULL? |
| 8 | PDREF | Reference Number of Payment Specification | nvarchar | 16 | 0 | | | | Allow NULL? |
| 9 | EIGBV | Own Bank Details | nvarchar | 25 | 0 | | | | Allow NULL? |
| 10 | PYMET | Payment Method | char | 1 | 0 | | | | Allow NULL? |
| 11 | BKVID | Bank details ID | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | | | Allow NULL? |
| 13 | CCARD_ID | Payment Card ID | nvarchar | 6 | 0 | | | | Allow NULL? |
| 14 | PYBUK | Company Code for Automatic Payment Transactions | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | BETRW | Payment Amount of Payment Specification | decimal | 13 | 2 | | | | |
| 16 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 17 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 18 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | ERTIM | Time of Entry | nvarchar | 6 | 0 | | | | Allow NULL? |
| 20 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 21 | AEDAT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | AETIM | Time of Entry | nvarchar | 6 | 0 | | | | Allow NULL? |
| 23 | DOC1T | Payment Document Category | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | DOC1R | Reference to Payment Document | nvarchar | 24 | 0 | | | | Allow NULL? |
| 25 | LAUFD | Date ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | LAUFI | Identification for the payment run | nvarchar | 5 | 0 | | | | Allow NULL? |
| 27 | C4EYE | Check Reason for Workflows Acc. to Dual Control Principle | nvarchar | 2 | 0 | | | | Allow NULL? |
| 28 | DTAWS | Instruction key for data medium exchange | nvarchar | 2 | 0 | | | | Allow NULL? |
| 29 | DTAMS | Indicator for Data Medium Exchange | char | 1 | 0 | | | | Allow NULL? |
| 30 | TXTSL | Text key for the code line on the form | nvarchar | 2 | 0 | | | | Allow NULL? |
| 31 | TXERG | Text key supplement | nvarchar | 3 | 0 | | | | Allow NULL? |
| 32 | STAIP | Payment Specification: Status | char | 1 | 0 | | | | Allow NULL? |
| 33 | AUSFD | Payment Specification: Execution Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 34 | PYTXT | Text for Payment | nvarchar | 50 | 0 | | | | Allow NULL? |
| 35 | XFINI | Processing Status for Payment Specification | char | 1 | 0 | | | | Allow NULL? |
| 36 | VALTO | Expiry Date of Payment Specification | nvarchar | 8 | 0 | | | | Allow NULL? |
| 37 | PYTYP | Payment Type Notified | char | 1 | 0 | | | | Allow NULL? |
| 38 | FDGRP | Planning Group | nvarchar | 10 | 0 | | | | Allow NULL? |
| 39 | FDLEV | Planning level | nvarchar | 2 | 0 | | | | Allow NULL? |
| 40 | FDZTG | Additional Days for Cash Management | nvarchar | 2 | 0 | | | | Allow NULL? |
| 41 | FDWBT | Planning amount in document currency | decimal | 13 | 2 | | | | |
| 42 | SPZAH | Lock Reason for Automatic Payment | char | 1 | 0 | | | | Allow NULL? |
| 43 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | | | | |
| 44 | HERKF | Origin of Payment Specification | nvarchar | 2 | 0 | | | | Allow NULL? |
| 45 | CCINS | Payment card type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 46 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | | | Allow NULL? |
| 47 | CCFOL | Payment cards: Payment card suffix | nvarchar | 10 | 0 | | | | Allow NULL? |
| 48 | DATAB | Payment cards: Valid from | nvarchar | 8 | 0 | | | | Allow NULL? |
| 49 | DATBI | Payment Cards: Valid To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 50 | CCNAME | Payment cards: Name of cardholder | nvarchar | 40 | 0 | | | | Allow NULL? |
| 51 | AUNUM | Payment cards: Authorization number | nvarchar | 25 | 0 | | | | Allow NULL? |
| 52 | AUDAT | Payment cards: Authorization date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 53 | AUTIM | Payment cards: Authorization time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 54 | CGUID | GUID of a Payment Card | varbinary | 16 | 0 | | | | |
| 55 | ENCTP | Type of Encryption | char | 1 | 0 | | | | Allow NULL? |
| 56 | SKTOW | Cash Discount Amount in Currency of Payment Specification | decimal | 13 | 2 | | | | |