biuan SAP® BUSINESS ONE SDK
API SEWCS
SEWCS - SEWCS Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CompDbNam KEY UNIQUECompany Db NamenVarChar
100
PRIMARYYes
SmpTableIdSmp Table IDnVarChar
3
COAtemplatCOA TemplateVarChar
1
LocalCurrLocal CurrencynVarChar
3
SystemCurrSystem CurrenctnVarChar
3
UseSegAccUse Segment AccountsVarChar
1
StkValuatStock ValuationVarChar
1
PricSysPWhPrice System Per WarehouseVarChar
1
AllowRelStStock Release w/o Cost PriceVarChar
1
CostPrcLstGross profit Base Price OrigiVarChar
1
GrossBySalCalculate % GP asVarChar
1
BlkNegQuanBlock Negative QuantityVarChar
1
RoundMethRounding MethodVarChar
1
RoundVATRound Tax Amount in RowsVarChar
1
EnblExpnsManage Expenses in DocumentsVarChar
1
DirectRateExchange Rate PostingVarChar
1
SumDecDecimal - AmountsInt
11
PriceDecDecimal - PricesInt
11
RateDecDecimal - RatesInt
11
QtyDecDecimal - QuantitiesInt
11
PercentDecDecimal - PercentInt
11
MeasureDecDecimal - UnitsInt
11
DecSepDecimal - SeparatorVarChar
1
DpmSalActSal-DownPayment Clearing AcctnVarChar
15
DfltIncomSales -Revenues AccountnVarChar
15
ForgnIncmSales -Revenues ForeignnVarChar
15
ECIncomeSales -Revenue EUnVarChar
15
SHandleWTSales -enable WTVarChar
1
SDfltWTSales -Default WT CodenVarChar
4
NINumNi NonVarChar
20
ExpireDateSales - Expiration DateDate
8
CrtfcateNOSales - Certificate NumbernVarChar
20
SaleVatOffSales - Tax Offsetting accountnVarChar
15
DfltExpnPurchase - Expense AccountnVarChar
15
ForgnExpnPurchase-Foreign Expense AcctnVarChar
15
ECExepnsesPurchase - EU Expense accountnVarChar
15
DpmPurActPur-DownPayment Clearing AcctnVarChar
15
ExpVarActPurchase - Variance accontnVarChar
15
PHandleWTPurchase - WT enabledVarChar
1
PDfltWTPurchase - Default WT codenVarChar
4
PurcVatOffPur - Tax Offsetting accountnVarChar
15
ComissActGen - Credit Card Deposit feenVarChar
15

SELECT statement

SELECT SEWCS.CompDbNam AS 'Company Db Name', SEWCS.SmpTableId AS 'Smp Table ID', SEWCS.COAtemplat AS 'COA Template', SEWCS.LocalCurr AS 'Local Currency', SEWCS.SystemCurr AS 'System Currenct', SEWCS.UseSegAcc AS 'Use Segment Accounts', SEWCS.StkValuat AS 'Stock Valuation', SEWCS.PricSysPWh AS 'Price System Per Warehouse', SEWCS.AllowRelSt AS 'Stock Release w/o Cost Price', SEWCS.CostPrcLst AS 'Gross profit Base Price Origi', SEWCS.GrossBySal AS 'Calculate % GP as', SEWCS.BlkNegQuan AS 'Block Negative Quantity', SEWCS.RoundMeth AS 'Rounding Method', SEWCS.RoundVAT AS 'Round Tax Amount in Rows', SEWCS.EnblExpns AS 'Manage Expenses in Documents', SEWCS.DirectRate AS 'Exchange Rate Posting', SEWCS.SumDec AS 'Decimal - Amounts', SEWCS.PriceDec AS 'Decimal - Prices', SEWCS.RateDec AS 'Decimal - Rates', SEWCS.QtyDec AS 'Decimal - Quantities', SEWCS.PercentDec AS 'Decimal - Percent', SEWCS.MeasureDec AS 'Decimal - Units', SEWCS.DecSep AS 'Decimal - Separator', SEWCS.DpmSalAct AS 'Sal-DownPayment Clearing Acct', SEWCS.DfltIncom AS 'Sales -Revenues Account', SEWCS.ForgnIncm AS 'Sales -Revenues Foreign', SEWCS.ECIncome AS 'Sales -Revenue EU', SEWCS.SHandleWT AS 'Sales -enable WT', SEWCS.SDfltWT AS 'Sales -Default WT Code', SEWCS.NINum AS 'Ni No', SEWCS.ExpireDate AS 'Sales - Expiration Date', SEWCS.CrtfcateNO AS 'Sales - Certificate Number', SEWCS.SaleVatOff AS 'Sales - Tax Offsetting account', SEWCS.DfltExpn AS 'Purchase - Expense Account', SEWCS.ForgnExpn AS 'Purchase-Foreign Expense Acct', SEWCS.ECExepnses AS 'Purchase - EU Expense account', SEWCS.DpmPurAct AS 'Pur-DownPayment Clearing Acct', SEWCS.ExpVarAct AS 'Purchase - Variance accont', SEWCS.PHandleWT AS 'Purchase - WT enabled', SEWCS.PDfltWT AS 'Purchase - Default WT code', SEWCS.PurcVatOff AS 'Pur - Tax Offsetting account', SEWCS.ComissAct AS 'Gen - Credit Card Deposit fee' FROM SEWCS AS SEWCS

Related information




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