📚 SAP Business One SDK Help

Table Name: AWOR

Table Description: Production Order - History

Field Description Type Size Related Default Value Constraints
DocEntry Internal Number Int 11 -      
DocNum Document Number Int 11 -      
Series Series Int 11 NNM1 0    
ItemCode Product No. nVarChar 50 OITT      
Status Production Order Status VarChar 1 - P P Planned
            R Released
            L Closed
            C Canceled
Type Production Order Type VarChar 1 - S S Standard
            P Special
            D Disassembly
PlannedQty Planned Quantity - Header Num 19.6 -      
CmpltQty Completed Quantity Num 19.6 -      
RjctQty Rejected Quantity Num 19.6 -      
PostDate Order Date Date 8 -      
DueDate Due Date Date 8 -      
OriginAbs Production Order Origin Entry Int 11 -      
OriginNum Production Order Origin Number Int 11 -      
OriginType Production Order Origin VarChar 1 - M M Manual
            R MRP
            S Sales Order
            U Upgrade
            P Production Order
UserSign User Signature Int 6 OUSR      
Comments Remarks nVarChar 254 -      
CloseDate Closing Date Date 8 -      
RlsDate Release Date Date 8 -      
CardCode Customer Code nVarChar 15 OCRD      
Warehouse Warehouse nVarChar 8 OWHS      
Uom Inv. UoM in Production Order nVarChar 100 -      
LineDirty Line Modified Int 11 -      
JrnlMemo Journal Remarks nVarChar 254 -      
TransId Transaction Number Int 11 OJDT      
CreateDate Creation Date Date 8 -      
Printed Printed VarChar 1 - N Y Copy
            N Original
OcrCode Distribution Rule nVarChar 8 OOCR      
PIndicator Period Indicator nVarChar 10 OPID ' '    
OcrCode2 Distribution Rule2 nVarChar 8 OOCR      
OcrCode3 Distribution Rule3 nVarChar 8 OOCR      
OcrCode4 Distribution Rule4 nVarChar 8 OOCR      
OcrCode5 Distribution Rule5 nVarChar 8 OOCR      
SeqCode Sequence Code Int 6 -      
Serial Serial Number Int 11 -      
SeriesStr Series String nVarChar 3 -      
SubStr Subseries String nVarChar 3 -      
LogInstanc Log Instance Int 11 - 0    
UserSign2 Updating User Int 6 OUSR      
UpdateDate Update Date Date 8 -      
Project Project Code nVarChar 20 OPRJ      
SupplCode Supplementary Code nVarChar 254 -      
UomEntry UoM Entry Int 11 OUOM 0    
PickRmrk Pick Remarks nVarChar 254 -      
SysCloseDt System Closing Date Date 8 -      
SysCloseTm System Closing Time Int 6 -      
CloseVerNm Closing Version Number nVarChar 13 -      
StartDate Start Date Date 8 -      
ObjType Object Type nVarChar 20 - 202    
ProdName Product Description nVarChar 200 -      
Priority Priority Int 6 - 100    
RouDatCalc Routing Date Calculation VarChar 1 - S S On Start Date
            D On End Date
            F Start Date Forwards
            B End Date Backwards
UpdAlloc Update Allocation VarChar 1 - M M Manual
            A Auto
CreateTS Create Time - Incl. Secs Int 11 -      
UpdateTS Update Full Time Int 11 -      
VersionNum Version Number nVarChar 13 -      
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Upgrade
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Auto Summary
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
SAPPassprt Extended SAP Passport Text 16 -      
AtcEntry Attachment Entry Int 11 OATC      
Attachment Attachment Text 16 -      
AsChild Parent set as component VarChar 1 - N Y Parent set as component
            N Parent not set as component
LinkToObj Linked To nVarChar 20 - 17 202 Production Order
            17 Sales Order
ProcItms Procure Items VarChar 1 - N Y Yes
            N No
ReopOriDoc Reopen Origin. Doc Cancel VarChar 1 -   Y Yes
            N No
Key Unique Field
PRIMARY Yes DocEntry
    LogInstanc
NUM Yes DocNum
    PIndicator
    LogInstanc
ITEM_CODE No ItemCode