| VENDORID |
String*12 |
Vendor Number |
Mask: %-12C |
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| SHORTNAME |
String*10 |
Short Name |
|
| IDGRP |
String*6 |
Group Code |
Mask: %-6N |
| SWACTV |
Integer |
Status |
List: 2 entries
|
| DATEINAC |
Date |
Inactive Date |
|
| DATELASTMN |
Date |
Date Last Maintained |
|
| SWHOLD |
Integer |
On Hold |
List: 2 entries
|
| DATESTART |
Date |
Start Date |
|
| IDPPNT |
String*12 |
Participant ID |
|
| VENDNAME |
String*60 |
Vendor 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 |
|
| CODESTTE |
String*30 |
State/Prov. |
|
| CODEPSTL |
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 |
| PRIMRMIT |
String*6 |
Primary Remit-To Location |
Mask: %-6N |
| IDACCTSET |
String*6 |
Account Set |
Mask: %-6N |
| CURNCODE |
String*3 |
Currency Code |
Mask: %-3N |
| RATETYPE |
String*2 |
Rate Type |
Mask: %-2N |
| BANKID |
String*8 |
Bank Code |
Mask: %-8N |
| PRTSEPCHKS |
Integer |
Print Separate Checks |
List: 2 entries
| 0 | = | Do Not Print Separate Checks | | 1 | = | Print Separate Checks |
|
| DISTSETID |
String*6 |
Distribution Set |
Mask: %-6N |
| DISTCODE |
String*6 |
Distribution Code |
Mask: %-6N |
| GLACCNT |
String*45 |
G/L Account |
Mask: %-45C |
| TERMSCODE |
String*6 |
Terms |
Mask: %-6N |
| DUPINVCCD |
Integer |
Reserved |
|
| DUPAMTCODE |
Integer |
Duplicate Amount Code |
List: 3 entries
|
| DUPDATECD |
Integer |
Duplicate Date Code |
List: 3 entries
|
| CODETAXGRP |
String*12 |
Tax Group |
Mask: %-12N |
| TAXCLASS1 |
Integer |
Tax Class Code 1 |
|
| TAXCLASS2 |
Integer |
Tax Class Code 2 |
|
| TAXCLASS3 |
Integer |
Tax Class Code 3 |
|
| TAXCLASS4 |
Integer |
Tax Class Code 4 |
|
| TAXCLASS5 |
Integer |
Tax Class Code 5 |
|
| TAXRPTSW |
Integer |
Tax Reporting Type |
List: 3 entries
|
| SUBJTOWTHH |
Integer |
Reserved |
|
| TAXNBR |
String*20 |
1099/CPRS Tax Number |
|
| TAXIDTYPE |
Integer |
Tax Type |
List: 6 entries
| 0 | = | Unknown | | 1 | = | Social Security Number | | 2 | = | Employer ID Number | | 3 | = | GST Registration Number | | 4 | = | Business Number | | 5 | = | Social Insurance Number |
|
| TAXNOTE2SW |
Integer |
Reserved |
|
| CLASID |
String*6 |
1099/CPRS Code |
Mask: %-6N |
| AMTCRLIMT |
BCD*10.3 |
Credit Limit |
|
| AMTBALDUET |
BCD*10.3 |
Balance Due in Vendor Currency |
|
| AMTBALDUEH |
BCD*10.3 |
Balance Due in Func. Currency |
|
| AMTPPDINVT |
BCD*10.3 |
Total Prepaid Invoice Vend. Curr. |
|
| AMTPPDINVH |
BCD*10.3 |
Total Prepaid Invoice Func. Curr. |
|
| DTLASTRVAL |
Date |
Date of Last Revaluation |
|
| AMTBALLARV |
BCD*10.3 |
Last Revaluation Balance |
|
| CNTOPENINV |
BCD*4.0 |
Number of Open Invoices |
|
| CNTPPDINVC |
BCD*4.0 |
Number of Prepaid Invoices |
|
| CNTINVPAID |
BCD*4.0 |
Number of Paid Invoices |
|
| DAYSTOPAY |
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 Balance Last Yr. |
|
| DATELASTAC |
Date |
Date of Last Activity |
|
| DATELASTIV |
Date |
Date of Last Invoice |
|
| DATELASTCR |
Date |
Date of Last Credit Note |
|
| DATELASTDR |
Date |
Date of Last Debit Note |
|
| DATELASTPA |
Date |
Date of Last Payment |
|
| DATELASTDI |
Date |
Date of Last Discount |
|
| DATELSTADJ |
Date |
Date of Last Adjustment |
|
| IDINVCHI |
String*22 |
Number of Largest Invoice |
Mask: %-22C |
| IDINVCHILY |
String*22 |
Number of Largest Invoice Last Yr. |
Mask: %-22C |
| AMTINVHIT |
BCD*10.3 |
Largest Invoice - Vend. Curr. |
|
| AMTBALHIT |
BCD*10.3 |
Highest Balance - Vend. Curr. |
|
| AMTWTHTCUR |
BCD*10.3 |
Reserved |
|
| AMTINVHILT |
BCD*10.3 |
Larg. Inv. Last Yr. Vend. Curr. |
|
| AMTBALHILT |
BCD*10.3 |
High Bal. Last Yr. - Vend. Curr. |
|
| AMTWTHLYTC |
BCD*10.3 |
Reserved |
|
| AMTLASTIVT |
BCD*10.3 |
Last Invoice Amt - Vend. Curr. |
|
| AMTLASTCRT |
BCD*10.3 |
Last Cr. Note Amt. - Vend. Curr. |
|
| AMTLASTDRT |
BCD*10.3 |
Last Dr. Note Amt. - Vend. Curr. |
|
| AMTLASTPYT |
BCD*10.3 |
Last Payment - Vend. Curr. |
|
| AMTLASTDIT |
BCD*10.3 |
Last Discount Amt. - Vend. Curr. |
|
| AMTLASTADT |
BCD*10.3 |
Last Adj. Amt. - Vend. Curr. |
|
| AMTINVHIH |
BCD*10.3 |
Largest Invoice - Func. Curr. |
|
| AMTBALHIH |
BCD*10.3 |
Highest Balance - Func. Curr. |
|
| AMTWTHHCUR |
BCD*10.3 |
Reserved |
|
| AMTINVHILH |
BCD*10.3 |
Larg. Inv. Last Yr. Func. Curr. |
|
| AMTBALHILH |
BCD*10.3 |
High Bal. Last Yr. Func. Curr. |
|
| AMTWTHLYHC |
BCD*10.3 |
Reserved |
|
| AMTLASTIVH |
BCD*10.3 |
Last Invoice Amt. - Func. Curr. |
|
| AMTLASTCRH |
BCD*10.3 |
Last Cr. Note Amt. - Func. Curr. |
|
| AMTLASTDRH |
BCD*10.3 |
Last Dr. Note Amt. - Func. Curr. |
|
| AMTLASTPYH |
BCD*10.3 |
Last Payment - Func. Curr. |
|
| AMTLASTDIH |
BCD*10.3 |
Last Discount Amt. - Func. Curr. |
|
| AMTLASTADH |
BCD*10.3 |
Last Adj. Amt. - Func. Curr. |
|
| PAYMCODE |
String*12 |
Payment Code |
Mask: %-12N |
| IDTAXREGI1 |
String*20 |
Tax Registration Code 1 |
|
| IDTAXREGI2 |
String*20 |
Tax Registration Code 2 |
|
| IDTAXREGI3 |
String*20 |
Tax Registration Code 3 |
|
| IDTAXREGI4 |
String*20 |
Tax Registration Code 4 |
|
| IDTAXREGI5 |
String*20 |
Tax Registration Code 5 |
|
| SWDISTBY |
Integer |
Distribution Type |
List: 4 entries
| 0 | = | Distribution Set | | 1 | = | Distribution Code | | 2 | = | G/L Account | | 3 | = | None |
|
| CODECHECK |
String*3 |
Check Language |
List: 7 entries
| 1 | = | ENG | | 2 | = | FRA | | 3 | = | ESN | | 4 | = | AUS | | 5 | = | MEX | | 6 | = | CHN | | 7 | = | CHT |
|
| AVGDAYSPAY |
BCD*5.1 |
Average Days to Pay |
|
| AVGPAYMENT |
BCD*10.3 |
Reserved |
|
| AMTINVPDHC |
BCD*10.3 |
Total Invoices Paid - Func. Curr. |
|
| AMTINVPDTC |
BCD*10.3 |
Total Invoices Paid - Vend. Curr. |
|
| CNTNBRCHKS |
BCD*4.0 |
Total Number of Payments |
|
| SWTXINC1 |
Integer |
Tax Included 1 |
List: 2 entries
|
| SWTXINC2 |
Integer |
Tax Included 2 |
List: 2 entries
|
| SWTXINC3 |
Integer |
Tax Included 3 |
List: 2 entries
|
| SWTXINC4 |
Integer |
Tax Included 4 |
List: 2 entries
|
| SWTXINC5 |
Integer |
Tax Included 5 |
List: 2 entries
|
| EMAIL1 |
String*50 |
Contact's E-mail |
|
| EMAIL2 |
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 |
| DELMETHOD |
Integer |
Delivery Method |
List: 3 entries
| 0 | = | Mail | | 2 | = | E-mail | | 4 | = | Contact's E-mail |
|
| RTGPERCENT |
BCD*5.5 |
Percent Retained |
|
| RTGDAYS |
Integer |
Days Retained |
|
| RTGTERMS |
String*6 |
Retainage Terms Code |
Mask: %-6N |
| RTGAMTTC |
BCD*10.3 |
Amount Retained - Vend. Curr. |
|
| RTGAMTHC |
BCD*10.3 |
Amount Retained - Func. Curr. |
|
| VALUES |
Long |
Optional Fields |
|
| NEXTCUID |
Long |
Next Client Unique ID |
|
|