| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBasic functions |
1 | HUINV_HDR | Handling Unit: Phys. Inv. Document Header | 16 | POSTED | Inventory document/item was cleared | nvarchar | 1 | 0 | | |
2 | HUINV_ITEM | Handling Unit: Physical Inventory Document Item | 28 | POSTED | Inventory document/item was cleared | nvarchar | 1 | 0 | | |
3 | HUWM_LOAD_PROT | Log Table of Initial Data Transfer for Subsequent Posting | 70 | POSTED | Checkbox | nvarchar | 1 | 0 | | |
TOPContract Accounts Receivable and Payable |
4 | DFKKDEFREV_POS | Line Item Table (Event-Based Deferred Revenues) | 46 | POSTED | Trigger Transferred to General Ledger | nvarchar | 1 | 0 | | |
5 | FKKDEFREV | Trigger Table for Deferred Revenue Postings | 38 | POSTED | Trigger Transferred to General Ledger | nvarchar | 1 | 0 | | |
TOPPerformance Assessment Workbench |
6 | SLS_PET | PAW - Person/Event/Test Relationship Table | 17 | POSTED | PAW - Post Edit for Free Text or Essay | nvarchar | 1 | 0 | | |
7 | SLS_RITEM | PAW - Result on Item | 6 | POSTED | PAW - 'Post-Edit' Flag - as checkbox ('X' = yes) | nvarchar | 1 | 0 | | |
8 | SLS_YITEM | PAW - Result on Item | 6 | POSTED | PAW - 'Post-Edit' Flag - as checkbox ('X' = yes) | nvarchar | 1 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
9 | NLHCO_ORDER | NL-HCO: Orders | 8 | POSTED | Algemeen teken | nvarchar | 1 | 0 | | |