Requisition attributes

Attribute name Attribute Table name
Approved APPROVED_FL REQHEADER
Closed CLOSED_FL REQHEADER
Dropship DROPSHIP_FL REQHEADER
Req Company COMPANY REQHEADER
Req Header Status R_STATUS REQHEADER
Req Number REQ_NUMBER REQHEADER
Requester REQUESTER REQHEADER
Requester Name R_NAME REQUESTER
Requester Location REQ_LOCATION REQHEADER
Requisition Source RQ_SOURCE REQHEADER
Cost Code COST_CD REQLINE
Create PO CREATE_PO_FL REQLINE
Currency Code TRAN_CURR_CODE REQLINE
Manufacturer Code MANUF_CODE REQLINE
Manufacturer Division MANUF_DIVISION REQLINE
Pcard P_CARD_FLAG REQLINE
Req Company COMPANY REQLINE
Req Line Number LINE_NBR REQLINE
Req Line Status R_STATUS REQLINE
Req Number REQ_NUMBER REQLINE
Sourcing Event SS_EVENT_REQD REQLINE
Taxable PURCH_TAX_FL REQLINE
Diversity Code DIVERSE_CODE APDIVCODE
Vendor Class DESCRIPTION (or) VEN_CLASS APVENCLASS.DESCRIPTION, APVENMAST.VEN_CLASS
Vendor Group VENDOR_GROUP APVENMAST
Vendor Name VENDOR_VNAME APVENMAST
Vendor Number VENDOR APVENMAST
Vendor Status VENDOR_STATUS APVENMAST
Agreement Administrator AGRMT_ADMIN POVAGRMTHD
Agreement Type AGMT_TYPE POVAGRMTHD
Effective Date EFFECTIVE_DT POVAGRMTHD
Expire Date EXPIRE_DT POVAGRMTHD
Group Purchasing Org GRP_PURCH_ORG POVAGRMTHD
Is GPO Vendor GRP_PURCH_ORG POVAGRMTHD
Procurement Group PROCURE_GROUP POVAGRMTHD
Vendor Agreement Description DESCRIPTION POVAGRMTHD
Vendor Agreement Description2 DESCRIPTION2 POVAGRMTHD
Vendor Agreement Reference VEN_AGRMT_REF POVAGRMTHD
Vendor Agreement Type Long Name AGMT_TYPE POVAGRMTHD
Vendor Agreeme t Type Name AGMT_TYPE POVAGRMTHD
Vendor Location PURCH_FR_LOC POVAGRMTHD
Commodity Code COMMODITY_CODE ITEMMAST
Generic Name GENERIC ITEMMAST
Hazard Code HAZARD_CODE ITEMMAST
Hazardous HARMONIZE_CD ITEMMAST
Inventory Major Class DESCRIPTION MAJORCL
Inventory Minor Class DESCRIPTION MINORCL
Item Description DESCRIPTION ITEMMAST
Item Group ITEM_GROUP ITEMMAST
Item Number ITEM ITEMMAST
Manufacturer Code MANUF_CODE ITEMMAST
Manufacturer Division MANUF_DIVISION ITEMMAST
Manufacturer Number MANUF_NBR ITEMMAST
Purchasing Major Class DESCRIPTION MAJORCL
Purchasing Minor Class DESCRIPTION MINORCL
Sales Major Class DESCRIPTION MAJORCL
Sales Minor Class DESCRIPTION MINORCL
UNSPSC Class ICCODE_LDESC ICITEMCODE
UNSPSC Commodity ICCODE_LDESC ICITEMCODE
UNSPSC Family ICCODE_LDESC ICITEMCODE
UNSPSC Segment ICCODE_LDESC ICITEMCODE
Catalog Type On Catalog, Non Catalog REQLINE
Item Type ITEM_TYPE REQLINE
Spend Category AGREEMENT_REF REQLINE