| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | SZEDUS | EDI - User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 2 | SZEDBT | EDI - Batch Number | String | Generic Edit | 15 | 0 | Allow NULL? |
| 3 | SZEDTN | EDI - Transaction Number | String | Generic Edit | 22 | 0 | Allow NULL? |
| 4 | SZEDLN | EDI - Line Number | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 5 | SZEDCT | EDI - Document Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 6 | SZTYTN | Type - Transaction | String | UDC (00 TT) | 8 | 0 | Allow NULL? |
| 7 | SZEDFT | EDI - Translation Format | String | Generic Edit | 10 | 0 | Allow NULL? |
| 8 | SZEDDT | EDI - Transmission Date | Date | Generic Edit | 6 | 0 | |
| 9 | SZDRIN | Direction Indicator | Character | UDC (00 DN) | 1 | 0 | Allow NULL? |
| 10 | SZEDDL | EDI - Detail Lines Processed | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 11 | SZEDSP | EDI - Successfully Processed | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | SZPNID | Trading Partner ID | String | Generic Edit | 15 | 0 | Allow NULL? |
| 13 | SZTNAC | Transaction Action | String | UDC (00 TA) | 2 | 0 | Allow NULL? |
| 14 | SZEDTY | Type Record | Character | UDC (00 RD) | 1 | 0 | Allow NULL? |
| 15 | SZEDSQ | Record Sequence | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 16 | SZEDTS | EDI - Transaction Set Number | String | Generic Edit | 6 | 0 | Allow NULL? |
| 17 | SZEDER | EDI - Send/Receive Indicator | Character | UDC (H00 ED) | 1 | 0 | Allow NULL? |
| 18 | SZEDTC | EDI - Transaction Action | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 19 | SZEDTR | EDI - Transaction Type | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 20 | SZEDGL | Batch File Create G/L Record | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 21 | SZEDDH | Batch File Discount Handling Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 22 | SZEDAN | User Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 23 | SZKCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 24 | SZDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 25 | SZDOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 26 | SZDGJ | Date - For G/L (and Voucher) - Julian | Date | Generic Edit | 6 | 0 | |
| 27 | SZJELN | Journal Entry Line Number | Numeric | Generic Edit | 7 | 0 | Allow NULL? |
| 28 | SZEXTL | Line Extension Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 29 | SZPOST | G/L Posted Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 30 | SZICU | Batch Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 31 | SZICUT | Batch Type | String | UDC (98 IT) | 2 | 0 | Allow NULL? |
| 32 | SZDICJ | Date - Batch (Julian) | Date | Generic Edit | 6 | 0 | |
| 33 | SZDSYJ | Date - Batch System Date | Date | Generic Edit | 6 | 0 | |
| 34 | SZTICU | Batch Time | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 35 | SZCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 36 | SZANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 | Allow NULL? |
| 37 | SZAM | Account Mode - G/L | Character | UDC (H09 AM) | 1 | 0 | Allow NULL? |
| 38 | SZAID | Account ID | String | Generic Edit | 8 | 0 | Allow NULL? |
| 39 | SZMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 40 | SZOBJ | Object Account | String | Generic Edit | 6 | 0 | Allow NULL? |
| 41 | SZSUB | Subsidiary | String | Generic Edit | 8 | 0 | Allow NULL? |
| 42 | SZSBL | Subledger - G/L | String | Generic Edit | 8 | 0 | Allow NULL? |
| 43 | SZSBLT | Subledger Type | Character | UDC (00 ST) | 1 | 0 | Allow NULL? |
| 44 | SZLT | Ledger Types | String | UDC (09 LT) | 2 | 0 | Allow NULL? |
| 45 | SZPN | Period Number - General Ledger | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 46 | SZCTRY | Century | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 47 | SZFY | Fiscal Year | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 48 | SZFQ | Fiscal Quarter (Obsolete) | String | UDC (H09 FQ) | 4 | 0 | Allow NULL? |
| 49 | SZCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 50 | SZCRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 51 | SZHCRR | Historical Currency Conversion Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 52 | SZHDGJ | Historical Date - Julian | Date | Generic Edit | 6 | 0 | |
| 53 | SZAA | Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 54 | SZU | Units | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 55 | SZUM | Unit of Measure | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 56 | SZGLC | G/L Offset | String | Generic Edit | 4 | 0 | Allow NULL? |
| 57 | SZRE | Reverse or Void (R/V) | Character | UDC (H09 RE) | 1 | 0 | Allow NULL? |
| 58 | SZEXA | Name - Alpha Explanation | String | Generic Edit | 30 | 0 | Allow NULL? |
| 59 | SZEXR | Name - Remark Explanation | String | Generic Edit | 30 | 0 | Allow NULL? |
| 60 | SZR1 | Reference 1 - JE Voucher Invoice etc. | String | Generic Edit | 8 | 0 | Allow NULL? |
| 61 | SZR2 | Reference 2 | String | Generic Edit | 8 | 0 | Allow NULL? |
| 62 | SZR3 | Reference 3 - Account Reconciliation | String | Generic Edit | 8 | 0 | Allow NULL? |
| 63 | SZSFX | Document Pay Item | String | Generic Edit | 3 | 0 | Allow NULL? |
| 64 | SZODOC | Document - Original | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 65 | SZODCT | Document Type - Original | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 66 | SZOSFX | Document Pay Item - Original | String | Generic Edit | 3 | 0 | Allow NULL? |
| 67 | SZPKCO | Document Company (Purchase Order) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 68 | SZOKCO | Document Company (Original Order) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 69 | SZPDCT | Document Type - Purchase Order | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 70 | SZAN8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 71 | SZCN | Payment Number | String | Generic Edit | 8 | 0 | Allow NULL? |
| 72 | SZDKJ | Date - Check - Julian | Date | Generic Edit | 6 | 0 | |
| 73 | SZDKC | Date - Check Cleared | Date | Generic Edit | 6 | 0 | |
| 74 | SZASID | Serial Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 75 | SZBRE | Batch Rear End Posted Code | Character | UDC (09 BR) | 1 | 0 | Allow NULL? |
| 76 | SZRCND | Reconciled Code | Character | UDC (09 RC) | 1 | 0 | Allow NULL? |
| 77 | SZSUMM | Summarized Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 78 | SZPRGE | Purge Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 79 | SZTNN | Flag for 1099 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 80 | SZALT1 | G/L Posting Code - Alternate 1 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 81 | SZALT2 | G/L Posting Code - Alternate 2 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 82 | SZALT3 | G/L Posting Code - Alternate 3 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 83 | SZALT4 | G/L Posting Code - Alternate 4 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 84 | SZALT5 | G/L Posting Code - Alternate 5 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 85 | SZALT6 | G/L Posting Code - Cash Basis Acct | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 86 | SZALT7 | Commitment Relief Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 87 | SZALT8 | Billing Control | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 88 | SZALT9 | Currency Update | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 89 | SZALT0 | G/L Posting Code - Alternate 0 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 90 | SZALTT | G/L Posting Code - Alternate T | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 91 | SZALTU | G/L Posting Code - Alternate U | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 92 | SZALTV | Stocked Inventory Commitment | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 93 | SZALTW | G/L Posting Code - Alternate W | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 94 | SZALTX | Consumption Tax Cross Reference | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 95 | SZALTZ | G/L Posting Code - Account Debit Balance | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 96 | SZDLNA | Delete Not Allowed | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 97 | SZCFF1 | Client Free Form - Alternate 1 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 98 | SZCFF2 | Client Free Form - Alternate 2 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 99 | SZASM | Lease Cost Ledger Posted Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 100 | SZBC | Bill Code | Character | UDC (98 BC) | 1 | 0 | Allow NULL? |
| 101 | SZVINV | Supplier Invoice Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 102 | SZIVD | Date - Invoice | Date | Generic Edit | 6 | 0 | |
| 103 | SZWR01 | Categories - Work Order 01 | String | UDC (00 W1) | 4 | 0 | Allow NULL? |
| 104 | SZPO | Purchase Order | String | Generic Edit | 8 | 0 | Allow NULL? |
| 105 | SZPSFX | Purchase Order Suffix | String | Generic Edit | 3 | 0 | Allow NULL? |
| 106 | SZDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 107 | SZLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 108 | SZWY | Fiscal Year - Weekly | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 109 | SZWN | Fiscal Period - Weekly | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 110 | SZFNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 111 | SZOPSQ | Sequence Number - Operations | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 112 | SZJBCD | Job Type (Craft) Code | String | UDC (06 G) | 6 | 0 | Allow NULL? |
| 113 | SZJBST | Job Step | String | UDC (06 GS) | 4 | 0 | Allow NULL? |
| 114 | SZHMCU | Business Unit - Home | String | Generic Edit | 12 | 0 | Allow NULL? |
| 115 | SZDOI | DOI Sub | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 116 | SZALID | Outsider Lease or Well ID | String | Generic Edit | 25 | 0 | Allow NULL? |
| 117 | SZALTY | ID Type | String | UDC (00 AL) | 2 | 0 | Allow NULL? |
| 118 | SZDSVJ | Date - Service/Tax | Date | Generic Edit | 6 | 0 | |
| 119 | SZREG# | Registration Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 120 | SZPYID | Payment ID (Internal) | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 121 | SZCRRM | Currency Mode-Foreign or Domestic Entry | Character | UDC (H00 CY) | 1 | 0 | Allow NULL? |
| 122 | SZACR | Amount - Currency | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 123 | SZCRDC | Currency Code - To | String | Generic Edit | 3 | 0 | Allow NULL? |
| 124 | SZPYIN | Payment Instrument | Character | UDC (00 PY) | 1 | 0 | Allow NULL? |
| 125 | SZURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 126 | SZURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 127 | SZURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 128 | SZURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 129 | SZURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 130 | SZTORG | Transaction Originator | String | Generic Edit | 10 | 0 | Allow NULL? |
| 131 | SZUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 132 | SZPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 133 | SZJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 134 | SZUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 135 | SZTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 136 | SZABR1 | Managerial Analysis Code 1 | String | Generic Edit | 12 | 0 | Allow NULL? |
| 137 | SZABR2 | Managerial Analysis Code 2 | String | Generic Edit | 12 | 0 | Allow NULL? |
| 138 | SZABR3 | Managerial Analysis Code 3 | String | Generic Edit | 12 | 0 | Allow NULL? |
| 139 | SZABR4 | Managerial Analysis Code 4 | String | Generic Edit | 12 | 0 | Allow NULL? |
| 140 | SZABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 | Allow NULL? |
| 141 | SZABT2 | Managerial Analysis Type 2 | Character | UDC | 1 | 0 | Allow NULL? |
| 142 | SZABT3 | Managerial Analysis Type 3 | Character | UDC | 1 | 0 | Allow NULL? |
| 143 | SZABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 | Allow NULL? |
| 144 | SZITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 145 | SZPM01 | Posting Code 1 - Managerial Accounting . | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 146 | SZPM02 | Posting Code 2 - Managerial Accounting . | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 147 | SZPM03 | Posting Code 3 - Managerial Accounting . | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 148 | SZPM04 | Posting Code 4 - Managerial Accounting . | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 149 | SZPM05 | Posting Code 5 - Managerial Accounting . | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 150 | SZPM06 | Posting Code 6 - Managerial Accounting . | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 151 | SZPM07 | Posting Code 7 - Managerial Accounting . | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 152 | SZPM08 | Posting Code 8 - Managerial Accounting . | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 153 | SZPM09 | Posting Code 9 - Managerial Accounting . | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 154 | SZPM10 | Posting Code 10- Managerial Accounting . | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 155 | SZBCRC | Currency Code - Base | String | Generic Edit | 3 | 0 | Allow NULL? |
| 156 | SZTXA1 | Tax Rate/Area | String | Generic Edit | 10 | 0 | Allow NULL? |
| 157 | SZEXR1 | Tax Expl Code 1 | String | UDC (00 EX) | 2 | 0 | Allow NULL? |
| 158 | SZTXITM | Tax - Short Item Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 159 | SZACTB | Activity-Based Costing Activity Code | String | Generic Edit | 10 | 0 | Allow NULL? |
| 160 | SZDLNID | DistributionLine Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 161 | SZCKNU | Receipt Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 162 | SZBUPC | Burdening Posted Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 163 | SZAHBU | Alternate Home Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 164 | SZEPGC | Employee Pool Grouping Code | String | UDC (00 12) | 3 | 0 | Allow NULL? |
| 165 | SZJPGC | Job Pool Grouping Code | String | UDC (00 12) | 3 | 0 | Allow NULL? |
| 166 | SZRC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 167 | SZSFXE | Pay Item Extension Number | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 168 | SZOFM | Auto Offset Method (S Y or B) | Character | Generic Edit | 1 | 0 | Allow NULL? |
