| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SLD_DOC_ID | DSD: Settlement Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 4 | ASSIGNED_SEQ | DSD - RA: Assigned Sequence Number | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | REASON | DSD - RA: Reasons for Differences in Check | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | SPEC_RETURN | Control Parameters | char | 1 | 0 | | | | Allow NULL? |
| 7 | PLANT | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | CHARG | Batch Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | QUAN_PLANNED | DSD - RA: Target Quantity | decimal | 13 | 3 | | | | |
| 10 | QUAN_LC_INIT | Settlement: Quantity for Initial Loading Confirmation | decimal | 13 | 3 | | | | |
| 11 | QUAN_LC_INIT_DIF | Settlement: Difference Quantity for Initial Loading Conf. | decimal | 13 | 3 | | | | |
| 12 | QUAN_CO_INIT | Settlement: Quantity for Initial Check-Out | decimal | 13 | 3 | | | | |
| 13 | QUAN_CO_INIT_DIF | Settlement: Difference Quantity for Initial Check-Out | decimal | 13 | 3 | | | | |
| 14 | QUAN_RLD_PLAN | Settlement: Planned Quantity for Reload | decimal | 13 | 3 | | | | |
| 15 | QUAN_RLD_CI | Settlement: Quantity for Check-In Reload | decimal | 13 | 3 | | | | |
| 16 | QUAN_RLD_LC | Settlement: Quantity for Loading Confirmation Reload | decimal | 13 | 3 | | | | |
| 17 | QUAN_RLD_LC_DIFF | Settlement: Difference Qty for Loading Confirmation Reload | decimal | 13 | 3 | | | | |
| 18 | QUAN_RLD_CO | Settlement: Quantity for Check-Out Reload | decimal | 13 | 3 | | | | |
| 19 | QUAN_RLD_CO_DIFF | Settlement: Difference Quantity for Check-Out Reload | decimal | 13 | 3 | | | | |
| 20 | QUAN_CI_PLAN | Settlement: Planned Quantity for Final Check-In | decimal | 13 | 3 | | | | |
| 21 | QUAN_CI | Settlement: Quantity for Final Check-In | decimal | 13 | 3 | | | | |
| 22 | QUAN_CI_DIFF | Settlement: Difference Quantity for Final Check-In | decimal | 13 | 3 | | | | |
| 23 | QUAN_LC_PLAN_SUM | Settlement: Planned Quantity for Loading Confirmation | decimal | 13 | 3 | | | | |
| 24 | QUAN_LC_SUM | Settlement: Quantity for Load Confirmation | decimal | 13 | 3 | | | | |
| 25 | QUAN_LC_DIFF_SUM | Settlement: Difference Quantity for Loading Confirmation | decimal | 13 | 3 | | | | |
| 26 | QUAN_CO_PLAN_SUM | Settlement: Planned Quantity for Check-Out | decimal | 13 | 3 | | | | |
| 27 | QUAN_CO_SUM | Settlement: Check-Out Quantity | decimal | 13 | 3 | | | | |
| 28 | QUAN_CO_DIFF_SUM | DSD: Settlement Quantity Difference for Check-Out | decimal | 13 | 3 | | | | |
| 29 | QUAN_CI_PLAN_SUM | Settlement: Planned Quantity for Check-In | decimal | 13 | 3 | | | | |
| 30 | QUAN_CI_SUM | Settlement: Quantity for Check-In | decimal | 13 | 3 | | | | |
| 31 | QUAN_CI_DIFF_SUM | Settlement: Difference Quantity at Check-In | decimal | 13 | 3 | | | | |
| 32 | UOM_FOR_QUAN | Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 33 | TOLGRP_ID | Tolerance Group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 34 | BWTAR | Valuation Type | nvarchar | 10 | 0 | | | | Allow NULL? |