IN_UPDOCS_Template.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW
1	Invoice																Vendor																										Commodity

2			IN_DOC_HDR	IN_DOC_HDR	IN_DOC_HDR	IN_DOC_HDR	IN_DOC_VEND	IN_DOC_COMM	IN_DOC_HDR	IN_DOC_HDR	IN_DOC_HDR	IN_DOC_HDR	IN_DOC_HDR	IN_DOC_HDR	IN_DOC_HDR	IN_DOC_HDR	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_VEND	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM	IN_DOC_COMM
3	SPD_DOC_ID	AUTO_NO_FL	DOC_CD	DOC_DEPT_CD	DOC_ID	DOC_UNIT_CD	DOC_VEND_LN_NO	DOC_COMM_LN_NO	DOC_NM	INV_DT	TRKG_DT	LOC_CD	DOC_DSCR	VEND_CUST_CD	VEND_INV_NO	DSCR_EXT	AD_ID	CNTAC_ID	PRIN_CNTAC	VOICE_PH_NO	VOICE_PH_EXT	EMAIL_AD	VEND_DISB_CAT	DFLT_DISB_FRMT	DISB_PRTY_CD	VEND_SNGL_CHK_FL	ONL_DISB_RQST_FL	HDLG_CD	TAX_PRFL_CD	SCHED_PYMT_DT	DISC_1_PC	DISC_1_DY	DISC_ALW_1_FL	DISC_2_PC	DISC_2_DY	DISC_ALW_2_FL	DISC_3_PC	DISC_3_DY	DISC_ALW_3_FL	DISC_4_PC	DISC_4_DY	DISC_ALW_4_FL	COMM_CD	QTY	UNIT_PRICE	CNTRC_AM	LN_TYP	RF_DOC_CD	RF_DOC_DEPT_CD	RF_DOC_ID	RF_DOC_COMM_LN_NO	RF_TYP	VEND_INV_LN_NO	CL_DSCR	SVC_FRM_DT	SVC_TO_DT	TAX_PRFL_CD	COND_CD	REAS	ADDL_CMNT	CHK_DSCR	TAX_ADJ_AMT	RF_TAX_ADJ_AMT	DISC_1_PC	DISC_1_DY	DISC_ALW_1_FL	DISC_2_PC	DISC_2_DY	DISC_ALW_2_FL	DISC_3_PC	DISC_3_DY	DISC_ALW_3_FL	DISC_4_PC	DISC_4_DY	DISC_ALW_4_FL
4	*Spreadsheet Doc Id	*Auto Numbering	*Code	*Dept	ID	Unit	Vendor Line No*	Commodity Line No*	Transaction Name	*Invoiced Date	Tracking Date	Invoiced Location	Description	Vendor	Vendor Invoice Number	Extended Description	Address Code	Vendor Contact ID	Contact Name	Phone	Extension	Email	Disbursement Category	Disbursement Format	Disbursement Priority	Single Payment	Online Disbursement Request	*Handling Code	Tax Profile	Scheduled Payment Date	Percent 1	Days 1	Discount Always 1	Percent 2	Days 2	Discount Always 2	Percent 3	Days 3	Discount Always 3	Percent 4	Days 4	Discount Always 4	*Commodity	Invoiced Quantity	Invoiced Unit Price	Invoiced Service Contract Amount	*Line Type	Referenced Transaction Code	Referenced Transaction Dept	Referenced Transaction ID	Referenced Commodity Line	Reference Type	Vendor Invoice Line	Commodity Line Description	Service From	Service To	Tax Profile	Condition	Reason	Additional Comment	Check Description	Tax Adjusted Amount	Referenced Tax Adj Amt.	Percent 1	Days 1	Discount Always 1	Percent 2	Days 2	Discount Always 2	Percent 3	Days 3	Discount Always 3	Percent 4	Days 4	Discount Always 4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100