SSF_VCHLINE_STG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	VCHR_BLD_KEY_C1	Character(25)	VARCHAR2(25) NOT NULL	Voucher Build Key Char 1
4	VCHR_BLD_KEY_C2	Character(25)	VARCHAR2(25) NOT NULL	Voucher Build Key Char 1
5	VCHR_BLD_KEY_N1	Number(10,0)	DECIMAL(10) NOT NULL	Voucher Build Key Num 1
6	VCHR_BLD_KEY_N2	Number(10,0)	DECIMAL(10) NOT NULL	Vchr Build Key Num 2
7	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
8	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
9	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
10	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
11	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number
12	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
13	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
14	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt
15	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID
16	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
17	QTY_VCHR	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Vouchered
18	STATISTIC_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Statistic Amount
19	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set
20	UNIT_PRICE	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Unit Price
21	DSCNT_APPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Apply Discount
22	TAX_CD_VAT	Character(8)	VARCHAR2(8) NOT NULL	VAT code.
23	BUSINESS_UNIT_RECV	Character(5)	VARCHAR2(5) NOT NULL	Receiving Business Unit
24	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver ID Number
25	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receiver Line Number
26	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
27	MATCH_LINE_OPT	Character(1)	VARCHAR2(1) NOT NULL	Match Line Option E=ERS Match F=Full Match N=Don't Match
28	DISTRIB_MTHD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Distribute by A=Amount Q=Quantity
29	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
30	SUT_BASE_ID	Character(10)	VARCHAR2(10) NOT NULL	Sales/Use Tax Destination
31	TAX_CD_SUT	Character(8)	VARCHAR2(8) NOT NULL	Tax code - Sales and Use tax.
32	ULTIMATE_USE_CD	Character(8)	VARCHAR2(8) NOT NULL	Ultimate Use Code
33	SUT_EXCPTN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Sales/Use Tax Exception Type D=Direct Pay E=Exempt/Exonerated N=None
34	SUT_EXCPTN_CERTIF	Character(20)	VARCHAR2(20) NOT NULL	Sales/Use Tax Exception Certif
35	SUT_APPLICABILITY	Character(1)	VARCHAR2(1) NOT NULL	Sales/Use Tax Applicability D=Sales Tax Appl, Direct Pay E=Item is Exempt S=Sales Tax Appl U=Use Tax Appl X=Purchaser is Exonerated
36	VAT_APPLICABILITY	Character(1)	VARCHAR2(1) NOT NULL	VAT Applicability E=Exempt N=Not Applicable O=Outside of Scope of VAT S=Suspended T=Taxable V=VAT only
37	VAT_TXN_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	VAT Transaction Type
38	VAT_USE_ID	Character(6)	VARCHAR2(6) NOT NULL	VAT Use Type
39	ADDR_SEQ_NUM_SHIP	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
40	BUS_UNIT_RELATED	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
41	VOUCHER_ID_RELATED	Character(8)	VARCHAR2(8) NOT NULL	Related Voucher
42	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
43	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
44	DESCR254_MIXED	Character(254)	VARCHAR2(254) NOT NULL	Description
45	SPEEDCHART_KEY	Character(10)	VARCHAR2(10) NOT NULL	SpeedChart Key
46	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	General Ledger Unit
47	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
48	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
49	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit
50	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product
51	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
52	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field.
53	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code
54	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Chartfield
55	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field
56	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
57	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
58	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield number 1
59	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
60	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
61	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
62	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project/Grant
63	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
64	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
65	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
66	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Resource Type
67	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Resource Category
68	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Resource Sub Category
69	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.
70	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)
71	TAX_DSCNT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include Discount
72	TAX_FRGHT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include Freight
73	TAX_MISC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include Misc Charges
74	TAX_VAT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include VAT
75	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature
76	VAT_RCRD_INPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT record input.
77	VAT_RCRD_OUTPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT record output.
78	VAT_TREATMENT	Character(4)	VARCHAR2(4) NOT NULL	VAT Treatment
79	VAT_SVC_SUPPLY_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT Services Place of Supply Flag
80	VAT_SERVICE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	VAT Service Type
81	COUNTRY_LOC_BUYER	Character(3)	VARCHAR2(3) NOT NULL	Buyer's Location Country - May be either the VAT Entity or the Trading Partner
82	STATE_LOC_BUYER	Character(6)	VARCHAR2(6) NOT NULL	Buyer's Location State - May be either the VAT Entity or the Trading Partner
83	COUNTRY_LOC_SELLER	Character(3)	VARCHAR2(3) NOT NULL	Seller's Location Country - May be either the VAT Entity or the Trading Partner
84	STATE_LOC_SELLER	Character(6)	VARCHAR2(6) NOT NULL	Seller's Location State - May be either the VAT Entity or the Trading Partner
85	COUNTRY_VAT_SUPPLY	Character(3)	VARCHAR2(3) NOT NULL	VAT Place of Supply Country
86	STATE_VAT_SUPPLY	Character(6)	VARCHAR2(6) NOT NULL	VAT Place of Supply State
87	COUNTRY_VAT_PERFRM	Character(3)	VARCHAR2(3) NOT NULL	Country Where Service Physically Performed
88	STATE_VAT_PERFRM	Character(6)	VARCHAR2(6) NOT NULL	State Where Service Physically Performed
89	STATE_SHIP_FROM	Character(6)	VARCHAR2(6) NOT NULL	Ship From State
90	STATE_VAT_DEFAULT	Character(6)	VARCHAR2(6) NOT NULL	VAT Defaulting State
91	REQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id
92	VAT_ENTRD_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Entered VAT amount.
93	VAT_RECEIPT	Character(1)	VARCHAR2(1) NOT NULL	No VAT Receipt
94	VAT_RGSTRN_SELLER	Character(12)	VARCHAR2(12) NOT NULL	Seller's VAT registration.
95	IST_TXN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Intrastat Transaction Flag
96	TRANS_DT	Date(10)	DATE	Transaction Date
97	WTHD_SW	Character(1)	VARCHAR2(1) NOT NULL	Display Withholding Flag
98	WTHD_CD	Character(5)	VARCHAR2(5) NOT NULL	Withholding Code
99	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID
100	USER_VCHR_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	User Character Field
101	USER_VCHR_CHAR2	Character(1)	VARCHAR2(1) NOT NULL	User Character Field 2
102	USER_VCHR_DEC	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	User Amount Field
103	USER_VCHR_DATE	Date(10)	DATE	User Date
104	USER_VCHR_NUM1	Number(3,0)	SMALLINT NOT NULL	User Number field
105	USER_LINE_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Line User Field
106	USER_SCHED_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Schedule User Field