PCFILE: PC FILE

ElementElement NameTable or FileSQL or Focus
PC002PC VENDOR NUMBERPCFILEVENDOR_NUM
PC004PC COMMODITY NUMBERPCFILECOMMODITY_CODE
PC006PC CAMPUS CODEPCFILECAMPUS_CODE
PC008PC COMMODITY NUMBERPCFILECOMMODITY_CODE
PC010PC VENDOR NUMBERPCFILEVENDOR_NUM
PC012PC CAMPUS CODEPCFILECAMPUS_CODE
PC018PC DROP FLAGPCFILEDROP_FLAG
PC019PC DELETE FLAGPCFILEDELETE_FLAG
PC020PC FREEZE FLAGPCFILEFREEZE_FLAG
PC030PC DATE CREATEDPCFILECREATE_DT
PC031PC DATE CREATED-6PCFILECREATE_DT_6
PC032PC DATE EXPIREPCFILEEXPIRATION_DT
PC033PC DATE EXPIRE-6PCFILEEXPIRATION_DT_6
PC034PC DATE OF LAST ACTPCFILEDT_LAST_ACTV
PC035PC DATE OF LAST AC-6PCFILEDT_LAST_ACTV_6
PC036PC UNIT PRICEPCFILEUNIT_PRICE
PC038PC TRADE DISCOUNTPCFILETRADE_DISC
PC040PC UOMPCFILEUNIT_OF_MEASURE
PC042PC DESC LINE 1PCFILEDESC_1
PC044PC DESC LINE 2PCFILEDESC_2
PC046PC VEND INVENTORY NOPCFILEINVEN_NUM
PC048PC SUPPLY INVRY NOPCFILESUPPLIES_INVEN
PC054PC BUYER CODEPCFILEBUYER_CODE
PC056PC PHONE CODEPCFILEBUYER_PHONE
PC060PC SAFETY CODEPCFILESAFETY_CODE
PC063PC FEDERAL/STATE CONPCFILEFED_STATE_CONTRACT
PC064PC CONTRACT NUMBERPCFILECNTRCT_NUM
PC066PC APPROVAL CODEPCFILEAPRVL_CODE
PC068PC APPROVAL TEXTPCFILEAPRVL_TEXT
PC070PC NUMBER OF BIDSPCFILENUM_BIDS
PC072PC NUMBER OF RESPPCFILENUM_RESPONSES
PC100PC CM ORDERED NUMBERPCFILENUM_ORDERS_CM
PC102PC CM ORDERED QTYPCFILEQTY_ORDERED_CM
PC104PC CM ORDERED AMOUNTPCFILEAMT_ORDERED_CM
PC106PC CM REC QTY ACCPTPCFILERECV_QTY_ACCPTD_CM
PC108PC CM REC QTY REJECPCFILERECV_QTY_REJCTD_CM
PC110PC CM REC QTY BK-ORDPCFILERECV_QTY_BK_ORD_CM
PC112PC CM REC QTY LATEPCFILERECV_QTY_LATE_CM
PC114PC CM SHIPMENT TOTALPCFILENUM_SHIPMENTS_CM
PC116PC CM SHIPMENT REJECPCFILESHIP_REJECTED_CM
PC118PC CM SHIPMENT BCK-OPCFILESHIP_BACK_ORD_CM
PC120PC CM SHIPMENT LATEPCFILESHIP_LATE_CM
PC122PC CM INVOICES (NUM)PCFILENUM_INVOICES_CM
PC124PC CM INVOICES QTYPCFILEINVOICED_QTY_CM
PC126PC CM INVOICES AMTPCFILEINVOICED_AMT_CM
PC130PC YTD ORDERED NUMPCFILENUM_ORDERS_YTD
PC132PC YTD ORDERED QTYPCFILEQTY_ORDERED_YTD
PC134PC YTD ORDERED AMTPCFILEAMT_ORDERED_YTD
PC136PC YTD REC QTY ACCPTPCFILERECV_QTY_ACCPTD_YT
PC138PC YTD REC QTY REJECPCFILERECV_QTY_REJCTD_YT
PC140PC YTD REC QTY BK-ORPCFILERECV_QTY_BK_ORD_YT
PC142PC YTD REC QTY LATEPCFILERECV_QTY_LATE_YTD
PC144PC YTD SHIPMENT TOTLPCFILENUM_SHIPMENTS_YTD
PC146PC YTD SHIPMENT REJEPCFILESHIP_REJECTED_YTD
PC148PC YTD SHIPMENT BCKOPCFILESHIP_BACK_ORD_YTD
PC150PC YTD SHIPMENT LATEPCFILESHIP_LATE_YTD
PC152PC YTD INVOICES (NO)PCFILENUM_INVOICES_YTD
PC154PC YTD INVOICES QTYPCFILEINVOICED_QTY_YTD
PC156PC YTD INVOICES AMTPCFILEINVOICED_AMT_YTD
PC160PC PY ORDERED NUMBERPCFILENUM_ORDERS_PY
PC162PC PY ORDERED QTYPCFILEQTY_ORDERED_PY
PC164PC PY ORDERED AMOUNTPCFILEAMT_ORDERED_PY
PC166PC PY REC QTY ACCPTPCFILERECV_QTY_ACCPTD_PY
PC168PC PY REC QTY REJECPCFILERECV_QTY_REJCTD_PY
PC170PC PY REC QTY BK-ORDPCFILERECV_QTY_BK_ORD_PY
PC172PC PY REC QTY LATEPCFILERECV_QTY_LATE_PY
PC174PC PY SHIPMENT TOTALPCFILENUM_SHIPMENTS_PY
PC176PC PY SHIPMENT REJECPCFILESHIP_REJECTED_PY
PC178PC PY SHIPMENT BCK-OPCFILESHIP_BACK_ORD_PY
PC180PC PY SHIPMENT LATEPCFILESHIP_LATE_PY
PC182PC PY INVOICES (NUM)PCFILENUM_INVOICES_PY
PC184PC PY INVOICES QTYPCFILEINVOICED_QTY_PY
PC186PC PY INVOICES AMTPCFILEINVOICED_AMT_PY
PC192PC PO NUMBERPCFILEDOC_NUM
PC194PC LINE NUMBERPCFILELINE_NUM

©2000 All Rights Reserved