| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | SYEDTY | Type Record | Character | UDC (00 RD) | 1 | 0 | Allow NULL? |
| 2 | SYEDSQ | Record Sequence | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 3 | SYEKCO | Company - Key (EDI - Document Key Co) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 4 | SYEDOC | EDI - Document Number | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 5 | SYEDCT | EDI - Document Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 6 | SYEDLN | EDI - Line Number | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 7 | SYEDST | EDI - Transaction Set Number | String | UDC (40 ST) | 6 | 0 | Allow NULL? |
| 8 | SYEDFT | EDI - Translation Format | String | Generic Edit | 10 | 0 | Allow NULL? |
| 9 | SYEDDT | EDI - Transmission Date | Date | Generic Edit | 6 | 0 | |
| 10 | SYEDER | EDI - Send/Receive Indicator | Character | UDC (H00 ED) | 1 | 0 | Allow NULL? |
| 11 | SYEDDL | EDI - Detail Lines Processed | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 12 | SYEDSP | EDI - Successfully Processed | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | SYEDBT | EDI - Batch Number | String | Generic Edit | 15 | 0 | Allow NULL? |
| 14 | SYPNID | Trading Partner ID | String | Generic Edit | 15 | 0 | Allow NULL? |
| 15 | SYCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 16 | SYKCOO | Order Company (Order Number) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 17 | SYDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 18 | SYDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 19 | SYSFXO | Order Suffix | String | Generic Edit | 3 | 0 | Allow NULL? |
| 20 | SYKCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 21 | SYDOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 22 | SYDCTV | Document Type - Voucher Only | String | UDC (00 DV) | 2 | 0 | Allow NULL? |
| 23 | SYAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 24 | SYVINV | Supplier Invoice Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 25 | SYDGJ | Date - For G/L (and Voucher) - Julian | Date | Generic Edit | 6 | 0 | |
| 26 | SYDIVJ | Date - Invoice - Julian | Date | Generic Edit | 6 | 0 | |
| 27 | SYSHAN | Address Number - Ship To | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 28 | SYPA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 29 | SYAN8J | Address Number - Alternate Payee | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 30 | SYSNTO | Address Number - Approver | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 31 | SYCRRM | Currency Mode-Foreign or Domestic Entry | Character | UDC (H00 CY) | 1 | 0 | Allow NULL? |
| 32 | SYCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 33 | SYCRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 34 | SYEXR1 | Tax Expl Code 1 | String | UDC (00 EX) | 2 | 0 | Allow NULL? |
| 35 | SYTXA1 | Tax Rate/Area | String | Generic Edit | 10 | 0 | Allow NULL? |
| 36 | SYPCR | Percent Retainage | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 37 | SYPTC | Payment Terms Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 38 | SYPYIN | Payment Instrument | Character | UDC (00 PY) | 1 | 0 | Allow NULL? |
| 39 | SYPTD | Description - Payment Terms | String | Generic Edit | 30 | 0 | Allow NULL? |
| 40 | SYPEFJ | Date - Price Effective Date | Date | Generic Edit | 6 | 0 | |
| 41 | SYASN | Price and Adjustment Schedule | String | UDC (40 AS) | 8 | 0 | Allow NULL? |
| 42 | SYATXT | Associated Text | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 43 | SYAVCH | Code - Evaluated Receipt Settlement | Character | UDC (40 ER) | 1 | 0 | Allow NULL? |
| 44 | SYCRMD | Send Method | Character | UDC (00 SM) | 1 | 0 | Allow NULL? |
| 45 | SYCORD | Change Order Number | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 46 | SYDCP | Discount % - Payment Terms | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 47 | SYDCD | Discount Days | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 48 | SYNDTP | Net Days to Pay | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 49 | SYDDU | Date - Due | Date | Generic Edit | 6 | 0 | |
| 50 | SYDDJ | Date - Net Due | Date | Generic Edit | 6 | 0 | |
| 51 | SYRMK | Name - Remark | String | Generic Edit | 30 | 0 | Allow NULL? |
| 52 | SYVRMK | Supplier Remark | String | Generic Edit | 30 | 0 | Allow NULL? |
| 53 | SYVR01 | Reference | String | Generic Edit | 25 | 0 | Allow NULL? |
| 54 | SYVR02 | Reference 2 | String | Generic Edit | 25 | 0 | Allow NULL? |
| 55 | SYURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 56 | SYURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 57 | SYURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 58 | SYURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 59 | SYURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 60 | SYTORG | Transaction Originator | String | Generic Edit | 10 | 0 | Allow NULL? |
| 61 | SYUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 62 | SYPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 63 | SYJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 64 | SYUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 65 | SYTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 66 | SYGAN8 | Global Location Number | Numeric | Generic Edit | 13 | 0 | Allow NULL? |
| 67 | SYGSHAN | Ship To GLN | Numeric | Generic Edit | 13 | 0 | Allow NULL? |
| 68 | SYGPA8 | Parent Address GLN | Numeric | Generic Edit | 13 | 0 | Allow NULL? |
| 69 | SYGAN8J | Alternate Payee GLN | Numeric | Generic Edit | 13 | 0 | Allow NULL? |
