CRV4_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	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO	CP	CQ	CR	CS	CT	CU	CV
1	Cash Receipt																															Vendor																																																												Accounting

2			CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_VEND	CR_DOC_ACTG	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_HDR	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_VEND	CR_DOC_ACTG	CR_DOC_ACTG	CR_DOC_ACTG	CR_DOC_ACTG	CR_DOC_ACTG	CR_DOC_ACTG	CR_DOC_ACTG	CR_DOC_ACTG	CR_DOC_ACTG
3	SPD_DOC_ID	AUTO_NO_FL	DOC_CD	DOC_DEPT_CD	DOC_ID	DOC_UNIT_CD	DOC_VEND_LN_NO	DOC_ACTG_LN_NO	DOC_NM	DOC_REC_DT_DC	DOC_BFY	DOC_FY_DC	DOC_PER_DC	DOC_DSCR	BANK_ACCT_CD	CASH_ACCT_CD	CASH_ACCT_S	CNT_STMT_CUST	CNT_STMT_BIL_PRFL	ESCROW_ID	MISC_ID	MAIL_CD	EXT_DOC_DSCR	DPS_TKT_NO	DPS_DT	BANK_DPS_DT	TRANS_RECON_DT	TRANS_AUD_DT	METH_OF_DPS	DPS_BANK_CAT_CD	PYMT_TYP_IND	VEND_CUST_CD	LGL_NM	VL_AM	BPRO_CD	TRVLR_ID	MRCHT_ID	AD_ID	AD_LN_1	AD_LN_2	CITY	ST	ZIP	CTRY	CNTY	AR_DEPT_CD	AR_UNIT_CD	CNTAC_ID	PRIN_CNTAC	VOICE_PH_NO	VOICE_PH_EXT	EMAIL_AD	FAX_PH_NO	FAX_PH_EXT	WEB_AD	AUTO_APY_FL	RS_CR_BAL_FL	ACTG_PRFL_ID	REAS_CD	PYMT_DT	MISC_DSCR_1	MISC_DSCR_2	MISC_DSCR_3	PYMT_TYP_IND	SPRS_PEND_PRN_FL	RFED_DOC_CD	RFED_DOC_DEPT_CD	RFED_DOC_ID	RFED_VEND_LN_NO	RFED_ACTG_LN_NO	WIRE_XFER_NO	WIRE_XFER_DT	ABA_NO	BANK_NM	ACCT_NO	BIC_SWIFT_CD	IBAN_CD	WIRE_DESC	CHK_EFT_NO	CHK_DT	ID_NO	ID_TYP	NSF_FEE_AM	NSF_CHK_DT	WAIV_NSF_FEE_FL	CC_CD	CC_NO_VIEW	CC_EXPR_MO	CC_EXPR_YR	CC_TRAN_NO	CARD_HLD_NM	LN_AM	EVNT_TYP_ID	PSTNG_PR_TYP	ACTG_TMPL_ID	ACTG_LN_DSCR	CRRNCY_AM	COIN_AM	BFY	FY_DC
4	*Spreadsheet Doc Id	*Auto Numbering	*Code	*Dept	ID	Unit	*Vendor Line No	*Accounting Line No	Transaction Name	Record Date	Budget FY	Fiscal Year	Period	*Transaction Description	*Bank Account	Cash Account	Cash Account Sub	Central Statement Customer	Central Statement Billing Profile	Escrow ID	Miscellaneous Identifier	Mail Code	Extended Description	Deposit Ticket	Deposit Date	Bank Deposit Date	Date Transitted for Reconciliation	Date Transmitted for Audit	Method of Deposit	Deposit and Bank Category	Payment Type	Vendor Customer	Legal Name	*Line Amount	Billing Profile	Traveler ID	Merchant ID	Address Code	Address Line 1	Address Line 2	City	State	Zip	Country	County	AR Dept	AR Unit	Vendor Contact ID	Vendor Contact Name	Vendor Contact Phone	Vendor Contact Phone Ext.	Vendor Contact Email	Fax	Fax Extension	Web Address http//	Auto Apply	Reserve Credit Balance	Accounting Profile	Reason	Payment Date	Misc. Description 1	Misc. Description 2	Misc. Description 3	Payment Type	Suppress Pend Print	Referenced Transaction Code	Referenced Transaction Dept	Referenced Transaction ID	Referenced Vendor Line	Referenced Accounting Line	Wire Transfer Number	Wire Transfer Date	ABA Number	Bank Name	Account Number	BIC or SWIFT Code	IBAN	Description	Check/EFT Number	EFT/Check Date	ID Number	ID Type	NSF Fee Amount	NSF Check Date	Waive NSF Fee	Credit/Debit Card	Credit/Debit Card Number	Card Expiration Month	Card Expiration Year	Credit/Debit Transaction Number	Name on Card	*Line Amount	*Event Type	Line Type	Accounting Template	Line Description	Currency	Coin	Budget FY	Fiscal Year
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