| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 3 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 4 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
|
| 5 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
|
| 6 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 7 |
MISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc. Amount
|
| 8 |
ORG_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Organization SetID.
|
| 9 |
ORG_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Organization Code. This will be unique to an Organization.
|
| 10 |
ORG_TAX_LOC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Location Code. An Organization can have multiple Tax Location Codes.
|
| 11 |
EXS_TAX_TXN_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Tax Transaction Type. This field will be used in the Tax determination and calculation of taxes.
DEB=Direct Export With Bond
DEWB=Direct Export Without Bond
DIMP=Direct Import
DOM=Domestic
LEB=Local Export With Bond
LEWB=Local Export Without Bond
LIMP=Local Import
|
| 12 |
EXS_TAX_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Type
C=Custom Duty
E=Excise Duty
G=Goods and Services Tax
S=Sales Tax / VAT
|
| 13 |
EXS_TAX_RATE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Tax Rate Sequence
|
| 14 |
STX_TPRTNR_CATG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Trading Partner Tax Cat
|
| 15 |
EXD_TPRTNR_CATG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Trading Partner Excise Cat
|
| 16 |
STX_ITM_CATG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales Item Category Code
|
| 17 |
EXD_ITM_CATG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Excise Item Category Code
|
| 18 |
EXD_TAX_ITEM_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Tax Item Type
C=Capital Goods
F=Finished Goods
R=Raw Material
S=Service
|
| 19 |
EXD_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Excise Applicablity Flag. This field is used to indicate the applicability of Excise duty with respect to a vendor, customer, item or product. It will have Yes or No values.
|
| 20 |
EXD_TAX_RATE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Excise Tax Calculation Code
|
| 21 |
EXD_CONVERSION_RT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Conversion Rate
|
| 22 |
STX_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Tax Applicability.
|
| 23 |
STX_TAX_RATE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales Tax Calculation Code
|
| 24 |
STX_TAX_AUTH_RATE |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Authority Rate (India Sales Tax)
|
| 25 |
STX_TAX_AUTH_RPT |
Character(8) |
VARCHAR2(8) NOT NULL |
Reporting Authority (India Sales Tax)
|
| 26 |
EXS_USE_AV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Assessable Flag
|
| 27 |
EXD_ASSESS_VALUE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Assessable Value
|
| 28 |
STX_FORM_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Form Code
|
| 29 |
EXS_SERV_TAX_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Service Tax Indicator
N=Not Service Tax
Y=Service Tax
|
| 30 |
RATE_MULT_EXS |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Excise Rt Multiplier
|
| 31 |
RATE_DIV_EXS |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Excise Rt Divider
|
| 32 |
EXS_CURRENCY_RPTG |
Character(3) |
VARCHAR2(3) NOT NULL |
Excise Currency Reporting
|
| 33 |
EXD_ASSESS_AMT_TXN |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Assessable Value - Transaction
|
| 34 |
EXD_ASSESS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Assessable Value - Base
|
| 35 |
EXD_ASSESS_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Assessable Value - Reporting
|
| 36 |
EXS_CALC_BASE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculation Base Flag
|
| 37 |
EXS_CALC_FRGHT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculation Freight Flag
|
| 38 |
EXS_CALC_MISC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculation Miscellaneous Flag
|
| 39 |
EXS_TAXRT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Rate Amount
|
| 40 |
EXS_TAXRT_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Rate Amount
|
| 41 |
EXS_TAXRT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Rate Amount
|
| 42 |
EXD_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Tax Amount
|
| 43 |
EXD_TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Duty in Base Currency
|
| 44 |
EXD_TAX_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Duty Amt In Rpt Curr
|
| 45 |
EXD_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Basis Amt
|
| 46 |
EXD_BASIS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Basis Amount - Base
|
| 47 |
EXD_BASIS_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Basis Amount
|
| 48 |
EXD_RCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Recovery Amount
|
| 49 |
EXD_RCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Recovery Amount
|
| 50 |
EXD_RCVRY_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Recovery Amount
|
| 51 |
EXD_NRCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise NonRcvry Amount
|
| 52 |
EXD_NRCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Non Recovery
|
| 53 |
EXD_NRCVRY_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Non-Recovery
|
| 54 |
EXD_CHAPTER_ID |
Character(7) |
VARCHAR2(7) NOT NULL |
Excise Chapter ID
|
| 55 |
STX_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 56 |
STX_TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SALES TAX IN BASE CURR
|
| 57 |
STX_TAX_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SALES TAX IN REPORT CURR
|
| 58 |
STX_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Basis Amount
|
| 59 |
STX_BASIS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Basis Amt in Base Curr
|
| 60 |
STX_BASIS_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Basis Amt in Rpt Curr
|
| 61 |
STX_RCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Recovery Amount
|
| 62 |
STX_RCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Recovery Amt in Base Curr
|
| 63 |
STX_RCVRY_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Recovery Amt in Rpt Curr
|
| 64 |
STX_NRCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Nonrecovery
|
| 65 |
STX_NRCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tx Amt NonRecovery in Bse Curr
|
| 66 |
STX_NRCVRY_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax NonRecovery
|
| 67 |
EXS_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Amount
|
| 68 |
EXS_TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Amount Base Currency
|
| 69 |
EXS_TAX_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Amount Reporting Currency
|
| 70 |
EXS_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Basis Amount
|
| 71 |
EXS_BASIS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Basis Amount Base Currency
|
| 72 |
EXS_BASIS_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Basis Amount Reporting Currency
|
| 73 |
EXS_RCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Recovery Amount
|
| 74 |
EXS_RCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Recovery Amount
|
| 75 |
EXS_RCVRY_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Reporting Recovery Amount
|
| 76 |
EXS_NRCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Non Recovery Amount
|
| 77 |
EXS_NRCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Non Base Recovery Amount
|
| 78 |
EXS_NRCVRY_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Non Recovery Reporting Amount
|
| 79 |
MERCHANDISE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amt
F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
|
| 80 |
MERCH_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Merchandise Amount
|
| 81 |
TTL_MERCH_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amount
|
| 82 |
DST_ACCT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
07/20/04 st: added RCN for Advance Reconciliation
02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement
11/11/99 llr: Added ADVP for Payables Advance Payment
|
| 83 |
LC_EXTRCT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Landed Cost Extract Status
|
| 84 |
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. "
|
| 85 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 86 |
APPLY_TO_ALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply to All
D=Apply All at Discount
G=Apply All at Gross
I=Apply Individually
N=Do Not Apply Any
|
| 87 |
EXD_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Excise Unit Of Measure
|
| 88 |
HSN_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
HSN Code for GST
|
| 89 |
SAC_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
SAC Code
|
| 90 |
REVERSE_CHARGE_GST |
Character(1) |
VARCHAR2(1) NOT NULL |
Reverse Charge Applicable Flag
|
| 91 |
EXS_TAX_CMPNT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Component Code
|
| 92 |
ITC_SGST_AVAILED |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SGST Availed
|
| 93 |
ITC_SGST_AVAIL_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SGST Availed BSE
|
| 94 |
ITC_CGST_AVAILED |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
CGST Availed
|
| 95 |
ITC_CGST_AVAIL_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
CGST Availed BSE
|
| 96 |
ITC_IGST_AVAILED |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
IGST Availed
|
| 97 |
ITC_IGST_AVAIL_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
IGST Availed BSE
|
| 98 |
ITC_CESS_AVAILED |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
GSTCess Availed
|
| 99 |
ITC_CESS_AVAIL_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
GSTCess Availed BSE
|
| 100 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 101 |
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
|
| 102 |
GST_ITC_ELIG |
Character(4) |
VARCHAR2(4) NOT NULL |
GST Input Tax Credit Eligibile
CGDS=Capital Goods
IE=Ineligible
INPT=Inputs
INSR=Input Services
|
| 103 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 104 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 105 |
ITC_SUPINV_IRN |
Character(64) |
VARCHAR2(64) NOT NULL |
IRN
|
| 106 |
GST_IRP_DT |
DateTime(26) |
TIMESTAMP |
IRP Date
|
| 107 |
INV_DOC_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Document Reference
|
| 108 |
CNTRCT_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Contract Reference Number
|
| 109 |
PRECEED_INV_ID |
Character(64) |
VARCHAR2(64) NOT NULL |
Preceding IRN
|
| 110 |
PRECEED_INV_DT |
DateTime(26) |
TIMESTAMP |
Preceding IRP Date
|
| 111 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 112 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|