| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ID | Confirmation ID | nvarchar | 32 | 0 | | | | Allow NULL? |
| 3 | RETAILER | Global localization number (GLN) | nvarchar | 13 | 0 | | | | Allow NULL? |
| 4 | SUPPLIER | Global localization number (GLN) | nvarchar | 13 | 0 | | | | Allow NULL? |
| 5 | GTIN | Global trade item number (GTIN) | nvarchar | 14 | 0 | | | | Allow NULL? |
| 6 | DATAPOOL | Data pool | nvarchar | 13 | 0 | | | | Allow NULL? |
| 7 | COUNTRY | Target market country ISO code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | SUBDIVISION | Target market country subdivision ISO code | nvarchar | 7 | 0 | | | | Allow NULL? |
| 9 | STATE | Confirmation state: accepted, sync, review, rejected | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | LOG | Application log: log number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 11 | LAST_MODIFIED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 12 | IS_TOP_ITEM | Flag identifying synchronization top item | char | 1 | 0 | | | | Allow NULL? |