|
|
DTW Administration / Setup / Inventory / Customs Groups
API OARG / / Customs Groups
OARG - Customs Groups Table
Customs Groups CustomsGroups Object· Table: OARG
OARG SQL Table
G/L Accounts OACT SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | CstGrpCode KEY UNIQUE | Code | Int | 6 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| CstGrpName KEY UNIQUE | Name | nVarChar | 20 | GROUP_NAME | Yes | |||
| GroupNum | Number | nVarChar | 20 | |||||
| Custom | Customs | Num | 20 | |||||
| BuyTax | Purchase | Num | 20 | |||||
| OtherTax | Other | Num | 20 | |||||
| TotalTax | Total | Num | 20 | |||||
| Locked | Locked | VarChar | N) Changeable Y) Locked | 1 | N | |||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| cstAllcAcc | Customs Allocation Account | nVarChar | 15 | OACT G/L Accounts | ||||
| cstExpAcc | Customs Expense Account | nVarChar | 15 | OACT G/L Accounts | ||||
| PortAddr | Local Clearance - Port Address | nVarChar | 50 | |||||
| PortState | Port State | nVarChar | 3 | |||||
| ExciExpAcc | Excise Expense Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ExciAlcAcc | Excise Allocation Account | nVarChar | 15 | OACT G/L Accounts |
Table relationship map
SELECT statement
SELECT
OARG.CstGrpCode AS 'Code',
OARG.CstGrpName AS 'Name',
OARG.GroupNum AS 'Number',
OARG.Custom AS 'Customs',
OARG.BuyTax AS 'Purchase',
OARG.OtherTax AS 'Other',
OARG.TotalTax AS 'Total',
OARG.Locked AS 'Locked',
OARG.DataSource AS 'Data Source',
OARG.UserSign AS 'User Signature',
OARG.cstAllcAcc AS 'Customs Allocation Account',
OARG.cstExpAcc AS 'Customs Expense Account',
OARG.PortAddr AS 'Local Clearance - Port Address',
OARG.PortState AS 'Port State',
OARG.ExciExpAcc AS 'Excise Expense Account',
OARG.ExciAlcAcc AS 'Excise Allocation Account'
FROM OARG AS OARG
Related information
Customs Groups CustomsGroups Object· Table: OARG
The CustomsGroups object enables to define custom groups, which specify the customs duty for items purchased abroad that are liable for customs.
Source table: OARG.
OARG SQL Table
G/L Accounts OACT SQL Table
Users OUSR SQL Table
CustomsGroups
Method
Object
Property
Code
DTW DB
Customs
DTW DB
Locked
DB
Name
DTW DB
Number
DTW DB
Other
DTW DB
Purchase
DTW DB
Total
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
