| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
EXD_REG_SRL_NO |
Number(10,0) |
DECIMAL(10) NOT NULL |
Excise Register Number
|
| 3 |
EXD_REG_PARTI_SRNO |
Number(10,0) |
DECIMAL(10) NOT NULL |
Register Serial Nos of Part 1
|
| 4 |
PARENT_PROD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Parent Product Id
|
| 5 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 6 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 7 |
KIT_LINE_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Kit Line Number
|
| 8 |
KIT_QTY |
Number(3,0) |
SMALLINT NOT NULL |
Quantity
|
| 9 |
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
|
| 10 |
EXD_TAX_ITEM_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Tax Item Type
C=Capital Goods
F=Finished Goods
R=Raw Material
S=Service
|
| 11 |
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
|
| 12 |
EXD_INVOICE_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Excise Invoice Number
|
| 13 |
EXD_INV_DATE |
Date(10) |
DATE |
Date Invoice Created
|
| 14 |
EXD_SRC_DOC_NO |
Character(18) |
VARCHAR2(18) NOT NULL |
Excise Source Document
|
| 15 |
EXD_SRC_DOC_DT |
Date(10) |
DATE |
Excise Source Document Date
|
| 16 |
EXD_INVOICE_LINE |
Number(5,0) |
INTEGER NOT NULL |
Excise Invoice Line Number
|
| 17 |
EXD_CHAPTER_ID |
Character(7) |
VARCHAR2(7) NOT NULL |
Excise Chapter ID
|
| 18 |
EXD_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Excise Unit Of Measure
|
| 19 |
EXD_OPEN_BALANCE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Opening Balance
|
| 20 |
EXD_CLOSE_BALANCE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Opening Balance
|
| 21 |
EXD_DISP_QTY |
Signed Number(29,4) |
DECIMAL(27,4) NOT NULL |
Display Quantity
|
| 22 |
EXD_DISP_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Amount
|
| 23 |
EXD_DISP_DUTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Amount
|
| 24 |
EXD_TOTAL_STOCK |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Total Stock
|
| 25 |
EXD_OTH_RECEIPTS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Other Receipts
|
| 26 |
TOT_EXD_AMT_RPT |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Total Exc Tax in Rpt Curr
|
| 27 |
EXD_CODE_AMT1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
AED Amount
|
| 28 |
EXD_CODE_AMT2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
BED Amount
|
| 29 |
EXD_CODE_AMT3 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SED Amount
|
| 30 |
EXD_CODE_AMT4 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise CESS Amount
|
| 31 |
EXD_CODE_AMT5 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Additional Duty Amount
|
| 32 |
EXD_CODE_AMT6 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Other Duty Amount
|
| 33 |
EXD_TOT_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Tax Amount
|
| 34 |
EXD_CODE_RATE1 |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
AED Rate
|
| 35 |
EXD_CODE_RATE2 |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
BED Rate
|
| 36 |
EXD_CODE_RATE3 |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
SED Rate
|
| 37 |
EXD_CODE_RATE4 |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Excise CESS Rate
|
| 38 |
EXD_CODE_RATE5 |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Additional Duty Rate
|
| 39 |
EXD_CODE_RATE6 |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Other Duty Rate
|
| 40 |
EXD_REG_COL_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Register Column Sequence
1=Column1
2=Column2
3=Column3
4=Column4
5=Column5
6=Column6
|
| 41 |
EXD_TAX_CMPNT1 |
Character(10) |
VARCHAR2(10) NOT NULL |
AED Component Code
|
| 42 |
EXD_TAX_CMPNT2 |
Character(10) |
VARCHAR2(10) NOT NULL |
BED Componet Code
|
| 43 |
EXD_TAX_CMPNT3 |
Character(10) |
VARCHAR2(10) NOT NULL |
SED Component Code
|
| 44 |
EXD_TAX_CMPNT4 |
Character(10) |
VARCHAR2(10) NOT NULL |
CESS Component Code
|
| 45 |
EXD_TAX_CMPNT5 |
Character(10) |
VARCHAR2(10) NOT NULL |
Addl Component Code
|
| 46 |
EXD_TAX_CMPNT6 |
Character(10) |
VARCHAR2(10) NOT NULL |
Other Component Code
|
| 47 |
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
|
| 48 |
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
|
| 49 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
|
| 50 |
BUSINESS_UNIT_RECV |
Character(5) |
VARCHAR2(5) NOT NULL |
Receiving Business Unit
|
| 51 |
RECEIVER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Receiver number
|
| 52 |
QTY_SH_ACCPT_SUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Accepted Quantity
|
| 53 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 54 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 55 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 56 |
QTY_EXD |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Excise Quantity
|
| 57 |
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
|
| 58 |
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.
|
| 59 |
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.
|
| 60 |
EXD_RCVRY_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Recovery Amount
|
| 61 |
EXD_NRCVRY_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Non-Recovery
|
| 62 |
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
|
| 63 |
POST_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a group of pending items is ready to be processed by the Receivable Update program. The "action" requested can be no action, priority scheduled or standard scheduled.
A=Do Not Post
B=Balance Only Now
D=Delete This Group Now
E=Delete ALL Accounting Entries
G=Generate GL Distribution
I=Balance and Post Later
L=Batch Standard
N=Batch Priority
V=View
|
| 64 |
POST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a control group of pending items has been fully posted to customer accounts. The posting status also indicates whether or not there were errors encountered during posting. This field is automatically populated by the Receivables Update program.
%=All
C=Complete
E=Errors
N=Not Posted
|
| 65 |
QTY_SHIP_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Ship Base
|
| 66 |
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
|