BI_LINE_EXG_TMP(SQL Table) |
Index Back |
---|---|
Billing India GST tableTable 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 |