PURCHASE_ORDER_ITEM - Report
Data Element |
Business Definition |
Data Type |
Source Name |
Source Data Element |
Form Name |
PURCHASE_ORDER |
PURCHASE ORDER ASSOCIATED WITH THIS INVOICE. |
|
FPRPODT |
FPRPODT_POHD_CODE |
UNKNOWN |
ITEM |
LITERAL COMMODITY OR GOODS ASSOCIATED WITH AN INVOICE PROCESSING RECORD. UNIQUE SEQUENCE NUMBER DIRECTLY ASSOCIATED AN ITEM ON THE COMMODITY RECORD. |
|
FPRPODT |
FPRPODT_ITEM |
UNKNOWN |
COMMODITY |
UNIQUE SEQUENCE NUMBER DIRECTLY ASSOCIATED WITH AN ITEM ON THE COMMODITY RECORD. |
|
FPRPODT |
FPRPODT_COMM_CODE |
UNKNOWN |
COMMODITY_DESC |
DESCRIPTION OR TITLE OF THE COMMODITY. THIS IS DERIVED FROM THE COMMODITY VALIDATION TABLE ON COMMODITIES STORED IN THE SYSTEM OR FROM THE DOCUMENT LINE ITEM ON ONE-TIME COMMODITIES. |
|
FPRPODT |
FPRPODT_COMM_DESC |
UNKNOWN |
UNIT_OF_MEASURE |
HE UNIT OF MEASURE APPLICABLE TO THE SELECTED COMMODITY. |
|
FPRPODT |
FPRPODT_UOMS_CODE |
UNKNOWN |
UNIT_OF_MEASURE_DESC |
DESCRIPTION OR TITLE OF THE UNIT OF MEASURE. |
|
FTVUOMS |
FTVUOMS_DESC |
UNKNOWN |
UNIT_PRICE |
UNIT PRICE FOR GOODS AND OR SERVICES. |
|
FPRPODT |
FPRPODT_UNIT_PRICE |
UNKNOWN |
LIQUIDATION_AMOUNT |
AMOUNT WHICH HAS BEEN LIQUIDATED AGAINST THE ORIGINAL ENCUMBRANCE. |
|
FPRPODT |
FPRPODT_LIQ_AMT |
UNKNOWN |
QUANTITY |
QUANTITY OF MATERIALS TO BE SENT. |
|
FPRPODT |
FPRPODT_QTY |
UNKNOWN |
DISCOUNT_AMOUNT |
VALUE OF THE DISCOUNT BEING TAKEN ON THE INVOICE ACCOUNTING AMOUNT ON THIS INVOICE ITEM. |
|
FPRPODT |
FPRPODT_DISC_AMT |
UNKNOWN |
TAX_AMOUNT |
AMOUNT OF TAX COMPUTED OR ENTERED FOR A DOCUMENT. |
|
FPRPODT |
FPRPODT_TAX_AMT |
UNKNOWN |
ADDITIONAL_CHARGES_AMOUNT |
AMOUNT OF ADDITIONAL CHARGES FOR THIS INVOICE ITEM. |
|
FPRPODT |
FPRPODT_ADDL_CHRG_AMT |
UNKNOWN |
APPROVED_ITEM_AMOUNT |
AMOUNT APPROVED FOR THIS ITEM ON THE INVOICE. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
DISCOUNT_PERCENT |
SPECIFIES THE DISCOUNT PERCENT FOR THE ITEM. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
VENDOR_REFERENCE_NUMBER |
VENDOR REFERENCE OR PART NUMBER FOR A COMMODITY ITEM PROVIDED. |
|
FPRPODT |
FPRPODT_VEND_REF_NUM |
UNKNOWN |
SUSPENSE_IND |
INDICATOR TO INFORM THE USER THAT A DOCUMENT IS BEING HELD IN SUSPENSE DUE TO MISSING OR ERRONEOUS DATA CONTENT. |
|
FPRPODT |
FPRPODT_SUSP_IND |
UNKNOWN |
CLOSED_IND |
AUTOMATIC INDICATOR SET WHEN AN ITEM ON A PURCHASE ORDER IS CLOSED |
|
FPRPODT |
FPRPODT_CLOSED_IND |
UNKNOWN |
CANCEL_IND |
INDICATOR THAT THE CHECK WAS CANCELLED. |
|
FPRPODT |
FPRPODT_CANCEL_IND |
UNKNOWN |
CANCEL_DATE |
DATE THAT THE CHECK WAS CANCELLED. |
|
FPRPODT |
FPRPODT_CANCEL_DATE |
UNKNOWN |
CONVERTED_UNIT_PRICE |
CURRENCY CONVERTED UNIT PRICE FOR THIS ITEM. |
|
FPRPODT |
FPRPODT_CONVERT_UNIT_PRICE |
UNKNOWN |
CONVERTED_DISCOUNT_AMOUNT |
CURRENCY CONVERTED DISCOUNT AMOUNT FOR THIS ITEM. |
|
FPRPODT |
FPRPODT_CONVERT_DISC_AMT |
UNKNOWN |
CONVERTED_TAX_AMOUNT |
CURRENCY CONVERTED TAX AMOUNT FOR THIS ITEM. |
|
FPRPODT |
FPRPODT_CONVERT_TAX_AMT |
UNKNOWN |
CONVERTED_ADDITNAL_AMOUNT |
CURRENCY CONVERTED ADDITIONAL CHARGE AMOUNT FOR THIS ITEM. |
|
FPRPODT |
FPRPODT_CONVERT_ADDL_CHRG_AMT |
UNKNOWN |
TAX_GROUP |
TAX GROUP CODE TO BE USED FOR THIS INVOICE COMMODITY RECORD. |
|
FPRPODT |
FPRPODT_TGRP_CODE |
UNKNOWN |
TAX_GROUP_DESC |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVTGRP |
FTVTGRP_TGRP_CODE |
UNKNOWN |
BLANKET_ORDER_REMAINING_BAL |
CONTAINS THE REMAINING BALANCE OF THE BLANKET ORDER. |
|
FPRPODT |
FPRPODT_BO_REMAIN_BAL |
UNKNOWN |
REQUISITION |
IDENTIFIES THE REQUISITION. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
REQUISITION_NUMBER |
REQUISITION NUMBER OF THE POSITION CLASS AND POSITION NUMBER. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
BID_NUMBER |
IDENTIFIES THE BID NUMBER. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
SHIPMENT_TO_ADDRESS |
|
|
FPRPODT |
FPRPODT_SHIP_CODE |
UNKNOWN |
STREET_LINE1 |
FIRST LINE OF THE PERSON'S ADDRESS. |
|
FTVSHIP |
FTVSHIP_ADDR_LINE1 |
UNKNOWN |
STREET_LINE2 |
SECOND LINE OF THE PERSON'S ADDRESS. |
|
FTVSHIP |
FTVSHIP_ADDR_LINE2 |
UNKNOWN |
STREET_LINE3 |
THIRD LINE OF THE PERSON'S ADDRESS. |
|
FTVSHIP |
FTVSHIP_ADDR_LINE3 |
UNKNOWN |
STREET_LINE4 |
FOURTH LINE OF THE PERSON'S ADDRESS. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
BUILDING |
BUILDING OF THE VENDOR. |
|
FTVSHIP |
FTVSHIP_BUILDING |
UNKNOWN |
FLOOR |
FLOOR NUMBER SPECIFIC TO THE SHIPPING ADDRESS. |
|
FTVSHIP |
FTVSHIP_FLOOR |
UNKNOWN |
CITY |
CITY IN THE ADDRESS FOR A PERSON OR ENTITY. |
|
FTVSHIP |
FTVSHIP_CITY |
UNKNOWN |
COUNTY |
COUNTY CODE FOR THIS ADDRESS. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
COUNTY_DESC |
NAME OF THE COUNTY FROM THE ADDRESS. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
STATE_PROVINCE |
STATE/PROVINCE CODE OF THE ADDRESS. |
|
FTVSHIP |
FTVSHIP_STATE |
UNKNOWN |
STATE_PROVINCE_DESC |
DESCRIPTION ASSOCIATED WITH THE PERSON'S PREFERRED ADDRESS STATE/PROVINCE CODE. |
|
STVSTAT |
STVSTAT_DESC |
UNKNOWN |
POSTAL_CODE |
ADDRESS POST CODE OR ZIP CODE. |
|
FTVSHIP |
FTVSHIP_ZIP_CODE |
UNKNOWN |
NATION |
CODE WHICH IDENTIFIES A PARTICULAR COUNTRY. |
|
FTVSHIP |
FTVSHIP_NATN_CODE |
UNKNOWN |
NATION_DESC |
DESCRIPTION ASSOCIATED WITH THE PERSON'S PREFERRED ADDRESS NATION/COUNTRY CODE. |
|
STVNATN |
STVNATN_NATION |
UNKNOWN |
CONTACT_NAME |
NAME OF THE CONTACT AT THE SOURCE. |
|
FTVSHIP |
FTVSHIP_CONTACT |
UNKNOWN |
DELIVERY_POINT |
DELIVERY POINT INFORMATION FOR ADDRESS |
|
FTVSHIP |
FTVSHIP_DELIVERY_POINT |
UNKNOWN |
CORRECTION_DIGIT |
CORRECTION DIGIT INFORMATION FOR THE POSTAL SERVICE. |
|
FTVSHIP |
FTVSHIP_CORRECTION_DIGIT |
UNKNOWN |
CARRIER_ROUTE |
CARRIER ROUTE INFORMATION FOR THE ADDRESS |
|
FTVSHIP |
FTVSHIP_CARRIER_ROUTE |
UNKNOWN |
PHONE_NUMBER_COMBINED |
ALL RECORDED PIECES OF THE TELEPHONE NUMBER COMBINED IN A SINGLE FIELD. INTERNATIONAL CODE, AREA CODE, NUMBER, EXTENSION. |
|
SUBSTR |
PHONE_NUMBER_COMBINED |
UNKNOWN |
PHONE_INTL_ACCESS |
FREE FORMAT INTERNATIONAL ACCESS CODE FOR TELEPHONE NUMBER INCLUDING COUNTRY AND CITY CODE. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
PHONE_AREA |
AREA CODE OF THE REFERENCE. |
|
FTVSHIP |
FTVSHIP_PHONE_AREA |
UNKNOWN |
PHONE_NUMBER |
TELEPHONE NUMBER. |
|
FTVSHIP |
FTVSHIP_PHONE_NUMBER |
UNKNOWN |
PHONE_EXT |
TELEPHONE NUMBER EXTENSION. |
|
FTVSHIP |
FTVSHIP_PHONE_EXT |
UNKNOWN |
PHONE_UNLIST_IND |
SPECIFIES IF THE PREFERRED PHONE NUMBER IS TO BE UNLISTED OR NOT. |
|
NA |
NOT AVAILABLE |
UNKNOWN |