| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFinancials |
1 | FINORDUE0C | FIN Objects for Receivables/Payables | 19 | FINB_CHNG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
TOPInventory Accounting |
2 | CFICC0C | FIN Objects for Cost Centers | 9 | FINB_CHNG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
3 | CFICR0C | FIN Objects for Cost Center/Resource Pool | 10 | FINB_CHNG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
4 | CFIFA0C | FIN Objects for Fixed Assets | 10 | FINB_CHNG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
5 | CFIOCONSI0C | FIN Objects for Consignment | 20 | FINB_CHNG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
6 | CFIOGMVMT0C | FIN Objects for Material Documents (GR-Based IV) | 20 | FINB_CHNG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
7 | CFIORGEN0C | FIN Objects for Internal Orders | 11 | FINB_CHNG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
8 | CFIORMNF0C | FIN Objects for Manufacturing Orders | 12 | FINB_CHNG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
9 | CFIORMNT0C | FIN Objects for Maintenance Orders | 11 | FINB_CHNG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
10 | CFIORNTA0C | FIN Objects for Network Items | 12 | FINB_CHNG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
11 | CFIORNTW0C | FIN Objects for Networks | 11 | FINB_CHNG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
12 | CFIORPURITM0C | FIN Objects for Purchase Order Items | 21 | FINB_CHNG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
13 | CFIORQMM0C | FIN Objects for QM Orders | 11 | FINB_CHNG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
14 | CFIORSRV0C | FIN Objects for Service Orders | 11 | FINB_CHNG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
15 | CFIORWBS0C | FIN Objects for WBS Elements | 11 | FINB_CHNG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
16 | CFIOSENTR0C | FIN Objects for Services | 20 | FINB_CHNG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
17 | CFIPVLOCPRD0C | Product Depending on Company/Location | 13 | FINB_CHNG_DATE | Last Changed On | nvarchar | 8 | 0 | | |
18 | CFIPVLOCPRDBTC0C | Product Depending on Company/Location/Batch | 14 | FINB_CHNG_DATE | Last Changed On | nvarchar | 8 | 0 | | |