Demand
The Demand file contains all the records that the Lawson Warehouse system needs for processing demands.
REFERENCED BY
| RQ300 |
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | |
|---|---|---|---|
| WDM-COMPANY Element: Company | Numeric 4 This field contains the company number. |
||
| WDM-SYSTEM-CD Element: System Cd | Alpha 2 This field indicates from which Lawson system the document originated. OE = Customer Order RQ = Requisition IC = Intransit PO = Purchase Order CX = Case Cart WO = Work Order PH = Pharmacy |
||
| WDM-DOC-NBR Element: Doc Nbr | Alpha 10 (Right Justified) This field contains the document number for the shipment line. If this record was created from a purchase order, it will be the object ID from the POLINE since the PO Number is too long for this field. |
||
| WDM-DOC-NBR-NUM Element: Doc Nbr Num | Numeric 10 This field contains the numeric version of the document number. Order Entry and Requisitions use this field. For PO, this field will be the PLI-PO-RELEASE field. |
||
| WDM-LINE-NBR Element: Line Nbr | Numeric 6 This field contains the document line number. |
||
| WDM-COMPONENT-SEQ Element: Seq | Numeric 3 This field contains the component sequence number of the component item. |
||
| WDM-DOC-TYPE Element: Doc Type | Alpha 2 This field contains the type of document. For warehouse purposes, this is the shipping document. DT = Direct Transfer IR = Intransit Receiving IS = Issue IT = Transfer Issue SH = Shipment PO = Purchase Order WO = Work Order |
||
| WDM-RECORD-TYPE Element: Record Type | Alpha 1 This field identifies the type of demand record defined. Demand records are processed in the Lawson Warehouse system and supply records are not. D = Demand S = Supply |
||
| WDM-ITEM Element: Item | Alpha 32 This field contains the item identifier. |
||
| WDM-ITEM-DESC Element: Item Desc | Alpha 30 This field contains the description for inventoried and nonstock items. |
||
| WDM-LOCATION Element: Location | Alpha 5 This field contains a valid stock location within the company inventory. |
||
| WDM-DESTINATION Element: Destination | Alpha 15 This field contains the destination name for the shipment (ship-to customer). |
||
| WDM-ROUTE Element: Route | Numeric 4 This field contains the route number. The route assigned to the ship-to customer defaults from the Order Entry Route file. |
||
| WDM-STOP Element: Stop | Numeric 4 This field contains the stop within the route. If left blank, the stop associated with the ship-to customer defaults from the Route file. |
||
| WDM-RTE-CREATE-FL Element: Route Create Flag | Alpha 1 This field indicates whether a route record exists for this document line. |
||
| WDM-STATUS Element: Status | Numeric 1 This field contains the demand status. 0 = Unreleased 1 = Released for Processing |
||
| WDM-ALLOCABLE-FL Element: Allocatable Flag | Alpha 1 This field indicates whether demand lines are ready to be allocated or not. Y = Allocatable N = Not Ready for Allocation |
||
| WDM-ALLOC-BASIS Element: Alloc Basis | Alpha 1 This field is used to determine if the batch allocation program should allocate demand based on requested date or the priority. |
|
|
| WDM-LINE-TYPE Element: Line Type | Alpha 1 This field contains the type of item on this demand line. I = Inventoried N = Nonstock X = Special |
||
| WDM-QUANTITY Element: Quantity | Signed 13.4 This field contains the demand quantity. |
||
| WDM-ALLOC-QTY Element: Quantity | Signed 13.4 This field contains the quantity that has been allocated for this demand line. |
||
| WDM-BACKORD-QTY Element: Quantity | Signed 13.4 This field contains the backordered quantity that is not available in inventory for allocation. |
||
| WDM-PRINTED-QTY Element: Quantity | Signed 13.4 This field contains the quantity that was printed on the pick list to be picked. |
||
| WDM-IN-PROC-QTY Element: In-Process Quantity | Signed 13.4 This field contains the in-process quantity for the demand. |
||
| WDM-SHIPPED-QTY Element: Quantity | Signed 13.4 This field contains the quantity that was shipped. |
||
| WDM-PRE-ASMBLD-KIT Element: Pre-Assembled Kit | Signed 13.4 This field contains the quantity of make-to-order kits you want to preassemble. |
||
| WDM-DETAIL-QTY Element: Quantity | Signed 13.4 This field shows the quantity of demand lines with details. |
||
| WDM-UNIT-PRICE Element: Intl Cost | Signed 18.5 |
||
| WDM-UNIT-COST Element: Intl Cost | Signed 18.5 This field contains the unit cost for the document line. |
||
| WDM-TRAN-UOM Document Unit of Measure | Alpha 4 This field contains the unit of measure used for the document. |
||
| WDM-TRAN-UOM-MULT Document UOM Multiplier | Signed 13.7 This field contains the multiplier used to convert the document unit of measure to the stock unit of measure. |
||
| WDM-FUTURE-FL Element: Future Document Flag | Alpha 1 This field indicates if the document line has a future status. Y = Future Demand N = Current Demand |
||
| WDM-FIRM-FL Element: Firm Flag | Alpha 1 This field indicates whether allocation is firm or not for a document line item. If the allocation is set to Confirmed Demand, WH110 (Batch Allocation) will not let you deallocate this item later. Y = Confirmed Demand N = Open For Confirmation |
||
| WDM-SHIP-COMP-FL Element: Ship Comp Fl | Alpha 1 This field indicates whether or not the customer requires complete shipments. |
||
| WDM-BACK-ORD-FL Element: Back Ord Fl | Alpha 1 This field indicates whether or not the customer accepts backorders. Y = Backorder Allowed N = Backorder Not Allowed |
||
| WDM-KIT-FL Element: Kit Fl | Alpha 1 This field indicates the kind of kit item found on the document line. O = Make-to-Order Kit S = Make-to-Stock Kit N = Not a Kit |
||
| WDM-KIT-COMPLETE Element: Kit Complete | Alpha 1 This field indicates whether or not all kit options have been reviewed and selected for a kit item. Y = All kit options are reviewed N = All kit options not reviewed |
||
| WDM-PO-FLAG Element: PO Flag | Alpha 1 This field indicates whether or not the line is related to a purchase order. Y = Based on PO Receipt N = Not Related to PO |
||
| WDM-PICKING-REQ Element: Picking Required | Alpha 1 This field indicates whether the process type for the document requires picking feedback. Y = Picking is Required N = Picking is not Required |
||
| WDM-PACKING-REQ Element: Packing Required | Alpha 1 This field indicates whether or not the process type for this document requires packing feedback. Y = Packing is Required N = Packing is not Required |
||
| WDM-DETAIL-REQ Element: Detail Required | Alpha 1 This field indicates whether or not details are required for the document line item. Y = Details are Required N = Details are not Required |
||
| WDM-ALLOC-PRI Element: Allocation Priority | Numeric 2 This field indicates what allocation priority you gave to a document line. 00 = Priority of Allocation 99 = Priority of Allocation |
||
| WDM-HOLD-FL Element: Hold Flag | Alpha 1 This field indicates if the document line is on hold. The source for this field is the originating Lawson system. Y = Document Line is on Hold N = Document Line is not on Hold |
||
| WDM-MSDS-REQ-FL Element: All Flag | Alpha 1 Y = Yes N = No |
||
| WDM-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code. |
||
| WDM-CARRIER Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code. |
||
| WDM-CUST-SHIP-TO Customer Ship-To Number | Numeric 4 This field contains the ship-to customer number. |
||
| WDM-REQ-LOCATION Element: To Location | Alpha 5 The location that is requesting items. This location can be an inventory or nonstock location. |
||
| WDM-REQ-COMPANY Element: Requesting Company | Numeric 4 This field contains the requesting company. |
||
| WDM-ALLOCATE-DT Element: Date | Numeric 8 (yyyymmdd) This field contains the date that you want the document line to be allocated. |
||
| WDM-EST-TRAN-DT Element: Expected Ship Date | Numeric 8 (yyyymmdd) This field contains the expected ship date for the line. If you leave the field blank and no ship days are defined on the document's process level, the document date defaults. If ship dates exist on the process level, ship days are added to the document date to calculate the expected ship date. |
||
| WDM-SUGGESTED-LOT Element: Lot | Alpha 10 This field contains the suggested lot for lot-tracked items. |
||
| WDM-SHIP-ACCT-UNIT Element: Acct Unit | Alpha 15 This field contains a temporary general ledger shipping account unit. |
|
|
| WDM-SHIP-ACCOUNT Element: Account | Numeric 6 This field contains a temporary general ledger shipping account. |
|
|
| WDM-SHIP-SUB-ACCT Element: Sub Acct | Numeric 4 This field contains a temporary general ledger shipping subaccount. |
|
|
| WDM-RUSH-FL Element: All Flag | Alpha 1 The rush flag indicates if the document has a 'rush' placed on it. Y = Yes N = No |
||
| WDM-OBJ-ID-DMND Element: Obj Id | Numeric 12 This field contains the demand object identifier. |
|
|
| WDM-SEQ Element: Seq | Numeric 3 This field is used to create a value that is associated with the demand object id in the access path that gets demand records by demand object id. |
|
|
| WDM-FILL-OR-KILL Element: Fill Or Kill | Alpha 1 F = Fill Backorders K = Kill Backorders |
||
| WDM-ORIGIN Element: Origin | Derived This literal helps to determine from which Lawson system a document originated. |
|
|
| WDM-DOC-ALPHA Element: Doc Alpha | Derived This field contains the alpha version of the document number. |
|
|
| WDM-OPEN-DEMAND Element: Open Demand | Derived This field contains the total of the in-process quantity and the backorder quantity for a document line. |
|
|
| WDM-SRC-ITEM-DESC Element: Src Item Desc | Derived This field contains either the item master description or the document line description of an item. |
|
|
| WDM-TRAN-QUANTITY Element: Transaction Quantity | Derived This field shows the transaction quantity. |
|
|
| WDM-TRAN-ALLOCATED Transaction Allocated | Derived This field shows the transaction quantity allocated. |
|
|
| WDM-TRAN-BACKORD Transaction Backordered | Derived This field shows the amount of the transaction that is backordered. |
|
|
| WDM-TRAN-PRINTED Element: Transaction Printed | Derived This field shows the transaction amount that is printed. |
|
|
| WDM-TRAN-IN-PROC Transaction in Process | Derived This field shows the transaction that is currently in process. |
|
|
| WDM-TRAN-SHIPPED Element: Transaction Shipped | Derived This field shows the transaction that has been shipped. |
|
|
| WDM-DISP-QUANTITY Element: Display Quantity | Derived This field shows the displayed line quantity. |
|
|
| WDM-DISP-ALLOCATED Element: Display Allocated | Derived This field shows the displayed line quantity that is allocated. |
|
|
| WDM-DISP-BACKORD Element: Display Backordered | Derived This field shows the displayed line quantity that is backordered. |
|
|
| WDM-DISP-PRINTED Element: Display Printed | Derived This field shows the displayed line quantity that is printed. |
|
|
| WDM-DISP-IN-PROC Element: Display in Process | Derived This field shows the displayed line quantity that is currently in process. |
|
|
| WDM-DISP-SHIPPED Element: Display Shipped | Derived This field shows the displayed line quantity that has been shipped. |
|
|
| WDM-DISP-DOC-NBR Element: Disp Doc Nbr | Derived |
|
|
| WDM-ENTERED-ITEM Element: Entered Item | Alpha 25 |
||
| WDM-ENTRY-FL Element: Entry Fl | Alpha 1 1 = Item 2 = UPC 3 = UPN1 4 = UPN2 5 = NDC 6 = SKU |
||
| WDM-RQSRC-MACHINE Element: Rqsrc Machine | Alpha 6 ESIOB DROYAL HBOC OMNICL PAREXE PERSE PYXIS SSI |
||
| WDM-PAR-ORDER-ID Element: Par Order Id | Alpha 20 |
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | |||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| WDMSET1 |
COMPANY SYSTEM-CD DOC-NBR LINE-NBR COMPONENT-SEQ LOCATION |
|
||||||||||||||||||||||||||||||||||||||||||||
| WDMSET2 |
COMPANY LOCATION LINE-TYPE ITEM ALLOC-PRI DOC-NBR LINE-NBR ALLOCATE-DT SYSTEM-CD |
|
| |||||||||||||||||||||||||||||||||||||||||||
| WDMSET3 |
COMPANY LOCATION SYSTEM-CD DOC-NBR LINE-NBR |
|
||||||||||||||||||||||||||||||||||||||||||||
| WDMSET4 |
COMPANY SYSTEM-CD DOC-NBR LINE-NBR COMPONENT-SEQ ITEM LOCATION |
|
||||||||||||||||||||||||||||||||||||||||||||
| WDMSET5 |
COMPANY LOCATION ITEM EST-TRAN-DT DOC-TYPE SYSTEM-CD DOC-NBR LINE-NBR COMPONENT-SEQ |
|
||||||||||||||||||||||||||||||||||||||||||||
| WDMSET6 |
COMPANY LOCATION ITEM EST-TRAN-DT SYSTEM-CD DOC-NBR LINE-NBR COMPONENT-SEQ |
|
||||||||||||||||||||||||||||||||||||||||||||
| WDMSET7 |
COMPANY LOCATION SYSTEM-CD DOC-NBR LINE-NBR COMPONENT-SEQ |
|
||||||||||||||||||||||||||||||||||||||||||||
| WDMSET8 |
OBJ-ID-DMND SEQ |
|
||||||||||||||||||||||||||||||||||||||||||||
| WDMSET9 |
COMPANY SYSTEM-CD DOC-NBR LINE-NBR LOCATION COMPONENT-SEQ |
|
||||||||||||||||||||||||||||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Apcompany | APCOMPANY |
Not Required
| ||||||||||||||||||
| Apvenmast | APVENMAST |
Not Required
| ||||||||||||||||||
| Caseline | CXPREFITEM |
Required
| ||||||||||||||||||
| Coline | COLINE |
Required
| ||||||||||||||||||
| Custorder | CUSTORDER |
Required
| ||||||||||||||||||
| Iccompany | ICCOMPANY |
Required
| ||||||||||||||||||
| Iclocation | ICLOCATION |
Required
| ||||||||||||||||||
| Itemloc | ITEMLOC |
Required
| ||||||||||||||||||
| Itemmast | ITEMMAST |
Required
| ||||||||||||||||||
| Poline | POLINE |
Required
| ||||||||||||||||||
| Reqheader | REQHEADER |
Required
| ||||||||||||||||||
| Reqline | REQLINE |
Required
| ||||||||||||||||||
| Whdemndhdr | WHDEMNDHDR |
Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Itemlocs | ITEMLOC |
| |||||||||||||||||||||
| Sohdetail | SOHDETAIL |
| |||||||||||||||||||||
| Subloc | ITEMLOC |
|
All trademarks and registered trademarks are the property of their
respective owners.