| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | EHPRCC_DOCGA | Document group - Document assignment | 2 | DOCGRP | Document Group | nvarchar | 20 | 0 | | |
2 | EHPRCC_DOCGA_T | Document group - Document assignment Description | 3 | DOCGRP | Document Group | nvarchar | 20 | 0 | | |
3 | EHPRCC_DOCGN | Document Group Description | 3 | DOCGRP | Document Group | nvarchar | 20 | 0 | | |
4 | EHPRCC_DOCGP | Document groups | 2 | DOCGRP | Document Group | nvarchar | 20 | 0 | | |
5 | EHPRCC_EMLC | Communication Definition | 7 | DOCGRP | Document Group | nvarchar | 20 | 0 | | |
6 | EHPRCD_DOCGA | Document group - Document assignment | 2 | DOCGRP | Document Group | nvarchar | 20 | 0 | | |
TOPDocument Builder |
7 | /IPRO/TCHOICE | Table determines which doc selections are in a doc group | 4 | DOCGRP | Document Group | nvarchar | 20 | 0 | | |
8 | /IPRO/TDOCGRP | A collection of one or more doc types and part of struc rule | 3 | DOCGRP | Document Group | nvarchar | 20 | 0 | | |
9 | /IPRO/TDOCGRP_T | Contains document types text for TDOCGRP | 4 | DOCGRP | Document Group | nvarchar | 20 | 0 | | |
TOPEnvironment, Health and Safety |
10 | /TDAG/RCSC_DOCGA | Document group - Document assignment | 2 | DOCGRP | Document Group | nvarchar | 20 | 0 | | |
11 | /TDAG/RCSC_DOCGN | Document Group Description | 3 | DOCGRP | Document Group | nvarchar | 20 | 0 | | |
12 | /TDAG/RCSC_DOCGP | Document groups | 2 | DOCGRP | Document Group | nvarchar | 20 | 0 | | |
13 | /TDAG/RCSC_EMLC | Communication Definition | 5 | DOCGRP | Document Group | nvarchar | 20 | 0 | | |
TOPExpenditure Certification |
14 | FMEUFDOCGR | Document Group | 2 | DOCGRP | Document Group | nvarchar | 2 | 0 | | |
15 | FMEUFDOCGR_T | Text Table for Document Group | 2 | DOCGRP | Document Group | nvarchar | 2 | 0 | | |
16 | FMEUFDOCT | Document Type assigned to Document Group | 4 | DOCGRP | Document Group | nvarchar | 2 | 0 | | |
17 | FMEUFEXP | Certified Expenditure Documents | 25 | DOCGRP | Document Group | nvarchar | 2 | 0 | | |
TOPPayment Item |
18 | TBKKIDC | BCA: Document Types | 2 | DOCGRP | Document Type Group | nvarchar | 1 | 0 | | |