BI_LINE_EXG_TMP

(SQL Table)
Index Back

Billing India GST table

Table stores the HSN, SAC code and the Reverse Charge Applicability for a Bill Line

# 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 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
4 IDENTIFIER Character(18) VARCHAR2(18) NOT NULL Identifier
5 HSN_CODE Character(10) VARCHAR2(10) NOT NULL HSN Code for GST
6 SAC_CODE Character(10) VARCHAR2(10) NOT NULL SAC Code
7 REV_CHARGE_APPL Character(1) VARCHAR2(1) NOT NULL Reverse Charge Applicability

Default Value: N

8 RPT_PROCESS Character(1) VARCHAR2(1) NOT NULL In process flag

Default Value: N