| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | OBJ_TYP | Document type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | OBJ_ID | Document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | LC_SEQUENCE | Loading Confirmation Sequence | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | ITM_NO | DSD Connector: Item number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 6 | DIFF_FLAG | Loading Confirmation Difference Flag | char | 1 | 0 | | | | Allow NULL? |
| 7 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 8 | QUAN_PLAN | Loading Confirmation Planned Quantity | decimal | 13 | 3 | | | | |
| 9 | QUAN_COUNT | Loading Confirmation Counted Quantity | decimal | 13 | 3 | | | | |
| 10 | UOM | Unit of Measurement | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | REASON | DSD - RA: Reasons for Differences in Check | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | CREUSER | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 13 | CREDATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | CRETIME | Entry time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 15 | CNGUSER | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 16 | CNGDATE | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | CNGTIME | Time last change was made | nvarchar | 6 | 0 | | | | Allow NULL? |
| 18 | CHARG | Batch Number | nvarchar | 10 | 0 | | | | Allow NULL? |