Announcement

Collapse
No announcement yet.

OTM Tables effecting in Settlement or Freight Payment

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • OTM Tables effecting in Settlement or Freight Payment

    Hi Folks,
    I hope everyone is doing good.
    I am new to OTM. and I have been workin on Oracle Apps (Finacne).
    Could you please let me know the OTM tables effecting in Settlement of Freight Payment (ie, Invoice and Payment details).

    Appreciate your help.

    Thanks
    Venkata.

  • #2
    Re: OTM Tables effecting in Settlement or Freight Payment

    Invoice and Bill are using the Master INVOICE table and related child tables with INVOICE_TYPE = I (Invoice) or B (Bill).
    Tables for Bills
    INVOICE
    INVOICE_LINEITEM
    INVOICE_INVOLVED_PARTY
    INVOICE_REMARK
    SHIPMENT_BILL
    INVOICE_STOP
    INVOICE_STATUS
    INVOICE_REFNUM
    ORDER_RELEASE_BILL -- BILL LINK TO ORDER RELEASE

    Tables for INVOICE
    INVOICE
    INVOICE_LINEITEM
    INVOICE_INVOLVED_PARTY
    INVOICE_REMARK
    INVOICE_SHIPMENT
    INVOICE_STOP
    INVOICE_STATUS
    INVOICE_REFNUM

    VOUCHER
    JOB

    What i have listed are common tables that i have used before. If your design requires you to use other functionality, i suggest you refer to the data dictionary.

    Good luck

    Regards,
    Dave Lee

    Comment

    Working...
    X