|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Input Service Distribution
Table Name: OISD
Table Description: Input Service Distribution
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| DocNum | Document Number | Int | 11 | - | Â | Â | Â |
| SrcLctCode | Source Location Code | Int | 11 | - | Â | Â | Â |
| SrcLctName | Source Location Name | nVarChar | 100 | - | Â | Â | Â |
| Series | Series | Int | 11 | NNM1 | Â | Â | Â |
| PostDate | Posting Date | Date | 8 | - | Â | Â | Â |
| DocDate | Document Date | Date | 8 | - | Â | Â | Â |
| DocStatus | Document Status | VarChar | 1 | - | O | O | Open |
| Â | Â | Â | Â | Â | Â | C | Canceled |
| Revised | Revised | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| OrgRefNo | Original Reference No. | nVarChar | 100 | - | Â | Â | Â |
| OrgRefEty | Original Reference Entry | Int | 11 | - | Â | Â | Â |
| OrgDocDate | Original Document Date | Date | 8 | - | Â | Â | Â |
| Comments | Remarks | nVarChar | 254 | - | Â | Â | Â |
| ObjType | Object Type | nVarChar | 20 | - | Â | Â | Â |
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| Â | Â | Â | Â | Â | Â | I | Interface |
| Â | Â | Â | Â | Â | Â | U | Update |
| Â | Â | Â | Â | Â | Â | M | Import |
| Â | Â | Â | Â | Â | Â | O | DI API |
| Â | Â | Â | Â | Â | Â | S | Service Layer |
| Â | Â | Â | Â | Â | Â | W | Web Client |
| Â | Â | Â | Â | Â | Â | A | Doc. Generation Wizard |
| Â | Â | Â | Â | Â | Â | D | Restore Wizard |
| Â | Â | Â | Â | Â | Â | P | Partner Implementation |
| Â | Â | Â | Â | Â | Â | T | Year Transfer |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| CreateDate | Create Date | Date | 8 | - | Â | Â | Â |
| UserSign2 | Updating User | Int | 6 | OUSR | Â | Â | Â |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| Handwrtten | Manual Numbering | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| PIndicator | Period Indicator | nVarChar | 10 | OPID | Â | Â | Â |
| DstPercent | Percent to Distribute | Num | 19.6 | - | Â | Â | Â |
| BPLId | Branch | Int | 11 | OBPL | Â | Â | Â |
| BPLName | Branch Name | nVarChar | 200 | - | Â | Â | Â |
| VATRegNum | VAT Reg. Number | nVarChar | 32 | - | Â | Â | Â |
| SrcDocType | Source Document Type | Int | 11 | - | Â | 18 | GST Tax Invoice |
| Â | Â | Â | Â | Â | Â | -19 | GST Debit Memo/GST Credit Memo |
| FromNum | Document Number From | Int | 11 | - | Â | Â | Â |
| ToNum | Document Number To | Int | 11 | - | Â | Â | Â |
| FromDate | Document Date From | Date | 8 | - | Â | Â | Â |
| ToDate | Document Date To | Date | 8 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| INDEX | Yes | DocNum |
| Â | Â | PIndicator |