Payment terms table in oracle apps
Payment terms we uses in Oracle Applications Payables and receivables Modules. When We enter some Supplier Invoice in our Oracle Applications , Then we must need to enter the Payment Terms for the invoice. This payment Terms help to identify the Due Date of the Payment for this Invoice. This Helps to identify the Organization , when the Supplier Invoice are getting Due's for the Invoice. In the Same Way , We also enter the Payment terms to the Customer Invoices , When we sent invoices to our customer , then we also given the Payment Terms to identify our Customers, When the Payment for this Invoice will be paid. Before using the Payment Terms , We must need to create the Payment Terms first. These Payment Terms Master Information stores in the Payment Terms table in Oracle Apps. Payment Terms information stores in two tables. These two tables are Header and Details Table in Oracle apps.
Payables Payment Terms Table in Oracle Apps
AP_TERMS
AP_TERM_LINES
Receivables Payment Terms Table in Oracle Apps
RA_TERMS
RA_TERM_LINES
select * from ra_terms a1,ra_term_lines a2
where a1.term_id=a2.term_id
These Tables stores Headers and Lines information of the Payment terms Table.
2 comments:
Thank you very much for sharing valuable article with full information that benefits to the students to select best course go on keep rock. Oracle Fusion Cloud Financials Training
The second two tables are, in my instance, "_TERMS_LINES" not "_TERM_LINES". Otherwise aligned and this was helpful, thanks!
Post a Comment