| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_05_FPLA | Collector Table for Billing Plans | 3 | FPLNR | FPLNR for FPLA | nvarchar | 10 | 0 | | |
TOPBasic Functions |
2 | FPLA | Billing Plan | 2 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |
3 | FPLAPO | Billing Plan | 2 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |
4 | FPLT | Billing Plan: Dates | 2 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |
5 | FPLTPO | Billing Plan: Dates | 2 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |
6 | VBFA | Sales Document Flow | 28 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |
7 | VFPLA | Billing Plan | 2 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |
8 | VFPLT | Billing Plan: Dates | 2 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |
TOPBilling |
9 | VBRP | Billing Document: Item Data | 129 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |
TOPCross-Application Components |
10 | VVBFA | Sales Document Flow | 28 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |
11 | VVBKD | Sales Document: Business Data | 29 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |
TOPData Collection |
12 | S008 | Communications Table SD -> CO/Projects | 11 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |
TOPMaterial |
13 | RSADD | Additional fields for reservation | 16 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |
TOPOperative Structures |
14 | PRPS | WBS (Work Breakdown Structure) Element Master Data | 81 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |
TOPPayment Cards |
15 | FPLTC | Payment cards: Transaction data - SD | 2 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |
TOPProduction Orders |
16 | AFVC | Operation within an order | 160 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |
TOPProfitability Analysis |
17 | CEERROR | CO-PA: Incorrect records from SD | 6 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |
TOPPurchasing |
18 | EKPO | Purchasing Document Item | 114 | FPLNR | Invoicing plan number | nvarchar | 10 | 0 | | |
TOPSales |
19 | VBKD | Sales Document: Business Data | 29 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |
TOPSimulation |
20 | VSAFVC_CN | Version: Operation in order | 161 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |
21 | VSFPLA_CN | Version: Billing schedule | 3 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |
22 | VSFPLT_CN | Version: Billing schedule: Dates | 3 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |
23 | VSPRPS_CN | Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data | 82 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |
24 | VSRSADD_CN | Version: Additional fields for reservation | 17 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |
25 | VSVBKD_CN | Version: Sales document - commercial data | 30 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | | |