INVOICEC=Credit after Cut-Off Time
E=Excluded from E-Invoicing
I=In Process
L=Login Credentials Issue
M=Manual Upload
N=Not Processed
R=Retry
X=Rejected
Y=Completed
Z=Other Error or Multiple Errors
BI_HDR_GST_STG(SQL Table) |
Index Back |
|---|---|
Billing Header GST Staging Rec |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INVOICE |
Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 2 | STATUS1 | Character(30) | VARCHAR2(30) NOT NULL | Status |
| 3 | STATUS2 | Character(30) | VARCHAR2(30) NOT NULL | Status |
| 4 | STATUS3 | Character(30) | VARCHAR2(30) NOT NULL | Status |
| 5 | ERROR_LABEL | Character(100) | VARCHAR2(100) NOT NULL | Error Label |
| 6 | ERROR_MSG_TXT | Long Character(1000) | VARCHAR2(1000) | Error Message |
| 7 | ACK_NUM | Character(20) | VARCHAR2(20) NOT NULL | Field to store Acknowledgement Number |
| 8 | IRP_DATE | DateTime(26) | TIMESTAMP | IRP Date |
| 9 | IRN | Character(64) | VARCHAR2(64) NOT NULL | Invoice Reference Number |
| 10 | METAVALUE | Character(254) | VARCHAR2(254) NOT NULL | Meta Parm Value |
| 11 | QR_CODE | Long Character | CLOB | QR Code |
| 12 | CANCEL_DATE | Date(10) | DATE | Cancel Date |
| 13 | EINV_PROC_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
E-Invoice Processing Flag
C=Credit after Cut-Off Time E=Excluded from E-Invoicing I=In Process L=Login Credentials Issue M=Manual Upload N=Not Processed R=Retry X=Rejected Y=Completed Z=Other Error or Multiple Errors |