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
Expert's Answer
Chat with our Experts
Want to contact us directly? No Problem. We are always here for you
Your future, our responsibilty submit your task on time.
Order NowGet Online
Assignment Help Services