VCHR_LN_GST(SQL Table) |
Index Back |
|---|---|
India GST/* Capture HSN, SAC codes, Revercharge indicator for Voucher line applicable for India GST */ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 3 | VOUCHER_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 4 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 5 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 6 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 7 | EXD_TAX_ITEM_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Tax Item Type
C=Capital Goods F=Finished Goods R=Raw Material S=Service |
| 8 | HSN_CODE | Character(10) | VARCHAR2(10) NOT NULL | HSN Code for GST |
| 9 | SAC_CODE | Character(10) | VARCHAR2(10) NOT NULL | SAC Code |
| 10 | REV_CHARGE_APPL | Character(1) | VARCHAR2(1) NOT NULL |
Reverse Charge Applicability
Y/N Table Edit |
| 11 | RPT_PROCESS | Character(1) | VARCHAR2(1) NOT NULL |
In process flag
Default Value: N |
| 12 | GST_ITM_TAX_APPL | Character(4) | VARCHAR2(4) NOT NULL |
GST Item Tax Applicability
CTP=Composite Taxable Person EXMT=Exempt NGST=Non GST NR=Nil Rate |
| 13 | GST_ITC_ELIG | Character(4) | VARCHAR2(4) NOT NULL |
GST Input Tax Credit Eligibile
CGDS=Capital Goods IE=Ineligible INPT=Inputs INSR=Input Services |