| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 2 |
ORG_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Organization Code. This will be unique to an Organization.
|
| 3 |
ORG_TAX_LOC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Location Code. An Organization can have multiple Tax Location Codes.
|
| 4 |
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
|
| 5 |
EXD_REG_SRL_NO |
Number(10,0) |
DECIMAL(10) NOT NULL |
Excise Register Number
|
| 6 |
EXD_REG_PARTI_SRNO |
Number(10,0) |
DECIMAL(10) NOT NULL |
Register Serial Nos of Part 1
|
| 7 |
EXD_TXN_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Excise Tax Transaction Type. This field will have various translate values for the transaction types.
BOE=Bill of Entry
DEXB=Deemed Export with Bond
DEXP=Deemed Export
DOMR=Domestic Receipt
DOMS=Domestic Sales
EXP=Export without bond
EXPB=Export with bond
IBUS=Inter-Unit Sale
IUT=InterUnit Receipt
MEIN=Manual
STFR=Stock Transfer
|
| 8 |
EXD_ADJUST_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Excise Adjustment Type
CAP=Capital Goods CENVAT
INV=Inventory Adjustments
OTH=Other Transaction
PAD=Price Adjustment Dispatch
PAP=Price Adjustment Purchase
PLA=PLA Register Update
PLD=PLA Register Deposit
PRD=Daily Stock Account
RMA=Return Material Authorization
RTV=Return To Vendor (Supplier)
SUB=SubContracting
|
| 9 |
EXD_INVOICE_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Excise Invoice Number
|
| 10 |
EXD_INV_DATE |
Date(10) |
DATE |
Date Invoice Created
|
| 11 |
EXD_SRC_DOC_NO |
Character(18) |
VARCHAR2(18) NOT NULL |
Excise Source Document
|
| 12 |
EXD_SRC_DOC_DT |
Date(10) |
DATE |
Excise Source Document Date
|
| 13 |
EXD_INVOICE_LINE |
Number(5,0) |
INTEGER NOT NULL |
Excise Invoice Line Number
|
| 14 |
ORG_BU_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Business Unit Type. This field will have six translate values representing the various BUs
AP=Payables
AR=Receivables
BI=Billing
IN=Inventory
OM=Order Management
PO=Purchasing
|
| 15 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 16 |
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.
|
| 17 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
|
| 18 |
BUSINESS_UNIT_RECV |
Character(5) |
VARCHAR2(5) NOT NULL |
Receiving Business Unit
|
| 19 |
RECEIVER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Receiver number
|
| 20 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 21 |
EXD_CHAPTER_ID |
Character(7) |
VARCHAR2(7) NOT NULL |
Excise Chapter ID
|
| 22 |
EXD_DUTY_CREDIT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Opening Balance
|
| 23 |
EXD_DUTY_DEBIT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Opening Balance
|
| 24 |
EXD_OPEN_BALANCE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Opening Balance
|
| 25 |
EXD_CLOSE_BALANCE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Opening Balance
|
| 26 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 27 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 28 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 29 |
EXD_ECC_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
Excise Control Code number. This code is unique to the Excise Tax Location and it is issued by the Excise authority
|
| 30 |
EXD_DIVISION |
Character(20) |
VARCHAR2(20) NOT NULL |
Excise Division. This field defines the Excise Division for a particular Tax Location code. It is used in documents and registers printing.
|
| 31 |
EXD_RANGE |
Character(20) |
VARCHAR2(20) NOT NULL |
Excise Range. This field defines the Excise Range for a particular Tax Location code. It is used in documents and registers printing.
|
| 32 |
REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason Code
|
| 33 |
EXD_TAX_CMPNT1 |
Character(10) |
VARCHAR2(10) NOT NULL |
AED Component Code
|
| 34 |
EXD_CODE_AMT1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
AED Amount
|
| 35 |
EXD_TAX_CMPNT2 |
Character(10) |
VARCHAR2(10) NOT NULL |
BED Componet Code
|
| 36 |
EXD_CODE_AMT2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
BED Amount
|
| 37 |
EXD_TAX_CMPNT3 |
Character(10) |
VARCHAR2(10) NOT NULL |
SED Component Code
|
| 38 |
EXD_CODE_AMT3 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SED Amount
|
| 39 |
EXD_TAX_CMPNT4 |
Character(10) |
VARCHAR2(10) NOT NULL |
CESS Component Code
|
| 40 |
EXD_CODE_AMT4 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise CESS Amount
|
| 41 |
EXD_TAX_CMPNT5 |
Character(10) |
VARCHAR2(10) NOT NULL |
Addl Component Code
|
| 42 |
EXD_CODE_AMT5 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Additional Duty Amount
|
| 43 |
EXD_TAX_CMPNT6 |
Character(10) |
VARCHAR2(10) NOT NULL |
Other Component Code
|
| 44 |
EXD_CODE_AMT6 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Other Duty Amount
|
| 45 |
POSTED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program.
N=Not Posted
X=Don't Post
Y=Posted
|
| 46 |
IN_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
In process flag
|
| 47 |
CREATED_DTTM |
DateTime(26) |
TIMESTAMP |
Created Date and time
|