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	LEASE_PYMNT_DT	Date(10)	DATE	Lease Payment Date
8	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
9	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
10	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Prompt Table: SP_BUPRCR_NONVW
11	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
12	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
13	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
14	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
15	STATISTIC_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
16	QTY_VCHR	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Vouchered
17	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
18	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
19	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
20	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
21	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
22	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
23	PO_DIST_LINE_NUM	Number(5,0)	INTEGER NOT NULL	PO Distribution Line Number
24	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
25	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
26	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
27	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
28	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
29	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
30	ASSET_FLG	Character(1)	VARCHAR2(1) NOT NULL	Assets Applicable
31	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit
32	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
33	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID
34	COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cost Type
35	VAT_TXN_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
36	BUSINESS_UNIT_RECV	Character(5)	VARCHAR2(5) NOT NULL	Receiving Business Unit
37	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
38	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
39	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
40	RECV_DIST_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Receiver Distrib Line
41	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField
42	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField
43	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
44	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field
45	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField
46	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference
47	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate
48	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
49	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
50	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1
51	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
52	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
53	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
54	BUDGET_DT	Date(10)	DATE	Budget Date
55	ENTRY_EVENT	Character(10)	VARCHAR2(10) NOT NULL	Entry Event
56	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.
57	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)
58	JRNL_LN_REF	Character(10)	VARCHAR2(10) NOT NULL	Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.
59	VAT_APORT_CNTRL	Character(1)	VARCHAR2(1) NOT NULL	VAT Apportionment Control D=Distribution GL Business Unit G=Transaction GL Business Unit T=Transaction Business Unit
60	USER_VCHR_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	User Character Field
61	USER_VCHR_CHAR2	Character(1)	VARCHAR2(1) NOT NULL	User Character Field 2
62	USER_VCHR_DEC	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	User Amount Field
63	USER_VCHR_DATE	Date(10)	DATE	User Date
64	USER_VCHR_NUM1	Number(3,0)	SMALLINT NOT NULL	User Number field
65	USER_DIST_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 1
66	CUSTOM_C100_D1	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 1
67	CUSTOM_C100_D2	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 2
68	CUSTOM_C100_D3	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 3
69	CUSTOM_C100_D4	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 4
70	CUSTOM_DATE_D	Date(10)	DATE	Custom Date
71	CUSTOM_C1_D	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 2
72	OPEN_ITEM_KEY	Character(30)	VARCHAR2(30) NOT NULL	Open Item Key
73	VAT_RECOVERY_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT Recovery Percent
74	VAT_REBATE_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT Rebate Percent
75	VAT_CALC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Calculated Amount
76	VAT_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.
77	VAT_RCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Recovery Amt
78	VAT_NRCVR_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Non Recoverable
79	VAT_REBATE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Rebate Amt
80	VAT_TRANS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the sale or purchase amount against which the VAT is applicable.
81	TAX_CD_VAT_PCT	Signed Number(9,4)	DECIMAL(7,4) NOT NULL	Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
82	VAT_INV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Invoice Amount
83	VAT_NONINV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Non-Invoice Amount
84	BUSINESS_UNIT_WO	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Work Order
85	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification
86	WO_TASK_ID	Number(5,0)	INTEGER NOT NULL	Task Number
87	RSRC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Work Order Management Resource Types 1=Labor 2=Tools 3=Material
88	RES_LN_NBR	Number(5,0)	INTEGER NOT NULL	Resource Line No.