You are here: Reference Guide > Table Structures > Inventory > IN_OnBackOrder

IN_OnBackOrder

Purpose    

Maintains the current status of inventory items on back order, including the sales order and debtor that originated the transaction(s).  The date and time is recorded to allocate stock on the FIFO method of stock control unless the priority if allocation is changed by a user.

Path    

Process Sales Orders and Process Back Orders run

Name

Type

Linked To/Supplied

OrdersOnBackID

Text (20)

 

LastSavedDateTime

Date/Time

 

TranDate

Date/Time

 

InvoiceType

Number (Integer)

0 = Normal Sales Order (When INAssemblyID <> blank then Assembly);1 = Back to back;2 = Job Costing;4 = Service Manager;6 = Bill OF Materials

InvoiceID

Text (20)

SO_Main.InvoiceID

InvoiceLineID

Text (20)

 

DebtorID

Text (20)

DB_Main1.DebtorID

InventoryID

Text (20)

IN_Main.InventoryID

OrderID

Text (20)

PO_Main.OrderID

OrderLineID

Text (20)

PO_Lines.OrderLineID

Quantity

Number (Float)

 

Price

Number (Float)

 

EstBOValue

Number (Float)

 

Priority

Text(34)

 

IN_LogicalID

Text (20)

IN_Logical.IN_LogicalID

ForLogicalID

Text (20)

IN_Logical.IN_LogicalID

ForAnotherWarehouse

Number (Integer)

 

INAssemblyID

Text (20)

IN_Assembly.INAssemblyID

BackOrderMode

Number (Integer)

0 = Normal;1 = Manual

Copyright © 2012 Jiwa Financials. All rights reserved.