INVOICE_BATCH
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 | Â | Â |
Â
Â