| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | NR | Offline Weighing Transaction Number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | WEIGHINGNR | Weighing Transaction | nvarchar | 20 | 0 | | | | Allow NULL? |
| 4 | EXTNR | External Number for Offline Weighing | nvarchar | 20 | 0 | | | | Allow NULL? |
| 5 | BOOKFLAG | Posting Indicator for Offline Weighing | char | 1 | 0 | | | | Allow NULL? |
| 6 | CAR | Equipment Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 7 | TRAILER | Equipment Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 8 | TREATMENT | Type of Waste Treatment | char | 1 | 0 | | | | Allow NULL? |
| 9 | ORDERNR | Internal Number for Identifying a Waste Disposal Order | nvarchar | 20 | 0 | | | | Allow NULL? |
| 10 | WCNT | Consecutive Number of Weighing Data Record | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | WASTE_REDECLARED | Waste | nvarchar | 18 | 0 | | | | Allow NULL? |
| 12 | LOAD_TIME_BEGIN | Loading Time From | nvarchar | 6 | 0 | | | | Allow NULL? |
| 13 | LOAD_TIME_END | Loading Time To | nvarchar | 6 | 0 | | | | Allow NULL? |
| 14 | UNLOAD_TIME_BEGI | Unloading Time From | nvarchar | 6 | 0 | | | | Allow NULL? |
| 15 | UNLOAD_TIME_END | Unloading Time To | nvarchar | 6 | 0 | | | | Allow NULL? |
| 16 | VERTRAG | Contract | nvarchar | 10 | 0 | | | | Allow NULL? |
| 17 | DISPATCHNOTE | Unique ID Number | nvarchar | 32 | 0 | | | | Allow NULL? |
| 18 | CAR_CONT_NR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 19 | CAR_CONT_COUNT | No. of Containers | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | TRLR_CONT_NR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 21 | TRLR_CONT_COUNT | No. of Containers | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | BRUTTO_WEIGHT | Gross weight | decimal | 10 | 3 | | | | |
| 23 | BRUTTO_UNIT | Unit of weight | nvarchar | 3 | 0 | | | | Allow NULL? |
| 24 | TARA_WEIGHT | Tare Weight | decimal | 10 | 3 | | | | |
| 25 | TARA_UNIT | Unit of weight | nvarchar | 3 | 0 | | | | Allow NULL? |
| 26 | CONTRACT_VBELN | Sales Document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 27 | GEMARK | Local Subdistrict | nvarchar | 12 | 0 | | | | Allow NULL? |
| 28 | NFLURNR | Number of Tract of Land in Land Register | nvarchar | 6 | 0 | | | | Allow NULL? |
| 29 | XFLURST | Parcel of Land | nvarchar | 10 | 0 | | | | Allow NULL? |
| 30 | GUARANTOR | Guarantor Contract | nvarchar | 18 | 0 | | | | Allow NULL? |
| 31 | EXT_ID | External Number of Weighing Data Record | nvarchar | 30 | 0 | | | | Allow NULL? |
| 32 | WASTE | Waste | nvarchar | 18 | 0 | | | | Allow NULL? |
| 33 | LICENSE_NUM | License plate number | nvarchar | 15 | 0 | | | | Allow NULL? |
| 34 | GROSS_ID | Gross Weighing Number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 35 | GROSS_WDATE | Weighing Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 36 | GROSS_WTIME | Weighing time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 37 | GROSS_WEIGHT | Gross weight | decimal | 10 | 3 | | | | |
| 38 | GROSS_SCALE | Gross weight | decimal | 10 | 3 | | | | |
| 39 | TARE_ID | Weight No.- Empty | nvarchar | 20 | 0 | | | | Allow NULL? |
| 40 | TARE_WDATE | Weighing Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 41 | TARE_WTIME | Weighing time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 42 | TARE_WEIGHT | Tare Weight | decimal | 10 | 3 | | | | |
| 43 | TARE_SCALE | Weight of empty container | decimal | 10 | 3 | | | | |
| 44 | WEIGHT_UNIT | Unit of weight | nvarchar | 3 | 0 | | | | Allow NULL? |
| 45 | NET_WEIGHT | Net Weight | decimal | 10 | 3 | | | | |
| 46 | VOLUME | Waste volume | decimal | 13 | 3 | | | | |
| 47 | VOL_UNIT | Volume unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 48 | ANALYSE | Waste Analysis in Weighing Data Record | nvarchar | 5 | 0 | | | | Allow NULL? |
| 49 | WDPLANT | Identification of Waste Disposal Facility | nvarchar | 20 | 0 | | | | Allow NULL? |
| 50 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 51 | LGORT | Storage Location | nvarchar | 4 | 0 | | | | Allow NULL? |
| 52 | LGTYP_W | Storage Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 53 | LGPLA_W | Storage Bin | nvarchar | 10 | 0 | | | | Allow NULL? |
| 54 | STOCK_TYPE | Stock Type | char | 1 | 0 | | | | Allow NULL? |
| 55 | POBJNR | Object Number of Order Item | nvarchar | 22 | 0 | | | | Allow NULL? |
| 56 | PSTNG_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 57 | PROCESSTYPE | Transaction Type | char | 1 | 0 | | | | Allow NULL? |
| 58 | GM_FLAG | Indicator for Goods Movement | char | 1 | 0 | | | | Allow NULL? |
| 59 | BILLING_FLAG | Indicator: Relevant for Billing | char | 1 | 0 | | | | Allow NULL? |
| 60 | QUANTITY | Quantity/ Piece Goods Of Weighing Transaction | decimal | 15 | 3 | | | | |
| 61 | QUANTITY_UNIT | Unit/Type For Quantity in Weighing Transaction | nvarchar | 3 | 0 | | | | Allow NULL? |
| 62 | GENERATOR_RECN | Unique ID Number | nvarchar | 32 | 0 | | | | Allow NULL? |
| 63 | GENERATOR_ACTN | Unique ID Number | nvarchar | 32 | 0 | | | | Allow NULL? |
| 64 | TRANSPORTER_RECN | Unique ID Number | nvarchar | 32 | 0 | | | | Allow NULL? |
| 65 | TRANSPORTER_ACTN | Unique ID Number | nvarchar | 32 | 0 | | | | Allow NULL? |
| 66 | DISPOSER_RECN | Unique ID Number | nvarchar | 32 | 0 | | | | Allow NULL? |
| 67 | DISPOSER_ACTN | Unique ID Number | nvarchar | 32 | 0 | | | | Allow NULL? |
| 68 | VSTELLE | Premise | nvarchar | 10 | 0 | | | | Allow NULL? |
| 69 | SERVLOC | Location of Container | nvarchar | 30 | 0 | | | | Allow NULL? |
| 70 | ZTERM | Terms of Payment Key | nvarchar | 4 | 0 | | | | Allow NULL? |
| 71 | ZTAGG | Day Limit | nvarchar | 2 | 0 | | | | Allow NULL? |
| 72 | KUNNR | Customer Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 73 | APPROVAL_RECN | Unique ID Number | nvarchar | 32 | 0 | | | | Allow NULL? |
| 74 | APPROVAL_ACTN | Unique ID Number | nvarchar | 32 | 0 | | | | Allow NULL? |
| 75 | KAPID | Capacity ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 76 | VERSN | Available capacity version | nvarchar | 2 | 0 | | | | Allow NULL? |
| 77 | DATUB | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 78 | TAGNR | Current weekday number within the available capacity cycle | nvarchar | 3 | 0 | | | | Allow NULL? |
| 79 | SCHNR | Shift number of the available capacity | char | 1 | 0 | | | | Allow NULL? |
| 80 | SCHDATUM | Shift Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 81 | SCHUZEIT | Time of Acceptance | nvarchar | 6 | 0 | | | | Allow NULL? |
| 82 | LGNUM | Warehouse Number / Warehouse Complex | nvarchar | 3 | 0 | | | | Allow NULL? |
| 83 | LGTYP | Storage Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 84 | LGPLA | Storage Bin | nvarchar | 10 | 0 | | | | Allow NULL? |
| 85 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 86 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 87 | AEDAT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 88 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 89 | BEGRU | Authorization Group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 90 | LOEVM | Deletion Indicator | char | 1 | 0 | | | | Allow NULL? |
| 91 | WDPLANTORDERTYPE | Order Type for Waste Disposal Facility | nvarchar | 20 | 0 | | | | Allow NULL? |
| 92 | FLAG_TARA | Maintain Tare Weight Manually | char | 1 | 0 | | | | Allow NULL? |
| 93 | CONTRACT_POSNR | Sales Document Item | nvarchar | 6 | 0 | | | | Allow NULL? |