| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | TQSYEA | Declaration Year - Spain | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 2 | TQS74IDY | Invoice Declaration Year - Spain | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 3 | TQSTID | Company Tax Identification - Spain | String | Generic Edit | 9 | 0 | Allow NULL? |
| 4 | TQSOTP | Operation Type - Spain | Character | UDC (74S OT) | 1 | 0 | Allow NULL? |
| 5 | TQSCVT | Customer/Vendor Tax Id. - Spain | String | Generic Edit | 9 | 0 | Allow NULL? |
| 6 | TQSIOP | Insurance Operation - Spain | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 7 | TQSLOP | Leasing Operation - Spain | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 8 | TQSRTI | Record Type - Spain | Numeric | Generic Edit | 1 | 0 | Allow NULL? |
| 9 | TQCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 10 | TQBCRC | Currency Code - Base | String | Generic Edit | 3 | 0 | Allow NULL? |
| 11 | TQS74TAQ1 | Transaction Amount Q1 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 12 | TQS74TAQ2 | Transaction Amount Q2 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 13 | TQS74TAQ3 | Transaction Amount Q3 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 14 | TQS74TAQ4 | Transaction Amount Q4 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 15 | TQS74ARPQ1 | Amount Received Properties Q1 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 16 | TQS74ARPQ2 | Amount Received Properties Q2 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 17 | TQS74ARPQ3 | Amount Received Properties Q3 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | TQS74ARPQ4 | Amount Received Properties Q4 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 19 | TQUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 20 | TQPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 21 | TQJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 22 | TQUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 23 | TQUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |