| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | DocEntry | Internal Number | int | 11 | 0 | | | | Allow NULL? |
| 2 | DocNum | Document Number | int | 11 | 0 | | | | Allow NULL? |
| 3 | Series | Series | int | 11 | 0 | NNM1 | 0 | | Allow NULL? |
| 4 | ItemCode | Product No. | nvarchar | 50 | 0 | OITT | | | Allow NULL? |
| 5 | Status | Production Order Status | char | 1 | 0 | | P | C=Canceled, L=Closed, P=Planned, R=Released | Allow NULL? |
| 6 | Type | Production Order Type | char | 1 | 0 | | S | D=Disassembly, P=Special, S=Standard | Allow NULL? |
| 7 | PlannedQty | Planned Quantity - Header | num | 19 | 6 | | | | Allow NULL? |
| 8 | CmpltQty | Completed Quantity | num | 19 | 6 | | | | Allow NULL? |
| 9 | RjctQty | Rejected Quantity | num | 19 | 6 | | | | Allow NULL? |
| 10 | PostDate | Order Date | date | 8 | 0 | | | | |
| 11 | DueDate | Due Date | date | 8 | 0 | | | | |
| 12 | OriginAbs | Production Order Origin Entry | int | 11 | 0 | | | | Allow NULL? |
| 13 | OriginNum | Production Order Origin Number | int | 11 | 0 | | | | Allow NULL? |
| 14 | OriginType | Production Order Origin | char | 1 | 0 | | M | M=Manual, R=MRP, S=Sales Order, U=Upgrade | Allow NULL? |
| 15 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 16 | Comments | Remarks | nvarchar | 254 | 0 | | | | Allow NULL? |
| 17 | CloseDate | Closing Date | date | 8 | 0 | | | | |
| 18 | RlsDate | Release Date | date | 8 | 0 | | | | |
| 19 | CardCode | Customer Code | nvarchar | 15 | 0 | OCRD | | | Allow NULL? |
| 20 | Warehouse | Warehouse | nvarchar | 8 | 0 | OWHS | | | Allow NULL? |
| 21 | Uom | Inv. UoM in Production Order | nvarchar | 100 | 0 | | | | Allow NULL? |
| 22 | LineDirty | Line Modified | int | 11 | 0 | | | | Allow NULL? |
| 23 | JrnlMemo | Journal Remarks | nvarchar | 50 | 0 | | | | Allow NULL? |
| 24 | TransId | Transaction Number | int | 11 | 0 | OJDT | | | Allow NULL? |
| 25 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 26 | Printed | Printed | char | 1 | 0 | | N | N=Original, Y=Copy | Allow NULL? |
| 27 | OcrCode | Distribution Rule | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 28 | PIndicator | Period Indicator | nvarchar | 10 | 0 | OPID | | | Allow NULL? |
| 29 | OcrCode2 | Distribution Rule2 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 30 | OcrCode3 | Distribution Rule3 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 31 | OcrCode4 | Distribution Rule4 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 32 | OcrCode5 | Distribution Rule5 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 33 | SeqCode | Sequence Code | int | 6 | 0 | | | | Allow NULL? |
| 34 | Serial | Serial Number | int | 11 | 0 | | | | Allow NULL? |
| 35 | SeriesStr | Series String | nvarchar | 3 | 0 | | | | Allow NULL? |
| 36 | SubStr | Subseries String | nvarchar | 3 | 0 | | | | Allow NULL? |
| 37 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 38 | UserSign2 | Updating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 39 | UpdateDate | Update Date | date | 8 | 0 | | | | |
| 40 | Project | Project Code | nvarchar | 20 | 0 | OPRJ | | | Allow NULL? |
| 41 | SupplCode | Supplementary Code | nvarchar | 254 | 0 | | | | Allow NULL? |
| 42 | UomEntry | UoM Entry | int | 11 | 0 | OUOM | 0 | | Allow NULL? |
| 43 | PickRmrk | Pick Remarks | nvarchar | 254 | 0 | | | | Allow NULL? |
| 44 | SysCloseDt | System Closing Date | date | 8 | 0 | | | | |
| 45 | SysCloseTm | System Closing Time | int | 6 | 0 | | | | Allow NULL? |
| 46 | CloseVerNm | Closing Version Number | nvarchar | 11 | 0 | | | | Allow NULL? |
| 47 | StartDate | Start Date | date | 8 | 0 | | | | |
| 48 | ObjType | Object Type | nvarchar | 20 | 0 | | 202 | | Allow NULL? |
| 49 | ProdName | Product Description | nvarchar | 100 | 0 | | | | Allow NULL? |
| 50 | Priority | Priority | int | 6 | 0 | | 100 | | Allow NULL? |
| 51 | RouDatCalc | Routing Date Calculation | char | 1 | 0 | | S | B=End Date Backwards, D=On End Date, F=Start Date Forwards, S=On Start Date | Allow NULL? |
| 52 | UpdAlloc | Update Allocation | char | 1 | 0 | | M | A=Auto, M=Manual | Allow NULL? |
| 53 | CreateTS | Create Time - Incl. Secs | int | 11 | 0 | | | | Allow NULL? |
| 54 | UpdateTS | Update Full Time | int | 11 | 0 | | | | Allow NULL? |
| 55 | VersionNum | Version Number | nvarchar | 11 | 0 | | | | Allow NULL? |
| 56 | DataSource | Data Source | char | 1 | 0 | | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade | Allow NULL? |
| 57 | SAPPassprt | Extended SAP Passport | text | 16 | 0 | | | | |
