| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
ORG_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Organization Code. This will be unique to an Organization.
Prompt Table:
ORG_RGSTN_DTL
|
| 3 |
ORG_TAX_LOC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Location Code. An Organization can have multiple Tax Location Codes.
|
| 4 |
EXD_DOC_NBR_SER |
Character(6) |
VARCHAR2(6) NOT NULL |
Excise Document Number Series. Excise Document number series group will be created against each excise transaction type.
|
| 5 |
EXD_REGISTER_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Excise Register Code. This code is unique to the Excise Tax Location and it is issued by the Excise authority
DSA=Daily Stock Account
ICGH=CENVAT Register - CG Onhold
ICGQ=Qty Register - Capital Goods
ICGV=CENVAT Register -Capital Goods
IRMQ=Qty Register - Raw Material
IRMV=CENVAT Register - Raw Material
PLA=Personal Ledger Account
|
| 6 |
EXD_ADJUST_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Adjustment Excise Invoice Nbr
|
| 7 |
EXD_ADJUST_LINE |
Number(3,0) |
SMALLINT NOT NULL |
|
| 8 |
EXD_ADJ_TAX_LN |
Number(3,0) |
SMALLINT NOT NULL |
Adjust Line Tax
|
| 9 |
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
|
| 10 |
EXS_TAX_RATE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Tax Rate Sequence
|
| 11 |
EXS_TAX_CMPNT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Component Code
|
| 12 |
EXS_TAX_DEP_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Dependency Code
|
| 13 |
EXS_CALC_SCHEME |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculation Scheme
A=Amount
P=Percentage
Q=Quantity
|
| 14 |
EXS_TAX_RATE_PCT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Tax Rate Percentage
|
| 15 |
EXS_TXRTAMT_TRC |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Rate Currency
|
| 16 |
EXS_CURRENCY_TRC |
Character(3) |
VARCHAR2(3) NOT NULL |
Curreny Tax Rate
|
| 17 |
EXS_TAX_RATE_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Excise Unit Of Measure
|
| 18 |
EXS_RCVRY_PCT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Tax Percentage
|
| 19 |
EXS_CALC_BASE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculation Base Flag
|
| 20 |
EXS_CALC_FRGHT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculation Freight Flag
|
| 21 |
EXS_CALC_MISC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculation Miscellaneous Flag
|
| 22 |
EXS_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Amount
|
| 23 |
EXS_TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Amount Base Currency
|
| 24 |
EXS_TAX_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Amount Reporting Currency
|
| 25 |
EXS_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Basis Amount
|
| 26 |
EXS_BASIS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Basis Amount Base Currency
|
| 27 |
EXS_BASIS_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Basis Amount Reporting Currency
|
| 28 |
EXS_RCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Recovery Amount
|
| 29 |
EXS_RCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Recovery Amount
|
| 30 |
EXS_RCVRY_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Reporting Recovery Amount
|
| 31 |
EXS_NRCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Non Recovery Amount
|
| 32 |
EXS_NRCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Non Base Recovery Amount
|
| 33 |
EXS_NRCVRY_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Non Recovery Reporting Amount
|
| 34 |
EXS_CURRENCY_RPTG |
Character(3) |
VARCHAR2(3) NOT NULL |
Excise Currency Reporting
|
| 35 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 36 |
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. "
|