Purchasing attributes

Attribute name Attribute Table name
Vendor Returns
Agreement Administrator AGRMT_ADMIN POVAGRMTHD
Agreement Type AGMT_TYPE POVAGRMTHD
Buyer RET_PO_BUYER PORETURNHD
Buyer RET_PO_BUYER PORETURNHD
Buyer BUYER_CODE PURCHORDER
Buyer Name R_NAME BUYER
Catalog Type On Catalog, Non Catalog
Closed CLOSED_FL PURCHORDER
Commodity Code COMMODITY_CODE ITEMMAST
Cost Code COST_CD POLINE
Currency CURRENCY_CODE PURCHORDER
Diversity Code DIVERSE_CODE APDIVCODE
Dropship CURRENCY_CODE PURCHORDER
Effective Date EFFECTIVE_DT POVAGRMTHD
Expire Date EXPIRE_DT POVAGRMTHD
Generic Name GENERIC ITEMMAST
Group Purchasing Org GRP_PURCH_ORG POVAGRMTHD
GTIN GTIN ICITEMGTIN
GTIN Description FULL_DESC ICITEMGTIN
GTIN UOM UOM ICITEMGTIN
Hazard Code HAZARD_CODE ITEMMAST
Hazardous HARMONIZE_CD ITEMMAST
Inventory Major Class DESCRIPTION MAJORCL
Inventory Minor Class DESCRIPTION MINORCL
Is GPO Vendor GRP_PURCH_ORG POVAGRMTHD
Issue Method ISSUE_METH POREVISION
Issued ISSUED_FLAG PURCHORDER
Item Description DESCRIPTION ITEMMAST
Item Group ITEM_GROUP ITEMMAST
Item Number ITEM ITEMMAST
Item Type ITEM_TYPE POLINE
Manufacturer Code MANUF_CODE ITEMMAST
Manufacturer Code MANUF_CODE POLINE
Manufacturer Division MANUF_DIVISION ITEMMAST
Manufacturer Division MANUF_DIVISION POLINE
Manufacturer Number MANUF_NBR ITEMMAST
PCard P_CARD_FLAG POLINE
PO Company COMPANY PORETURNLN
PO Company COMPANY PORETURNHD
PO Company COMPANY PURCHORDER
PO Company COMPANY PURCHORDER
PO Line Number LINE_NBR POLINE
PO Line Status RELEASED_FL POLINE
PO Number PO_NUMBER PURCHORDER
PO Number PO_NUMBER PURCHORDER
PO Status RELEASED_FL PURCHORDER
Process Level PROCESS_LEVEL PURCHORDER
Procurement Group PROCURE_GROUP POVAGRMTHD
Purchasing Major Class DESCRIPTION MAJORCL
Purchasing Minor Class DESCRIPTION MINORCL
Reason Code REASON_CODE PORETURNHD
Reason Code REASON_CODE PORETURNHD
Released RELEASED_FL PURCHORDER
Return Line Number RET_LINE_NBR PORETURNLN
Return Number RETURN_NUMBER PORETURNLN
Return Number RETURN_NUMBER PORETURNHD
Return Status R_STATUS PORETURNHD
Return Status R_STATUS PORETURNHD
Return Status Code R_STATUS PORETURNHD
Return Status Code R_STATUS PORETURNHD
Revised REVISED_FL PURCHORDER
Sales Major Class DESCRIPTION MAJORCL
Sales Minor Class DESCRIPTION MINORCL
Ship To Location LOCATION PURCHORDER
Sourcing Event SS_EVENT_NBR POLINE
Spend Category On Agreement, Off Agreement, None
Tax Code TAX_CODE PURCHORDER
UNSPSC Class ICCODE_LDESC ICITEMCODE
UNSPSC Commodity ICCODE_LDESC ICITEMCODE
UNSPSC Family ICCODE_LDESC ICITEMCODE
UNSPSC Segment ICCODE_LDESC ICITEMCODE
Vendor Agreement Description DESCRIPTION POVAGRMTHD
Vendor Agreement Description2 DESCRIPTION2 POVAGRMTHD
Vendor Agreement Reference VEN_AGRMT_REF POVAGRMTHD
Vendor Agreement Type LongName AGMT_TYPE POVAGRMTHD
Vendor Agreement Type Name AGMT_TYPE POVAGRMTHD
Vendor Class DESCRIPTION (or)VEN_CLASS APVENCLASS.DESCRIPTION,APVENMAST.VEN_CLASS
Vendor Group VENDOR_GROUP APVENMAST
Vendor Location PURCH_FR_LOC POVAGRMTHD
Vendor Name VENDOR_VNAME APVENMAST
Vendor Number VENDOR APVENMAST
Vendor Status VENDOR_STATUS APVENMAST
Spend
Account Category ACCT_CATEGORY
Accounting Unit DIS_ACCT_UNIT APDISTRIB
Agreement Administrator AGRMT_ADMIN POVAGRMTHD
Agreement Type AGMT_TYPE POVAGRMTHD
AP Company COMPANY APDISTRIB
AP Distribution Type DIST_TYPE APDISTRIB
AP Invoice INVOICE APDISTRIB
AP Invoice Date INVOICE_DTE APDISTRIB
AP Invoice Type INVOICE_TYPE APDISTRIB
AP Process Level PROC_LEVEL APDISTRIB
Buyer BUYER_CODE PURCHORDER
Buyer Name R_NAME BUYER
Catalog Type On Catalog, Non Catalog
Closed CLOSED_FL PURCHORDER
Commodity Code COMMODITY_CODE ITEMMAST
Cost Code COST_CD POLINE
Currency CURRENCY_CODE PURCHORDER
Currency INV_CURRENCY APDISTRIB
Diversity Code DIVERSE_CODE APDIVCODE
Dropship CURRENCY_CODE PURCHORDER
Effective Date EFFECTIVE_DT POVAGRMTHD
Expire Date EXPIRE_DT POVAGRMTHD
Generic Name GENERIC ITEMMAST
GL Account DIS_ACCOUNT,DIS_SUB_ACCT APDISTRIB
GL Chart CHART_NAME GLSYSTEM
Group Purchasing Org GRP_PURCH_ORG POVAGRMTHD
Hazard Code HAZARD_CODE ITEMMAST
Hazardous HARMONIZE_CD ITEMMAST
Inventory Major Class DESCRIPTION MAJORCL
Inventory Minor Class DESCRIPTION MINORCL
Is GPO Vendor GRP_PURCH_ORG POVAGRMTHD
Issue Method ISSUE_METH POREVISION
Issued ISSUED_FLAG PURCHORDER
Item Description DESCRIPTION ITEMMAST
Item Group ITEM_GROUP ITEMMAST
Item Number ITEM ITEMMAST
Item Type ITEM_TYPE POLINE
Manufacturer Code MANUF_CODE ITEMMAST
Manufacturer Code MANUF_CODE POLINE
Manufacturer Division MANUF_DIVISION ITEMMAST
Manufacturer Division MANUF_DIVISION POLINE
Manufacturer Number MANUF_NBR ITEMMAST
PCard P_CARD_FLAG POLINE
PO Company COMPANY PURCHORDER
PO Company COMPANY PURCHORDER
PO Line Number LINE_NBR POLINE
PO Line Status RELEASED_FL POLINE
PO Number PO_NUMBER PURCHORDER
PO Number PO_NUMBER PURCHORDER
PO Status RELEASED_FL PURCHORDER
Process Level PROCESS_LEVEL PURCHORDER
Procurement Group PROCURE_GROUP POVAGRMTHD
Purchasing Major Class DESCRIPTION MAJORCL
Purchasing Minor Class DESCRIPTION MINORCL
Released RELEASED_FL PURCHORDER
Revised REVISED_FL PURCHORDER
Sales Major Class DESCRIPTION MAJORCL
Sales Minor Class DESCRIPTION MINORCL
Ship To Location LOCATION PURCHORDER
Sourcing Event SS_EVENT_NBR POLINE
Spend Category Off Contract, No Contract, Expense, None
Tax Code TAX_CODE PURCHORDER
UNSPSC Class ICCODE_LDESC ICITEMCODE
UNSPSC Commodity ICCODE_LDESC ICITEMCODE
UNSPSC Family ICCODE_LDESC ICITEMCODE
UNSPSC Segment ICCODE_LDESC ICITEMCODE
Vendor Agreement Description DESCRIPTION POVAGRMTHD
Vendor Agreement Description2 DESCRIPTION2 POVAGRMTHD
Vendor Agreement Reference VEN_AGRMT_REF POVAGRMTHD
Vendor Agreement Type LongName AGMT_TYPE POVAGRMTHD
Vendor Agreement Type Name AGMT_TYPE POVAGRMTHD
Vendor Class DESCRIPTION (or)VEN_CLASS APVENCLASS.DESCRIPTION,APVENMAST.VEN_CLASS
Vendor Group VENDOR_GROUP APVENMAST
Vendor Location PURCH_FR_LOC POVAGRMTHD
Vendor Name VENDOR_VNAME APVENMAST
Vendor Number VENDOR APVENMAST
Vendor Status VENDOR_STATUS APVENMAST
Vendor Agreement
Agreement Administrator AGRMT_ADMIN POVAGRMTHD
Agreement Type AGMT_TYPE POVAGRMTHD
Diversity Code DIVERSE_CODE APDIVCODE
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 LongName AGMT_TYPE POVAGRMTHD
Vendor Agreement Type Name AGMT_TYPE POVAGRMTHD
Vendor Class DESCRIPTION (or)VEN_CLASS APVENCLASS.DESCRIPTION,APVENMAST.VEN_CLASS
Vendor Group VENDOR_GROUP APVENMAST
Vendor Location PURCH_FR_LOC POVAGRMTHD
Vendor Name VENDOR_VNAME APVENMAST
Vendor Number VENDOR APVENMAST
Vendor Status VENDOR_STATUS APVENMAST
Purchase Order
Agreement Administrator AGRMT_ADMIN POVAGRMTHD
Agreement Type AGMT_TYPE POVAGRMTHD
Buyer BUYER_CODE PURCHORDER
Buyer Name R_NAME BUYER
Catalog Type On Catalog, Non Catalog
Catalog Type On Catalog, Non Catalog
Closed CLOSED_FL PURCHORDER
Commodity Code COMMODITY_CODE ITEMMAST
Cost Code COST_CD POLINE
Currency CURRENCY_CODE PURCHORDER
Diversity Code DIVERSE_CODE APDIVCODE
Dropship CURRENCY_CODE PURCHORDER
Effective Date EFFECTIVE_DT POVAGRMTHD
Expire Date EXPIRE_DT POVAGRMTHD
Generic Name GENERIC ITEMMAST
Group Purchasing Org GRP_PURCH_ORG POVAGRMTHD
Hazard Code HAZARD_CODE ITEMMAST
Hazardous HARMONIZE_CD ITEMMAST
Inventory Major Class DESCRIPTION MAJORCL
Inventory Minor Class DESCRIPTION MINORCL
Is GPO Vendor GRP_PURCH_ORG POVAGRMTHD
Issue Method ISSUE_METH PURCHORDER
Issued ISSUED_FLAG PURCHORDER
Item Description DESCRIPTION ITEMMAST
Item Group ITEM_GROUP ITEMMAST
Item Number ITEM ITEMMAST
Item Type ITEM_TYPE POLINE
Item Type ITEM_TYPE POLINE
Manufacturer Code MANUF_CODE ITEMMAST
Manufacturer Code MANUF_CODE POLINE
Manufacturer Division MANUF_DIVISION ITEMMAST
Manufacturer Division MANUF_DIVISION POLINE
Manufacturer Number MANUF_NBR ITEMMAST
PCard P_CARD_FLAG POLINE
PO Company COMPANY PURCHORDER
PO Company COMPANY PURCHORDER
PO Line Number LINE_NBR POLINE
PO Line Status RELEASED_FL POLINE
PO Number PO_NUMBER PURCHORDER
PO Number PO_NUMBER PURCHORDER
PO Status RELEASED_FL PURCHORDER
Process Level PROCESS_LEVEL PURCHORDER
Procurement Group PROCURE_GROUP POVAGRMTHD
Purchasing Major Class DESCRIPTION MAJORCL
Purchasing Minor Class DESCRIPTION MINORCL
Released RELEASED_FL PURCHORDER
Revised REVISED_FL PURCHORDER
Sales Major Class DESCRIPTION MAJORCL
Sales Minor Class DESCRIPTION MINORCL
Ship To Location LOCATION PURCHORDER
Sourcing Event SS_EVENT_NBR POLINE
Spend Category Off Contract, No Contract, Expense, None
Tax Code TAX_CODE PURCHORDER
UNSPSC Class ICCODE_LDESC ICITEMCODE
UNSPSC Commodity ICCODE_LDESC ICITEMCODE
UNSPSC Family ICCODE_LDESC ICITEMCODE
UNSPSC Segment ICCODE_LDESC ICITEMCODE
Vendor Agreement Description DESCRIPTION POVAGRMTHD
Vendor Agreement Description2 DESCRIPTION2 POVAGRMTHD
Vendor Agreement Reference VEN_AGRMT_REF POVAGRMTHD
Vendor Agreement Type LongName AGMT_TYPE POVAGRMTHD
Vendor Agreement Type Name AGMT_TYPE POVAGRMTHD
Vendor Class DESCRIPTION (or)VEN_CLASS APVENCLASS.DESCRIPTION,APVENMAST.VEN_CLASS
Vendor Group VENDOR_GROUP APVENMAST
Vendor Location PURCH_FR_LOC POVAGRMTHD
Vendor Name VENDOR_VNAME APVENMAST
Vendor Number VENDOR APVENMAST
Vendor Status VENDOR_STATUS APVENMAST