| # |
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_STYLE |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
TMPL=Template Voucher
|
| 4 |
ITC_SUPINV_IRN |
Character(64) |
VARCHAR2(64) NOT NULL |
IRN
|
| 5 |
GST_IRP_DT |
DateTime(26) |
TIMESTAMP |
IRP Date
|
| 6 |
TPR_TYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Trading Partner type
Prompt Table:
%EDITTABLE4
|
| 7 |
INV_DOC_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Document Reference
|
| 8 |
CNTRCT_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Contract Reference Number
|
| 9 |
GST_TXN_CATG |
Character(30) |
VARCHAR2(30) NOT NULL |
GST Transaction Category
Prompt Table:
%EDITTABLE5
|
| 10 |
GST_DOC_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
GST Document Type
CRN=Credit Note
DBN=Debit Note
INV=Regular Invoice
|
| 11 |
GST_IMPORT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
GST Import Type
|
| 12 |
PRECEED_INV_ID |
Character(64) |
VARCHAR2(64) NOT NULL |
Preceding IRN
|
| 13 |
PRECEED_INV_DT |
DateTime(26) |
TIMESTAMP |
Preceding IRP Date
|
| 14 |
GST_IRN_APPL |
Character(1) |
VARCHAR2(1) NOT NULL |
GST IRN Applicability
Y/N Table Edit
Default Value: N
|
| 15 |
GST_IRN_MAND |
Character(1) |
VARCHAR2(1) NOT NULL |
IRN Mandatory
Y/N Table Edit
Default Value: N
|
| 16 |
ITC_CGST_AVAILED |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
CGST Availed
Default Value: 0
|
| 17 |
ITC_SGST_AVAILED |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SGST Availed
Default Value: 0
|
| 18 |
ITC_IGST_AVAILED |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
IGST Availed
Default Value: 0
|
| 19 |
ITC_CESS_AVAILED |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
GSTCess Availed
Default Value: 0
|
| 20 |
ITC_CGST_AVAIL_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
CGST Availed BSE
Default Value: 0
|
| 21 |
ITC_SGST_AVAIL_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SGST Availed BSE
Default Value: 0
|
| 22 |
ITC_IGST_AVAIL_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
IGST Availed BSE
Default Value: 0
|
| 23 |
ITC_CESS_AVAIL_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
GSTCess Availed BSE
Default Value: 0
|
| 24 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 25 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
|