Groups
INVOICE_BATCH
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | INVOICE_SCHEDULE_ID | NUMBER | 22 | Y | ||
| 3 | BATCH_ID | NUMBER | 22 | Y | ||
| 4 | CREATE_DATE | DATE | 7 | Y | ||
| 5 | CREATED_BY | VARCHAR2 | 800 | Y | ||
| 6 | DUE_DATE | DATE | 7 | Y | ||
| 7 | CLOSE_DATE | DATE | 7 | Y | ||
| 8 | STATUS_ID | VARCHAR2 | 8 | Y | ||
| 9 | FILE_NAME | VARCHAR2 | 2000 | Y | ||
| 10 | NUMBER_OF_INVOICES | NUMBER | 22 | Y | ||
| 11 | INVOICE_PAPER | NUMBER | 22 | Y | ||
| 12 | INVOICE_EMAIL | NUMBER | 22 | Y |