| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | QCCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | QCAN8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | QCYTYP | TDS Type | Character | UDC (75I TY) | 1 | 0 | Allow NULL? |
| 4 | QCI75DTBG | Beginning Date | Date | Generic Edit | 6 | 0 | |
| 5 | QCI75DTEN | End Date | Date | Generic Edit | 6 | 0 | |
| 6 | QCI75ORST | Origin State | String | UDC (00 S) | 3 | 0 | Allow NULL? |
| 7 | QCI75CRPE | Concessional Rate | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 8 | QCI75TSUR | Surcharge Rate | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 9 | QCPTC | Payment Terms Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 10 | QCGLC | G/L Offset | String | Generic Edit | 4 | 0 | Allow NULL? |
| 11 | QCYAOC | Assessing Certificate Number | String | Generic Edit | 40 | 0 | Allow NULL? |
| 12 | QCYDSD | Date Submit NIL Declaration | Date | Generic Edit | 6 | 0 | |
| 13 | QCCDT | Date - Creation | Date | Generic Edit | 6 | 0 | |
| 14 | QCYDFD | Date Foward Declaration to Commision | Date | Generic Edit | 6 | 0 | |
| 15 | QCUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 16 | QCPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 17 | QCJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 18 | QCUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 19 | QCUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 20 | QCTORG | Transaction Originator | String | Generic Edit | 10 | 0 | Allow NULL? |
| 21 | QCI75CEIR | Ceiling Rate Limit | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 22 | QCI75SUCE | Surcharge Ceiling | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 23 | QCI75CERA | Cess Rate | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 24 | QCI75EFRA | Effective Rate Without Surcharge | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 25 | QCCHGF | Change Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 26 | QCFLAG | Journaling Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 27 | QCI75THAM | Thresholds By | Character | UDC (75I TB) | 1 | 0 | Allow NULL? |
| 28 | QCI75CORL | Concessional Limit Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 29 | QCI75CORF | Concessional Limit Amount Future Use | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 30 | QCI75INLI | Ceiling Invoice Limit | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 31 | QCI75HECR | Higher Education Rate | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 32 | QCI75FTX1 | Penalty Rate | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 33 | QCI75FTX2 | Taxable Rounding | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 34 | QCI75EXST | Exclude Service Tax | Character | Generic Edit | 1 | 0 | Allow NULL? |