ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCV
1
Cash ReceiptVendorAccounting
2
CR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_VENDCR_DOC_ACTGCR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_HDRCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_VENDCR_DOC_ACTGCR_DOC_ACTGCR_DOC_ACTGCR_DOC_ACTGCR_DOC_ACTGCR_DOC_ACTGCR_DOC_ACTGCR_DOC_ACTGCR_DOC_ACTG
3
SPD_DOC_IDAUTO_NO_FLDOC_CDDOC_DEPT_CDDOC_IDDOC_UNIT_CDDOC_VEND_LN_NODOC_ACTG_LN_NODOC_NMDOC_REC_DT_DCDOC_BFYDOC_FY_DCDOC_PER_DCDOC_DSCRBANK_ACCT_CDCASH_ACCT_CDCASH_ACCT_SCNT_STMT_CUST
CNT_STMT_BIL_PRFL
ESCROW_IDMISC_IDMAIL_CDEXT_DOC_DSCRDPS_TKT_NODPS_DTBANK_DPS_DTTRANS_RECON_DTTRANS_AUD_DTMETH_OF_DPS
DPS_BANK_CAT_CD
PYMT_TYP_INDVEND_CUST_CDLGL_NMVL_AMBPRO_CDTRVLR_IDMRCHT_IDAD_IDAD_LN_1AD_LN_2CITYSTZIPCTRYCNTYAR_DEPT_CDAR_UNIT_CDCNTAC_IDPRIN_CNTACVOICE_PH_NOVOICE_PH_EXTEMAIL_ADFAX_PH_NOFAX_PH_EXTWEB_ADAUTO_APY_FLRS_CR_BAL_FLACTG_PRFL_IDREAS_CDPYMT_DTMISC_DSCR_1MISC_DSCR_2MISC_DSCR_3PYMT_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_NOWIRE_XFER_DTABA_NOBANK_NMACCT_NOBIC_SWIFT_CDIBAN_CDWIRE_DESCCHK_EFT_NOCHK_DTID_NOID_TYPNSF_FEE_AMNSF_CHK_DTWAIV_NSF_FEE_FLCC_CDCC_NO_VIEWCC_EXPR_MOCC_EXPR_YRCC_TRAN_NOCARD_HLD_NMLN_AMEVNT_TYP_IDPSTNG_PR_TYPACTG_TMPL_IDACTG_LN_DSCRCRRNCY_AMCOIN_AMBFYFY_DC
4
*Spreadsheet Doc Id*Auto Numbering*Code*DeptIDUnit*Vendor Line No
*Accounting Line No
Transaction NameRecord DateBudget FYFiscal YearPeriod*Transaction Description*Bank AccountCash AccountCash Account SubCentral Statement CustomerCentral Statement Billing ProfileEscrow IDMiscellaneous IdentifierMail CodeExtended DescriptionDeposit TicketDeposit DateBank Deposit DateDate Transmitted for ReconciliationDate Transmitted for AuditMethod of DepositDeposit and Bank CategoryPayment TypeVendor CustomerLegal Name*Line AmountBilling ProfileTraveler IDMerchant IDAddress CodeAddress Line 1Address Line 2CityStateZipCountryCountyAR DeptAR UnitVendor Contact IDVendor Contact NameVendor Contact PhoneVendor Contact Phone Ext.Vendor Contact EmailFaxFax ExtensionWeb Address http//Auto ApplyReserve Credit BalanceAccounting ProfileReasonPayment DateMisc. Description 1Misc. Description 2Misc. Description 3Payment TypeSuppress Pend PrintReferenced Transaction CodeReferenced Transaction DeptReferenced Transaction IDReferenced Vendor LineReferenced Accounting LineWire Transfer NumberWire Transfer DateABA NumberBank NameAccount NumberBIC or SWIFT CodeIBANDescriptionCheck/EFT NumberCheck/EFT DateID NumberID TypeNSF Fee AmountNSF Check DateWaive NSF FeeCredit/Debit CardCredit/Debit Card NumberCard Expiration MonthCard Expiration YearCredit/Debit Transaction NumberName on Card*Line Amount*Event TypeLine Type
Accounting Template
Line DescriptionCurrencyCoinBudget FYFiscal 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