|
|
SAP Business One SDK 10.0 - Database Tables Reference |
SEWDV
Table Name: SEWDV
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| CompDbNam | Company Db Name | nVarChar | 200 | - | Â | Â | Â |
| SmpTableId | Smp Table ID | nVarChar | 3 | - | Â | Â | Â |
| EwaSentDat | EWA Sent Date | nVarChar | 10 | - | Â | Â | Â |
| CustNumber | Customer Number | VarChar | 1 | - | Â | Â | Â |
| DocPeriod | Doc Period | nVarChar | 32 | - | Â | Â | Â |
| SalesOrdrs | Sales Orders | Int | 11 | - | Â | Â | Â |
| SalDlvDocs | Sales Delivery Docs | Int | 11 | - | Â | Â | Â |
| SalesInvs | Sales Invoices | Int | 11 | - | Â | Â | Â |
| PurcOrders | Purchase Orders | Int | 11 | - | Â | Â | Â |
| GoodRecpts | Good Receipts | Int | 11 | - | Â | Â | Â |
| PurchAPInv | Purchase AP Invoices | Int | 11 | - | Â | Â | Â |
| ServicCall | Service Calls | Int | 11 | - | Â | Â | Â |
| MaterBills | Meterial Bills | Int | 11 | - | Â | Â | Â |
| WorkOrders | Work Orders | Int | 11 | - | Â | Â | Â |
| SalesOppor | Opportunities | Int | 11 | - | Â | Â | Â |
| ItmMasterD | Item Master Data | Int | 11 | - | Â | Â | Â |
| CustBPMasD | Customer Bp Master Data | Int | 11 | - | Â | Â | Â |
| SuppBPMasD | Supplier Bp Master Data | Int | 11 | - | Â | Â | Â |
| SalOrdMinR | Min Rows Of Sales Orders | Int | 11 | - | Â | Â | Â |
| SlDlvrMinR | Min rows Of Sales DElivery | Int | 11 | - | Â | Â | Â |
| SlsInvMinR | Min rows Of Invoices | Int | 11 | - | Â | Â | Â |
| PrcOrdMinR | Min rows Of Purchase Orders | Int | 11 | - | Â | Â | Â |
| GodRcpMinR | Min rows Of Good Receipts | Int | 11 | - | Â | Â | Â |
| WrkOrdMinR | Min rows Of work orders | Int | 11 | - | Â | Â | Â |
| QuotMinR | Min rows Of QUOT | Int | 11 | - | Â | Â | Â |
| RetMinR | Min rows Of RETURN | Int | 11 | - | Â | Â | Â |
| DownMinR | Min rows Of DOWN | Int | 11 | - | Â | Â | Â |
| ARCrdMinR | Min rows Of ARCREDIT | Int | 11 | - | Â | Â | Â |
| GodRecMinR | Min rows Of GOODREC | Int | 11 | - | Â | Â | Â |
| APRetMinR | Min rows Of APRETURN | Int | 11 | - | Â | Â | Â |
| APDwnMinR | Min rows Of APDOWN | Int | 11 | - | Â | Â | Â |
| APInvMinR | Min rows Of APINVOICE | Int | 11 | - | Â | Â | Â |
| APCrdMinR | Min rows Of APCREDIT | Int | 11 | - | Â | Â | Â |
| SalOrdMaxR | Max Rows Of Sales Orders | Int | 11 | - | Â | Â | Â |
| SlDlvrMaxR | Max rows Of Sales DElivery | Int | 11 | - | Â | Â | Â |
| SlsInvMaxR | Max rows Of Invoices | Int | 11 | - | Â | Â | Â |
| PrcOrdMaxR | Max rows Of Purchase Orders | Int | 11 | - | Â | Â | Â |
| GodRcpMaxR | Max rows Of Good Receipts | Int | 11 | - | Â | Â | Â |
| WrkOrdMaxR | Max rows Of work orders | Int | 11 | - | Â | Â | Â |
| QuotMaxR | Max rows Of QUOT | Int | 11 | - | Â | Â | Â |
| RetMaxR | Max rows Of RETURN | Int | 11 | - | Â | Â | Â |
| DownMaxR | Max rows Of DOWN | Int | 11 | - | Â | Â | Â |
| ARCrdMaxR | Max rows Of ARCREDIT | Int | 11 | - | Â | Â | Â |
| GodRecMaxR | Max rows Of GOODREC | Int | 11 | - | Â | Â | Â |
| APRetMaxR | Max rows Of APRETURN | Int | 11 | - | Â | Â | Â |
| APDwnMaxR | Max rows Of APDOWN | Int | 11 | - | Â | Â | Â |
| APInvMaxR | Max rows Of APINVOICE | Int | 11 | - | Â | Â | Â |
| APCrdMaxR | Min rows Of APCREDIT | Int | 11 | - | Â | Â | Â |
| NoPickLst | No of Picklists in system | Int | 11 | - | Â | Â | Â |
| MaxLnPkLst | Maximum Lines in Pick List | Int | 11 | - | Â | Â | Â |
| MinLnPkLst | Minimum Lines in Pick List | Int | 11 | - | Â | Â | Â |
| MaxChldBm | Maximum children per BOM | Int | 11 | - | Â | Â | Â |
| NoProdOrd | Number of Production order | Int | 11 | - | Â | Â | Â |
| NoSrlNum | No of Serial number items | Int | 11 | - | Â | Â | Â |
| NoBatchNum | No of Batch number items | Int | 11 | - | Â | Â | Â |
| StockTras | Number of Stock Transfers | Int | 11 | - | Â | Â | Â |
| MaxRStTrs | Max num of rows per stock tran | Int | 11 | - | Â | Â | Â |
| MinRStTrs | Min num of rows per stock tran | Int | 11 | - | Â | Â | Â |
| NoPriceLst | 'Number of Price Lists | Int | 11 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | CompDbNam |