|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Intrastat Reported Items
Table Name: ISW2
Table Description: Intrastat Reported Items
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| WizAbsEnt | Wizard Run Key | Int | 11 | OISW | Â | Â | Â |
| ItemCode | Item Code | nVarChar | 50 | OITM | Â | Â | Â |
| CommCode | Commodity Code | nVarChar | 12 | - | Â | Â | Â |
| SerCode | Service Code | nVarChar | 12 | - | Â | Â | Â |
| AddMUnit | Additional Measure Unit | nVarChar | 50 | - | Â | Â | Â |
| FactorAM | Factor Additional Measure | Num | 19.6 | - | Â | Â | Â |
| OriRegSta | Region of Origin (for Export) | nVarChar | 12 | - | Â | Â | Â |
| DstRegSta | Destination Region (Import) | nVarChar | 12 | - | Â | Â | Â |
| CtryOrig | Country/Region of Origin | nVarChar | 3 | - | Â | Â | Â |
| SerSupplM | Service Supply Method | nVarChar | 12 | - | I | I | Immediate |
| Â | Â | Â | Â | Â | Â | R | To More Resumptions |
| SerPymMeth | Service Payment Method | nVarChar | 12 | - | X | A | Accredited to Bank Account |
| Â | Â | Â | Â | Â | Â | B | Bank Transfer |
| Â | Â | Â | Â | Â | Â | X | Other |
| ItemType | Item Type | VarChar | 1 | - | I | I | Item |
| Â | Â | Â | Â | Â | Â | S | Service |
| Â | Â | Â | Â | Â | Â | N | Item not relevant to Intrastat |
| ItemName | Item Name | nVarChar | 200 | - | Â | Â | Â |
| DestRegCry | Destination Country - Region | nVarChar | 3 | - | Â | Â | Â |
| OrigRegCry | Origin Region Country | nVarChar | 3 | - | Â | Â | Â |
| UseWeight | Use Wt in Add. Measure Calc. | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| StatCode | Statistical Code | nVarChar | 2 | - | Â | Â | Â |
| NatOfTrans | Nature of Transaction | nVarChar | 50 | - | Â | Â | Â |
| StatProc | Statistical Procedure | nVarChar | 50 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | WizAbsEnt |
| Â | Â | ItemCode |