Invoice Management and General Ledger Accounts: A Comprehensive

School: University of Phoenix - Course: EXCEL WO - Subject: Accounting

S420_1587_MILANK1.INVOICES * INVOICE_ID NUMBER ENDOR NUMBER * INVOICE_NUMBER VARCHAR2 (50 BYTE) * INVOICE_DATE DATE * INVOICE TOTAL NUMBER (9,2) PAYMENT_TOTAL NUMBER (9,2) IS420_1587_MILANK1.GENERAL_LEDGER_ACCOUNTS CREDIT_TOTAL NUMBER (9,2) P * ACCOUNT NUMBER NUMBER * TERMS ID NUMBER U * ACCOUNT DESCRIPTION VARCHAR2 (50 BYTE) * INVOICE_DUE_DATE DATE GL_ACCOUNTS_PK (ACCOUNT_NUMBER) PAYMENT_DATE DATE GL_ACCOUNT_DESCRIPTION_UQ (ACCOUNT_DESCRIPTION) INVOICES_PK (INVOICE_ID) GL_ACCOUNTS_PK (ACCOUNT_NUMBER) INVOICES_INVOICE_DATE_IX (INVOICE_DATE) GL_ACCOUNT_DESCRIPTION_UQ (ACCOUNT_DESCRIPTION) INVOICES_PK (INVOICE_ID) $420_1587_MILANK1.INVOICE_LINE_ITEMS PF * INVOICE ID NUMBER * INVOICE_SEQUENCE NUMBER * ACCOUNT_NUMBER NUMBER IS420_1587_MILANK1.VENDORS * LINE_ITEM_AMT NUMBER (9,2) P * VENDOR_ID NUMBER * LINE_ITEM_DESCRIPTION VARCHAR2 (100 BYTE) U * VENDOR_NAME VARCHAR2 (50 BYTE) LINE_ITEMS_PK (INVOICE_ID, INVOICE_SEQUENCE) VENDOR_ADDRESS1 VARCHAR2 (50 BYTE) VENDOR ADDRESS2 VARCHAR2 (50 BYTE) LINE_ITEMS_FK_ACOUNTS (ACCOUNT_NUMBER) * VENDOR_CITY VARCHAR2 (50 BYTE) LINE_ITEMS_FK_INVOICES (INVOICE_ID) * VENDOR_STATE CHAR (2 BYTE) LINE_ITEMS_ACCOUNT_NUMBER_IX (ACCOUNT_NUMBER) * VENDOR ZIP CODE VARCHAR2 (20 BYTE) LINE_ITEMS_PK (INVOICE_ID, INVOICE_SEQUENCE) VENDOR PHONE VARCHAR2 (50 BYTE) VENDOR_CONTACT_LAST_NAME VARCHAR2 (50 BYTE) VENDOR_CONTACT_FIRST_NAME VARCHAR2 (50 BYTE) * DEFAULT_TERMS_ID NUMBER * DEFAULT_ACCOUNT_NUMBER NUMBER VENDORS_PK (VENDOR_ID VENDORS_VENDOR_NAME_UQ (VENDOR_NAME) VENDORS_FK_ACCOUNTS (DEFAULT_ACCOUNT_NUMBER) VENDORS_FK_TERMS (DEFAULT_TERMS_ID) VENDORS_ACCOUNT_NUMBER_IX (DEFAULT_ACCOUNT_NUMBER) VENDORS_PK (VENDOR_ID) VENDORS_TERMS_ID_IX (DEFAULT_TERMS_ID) Relational 1