|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Customs Groups
Table Name: OARG
Table Description: Customs Groups
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| CstGrpCode | Code | Int | 6 | - | Â | Â | Â |
| CstGrpName | Name | nVarChar | 20 | - | Â | Â | Â |
| GroupNum | Number | nVarChar | 20 | - | Â | Â | Â |
| Custom | Customs | Num | 19.6 | - | Â | Â | Â |
| BuyTax | Purchase | Num | 19.6 | - | Â | Â | Â |
| OtherTax | Other | Num | 19.6 | - | Â | Â | Â |
| TotalTax | Total | Num | 19.6 | - | Â | Â | Â |
| Locked | Locked | VarChar | 1 | - | N | N | Changeable |
| Â | Â | Â | Â | Â | Â | Y | Locked |
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| Â | Â | Â | Â | Â | Â | I | Interface |
| Â | Â | Â | Â | Â | Â | U | Update |
| Â | Â | Â | Â | Â | Â | M | Import |
| Â | Â | Â | Â | Â | Â | O | DI API |
| Â | Â | Â | Â | Â | Â | S | Service Layer |
| Â | Â | Â | Â | Â | Â | W | Web Client |
| Â | Â | Â | Â | Â | Â | A | Doc. Generation Wizard |
| Â | Â | Â | Â | Â | Â | D | Restore Wizard |
| Â | Â | Â | Â | Â | Â | P | Partner Implementation |
| Â | Â | Â | Â | Â | Â | T | Year Transfer |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| cstAllcAcc | Customs Allocation Account | nVarChar | 15 | OACT | Â | Â | Â |
| cstExpAcc | Customs Expense Account | nVarChar | 15 | OACT | Â | Â | Â |
| PortAddr | Local Clearance - Port Address | nVarChar | 50 | - | Â | Â | Â |
| PortState | Port State | nVarChar | 3 | - | Â | Â | Â |
| ExciExpAcc | Excise Expense Account | nVarChar | 15 | OACT | Â | Â | Â |
| ExciAlcAcc | Excise Allocation Account | nVarChar | 15 | OACT | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | CstGrpCode |
| GROUP_NAME | Yes | CstGrpName |