|
|
SAP Business One SDK 10.0 - Database Tables Reference |
SEWCS
Table Name: SEWCS
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| CompDbNam | Company Db Name | nVarChar | 200 | - | Â | Â | Â |
| SmpTableId | Smp Table ID | nVarChar | 3 | - | Â | Â | Â |
| COAtemplat | COA Template | VarChar | 1 | - | Â | Â | Â |
| LocalCurr | Local Currency | nVarChar | 3 | - | Â | Â | Â |
| SystemCurr | System Currenct | nVarChar | 3 | - | Â | Â | Â |
| UseSegAcc | Use Segment Accounts | VarChar | 1 | - | Â | Â | Â |
| StkValuat | Stock Valuation | VarChar | 1 | - | Â | Â | Â |
| PricSysPWh | Price System Per Warehouse | VarChar | 1 | - | Â | Â | Â |
| AllowRelSt | Stock Release w/o Cost Price | VarChar | 1 | - | Â | Â | Â |
| CostPrcLst | Gross profit Base Price Origi | VarChar | 1 | - | Â | Â | Â |
| GrossBySal | Calculate % GP as | VarChar | 1 | - | Â | Â | Â |
| BlkNegQuan | Block Negative Quantity | VarChar | 1 | - | Â | Â | Â |
| RoundMeth | Rounding Method | VarChar | 1 | - | Â | Â | Â |
| RoundVAT | Round Tax Amount in Rows | VarChar | 1 | - | Â | Â | Â |
| EnblExpns | Manage Expenses in Documents | VarChar | 1 | - | Â | Â | Â |
| DirectRate | Exchange Rate Posting | VarChar | 1 | - | Â | Â | Â |
| SumDec | Decimal - Amounts | Int | 11 | - | Â | Â | Â |
| PriceDec | Decimal - Prices | Int | 11 | - | Â | Â | Â |
| RateDec | Decimal - Rates | Int | 11 | - | Â | Â | Â |
| QtyDec | Decimal - Quantities | Int | 11 | - | Â | Â | Â |
| PercentDec | Decimal - Percent | Int | 11 | - | Â | Â | Â |
| MeasureDec | Decimal - Units | Int | 11 | - | Â | Â | Â |
| DecSep | Decimal - Separator | VarChar | 1 | - | Â | Â | Â |
| DpmSalAct | Sal-DownPayment Clearing Acct | nVarChar | 15 | - | Â | Â | Â |
| DfltIncom | Sales -Revenues Account | nVarChar | 15 | - | Â | Â | Â |
| ForgnIncm | Sales -Revenues Foreign | nVarChar | 15 | - | Â | Â | Â |
| ECIncome | Sales -Revenue EU | nVarChar | 15 | - | Â | Â | Â |
| SHandleWT | Sales -enable WT | VarChar | 1 | - | Â | Â | Â |
| SDfltWT | Sales -Default WT Code | nVarChar | 4 | - | Â | Â | Â |
| NINum | Ni No | nVarChar | 20 | - | Â | Â | Â |
| ExpireDate | Sales - Expiration Date | Date | 8 | - | Â | Â | Â |
| CrtfcateNO | Sales - Certificate Number | nVarChar | 20 | - | Â | Â | Â |
| SaleVatOff | Sales - Tax Offsetting account | nVarChar | 15 | - | Â | Â | Â |
| DfltExpn | Purchase - Expense Account | nVarChar | 15 | - | Â | Â | Â |
| ForgnExpn | Purchase-Foreign Expense Acct | nVarChar | 15 | - | Â | Â | Â |
| ECExepnses | Purchase - EU Expense account | nVarChar | 15 | - | Â | Â | Â |
| DpmPurAct | Pur-DownPayment Clearing Acct | nVarChar | 15 | - | Â | Â | Â |
| ExpVarAct | Purchase - Variance accont | nVarChar | 15 | - | Â | Â | Â |
| PHandleWT | Purchase - WT enabled | VarChar | 1 | - | Â | Â | Â |
| PDfltWT | Purchase - Default WT code | nVarChar | 4 | - | Â | Â | Â |
| PurcVatOff | Pur - Tax Offsetting account | nVarChar | 15 | - | Â | Â | Â |
| ComissAct | Gen - Credit Card Deposit fee | nVarChar | 15 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | CompDbNam |