Tables Involved in Purchasing & ePro
***************************
*PO RELATED TABLES*
***************************
PS_PO_HDR
PS_PO_HDR_VAT
PS_PO_HDR_MISC
PS_PO_HDR_PHONE
PS_PO_LINE
PS_PO_LINE_DISTRIB
PS_PO_LINE_MATCHED
PS_PO_LINE_MISC
PS_PO_LINE_SHIP
PS_PO_LN_MISC_DTL
PS_PO_LN_SHIP_MTCH
PS_PO_LN_SHIP_SUT
PS_PO_LN_SHIP_MISC
*PO RELATED TABLES*
***************************
PS_PO_HDR
PS_PO_HDR_VAT
PS_PO_HDR_MISC
PS_PO_HDR_PHONE
PS_PO_LINE
PS_PO_LINE_DISTRIB
PS_PO_LINE_MATCHED
PS_PO_LINE_MISC
PS_PO_LINE_SHIP
PS_PO_LN_MISC_DTL
PS_PO_LN_SHIP_MTCH
PS_PO_LN_SHIP_SUT
PS_PO_LN_SHIP_MISC
**********************
*PO Set Up Tables*
**********************
Installation Options - Purchasing
PS_INSTALLATION_PO - Installation Options - Purchasing
PS_INSTALLATION - Installation Options - Overall
Business Unit Tables
PS_BUS_UNIT_TBL_PM - Business Unit Definition
PS_PO_APR_NOT_RQ - PO Approval RelatedPS_PO_COAPR_NOT_RQ - Change Order Approval Related
PS_AUTO_NUM_TBL_BU - PO Autonumbering
PS_RS_TASK_TYPE - ????
Business Unit Options Tables
PS_BUS_UNIT_OPT_PM - PO Purchasing Options
Carrier Related Tables
PS_CARRIER_ID - Carrier Set up
PS_CARRIER_SHEX_DT - Carrier Scheduled Exceptions Std Exceptions
PS_CARRIER_SHEX_BK - Carrier Scheduled Exceptions Block Exceptions
PS_CARRIER_SHEX_DT - Carrier Scheduled Exceptions Std Exceptions
PS_CARRIER_SHEX_BK - Carrier Scheduled Exceptions Block Exceptions
Standard Comments
PS_STD_COMM_TYP_PO - Standard Comment Type
PS_STD_COMM_TBL_PO - Standard Comment
PS_COMMENTS_TBL - Stores the comment description
Commodity Code
PS_COMMOD_CODE - Commodity Code Table
Frieght Terms Code
PS_FREIGHT_TERMS
Location Code Table
PS_LOCATION_TBL
Reason Code Table
PS_REASON_CD
Ship To Table
PS_SHIPTO_TBL - Ship to Location
PS_SUT_EXCPTN_TBL - Ship to Tax Exemption
PS_SUT_DFLT_TBL - Ship to Tax Default Table
PS_AP_MTCH_RULECFG
PS_AP_RULESET_DTL
PS_AUTO_NUM_TBL_BU
PS_BUS_UNIT_PV_INT
PS_CHNG_MAP_REC
PS_CHNG_MAP_TMPLT
PS_MTCH_CNTRL_VW
PS_ORIGIN_PO
PS_PV_ADM_PROJ_TBL
PS_PV_ADM_PROJ_XRF
PS_PV_BUS_UNIT_PM
PS_SHIP_METHOD
PS_UNITS_CVT_TBL
PS_UNITS_TBL
PS_VAT_SEARCH_TRF
PS_AP_RULESET_DTL
PS_AUTO_NUM_TBL_BU
PS_BUS_UNIT_PV_INT
PS_CHNG_MAP_REC
PS_CHNG_MAP_TMPLT
PS_MTCH_CNTRL_VW
PS_ORIGIN_PO
PS_PV_ADM_PROJ_TBL
PS_PV_ADM_PROJ_XRF
PS_PV_BUS_UNIT_PM
PS_SHIP_METHOD
PS_UNITS_CVT_TBL
PS_UNITS_TBL
PS_VAT_SEARCH_TRF