RE: Reservation table details - 337
Hi
For table relationship see this : dynamicsdocs.com/.../reservation-entry
Reservation Status:
Reservation: This is a reservation. Usually, the user has reserved this item for the order
Tracking: The program has allocated the supply for this demand. The system only tracks if the Tracking Policy field on the item card is set to Tracking Only or Tracking & Action Msg., or during planning in the planning worksheet.
Surplus: Surplus occurs in connection with tracking, for example, if the supply is not allocated to any demand, or the demand is not allocated to any supply.
Prospect: Used for non-order network entities, e.g. item journal line, to carry item tracking.
Source Subtype Field
Indicates which source subtype the reservation entry is related to. If the entry is related to a purchase or sales line, the field is copied from the Document Type field on the line. If it is related to a journal line, the field is copied from the Entry Type field on the journal line.
"Source type" is the ID of the related table. so if it says "37", then it's "Sales Line".
"Source Subtype" is a further identification of the related table. In case of "Source type" = "37", then "source subtype" is the field "Document type" of table 37. In this case it could be Quote, Order, Invoice, Credit Memo, Blanket Order, Return Order. For purchase table it could be different subtype. If you use Journal Line then it is depends on Entry Type on the journal line.
Source Batch Name Field
Contains the journal batch name if the item comes from a journal line. The program copies the source batch name from the Batch Name field on the journal line. You need to add something to reservation table through journal to populate this.