| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | PIQDB_DE_TRD | Target Degree for Transcripts | 2 | TRANS_GUID | GUID - Unique ID of External Transcript | nvarchar | 32 | 0 | | |
| 2 | PIQDB_DE_TRH | Transcript Header | 2 | TRANS_GUID | GUID - Unique ID of External Transcript | nvarchar | 32 | 0 | | |
| 3 | PIQDB_DE_TRS | Specialization for Trnascripts | 2 | TRANS_GUID | GUID - Unique ID of External Transcript | nvarchar | 32 | 0 | | |
| 4 | HRP1719 | DB Table for Infotype 1719 | 18 | TRANS_GUID | GUID - Unique ID of External Transcript | nvarchar | 32 | 0 | | |
| 5 | HRP1893 | DB Table for Infotype 1893 | 18 | TRANS_GUID | GUID - Unique ID of External Transcript | nvarchar | 32 | 0 | | |
| 6 | PIQDB_NL_OUTLOG | Status log of the Outgoing messages | 7 | TRANS_GUID | GUID - Unique ID of External Transcript | nvarchar | 32 | 0 | | |
| TOPInventory Management |
| 7 | WRMA_NO_DOC | Index of Cancelled Posting Run Without Agency Document | 2 | TRANS_GUID | GUID of RMA Posting Run | varbinary | 16 | 0 | | |
| 8 | WRMA_TRANS | Header Data for Posting Run | 2 | TRANS_GUID | GUID of RMA Posting Run | varbinary | 16 | 0 | | |
| 9 | WRMA_TRANS_CD | Condition Data for Posting Run | 2 | TRANS_GUID | GUID of RMA Posting Run | varbinary | 16 | 0 | | |
| 10 | WRMA_TRANS_DOC | Document Data for Posting Run | 2 | TRANS_GUID | GUID of RMA Posting Run | varbinary | 16 | 0 | | |
