|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Docs. for Confirmation
Table Name: OWDD
Table Description: Docs. for Confirmation
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| WddCode | Internal Number | Int | 11 | - | Â | Â | Â |
| WtmCode | Authorization Template | Int | 11 | OWTM | Â | Â | Â |
| OwnerID | Production Code | Int | 11 | OUSR | Â | Â | Â |
| DocEntry | Document Counter | Int | 11 | - | Â | Â | Â |
| ObjType | Object Type | nVarChar | 20 | - | Â | 23 | Sales Quotation |
| Â | Â | Â | Â | Â | Â | 17 | Sales Order |
| Â | Â | Â | Â | Â | Â | 15 | Delivery |
| Â | Â | Â | Â | Â | Â | 234000031 | Return Request |
| Â | Â | Â | Â | Â | Â | 16 | Return |
| Â | Â | Â | Â | Â | Â | 203 | A/R Down Payment |
| Â | Â | Â | Â | Â | Â | 13 | A/R Invoice |
| Â | Â | Â | Â | Â | Â | 165 | A/R Correction Invoice |
| Â | Â | Â | Â | Â | Â | 166 | A/R Correction Invoice Reversal |
| Â | Â | Â | Â | Â | Â | 14 | A/R Credit Memo |
| Â | Â | Â | Â | Â | Â | 132 | Correction Invoice |
| Â | Â | Â | Â | Â | Â | 1470000113 | Purchase Request |
| Â | Â | Â | Â | Â | Â | 540000006 | Purchase Quotation |
| Â | Â | Â | Â | Â | Â | 22 | Purchase Order |
| Â | Â | Â | Â | Â | Â | 20 | Goods Receipt PO |
| Â | Â | Â | Â | Â | Â | 234000032 | Goods Return Request |
| Â | Â | Â | Â | Â | Â | 21 | Goods Returns |
| Â | Â | Â | Â | Â | Â | 204 | A/P Down Payment |
| Â | Â | Â | Â | Â | Â | 18 | A/P Invoice |
| Â | Â | Â | Â | Â | Â | 163 | A/P Correction Invoice |
| Â | Â | Â | Â | Â | Â | 164 | A/P Correction Invoice Reversal |
| Â | Â | Â | Â | Â | Â | 19 | A/P Credit Memo |
| Â | Â | Â | Â | Â | Â | 59 | Goods Receipt |
| Â | Â | Â | Â | Â | Â | 60 | Goods Issue |
| Â | Â | Â | Â | Â | Â | 1250000001 | Inventory Transfer Request |
| Â | Â | Â | Â | Â | Â | 67 | Inventory Transfer |
| Â | Â | Â | Â | Â | Â | 310000001 | Inventory Opening Balance |
| Â | Â | Â | Â | Â | Â | 46 | Outgoing Payment |
| Â | Â | Â | Â | Â | Â | 1250000026 | Sales Blanket Agreements |
| Â | Â | Â | Â | Â | Â | 1250000027 | Purchase Blanket Agreements |
| Â | Â | Â | Â | Â | Â | 1470000065 | Inventory Counting |
| Â | Â | Â | Â | Â | Â | 10000071 | Inventory Posting |
| Â | Â | Â | Â | Â | Â | 112 | Documents - Drafts |
| Â | Â | Â | Â | Â | Â | 140 | Payment Drafts |
| Â | Â | Â | Â | Â | Â | 1470000109 | Inventory Counting - Drafts |
| Â | Â | Â | Â | Â | Â | 1470000136 | Inventory Posting - Drafts |
| Â | Â | Â | Â | Â | Â | 1470000131 | Inventory Opening Balance - Drafts |
| DocDate | Posting Date | Date | 8 | - | Â | Â | Â |
| CurrStep | Stage Code | Int | 11 | OWST | Â | Â | Â |
| Status | Status | VarChar | 1 | - | W | W | Pending |
| Â | Â | Â | Â | Â | Â | Y | Approved |
| Â | Â | Â | Â | Â | Â | N | Rejected |
| Â | Â | Â | Â | Â | Â | P | Generated |
| Â | Â | Â | Â | Â | Â | A | Generated by Authorizer |
| Â | Â | Â | Â | Â | Â | C | Canceled |
| Remarks | Remarks | nVarChar | 254 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| CreateDate | Production Date | Date | 8 | - | Â | Â | Â |
| CreateTime | Production Time | Int | 6 | - | Â | Â | Â |
| IsDraft | Draft | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| MaxReqr | No. of Authorizers | Int | 6 | - | Â | Â | Â |
| MaxRejReqr | No. of Rejects | Int | 6 | - | Â | Â | Â |
| SrcDocEnt | Source Document Internal ID | Int | 11 | - | Â | Â | Â |
| DraftType | Draft Type | nVarChar | 20 | - | Â | 112 | Documents - Drafts |
| Â | Â | Â | Â | Â | Â | 140 | Payment Drafts |
| Â | Â | Â | Â | Â | Â | 1470000109 | Inventory Counting - Drafts |
| Â | Â | Â | Â | Â | Â | 1470000136 | Inventory Posting - Drafts |
| Â | Â | Â | Â | Â | Â | 1470000131 | Inventory Opening Balance - Drafts |
| DraftEntry | Draft Internal Number | Int | 11 | - | Â | Â | Â |
| BFType | Business Flow Type | VarChar | 1 | - | Â | A | Create |
| Â | Â | Â | Â | Â | Â | U | Update |
| ProcessID | Approval Process ID | Int | 11 | - | Â | Â | Â |
| ProcesStat | Approval Process Status | VarChar | 1 | - | W | W | Pending |
| Â | Â | Â | Â | Â | Â | Y | Approved |
| Â | Â | Â | Â | Â | Â | N | Rejected |
| Â | Â | Â | Â | Â | Â | P | Generated |
| Â | Â | Â | Â | Â | Â | A | Generated by Authorizer |
| Â | Â | Â | Â | Â | Â | C | Canceled |
| StpUpdated | Stages Updated | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Key | Unique | Field |
| PRIMARY | Yes | WddCode |
| PROCESS | No | ProcessID |