| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /GSINS/INH_EXTDE | External Transfers (in HCM infotype 0011) | 61 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
2 | BBP_PDIGP | Business Transaction Item-Purchasing Information | 109 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
3 | BBP_RBKP | Document Header: Invoice Receipt | 53 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
4 | BSEG | Accounting Document Segment | 162 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
5 | BSSEG | Accounting Document Segment | 151 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
6 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 151 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
7 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 151 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
8 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 151 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
9 | GLPOS_C_CT | FI Document: Entry View | 105 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
10 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 105 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
11 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 105 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
12 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 105 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
13 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 107 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
14 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 107 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
15 | P2RH_HU_MEMB | P21MB | 25 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
16 | P2RX_BT | Payroll Results: Bank Transfers | 30 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
17 | P2RX_BT_PERSON | Payment-Related Information (Person) | 32 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
18 | REGUP | Processed items from payment program | 74 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
19 | T77PAYKZBT | Bank Transfer Table Image (BTKZ) | 47 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
TOPAccounting Interface |
20 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 232 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
21 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 232 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
TOPCollectionsDisbursements |
22 | VVSCPOSESR | Payment Plan Item: ISR Attachment | 8 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
TOPContract Accounts Receivable and Payable |
23 | DFKKESR | POR Payment Supplement | 6 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
TOPFinancial Accounting |
24 | VBSEGK | Document Segment for Vendor Document Parking | 90 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
TOPFunds Management-Specific Postings |
25 | PSOSEGK | Recurring Request Document Segment, Vendors | 91 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
TOPInvoice Verification |
26 | RBKP | Document Header: Invoice Receipt | 53 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
27 | RBKPB | Invoice Document Header (Batch Invoice Verification) | 48 | ESRPZ | Obsolete: ISR check digit: do NOT use | nvarchar | 2 | 0 | | |
TOPPayment Transactions |
28 | FPRL_ITEM | Item Data | 50 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
29 | REGUP_CORE | Processed Items from Payment Program | 33 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
TOPPayroll |
30 | T7BGA2 | Changes of external transfers (IT11) | 3 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
31 | T7ROA5 | Changes of external transfers (IT11) | 3 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
32 | T7SIA5 | History of repayments | 4 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
33 | T7SKEC0009 | Logovacia tabulka pre EURO konverziu - IT 0009 | 50 | ESRPZ | Kontr.cís.ESR | nvarchar | 2 | 0 | | |
34 | T7SKEC0011 | Logovacia tabulka pre EURO konverziu - IT 0011 | 55 | ESRPZ | Kontr.cís.ESR | nvarchar | 2 | 0 | | |
TOPPersonnel Administration |
35 | PA0009 | HR Master Record: Infotype 0009 (Bank Details) | 47 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
36 | PA0011 | HR Master Record: Infotype 0011 (Ext.Bank Transfers) | 52 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
37 | PA0057 | HR Master Record: Infotype 0057 (Membership Fees) | 42 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
TOPRecruitment |
38 | PB0009 | HR Master Record: Infotype 0009 (Bank Details) | 47 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
39 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 153 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | | |