BUSINESS_UNITINVOICESEQ_NUM0=Success
1=Fail
N=No
Y=Yes
Default Value: Y
N=No
Y=Yes
Default Value: N
BI_EMAIL_LOG(SQL Table) |
Index Back |
|---|---|
Email Invoice Delivery LogAs invoices are emailed, the results will be tracked in this table. Rows in this table are populated by the BI_EMAILIVC App Engine program. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INVOICE |
Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 5 | INVALID_EMAILID | Character(70) | VARCHAR2(70) NOT NULL | Invalid Email address |
| 6 | EMAIL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status of an email transmission.
0=Success 1=Fail |
| 7 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 8 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 9 | PRIMARY_IVC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
A "Y" means primary invoice. An "N" means a courtesy copy invoice.
N=No Y=Yes Default Value: Y |
| 10 | RESEND_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Resend Invoice
N=No Y=Yes Default Value: N |
| 11 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 12 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |
| 13 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |