| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | Z1EDUS | EDI - User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 2 | Z1EDBT | EDI - Batch Number | String | Generic Edit | 15 | 0 | Allow NULL? |
| 3 | Z1EDTN | EDI - Transaction Number | String | Generic Edit | 22 | 0 | Allow NULL? |
| 4 | Z1EDLN | EDI - Line Number | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 5 | Z1EDCT | EDI - Document Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 6 | Z1TYTN | Type - Transaction | String | UDC (00 TT) | 8 | 0 | Allow NULL? |
| 7 | Z1EDFT | EDI - Translation Format | String | Generic Edit | 10 | 0 | Allow NULL? |
| 8 | Z1EDDT | EDI - Transmission Date | Date | Generic Edit | 6 | 0 | |
| 9 | Z1DRIN | Direction Indicator | Character | UDC (00 DN) | 1 | 0 | Allow NULL? |
| 10 | Z1EDDL | EDI - Detail Lines Processed | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 11 | Z1EDSP | EDI - Successfully Processed | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | Z1PNID | Trading Partner ID | String | Generic Edit | 15 | 0 | Allow NULL? |
| 13 | Z1TNAC | Transaction Action | String | UDC (00 TA) | 2 | 0 | Allow NULL? |
| 14 | Z1DOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 15 | Z1DCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 16 | Z1KCOO | Order Company (Order Number) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 17 | Z1SFXO | Order Suffix | String | Generic Edit | 3 | 0 | Allow NULL? |
| 18 | Z1LNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 19 | Z1OSEQ | Sequence Number | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 20 | Z1PA04 | Target Application | Character | UDC (40 TA) | 1 | 0 | Allow NULL? |
| 21 | Z1AST | Price Adjustment Name | String | UDC (40 TY) | 8 | 0 | Allow NULL? |
| 22 | Z1AGTY | AgreementType | String | UDC (45 AT) | 2 | 0 | Allow NULL? |
| 23 | Z1ANS8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 24 | Z1MCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 25 | Z1IGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 26 | Z1CGID | Customer Group Key ID | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 27 | Z1AN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 28 | Z1CPGP | Customer Price Group | String | UDC (40 PC) | 8 | 0 | Allow NULL? |
| 29 | Z1ITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 30 | Z1PRGR | Item Price Group | String | UDC (40 PI) | 8 | 0 | Allow NULL? |
| 31 | Z1CATN | Catalog | String | UDC (40 CN) | 8 | 0 | Allow NULL? |
| 32 | Z1CCF3 | Currency Code - From 3 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 33 | Z1CTYE | Claim Type Code | String | UDC (45 CT) | 2 | 0 | Allow NULL? |
| 34 | Z1CLMD | Claim Method | Character | UDC (45 CM) | 1 | 0 | Allow NULL? |
| 35 | Z1SCNT | Status Code - Next | String | UDC (45 SC) | 2 | 0 | Allow NULL? |
| 36 | Z1ACCS | Account Number - Cost of Goods Reduction | String | Generic Edit | 29 | 0 | Allow NULL? |
| 37 | Z1ACCA | Account Number - Claim Accrual | String | Generic Edit | 29 | 0 | Allow NULL? |
| 38 | Z1CLAD | Claim Amount - Domestic | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 39 | Z1CAF | Claim Amount - Foreign | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 40 | Z1CRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 41 | Z1BCRC | Currency Code - Base | String | Generic Edit | 3 | 0 | Allow NULL? |
| 42 | Z1CLNR | Claim Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 43 | Z1DESC | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 44 | Z1DOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 45 | Z1DCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 46 | Z1KCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 47 | Z1SFX | Document Pay Item | String | Generic Edit | 3 | 0 | Allow NULL? |
| 48 | Z1SFXE | Pay Item Extension Number | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 49 | Z1SDOC | Sales Document Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 50 | Z1SDCT | Sales Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 51 | Z1SKCO | Document Company (Sales Order) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 52 | Z1SFX0 | Document Pay Item | String | Generic Edit | 3 | 0 | Allow NULL? |
| 53 | Z1DOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 54 | Z1DCTM | Document Type - Matching | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 55 | Z1SCLM | Address Number - Send Claim To | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 56 | Z1ADDJ | Date - Actual Ship Date | Date | Generic Edit | 6 | 0 | |
| 57 | Z1CNFD | Date - Claim Notification | Date | Generic Edit | 6 | 0 | |
| 58 | Z1CSCD | Date - Last Claim Status Change | Date | Generic Edit | 6 | 0 | |
| 59 | Z1DSC1 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 60 | Z1RPER | Person Responsible | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 61 | Z1UOM | Unit of Measure as Input | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 62 | Z1SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 63 | Z1QYCL | Units - Claimed Quantity | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 64 | Z1CLRR | Claim Reject Reason Code | String | UDC (45 RR) | 2 | 0 | Allow NULL? |
| 65 | Z1BN01 | Batch Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 66 | Z1BTY1 | Batch Type1 | String | UDC (98 IT) | 2 | 0 | Allow NULL? |
| 67 | Z1SLSP | Salesperson | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 68 | Z1ABR1 | Managerial Analysis Code 1 | String | Generic Edit | 12 | 0 | Allow NULL? |
| 69 | Z1ABR2 | Managerial Analysis Code 2 | String | Generic Edit | 12 | 0 | Allow NULL? |
| 70 | Z1ABR3 | Managerial Analysis Code 3 | String | Generic Edit | 12 | 0 | Allow NULL? |
| 71 | Z1ABR4 | Managerial Analysis Code 4 | String | Generic Edit | 12 | 0 | Allow NULL? |
| 72 | Z1ABT1 | Managerial Analysis Type 1 | Character | UDC | 1 | 0 | Allow NULL? |
| 73 | Z1ABT2 | Managerial Analysis Type 2 | Character | UDC | 1 | 0 | Allow NULL? |
| 74 | Z1ABT3 | Managerial Analysis Type 3 | Character | UDC | 1 | 0 | Allow NULL? |
| 75 | Z1ABT4 | Managerial Analysis Type 4 | Character | UDC | 1 | 0 | Allow NULL? |
| 76 | Z1UM | Unit of Measure | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 77 | Z1SBL | Subledger - G/L | String | Generic Edit | 8 | 0 | Allow NULL? |
| 78 | Z1SBLT | Subledger Type | Character | UDC (00 ST) | 1 | 0 | Allow NULL? |
| 79 | Z1ANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 | Allow NULL? |
| 80 | Z1DAMD | Amount - Debit per Unit | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 81 | Z1DAMF | Amount - Debit Foreign per Unit | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 82 | Z1EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 | Allow NULL? |
| 83 | Z1CO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 84 | Z1FLIT | Item Number - Flex Accounting | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 85 | Z1ICU | Batch Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 86 | Z1ICUT | Batch Type | String | UDC (98 IT) | 2 | 0 | Allow NULL? |
| 87 | Z1DE01 | Claims 01 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 88 | Z1DE02 | Claims 02 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 89 | Z1DE03 | Claims 03 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 90 | Z1DE04 | Claims 04 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 91 | Z1DE05 | Claims 05 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 92 | Z1URCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 93 | Z1URDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 94 | Z1URAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 95 | Z1URAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 96 | Z1URRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 97 | Z1USER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 98 | Z1PID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 99 | Z1JOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 100 | Z1UPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 101 | Z1TDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 102 | Z1EDOC | EDI - Document Number | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 103 | Z1TPUR | Transaction Set Purpose | String | UDC (47 PU) | 2 | 0 | Allow NULL? |
| 104 | Z1CITM | Item Number - Customer/Supplier | String | Generic Edit | 25 | 0 | Allow NULL? |
| 105 | Z1EDST | EDI - Transaction Set Number | String | UDC (40 ST) | 6 | 0 | Allow NULL? |
| 106 | Z1IVD | Date - Invoice | Date | Generic Edit | 6 | 0 | |
| 107 | Z1ASN | Price and Adjustment Schedule | String | UDC (40 AS) | 8 | 0 | Allow NULL? |
| 108 | Z1MNQ | Quantity - From | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 109 | Z1LEDG | Cost Method | String | UDC (40 CM) | 2 | 0 | Allow NULL? |
| 110 | Z1UPRC | Amount - Price per Unit | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 111 | Z1FUP | Amount - Foreign Price per Unit | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 112 | Z1GLC | G/L Offset | String | Generic Edit | 4 | 0 | Allow NULL? |
| 113 | Z1FVMD | Factor Value Method | Character | UDC (40 BC) | 1 | 0 | Allow NULL? |
| 114 | Z1FVTR | Factor Value | Numeric | Generic Edit | 15 | 5 | Allow NULL? |
| 115 | Z1QYAP | Units - Quantity Applied | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 116 | Z1ACNT | Adjustment Control Code | Character | UDC (40 CO) | 1 | 0 | Allow NULL? |
| 117 | Z1EFTJ | Date - Effective | Date | Generic Edit | 6 | 0 | |
| 118 | Z1EXDJ | Date - Expired | Date | Generic Edit | 6 | 0 | |
| 119 | Z1BDCS | Amount - Based On Cost | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 120 | Z1BDCL | Based On Cost Lock Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 121 | Z1FRMN | Price Formula Name | String | UDC (40 FM) | 10 | 0 | Allow NULL? |
| 122 | Z1MQYQ | Units - Minimum Quantity to Qualify | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 123 | Z1MAQY | Units - Maximum Authorized Quantity | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 124 | Z1QYOA | Units - Quantity Open/Available | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 125 | Z1AGNB | Agreement Number - Supplier | String | Generic Edit | 30 | 0 | Allow NULL? |
| 126 | Z1OKCO | Document Company (Original Order) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 127 | Z1OORN | Original Order Number | String | Generic Edit | 8 | 0 | Allow NULL? |
| 128 | Z1OCTO | Original Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 129 | Z1OGNO | Original Line Number | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 130 | Z1RORN | Related PO/SO/WO Number | String | Generic Edit | 8 | 0 | Allow NULL? |
| 131 | Z1RCTO | Related PO/SO/WO Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 132 | Z1RLLN | Related PO/SO Line Number | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 133 | Z1SHAN | Address Number - Ship To | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 134 | Z1PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 135 | Z1TRDJ | Date - Order/Transaction | Date | Generic Edit | 6 | 0 | |
| 136 | Z1LITM | 2nd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 137 | Z1AITM | 3rd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 138 | Z1RLIT | Item Number - Related (Kit) | String | Generic Edit | 8 | 0 | Allow NULL? |
| 139 | Z1KTLN | Kit Master Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 140 | Z1CPNT | Component Line Number | Numeric | Generic Edit | 4 | 1 | Allow NULL? |
| 141 | Z1RKIT | Related Kit Component | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 142 | Z1KTP | Number of Component Per Parent | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 143 | Z1AEXP | Amount - Extended Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 144 | Z1UNCS | Amount - Unit Cost | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 145 | Z1ECST | Amount - Extended Cost | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 146 | Z1ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 147 | Z1ODCT | Document Type - Original | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 148 | Z1OKC | Document Company - Original | String | Generic Edit | 5 | 0 | Allow NULL? |
| 149 | Z1TAX1 | Sales Taxable (Y/N) | Character | UDC (H00 TV) | 1 | 0 | Allow NULL? |
| 150 | Z1TXA1 | Tax Rate/Area | String | Generic Edit | 10 | 0 | Allow NULL? |
| 151 | Z1EXR1 | Tax Expl Code 1 | String | UDC (00 EX) | 2 | 0 | Allow NULL? |
| 152 | Z1VEND | Primary / Last Supplier Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 153 | Z1UOM1 | Unit of Measure - Primary | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 154 | Z1CRR | Currency Conversion Rate - Spot Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 155 | Z1FPRC | Amount - List Price per Unit | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 156 | Z1FEA | Amount - Foreign Extended Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 157 | Z1FUC | Amount - Foreign Unit Cost | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 158 | Z1FEC | Amount - Foreign Extended Cost | Numeric | Generic Edit | 15 | 2 | Allow NULL? |