| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SAPF15/SM | F15 SEPA Mandat | 13 | MGUID | SEPA-Mandat: GUID des Mandats | varbinary | 16 | 0 | | |
2 | HRPAD00_SEPA_UPD | Flag SEPA Mandates to Be Updated | 3 | MGUID | SEPA Mandate: GUID of Mandate | varbinary | 16 | 0 | | |
TOPAutomatic Payments |
3 | PAYRQ | Payment Requests | 162 | MGUID | SEPA Mandate: GUID of Mandate | varbinary | 16 | 0 | | |
TOPBank |
4 | SEPA_MANDATE | SEPA Mandate | 2 | MGUID | SEPA Mandate: GUID of Mandate | varbinary | 16 | 0 | | |
5 | SEPA_MANDATE_USE | SEPA Mandate Management: Usages | 2 | MGUID | Globally Unique Identifier | varbinary | 16 | 0 | | |
TOPContract Accounts Receivable and Payable |
6 | DPAYH | Payment program - data for payment | 97 | MGUID | Generic Data Element for GUID Fields (X16) | varbinary | 16 | 0 | | |
TOPMaster Data |
7 | VDESCROW0 | TEMPORARY USE: Escrow-Specific Master Data | 2 | MGUID | GUID | varbinary | 16 | 0 | | |
8 | VDESCROWGUID | Escrow Reference Table for VDARL | 5 | MGUID | GUID | varbinary | 16 | 0 | | |
9 | VDESCROWKOKO0 | TEMPORARY USE: Escrow Condition Headers | 2 | MGUID | GUID | varbinary | 16 | 0 | | |
10 | VDESCROWKOPO0 | TEMPORARY USE: Escrow Condition Items | 2 | MGUID | GUID | varbinary | 16 | 0 | | |
TOPPayment Transactions |
11 | FPRL_ITEM | Item Data | 170 | MGUID | SEPA Mandate: GUID of Mandate | varbinary | 16 | 0 | | |
12 | REGUH | Settlement data from payment program | 169 | MGUID | SEPA Mandate: GUID of Mandate | varbinary | 16 | 0 | | |
13 | REGUHH | REGUH version before the 'n'th change | 37 | MGUID | SEPA Mandate: GUID of Mandate | varbinary | 16 | 0 | | |
14 | REGUS_SEPA | SEPA Mandate Lock: Applications To Be Retrieved | 4 | MGUID | Globally Unique Identifier | varbinary | 16 | 0 | | |