| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | CRDOC0 | Document | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | CRLINN | Line Number | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 3 | CRDOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 4 | CRDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 5 | CRKCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 6 | CRSFX | Document Pay Item | String | Generic Edit | 3 | 0 | Allow NULL? |
| 7 | CRDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 8 | CRDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 9 | CRKCOO | Order Company (Order Number) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 10 | CRGUI | Government Uniform Invoice Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 11 | CRAEXP | Amount - Extended Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 12 | CRCRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 13 | CRCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 14 | CRCRDC | Currency Code - To | String | Generic Edit | 3 | 0 | Allow NULL? |
| 15 | CRRCDS | Status - Record | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 16 | CRUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 17 | CRPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 18 | CRUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 19 | CRUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 20 | CRJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 21 | CRIVD | Date - Invoice | Date | Generic Edit | 6 | 0 | |
| 22 | CRDIVJ | Date - Invoice - Julian | Date | Generic Edit | 6 | 0 | |
| 23 | CRC75CBNK | Customer Bank Account Number | String | Generic Edit | 50 | 0 | Allow NULL? |
| 24 | CRDL01 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 25 | CRUPRC | Amount - Price per Unit | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 26 | CRAR1 | Phone Prefix | String | Generic Edit | 6 | 0 | Allow NULL? |
| 27 | CRPH1 | Phone Number | String | Generic Edit | 20 | 0 | Allow NULL? |
| 28 | CRADD1 | Address Line 1 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 29 | CRC75STCI | Select to cancel invoice | Character | Generic Edit | 1 | 0 | Allow NULL? |
