Table RJE
Purpose
Rejects during import?
Field definitions in table RJE
| No. | Used | Name | Type | Reqd. | Description |
|---|---|---|---|---|---|
| 1 | AVIZ | VARCHAR(50) | N | ||
| 2 | ART | VARCHAR(50) | N | ||
| 3 | QTY | INT | N | ||
| 4 | STOCKCODE | VARCHAR(10) | N | ||
| 5 | CLIENTID | INT | N | ||
| 6 | BPOINTS | VARCHAR(20) | N | ||
| 7 | OrderType | VARCHAR(50) | N | ||
| 8 | Country | VARCHAR(50) | N | ||
| 9 | id | NUMERIC(0,18) | N | ||
| 10 | OriginalImpRow1 | VARCHAR(750) | N | ||
| 11 | OriginalImpRow2 | VARCHAR(750) | N | ||
| 12 | OriginalImpRow3 | VARCHAR(250) | N | ||
| 13 | IDDClient | VARCHAR(50) | N | ||
| 14 | DClient | VARCHAR(50) | N | ||
| 15 | DClientTown | VARCHAR(50) | N | ||
| 16 | DClientTownCode | VARCHAR(50) | N | ||
| 17 | DClientAddress | VARCHAR(200) | N | ||
| 18 | DClientCountry | VARCHAR(50) | N | ||
| 19 | IDIClient | VARCHAR(50) | N | ||
| 20 | IClient | VARCHAR(50) | N | ||
| 21 | IClientTown | VARCHAR(50) | N | ||
| 22 | IClientTownCode | VARCHAR(50) | N | ||
| 23 | IClientAddress | VARCHAR(200) | N | ||
| 24 | IClientCountry | VARCHAR(50) | N | ||
| 25 | UserName | VARCHAR(50) | N | ||
| 26 | MasterQTY | NUMERIC(0,18) | N | ||
| 27 | Grouped | VARCHAR(50) | N | ||
| 28 | CGROUPID | VARCHAR(50) | N | ||
| 29 | UnitQTY | NUMERIC(0,18) | N | ||
| 30 | RealMasterQTY | NUMERIC(0,18) | N |