ap data model
TRANSCRIPT
Important Transaction Tables AP_INVOICES_ALL AP_INVOICE_DSITRIBUTIONS_ALL AP_PAYMENT_SCHEDULES_ALL AP_INVOICE_PAYMENTS_ALL AP_PAYMENT_HISTORY_ALL AP_CHECKS_ALL Important Accounting Tables AP_ACCOUNTING_EVENTS_ALL AP_AE_HEADERS_ALL AP_AE_LINES_ALL Important Interface Tables AP_INVOICES_INTERFACE AP_INVOICE_LINES_INTERFACE AP_SUPPLIERS_INT AP_SUPPLIER_SITES_INT
AP_INVOICES_ALL (Important Columns) INVOICE_ID (pk) VENDOR_ID INVOICE_NUM SET_OF_BOOKS_ID INVOICE_CURRENCY_CODE PAYMENT_CURRENCY_CODE INVOICE_AMOUNT VENDOR_SITE_ID AMOUNT_PAID INVOICE_DATE INVOICE_TYPE_LOOKUP_CODE PAYMENT_STATUS_FLAG GL_DATE EXCHANGE_RATE ORG_ID
AP_INVOICE_DISTRIBUTIONS_ALL (Important Columns) INVOICE_DISTRIBUTION_ID (pk) INVOICE_ID DIST_CODE_COMBINATION_ID DISTRIBUTION_LINE_NUMBER LINE_TYPE_LOOKUP_CODE PERIOD_NAME SET_OF_BOOKS_ID ACCRUAL_POSTED_FLAG EXCHANGE_RATE ORG_ID
AP_PAYMENT_SCHEDULES_ALL (Important Columns) INVOICE_ID (pk) PAYMENT_NUM (pk) AMOUNT_REMAINING DUE_DATE ORG_ID
AP_INVOICE_PAYMENTS_ALL (Important Columns) INVOICE_PAYMENT_ID (pk) INVOICE_ID CHECK_ID ACCOUNTING_EVENT_ID ACCOUNTING_DATE PAYMENT_NUM PERIOD_NAME SET_OF_BOOKS_ID EXCHANGE_RATE ORG_ID REVERSAL_FLAG ACCOUNTING_EVENT_ID
AP_PAYMENT_HISTORY_ALL (Important Columns) PAYMENT_HISTORY_ID (pk) CHECK_ID ACCOUNTING_DATE TRANSACTION_TYPE ORG_ID ACCOUNTING_EVENT_ID PMT_CURRENCY_CODE TRX_PMT_AMOUNT
AP_CHECKS_ALL (Important Columns) CHECK_ID (pk) AMOUNT BANK_ACCOUNT_ID BANK_ACCOUNT_NAME CHECK_DATE CHECK_NUMBER CURRENCY_CODE PAYMENT_METHOD_LOOKUP_CODE VENDOR_NAME VENDOR_SITE_CODE ORG_ID EXCHANGE_RATE
AP_ACCOUNTING_EVENTS_ALL (Important Columns) ACCOUNTING_EVENT_ID (pk) EVENT_TYPE_CODE ACCOUNTING_DATE EVENT_NUMBER EVENT_STATUS_CODE SOURCE_TABLE SOURCE_ID ORG_ID
AP_AE_HEADERS_ALL (Important Columns) AE_HEADER_ID (pk) ACCOUNTING_EVENT_ID SET_OF_BOOKS_ID AE_CATEGORY PERIOD_NAME ACCOUNTING_DATE GL_TRANSFER_FLAG ORG_ID
AP_AE_LINES_ALL (Important Columns) AE_LINE_ID AE_HEADER_ID AE_LINE_NUMBER CODE_COMBINATION_ID CURRENCY_CODE ACCOUNTED_DR ACCOUNTED_CR SOURCE_TABLE SOURCE_ID ORG_ID
AP_INVOICES_INTERFACE (Important Columns) INVOICE_ID INVOICE_NUM INVOICE_TYPE_LOOKUP_CODE INVOICE_DATE VENDOR_ID VENDOR_SITE_CODE INVOICE_AMOUNT INVOICE_CURRENCY_CODE TERMS_ID SOURCE PAYMENT_CURRENCY_CODE GL_DATE ORG_ID
AP_INVOICE_LINES_INTERFACE (Important Columns) INVOICE_ID LINE_NUMBER LINE_TYPE_LOOKUP_CODE AMOUNT ACCOUNTING_DATE DIST_CODE_COMBINATION_ID ORG_ID
AP_SUPPLIERS_INT (Important Columns) VENDOR_INTERFACE_ID VENDOR_NAME SEGMENT1 VENDOR_NAME_ALT ENABLED_FLAG VENDOR_TYPE_LOOKUP_CODE TERMS_ID SET_OF_BOOKS_ID PREPAY_CODE_COMBINATION_ID START_DATE_ACTIVE END_DATE_ACTIVE STATUS REJECT_CODE
AP_SUPPLIERS_SITES_INT (Important Columns) VENDOR_INTERFACE_ID VENDOR_ID VENDOR_SITE_CODE PURCHASING_SITE_FLAG RFQ_ONLY_SITE_FLAG PAY_SITE_FLAG ADDRESS_LINE1 ADDRESS_LINE2 ADDRESS_LINE3 PREPAY_CODE_COMBINATION_ID TERMS_ID ORG_ID STATUS REJECT_CODE
Transaction Data Model
AP_INVOICES_ALLINVOICE_ID
1 to many
1 to many
AP_INVOICE_DISTRIBUTIONS_ALLINVOICE_ID
AP_INVOICE_PAYMENTS_ALLINVOICE_ID CHECK_ID
1 to many 1 to many AP_PAYMENT_SCHEDULES_ALLINVOICE_ID
AP_CHECKS_ALLCHECK_ID
1 to many
AP_PAYMENT_HISTORYCHECK_ID
Accounting Data Model
AP_ACCOUNTING_EVENTS_ALLACCOUNTING_EVENT_ID
1 to many AP_AE_HEADERS_ALLACCOUNTING_EVENT_ID AE_HEADER_ID
1 to many
AP_AE_LINES_ALLAE_HEADER_ID AE_LINE_ID
Invoices Interface Data Model
AP_INVOICES_INTERFACEINVOICE_ID
1 to many
AP_INVOICE_LINES_INTERFACEINVOICE_ID
Supplier Interface Data Model
AP_SUPPLIER_INTVENDOR_ID
1 to many AP_SUPPLIER_SITE_INTVENDOR_ID VENDOR_SITE_ID