| STMTSEQ |
1 |
Long |
Statement Run Number |
E A K R |
|
| IDCUST |
2 |
String*12 |
Customer Number |
E A K R |
Mask: %-12C |
| SWPRINTED |
3 |
Integer |
Statement Printed Flag |
E A |
List: 2 entries
|
| SWNATSTMT |
4 |
Integer |
NAT Statement Switch |
E A |
List: 3 entries
| 0 | = | Customer Statements | | 1 | = | National Acct. Statements | | 2 | = | Letters or Labels |
|
| IDNATACCT |
5 |
String*12 |
National Account Number |
E A |
Mask: %-12C |
| STMTDATE |
6 |
Date |
Statement Run Date |
E A |
|
| TEXTSNAM |
7 |
String*10 |
Short Name |
E A |
|
| IDGRP |
8 |
String*6 |
Group Code |
E A |
Mask: %-6N |
| SWACTV |
9 |
Integer |
Status |
E A |
|
| DATEINAC |
10 |
Date |
Inactive Date |
E A |
|
| DATELASTMN |
11 |
Date |
Date Last Maintained |
E A |
|
| SWHOLD |
12 |
Integer |
On Hold |
E A |
|
| DATESTART |
13 |
Date |
Start Date |
E A |
|
| IDPPNT |
14 |
String*12 |
Reserved |
E A |
|
| CODEDAB |
15 |
String*9 |
Credit Bureau Number |
E A |
|
| CODEDABRTG |
16 |
String*5 |
Credit Bureau Rating |
E A |
|
| DATEDAB |
17 |
Date |
Credit Bureau Date |
E A |
|
| NAMECUST |
18 |
String*60 |
Customer Name |
E A |
|
| TEXTSTRE1 |
19 |
String*60 |
Address Line 1 |
E A |
|
| TEXTSTRE2 |
20 |
String*60 |
Address Line 2 |
E A |
|
| TEXTSTRE3 |
21 |
String*60 |
Address Line 3 |
E A |
|
| TEXTSTRE4 |
22 |
String*60 |
Address Line 4 |
E A |
|
| NAMECITY |
23 |
String*30 |
City |
E A |
|
| CODESTTE |
24 |
String*30 |
State/Prov. |
E A |
|
| CODEPSTL |
25 |
String*20 |
Zip/Postal Code |
E A |
|
| CODECTRY |
26 |
String*30 |
Country |
E A |
|
| NAMECTAC |
27 |
String*60 |
Contact Name |
E A |
|
| TEXTPHON1 |
28 |
String*30 |
Phone Number |
E A P |
Mask: (%-3C) %-3C-%-24C |
| TEXTPHON2 |
29 |
String*30 |
Fax Number |
E A P |
Mask: (%-3C) %-3C-%-24C |
| CODETERR |
30 |
String*6 |
Territory Code |
E A |
Mask: %-6N |
| IDACCTSET |
31 |
String*6 |
Account Set |
E A |
Mask: %-6N |
| IDAUTOCASH |
32 |
String*6 |
Autocash Profile |
E A |
|
| IDBILLCYCL |
33 |
String*6 |
Billing Cycle |
E A |
Mask: %-6N |
| IDSVCCHRG |
34 |
String*6 |
Interest Profile |
E A |
Mask: %-6N |
| IDDLNQ |
35 |
String*6 |
Reserved |
E A |
|
| CODECURN |
36 |
String*3 |
Currency Code |
E A |
Mask: %-3N |
| SWPRTSTMT |
37 |
Integer |
Print Statements |
E A |
List: 2 entries
|
| SWPRTDLNQ |
38 |
Integer |
Reserved |
E A |
|
| SWBALFWD |
39 |
Integer |
Account Type |
E A |
List: 2 entries
| 0 | = | Open Item | | 1 | = | Balance Forward |
|
| CODETERM |
40 |
String*6 |
Terms |
E A |
Mask: %-6N |
| IDRATETYPE |
41 |
String*2 |
Rate Type |
E A |
Mask: %-2N |
| CODETAXGRP |
42 |
String*12 |
Tax Group |
E A |
Mask: %-12N |
| IDTAXREGI1 |
43 |
String*20 |
Tax Registration No. 1 |
E A |
|
| IDTAXREGI2 |
44 |
String*20 |
Tax Registration No. 2 |
E A |
|
| IDTAXREGI3 |
45 |
String*20 |
Tax Registration No. 3 |
E A |
|
| IDTAXREGI4 |
46 |
String*20 |
Tax Registration No. 4 |
E A |
|
| IDTAXREGI5 |
47 |
String*20 |
Tax Registration No. 5 |
E A |
|
| TAXSTTS1 |
48 |
Integer |
Tax Class Code 1 |
E A |
|
| TAXSTTS2 |
49 |
Integer |
Tax Class Code 2 |
E A |
|
| TAXSTTS3 |
50 |
Integer |
Tax Class Code 3 |
E A |
|
| TAXSTTS4 |
51 |
Integer |
Tax Class Code 4 |
E A |
|
| TAXSTTS5 |
52 |
Integer |
Tax Class Code 5 |
E A |
|
| AMTCRLIMT |
53 |
BCD*10.3 |
Credit Limit (Cust. Curr.) |
E A |
|
| AMTBALDUET |
54 |
BCD*10.3 |
Balance Due in Cust. Curr. |
E A |
|
| AMTBALDUEH |
55 |
BCD*10.3 |
Balance Due in Func. Curr. |
E A |
|
| DATELASTST |
56 |
Date |
Date of Last Statement |
E A |
|
| AMTLASTSTT |
57 |
BCD*10.3 |
Last Statement Total Cust. Curr. |
E A |
|
| AMTLASTSTH |
58 |
BCD*10.3 |
Reserved |
E A |
|
| DTBEGBALFW |
59 |
Date |
Date of Last Bal. Fwd. Statement |
E A |
|
| AMTBALFWDT |
60 |
BCD*10.3 |
Beginning Bal. on Last Statement |
E A |
|
| AMTBALFWDH |
61 |
BCD*10.3 |
Reserved |
E A |
|
| DTLASTRVAL |
62 |
Date |
Date of Last Revaluation |
E A |
|
| AMTBALLARV |
63 |
BCD*10.3 |
Last Revaluation Balance |
E A |
|
| CNTOPENINV |
64 |
BCD*4.0 |
Number of Open Documents |
E A |
|
| CNTINVPAID |
65 |
BCD*4.0 |
Number of Paid Invoices |
E A |
|
| DAYSTOPAY |
66 |
BCD*4.0 |
Number of Days to Pay |
E A |
|
| DATEINVCHI |
67 |
Date |
Date of Largest Invoice |
E A |
|
| DATEBALHI |
68 |
Date |
Date of Highest Balance |
E A |
|
| DATEINVHIL |
69 |
Date |
Date of Largest Invoice Last Yr. |
E A |
|
| DATEBALHIL |
70 |
Date |
Date of Highest Balance Last Yr. |
E A |
|
| DATELASTAC |
71 |
Date |
Date of Last Activity |
E A |
|
| DATELASTIV |
72 |
Date |
Date of Last Invoice |
E A |
|
| DATELASTCR |
73 |
Date |
Date of Last Credit Note |
E A |
|
| DATELASTDR |
74 |
Date |
Date of Last Debit Note |
E A |
|
| DATELASTPA |
75 |
Date |
Date of Last Receipt |
E A |
|
| DATELASTDI |
76 |
Date |
Date of Last Discount |
E A |
|
| DATELASTAD |
77 |
Date |
Date of Last Adjustment |
E A |
|
| DATELASTWR |
78 |
Date |
Date of Last Write-Off |
E A |
|
| DATELASTRI |
79 |
Date |
Date of Last Returned Check |
E A |
|
| DATELASTIN |
80 |
Date |
Date of Last Interest Charge |
E A |
|
| DATELASTDQ |
81 |
Date |
Reserved |
E A |
|
| IDINVCHI |
82 |
String*22 |
Largest Invoice Number |
E A |
|
| IDINVCHILY |
83 |
String*22 |
Largest Invoice Number Last Yr. |
E A |
|
| AMTINVHIT |
84 |
BCD*10.3 |
Largest Invoice - Cust. Curr. |
E A |
|
| AMTBALHIT |
85 |
BCD*10.3 |
Highest Balance - Cust. Curr. |
E A |
|
| AMTINVHILT |
86 |
BCD*10.3 |
Lgst. Inv. Last Yr. Cust. Curr. |
E A |
|
| AMTBALHILT |
87 |
BCD*10.3 |
High Bal. Last Yr. - Cust. Curr. |
E A |
|
| AMTLASTIVT |
88 |
BCD*10.3 |
Last Invoice Amt. - Cust. Curr. |
E A |
|
| AMTLASTCRT |
89 |
BCD*10.3 |
Last Cr. Note Amt. - Cust. Curr. |
E A |
|
| AMTLASTDRT |
90 |
BCD*10.3 |
Last Dr. Note Amt. - Cust. Curr. |
E A |
|
| AMTLASTPYT |
91 |
BCD*10.3 |
Last Receipt - Cust. Curr. |
E A |
|
| AMTLASTDIT |
92 |
BCD*10.3 |
Last Discount Amt. - Cust. Curr. |
E A |
|
| AMTLASTADT |
93 |
BCD*10.3 |
Last Adj. Amt. - Cust. Curr. |
E A |
|
| AMTLASTWRT |
94 |
BCD*10.3 |
Last Write-Off Amt. Cust. Curr. |
E A |
|
| AMTLASTRIT |
95 |
BCD*10.3 |
Last Ret'd. Chk. Amt. Cust. Curr |
E A |
|
| AMTLASTINT |
96 |
BCD*10.3 |
Last Int. Charge - Cust. Curr. |
E A |
|
| AMTINVHIH |
97 |
BCD*10.3 |
Largest Invoice - Func. Curr. |
E A |
|
| AMTBALHIH |
98 |
BCD*10.3 |
Highest Balance - Func. Curr. |
E A |
|
| AMTINVHILH |
99 |
BCD*10.3 |
Lgst. Inv. Last Yr. Func. Curr. |
E A |
|
| AMTBALHILH |
100 |
BCD*10.3 |
High Bal. Last Yr. - Func. Curr. |
E A |
|
| AMTLASTIVH |
101 |
BCD*10.3 |
Last Invoice Amt. - Func. Curr. |
E A |
|
| AMTLASTCRH |
102 |
BCD*10.3 |
Last Cr. Note Amt. - Func. Curr. |
E A |
|
| AMTLASTDRH |
103 |
BCD*10.3 |
Last Dr. Note Amt. - Func. Curr. |
E A |
|
| AMTLASTPYH |
104 |
BCD*10.3 |
Last Receipt - Func. Curr. |
E A |
|
| AMTLASTDIH |
105 |
BCD*10.3 |
Last Discount Amt. - Func. Curr. |
E A |
|
| AMTLASTADH |
106 |
BCD*10.3 |
Last Adj. Amt. - Func. Curr. |
E A |
|
| AMTLASTWRH |
107 |
BCD*10.3 |
Last Write-Off Amt. Func. Curr. |
E A |
|
| AMTLASTRIH |
108 |
BCD*10.3 |
Last Ret'd. Chk. Amt. Func. Curr |
E A |
|
| AMTLASTINH |
109 |
BCD*10.3 |
Last Int. Charge - Func. Curr. |
E A |
|
| CODESLSP1 |
110 |
String*8 |
Salesperson 1 |
E A |
Mask: %-8N |
| CODESLSP2 |
111 |
String*8 |
Salesperson 2 |
E A |
Mask: %-8N |
| CODESLSP3 |
112 |
String*8 |
Salesperson 3 |
E A |
Mask: %-8N |
| CODESLSP4 |
113 |
String*8 |
Salesperson 4 |
E A |
Mask: %-8N |
| CODESLSP5 |
114 |
String*8 |
Salesperson 5 |
E A |
Mask: %-8N |
| PCTSASPLT1 |
115 |
BCD*5.5 |
Sales-Split Percentage 1 |
E A |
|
| PCTSASPLT2 |
116 |
BCD*5.5 |
Sales-Split Percentage 2 |
E A |
|
| PCTSASPLT3 |
117 |
BCD*5.5 |
Sales-Split Percentage 3 |
E A |
|
| PCTSASPLT4 |
118 |
BCD*5.5 |
Sales-Split Percentage 4 |
E A |
|
| PCTSASPLT5 |
119 |
BCD*5.5 |
Sales-Split Percentage 5 |
E A |
|
| PRICLIST |
128 |
String*6 |
Customer Price List |
E A |
Mask: %-6C |
| CUSTTYPE |
129 |
Integer |
Customer Discount Type |
E A |
List: 6 entries
|
| AMTPDUE |
130 |
BCD*10.3 |
Amount Past Due |
E A |
|
| TEXTSTMT |
131 |
String*45 |
Dunning Message |
E A |
|
| EMAIL1 |
132 |
String*50 |
Contact's E-mail |
E A |
|
| EMAIL2 |
133 |
String*50 |
Customer's E-mail |
E A |
|
| WEBSITE |
134 |
String*100 |
Web Site |
E A |
|
| DELMETHOD |
135 |
Integer |
Delivery Method |
E A |
List: 3 entries
| 0 | = | Mail | | 2 | = | E-mail | | 4 | = | Contact's E-mail |
|
| CTACPHONE |
136 |
String*30 |
Contact's Phone |
E A P |
Mask: (%-3C) %-3C-%-24C |
| CTACFAX |
137 |
String*30 |
Contact's Fax |
E A P |
Mask: (%-3C) %-3C-%-24C |
| SWPARTSHIP |
138 |
Integer |
Allow Partial Shipments |
E A |
List: 2 entries
|
| HAMTBGNBLF |
139 |
BCD*10.3 |
HDR Amount Beginning Balance Forward |
E A |
|
| HAMTEBALFD |
140 |
BCD*10.3 |
HDR Amount Ending Balance Forward |
E A |
|
| HAMTSTMTBL |
141 |
BCD*10.3 |
HDR Amount Statement Balance |
E A |
|
| HAMTDUECUR |
142 |
BCD*10.3 |
HDR Amount Due Current Period |
E A |
|
| HAMTDUEAG1 |
143 |
BCD*10.3 |
HDR Amount Due 1st Period |
E A |
|
| HAMTDUEAG2 |
144 |
BCD*10.3 |
HDR Amount Due 2nd Period |
E A |
|
| HAMTDUEAG3 |
145 |
BCD*10.3 |
HDR Amount Due 3rd Period |
E A |
|
| HAMTDUEAG4 |
146 |
BCD*10.3 |
HDR Amount Due 4th Period |
E A |
|
| HAMTDUEFWD |
147 |
BCD*10.3 |
HDR Amount Due Forward Balance |
E A |
|
| RBCNAME |
148 |
String*60 |
Remit-To Name |
E A |
|
| RBCSTREET1 |
149 |
String*60 |
Remit-To Address 1 |
E A |
|
| RBCSTREET2 |
150 |
String*60 |
Remit-To Address 2 |
E A |
|
| RBCSTREET3 |
151 |
String*60 |
Remit-To Address 3 |
E A |
|
| RBCSTREET4 |
152 |
String*60 |
Remit-To Address 4 |
E A |
|
| RBCCITY |
153 |
String*30 |
Remit-To City |
E A |
|
| RBCSTATE |
154 |
String*30 |
Remit-To State/Prov. |
E A |
|
| RBCPSTCDE |
155 |
String*20 |
Remit-To Zip/Postal Code |
E A |
|
| RBCCNTYCDE |
156 |
String*30 |
Remit-To Country |
E A |
|
| CUSDECIMAL |
157 |
Integer |
Customer Currency Decimal |
E A |
|
| CURSYMBOL |
158 |
String*4 |
Customer Currency Symbol |
E A |
|
| VALUES |
159 |
Long |
Optional Fields |
E A C |
|
|