| 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 | SZHBMCUS | Community | String | Generic Edit | 12 | 0 | Allow NULL? |
| 15 | SZHBLOT | Lot Number | String | Generic Edit | 4 | 0 | Allow NULL? |
| 16 | SZCSSEQ | Sequence - Current Sales | String | Generic Edit | 3 | 0 | Allow NULL? |
| 17 | SZACTVSEQ | Active Sales Sequence | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 18 | SZMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 19 | SZHBAREA | HomeBuilder Area ID | String | UDC (00 05) | 3 | 0 | Allow NULL? |
| 20 | SZCPHASE | Phase | String | Generic Edit | 3 | 0 | Allow NULL? |
| 21 | SZBYR | Buyer Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 22 | SZMLTBYR | Multiple Buyers | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 23 | SZHBPLAN | Plan Number | String | Generic Edit | 4 | 0 | Allow NULL? |
| 24 | SZHBELEV | Elevation | String | Generic Edit | 3 | 0 | Allow NULL? |
| 25 | SZSWING | Swing | Character | UDC (44H2 SW) | 1 | 0 | Allow NULL? |
| 26 | SZSALLST | Sales Activity Code - Last | String | UDC (44H0 RL) | 3 | 0 | Allow NULL? |
| 27 | SZSALNXT | Sales Activity Code - Next | String | UDC (44H0 RL) | 3 | 0 | Allow NULL? |
| 28 | SZDCG | Date - Status Changed | Date | Generic Edit | 6 | 0 | |
| 29 | SZCONACT | Sold at Construction Activity | String | UDC (44H0 RL) | 3 | 0 | Allow NULL? |
| 30 | SZHBSCS | Sales Contract Status | String | UDC (44H5 ST) | 3 | 0 | Allow NULL? |
| 31 | SZSDJ | Sales Date (Julian) | Date | Generic Edit | 6 | 0 | |
| 32 | SZSRPDJ | Sale Reported Date (Julian) | Date | Generic Edit | 6 | 0 | |
| 33 | SZSRDJ | Sale Ratified Date (Julian) | Date | Generic Edit | 6 | 0 | |
| 34 | SZCAPRVL | Credit Approval Date (Julian) | Date | Generic Edit | 6 | 0 | |
| 35 | SZECDJ | Projected Close Date (Julian) | Date | Generic Edit | 6 | 0 | |
| 36 | SZCDJ | Close Date (Julian) | Date | Generic Edit | 6 | 0 | |
| 37 | SZEDJ | Cancel Date (Julian) | Date | Generic Edit | 6 | 0 | |
| 38 | SZCSRCD | Cancel Sale Reason Code | String | UDC (44H5 CS) | 3 | 0 | Allow NULL? |
| 39 | SZCSN1 | Cancel Sale Note 1 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 40 | SZCSN2 | Cancel Sale Note 2 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 41 | SZCSN3 | Cancel Sale Note 3 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 42 | SZBHPRICE | Amount - Base House Sales Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 43 | SZLOTPREM | Amount - Lot Premium | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 44 | SZINCA1 | Amount - Incentive 1 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 45 | SZINCA2 | Amount - Incentive 2 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 46 | SZINCA3 | Amount - Incentive 3 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 47 | SZUPG | Amount - Upgrade | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 48 | SZNETBP | Amount - Net Base Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 49 | SZOPRV1 | Amount - Option Revenue 1 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 50 | SZOPRV2 | Amount - Option Revenue 2 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 51 | SZOPRV3 | Amount - Option Revenue 3 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 52 | SZOPRV4 | Amount - Option Revenue 4 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 53 | SZOPRV5 | Amount - Option Revenue 5 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 54 | SZOPRV6 | Amount - Option Revenue 6 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 55 | SZOPRV7 | Amount - Option Revenue 7 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 56 | SZOPRV8 | Amount - Option Revenue 8 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 57 | SZOPRV9 | Amount - Option Revenue 9 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 58 | SZOPINCA | Amount - Option Incentive | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 59 | SZNETOPT | Amount - Net Option Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 60 | SZTOTSAL | Amount - Total Sales Price | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 61 | SZANSM01 | Address Number - Sales Master 1 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 62 | SZANSM02 | Address Number - Sales Master 2 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 63 | SZANSM03 | Address Number - Sales Master 3 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 64 | SZANSM04 | Address Number - Sales Master 4 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 65 | SZANSM05 | Address Number - Sales Master 5 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 66 | SZANSM06 | Address Number - Sales Master 6 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 67 | SZANSM07 | Address Number - Sales Master 7 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 68 | SZANSM08 | Address Number - Sales Master 8 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 69 | SZANSM09 | Address Number - Sales Master 9 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 70 | SZANSM10 | Address Number - Sales Master 10 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 71 | SZCMPCT1 | Commission Percentage 1 | Numeric | Generic Edit | 5 | 3 | Allow NULL? |
| 72 | SZCMPCT2 | Commission Percentage 2 | Numeric | Generic Edit | 5 | 3 | Allow NULL? |
| 73 | SZCMPCT3 | Commission Percentage 3 | Numeric | Generic Edit | 5 | 3 | Allow NULL? |
| 74 | SZCMPCT4 | Commission Percentage 4 | Numeric | Generic Edit | 5 | 3 | Allow NULL? |
| 75 | SZCMPCT5 | Commission Percentage 5 | Numeric | Generic Edit | 5 | 3 | Allow NULL? |
| 76 | SZCMPCT6 | Commission Percentage 6 | Numeric | Generic Edit | 5 | 3 | Allow NULL? |
| 77 | SZCMPCT7 | Commission Percentage 7 | Numeric | Generic Edit | 5 | 3 | Allow NULL? |
| 78 | SZCMPCT8 | Commission Percentage 8 | Numeric | Generic Edit | 5 | 3 | Allow NULL? |
| 79 | SZCMPCT9 | Commission Percentage 9 | Numeric | Generic Edit | 5 | 3 | Allow NULL? |
| 80 | SZCMPCT10 | Commission Percentage 10 | Numeric | Generic Edit | 5 | 3 | Allow NULL? |
| 81 | SZCM1 | Amount - Commission 1 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 82 | SZCM2 | Amount - Commission 2 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 83 | SZCM3 | Amount - Commission 3 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 84 | SZCM4 | Amount - Commission 4 | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 85 | SZCM5 | Amount - Commission 5 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 86 | SZCM6 | Amount - Commission 6 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 87 | SZCM7 | Amount - Commission 7 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 88 | SZCM8 | Amount - Commission 8 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 89 | SZCM9 | Amount - Commission 9 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 90 | SZCM10 | Amount - Commission 10 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 91 | SZLDR | Lender Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 92 | SZLOANNUM | Loan Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 93 | SZLOANTYP | Loan Type | String | UDC (44H5 LT) | 10 | 0 | Allow NULL? |
| 94 | SZMGA | Mortage_Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 95 | SZINRTE | Interest Rate | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 96 | SZINRLCK | Interest Rate Lock Date | Date | Generic Edit | 6 | 0 | |
| 97 | SZPXD | Points expiration date | Date | Generic Edit | 6 | 0 | |
| 98 | SZDNPT | Down Payment | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 99 | SZEMD | Earnest Money Deposit | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 100 | SZDTKN | Amount - Deposit Taken | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 101 | SZMAD | Mortgage Approval Date (julian) | Date | Generic Edit | 6 | 0 | |
| 102 | SZTAD | Title Appt. Date | Date | Generic Edit | 6 | 0 | |
| 103 | SZLADJ | Loan Application Date | Date | Generic Edit | 6 | 0 | |
| 104 | SZCTG | Contingent Sale Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 105 | SZCTGS | Contingent Sale Type | String | Generic Edit | 8 | 0 | Allow NULL? |
| 106 | SZPTX | Property Text | String | Generic Edit | 30 | 0 | Allow NULL? |
| 107 | SZCTGJ | Contingency Effective Date | Date | Generic Edit | 6 | 0 | |
| 108 | SZLRD | Listing Receipt Date | Date | Generic Edit | 6 | 0 | |
| 109 | SZCCNVD | Contingency Converted Date | Date | Generic Edit | 6 | 0 | |
| 110 | SZCLJ | Conversion Loss Date | Date | Generic Edit | 6 | 0 | |
| 111 | SZCXD | Contingency Expiration Date | Date | Generic Edit | 6 | 0 | |
| 112 | SZCRD | Contingency Release Date | Date | Generic Edit | 6 | 0 | |
| 113 | SZCN1 | Contingent Note 1 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 114 | SZCN2 | Contingent Note 2 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 115 | SZLAG | Listing Agent | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 116 | SZDCAPPT | Design Center Appointment | Date | Generic Edit | 6 | 0 | |
| 117 | SZDCSTM | Design Center Appointment Time | String | Generic Edit | 8 | 0 | Allow NULL? |
| 118 | SZDCADT | Actual Design Center Appointment | Date | Generic Edit | 6 | 0 | |
| 119 | SZCLT | Change Lot | String | Generic Edit | 4 | 0 | Allow NULL? |
| 120 | SZTEDJ | Transfer Buyer Date (Julian) | Date | Generic Edit | 6 | 0 | |
| 121 | SZTIDJ | Transfer Buyer In Date (Julian) | Date | Generic Edit | 6 | 0 | |
| 122 | SZTLN1 | Transfer Lot Note 1 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 123 | SZTLN2 | Transfer Lot Note 2 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 124 | SZTLN3 | Transfer Lot Note 3 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 125 | SZBSWD | Buyer Scheduled Walkthru Date | Date | Generic Edit | 6 | 0 | |
| 126 | SZBSWT | Buyer Scheduled Walkthru Time | String | Generic Edit | 8 | 0 | Allow NULL? |
| 127 | SZBAWD | Buyer Actual Walkthru Date | Date | Generic Edit | 6 | 0 | |
| 128 | SZUSD1 | User Date 1 | Date | Generic Edit | 6 | 0 | |
| 129 | SZUSD2 | User Date 2 | Date | Generic Edit | 6 | 0 | |
| 130 | SZUSD3 | User Date 3 | Date | Generic Edit | 6 | 0 | |
| 131 | SZUSD4 | User Date 4 | Date | Generic Edit | 6 | 0 | |
| 132 | SZUSD5 | User Date 5 | Date | Generic Edit | 6 | 0 | |
| 133 | SZUSD6 | User Date 6 | Date | Generic Edit | 6 | 0 | |
| 134 | SZUSD7 | User Date 7 | Date | Generic Edit | 6 | 0 | |
| 135 | SZUSD8 | User Date 8 | Date | Generic Edit | 6 | 0 | |
| 136 | SZUSD9 | User Date 9 | Date | Generic Edit | 6 | 0 | |
| 137 | SZUSD10 | User Date 10 | Date | Generic Edit | 6 | 0 | |
| 138 | SZUSD11 | User Date 11 | Date | Generic Edit | 6 | 0 | |
| 139 | SZUSD12 | User Date 12 | Date | Generic Edit | 6 | 0 | |
| 140 | SZUSD13 | User Date 13 | Date | Generic Edit | 6 | 0 | |
| 141 | SZUSD14 | User Date 14 | Date | Generic Edit | 6 | 0 | |
| 142 | SZUSD15 | User Date 15 | Date | Generic Edit | 6 | 0 | |
| 143 | SZUSD16 | User Date 16 | Date | Generic Edit | 6 | 0 | |
| 144 | SZUSD17 | User Date 17 | Date | Generic Edit | 6 | 0 | |
| 145 | SZUSD18 | User Date 18 | Date | Generic Edit | 6 | 0 | |
| 146 | SZUSD19 | User Date 19 | Date | Generic Edit | 6 | 0 | |
| 147 | SZUSD20 | User Date 20 | Date | Generic Edit | 6 | 0 | |
| 148 | SZUAMT01 | User Defined Amount 01 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 149 | SZUAMT02 | User Defined Amount 02 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 150 | SZUAMT03 | User Defined Amount 03 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 151 | SZUAMT04 | User Defined Amount 04 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 152 | SZUAMT05 | User Defined Amount 05 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 153 | SZUAMT06 | User Defined Amount 06 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 154 | SZUAMT07 | User Defined Amount 07 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 155 | SZUAMT08 | User Defined Amount 08 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 156 | SZUAMT09 | User Defined Amount 09 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 157 | SZUAMT10 | User Defined Amount 10 | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 158 | SZSMC01 | Sales Category Code 1 | String | UDC (44H5 01) | 3 | 0 | Allow NULL? |
| 159 | SZSMC02 | Sales Category Code 2 | String | UDC (44H5 02) | 3 | 0 | Allow NULL? |
| 160 | SZSMC03 | Sales Category Code 3 | String | UDC (44H5 03) | 3 | 0 | Allow NULL? |
| 161 | SZSMC04 | Sales Category Code 4 | String | UDC (44H5 04) | 3 | 0 | Allow NULL? |
| 162 | SZSMC05 | Sales Category Code 5 | String | UDC (44H5 05) | 3 | 0 | Allow NULL? |
| 163 | SZSMC06 | Sales Category Code 6 | String | UDC (44H5 06) | 3 | 0 | Allow NULL? |
| 164 | SZSMC07 | Sales Category Code 7 | String | UDC (44H5 07) | 3 | 0 | Allow NULL? |
| 165 | SZSMC08 | Sales Category Code 8 | String | UDC (44H5 08) | 3 | 0 | Allow NULL? |
| 166 | SZSMC09 | Sales Category Code 9 | String | UDC (44H5 09) | 3 | 0 | Allow NULL? |
| 167 | SZSMC10 | Sales Category Code 10 | String | UDC (44H5 10) | 3 | 0 | Allow NULL? |
| 168 | SZUSAN01 | Address Number User Defined 01 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 169 | SZUSAN02 | Address Number User Defined 02 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 170 | SZUSAN03 | Address Number User Defined 03 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 171 | SZUSAN04 | Address Number User Defined 04 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 172 | SZUSAN05 | Address Number User Defined 05 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 173 | SZHBST1 | HomeBuilder Status Code 1 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 174 | SZHBST2 | HomeBuilder Status Code 2 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 175 | SZHBST3 | HomeBuilder Status Code 3 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 176 | SZHBST4 | HomeBuilder Status Code 4 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 177 | SZHBST5 | HomeBuilder Status Code 5 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 178 | SZCRTU | Created by user | String | Generic Edit | 10 | 0 | Allow NULL? |
| 179 | SZCRTJ | Date - Created | Date | Generic Edit | 6 | 0 | |
| 180 | SZCRTT | Time - Created | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 181 | SZWRKSTNID | Original Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 182 | SZHBOPID | Original Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 183 | SZUPMB | Updated By - User | String | Generic Edit | 10 | 0 | Allow NULL? |
| 184 | SZUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 185 | SZUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 186 | SZJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 187 | SZPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |