Oracle EBS

AR Table 관련

자세는프론데 2023. 6. 16. 17:20
반응형
모듈명 제목 내용
AR TRX AR Transaction Interface select * from

AR Transaction SELECT *
FROM   ra_customer_trx_all
WHERE  1 = 1
AND    trx_number = 70006662;

AR Transaction Line SELECT *
FROM   ra_customer_trx_lines_all
WHERE  1 = 1
AND    customer_trx_id = 1913008;

AR Transaction sales person SELECT *
FROM   ra_cust_trx_line_salesreps_all
WHERE  1 = 1
AND    customer_trx_id = 1913008;

AR Transaction Distribution SELECT *
FROM   ra_cust_trx_line_gl_dist_all
WHERE  1 = 1
AND    customer_trx_id = 1913008;

AR Payment Schedule SELECT *
FROM   ar_payment_schedules_all
WHERE  1 = 1
AND    customer_trx_id = 1913008;
AR RCP AR Receipt SELECT *
FROM   ar_cash_receipts_all
WHERE  1 = 1
and receipt_number = 'Invoice번호';

AR Receipt History SELECT *
FROM   ar_cash_receipt_history_all
WHERE  1 = 1
and cash_receipt_id = 1203015;

AR Receivable Applications
반제처리 내역		 SELECT *
FROM   ar_receivable_applications_all
WHERE  1 = 1
and cash_receipt_id = 1203015;
반응형