Import File: SVRM0001.CSV (Comma) or SVRM0001.TXT (Tab)
Warehouse File: SV_RM_Customer_SUM_IMP_WHSE
Destination File: RM_Customer_MSTR_SUM (RM00103)
- Indicates validated fields, and must contain data.
- Indicates validated, but can be left empty.
Tab Position
Excel Column
Field Name
Storage Type
Keyable
Storage
1
A
Total Amount Of NSF Checks Life
Currency
19
10
2
B
Number Of NSF Checks Life
Long Integer
6
4
3
C
*Customer Number
String
15
16
4
D
Customer Balance
Currency
19
10
5 - 11
E-K
Aging Period Amounts
Currency
17
10
12
L
Last Aged
Date
6
4
13
M
First Invoice Date
Date
6
4
14
N
Last NSF Check Date
Date
6
4
15
O
Last Payment Amount
Currency
17
10
16
P
Last Payment Date
Date
6
4
17
Q
Last Transaction Date
Date
6
4
18
R
Last Transaction Amount
Currency
17
10
19
S
Last Finance Charge Amount
Currency
17
10
20
T
Unpaid Finance Charges YTD
Currency
17
10
21
U
Average Days to Pay - LYR
Integer
3
2
22
V
Average Days To Pay - Life
Integer
3
2
23
W
Average Days To Pay - Year
Integer
3
2
24
X
Number ADTP Documents - Life
Long Integer
10
4
25
Y
Number ADTP Documents - Year
Long Integer
10
4
26
Z
Total Discounts Taken YTD
Currency
19
10
27
AA
Total Discounts Taken LYR
Currency
19
10
28
AB
Total Discounts Taken LTD
Currency
19
10
29
AC
Total Discounts Available YTD
Currency
19
10
30
AD
Retainage
Currency
19
10
31
AE
Total Amount Of NSF Checks YTD
Currency
19
10
32
AF
Number Of NSF Checks YTD
Long Integer
6
4
33
AG
Unposted Sales Amount
Currency
19
10
34
AH
Unposted Cash Amount
Currency
19
10
35
AI
Unposted Other Sales Amount
Currency
19
10
36
AJ
Unposted Other Cash Amount
Currency
19
10
37
AK
Non Current Scheduled Payments
Currency
19
10
38
AL
Total Sales YTD
Currency
19
10
39
AM
Total Sales LTD
Currency
19
10
40
AN
Total Sales LYR
Currency
19
10
41
AO
Total Costs YTD
Currency
19
10
42
AP
Total Costs LTD
Currency
19
10
43
AQ
Total Costs LYR
Currency
19
10
44
AR
Total Cash Received YTD
Currency
19
10
45
AS
Total Cash Received LTD
Currency
19
10
46
AT
Total Cash Received LYR
Currency
19
10
47
AU
Total Finance Charges YTD
Currency
19
10
48
AV
Total Finance Charges LTD
Currency
19
10
49
AW
Total Finance Charges LYR
Currency
19
10
50
AX
Finance Charges CYTD
Currency
19
10
51
AY
Finance Charges LYR Calendar
Currency
19
10
52
AZ
Total Bad Debt YTD
Currency
19
10
53
BA
Total Bad Debt LYR
Currency
19
10
54
BB
Total Bad Debt LTD
Currency
19
10
55
BC
Total Waived FC YTD
Currency
19
10
56
BD
Total Waived FC LTD
Currency
19
10
57
BE
Total Waived FC LYR
Currency
19
10
58
BF
Total Writeoffs YTD
Currency
19
10
59
BG
Total Writeoffs LTD
Currency
19
10
60
BH
Total Writeoffs LYR
Currency
19
10
61
BI
Total # Invoices YTD
Long Integer
6
4
62
BJ
Total # Invoices LTD
Long Integer
6
4
63
BK
Total # Invoices LYR
Long Integer
6
4
64
BL
Total # FC YTD
Long Integer
6
4
65
BM
Total # FC LTD
Long Integer
6
4
66
BN
Total # FC LYR
Long Integer
6
4
67
BO
Write Offs LIFE
Currency
19
10
68
BP
Write Offs LYR
Currency
19
10
69
BQ
Write Offs YTD
Currency
19
10
70
BR
High Balance LYR
Currency
19
10
71
BS
High Balance YTD
Currency
19
10
72
BT
High Balance LTD
Currency
19
10
73
BU
Last Statement Date
Date
6
4
74
BV
Last Statement Amount
Currency
17
10
75
BW
Deposits Received
Currency
19
10
76
BX
On Order Amount
Currency
19
10
- Indicates validated, but can be left empty.