| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBank Customer Accounts |
| 1 | BKKPOGISL | EDI Payments: Reporting Data to Clearing, Seg. E1IDT02 | 7 | TXTSP | Language | nvarchar | 1 | 0 | | |
| 2 | BKKPOREFL | References for EDI Payments, Header data, Long Texts | 6 | TXTSP | Language | nvarchar | 1 | 0 | | |
| TOPComputer Aided Process Planning |
| 3 | PLPH | CAPP: Sub-operations | 24 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| TOPConfirmations |
| 4 | AFRU | Order Confirmations | 12 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| TOPCross-Application Components |
| 5 | PLLPO | Task list - operation/activity | 24 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| TOPMaintenance History |
| 6 | HIVG | PM order history - operations | 17 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| TOPMaintenance Processing |
| 7 | /ISDFPS/MNTF_HD | DFPS: Mass Maintenance | 10 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| TOPMaster Data Distribution |
| 8 | /ISDFPS/TL1 | Task List - Operation/Activity | 24 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| TOPMaster Recipe |
| 9 | PLFV | PI Characteristics/Sub-Operation Parameter Values | 29 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| TOPOperative Structures |
| 10 | PROJ | Project definition | 37 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| 11 | PRPS | WBS (Work Breakdown Structure) Element Master Data | 43 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| TOPProcess Order |
| 12 | AFFV | Order - Process Instruction Values | 25 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| TOPProduction Orders |
| 13 | AFFL | Work order sequence | 15 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| 14 | AFVC | Operation within an order | 19 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| TOPProduction ResourcesTools |
| 15 | AFFH | PRT assignment data for the work order | 62 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| TOPRouting |
| 16 | PLFH | Task list - production resources/tools | 36 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| 17 | PLFL | Task list - sequences | 21 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| 18 | PLKO | Task list - header | 24 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| 19 | PLPO | Task list - operation/activity | 24 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| TOPSimulation |
| 20 | VSAFFH_CN | Version: PRT allocation to work order | 63 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| 21 | VSAFFL_CN | Version: Order sequences PP orders | 16 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| 22 | VSAFVC_CN | Version: Operation in order | 20 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| 23 | VSPROJ_CN | Version: Project definition | 38 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| 24 | VSPRPS_CN | Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data | 44 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| TOPTemplates |
| 25 | PROJS | Standard project definition | 37 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
| 26 | PRPSS | Standard WBS Element (WBS element) - Master Data | 43 | TXTSP | Language Key | nvarchar | 1 | 0 | | |
