| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 85 | KIDNO | | nvarchar | 30 | 0 | | |
2 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 85 | KIDNO | | nvarchar | 30 | 0 | | |
3 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 113 | KIDNO | | nvarchar | 30 | 0 | | |
4 | BBP_RBKP | Document Header: Invoice Receipt | 69 | KIDNO | Payment Reference (BBP Original Copy) | nvarchar | 30 | 0 | | |
5 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 146 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
6 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 144 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
7 | BSEG | Accounting Document Segment | 284 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
8 | BSID_BAK | Accounting: Secondary Index for Customers | 146 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
9 | BSIK_BAK | Accounting: Secondary index for vendors | 144 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
10 | BSSEG | Accounting Document Segment | 273 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
11 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 273 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
12 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 273 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
13 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 273 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
14 | GLPOS_C_CT | FI Document: Entry View | 143 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
15 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 143 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
16 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 143 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
17 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 143 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
18 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 145 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
19 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 145 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
20 | REGUP | Processed items from payment program | 149 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
TOPAccounting Interface |
21 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 322 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
22 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 322 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
TOPAgency Business Global Trade |
23 | WBRK | Agency business: Header | 79 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
TOPAutomatic Payments |
24 | PAYRQ | Payment Requests | 154 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
TOPBasic Functions |
25 | FEBEP | Electronic Bank Statement Line Items | 74 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
TOPBilling |
26 | VBRK | Billing Document: Header Data | 91 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
TOPContract Accounts Receivable and Payable |
27 | FKKBEP | Electronic Bank Statement Line Items | 74 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
TOPCross-Application Components |
28 | BBSID | Accounting: Secondary index for customers | 146 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
TOPFinancial Accounting |
29 | /OPT/VIM_1HEAD | Document Header | 127 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
30 | AVIP | Payment Advice Line Item | 55 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
31 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 146 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
32 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 144 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
33 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 79 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
34 | BSID | Accounting: Secondary Index for Customers | 146 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
35 | BSIK | Accounting: Secondary Index for Vendors | 144 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
36 | BSIS | Accounting: Secondary Index for G/L Accounts | 79 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
37 | VBSEGD | Document Segment for Customer Document Parking | 109 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
38 | VBSEGK | Document Segment for Vendor Document Parking | 120 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
TOPFunds Management-Specific Postings |
39 | PSOSEGD | Document Segment: Recurring Request, Customer | 110 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
40 | PSOSEGK | Recurring Request Document Segment, Vendors | 118 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
TOPInvoice Verification |
41 | RBKP | Document Header: Invoice Receipt | 69 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
TOPLocalization |
42 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 116 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
43 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 115 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
44 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 115 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
45 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 115 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
TOPNorway |
46 | T5V4C | Assignment of KID number to Payee Key | 6 | KIDNO | Norway KID number | nvarchar | 30 | 0 | | |
TOPPayment Transactions |
47 | FPRL_ITEM | Item Data | 156 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
48 | REGUH | Settlement data from payment program | 126 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
49 | REGUP_CORE | Processed Items from Payment Program | 34 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |
TOPPublic Sector |
50 | P01ZFA_NN_KIDS | ZfA: Notifications Not Assigned - Child Data | 15 | KIDNO | Feature for Child Allowance Entitlement | nvarchar | 1 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
51 | /BEV3/CH1030BSG2 | Document Segment CH Event Ledger Part2 | 40 | KIDNO | Payment Reference | nvarchar | 30 | 0 | | |