Tables involved in Receivables
***************************
*When a Pending Item is Saved*
***************************
PS_GROUP_CONTROL
PS_PENDING_ITEM
PS_PENDING_DST
PS_PENDING_VAT
PS_PENDING_TAX - Used with India Localization
PS_PENDING_TAX_DTL - Used with India Localization
*When a Pending Item is Saved*
***************************
PS_GROUP_CONTROL
PS_PENDING_ITEM
PS_PENDING_DST
PS_PENDING_VAT
PS_PENDING_TAX - Used with India Localization
PS_PENDING_TAX_DTL - Used with India Localization
PS_PENDING_IT_MRL
***********************************
*When AR Update is completed*
************************************
PS_ITEM
PS_ITEM_ACTIVITY
PS_ITEM_DST
PS_ITEM_ACT_VAT
PS_CUST_DATA
PS_CUST_HISTORY
PS_SUBCUST_DATA
PS_SUBCUST_HISTORY
PS_ITEM_ACTTAX
PS_ITEM_ACTTAX_DTL
PS_ITEM_AUDIT
***********************************
*When AR Update is completed*
************************************
PS_ITEM
PS_ITEM_ACTIVITY
PS_ITEM_DST
PS_ITEM_ACT_VAT
PS_CUST_DATA
PS_CUST_HISTORY
PS_SUBCUST_DATA
PS_SUBCUST_HISTORY
PS_ITEM_ACTTAX
PS_ITEM_ACTTAX_DTL
PS_ITEM_AUDIT
*******************
*Payment Data *
*******************
PS_DEPOSIT_CONTROL
PS_PAYMENT
PS_PAYMENT_ITEM
PS_PAYMENT_ID_CUST
PS_PAYMENT_ID_ITEM
PS_PAY_MISC_DST
PS_PAY_ITEM_MRL
PS_EE_DJR_ACCTG_LN
*Payment Data *
*******************
PS_DEPOSIT_CONTROL
PS_PAYMENT
PS_PAYMENT_ITEM
PS_PAYMENT_ID_CUST
PS_PAYMENT_ID_ITEM
PS_PAY_MISC_DST
PS_PAY_ITEM_MRL
PS_EE_DJR_ACCTG_LN
**************************
*Customer Information*
**************************
PS_CUSTOMER
PS_CUST_ADDR_SEQ
PS_CUST_ADDRESS
PS_CUST_CREDIT
PS_CUST_OPTION
PS_CUST_SHIPTO_OPT
PS_CUST_SOLDTO_OPT
PS_CUST_BILLTO
PS_CUST_SHIPTO
PS_CUST_CNTCT_SEQ
PS_CUST_CONTACT
PS_CUST_CNTCT_TYPE
PS_CUST_CNTCT_DOC
PS_CUST_CNTCT_CARD
PS_CUST_CNTCT_PHN
PS_CUST_CRSPD
*Customer Information*
**************************
PS_CUSTOMER
PS_CUST_ADDR_SEQ
PS_CUST_ADDRESS
PS_CUST_CREDIT
PS_CUST_OPTION
PS_CUST_SHIPTO_OPT
PS_CUST_SOLDTO_OPT
PS_CUST_BILLTO
PS_CUST_SHIPTO
PS_CUST_CNTCT_SEQ
PS_CUST_CONTACT
PS_CUST_CNTCT_TYPE
PS_CUST_CNTCT_DOC
PS_CUST_CNTCT_CARD
PS_CUST_CNTCT_PHN
PS_CUST_CRSPD
PS_CUST_REGN_TYPE
PS_CUST_VAT_REG
PS_CUST_CONVER
PS_CONVR_DTL
PS_KEYWORD_TBL_AR
PS_FOLLOWUP_TBL
PS_CUST_VAT_REG
PS_CUST_CONVER
PS_CONVR_DTL
PS_KEYWORD_TBL_AR
PS_FOLLOWUP_TBL
**********************
*Entry Type Tables*
**********************
PS_AUTO_ENTRY_TBL
PS_ENTRY_TYPE_TBL
PS_ENTRY_REASN_TBL
PS_ENTRY_USE_TBL
PS_ITEM_ENTRY_TBL
*******************
*SET ID Related*
*******************
PS_SETID_TBL
PS_SETID_TBL
PS_SET_CNTRL_GROUP
PS_SET_CNTRL_REC
PS_BI_BILL_BY
PS_BI_BILL_BY_FLD
PS_BI_IVC_NUM
PS_BI_SORT_BY
PS_BI_SORT_BY_FLD
PS_AR_IPAC_HDR
PS_AR_IPAC_SGL
PS_AR_IPAC_DETAIL
PS_AR_CC_TRAN_HDR
PS_AR_CC_TRAN_TBL
PS_EE_ITM_ACCTG_LN
Posted Customer Data
-------------------
PS_CUST_DATA
PS_CUST_AGING
PS_CUST_HISTORY
PS_SUBCUST_DATA
PS_SUBCUST_AGING
PS_SUBCUST_HISTORY
Statement Data
--------------
PS_STMT_CUST
PS_STMT_CUST_DTL
PS_STMT_CUST_BFWD
PS_AR_STMT_CUST
Dunning Data
------------
PS_DUN_CUST
PS_DUN_DTL
Overdue Charges Data
--------------------
PS_OC_CUST
PS_OC_CUST_DTL
Conversation Data
-----------------
PS_CUST_CONVER
PS_CUST_CONV_HDR
PS_CUST_CONVER_DTL
PS_CUST_CONVER_ATT
Message Log Data(Common for all modules)
----------------------------------------
PS_MESSAGE_LOG
PS_MESSAGE_LOGPARM
Other Tables:
PS_AR_FLD_REF_TBL PS_AR_RUN_CONTROL PS_AUTO_ENTRY_TBL PS_AUTO_LINES_TBL PS_BUS_UNIT_OPT_AR PS_BUS_UNIT_TBL_AR PS_CUST_MICR_TBL PS_DST_ACCT_TBL
PS_DST_CODE_TBL PS_ENTRY_USE_L_TBL PS_ENTRY_USE_TBL PS_INSTALLATION_AR
PS_ORIGIN_TBL PS_PAYMENT_ID_CUST
PS_PAYMENT_ID_ITEM PS_PENDING_DST_BAL PS_PP_GROUP_TBL PS_PP_MET_TBL PS_PP_MET_FUNC_TBL PS_PP_MET_USE_TBL PS_PP_REQUEST
PS_PP_STMT_B_TBL PS_PP_STMT_TBL PS_SET_CNTRL_REC
Temporary Tables Used by Payment Predictor
PS_PP_CUST_TMP
PS_PP_ITEM_TMP
PS_PP_ITEM_TMP2 PS_PP_MATCH_TMP
PS_PP_PAYMENT_TMP
PS_PENDING_DST_TMP
PS_PP_STEP_TMP
TAO Tables used by ARUPDATE Process:
------------------------------------
PS_PGG_SERVICE_AET
PS_RP_POSTING_AET
PS_PG_AUTENT_TAO
PS_PG_BULED_TAO
PS_PG_CUR_RT_TAO
PS_PG_CUROLD_TAO
PS_PG_CURRT2_TAO
PS_PG_DFTREC_TAO
PS_PG_DST_AR_TAO
PS_PG_DST_DM_TAO
PS_PG_DST_ID_TAO
PS_PG_DST2_TAO
PS_PG_DSTBAL_TAO
PS_PG_DSTOLD_TAO
PS_PG_IIU_TAO
PS_PG_IIU2_TAO
PS_PG_ITEM_TAO
PS_PG_ITEMAE_TAO
PS_PG_ITEMAV_TAO
PS_PG_ITEMVI_TAO
PS_PG_ITMDST_TAO
PS_PG_ITMENT_TAO
PS_PG_ITRATE_TAO
PS_PG_LEDCUR_TAO
PS_PG_LEDOLD_TAO
PS_PG_MDST2_TAO
PS_PG_MULDST_TAO
PS_PG_PDST2_TAO
PS_PG_PDST3_TAO
PS_PG_PDST4_TAO
PS_PG_PENDST_TAO
PS_PG_PENVAT_TAO
PS_PG_REQOLD_TAO
PS_PG_RQST_TAO
PS_PG_RQST2_TAO
PS_PG_RTDFLT_TAO
PS_PG_VATAMT_TAO
PS_PG_VATSEQ_TAO
PS_PGG_GROUP_TAO
PS_HS_CLSITM_TMP
PS_HS_CLSHST_TMP
PS_AR_IPAC_SGL
PS_AR_IPAC_DETAIL
PS_AR_CC_TRAN_HDR
PS_AR_CC_TRAN_TBL
PS_EE_ITM_ACCTG_LN
Posted Customer Data
-------------------
PS_CUST_DATA
PS_CUST_AGING
PS_CUST_HISTORY
PS_SUBCUST_DATA
PS_SUBCUST_AGING
PS_SUBCUST_HISTORY
Statement Data
--------------
PS_STMT_CUST
PS_STMT_CUST_DTL
PS_STMT_CUST_BFWD
PS_AR_STMT_CUST
Dunning Data
------------
PS_DUN_CUST
PS_DUN_DTL
Overdue Charges Data
--------------------
PS_OC_CUST
PS_OC_CUST_DTL
Conversation Data
-----------------
PS_CUST_CONVER
PS_CUST_CONV_HDR
PS_CUST_CONVER_DTL
PS_CUST_CONVER_ATT
Message Log Data(Common for all modules)
----------------------------------------
PS_MESSAGE_LOG
PS_MESSAGE_LOGPARM
Other Tables:
PS_AR_FLD_REF_TBL PS_AR_RUN_CONTROL PS_AUTO_ENTRY_TBL PS_AUTO_LINES_TBL PS_BUS_UNIT_OPT_AR PS_BUS_UNIT_TBL_AR PS_CUST_MICR_TBL PS_DST_ACCT_TBL
PS_DST_CODE_TBL PS_ENTRY_USE_L_TBL PS_ENTRY_USE_TBL PS_INSTALLATION_AR
PS_ORIGIN_TBL PS_PAYMENT_ID_CUST
PS_PAYMENT_ID_ITEM PS_PENDING_DST_BAL PS_PP_GROUP_TBL PS_PP_MET_TBL PS_PP_MET_FUNC_TBL PS_PP_MET_USE_TBL PS_PP_REQUEST
PS_PP_STMT_B_TBL PS_PP_STMT_TBL PS_SET_CNTRL_REC
Temporary Tables Used by Payment Predictor
PS_PP_CUST_TMP
PS_PP_ITEM_TMP
PS_PP_ITEM_TMP2 PS_PP_MATCH_TMP
PS_PP_PAYMENT_TMP
PS_PENDING_DST_TMP
PS_PP_STEP_TMP
TAO Tables used by ARUPDATE Process:
------------------------------------
PS_PGG_SERVICE_AET
PS_RP_POSTING_AET
PS_PG_AUTENT_TAO
PS_PG_BULED_TAO
PS_PG_CUR_RT_TAO
PS_PG_CUROLD_TAO
PS_PG_CURRT2_TAO
PS_PG_DFTREC_TAO
PS_PG_DST_AR_TAO
PS_PG_DST_DM_TAO
PS_PG_DST_ID_TAO
PS_PG_DST2_TAO
PS_PG_DSTBAL_TAO
PS_PG_DSTOLD_TAO
PS_PG_IIU_TAO
PS_PG_IIU2_TAO
PS_PG_ITEM_TAO
PS_PG_ITEMAE_TAO
PS_PG_ITEMAV_TAO
PS_PG_ITEMVI_TAO
PS_PG_ITMDST_TAO
PS_PG_ITMENT_TAO
PS_PG_ITRATE_TAO
PS_PG_LEDCUR_TAO
PS_PG_LEDOLD_TAO
PS_PG_MDST2_TAO
PS_PG_MULDST_TAO
PS_PG_PDST2_TAO
PS_PG_PDST3_TAO
PS_PG_PDST4_TAO
PS_PG_PENDST_TAO
PS_PG_PENVAT_TAO
PS_PG_REQOLD_TAO
PS_PG_RQST_TAO
PS_PG_RQST2_TAO
PS_PG_RTDFLT_TAO
PS_PG_VATAMT_TAO
PS_PG_VATSEQ_TAO
PS_PGG_GROUP_TAO
PS_HS_CLSITM_TMP
PS_HS_CLSHST_TMP