BI_HDR_GST(SQL Table) |
Index Back |
---|---|
Billing Header GST |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_BI_NONVW |
2 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL |
Invoice
Default Value: NEXT |
3 | VERSION_CHAR | Character(10) | VARCHAR2(10) NOT NULL |
Version
Default Value: BI_GST_EINV_LMT.VERSION_CHAR |
4 | IRN | Character(64) | VARCHAR2(64) NOT NULL | Invoice Reference Number |
5 | IRP_DATE | DateTime(26) | TIMESTAMP | IRP Date |
6 | TPR_TYPE | Character(30) | VARCHAR2(30) NOT NULL |
Trading Partner type
Prompt Table: BI_TPR_TYPE_VW |
7 | GST_TXN_CATG | Character(30) | VARCHAR2(30) NOT NULL |
GST Transaction Category
Prompt Table: BI_TXN_CAT_VW |
8 | GST_DOC_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
GST Document Type
CRN=Credit Note DBN=Debit Note INV=Regular Invoice |
9 | REV_CHARGE_APPL | Character(1) | VARCHAR2(1) NOT NULL |
Reverse Charge Applicability
Y/N Table Edit Default Value: N |
10 | 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 |
11 | QR_CODE | Long Character | CLOB | QR Code |
12 | STATUS1 | Character(30) | VARCHAR2(30) NOT NULL | Status |
13 | STATUS2 | Character(30) | VARCHAR2(30) NOT NULL | Status |
14 | STATUS3 | Character(30) | VARCHAR2(30) NOT NULL | Status |
15 | ERROR_LABEL | Character(100) | VARCHAR2(100) NOT NULL | Error Label |
16 | ERROR_MSG_TXT | Long Character(1000) | VARCHAR2(1000) | Error Message |
17 | ACK_NUM | Character(20) | VARCHAR2(20) NOT NULL | Field to store Acknowledgement Number |
18 | METAVALUE | Character(254) | VARCHAR2(254) NOT NULL | Meta Parm Value |
19 | CANCEL_DATE | Date(10) | DATE | Cancel Date |
20 | POS_NUMERIC_CD | Character(2) | VARCHAR2(2) NOT NULL | Numeric Code |