PURCHASE_ORDER - Report
Data Element |
Business Definition |
Data Type |
Source Name |
Source Data Element |
Form Name |
PURCHASE_ORDER |
PURCHASE ORDER ASSOCIATED WITH THIS INVOICE. |
|
FPBPOHD |
FPBPOHD_CODE |
UNKNOWN |
PURCHASE_ORDER_DATE |
DATE ON WHICH A PURCHASE ORDER WAS CREATED. |
|
FPBPOHD |
FPBPOHD_PO_DATE |
UNKNOWN |
TRANSACTION_DATE |
DATE THE TRANSACTION WAS PROCESSED. |
|
FPBPOHD |
FPBPOHD_TRANS_DATE |
UNKNOWN |
CLOSED_IND |
AUTOMATIC INDICATOR SET WHEN AN ITEM ON A PURCHASE ORDER IS CLOSED |
|
FPBPOHD |
FPBPOHD_CLOSED_IND |
UNKNOWN |
COMPLETE_IND |
INDICATES IF THE DOCUMENT HAS BEEN COMPLETED. |
|
FPBPOHD |
FPBPOHD_COMPLETE_IND |
UNKNOWN |
APPROVAL_IND |
INDICATES IF THE DOCUMENT HAS BEEN APPROVED FOR PROCESSING BY THE INDIVIDUAL AUTHORIZED (VIA THE USER HIERARCHY TABLE) TO APPROVE THE DOCUMENT. |
|
FPBPOHD |
FPBPOHD_APPR_IND |
UNKNOWN |
PRINT_IND |
INDICATES IF THE DOCUMENT HAS BEEN PRINTED. |
|
FPBPOHD |
FPBPOHD_PRINT_IND |
UNKNOWN |
PRINTED_DATE |
DATE ON WHICH A PURCHASE ORDER WAS PRINTED. |
|
FPBPOHD |
FPBPOHD_PO_PRINTED_DATE |
UNKNOWN |
VENDOR_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
FPBPOHD |
FPBPOHD_VEND_PIDM |
UNKNOWN |
BUYER |
USER SPECIFIED CODE WHICH DESCRIBES A BUYER. |
|
FPBPOHD |
FPBPOHD_BUYR_CODE |
UNKNOWN |
BUYER_NAME |
NAME OF THE BUYER. |
|
FTVBUYR |
FTVBUYR_NAME |
UNKNOWN |
REQUIRED_DATE |
DATE GIVEN TO THE VENDOR AS A REQUIRED DELIVER BY DATE. |
|
FPBPOHD |
FPBPOHD_REQD_DATE |
UNKNOWN |
CHART_OF_ACCOUNTS |
INSTITUTIONAL DEFINED VALUE FOR THE CHART OF ACCOUNTS. |
|
FPBPOHD |
FPBPOHD_COAS_CODE |
UNKNOWN |
CHART_OF_ACCOUNTS_DESC |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVCOAS |
FTVCOAS_TITLE |
UNKNOWN |
ORGANIZATION_CODE |
IDENTIFIES THE INDIVIDUAL ORGANIZATION CODE WHICH APPEARS ON A TRANSACTION. |
|
FPBPOHD |
FPBPOHD_ORGN_CODE |
UNKNOWN |
ORGANIZATION_DESC |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVORGN |
FTVORGN_TITLE |
UNKNOWN |
ORGANIZATION_LEVEL_1 |
PRIMARY ORGANIZATION WITHIN THE ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_ORGN_CODE |
UNKNOWN |
ORGANIZATION_DESC_1 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVORGN |
FTVORGN_TITLE |
UNKNOWN |
ORGANIZATION_STATUS_1 |
STATUS OF THE PRIMARY ORGANIZATION WITHIN THE ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_STATUS_IND |
UNKNOWN |
ORGANIZATION_LEVEL_2 |
LEVEL 2 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_ORGN_CODE |
UNKNOWN |
ORGANIZATION_DESC_2 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVORGN |
FTVORGN_TITLE |
UNKNOWN |
ORGANIZATION_STATUS_2 |
STATUS OF THE LEVEL 2 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_STATUS_IND |
UNKNOWN |
ORGANIZATION_LEVEL_3 |
LEVEL 3 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_ORGN_CODE |
UNKNOWN |
ORGANIZATION_DESC_3 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVORGN |
FTVORGN_TITLE |
UNKNOWN |
ORGANIZATION_STATUS_3 |
STATUS OF THE LEVEL 3 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_STATUS_IND |
UNKNOWN |
ORGANIZATION_LEVEL_4 |
LEVEL 4 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_ORGN_CODE |
UNKNOWN |
ORGANIZATION_DESC_4 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVORGN |
FTVORGN_TITLE |
UNKNOWN |
ORGANIZATION_STATUS_4 |
STATUS OF THE LEVEL 4 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_STATUS_IND |
UNKNOWN |
ORGANIZATION_LEVEL_5 |
LEVEL 5 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_ORGN_CODE |
UNKNOWN |
ORGANIZATION_DESC_5 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVORGN |
FTVORGN_TITLE |
UNKNOWN |
ORGANIZATION_STATUS_5 |
STATUS OF THE LEVEL 5 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_STATUS_IND |
UNKNOWN |
ORGANIZATION_LEVEL_6 |
LEVEL 6 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_ORGN_CODE |
UNKNOWN |
ORGANIZATION_DESC_6 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVORGN |
FTVORGN_TITLE |
UNKNOWN |
ORGANIZATION_STATUS_6 |
STATUS OF THE LEVEL 6 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_STATUS_IND |
UNKNOWN |
ORGANIZATION_LEVEL_7 |
LEVEL 7 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_ORGN_CODE |
UNKNOWN |
ORGANIZATION_DESC_7 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVORGN |
FTVORGN_TITLE |
UNKNOWN |
ORGANIZATION_STATUS_7 |
STATUS OF THE LEVEL 7 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_STATUS_IND |
UNKNOWN |
ORGANIZATION_LEVEL_8 |
LEVEL 8 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_ORGN_CODE |
UNKNOWN |
ORGANIZATION_DESC_8 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVORGN |
FTVORGN_TITLE |
UNKNOWN |
ORGANIZATION_STATUS_8 |
STATUS OF THE LEVEL 8 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_STATUS_IND |
UNKNOWN |
SHIPPING_ADDRESS |
INSTITUTIONAL DEFINED CODE WHICH DESIGNATES A SPECIFIC SHIPPING ADDRESS. |
|
FPBPOHD |
FPBPOHD_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 |
TOTAL_APPROVED_ITEM_AMOUNT |
IDENTIFIES THE APPROVED ITEM AMOUNT FOR ALL ITEMS IN THE PURCHASE ORDER. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
TOTAL_CONVERTED_AMOUNT |
IDENTIFIES THE CONVERTED ORDER AMOUNT. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
TOTAL_BLANKET_ORDER_BAL |
IDENTIFIES THE BLANKET ORDER BALANCE FOR ALL ITEMS IN THE PURCHASE ORDER. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
PURCHASE_ORDER_TYPE |
PURCHASE ORDER TYPE. |
|
FPBPOHD |
FPBPOHD_PO_TYPE_IND |
UNKNOWN |
PURCHASE_ORDER_TYPE_DESC |
PURCHASE ORDER TYPE DESCRIPTION. |
|
FUNCTION |
NOT AVAILABLE |
UNKNOWN |
QUOTE_DATE |
SPECIFIES THE QUOTE DATE. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
QUOTE_REFERENCE |
SPECIFIES THE QUOTE REFERENCE. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
PO_START_DATE |
SPECIFIES THE PURCHASE ORDER START DATE. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
PO_END_DATE |
SPECIFIES THE PURCHASE ORDER END DATE. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
BLANKET_ORDER_IND |
BLANKET ORDER INDICATOR. |
|
FPBPOHD |
FPBPOHD_BLANKET_IND |
UNKNOWN |
PO_CHANGE_DATE |
SPECIFIES THE PURCHASE ORDER CHANGE DATE. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
PO_CHANGE_ORDER |
SPECIFIES THE PURCHASE ORDER WAS CHANGED. |
|
FPBPOHD |
FPBPOHD_CHANGE_SEQ_NUM |
UNKNOWN |
EDI_IND |
INDICATES IF THE PURCHASE ORDER IS TO BE SENT VIA EDI |
|
FPBPOHD |
FPBPOHD_EDI_IND |
UNKNOWN |
FREIGHT_TERMS |
FREIGHT TERMS CODE INDICATING THE METHOD OF PAYMENT FOR FREIGHT. |
|
FPBPOHD |
FPBPOHD_FTRM_CODE |
UNKNOWN |
FREIGHT_TERMS_DESC |
NAME OF THE FREIGHT TERMS CODE. |
|
FTVFTRM |
FTVFTRM_DESC |
UNKNOWN |