| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPPublic Sector Contract Accounts Receivable and Payable |
1 | DFMCA_FORM_VERS | Versions of Form Data | 2 | FORM_GUID | Technical Key of Form | nvarchar | 32 | 0 | | |
2 | DFMCA_TF_CST_H | Header Table of Consolidated Sales Use Tax Member Schedule | 2 | FORM_GUID | Technical Key of Form | nvarchar | 32 | 0 | | |
3 | DFMCA_TF_CST_L | Line Item Table of Consolidated SUT Member Schedule | 2 | FORM_GUID | Technical Key of Form | nvarchar | 32 | 0 | | |
4 | DFMCA_TF_MFT_D_H | Header Table of Motor Fuel Tax Disbursement Schedule | 2 | FORM_GUID | Technical Key of Form | nvarchar | 32 | 0 | | |
5 | DFMCA_TF_MFT_D_L | Line Item Table of Motor Fuel Tax Disbursement Schedule | 2 | FORM_GUID | Technical Key of Form | nvarchar | 32 | 0 | | |
6 | DFMCA_TF_MFT_R_H | Header Table of Motor Fuel Tax Receipts Schedule | 2 | FORM_GUID | Technical Key of Form | nvarchar | 32 | 0 | | |
7 | DFMCA_TF_MFT_R_L | Line Item Table of Motor Fuel Tax Receipts Schedule | 2 | FORM_GUID | Technical Key of Form | nvarchar | 32 | 0 | | |
8 | DFMCA_TF_UET_L | Line Item Table of Unemployment Tax | 2 | FORM_GUID | Technical Key of Form | nvarchar | 32 | 0 | | |
9 | DFMCA_TF_WHT_L | Line Item Table of Withholding Tax | 2 | FORM_GUID | Technical Key of Form | nvarchar | 32 | 0 | | |
TOPWeb Survey |
10 | TUWS_SURVEY_LOG | Survey Log | 7 | FORM_GUID | GUID | nvarchar | 32 | 0 | | |
11 | TUWS_SURVEY_PUB | Survey Publishing | 7 | FORM_GUID | GUID | nvarchar | 32 | 0 | | |