| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | VBELN | IS-M/SD: Billing Document | nvarchar | 10 | 0 | CHAR | (N' ') | No | JFRK | ISPVBELN | Allow NULL? |
| 3 | POSNR | IS-M: Billing Item | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | ISPPOSNR | Allow NULL? |
| 4 | FKIMG | Actual Invoiced Quantity | decimal | 13 | 3 | QUAN | ((0)) | No | | FKIMG | |
| 5 | VRKME | Sales unit | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | VRKME | Allow NULL? |
| 6 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | MEINS | Allow NULL? |
| 7 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | TGSB | GSBER | Allow NULL? |
| 8 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | PRSDT | Allow NULL? |
| 9 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | FBUDA | Allow NULL? |
| 10 | KURSK | Exchange Rate for Price Determination | decimal | 9 | 5 | DEC | ((0)) | No | | KURSK | |
| 11 | NETWR | Net value of the billing item in document currency | decimal | 15 | 2 | CURR | ((0)) | No | | NETWR_FP | |
| 12 | MATKL | Material Group | nvarchar | 9 | 0 | CHAR | (N' ') | No | T023 | MATKL | Allow NULL? |
| 13 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | No | TSPA | SPART | Allow NULL? |
| 14 | POSPA | IS-M: Item Number of Partner Segment | nvarchar | 6 | 0 | NUMC | (N'000000') | No | JFRP | ISPPOSPA | Allow NULL? |
| 15 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 16 | ALAND | Departure country (country from which the goods are sent) | nvarchar | 3 | 0 | CHAR | (N' ') | No | T005 | ALAND | Allow NULL? |
| 17 | WKREG | Region in which plant is located | nvarchar | 3 | 0 | CHAR | (N' ') | No | T005S | WKREG | Allow NULL? |
| 18 | WKCOU | County in which plant is located | nvarchar | 3 | 0 | CHAR | (N' ') | No | | WKCOU | Allow NULL? |
| 19 | WKCTY | City in which plant is located | nvarchar | 4 | 0 | CHAR | (N' ') | No | | WKCTY | Allow NULL? |
| 20 | TAXM1 | Tax classification material | char | 1 | 0 | CHAR | (N' ') | No | * | TAXM1 | Allow NULL? |
| 21 | TAXM2 | Tax classification 2 for material | char | 1 | 0 | CHAR | (N' ') | No | * | TAXM2 | Allow NULL? |
| 22 | TAXM3 | Tax classification 3 for material | char | 1 | 0 | CHAR | (N' ') | No | * | TAXM3 | Allow NULL? |
| 23 | TAXM4 | Tax Classification 4 Material | char | 1 | 0 | CHAR | (N' ') | No | * | TAXM4 | Allow NULL? |
| 24 | TAXM5 | Tax classification 5 for material | char | 1 | 0 | CHAR | (N' ') | No | * | TAXM5 | Allow NULL? |
| 25 | TAXM6 | Tax classification 6 for material | char | 1 | 0 | CHAR | (N' ') | No | * | TAXM6 | Allow NULL? |
| 26 | TAXM7 | Tax classification 7 for material | char | 1 | 0 | CHAR | (N' ') | No | * | TAXM7 | Allow NULL? |
| 27 | TAXM8 | Tax Classification 8 Material | char | 1 | 0 | CHAR | (N' ') | No | * | TAXM8 | Allow NULL? |
| 28 | TAXM9 | Tax Classification 9 Material | char | 1 | 0 | CHAR | (N' ') | No | * | TAXM9 | Allow NULL? |
| 29 | SKTOF | Cash discount indicator | char | 1 | 0 | CHAR | (N' ') | No | | SKTOF | Allow NULL? |
| 30 | SKFBP | Amount eligible for cash discount in document currency | decimal | 13 | 2 | CURR | ((0)) | No | | SKFBP | |
| 31 | SPARA | Division for order header | nvarchar | 2 | 0 | CHAR | (N' ') | No | TSPA | SPART_AK | Allow NULL? |
| 32 | SHKZG | Returns Item | char | 1 | 0 | CHAR | (N' ') | No | | SHKZG_VA | Allow NULL? |
| 33 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 34 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 35 | ERZET | Entry time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERZET | Allow NULL? |
| 36 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | CHAR | (N' ') | No | * | STAFO | Allow NULL? |
| 37 | WAVWR | Cost in document currency | decimal | 13 | 2 | CURR | ((0)) | No | | WAVWR | |
| 38 | KZWI1 | Subtotal 1 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | No | | KZWI1 | |
| 39 | KZWI2 | Subtotal 2 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | No | | KZWI2 | |
| 40 | KZWI3 | Subtotal 3 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | No | | KZWI3 | |
| 41 | KZWI4 | Subtotal 4 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | No | | KZWI4 | |
| 42 | KZWI5 | Subtotal 5 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | No | | KZWI5 | |
| 43 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | No | | KZWI6 | |
| 44 | STCUR | Exchange rate for statistics (Exch.rate at time of creation) | decimal | 9 | 5 | DEC | ((0)) | No | | STCUR_AP | |
| 45 | UVPRS | Incomplete with respect to pricing | char | 1 | 0 | CHAR | (N' ') | No | | UVPRS | Allow NULL? |
| 46 | TXJCD | Tax Jurisdiction | nvarchar | 15 | 0 | CHAR | (N' ') | No | * | TXJCD | Allow NULL? |
| 47 | ISPAUART | IS-M/SD: Sales Document Types | nvarchar | 4 | 0 | CHAR | (N' ') | No | TJAK | AUART_ISP | Allow NULL? |
| 48 | ISPAUAGRP | IS-M: Sales Document Type Grouping for Sales Order | char | 1 | 0 | CHAR | (N' ') | No | | ISPAUAGRP | Allow NULL? |
| 49 | ISPKOSTL_L | IS-M: Cost Center to be Charged | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | ISPKOSTL_L | Allow NULL? |
| 50 | ISPDRERZ | Publication | nvarchar | 8 | 0 | CHAR | (N' ') | No | JDTDRER | DRERZ | Allow NULL? |
| 51 | ISPPVA | Edition | nvarchar | 8 | 0 | CHAR | (N' ') | No | JDTPVA | PVA | Allow NULL? |
| 52 | ISPBEZ | Mix Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | JDTBEZTYP | BEZUGSTYP_JE_PVA | Allow NULL? |
| 53 | ISPLIFART | Delivery Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | TJV01 | LIEFERART | Allow NULL? |
| 54 | ISPDRUCK | IS-M: Plant (Printing Works) | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | ISPDRUCK | Allow NULL? |
| 55 | ISPGUTSCH | IS-M: Coupon Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | ISPGUTSCH | Allow NULL? |
| 56 | ISPXLOGO | Print Logo | char | 1 | 0 | CHAR | (N' ') | No | | XLOGO | Allow NULL? |
| 57 | ISPPVAKNTG | IS-M: Account Assignment Grouping for Edition | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVKM | ISPPVAKNTG | Allow NULL? |
| 58 | ISPPVAKONG | IS-M: Edition Condition Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | No | T178 | ISPPVAKONG | Allow NULL? |
| 59 | ISPPVABONG | IS-M: Bonus Grouping for Edition | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVBO | ISPPVABONG | Allow NULL? |
| 60 | ISPFKPER | Billing Frequency | nvarchar | 2 | 0 | CHAR | (N' ') | No | TJK01 | FKPER | Allow NULL? |
| 61 | ISPPERFK | Invoice dates (calendar identification) | nvarchar | 2 | 0 | CHAR | (N' ') | No | TFACD | PERFK | Allow NULL? |
| 62 | ISPZAHLW | Billing method | char | 1 | 0 | CHAR | (N' ') | No | | JZAHLW | Allow NULL? |
| 63 | ISPPOSEX | External Item Number (Purchase Order Item) | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | POSEX_ISP | Allow NULL? |
| 64 | ISPJPERIOD | IS-M: Periodic settlement | char | 1 | 0 | CHAR | (N' ') | No | | JPERIOD | Allow NULL? |
| 65 | ISPVBELN | IS-M/SD: Publishing Sales Order | nvarchar | 10 | 0 | CHAR | (N' ') | No | JKAK | AVNR | Allow NULL? |
| 66 | ISPPOSNR | Sales Order Item | nvarchar | 6 | 0 | NUMC | (N'000000') | No | JKAP | APNR | Allow NULL? |
| 67 | ISPETENR | Sales Order Schedule Line | nvarchar | 4 | 0 | NUMC | (N'0000') | No | JKEP | JAENR | Allow NULL? |
| 68 | ISPETEEX | IS-M: External Schedule Line Number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | ETEEX_ISP | Allow NULL? |
| 69 | ISPETART | Schedule Line Type for Internal Sales Order Schedule Line | nvarchar | 2 | 0 | CHAR | (N' ') | No | TJEP | ETART_ISP | Allow NULL? |
| 70 | ISPETMENGE | IS-M: Sales Order Schedule Line Quantity | decimal | 10 | 0 | QUAN | ((0)) | No | | ETMENGE | |
| 71 | ISPETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | ETMEINS | Allow NULL? |
| 72 | ISPETVOR | IS-M: Plus/Minus Sign for Sch. Line Quantity in Sales Order | char | 1 | 0 | CHAR | (N' ') | No | | ISPETVOR | Allow NULL? |
| 73 | ISPKPOSN | Condition item number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | KPOSN | Allow NULL? |
| 74 | ISPPRBAS | IS-M: Price Basis | char | 1 | 0 | CHAR | (N' ') | No | | ISPPRBAS | Allow NULL? |
| 75 | ISPPRSPER | IS-M: Price Frequency | nvarchar | 2 | 0 | CHAR | (N' ') | No | TJK03 | ISPPRSPER | Allow NULL? |
| 76 | ISPBZPERF | IS-M: Service Type for Billing | nvarchar | 5 | 0 | CHAR | (N' ') | No | TJD09 | ISPBZPERF | Allow NULL? |
| 77 | ISPPRSMLT | IS-M: Numerator in Conversion Factor for Frequencies | decimal | 5 | 0 | DEC | ((0)) | No | | ISPPRSMLT | |
| 78 | ISPPRSDIV | IS-M: Denominator for Frequency Conversion Factor | decimal | 5 | 0 | DEC | ((0)) | No | | ISPPRSDIV | |
| 79 | ISPAEART | IS-M: Order Change Type | char | 1 | 0 | CHAR | (N' ') | No | | ISPAEART | Allow NULL? |
| 80 | ISPANZET | IS-M: Number of Publication Dates | decimal | 5 | 0 | DEC | ((0)) | No | | ISPANZET | |
| 81 | ISPERSDAT | Publication Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ERSCHDAT | Allow NULL? |
| 82 | ISPWRBAKT | Sales Promotion | nvarchar | 8 | 0 | CHAR | (N' ') | No | TJWAK | WERBEAKT | Allow NULL? |
| 83 | ISPFAKVON | IS-M: Billing Period From | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | FAKVON | Allow NULL? |
| 84 | ISPFAKBIS | IS-M: Billing Period To | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | FAKBIS | Allow NULL? |
| 85 | ISPKONDA | Price group (customer) | nvarchar | 2 | 0 | CHAR | (N' ') | No | T188 | KONDA | Allow NULL? |
| 86 | ISPKDGRP | Customer group | nvarchar | 2 | 0 | CHAR | (N' ') | No | T151 | KDGRP | Allow NULL? |
| 87 | ISPPOART | Internal Item Type for Sales Order | nvarchar | 2 | 0 | CHAR | (N' ') | No | TJAP | POART_ISP | Allow NULL? |
| 88 | ISPPRSANTZ | IS-M: Numerator for proportional prices | decimal | 8 | 0 | DEC | ((0)) | No | | PRSANTZ | |
| 89 | ISPPRSANTN | IS-M: Denominator for proportional prices | decimal | 8 | 0 | DEC | ((0)) | No | | PRSANTN | |
| 90 | ISPPRSANZP | IS-M: Number of periods in billing period | decimal | 8 | 0 | DEC | ((0)) | No | | PRSANZP | |
| 91 | ISPBRTWR_P | IS-M: Gross Value in Document Currency | decimal | 15 | 2 | CURR | ((0)) | No | | ISPBRTWR | |
| 92 | ISPPRBAS_V | Price Basis for Shipping Costs | char | 1 | 0 | CHAR | (N' ') | No | | PRBAS_VK | Allow NULL? |
| 93 | ISPLAGRP_V | Country grouping for shipping costs | nvarchar | 2 | 0 | CHAR | (N' ') | No | TJG92 | LANDGRP_VK | Allow NULL? |
| 94 | ISPXFKKOMP | Indicator: Perform Billing in Full for Billing Period | char | 1 | 0 | CHAR | (N' ') | No | | XFKKOMP | Allow NULL? |
| 95 | ISPXFKENDE | Indicator: Billing at end of calculation | char | 1 | 0 | CHAR | (N' ') | No | | XFKENDE | Allow NULL? |
| 96 | ISPSFPOS | Separate billing document for order item | char | 1 | 0 | CHAR | (N' ') | No | | XSEPFKPOS | Allow NULL? |
| 97 | ISPXKOMPP | IS-M: Full period (billing) | char | 1 | 0 | CHAR | (N' ') | No | | XKOMPP | Allow NULL? |
| 98 | ISPVERSDAT | IS-M: Shipping Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | VRSNDDATUM | Allow NULL? |
| 99 | ISPLANDE | Current country being supplied | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | LANDE_ISP | Allow NULL? |
| 100 | ISPRKAUFNR | Order Number of RK Order for Account Assignment | nvarchar | 8 | 0 | CHAR | (N' ') | No | | J_RK_AUFNR | Allow NULL? |
| 101 | ISPRKPOSNR | Item Number of RK Order for Account Assignment | nvarchar | 2 | 0 | NUMC | (N'00') | No | | J_RK_POSNR | Allow NULL? |
| 102 | ISPCOAUFNR | Order number of internal CO order for account assignment | nvarchar | 12 | 0 | CHAR | (N' ') | No | AUFK | J_CO_AUFNR | Allow NULL? |
| 103 | ISPVAUSGB | Issue | nvarchar | 10 | 0 | CHAR | (N' ') | No | JDTVAUSGB | VAUSGB | Allow NULL? |
| 104 | ISPXFKBALF | IS-M: Billing based on delivery | char | 1 | 0 | CHAR | (N' ') | No | | XFKBASLIEF | Allow NULL? |
| 105 | ISPXFKBAAU | IS-M: Billing based on order | char | 1 | 0 | CHAR | (N' ') | No | | XFKBASAUFT | Allow NULL? |
| 106 | ISPVKBURZU | Sales office responsible | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | VKBURZUS | Allow NULL? |
| 107 | ISPXSTABGR | VAT to be accrued proportionally for payment in billing | char | 1 | 0 | CHAR | (N' ') | No | | JXMWSTABGR | Allow NULL? |
| 108 | ISPXIMMAT | Indicator: Proof of matriculation provided | char | 1 | 0 | CHAR | (N' ') | No | | XIMMATRIK | Allow NULL? |
| 109 | ISPIMMATD | Matriculation Certificate Valid To | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | IMMATDAT | Allow NULL? |
| 110 | ISPXFKRUEK | IS-M: Retroactive Billing of Period Already Billed | char | 1 | 0 | CHAR | (N' ') | No | | XFKRUECK | Allow NULL? |
| 111 | ISPIVWKN | Circulation Audit Report Category ID | nvarchar | 8 | 0 | CHAR | (N' ') | No | * | IVWKN | Allow NULL? |
| 112 | ISPXIVW | Indicator: Relevant for audit report | char | 1 | 0 | CHAR | (N' ') | No | | XIVW | Allow NULL? |
| 113 | ISPJKPAVRG | Normal Start of Address Validity for Retro.Order Items | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | JKPAVONREG | Allow NULL? |
| 114 | ISPJKPABRG | End of Address Validity if End of Billing Delayed | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | JKPABISREG | Allow NULL? |
| 115 | XNEGOPTION | IS-M: Item with Automatic Transformation to Chargeable | char | 1 | 0 | CHAR | (N' ') | No | | XNEGOPTION | Allow NULL? |
| 116 | IVWDATUM | Date of Audit Report for Returns | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | IVWDATUM | Allow NULL? |
| 117 | CAMPAIGN | IS-M: Marketing Campaign | varbinary | 16 | 0 | RAW | | No | | ISM_MARKETING_CAMPAIGN | |
| 118 | ISPBDPER | IS-M: Basic Date for Billing Frequency | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BDPER | Allow NULL? |
| 119 | FKPERVON | IS-M: Initial Date of Full Billing Period | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | FKPERVON | Allow NULL? |
| 120 | FKPERBIS | IS-M: Closing Date of Full Billing Period | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | FKPERBIS | Allow NULL? |
| 121 | ISPZSKLS | Time slice classification for sales order | char | 1 | 0 | CHAR | (N' ') | Yes | | JZSKLS | Allow NULL? |
| 122 | ISPWRBART | Sales Source | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJWAR | WERBEART | Allow NULL? |
| 123 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | NUMC | (N'000000') | No | * | APNR_UR | Allow NULL? |
| 124 | CYCLENR | IS-M/SD: Billing Cycle Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | * | CYCLENR | Allow NULL? |
| 125 | FAKNRRUECK | IS-M: Recalculated Billing Document | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | ISPFAKNRRUECK | Allow NULL? |
| 126 | XFIXED | Indicator: Billing Index Fixed and Cannot be Deleted | char | 1 | 0 | CHAR | (N' ') | No | | XINDEXFIXED | Allow NULL? |
| 127 | RCODE | IS-M/SD: Rate Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | RATE_CODE | Allow NULL? |
| 128 | XAUTO_REN | IS-M/SD: Customer Requests Automatic Renewal | char | 1 | 0 | CHAR | (N' ') | No | | XAUTO_REN | Allow NULL? |
| 129 | STBFREI | Type of Tax Exemption | nvarchar | 2 | 0 | CHAR | (N' ') | No | TJFSB | JSTBFREI | Allow NULL? |
| 130 | XNFAK | IS-M: Indicator - Repeat Billing After Reversal | char | 1 | 0 | CHAR | (N' ') | No | | ISPXNFAK | Allow NULL? |
| 131 | DELIVSPLIT | IS-M/SD: Alternating Address Element | nvarchar | 8 | 0 | CHAR | (N' ') | No | TJD23 | DELIVSPLIT | Allow NULL? |
| 132 | DELIVSPLITGRP | IS-M/SD: Address Alternation Group | nvarchar | 10 | 0 | CHAR | (N' ') | No | TJD63 | DELIVSPLITGRP | Allow NULL? |
| 133 | POSNR_MAIN | IS-M/SD: Main Item in Sales Order | nvarchar | 6 | 0 | NUMC | (N'000000') | No | JKAP | APNR_MAIN | Allow NULL? |
| 134 | POSNR_SUB | IS-M/SD: Sub-Item in Sales Order | nvarchar | 6 | 0 | NUMC | (N'000000') | No | JKAP | APNR_SUB | Allow NULL? |
| 135 | X_MONTAG | IS-M: Monday | char | 1 | 0 | CHAR | (N' ') | No | | X_MONTAG | Allow NULL? |
| 136 | X_DIENSTAG | IS-M: Tuesday | char | 1 | 0 | CHAR | (N' ') | No | | X_DIENSTAG | Allow NULL? |
| 137 | X_MITTWOCH | IS-M: Wednesday | char | 1 | 0 | CHAR | (N' ') | No | | X_MITTWOCH | Allow NULL? |
| 138 | X_DONNETAG | IS-M: Thursday | char | 1 | 0 | CHAR | (N' ') | No | | X_DONNETAG | Allow NULL? |
| 139 | X_FREITAG | IS-M: Friday | char | 1 | 0 | CHAR | (N' ') | No | | X_FREITAG | Allow NULL? |
| 140 | X_SAMSTAG | IS-M: Saturday | char | 1 | 0 | CHAR | (N' ') | No | | X_SAMSTAG | Allow NULL? |
| 141 | X_SONNTAG | IS-M: Sunday | char | 1 | 0 | CHAR | (N' ') | No | | X_SONNTAG | Allow NULL? |
| 142 | VBELN_FROM | IS-M/SD: Publishing Sales Order | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | AVNR | Allow NULL? |
| 143 | POSNR_UR_FROM | Sales Order Item | nvarchar | 6 | 0 | NUMC | (N'000000') | No | * | APNR | Allow NULL? |
| 144 | CYCLENR_FROM | IS-M/SD: Billing Cycle Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | * | CYCLENR | Allow NULL? |
| 145 | XPRICEALTER | Indicator: Generated Index for Price Change | char | 1 | 0 | CHAR | (N' ') | No | | XPRICEALTERNATION | Allow NULL? |
| 146 | REFUNDTYPE | IS-M/SD: Refund Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJK19 | REFUNDTYPE | Allow NULL? |
| 147 | XAUTO_ACCEPT | IS-M/SD: Indicator - Accept Cycle Without Payment | char | 1 | 0 | CHAR | (N' ') | Yes | | XAUTO_ACCEPT | Allow NULL? |
| 148 | BONUSTYPE | IS-M/SD: Bonus Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | JBONUSTYPE | Allow NULL? |