Purchase History Flashcards
Purchase history
ID
A unique identifier given to every purchased item or line in the PO/ Database (a Check Request will not have an ID)
FacilityID
Unique numeric identifier for each facility
FacilityName
Name of SCA Facility
Group
An association of facilities based on SCA Operations structure (Examples: Acela, Pioneer, Keystone, TGS, TVH)
Region
An association of facilities based on a geographical region within SCA Operations structure
PO Date
The date the PO was created/ submitted (does not have to be approved to appear)
PO Number
Unique ID generated by SmartSystem given to supplier to request product or service
Invoice Number
Unique ID generated by Supplier to request payment for products or services
SUPPLIERDESC
The seller of the product or service
MANUFDESC
The producer of the product or service
ALPHASUPPARTNUM
The Supplier (seller) unique product identifier
ALPHAMANPARTNUM
The Manufacturer (producer) unique product identifier
PARTDESC
Description of product or service
PO_PackQTY
Quantity of items in one pack
PO_QTY
Quantity of packs being purchased
PO_Eaches
Total quantity of individual items being purchased
PO_UOM
Specifies the unit of measure in which the material is orderd (BX, CA, EA, PK)
PO_UnitPrice
The price for the unit of measure ordered
PO_EachPrice
The price of an individual item on the PO (the lowest unit of measure typically calculated by taking Po Total/ PO Eaches)
PO_Total
The total cost of an item on a PO. The price the facility expects to pay.
GLACCT
General ledger account number. GL- is the master set of accounts that summarize all transactions occuring within an entity.
GL_Description
The description of the GL Account
GL_Category
The categorization of account types in the GL (Examples:MedSurg, Implants, Pharma, Other)
DeptID
An identification number associated to individual departments within the organization (Example: 415= Operating Room)
Dept_Desc
The actual definition or descriptor of the individual department (Example: Operating Room)
OrderType
Identifies whether an order is done electronically via EDI or manually via PowerPo (Examples: Smart Order, PowerPO, Check Request)
NDC
National Drug Code (NCD) used to identiy pharmaceutical products
ITEMID
A unique SmartSystem identifier related to a product and a specific supplier
BUYRIGHTNAME
The national contract category name for certain national contracts. Buy Right- drives contract awareness to select national contracts typically in lower physician preference space
BUYRIGHTSTATUS
Identifies if an item is currently active in an SCA Buy Right initiative. (Examples: Yes, No , NULL)
RECEIVEDDATE
The date a product is received in the facility.
ContractType
Identifies how pricing is being accessed for an item. (Examples: GPO, GPOC, GPONC, SCA, NONE, NULL)
ContractNumber
Identifies the contract number that the item is currently referencing.
ContractPrice
The price negotiated for an item on an SCA national contract
INV_QTY
Quantity of items being invoiced by UOM
INV_UOM
Specifies the unit of measure in which the material is invoiced (BX, CA, EA, PK)
INV_Total
The total cost of an item on the invoice. The price the supplier expects us to pay (can be different from PO Total)
INV_UnitPrice
The price for the unit of measure ordered
INV_Tax
The tax incurred on the item
INV_Freight
The freight incurred on the item
INV_Misc
The misc incurred on the item
INV_Status
The current state of the invoice (Example: PD(paid), OK(ok to pay) This column is dynamic and changes as the invoice goes through the payment process.
UNSPSC
United Nations Standard Products and Services Codes- a national standard classification for goods and services.(Exameple: 42321506= Bone Screw) It’s a four level heirarchy coded as an 8 digit number which provides category specificity(segment, family, class, commodity).
UNSPSC_CommodityName
A specific group or products. The most specific code represented by the last two digits in the series. (Example: 42321506- the “06” represents the specificity of bone screw)
UNSPSC_ClassName
A group of commodities sharing a common use or function. (Example: 42321506- the “15” represents the Class of Orthopedic Trauma Implants)
UNSPSC_FamilyName
A commonly recognized group of inter-related commodity categories. (Example: 42321506- the “32” represents the family of Orthopedic Surgical Implants)
STAGE
The current state of the PO (Example: CL=closed, AC=accepted, BO=backordered) This column is dynamic and changes as the PO goes through the payment process.
