Back

Purchase Order (PO) - POORDEDA

Name Type Length Decimal Relation Description
ORDNUM String 8 PO ORD DETAIL HISTORY ORDNUM - The purchase order number
INVNUM String 20 PO ORD DETAIL HISTORY INVNUM - The invoice or receipt number
KEYID String 12 PO ORD DETAIL HISTORY KEYID - Unique identifier of line
LINETYPE String 1 PO ORD DETAIL HISTORY LINETYPE - Indicate the type of purchase order line (inventory,special,misc,comment)
WHCODE String 8 PO ORD DETAIL HISTORY WHCODE - The warehouse into which the inventory item will be received.
ITEMNUM String 25 PO ORDER HISTORY DETAIL ITEMNUM - The inventory item, special or miscellaneous number.
DESCRIPT String 40 PO ORD DETAIL HISTORY DESCRIPT - The description of the purchase order line.
ITEMVEND String 45 PO ORD DETAIL HISTORY ITEMVEND - The vendor's item number
PURACCT String 12 PO ORD DETAIL HISTORY PURACCT - The purchases general ledger account number
INVACCT String 12 PO ORD DETAIL HISTORY INVACCT - The inventory general ledger account number
VARACCT String 12 PO ORD DETAIL HISTORY VARACCT - The variance account number
SERLOTRCPT String 15 PO ORD DETAIL HISTORY SERLOTRCPT - *** not currently used ***
TAXABLE String 1 PO ORD DETAIL HISTORY TAXABLE - Indicates if the purchase order line is subject to tax.
BACKORDER String 1 PO ORD DETAIL HISTORY BACKORDER - Indicates if the purchase order line can be backordered.
DISCOUNT String 1 PO ORD DETAIL HISTORY DISCOUNT - Indicates if the purchase order line can be discounted.
UM String 4 PO ORD DETAIL HISTORY UM - The purchasing unit of measure
QTYORD Decimal 12 4 PO ORD DETAIL HISTORY QTYORD - The quantity on the original purchase order
QTYRCVD Decimal 12 4 PO ORD DETAIL HISTORY QTYRCVD - The quantity received for the purchase order line.
QTYBACK Decimal 12 4 PO ORD DETAIL HISTORY QTYBACK - The quantity backordered for the purchase order line.
QTYINVD Decimal 12 4 PO ORD DETAIL HISTORY QTYINVD - The quanity invoiced for the purchase order line
ORIGORD Decimal 12 4 PO ORD DETAIL HISTORY ORIGORD - The original order quantity of the purchase order line
TOTALRCVD Decimal 12 4 PO ORD DETAIL HISTORY TOTALRCVD - The total quantity received for the purchase order line.
TOTALINVD Decimal 12 4 PO ORD DETAIL HISTORY TOTALINVD - The total quantity invoiced for the purchase order line.
PERCOST Decimal 12 4 PO ORD DETAIL HISTORY PERCOST - Our cost (vendor's price) of the item.
FPERCOST Decimal 12 4 PO ORD DETAIL HISTORY FPERCOST - Foreign currency equivalent of percost
INVCOST Decimal 12 4 PO ORD DETAIL HISTORY INVCOST - The actual cost of the purchase order line as it appears on the invoice.
FINVCOST Decimal 12 4 PO ORD DETAIL HISTORY FINVCOST - Foreign currency equivalent of invcost
EXTENSION Decimal 11 2 PO ORD DETAIL HISTORY EXTENSION - The extended cost of the purchase order line at invoice time.
FEXTENSION Decimal 11 2 PO ORD DETAIL HISTORY FEXTENSION - Foreign currency equivalent of extension
FACTOR Decimal 8 3 PO ORD DETAIL HISTORY FACTOR - The unit of measure conversion factor expressed in terms of the standard unit of measure as defined in the inventory item master.
MESSLINE String 4 PO ORD DETAIL HISTORY MESSLINE - Memo field for extended line comments
DROPSHIP String 1 PO ORD DETAIL HISTORY DROPSHIP - Y=Item to be dropped shipped directly to the customer. Inventory will not be impacted.
SALESORDER String 8 PO ORD DETAIL HISTORY SALESORDER - The sales order number that the item was ordered for.
FREIGHT Decimal 8 2 PO FREIGHT
REQDATE DateTime 8 PO REQDATE
CANCELDATE DateTime 8 PO CANCELDATE
PACKDATE DateTime 8 PO PACKDATE
SHIPDATE DateTime 8 PO SHIPDATE
ETADATE DateTime 8 PO ETADATE
STDCOST Decimal 12 4 POORDEDA STDCOST - Stdcost
QTYONWATER Decimal 12 4 PO QTYONWATER
FILENUM String 12 PO FILENUM
INCLUDE Boolean 1 PO INCLUDE
SPLITQTY Decimal 12 4 PO SPLITQTY
ONWATER Decimal 12 4 PO ONWATER
BROKER Decimal 8 2 PO BROKER
MISC Decimal 8 2 PO MISC
QTYTRAN Decimal 12 4 PO QTYTRAN
TRANWHCODE String 8 PO TRANWHCODE
FREIGHTCST Decimal 10 2 PO FREIGHTCST
FIRSTCOST Decimal 12 2 PO FIRSTCOST
CUSTSKU String 25 PO CUSTSKU
WEIGHT Decimal 8 3 PO WEIGHT
VOLSIZE Decimal 8 4 PO VOLSIZE
DISCPERC Decimal 6 3 PO DISCPERC
DISCAMT Decimal 11 2 PO DISCAMT
FDISCAMT Decimal 11 2 PO FDISCAMT
CASEPACK Decimal 10 2 PO CASEPACK
CASEPRICE Decimal 10 2 PO CASEPRICE
SOKEYID String 12 PO SOKEYID
STATUS Boolean 1 PO STATUS