EXD_DRILL_GL_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
3	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
4	JOURNAL_LINE	Number(9,0)	DECIMAL(9) NOT NULL	Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
5	BUSINESS_UNIT_TXN	Character(5)	VARCHAR2(5) NOT NULL	Transaction Business Unit
6	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
8	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
9	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
10	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
11	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
12	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
13	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
14	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
15	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
16	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
17	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
18	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
19	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
20	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
21	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
22	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
23	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDIT_BU_PC
24	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: %EDIT_PROJECT
25	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDIT_ACTIVITY
26	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RESTYPE_FS Set Control Field: BUSINESS_UNIT_PC
27	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDIT_RES_CAT Set Control Field: BUSINESS_UNIT_PC
28	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDIT_RES_SUB Set Control Field: BUSINESS_UNIT_PC
29	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: %EDIT_ANALYSIS Set Control Field: BUSINESS_UNIT_PC
30	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
31	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
32	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
33	ORG_CODE	Character(6)	VARCHAR2(6) NOT NULL	Organization Code. This will be unique to an Organization.
34	ORG_TAX_LOC_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Location Code. An Organization can have multiple Tax Location Codes.
35	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
36	EXD_REG_SRL_NO	Number(10,0)	DECIMAL(10) NOT NULL	Excise Register Number
37	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
38	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
39	EXD_DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Excise Distribution Account Type. This field is used to assign chart fields for a particular tax location and will have various translate values. CNCA=Cenvat Clearing Account CNCG=Cenvat on Capital Goods CNCI=Cenvat Clearing Imports ACD CNHA=Cenvat utilization on Hold Acc CNHC=Cenvat Hold on Capital Goods CNHS=Cenvat Hold for Sub Contractin CNRM=Cenvat on Raw Materials CNSU=Cenvat Suspense Account CSDN=Custom Duty Non-Recoverable EXDC=Excise Dty recovd from Customr EXDE=Excise Duty Expenses KKC=Krishi Kalyan Cess on Purchase KKCP=Krishi Kalyan Cess on Sales PLAA=PLA Account SBC=Swachh Bharat Cess on Purchase SBCP=Swachh Bharat Cess on Sales SERV=Service Tax SST=Suspense Service Tax
40	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
41	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
42	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit