| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | WddCode | Internal Number | int | 11 | 0 | | | | Allow NULL? |
| 2 | WtmCode | Authorization Template | int | 11 | 0 | OWTM | | | Allow NULL? |
| 3 | OwnerID | Production Code | int | 11 | 0 | OUSR | | | Allow NULL? |
| 4 | DocEntry | Document Counter | int | 11 | 0 | | | | Allow NULL? |
| 5 | ObjType | Object Type | nvarchar | 20 | 0 | | | (-=(-, 112=Documents - Drafts, 132=Correction Invoice, 13=A/R Invoice, 140=Payment Drafts, 14=A/R Credit Memo, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Return, 17=Sales Order, 18=A/P Invoice, 19=A/P Credit Memo, 203=A/R Down Payment, 20 | Allow NULL? |
| 6 | DocDate | Posting Date | date | 8 | 0 | | | | |
| 7 | CurrStep | Stage Code | int | 11 | 0 | OWST | | | Allow NULL? |
| 8 | Status | Status | char | 1 | 0 | | W | A=Generated By Authorizer, C=Cancelled, N=Rejected, P=Generated, W=Pending, Y=Approved | Allow NULL? |
| 9 | Remarks | Remarks | nvarchar | 100 | 0 | | | | Allow NULL? |
| 10 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 11 | CreateDate | Production Date | date | 8 | 0 | | | | |
| 12 | CreateTime | Production Time | int | 6 | 0 | | | | Allow NULL? |
| 13 | IsDraft | Draft | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 14 | MaxReqr | No. of Authorizers | int | 6 | 0 | | | | Allow NULL? |