biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Inventory / Customs Groups
API OARG / / Customs Groups
OARG - Customs Groups Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CstGrpCode KEY UNIQUECodeInt
6
PRIMARYYes
CstGrpName KEY UNIQUENamenVarChar
20
GROUP_NAMEYes
GroupNumNumbernVarChar
20
CustomCustomsNum
20
BuyTaxPurchaseNum
20
OtherTaxOtherNum
20
TotalTaxTotalNum
20
LockedLockedVarChar
N) Changeable
Y) Locked
1
N
DataSourceData SourceVarChar
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
UserSignUser SignatureInt
6OUSR
Users
cstAllcAccCustoms Allocation AccountnVarChar
15OACT
G/L Accounts
cstExpAccCustoms Expense AccountnVarChar
15OACT
G/L Accounts
PortAddrLocal Clearance - Port AddressnVarChar
50
PortStatePort StatenVarChar
3
ExciExpAccExcise Expense AccountnVarChar
15OACT
G/L Accounts
ExciAlcAccExcise Allocation AccountnVarChar
15OACT
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates