Groups
INVOICE_PAYMENTS
Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
1 | ID | NUMBER | 22 | N |
| Primary key |
2 | INVOICE_ID | NUMBER | 22 | Y |
| Reference to INVOICE |
3 | PAYMENT_DATE | DATE | 7 | Y |
|
|
4 | PAYMENT_SOURCE | VARCHAR2 | 100 | Y |
|
|
5 | AMOUNT_PAYED | NUMBER | 22 | Y |
|
|
6 | REFERENCE | VARCHAR2 | 100 | Y |
|
|
7 | BALANCING_OBJECT_ID | NUMBER | 22 | Y |
| Reference to ACCOUNT_PAYMENT (and others) |
8 | PAYMENT_TYPE_ID | NUMBER | 22 | Y |
|
|
Contains all payments of Invoices