| 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 | 81 | XNEGP | | nvarchar | 1 | 0 | | |
2 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 81 | XNEGP | | nvarchar | 1 | 0 | | |
3 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 99 | XNEGP | | nvarchar | 1 | 0 | | |
4 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 132 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
5 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 135 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
6 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 51 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
7 | BSEG | Accounting Document Segment | 270 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
8 | BSID_BAK | Accounting: Secondary Index for Customers | 132 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
9 | BSIK_BAK | Accounting: Secondary index for vendors | 135 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
10 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 51 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
11 | BSSEG | Accounting Document Segment | 259 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
12 | CNV_20100_T001 | CNV backup copy for T001 | 58 | XNEGP | | nvarchar | 1 | 0 | | |
13 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 51 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
14 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 51 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
15 | FIEUD_FIDOC_I | SAFT: FI Transaction Document Item | 18 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
16 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 259 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
17 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 259 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
18 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 259 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
19 | GLPOS_C_CT | FI Document: Entry View | 283 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
20 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 283 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
21 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 283 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
22 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 283 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
23 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 292 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
24 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 292 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
TOPAccounting Interface |
25 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 291 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
26 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 291 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
TOPAgency Business Global Trade |
27 | TMFK | Agency Business: Billing Document Types | 29 | XNEGP | Negative posting | nvarchar | 1 | 0 | | |
TOPBasic Functions |
28 | TVFK | Billing: Document Types | 45 | XNEGP | Negative posting | nvarchar | 1 | 0 | | |
TOPBasis Components |
29 | ZDS400_T001 | Buchungskreise | 57 | XNEGP | Kennzeichen: Negativbuchungen erlaubt | nvarchar | 1 | 0 | | |
TOPContract Accounts Receivable and Payable |
30 | DFKKRDI | Revenue Distribution | 22 | XNEGP | Negative Posting for Revenue Distribution | nvarchar | 1 | 0 | | |
31 | DFKKSUM | Posting totals from FI-CA | 41 | XNEGP | Negative Posting | nvarchar | 1 | 0 | | |
TOPCross-Application Components |
32 | BBSID | Accounting: Secondary index for customers | 132 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
TOPFinancial Accounting |
33 | ACCTIT | Compressed Data from FI/CO Document | 147 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
34 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 132 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
35 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 135 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
36 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 51 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
37 | BSID | Accounting: Secondary Index for Customers | 132 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
38 | BSIK | Accounting: Secondary Index for Vendors | 135 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
39 | BSIS | Accounting: Secondary Index for G/L Accounts | 51 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
40 | T001 | Company Codes | 57 | XNEGP | Indicator: Negative Postings Permitted | nvarchar | 1 | 0 | | |
41 | T003 | Document Types | 20 | XNEGP | Indicator: Negative Postings Permitted | nvarchar | 1 | 0 | | |
42 | T041C | Reasons for Reverse Posting | 3 | XNEGP | Indicator: Generate negative postings | nvarchar | 1 | 0 | | |
43 | VBSEGA | Document Segment for Document Parking - Asset Database | 85 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
44 | VBSEGD | Document Segment for Customer Document Parking | 120 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
45 | VBSEGK | Document Segment for Vendor Document Parking | 131 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
46 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 138 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
TOPFunds Management-Specific Postings |
47 | PSO55 | Negative Posting in Requests | 5 | XNEGP | Indicator: Negative Postings Permitted | nvarchar | 1 | 0 | | |
TOPGeneral Ledger Accounting |
48 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 62 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
49 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 51 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
50 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 51 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
TOPInformation System |
51 | DKKOP | Balance Audit Trail | 66 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
52 | DKOKP | Open Item Account Balance Audit Trail | 75 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
53 | DSKOP | Balance Audit Trail | 78 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
TOPInvoice Verification |
54 | RBCO | Document Item, Incoming Invoice, Account Assignment | 56 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
TOPLocalization |
55 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 102 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
56 | J_3RNEGPAFABE | Permit Negative Posting for Depr. Area and Chart of Depr. | 4 | XNEGP | Negative Postings Permitted | nvarchar | 1 | 0 | | |
57 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 101 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
58 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 101 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
59 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 101 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
60 | /BEV3/CH1030BSG2 | Document Segment CH Event Ledger Part2 | 26 | XNEGP | Indicator: Negative posting | nvarchar | 1 | 0 | | |
TOPTravel Expenses |
61 | PTRV_DOC_IT | Transfer Travel -> FI/CO: Lines of TRV interm. document | 50 | XNEGP | Indicator: Negative Posting | nvarchar | 1 | 0 | | |