| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | TOUR_ID | DSD Route Settlement: Tour ID | nvarchar | 32 | 0 | | | | Allow NULL? |
| 3 | CHECK_ID | DSD - RA: Check ID for Check-Out / Check-In | nvarchar | 6 | 0 | | | | Allow NULL? |
| 4 | ITEMNR | DSD - RA: Check-Out / Check-In - Item Number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 6 | PLANT | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | QUAN_PLAN | DSD - RA: Target Quantity | decimal | 13 | 3 | | | | |
| 8 | QUAN_COUNT | DSD - RA: Actual Quantity in Check-In / Check-Out | decimal | 13 | 3 | | | | |
| 9 | QUAN_DIFF | DSD - RA: Difference Quantity | decimal | 13 | 3 | | | | |
| 10 | UOM | DSD - RA: Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | REASON | DSD - RA: Reasons for Differences in Check | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | ROTRUCK | DSD - RA: Flag, Goods Remain on the Vehicle | char | 1 | 0 | | | | Allow NULL? |
| 13 | SPEC_RETURN | Control Parameters | char | 1 | 0 | | | | Allow NULL? |
| 14 | STATUS | DSD - RA: Processing Status of the Data Record | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | NOK | DSD - RA: Data Record is Incorrect | char | 1 | 0 | | | | Allow NULL? |
| 16 | CHARG | Batch Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 17 | BWTAR | Valuation Type | nvarchar | 10 | 0 | | | | Allow NULL? |