PO Form Fields

Fields available for the PO form.

NOTE: In most cases just the field name is used. In some cases an alias is used and both the actual field name and the alias will be presented - in this case use the alias name on the form.

Main Query Fields:

PO_DET.SESSION_NO CTL_SESSION_NO
PO_DET.TRANS_NO CTL_TRANS_NO[[
PO_HD.SESSION_NO
PO_HD.TRANS_NO
PO_HD.VENDND_ID
PO_HD.PO_NUMBER
PO_HD.DESCRIPMT_TRMION PO_DESCRIPMT_TRMION
PO_HD.PO_LIMIT
PO_HD.STATUS
PO_HD.PAYMENT_TERMS
PO_HD.ORDER_DATE
PO_HD.EXPECTED_DATE
PO_HD.EXPIRATION_DATE
PO_HD.BUDGET_DATE
PO_HD.TAX_AUTHORITY
PO_HD.ORDERED_BY
PO_HD.AUTHORIZED_BY
PO_HD.SHIP_FOB
PO_HD.SHIP_VIA
PO_HD.SHIP_TO_1
PO_HD.SHIP_TO_2
PO_HD.SHIP_TO_3
PO_HD.SHIP_TO_4
PO_HD.CONDITIONS
PO_HD.INSTRUCTIONS
PO_DET.LINE_NO
PO_DET.PRODODUCT_CODE
PO_DET.DESCRIPMT_TRMION
PO_DET.ORDER_UMS
PO_DET.STOCK_UMS
PO_DET.QTY_ORDERED
PO_DET.QTY_RECEIVENDD
PO_DET.UNIT_COST
PO_DET.UNIT_PCT_DISC
PO_DET.TAX_CODE
PO_DET.QUOTE_NO
PO_DET.PLUS_FLAG
VEND.NAME
VEND.ADDRESS_1
VEND.ADDRESS_2
VEND.CITY
VEND.STATE
VEND.ZIP
PMT_TRM.DESCRIPMT_TRMION TERMS_DESC
PROD.VENDND_PRODOD_ID

Calculated Fields

CALC_VENDADDR1
CALC_VENDADDR2
CALC_VENDADDR3
CALC_VENDADDR4
CALC_ORDSUBTOTAL
CALC_ORDTAXTOTAL
CALC_ORDTOTAL
CALC_DISCOUNT
CALC_STATUS
CALC_QTYBACKORDERED
COND_PLUS
CALC_EXTAMOUNT