| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /GSINS/INH_EXTDE | External Transfers (in HCM infotype 0011) | 60 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
2 | BBP_PDIGP | Business Transaction Item-Purchasing Information | 111 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
3 | BBP_RBKP | Document Header: Invoice Receipt | 54 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
4 | BSEG | Accounting Document Segment | 161 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
5 | BSSEG | Accounting Document Segment | 150 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
6 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 150 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
7 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 150 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
8 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 150 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
9 | GLPOS_C_CT | FI Document: Entry View | 106 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
10 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 106 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
11 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 106 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
12 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 106 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
13 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 108 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
14 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 108 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
15 | P2RH_HU_MEMB | P21MB | 24 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
16 | P2RX_BT | Payroll Results: Bank Transfers | 29 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
17 | P2RX_BT_PERSON | Payment-Related Information (Person) | 31 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
18 | REGUP | Processed items from payment program | 73 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
19 | T77PAYKZBT | Bank Transfer Table Image (BTKZ) | 46 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
TOPAccounting Interface |
20 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 233 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
21 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 233 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
TOPCollectionsDisbursements |
22 | VVSCPOSESR | Payment Plan Item: ISR Attachment | 7 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
TOPContract Accounts Receivable and Payable |
23 | DFKKESR | POR Payment Supplement | 5 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
TOPFinancial Accounting |
24 | VBSEGK | Document Segment for Vendor Document Parking | 89 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
TOPFunds Management-Specific Postings |
25 | PSOSEGK | Recurring Request Document Segment, Vendors | 90 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
TOPInvoice Verification |
26 | RBKP | Document Header: Invoice Receipt | 54 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
27 | RBKPB | Invoice Document Header (Batch Invoice Verification) | 49 | ESRRE | Obsolete: ISR reference number: do NOT use | nvarchar | 27 | 0 | | |
TOPPayment Transactions |
28 | FPRL_ITEM | Item Data | 49 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
29 | REGUP_CORE | Processed Items from Payment Program | 32 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
TOPPayroll |
30 | T5T1L | Bank accounts of authorities (tax,insurance) | 13 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
31 | T5TA1 | External transfers | 38 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
32 | T5TPS1L | Bank accounts of authorities (tax,insurance) | 15 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
33 | T5TSPO | Table for convert bank accounts (Ceska Sporitelna) | 5 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
34 | T7SI1L | Bank accounts of authorities (tax,insurance) | 11 | ESRRE | POR reference number | nvarchar | 27 | 0 | | |
35 | T7SIA6 | Bank transfer - interface table | 34 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
36 | T7SK1L | Bank accounts of authorities (tax,insurance) | 16 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
37 | T7SKA1 | External transfers | 38 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
38 | T7SKEC0009 | Logovacia tabulka pre EURO konverziu - IT 0009 | 49 | ESRRE | Referencné cís.ESR | nvarchar | 27 | 0 | | |
39 | T7SKEC0011 | Logovacia tabulka pre EURO konverziu - IT 0011 | 54 | ESRRE | Referencné cís.ESR | nvarchar | 27 | 0 | | |
TOPPersonnel Administration |
40 | PA0009 | HR Master Record: Infotype 0009 (Bank Details) | 46 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
41 | PA0011 | HR Master Record: Infotype 0011 (Ext.Bank Transfers) | 51 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
42 | PA0057 | HR Master Record: Infotype 0057 (Membership Fees) | 41 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
TOPRecruitment |
43 | PB0009 | HR Master Record: Infotype 0009 (Bank Details) | 46 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
44 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 152 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | | |