VCHR_DIST_STG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	VCHR_BLD_KEY_C1	Character(25)	VARCHAR2(25) NOT NULL	Voucher Build Key Char 1
3	VCHR_BLD_KEY_C2	Character(25)	VARCHAR2(25) NOT NULL	Voucher Build Key Char 1
4	VCHR_BLD_KEY_N1	Number(10,0)	DECIMAL(10) NOT NULL	Voucher Build Key Num 1
5	VCHR_BLD_KEY_N2	Number(10,0)	DECIMAL(10) NOT NULL	Vchr Build Key Num 2
6	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
7	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
8	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line Number
9	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	General Ledger Unit
10	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
11	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
12	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
13	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
14	STATISTIC_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Statistic Amount
15	QTY_VCHR	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Vouchered
16	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
17	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt
18	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
19	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
20	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number
21	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
22	PO_DIST_LINE_NUM	Number(5,0)	INTEGER NOT NULL	PO Distribution Line Number
23	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
24	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
25	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
26	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Resource Type
27	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Resource Category
28	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Resource Sub Category
29	ASSET_FLG	Character(1)	VARCHAR2(1) NOT NULL	Assets Applicable
30	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	Asset Management Business Unit
31	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
32	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID
33	COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates how the employee-paid portion of a benefit plan is paid, either as Cost (C) or Price (P). 'Price' indicates that the benefit is paid from an employee payroll deduction. 'Credit' specifies that the system calculates additional earnings which are used as credit to pay for a benefit. C=Credit P=Price
34	VAT_TXN_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	VAT Transaction Type
35	BUSINESS_UNIT_RECV	Character(5)	VARCHAR2(5) NOT NULL	Receiving Business Unit
36	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver ID Number
37	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receiver Line Number
38	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
39	RECV_DIST_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Receiver Distrib Line
40	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit
41	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product
42	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
43	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field.
44	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code
45	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Chartfield
46	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field
47	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
48	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
49	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield number 1
50	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
51	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
52	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project/Grant
53	BUDGET_DT	Date(10)	DATE	Budget Date
54	ENTRY_EVENT	Character(10)	VARCHAR2(10) NOT NULL	Entry Event
55	ECQUEUEINSTANCE	Number(9,0)	DECIMAL(9) NOT NULL	Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
56	ECTRANSID	Character(15)	VARCHAR2(15) NOT NULL	Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
57	JRNL_LN_REF	Character(10)	VARCHAR2(10) NOT NULL	Journal Line Reference
58	VAT_APORT_CNTRL	Character(1)	VARCHAR2(1) NOT NULL	VAT Apportionment Control D=Distribution GL Business Unit
59	USER_VCHR_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	User Character Field
60	USER_VCHR_CHAR2	Character(1)	VARCHAR2(1) NOT NULL	User Character Field 2
61	USER_VCHR_DEC	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	User Amount Field
62	USER_VCHR_DATE	Date(10)	DATE	User Date
63	USER_VCHR_NUM1	Number(3,0)	SMALLINT NOT NULL	User Number field
64	USER_DIST_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Distribution User Field
65	OPEN_ITEM_KEY	Character(30)	VARCHAR2(30) NOT NULL	Open Item Key
66	VAT_RECOVERY_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT recovery percent.
67	VAT_REBATE_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT rebate percent.
68	VAT_CALC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT calculated amount.
69	VAT_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT basis amount.
70	VAT_RCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT recovery amount.
71	VAT_NRCVR_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT non recoverable amount.
72	VAT_REBATE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT rebate amount.
73	VAT_TRANS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT transaction amount.
74	TAX_CD_VAT_PCT	Signed Number(9,4)	DECIMAL(7,4) NOT NULL	VAT tax code aggregate percent.
75	VAT_INV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT invoice amount.
76	VAT_NONINV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT non invoice amount.
77	BUSINESS_UNIT_WO	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Work Order
78	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification
79	WO_TASK_ID	Number(5,0)	INTEGER NOT NULL	Task Number
80	RSRC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Resource Type: Member Org or Initiative. I=Initiative M=Member Organization
81	RES_LN_NBR	Number(5,0)	INTEGER NOT NULL	Resource Line No.