| IDNATACCT |
String*12 |
National Account Number |
Mask: %-12C |
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| IDGRP |
String*6 |
Group Code |
Mask: %-6N |
| SWACTV |
Integer |
Status |
List:2 entries
|
| DATEINAC |
Date |
Inactive Date |
|
| DATELSTMTN |
Date |
Date Last Maintained |
|
| SWHOLD |
Integer |
On Hold |
List:2 entries
|
| CODEDAB |
String*9 |
Credit Bureau Number |
|
| DABRTG |
String*5 |
Credit Bureau Rating |
|
| DATEDAB |
Date |
Credit Bureau Date |
|
| NAMEACCT |
String*60 |
National Account Name |
|
| TEXTSTRE1 |
String*60 |
Address Line 1 |
|
| TEXTSTRE2 |
String*60 |
Address Line 2 |
|
| TEXTSTRE3 |
String*60 |
Address Line 3 |
|
| TEXTSTRE4 |
String*60 |
Address Line 4 |
|
| NAMECITY |
String*30 |
City |
|
| CODESTATE |
String*30 |
State/Prov. |
|
| CODEPOST |
String*20 |
Zip/Postal Code |
|
| CODECTRY |
String*30 |
Country |
|
| NAMECTAC |
String*60 |
Contact Name |
|
| TEXTPHON1 |
String*30 |
Phone Number |
Mask: (%-3C) %-3C-%-24C |
| TEXTPHON2 |
String*30 |
Fax Number |
Mask: (%-3C) %-3C-%-24C |
| IDACCTSET |
String*6 |
Account Set |
Mask: %-6N |
| IDAUTOCASH |
String*6 |
Autocash Profile |
|
| IDBILLCYCL |
String*6 |
Billing Cycle |
Mask: %-6N |
| IDSVCCHRG |
String*6 |
Interest Profile |
Mask: %-6N |
| IDDLNQ |
String*6 |
Reserved |
|
| CODECURN |
String*3 |
Currency Code |
Mask: %-3N |
| SWPRTSTMT |
Integer |
Print Statements |
List:2 entries
|
| SWPRTDLNQ |
Integer |
Reserved |
|
| SWBALFWD |
Integer |
Account Type |
List:2 entries
| 0 |
= |
Open Item |
| 1 |
= |
Balance Forward |
|
| IDRATETYPE |
String*2 |
Rate Type |
Mask: %-2N |
| AMTCRLIMIT |
BCD*10.3 |
Credit Limit |
|
| AMTBALDUTC |
BCD*10.3 |
Balance Due in Cust. Currency |
|
| AMTBALDUHC |
BCD*10.3 |
Balance Due in Func. Currency |
|
| DATELSTSTM |
Date |
Date of Last Statement |
|
| AMTLSTSTTC |
BCD*10.3 |
Last Statement Total Cust. Curr. |
|
| AMTLSTSTHC |
BCD*10.3 |
Last Statement Total Func. Curr. |
|
| DATEBALFWD |
Date |
Date Balance Forward Begins |
|
| AMTBLFWDTC |
BCD*10.3 |
Balance Forward Cust. Curr. |
|
| AMTBLFWDHC |
BCD*10.3 |
Balance Forward Func. Curr. |
|
| DATERVAL |
Date |
Reserved |
|
| AMTLSTRVAL |
BCD*10.3 |
Reserved |
|
| CNTOPENINV |
BCD*4.0 |
Number of Open Documents |
|
| CNTINVPAID |
BCD*4.0 |
Number of Paid Invoices |
|
| CNTDAYSPAY |
BCD*4.0 |
Number of Days to Pay |
|
| DATEINVCHI |
Date |
Date of Largest Invoice |
|
| DATEBALHI |
Date |
Date of Highest Balance |
|
| DATEINVHIL |
Date |
Date of Largest Invoice Last Yr. |
|
| DATEBALHIL |
Date |
Date of Highest Bal. Last Yr. |
|
| DATELASTAC |
Date |
Date of Last Activity |
|
| DATELASTIN |
Date |
Date of Last Invoice |
|
| DATELASTCR |
Date |
Date of Last Credit Note |
|
| DATELASTDR |
Date |
Date of Last Debit Note |
|
| DATELASTPA |
Date |
Date of Last Receipt |
|
| DATELASTDI |
Date |
Date of Last Discount |
|
| DATELASTAD |
Date |
Date of Last Adjustment |
|
| DATELASTWR |
Date |
Date of Last Write-Off |
|
| DATELASTRI |
Date |
Date of Last Returned Check |
|
| DATELSTINT |
Date |
Date of Last Interest Charge |
|
| DATELASTDL |
Date |
Reserved |
|
| IDINVCHIGH |
String*22 |
Largest Invoice Number |
|
| IDINVCHILY |
String*22 |
Largest Invoice Number Last Yr. |
|
| AMTINVHITC |
BCD*10.3 |
Largest Invoice - Cust. Curr. |
|
| AMTBALHITC |
BCD*10.3 |
Highest Balance - Cust. Curr. |
|
| AMTINVHLIT |
BCD*10.3 |
Lgst. Inv. Last Yr. Cust. Curr. |
|
| AMTBALHILT |
BCD*10.3 |
High Bal. Last Yr. - Cust. Curr. |
|
| AMTINVTC |
BCD*10.3 |
Last Invoice Amt. - Cust. Curr. |
|
| AMTCRTC |
BCD*10.3 |
Last Cr. Note Amt. - Cust. Curr. |
|
| AMTDRTC |
BCD*10.3 |
Last Dr. Note Amt. - Cust. Curr. |
|
| AMTPAYMTC |
BCD*10.3 |
Last Receipt - Cust. Curr. |
|
| AMTDISCTC |
BCD*10.3 |
Last Discount Amt. - Cust. Curr. |
|
| AMTADJTC |
BCD*10.3 |
Last Adj. Amt. - Cust. Curr. |
|
| AMTWROFTC |
BCD*10.3 |
Last Write-Off Amt. Cust. Curr. |
|
| AMTRIFTC |
BCD*10.3 |
Last Ret'd. Chk. Amt. Cust. Curr. |
|
| AMTINTTTC |
BCD*10.3 |
Last Int. Charge - Cust. Curr. |
|
| AMTINVHIHC |
BCD*10.3 |
Largest Invoice - Func. Curr. |
|
| AMTBALHIHC |
BCD*10.3 |
Highest Balance - Func. Curr. |
|
| AMTINVHILH |
BCD*10.3 |
Lgst. Inv. Last Yr. Func. Curr. |
|
| AMTBALHILH |
BCD*10.3 |
High Bal. Last Yr. - Func. Curr. |
|
| AMTINVHC |
BCD*10.3 |
Last Invoice Amt. - Func. Curr. |
|
| AMTCRHC |
BCD*10.3 |
Last Cr. Note Amt. - Func. Curr. |
|
| AMTDRHC |
BCD*10.3 |
Last Dr. Note Amt. - Func. Curr. |
|
| AMTPAYMHC |
BCD*10.3 |
Last Receipt - Func. Curr. |
|
| AMTDISCHC |
BCD*10.3 |
Last Discount Amt. - Func. Curr. |
|
| AMTADJHC |
BCD*10.3 |
Last Adj. Amt. - Func. Curr. |
|
| AMTWROFHC |
BCD*10.3 |
Last Write-Off Amt. Func. Curr. |
|
| AMTRIFHC |
BCD*10.3 |
Last Ret'd. Chk. Amt. Func. Curr |
|
| AMTINTTHC |
BCD*10.3 |
Last Int. Charge - Func. Curr. |
|
| EMAIL |
String*50 |
E-mail |
|
| WEBSITE |
String*100 |
Web Site |
|
| CTACPHONE |
String*30 |
Contact's Phone |
Mask: (%-3C) %-3C-%-24C |
| CTACFAX |
String*30 |
Contact's Fax |
Mask: (%-3C) %-3C-%-24C |
| CTACEMAIL |
String*50 |
Contact's E-mail |
|
| DELMETHOD |
Integer |
Delivery Method |
List:4 entries
| 0 |
= |
Mail |
| 2 |
= |
Email (national account) |
| 4 |
= |
Email (contact) |
| 5 |
= |
Email (multiple contacts) |
|
| RTGAMTTC |
BCD*10.3 |
Amount Retained - Cust. Curr. |
|
| RTGAMTHC |
BCD*10.3 |
Amount Retained - Func. Curr. |
|
| VALUES |
Long |
Optional Fields |
|
| DATELASTRF |
Date |
Date of Last Refund. |
|
| AMTLASTRFT |
BCD*10.3 |
Last Refund Amt. - Cust. Curr. |
|
| AMTLASTRFH |
BCD*10.3 |
Last Refund Amt. - Func. Curr. |
|
| SWCHKLIMIT |
Integer |
Check Credit Limit |
List:2 entries
|
| SWCHKOVER |
Integer |
Check Overdue Amounts |
List:2 entries
|
| OVERDAYS |
Integer |
Days Overdue |
|
| OVERAMT |
BCD*10.3 |
Amount Overdue |
|
|