Back

Purchase Order (PO) - POORDEHA

Name Type Length Decimal Relation Description
ORDNUM String 8 PO ORDER HISTORY HEADER ORDNUM - The purchase order number
VENDNUM String 10 PO VENDNUM
TIME String 7 PO ORD R HISTORY HEADER TIME - The time the purchase order was entered.
ORDTYPE String 1 PO ORD R HISTORY HEADER ORDTYPE - The order type (S=standard,C=Return/Credit,R=Receipt of goods,I=Invoice,b=Backorder)
ORIGIN String 1 PO ORD R HISTORY HEADER ORIGIN - ** not in use **
REPORDNUM String 8 PO ORD R HISTORY HEADER REPORDNUM - ** not currently in use ***
ORIGORDNUM String 8 PO ORD R HISTORY HEADER ORIGORDNUM - The original parent order.
INVNUM String 20 PO INVNUM
INBATCH String 6 PO ORD R HISTORY HEADER INBATCH - Populated during update
NAME String 30 PO ORD R HISTORY HEADER NAME - The vendor's name
ADDRESS1 String 30 PO ORD R HISTORY HEADER ADDRESS1 - The vendor's address
ADDRESS2 String 30 PO ORD R HISTORY HEADER ADDRESS2 - The vendor's address
CITY String 20 PO ORD R HISTORY HEADER CITY - The vendor's city
STATE String 10 PO ORD R HISTORY HEADER STATE - The vendor's state
ZIP String 10 PO ORD R HISTORY HEADER ZIP - The vendor's zip code.
CONTACT String 30 PO ORD R HISTORY HEADER CONTACT - A contact at the vendor
COUNTRY String 20 PO ORD R HISTORY HEADER COUNTRY - The vendor's country
SHIPCODE String 5 PO ORD R HISTORY HEADER SHIPCODE - The shipping code number of the address to ship the goods or blank for default.
SHIPNAME String 30 PO ORD R HISTORY HEADER SHIPNAME - The company name to ship purchased goods.
SHIPADD1 String 30 PO ORD R HISTORY HEADER SHIPADD1 - The company address to ship purchased goods.
SHIPADD2 String 30 PO ORD R HISTORY HEADER SHIPADD2 - The address to ship purchased goods.
SHIPCITY String 20 PO ORD R HISTORY HEADER SHIPCITY - The company city to ship purchased goods.
SHIPST String 10 PO ORD R HISTORY HEADER SHIPST - The company state to ship purchased goods.
SHIPZIP String 10 PO ORD R HISTORY HEADER SHIPZIP - The company zip to ship purchased goods.
SHIPCTRY String 20 PO ORD R HISTORY HEADER SHIPCTRY - The company country to ship purchased goods.
SHIPPHONE String 20 PO ORD R HISTORY HEADER SHIPPHONE - The company phone at site were purchased goods are shipped.
STATUS String 1 PO ORD R HISTORY HEADER STATUS - ** not currently used **
WHNUM String 8 PO ORD R HISTORY HEADER WHNUM - The default warehouse where the goods are to be received.
SHIPVIA String 15 PO ORD R HISTORY HEADER SHIPVIA - The method of shipping to use.
FOB String 15 PO ORD R HISTORY HEADER FOB - FOB
TERMCODE String 2 PO ORD R HISTORY HEADER TERMCODE - The vendors invoice terms.
INVTYPE String 2 PO ORD R HISTORY HEADER INVTYPE - ** not currently used **
USERID String 4 PO ORD R HISTORY HEADER USERID - The user code of the operator that entered the order.
DEFFREIGHT String 12 PO ORD R HISTORY HEADER DEFFREIGHT - The freight general ledger account.
DEFMISC String 12 PO ORD R HISTORY HEADER DEFMISC - The miscellaneous general ledger account.
DEFSALETAX String 12 PO ORD R HISTORY HEADER DEFSALETAX - The sales tax expense account.
DEFAP String 12 PO ORD R HISTORY HEADER DEFAP - The accounts payable general ledger account.
FORM1099 String 1 PO ORD R HISTORY HEADER FORM1099 - The 1099 form type if any
BOX1099 String 2 PO ORD R HISTORY HEADER BOX1099 - The 1099 box if any
ORDDATE DateTime 8 PO ORD R HISTORY HEADER ORDDATE - The date the purchase order was created
INVDATE DateTime 8 PO ORD R HISTORY HEADER INVDATE - The date the invoice or receipt was entered.
DUEDATE DateTime 8 PO ORD R HISTORY HEADER DUEDATE - The date the invoice is due based on the terms for the vendor.
REQDATE DateTime 8 PO ORD R HISTORY HEADER REQDATE - The date the goods are required.
POSTDATE DateTime 8 PO ORD R HISTORY HEADER POSTDATE - The date the transaction should hit the general ledger
DISCDATE DateTime 8 PO ORD R HISTORY HEADER DISCDATE - Date discount is due
COMMENT String 4 PO ORD R HISTORY HEADER COMMENT - Additional comments
DISCPERC Decimal 6 3 PO ORD R HISTORY HEADER DISCPERC - A disount percent off of the purchase order if any
TAX_RATE Decimal 6 3 PO ORD R HISTORY HEADER TAX_RATE - The tax rate if any
FTAX_RATE Decimal 6 3 PO ORD R HISTORY HEADER FTAX_RATE - ** not currently used **
TAX Decimal 8 2 PO ORD R HISTORY HEADER TAX - The tax amount
FTAX Decimal 8 2 PO ORD R HISTORY HEADER FTAX - The foreign equivalent of the tax amount.
NTAXTOT Decimal 11 2 PO ORD R HISTORY HEADER NTAXTOT - The non-taxable subtotal of the invoice
FNTAXTOT Decimal 11 2 PO ORD R HISTORY HEADER FNTAXTOT - The foreign equivalent of ntaxtot
TAXTOT Decimal 11 2 PO ORD R HISTORY HEADER TAXTOT - The total subject to tax
FTAXTOT Decimal 11 2 PO ORD R HISTORY HEADER FTAXTOT - The foreign equivalent of taxtot
INVTOT Decimal 12 2 PO ORD R HISTORY HEADER INVTOT - The total invoice amount
FINVTOT Decimal 12 2 PO ORD R HISTORY HEADER FINVTOT - The foreign equivalent of invtot
ORDTOT Decimal 12 2 PO ORD R HISTORY HEADER ORDTOT - The purchase order total amount
FORDTOT Decimal 12 2 PO ORD R HISTORY HEADER FORDTOT - The foreign equivalent of ordtot
FREIGHT Decimal 8 2 PO ORD R HISTORY HEADER FREIGHT - The freight amount
FFREIGHT Decimal 8 2 PO ORD R HISTORY HEADER FFREIGHT - The foreign equivalent of freight
MISC Decimal 8 2 PO ORD R HISTORY HEADER MISC - The miscellaneous amount for the invoice
FMISC Decimal 8 2 PO ORD R HISTORY HEADER FMISC - The foreign equivalent of misc
FDISCAMT Decimal 8 2 PO ORD R HISTORY HEADER FDISCAMT - The foreign equivalent of discamt
DISCAMT Decimal 8 2 PO ORD R HISTORY HEADER DISCAMT - The total discount amount for the order
FSUBTODISC Decimal 8 2 PO ORD R HISTORY HEADER FSUBTODISC - The foreign equivalent of fsubtodisc
SUBTODISC Decimal 8 2 PO ORD R HISTORY HEADER SUBTODISC - The total amount subject to discount
SHPCONTACT String 20 PO ORD R HISTORY HEADER SHPCONTACT - The contact at the ship-to location
ARTWORK Boolean 1 POORDEHA ARTWORK - Artwork
ARTDATE DateTime 8 POORDEHA ARTDATE - Artdate
DEPT String 20 POORDEHA DEPT - Dept
EMAIL String 40 PO EMAIL
FAX String 15 PO FAX
AREAFAX String 10 PO AREAFAX
NOTES String 4 PO NOTES
PACKDATE DateTime 8 PO PACKDATE
CANCELDATE DateTime 8 PO CANCELDATE
ETADATE DateTime 8 PO ETADATE
SHIPDATE DateTime 8 PO SHIPDATE
TOTVOLORD Decimal 9 4 POORDEHA TOTVOLORD - Totvolord
TOTPIECES Decimal 12 4 POORDEHA TOTPIECES - Totpieces
BROKER Decimal 8 2 PO BROKER
FBROKER Decimal 8 2 PO FBROKER
DEFBROKER String 12 POORDEHA DEFBROKER - Defbroker
XCHGRATE Decimal 12 6 PO XCHGRATE
CURCODE String 3 PO CURCODE
TAXABLE Int32 4 PO TAXABLE
TAXAMT Decimal 10 2 PO TAXAMT
NETID String 25 POORDEHA NETID - Netid
PONUM String 35 POORDEHA PONUM - Ponum
SOURCE String 5 POORDEHA SOURCE - Source
NUMBER String 10 PO NUMBER
DEPOSIT Decimal 10 2 PO DEPOSIT
FDEPOSIT Decimal 10 2 PO FDEPOSIT
BILLTOVEND String 10 PO BILLTOVEND
RECEIPTBIN String 10 PO RECEIPTBIN
BALANCE Decimal 10 2 PO BALANCE
CUSTOMAMT Decimal 8 2 PO CUSTOMAMT
FCUSTOMAMT Decimal 8 2 PO FCUSTOMAMT