📚 SAP Business One SDK Help

Table Name: UWOR1

Table Description: Production Order - Rows

Field Description Type Size Related Default Value Constraints
DocEntry Document Internal Number Int 11 OWOR      
LineNum Row Number Int 11 -      
ItemCode Item No. nVarChar 50 -      
BaseQty Base Quantity Num 19.6 -      
PlannedQty Planned Quantity - Rows Num 19.6 -      
IssuedQty Issued Quantity Num 19.6 -      
IssueType Production Order Issue Type VarChar 1 -   M Manual
            B Backflush
wareHouse Warehouse nVarChar 8 OWHS      
VisOrder Visual Order Int 11 -      
WipActCode WIP Account Code nVarChar 15 OACT      
CompTotal Total Completed Sum Num 19.6 -      
OcrCode Distribution Rule nVarChar 8 OOCR      
OcrCode2 Distribution Rule2 nVarChar 8 OOCR      
OcrCode3 Distribution Rule3 nVarChar 8 OOCR      
OcrCode4 Distribution Rule4 nVarChar 8 OOCR      
OcrCode5 Distribution Rule5 nVarChar 8 OOCR      
LocCode Location Code Int 11 OLCT      
LogInstanc Log Instance Int 11 - 0    
Project Project Code nVarChar 20 OPRJ      
UomEntry UoM Entry Int 11 OUOM 0    
UomCode UoM Code nVarChar 20 -      
ItemType Item Type Int 11 - 4 4 Item
            290 Resource
            -18 Text
AdditQty Additional Quantity Num 19.6 -      
LineText Row Text Text 16 -      
PickStatus Pick Status VarChar 1 - N Y Picked
            N Not Picked
            R Release for Picking
            P Partially Picked
PickQty Pick Quantity Num 19.6 -      
PickIdNo Pick List ID Number Int 11 -      
ReleaseQty Released Quantity Num 19.6 -      
ResAlloc Resource Allocation VarChar 1 -   S On Start Date
            D On End Date
            F Start Date Forwards
            B End Date Backwards
StartDate Start Date Date 8 -      
EndDate End Date Date 8 -      
StageId Stage ID Int 11 -      
BaseQtyNum Base Quantity Numerator Num 19.6 -      
BaseQtyDen Base Quantity Denominator Num 19.6 -      
ReqDays Required Days Num 19.6 - 0    
RtCalcProp Routing Calculation Proportion Num 19.6 - 100    
Status Stage Status VarChar 1 - P P Planned
            I In Progress
            C Complete
ItemName Item Description nVarChar 200 -      
AlwProcDoc Allow Procurement Doc. VarChar 1 - N Y Yes
            N No
PoDocType Procmnt Doc. Type Int 11 -      
PoDocNum Procmnt Doc. No. Int 11 -      
PoDocEntry Procmnt Doc. Internal ID Int 11 -      
PoLineNum Procmnt Doc. Row No. Int 11 -      
PoQuantity Procmnt Quantity Num 19.6 -      
PPTaxExRe Plastic Packaging Tax Exemption Reason nVarChar 2 -      
PlPaWght Plastic Packaging Weight Num 19.6 -      
Key Unique Field
PRIMARY Yes DocEntry
    LineNum
VISORDER Yes DocEntry
    VisOrder
ITEM_WHS No ItemCode
    wareHouse