Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Public 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 | ||
Web 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 |