| 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 | QUAN_PLANNED | DSD - RA: Target Quantity | decimal | 13 | 3 | | | | |
| 5 | QUAN_CHECKOUT | Settlement: Check-Out Quantity | decimal | 13 | 3 | | | | |
| 6 | QUAN_DIFF | DSD: Settlement Quantity Difference for Check-Out | decimal | 13 | 3 | | | | |
| 7 | QUAN_DELIVERED | Settlement: Delivered Quantity | decimal | 13 | 3 | | | | |
| 8 | QUAN_RETURN | Settlement: Quantity Taken Back | decimal | 13 | 3 | | | | |
| 9 | QUAN_CHECKIN | Settlement: Quantity for Check-In | decimal | 13 | 3 | | | | |
| 10 | QUAN_FINAL_DIFF | DSD: Settlement Final Difference | decimal | 13 | 3 | | | | |
| 11 | UOM_FOR_QUAN | Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | VALUE_FIN_DIFF | Amount of the Quantity Differences | decimal | 13 | 2 | | | | |
| 13 | CURRENCY_FIN_DIF | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 14 | PLANT | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | CHARG | Batch Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 16 | BWTAR | Valuation Type | nvarchar | 10 | 0 | | | | Allow NULL? |
| 17 | SPEC_RETURN | Control Parameters | char | 1 | 0 | | | | Allow NULL? |
| 18 | CO_DIFF_EVAL | Check-Out Difference Within/Outside of Tolerance | char | 1 | 0 | | | | Allow NULL? |
| 19 | QUAN_CHECKIN_PLN | Settlement: Planned Quantity for Check-In | decimal | 13 | 3 | | | | |
| 20 | QUAN_CHECKIN_DIF | Settlement: Difference Quantity at Check-In | decimal | 13 | 3 | | | | |
| 21 | CI_DIFF_EVAL | Check-In Difference Within/Outside of Tolerance | char | 1 | 0 | | | | Allow NULL? |
| 22 | QUAN_LC_INIT | Settlement: Quantity for Initial Loading Confirmation | decimal | 13 | 3 | | | | |
| 23 | QUAN_LC_INIT_DIF | Settlement: Difference Quantity for Initial Loading Conf. | decimal | 13 | 3 | | | | |
| 24 | QUAN_RLD_PLAN | Settlement: Planned Quantity for Reload | decimal | 13 | 3 | | | | |
| 25 | QUAN_RLD_CI | Settlement: Quantity for Check-In Reload | decimal | 13 | 3 | | | | |
| 26 | QUAN_RLD_LC | Settlement: Quantity for Loading Confirmation Reload | decimal | 13 | 3 | | | | |
| 27 | QUAN_RLD_LC_DIFF | Settlement: Difference Qty for Loading Confirmation Reload | decimal | 13 | 3 | | | | |
| 28 | QUAN_RLD_CO | Settlement: Quantity for Check-Out Reload | decimal | 13 | 3 | | | | |
| 29 | QUAN_RLD_CO_DIFF | Settlement: Difference Quantity for Check-Out Reload | decimal | 13 | 3 | | | | |
| 30 | LC_DIFF_EVAL | Loading Confirmation Difference within/outside of Tolerance | char | 1 | 0 | | | | Allow NULL? |
| 31 | QUAN_FINAL_PLAN | Settlement: Planned Check-Out plus Check-In Quantity | decimal | 13 | 3 | | | | |
| 32 | QUAN_FINAL | Settlement: Check-Out plus Check-In Quantity | decimal | 13 | 3 | | | | |
| 33 | FINAL_DIFF_EVAL | Final Difference within/outside of Tolerance | char | 1 | 0 | | | | Allow NULL? |
| 34 | TOLGRP_ID | Tolerance Group | nvarchar | 4 | 0 | | | | Allow NULL? |