| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAutomatic Payments |
1 | PAYRQ | Payment Requests | 62 | ZLAND | Country Key | nvarchar | 3 | 0 | | |
TOPContract Accounts Receivable and Payable |
2 | DFKKPOH | Payment Order: Header Data | 32 | ZLAND | Country Key | nvarchar | 3 | 0 | | |
3 | DPAYH | Payment program - data for payment | 29 | ZLAND | Country Key | nvarchar | 3 | 0 | | |
TOPPayment Transactions |
4 | FPRL_ITEM | Item Data | 123 | ZLAND | Country Key | nvarchar | 3 | 0 | | |
5 | PAYR | Payment Medium File | 38 | ZLAND | Country Key | nvarchar | 3 | 0 | | |
6 | REGUH | Settlement data from payment program | 34 | ZLAND | Country Key | nvarchar | 3 | 0 | | |
TOPPayments |
7 | DFKKBOH | Boleto: Header data | 34 | ZLAND | Country Key | nvarchar | 3 | 0 | | |
TOPTravel Expenses |
8 | PTRV_ARCHIVE | Administrative Table for Archived Trip Data | 6 | ZLAND | Trip Country / Trip Country Group | nvarchar | 3 | 0 | | |
9 | PTRV_ARCH_HEAD | Prearchiving FI-TV: Entries from PTRV_HEAD (Temporary) | 12 | ZLAND | Trip Country / Trip Country Group | nvarchar | 3 | 0 | | |
10 | PTRV_HEAD | General Trip Data | 12 | ZLAND | Trip Country / Trip Country Group | nvarchar | 3 | 0 | | |
11 | PTRV_KMSUM | Table for Use of Miles/Kms Accumulation | 4 | ZLAND | Trip Country / Trip Country Group | nvarchar | 3 | 0 | | |
12 | PTRV_NOT_CH_TR | Storage of New Data from Temporarily Unchangable Trips | 16 | ZLAND | Trip Country / Trip Country Group | nvarchar | 3 | 0 | | |
13 | PTRV_TRIPCHN_46C | Table of all Trip Destinations f. Processing Recurring Dest. | 13 | ZLAND | Trip Country / Trip Country Group | nvarchar | 3 | 0 | | |
14 | PTRV_TRIP_CHAIN | Table of all Trip Destinations f. Processing Recurring Dest. | 13 | ZLAND | Trip Country / Trip Country Group | nvarchar | 3 | 0 | | |
TOPTravel Planning |
15 | FTPT_TM_MEMO | Memo table for Travel Management | 9 | ZLAND | Trip Country / Trip Country Group | nvarchar | 3 | 0 | | |