| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | ID | Confirmation ID | nvarchar | 32 | 0 | CHAR | (N' ') | No | | WGDS_CONFIRM_ID | Allow NULL? |
| 3 | RETAILER | Global localization number (GLN) | nvarchar | 13 | 0 | NUMC | (N'0000000000000') | No | | WGDS_GLN | Allow NULL? |
| 4 | SUPPLIER | Global localization number (GLN) | nvarchar | 13 | 0 | NUMC | (N'0000000000000') | No | | WGDS_GLN | Allow NULL? |
| 5 | GTIN | Global trade item number (GTIN) | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | No | | WGDS_GTIN | Allow NULL? |
| 6 | DATAPOOL | Data pool | nvarchar | 13 | 0 | NUMC | (N'0000000000000') | No | | WGDS_DATAPOOL | Allow NULL? |
| 7 | COUNTRY | Target market country ISO code | nvarchar | 3 | 0 | NUMC | (N'000') | No | | WGDS_TM_COUNTRY | Allow NULL? |
| 8 | SUBDIVISION | Target market country subdivision ISO code | nvarchar | 7 | 0 | CHAR | (N' ') | No | | WGDS_TM_SUBDIVISION | Allow NULL? |
| 9 | STATE | Confirmation state: accepted, sync, review, rejected | nvarchar | 2 | 0 | NUMC | (N'00') | No | | WGDS_CONFIRM_STATE | Allow NULL? |
| 10 | LOG | Application log: log number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | BALOGNR | Allow NULL? |
| 11 | LAST_MODIFIED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 12 | IS_TOP_ITEM | Flag identifying synchronization top item | char | 1 | 0 | CHAR | (N' ') | Yes | | WGDS_CONFIRM_IS_TOP_ITEM | Allow NULL? |
