CCB Table | Columns | Data Type | Description | EBS Table | Columns | Data Type | Remarks |
|---|---|---|---|---|---|---|---|
CI_ADJ_APREQ | PAY_DOC_ID | VARCHAR2 (20) | Advice ID | AP_CHECKS_ALL | CHECK_ID | NUMBER (15) | |
CI_ADJ_APREQ | PAY_DOC_DT | DATE | Advice Date | AP_CHECKS_ALL | CHECK_DATE | DATE | |
CI_ADJ_APREQ | PYMNT_ID | CHAR (10) | Payment Number | AP_CHECKS_ALL | CHECK_NUMBER | NUMBER (15) | |
CI_ADJ_APREQ | PAID_AMT | NUMBER (15,2) | Paid Amount | AP_CHECKS_ALL | AMOUNT | NUMBER | |
CI_ADJ_APREQ | PYMNT_SEL_STAT_FLG | CHAR (1) | Payment Selections Status | Derived from BPEL. Value = ‘P’ (For valid Payment) Value =’C’ (For Void hold or Initiate stop) And Value =’X’ (For Void Cancel) | |||
CI_ADJ_APREQ | AP_REQ_ID | CHAR (12) | AP Request ID | AP_INVOICES_ALL | PAYMENT_REASON_COMMENTS | VARCHAR2 (240) | |
CI_ADJ_APREQ | ADJ_ID | CHAR (12) | Adjustment ID | AP_INVOICES_ALL | INVOICE_NUM | VARCHAR2 (50) | If liability is closed the ‘Adjustment Maintenance’ service is invoked for this Adjustment ID. |
CI_ADJ_APREQ | PYMNT_SEL_STAT_FLG | CHAR (1) | Payment Selections Status | Derived from BPEL. When AP_CHECKS_ALL.STOPPED_DATE IS NOT NULL or AP_CHECKS_ALL. VOID_DATE IS NOT NULL then Value=’C’ When AP_INVOICES_ALL.CANCELLED_DATE IS NOT NULL then Value=’X’ | |||
CI_ADJ | CAN_RSN_CD | CHAR (4) | Cancel Reason Code | APVC | |||