| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | QRYEXU | Excise Unit | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | QRYAR3N | AR3 Entry Number | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 3 | QRYSUF | Sufix | String | Generic Edit | 2 | 0 | Allow NULL? |
| 4 | QRYAR3D | AR3 Entry Date | Date | Generic Edit | 6 | 0 | |
| 5 | QRAA25 | Alpha Spec. Data 25 | String | Generic Edit | 25 | 0 | Allow NULL? |
| 6 | QREDER | EDI - Send/Receive Indicator | Character | UDC (H00 ED) | 1 | 0 | Allow NULL? |
| 7 | QRKCOO | Order Company (Order Number) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 8 | QRDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 9 | QRDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 10 | QRKCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 11 | QRDOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 12 | QRDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 13 | QRYEXA | Excise Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 14 | QRDCPER | Basic Duty | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 15 | QRDCVD | Excise Duty Per | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 16 | QRYTDU | Total Duty | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 17 | QRYODT | Other Duty | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | QRASVL | Assessed Value | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 19 | QRXOPR | External Operation | String | Generic Edit | 60 | 0 | Allow NULL? |
| 20 | QRREMK | Remarks | String | Generic Edit | 30 | 0 | Allow NULL? |
| 21 | QRMOT | Mode of Transport | String | UDC (00 TM) | 3 | 0 | Allow NULL? |
| 22 | QRBDSN | Serial Number - Bond | String | Generic Edit | 22 | 0 | Allow NULL? |
| 23 | QRYDFW | Date of first warehouse | Date | Generic Edit | 6 | 0 | |
| 24 | QRYC3N | CT3 Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 25 | QREXPUN | Export Under | String | Generic Edit | 10 | 0 | Allow NULL? |
| 26 | QRFLG | Translation Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 27 | QRYC3D | CT3 Date | Date | Generic Edit | 6 | 0 | |
| 28 | QRYEU3 | Excise Unit Issuing CT3 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 29 | QRYA3D | AR3 Receipt Date | Date | Generic Edit | 6 | 0 | |
| 30 | QRAEXD | Authorization Expiry Date | Date | Generic Edit | 6 | 0 | |
| 31 | QRYOA3N | Original AR3 Entry Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 32 | QRYOSUF | Original Sufix | String | Generic Edit | 2 | 0 | Allow NULL? |
| 33 | QRYOA3D | Original AR3 Entry Date | Date | Generic Edit | 6 | 0 | |
| 34 | QRTORG | Transaction Originator | String | Generic Edit | 10 | 0 | Allow NULL? |
| 35 | QRA301 | Generic String 01 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 36 | QRDESC | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 37 | QRDSC1 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 38 | QRUORG | Units - Order/Transaction Quantity | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 39 | QRELEM | Number of Elements | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 40 | QRLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 41 | QRTRQT | Quantity Available | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 42 | QRUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 43 | QRJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 44 | QRPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 45 | QRUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 46 | QRTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |