.
| Payment_service_request_id | Primary Key |
| Calling_app_id | For Invoice Payment, it is application Id of SQLAP |
| Calling_app_pay_service_req_code | checkrun_name of ap_inv_selection_criteria_all |
| Payment_service_request_status | Lookup iby_request_statuses |
| Allow_zero_payments_flag | Id it is no then an invoice and Credit memo of same amount will not get paid and those documents will remian in unpaid status |
| Process_type | Lookup type IBY_PROCESS_TYPES. This col has a value of STANDARD if payments are submitted using payment UI. I do not know when this col is set to MANUAL |
| Internal_bank_account_id | foreign key ot ce_bank_accounts |
| Payment_profile_id | Foreign key to IBY_ACCT_PMT_PROFILES_B |
| Documemt_rejection_level_code | Lookup type IBY_DOCUMENT_REJECTION_LEVELS. if it is set to REQUEST then whoe request is rejected if a single payment fails for any reason |
| Payment_rejection_level_code | Lookup type IBY_PAYMENT_REJECTION_LEVELS. it is set to Y then whole payment request fails if a single payment fails due to any reason |
| Create_pmt_instruction_flag | If it is Y then Create Payment Instruction program is started after Build program completes |
| Payment_Document_Id | foreign key to CE_PAYMENT_DOCUMENTS |
Posts
No comments:
Post a Comment