Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
MANUFACTUREORDER_I | Manufacture Order |
String | 32 | View | |
MANUFACTUREORDERST_I | Manufacture Order Status |
Integer | 2 | View | |
ENDQTY_I | End QTY |
Currency | 10 | View | |
QTYRECVD | QTY Received |
Currency | 10 | View | |
ITEMNMBR | Item Number |
String | 32 | View | |
VCTNMTHD | Valuation Method 1. FIFO Perpetual |
Integer | 2 | View | |
DECPLQTY | Decimal Places QTYS |
Integer | 2 | View | |
DECPLCUR | Decimal Places Currency |
Integer | 2 | View | |
STDMATQTYRCD | Var_StdMatQtyRcd |
Currency | 10 | View | |
STDMATFOQTYRCD | Var_StdMatFoQtyRcd |
Currency | 10 | View | |
STDMATVOQTYRCD | Var_StdMatVoQtyRcd |
Currency | 10 | View | |
STDLABQTYRCD | Var_StdLabQtyRcd |
Currency | 10 | View | |
STDLABFOQTYRCD | Var_StdLabFoQtyRcd |
Currency | 10 | View | |
STDLABVOQTYRCD | Var_StdLabVoQtyRcd |
Currency | 10 | View | |
STDMACHQTYRCD | Var_StdMachQtyRcd |
Currency | 10 | View | |
STDMACHFOQTYRCD | Var_StdMachFoQtyRcd |
Currency | 10 | View | |
STDMACHVOQTYRCD | Var_StdMachVoQtyRcd |
Currency | 10 | View | |
STDTOTALQTYRCD | Var_StdTotalQtyRcd |
Currency | 10 | View | |
STDMATQTYEND | Var_StdMatQtyEnd |
Currency | 10 | View | |
STDMATFOQTYEND | Var_StdMatFoQtyEnd |
Currency | 10 | View | |
STDMATVOQTYEND | Var_StdMatVoQtyEnd |
Currency | 10 | View | |
STDLABQTYEND | Var_StdLabQtyEnd |
Currency | 10 | View | |
STDLABFOQTYEND | Var_StdLabFoQtyEnd |
Currency | 10 | View | |
STDLABVOQTYEND | Var_StdLabVoQtyEnd |
Currency | 10 | View | |
STDMACHQTYEND | Var_StdMachQtyEnd |
Currency | 10 | View | |
STDMACHFOQTYEND | Var_StdMachFoQtyEnd |
Currency | 10 | View | |
STDMACHVOQTYEND | Var_StdMachVoQtyEnd |
Currency | 10 | View | |
STDTOTALQTYEND | Var_StdTotalQtyEnd |
Currency | 10 | View | |
PRODMATQTYRCD | Var_ProdMatQtyRcd |
Currency | 10 | View | |
PRODMATFOQTYRCD | Var_ProdMatFoQtyRcd |
Currency | 10 | View | |
PRODMATVOQTYRCD | Var_ProdMatVoQtyRcd |
Currency | 10 | View | |
PRODLABQTYRCD | Var_ProdLabQtyRcd |
Currency | 10 | View | |
PRODLABFOQTYRCD | Var_ProdLabFoQtyRcd |
Currency | 10 | View | |
PRODLABVOQTYRCD | Var_ProdLabVoQtyRcd |
Currency | 10 | View | |
PRODMACHQTYRCD | Var_ProdMachQtyRcd |
Currency | 10 | View | |
PRODMACHFOQTYRCD | Var_ProdMachFoQtyRcd |
Currency | 10 | View | |
PRODMACHVOQTYRCD | Var_ProdMachVoQtyRcd |
Currency | 10 | View | |
PRODTOTALQTYRCD | Var_ProdTotalQtyRcd |
Currency | 10 | View | |
PRODMATQTYEND | Var_ProdMatQtyEnd |
Currency | 10 | View | |
PRODMATFOQTYEND | Var_ProdMatFoQtyEnd |
Currency | 10 | View | |
PRODMATVOQTYEND | Var_ProdMatVoQtyEnd |
Currency | 10 | View | |
PRODLABQTYEND | Var_ProdLabQtyEnd |
Currency | 10 | View | |
PRODLABFOQTYEND | Var_ProdLabFoQtyEnd |
Currency | 10 | View | |
PRODLABVOQTYEND | Var_ProdLabVoQtyEnd |
Currency | 10 | View | |
PRODMACHQTYEND | Var_ProdMachQtyEnd |
Currency | 10 | View | |
PRODMACHFOQTYEND | Var_ProdMachFoQtyEnd |
Currency | 10 | View | |
PRODMACHVOQTYEND | Var_ProdMachVoQtyEnd |
Currency | 10 | View | |
PRODTOTALQTYEND | Var_ProdTotalQtyEnd |
Currency | 10 | View | |
MATWIPIN | Var_MatQtyWipIn |
Currency | 10 | View | |
MATFOWIPIN | Var_MatFoQtyWipIn |
Currency | 10 | View | |
MATVOWIPIN | Var_MatVoQtyWipIn |
Currency | 10 | View | |
LABWIPIN | Var_LabQtyWipIn |
Currency | 10 | View | |
LABFOWIPIN | Var_LabFoQtyWipIn |
Currency | 10 | View | |
LABVOWIPIN | Var_LabVoQtyWipIn |
Currency | 10 | View | |
MACHWIPIN | Var_MachQtyWipIn |
Currency | 10 | View | |
MACHFOWIPIN | Var_MachFoQtyWipIn |
Currency | 10 | View | |
MACHVOWIPIN | Var_MachVoQtyWipIn |
Currency | 10 | View | |
TOTALWIPIN | Var_TotalQtyWipIn |
Currency | 10 | View | |
MATWIPCONSUMED | Var_MatQtyWipConsumed |
Currency | 10 | View | |
MATFOWIPCONSUMED | Var_MatFoQtyWipConsumed |
Currency | 10 | View | |
MATVOWIPCONSUMED | Var_MatVoQtyWipConsumed |
Currency | 10 | View | |
LABWIPCONSUMED | Var_LabQtyWipConsumed |
Currency | 10 | View | |
LABFOWIPCONSUMED | Var_LabFoQtyWipConsumed |
Currency | 10 | View | |
LABVOWIPCONSUMED | Var_LabVoQtyWipConsumed |
Currency | 10 | View | |
MACHWIPCONSUMED | Var_MachQtyWipConsumed |
Currency | 10 | View | |
MACHFOWIPCONSUMED | Var_MachFoQtyWipConsumed |
Currency | 10 | View | |
MACHVOWIPCONSUMED | Var_MachVoQtyWipConsumed |
Currency | 10 | View | |
TOTALWIPCONSUMED | Var_TotalQtyWipConsumed |
Currency | 10 | View | |
STDMATQTYRCDVAR | Var_StdMatQtyRcdVar |
Currency | 10 | View | |
STDMATFOQTYRCDVAR | Var_StdMatFoQtyRcdVar |
Currency | 10 | View | |
STDMATVOQTYRCDVAR | Var_StdMatVoQtyRcdVar |
Currency | 10 | View | |
STDLABQTYRCDVAR | Var_StdLabQtyRcdVar |
Currency | 10 | View | |
STDLABFOQTYRCDVAR | Var_StdLabFoQtyRcdVar |
Currency | 10 | View | |
STDLABVOQTYRCDVAR | Var_StdLabVoQtyRcdVar |
Currency | 10 | View | |
STDMACHQTYRCDVAR | Var_StdMachQtyRcdVar |
Currency | 10 | View | |
STDMACHFOQTYRCDVAR | Var_StdMachFoQtyRcdVar |
Currency | 10 | View | |
STDMACHVOQTYRCDVAR | Var_StdMachVoQtyRcdVar |
Currency | 10 | View | |
STDTOTALQTYRCDVAR | Var_StdTotalQtyRcdVar |
Currency | 10 | View | |
STDMATQTYENDVAR | Var_StdMatQtyEndVar |
Currency | 10 | View | |
STDMATFOQTYENDVAR | Var_StdMatFoQtyEndVar |
Currency | 10 | View | |
STDMATVOQTYENDVAR | Var_StdMatVoQtyEndVar |
Currency | 10 | View | |
STDLABQTYENDVAR | Var_StdLabQtyEndVar |
Currency | 10 | View | |
STDLABFOQTYENDVAR | Var_StdLabFoQtyEndVar |
Currency | 10 | View | |
STDLABVOQTYENDVAR | Var_StdLabVoQtyEndVar |
Currency | 10 | View | |
STDMACHQTYENDVAR | Var_StdMachQtyEndVar |
Currency | 10 | View | |
STDMACHFOQTYENDVAR | Var_StdMachFoQtyEndVar |
Currency | 10 | View | |
STDMACHVOQTYENDVAR | Var_StdMachVoQtyEndVar |
Currency | 10 | View | |
STDTOTALQTYENDVAR | Var_StdTotalQtyEndVar |
Currency | 10 | View | |
STDMATQTYRCDVARPCT | Var_StdMatQtyRcdVarPct |
Currency | 10 | View | |
STDMATFOQTYRCDVARPCT | Var_StdMatFoQtyRcdVarPct |
Currency | 10 | View | |
STDMATVOQTYRCDVARPCT | Var_StdMatVoQtyRcdVarPct |
Currency | 10 | View | |
STDLABQTYRCDVARPCT | Var_StdLabQtyRcdVarPct |
Currency | 10 | View | |
STDLABFOQTYRCDVARPCT | Var_StdLabFoQtyRcdVarPct |
Currency | 10 | View | |
STDLABVOQTYRCDVARPCT | Var_StdLabVoQtyRcdVarPct |
Currency | 10 | View | |
STDMACHQTYRCDVARPCT | Var_StdMachQtyRcdVarPct |
Currency | 10 | View | |
STDMACHFOQTYRCDVARPCT | Var_StdMachFoQtyRcdVarPct |
Currency | 10 | View | |
STDMACHVOQTYRCDVARPCT | Var_StdMachVoQtyRcdVarPct |
Currency | 10 | View | |
STDTOTALQTYRCDVARPCT | Var_StdTotalQtyRcdVarPct |
Currency | 10 | View | |
STDMATQTYENDVARPCT | Var_StdMatQtyEndVarPct |
Currency | 10 | View | |
STDMATFOQTYENDVARPCT | Var_StdMatFoQtyEndVarPct |
Currency | 10 | View | |
STDMATVOQTYENDVARPCT | Var_StdMatVoQtyEndVarPct |
Currency | 10 | View | |
STDLABQTYENDVARPCT | Var_StdLabQtyEndVarPct |
Currency | 10 | View | |
STDLABFOQTYENDVARPCT | Var_StdLabFoQtyEndVarPct |
Currency | 10 | View | |
STDLABVOQTYENDVARPCT | Var_StdLabVoQtyEndVarPct |
Currency | 10 | View | |
STDMACHQTYENDVARPCT | Var_StdMachQtyEndVarPct |
Currency | 10 | View | |
STDMACHFOQTYENDVARPCT | Var_StdMachFoQtyEndVarPct |
Currency | 10 | View | |
STDMACHVOQTYENDVARPCT | Var_StdMachVoQtyEndVarPct |
Currency | 10 | View | |
STDTOTALQTYENDVARPCT | Var_StdTotalQtyEndVarPct |
Currency | 10 | View | |
PRODMATQTYRCDVAR | Var_ProdMatQtyRcdVar |
Currency | 10 | View | |
PRODMATFOQTYRCDVAR | Var_ProdMatFoQtyRcdVar |
Currency | 10 | View | |
PRODMATVOQTYRCDVAR | Var_ProdMatVoQtyRcdVar |
Currency | 10 | View | |
PRODLABQTYRCDVAR | Var_ProdLabQtyRcdVar |
Currency | 10 | View | |
PRODLABFOQTYRCDVAR | Var_ProdLabFoQtyRcdVar |
Currency | 10 | View | |
PRODLABVOQTYRCDVAR | Var_ProdLabVoQtyRcdVar |
Currency | 10 | View | |
PRODMACHQTYRCDVAR | Var_ProdMachQtyRcdVar |
Currency | 10 | View | |
PRODMACHFOQTYRCDVAR | Var_ProdMachFoQtyRcdVar |
Currency | 10 | View | |
PRODMACHVOQTYRCDVAR | Var_ProdMachVoQtyRcdVar |
Currency | 10 | View | |
PRODTOTALQTYRCDVAR | Var_ProdTotalQtyRcdVar |
Currency | 10 | View | |
PRODMATQTYENDVAR | Var_ProdMatQtyEndVar |
Currency | 10 | View | |
PRODMATFOQTYENDVAR | Var_ProdMatFoQtyEndVar |
Currency | 10 | View | |
PRODMATVOQTYENDVAR | Var_ProdMatVoQtyEndVar |
Currency | 10 | View | |
PRODLABQTYENDVAR | Var_ProdLabQtyEndVar |
Currency | 10 | View | |
PRODLABFOQTYENDVAR | Var_ProdLabFoQtyEndVar |
Currency | 10 | View | |
PRODLABVOQTYENDVAR | Var_ProdLabVoQtyEndVar |
Currency | 10 | View | |
PRODMACHQTYENDVAR | Var_ProdMachQtyEndVar |
Currency | 10 | View | |
PRODMACHFOQTYENDVAR | Var_ProdMachFoQtyEndVar |
Currency | 10 | View | |
PRODMACHVOQTYENDVAR | Var_ProdMachVoQtyEndVar |
Currency | 10 | View | |
PRODTOTALQTYENDVAR | Var_ProdTotalQtyEndVar |
Currency | 10 | View | |
PRODMATQTYRCDVARPCT | Var_ProdMatQtyRcdVarPct |
Currency | 10 | View | |
PRODMATFOQTYRCDVARPCT | Var_ProdMatFoQtyRcdVarPct |
Currency | 10 | View | |
PRODMATVOQTYRCDVARPCT | Var_ProdMatVoQtyRcdVarPct |
Currency | 10 | View | |
PRODLABQTYRCDVARPCT | Var_ProdLabQtyRcdVarPct |
Currency | 10 | View | |
PRODLABFOQTYRCDVARPCT | Var_ProdLabFoQtyRcdVarPct |
Currency | 10 | View | |
PRODLABVOQTYRCDVARPCT | Var_ProdLabVoQtyRcdVarPct |
Currency | 10 | View | |
PRODMACHQTYRCDVARPCT | Var_ProdMachQtyRcdVarPct |
Currency | 10 | View | |
PRODMACHFOQTYRCDVARPCT | Var_ProdMachFoQtyRcdVarPct |
Currency | 10 | View | |
PRODMACHVOQTYRCDVARPCT | Var_ProdMachVoQtyRcdVarPct |
Currency | 10 | View | |
PRODTOTALQTYRCDVARPCT | Var_ProdTotalQtyRcdVarPct |
Currency | 10 | View | |
PRODMATQTYENDVARPCT | Var_ProdMatQtyEndVarPct |
Currency | 10 | View | |
PRODMATFOQTYENDVARPCT | Var_ProdMatFoQtyEndVarPct |
Currency | 10 | View | |
PRODMATVOQTYENDVARPCT | Var_ProdMatVoQtyEndVarPct |
Currency | 10 | View | |
PRODLABQTYENDVARPCT | Var_ProdLabQtyEndVarPct |
Currency | 10 | View | |
PRODLABFOQTYENDVARPCT | Var_ProdLabFoQtyEndVarPct |
Currency | 10 | View | |
PRODLABVOQTYENDVARPCT | Var_ProdLabVoQtyEndVarPct |
Currency | 10 | View | |
PRODMACHQTYENDVARPCT | Var_ProdMachQtyEndVarPct |
Currency | 10 | View | |
PRODMACHFOQTYENDVARPCT | Var_ProdMachFoQtyEndVarPct |
Currency | 10 | View | |
PRODMACHVOQTYENDVARPCT | Var_ProdMachVoQtyEndVarPct |
Currency | 10 | View | |
PRODTOTALQTYENDVARPCT | Var_ProdTotalQtyEndVarPct |
Currency | 10 | View | |
PRODTOTALQTYENDVARPCT2 | Var_ProdTotalQtyEndVarPct2 |
Currency | 10 | View | |
MATVARPCT | Var_MatQtyVarPct |
Currency | 10 | View | |
MATFOVARPCT | Var_MatFoQtyVarPct |
Currency | 10 | View | |
MATVOVARPCT | Var_MatVoQtyVarPct |
Currency | 10 | View | |
LABVARPCT | Var_LabQtyVarPct |
Currency | 10 | View | |
LABFOVARPCT | Var_LabFoQtyVarPct |
Currency | 10 | View | |
LABVOVARPCT | Var_LabVoQtyVarPct |
Currency | 10 | View | |
MACHVARPCT | Var_MachQtyVarPct |
Currency | 10 | View | |
MACHFOVARPCT | Var_MachFoQtyVarPct |
Currency | 10 | View | |
MACHVOVARPCT | Var_MachVoQtyVarPct |
Currency | 10 | View | |
TOTALVARPCT | Var_TotalQtyVarPct |
Currency | 10 | View |