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