| 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 | MOV_GUID | GUID for CMS_MOVABLES | varbinary | 16 | 0 | RAW | | No | | CMS_DTE_MOV_GUID | |
| 3 | MOV_CATEGORY | Object Category | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TCMS_MOV_TYP | CMS_DTE_OMS_OBJ_CAT | Allow NULL? |
| 4 | MOV_TYP | Movable types | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TCMS_MOV_TYP | CMS_DTE_MOV_TYP | Allow NULL? |
| 5 | MOV_ID | Identification Number | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_MOV_ID | Allow NULL? |
| 6 | MOV_DESC | Description of the object | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_MOV_DESC | Allow NULL? |
| 7 | MOV_IDT_ACC | Identification accessories | char | 1 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_MOV_IDT_ACC | Allow NULL? |
| 8 | MOV_MODEL_NAM | Technical Category/Category term/Description | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_MOV_MODEL_NAM | Allow NULL? |
| 9 | MOV_MANUFACTURER | Object Manufacturer Builder | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_MOV_MANUFACTURER | Allow NULL? |
| 10 | MOV_MANU_DAT | Date of the Manufacture/Purchase | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CMS_DTE_MOV_MANU_DAT | Allow NULL? |
| 11 | ADDR_ID | Location / Address | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CMS_DTE_MOV_LOCATION | Allow NULL? |
| 12 | MOV_LOC_DESC | Location Description | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TCMS_ATT_ID_TY | CMS_DTE_MOV_LOC_DESC | Allow NULL? |
| 13 | MOV_LOC_DE_RMRK | Remark Field for Location Description | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_MOV_LOC_DESC_RMRK | Allow NULL? |
| 14 | MOV_IDEN_TYP | Type of identification / Marking of the collateral material | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TCMS_ATT_ID_TY | CMS_DTE_MOV_TYPE_IDENT | Allow NULL? |
| 15 | MOV_DESC_COL_MAT | Bank's Own Identifcation | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_OMS_DESC_IDENT_COL_MAT | Allow NULL? |
| 16 | MOV_DOP | Date of Purchase | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CMS_DTE_MOV_DOP | Allow NULL? |
| 17 | MOV_IDENT | Commercial usage | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_MOV_IDENT | Allow NULL? |
| 18 | MOV_UOB | Use of the object | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TCMS_ATT_ID_TY | CMS_DTE_MOV_UOB | Allow NULL? |
| 19 | MOV_MANU_CNTRY | Manufacturing Country | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | CMS_DTE_MOV_MANU_CNTRY | Allow NULL? |
| 20 | MOV_TYPE_FEAT | Classification | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TCMS_OMS_FEAT | CMS_DTE_MOV_TYPE_FEAT | Allow NULL? |
| 21 | EXT_ITM_NO | Ext. Item no / Number for identification of the objects | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_OMS_EXT_ITM_NO | Allow NULL? |
| 22 | EXT_REFERENCE | Reference number for the legacy system | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_OMS_REF_ID | Allow NULL? |
| 23 | IS_TEMPLATE | Type to be used as template | char | 1 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_MOV_FLG_TEMPLATE | Allow NULL? |
| 24 | TEMPLATE_ID | Template ID | varbinary | 16 | 0 | RAW | | Yes | | CMS_DTE_MOV_TEMPLATE_ID | |
| 25 | DEV_COUNTRY_KEY | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | CMS_DTE_MOV_COUNTRY_KEY | Allow NULL? |
| 26 | DEV_MAC_NO | External Item Number - Machine number | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_MOV_MACHINE_NO | Allow NULL? |
| 27 | ACR_DELVDAT | Delivery Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CMS_DTE_MOV_DELVDAT | Allow NULL? |
| 28 | ACR_REG | Registered | char | 1 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_MOV_REG | Allow NULL? |
| 29 | ACR_REGC | Registration Country | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | CMS_DTE_MOV_REGC | Allow NULL? |
| 30 | ACR_REGM | Registration Mark | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_MOV_REGM | Allow NULL? |
| 31 | ACR_RC | Registration Comments | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_MOV_RC | Allow NULL? |
| 32 | ACR_EMAN | Engine Manufacturer | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_MOV_EMAN | Allow NULL? |
| 33 | ACR_EMOD | Engine Model | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_MOV_EMOD | Allow NULL? |
| 34 | ACR_EPOOL | Engine pooling | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_MOV_EPOOL | Allow NULL? |
| 35 | ACR_EPRMK | Engine pooling remarks | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_MOV_EPRMK | Allow NULL? |
| 36 | ACR_NOE | Number of Engines | int | 10 | 0 | INT4 | ((0)) | Yes | | CMS_DTE_MOV_NOE | Allow NULL? |
| 37 | ACR_NAME | Object name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_MOV_OM | Allow NULL? |
| 38 | ACR_MTOW | Maximum take-off weight | decimal | 13 | 3 | QUAN | ((0)) | Yes | | CMS_DTE_MOV_MTOW | |
| 39 | ACR_MTOW_UNT | Maximum take off weight (Unit) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | CMS_DTE_MOV_MTOW_UNT | Allow NULL? |
| 40 | ACR_NOB | Number of objects | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | CMS_DTE_MOV_NOB | |
| 41 | ACR_MSNNO | MSN Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_MOV_MSNNO | Allow NULL? |
| 42 | ACR_RATCLS | Rating Class | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TCMS_ATT_ID_TY | CMS_DTE_MOV_RATCLS | Allow NULL? |
| 43 | ACR_RATD | Rating Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CMS_DTE_MOV_RATD | Allow NULL? |
| 44 | PERM_WGHT | Maximum Permissible Weight | decimal | 13 | 3 | QUAN | ((0)) | Yes | | CMS_DTE_MOV_PERM_WGHT | |
| 45 | PERM_WGHT_UNT | Unit of the quantity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | CMS_DTE_MOV_PERM_WGHT_UNT | Allow NULL? |
| 46 | PLACE_LIC | Place of Registration | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_MOV_PLACE_LIC | Allow NULL? |
| 47 | VEH_REG_NO | Vehicle registration mark | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_MOV_REG_NO | Allow NULL? |
| 48 | OFF_IDENT | Identification of the registration certificate | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_MOV_OFF_IDENT | Allow NULL? |
| 49 | CHAIS_NO | Chassis Number | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_MOV_CHASIS_NO | Allow NULL? |
| 50 | IDEN_ACC | Identification land accessories | char | 1 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_INV_IDEN_ACC | Allow NULL? |
| 51 | BILL_NO | Bill number of the inventory | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_INV_BILL_NO | Allow NULL? |
| 52 | UNIT_PRICE | Unit Price | decimal | 17 | 2 | CURR | ((0)) | Yes | | CMS_DTE_INV_UNIT_PRICE | |
| 53 | UNIT_PRICE_CURR | Currency for unit price | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | CMS_DTE_INV_UNIT_CURR | Allow NULL? |
| 54 | TYPE_STK_EXCH | Type of stock exchange | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TCMS_ATT_ID_TY | CMS_DTE_INV_TYPE_STK_EXCH | Allow NULL? |
| 55 | STK_EXCH_ID | Place of stock exchange | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TCMS_ATT_ID_TY | CMS_DTE_INV_STK_EXCH_ID | Allow NULL? |
| 56 | RATE_FIX_DAT | Date of previous quotation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CMS_DTE_INV_RATE_FIX_DAT | Allow NULL? |
| 57 | DET_PRICE | Determined price | decimal | 17 | 2 | CURR | ((0)) | Yes | | CMS_DTE_INV_DET_PRICE | |
| 58 | DET_CURR | Currency for determined price | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | CMS_DTE_INV_DET_CURR | Allow NULL? |
| 59 | STOCK_QUANTITY | Quantity of inventory | decimal | 13 | 3 | QUAN | ((0)) | Yes | | CMS_DTE_INV_QTY | |
| 60 | STOCK_UOM | Unit of Measure of Quantity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | CMS_DTE_UNIT | Allow NULL? |
| 61 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_ADMINORG | Allow NULL? |
| 62 | BANKAREA | Bank Area in Collateral Management | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | CMS_DTE_BANKAREA | Allow NULL? |
| 63 | CREATED_BY | Login ID of the User who created the Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_USER | Allow NULL? |
| 64 | CREATED_AT | Creation Timestamp | decimal | 15 | 0 | DEC | ((0)) | Yes | | CMS_DTE_CREATED_AT | |
| 65 | CHANGED_BY | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_LAST_CHNG_USER | Allow NULL? |
| 66 | CHANGED_AT | Change Timestamp | decimal | 15 | 0 | DEC | ((0)) | Yes | | CMS_DTE_CHANGED_AT | |
| 67 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_SOURCE_OF_ENTRY | Allow NULL? |
