FILENAME: D9530R61 MASTER
DESCRIPTION: FRS COMMODITIES FOCUS
FIELDNAME ALIAS FORMAT DESCRIPTION FIELDTYPE
PM002_PMRT COMMODITY_CODE A11 COMMODITY CODE
PM019 DELETE_FLAG A1 DELETE FLAG
PM020 FREEZE_FLAG A1 FREEZE FLAG
PM024 CREATE_DT YYMD DATE CREATE DATE
PM026 DT_OF_LAST_ACTV YYMD DATE DATE OF LAST ACTV
PM030 COMMODIDTY_NAME A30 COMMODITY NAME
PM036 CATEGORY_CODE A5 CATEGORY CODE
PM038 BUYER_CODE A3 BUYER CODE
PM040 BUYER_PHONE A3 BUYER PHONE
PM042 SAFETY_CODE A1 SAFETY CODE
PM044 FED_STATE_CNTRCT A1 FED STATE CNTRCT
PM046 CNTRCT_NUM A10 CNTRCT NUMBER
PM048 APRVL_CODE A2 APRVL CODE
PM050 APRVL_TEXT A40 APRVL TEXT
PM052 DESC_1 A40 DESC 1
PM054 DESC_2 A40 DESC 2
PM056 TAX_CODE A2 TAX CODE
PC002_PCRT VENDOR_NUM A11 VENDOR NUMBER
PC004_PCRT COMMODITY_CODE A11 COMMODITY CODE
PC006_PCRT CAMPUS_CODE A2 CAMPUS CODE
PC019 DELETE_FLAG A1 DELETE FLAG
PC020 FREEZE_FLAG A1 FREEZE FLAG
PC030 CREATE_DT YYMD DATE CREATE DATE
PC032 EXPIRATION_DT YYMD DATE EXPIRATION DATE
PC034 DT_OF_LAST_ACTV YYMD DATE DT OF LAST ACTV
PC036 UNIT_PRICE P14.04 P07 UNIT PRICE
PC038 TRADE_DISC P06.03 P03 TRADE DISC
PC040 UNIT_OF_MEASURE A3 UNIT OF MEASURE
PC042 DESC_1 A40 DESC 1
PC044 DESC_2 A40 DESC 2
PC046 INVEN_NUM A12 INVEN NUMBER
PC048 SUPPLIES_INVEN A12 SUPPLIES INVEN
PC054 BUYER_CODE A3 BUYER CODE
PC056 BUYER_PHONE A3 BUYER PHONE
PC060 SAFETY_CODE A1 SAFETY CODE
PC063 FED_STATE_CNTRCT A1 FED STATE CNTRCT
PC064 CNTRCT_NUM A10 CNTRCT NUMBER
PC066 APRVL_CODE A2 APRVL CODE
PC068 APRVL_TEXT A40 APRVL TEXT
PC070 NUM_OF_BIDS I6 I2 NUMBER OF BIDS
PC072 NUM_OF_RESPONSES I6 I2 NUMBER OF RESPONSES
PC100 NUM_OF_ORDERS_CM I6 I2 NUMBER ORDERS CM
PC102 QTY_ORDERED_CM P10.02 P05 QTY ORDERED CM
PC104 AMT_ORDERED_CM P12.02 P06 AMOUNT ORDERED CM
PC106 RECV_QTY_ACCPTD_CM P10.02 P05 RECV QTY ACCPTD CM
PC108 RECV_QTY_REJCTD_CM P08.02 P04 RECV QTY REJCTD CM
PC110 RECV_QTY_BK_ORD_CM P08.02 P04 RECV QTY BK ORD CM
PC112 RECV_QTY_LATE_CM P08.02 P04 RECV QTY LATE CM
PC114 NUM_SHPMNTS_CM I6 I2 NUM SHPMNTS CM
PC116 SHPMNT_REJCTD_CM I6 I2 SHPMNT REJCTD CM
PC118 SHPMNT_BK_ORD_CM I6 I2 SHPMNT BK ORD CM
PC120 SHPMNT_LATE_CM I6 I2 SHPMNT LATE CM
PC122 NUM_INVOICES_CM I6 I2 NUM INVOICES CM
PC124 INVOICED_QTY_CM P10.02 P05 INVOICED QTY CM
PC126 INVOICED_AMT_CM P12.02 P06 INVOICED AMT CM
PC130 NUM_ORDERS_YTD I6 I2 NUM ORDERS YTD
PC132 QTY_ORDERED_YTD P10.02 P05 QYT ORDERED YTD
PC134 AMT_ORDERED_YTD P12.02 P06 AMT ORDERED YTD
PC136 REC_QTY_ACCPTD_YTD P10.02 P05 REC QTY ACCPTD YTD
PC138 REC_QTY_REJCTD_YTD P08.02 P04 REC QTY REJCTD YTD
PC140 REC_QTY_BK_ORD_YTD P08.02 P04 REC QTY BK ORD YTD
PC142 RECV_QTY_LATE_YTD P08.02 P04 RECV QTY LATE YTD
PC144 NUM_SHPMNTS_YTD I6 I2 NUM SHPMNTS YTD
PC146 SHPMNT_REJCTD_YTD I6 I2 SHPMNT REJCTD YTD
PC148 SHPMNT_BK_ORD_YTD I6 I2 SHPMNT BK ORD YTD
PC150 SHPMNT_LATE_YTD I6 I2 SHPMNT LATE YTD
PC152 NUM_INVOICES_YTD I6 I2 NUM INVOICES YTD
PC154 INVOICED_QTY_YTD P10.02 P05 INVOICED QTY YTD
PC156 INVOICED_AMT_YTD P12.02 P06 INVOICED AMT YTD
PC160 NUM_ORDERS_PY I6 I2 NUM ORDERS PY
PC162 QTY_ORDERED_PY P10.02 P05 QTY ORDERED PY
PC164 AMT_ORDERED_PY P12.02 P06 AMT ORDERED PY
PC166 RECV_QTY_ACCPTD_PY P10.02 P05 RECV QTY ACCPTD PY
PC168 RECV_QTY_REJCTD_PY P08.02 P04 RECV QTY REJCTD PY
PC170 RECV_QTY_BK_ORD_PY P08.02 P04 RECV QTY BK ORD PY
PC172 RECV_QTY_LATE_PY P08.02 P04 RECV QTY LATE PY
PC174 NUM_SHPMNTS_PY I6 I2 NUMBER SHIPMENTS PY
PC176 SHPMNT_REJCTD_PY I6 I2 SHPMNT REJCTD PY
PC178 SHPMNT_BK_ORD_PY I6 I2 SHPMNT BK ORD PY
PC180 SHPMNT_LATE_PY I6 I2 SHPMNT LATE PY
PC182 NUM_INVOICES_PY I6 I2 NUM INVOICES PY
PC184 INVOICED_QTY_PY P10.02 P05 INVOICED QTY PY
PC186 INVOICED_AMT_PY P12.02 P06 INVOICED AMT PY
PC192 PO_NUM_1 A7 PO NUMBER 1
PC194 PO_LINE_NUM_1 A3 PO LINE NUM 1
PO_NUM_2 PO_NUM_2 A7 PO NUMBER 2
PO_LINE_NUM_2 PO_LINE_NUM_2 A3 POLINE NUM 2
PO_NUM_3 PO_NUM_3 A7 PO NUMBER 3
PO_LINE_NUM_3 PO_LINE_NUM_3 A3 PO LINE NUMBER 3
PO_NUM_4 PO_NUM_4 A7 PO NUMBER 4
PO_LINE_NUM_4 PO_LINE_NUM_4 A3 PO LINE NUMBER 4
PO_NUM_5 PO_NUM_5 A7 PO NUMBER 5
PO_LINE_NUM_5 PO_LINE_NUM_5 A3 PO LINE NUMBER 5
PO_NUM_6 PO_NUM_6 A7 PO NUMBER 6
PO_LINE_NUM_6 PO_LINE_NUM_6 A3 PO LINE NUMBER 6
PO_NUM_7 PO_NUM_7 A7 PO NUMBER 7
PO_LINE_NUM_7 PO_LINE_NUM_7 A3 PO LINE NUMBER 7
PO_NUM_8 PO_NUM_8 A7 PO NUMBER 8
PO_LINE_NUM_8 PO_LINE_NUM_8 A3 PO LINE NUMBER 8
PO_NUM_9 PO_NUM_9 A7 PO NUMBER 9
PO_LINE_NUM_9 PO_LINE_NUM_9 A3 PO LINE NUMBER 9
PO_NUM_10 PO_NUM_10 A7 PO NUMBER 10
PO_LINE_NUM_10 PO_LINE_NUM_10 A3 PO LINE NUMBER 10
PO_NUM_11 PO_NUM_11 A7 PO NUMBER 11
PO_LINE_NUM_11 PO_LINE_NUM_11 A3 PO LINE NUMBER 11
PO_NUM_12 PO_NUM_12 A7 PO NUMBER 12
PO_LINE_NUM_12 PO_LINE_NUM_12 A3 PO LINE NUMBER 12
PO_NUM_13 PO_NUM_13 A7 PO NUMBER 13
PO_LINE_NUM_13 PO_LINE_NUM_13 A3 PO LINE NUMBER 13
PO_NUM_14 PO_NUM_14 A7 PO NUMBER 14
PO_LINE_NUM_14 PO_LINE_NUM_14 A3 PO LINE NUMBER 14
PO_NUM_15 PO_NUM_15 A7 PO NUMBER 15
PO_LINE_NUM_15 PO_LINE_NUM_15 A3 PO LINE NUMBER 15
PO_NUM_16 PO_NUM_16 A7 PO NUMBER 16
PO_LINE_NUM_16 PO_LINE_NUM_16 A3 PO LINE NUMBER 16
PO_NUM_17 PO_NUM_17 A7 PO NUMBER 17
PO_LINE_NUM_17 PO_LINE_NUM_17 A3 PO LINE NUMBER 17
PO_NUM_18 PO_NUM_18 A7 PO NUM 18
PO_LINE_NUM_18 PO_LINE_NUM_18 A3 PO LINE NUMBER 18
PO_NUM_19 PO_NUM_19 A7 PO NUMBER 19
PO_LINE_NUM_19 PO_LINE_NUM_19 A3 PO LINE NUMBER 19
PO_NUM_20 PO_NUM_20 A7 PO NUMBER 20
PO_LINE_NUM_20 PO_LINE_NUM_20 A3 PO LINE NUMBER 20
PX003_PXRT COMMODITY_CODE A11 COMMODITY CODE
PX004_PXRT COMMODITY_NAME A30 COMMODITY NAME
PX012_PXRT ALIAS_FLAG A1 ALIAS FLAG

 

508 UsableNet Approved (v. 1.2.1)