| IDVEND |
String*12 |
Vendor Number |
Mask: %-12C |
| IDINVC |
String*22 |
Document Number |
Mask: %-22C |
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| IDRMIT |
String*12 |
Check Number |
Mask: %-12D |
| IDORDERNBR |
String*22 |
Order Number |
Mask: %-22C |
| IDPONBR |
String*22 |
PO Number |
Mask: %-22C |
| DATEINVCDU |
Date |
Due Date |
|
| IDRMITTO |
String*6 |
Remit-To Location |
Mask: %-6N |
| IDTRXTYPE |
Integer |
Transaction Type |
List: 8 entries
| 12 | = | Invoice - Summary Entered | | 13 | = | Invoice - Recurring Charge | | 22 | = | Debit Note - Summary Entered | | 26 | = | Debit Note - Advance Credit Claim | | 32 | = | Credit Note - Summary Entered | | 40 | = | Interest Charge | | 50 | = | Prepayment - Posted | | 51 | = | Payment - Posted |
|
| TXTTRXTYPE |
Integer |
Document Type |
List: 6 entries
| 1 | = | Invoice | | 2 | = | Debit Note | | 3 | = | Credit Note | | 4 | = | Interest | | 10 | = | Prepayment | | 11 | = | Payment |
|
| DATEBTCH |
Date |
Batch Date |
|
| CNTBTCH |
BCD*5.0 |
Batch Number |
|
| CNTITEM |
BCD*4.0 |
Entry Number |
|
| IDVENDGRP |
String*6 |
Group Code |
Mask: %-6N |
| DESCINVC |
String*60 |
Doc. Description |
|
| DATEINVC |
Date |
Doc. Date |
|
| DATEASOF |
Date |
Invoice as-of Date |
|
| CODETERM |
String*6 |
Terms |
Mask: %-6N |
| DATEDISC |
Date |
Discount Date |
|
| CODECURN |
String*3 |
Currency Code |
Mask: %-3N |
| IDRATETYPE |
String*2 |
Rate Type |
Mask: %-2N |
| SWRATEOVRD |
Integer |
Rate Overridden |
List: 2 entries
|
| EXCHRATEHC |
BCD*8.7 |
Exchange Rate |
|
| AMTINVCHC |
BCD*10.3 |
Func. Currency Invoice Amount |
|
| AMTDUEHC |
BCD*10.3 |
Func. Currency Amount Due |
|
| AMTTXBLHC |
BCD*10.3 |
Func. Currency Taxable Amount |
|
| AMTNONTXHC |
BCD*10.3 |
Func. Currency Non-Taxable Amt. |
|
| AMTTAXHC |
BCD*10.3 |
Func. Currency Tax Amount |
|
| AMTDISCHC |
BCD*10.3 |
Func. Currency Discount Amount |
|
| AMTINVCTC |
BCD*10.3 |
Vend. Currency Invoice Amount |
|
| AMTDUETC |
BCD*10.3 |
Vend. Currency Amount Due |
|
| AMTTXBLTC |
BCD*10.3 |
Vend. Currency Taxable Amount |
|
| AMTNONTXTC |
BCD*10.3 |
Vend. Currency Non-Taxable Amt. |
|
| AMTTAXTC |
BCD*10.3 |
Vend. Currency Tax Amount |
|
| AMTDISCTC |
BCD*10.3 |
Vend. Currency Discount Amount |
|
| SWPAID |
Integer |
Fully Paid |
List: 2 entries
|
| DATELSTACT |
Date |
Last Activity Date |
|
| DATELSTSTM |
Date |
Last Statement Date |
|
| CNTTOTPAYM |
BCD*3.0 |
Number of Scheduled Payments |
|
| CNTLSTPAYM |
BCD*3.0 |
Reserved - Last Payment Number Paid |
|
| CNTLSTPYST |
BCD*3.0 |
Payment Number on Last Statement |
|
| AMTREMIT |
BCD*10.3 |
Reserved - Payment Amount |
|
| CNTLASTSCH |
BCD*3.0 |
Last Applied Payment Seq. No. |
|
| SWTAXOVRD |
Integer |
Tax Amount Control |
List: 3 entries
| 0 | = | Enter | | 1 | = | Calculate | | 2 | = | Distribute |
|
| CODETAX1 |
String*12 |
Tax Auth. 1 |
Mask: %-12N |
| CODETAX2 |
String*12 |
Tax Auth. 2 |
Mask: %-12N |
| CODETAX3 |
String*12 |
Tax Auth. 3 |
Mask: %-12N |
| CODETAX4 |
String*12 |
Tax Auth. 4 |
Mask: %-12N |
| CODETAX5 |
String*12 |
Tax Auth. 5 |
Mask: %-12N |
| AMTBASE1HC |
BCD*10.3 |
Func. Base Amount 1 |
|
| AMTBASE2HC |
BCD*10.3 |
Func. Base Amount 2 |
|
| AMTBASE3HC |
BCD*10.3 |
Func. Base Amount 3 |
|
| AMTBASE4HC |
BCD*10.3 |
Func. Base Amount 4 |
|
| AMTBASE5HC |
BCD*10.3 |
Func. Base Amount 5 |
|
| AMTTAX1HC |
BCD*10.3 |
Func. Tax Amount 1 |
|
| AMTTAX2HC |
BCD*10.3 |
Func. Tax Amount 2 |
|
| AMTTAX3HC |
BCD*10.3 |
Func. Tax Amount 3 |
|
| AMTTAX4HC |
BCD*10.3 |
Func. Tax Amount 4 |
|
| AMTTAX5HC |
BCD*10.3 |
Func. Tax Amount 5 |
|
| AMTBASE1TC |
BCD*10.3 |
Vend. Base Amount 1 |
|
| AMTBASE2TC |
BCD*10.3 |
Vend. Base Amount 2 |
|
| AMTBASE3TC |
BCD*10.3 |
Vend. Base Amount 3 |
|
| AMTBASE4TC |
BCD*10.3 |
Vend. Base Amount 4 |
|
| AMTBASE5TC |
BCD*10.3 |
Vend. Base Amount 5 |
|
| AMTTAX1TC |
BCD*10.3 |
Vend. Tax Amount 1 |
|
| AMTTAX2TC |
BCD*10.3 |
Vend. Tax Amount 2 |
|
| AMTTAX3TC |
BCD*10.3 |
Vend. Tax Amount 3 |
|
| AMTTAX4TC |
BCD*10.3 |
Vend. Tax Amount 4 |
|
| AMTTAX5TC |
BCD*10.3 |
Vend. Tax Amount 5 |
|
| FISCYR |
String*4 |
Fiscal Year |
Mask: %04D |
| FISCPER |
String*2 |
Fiscal Period |
Mask: %02D |
| IDPREPAY |
String*22 |
Prepay Invoice Number |
Mask: %-22C |
| DATEBUS |
Date |
Posting Date |
|
| ID1099CLAS |
String*6 |
1099/CPRS Code |
Mask: %-6N |
| AMT1099ORG |
BCD*10.3 |
1099/CPRS Original Amount |
|
| AMT1099REM |
BCD*10.3 |
1099/CPRS Remaining Amount |
|
| RATEDATE |
Date |
Rate Date |
|
| RATEOP |
Integer |
Rate Operator |
|
| YPLASTACT |
String*6 |
Last Activity Year/Period |
|
| IDBANK |
String*8 |
Bank Code |
Mask: %-8N |
| LONGSERIAL |
Long |
Check Serial Number |
|
| POSTSEQNCE |
BCD*5.0 |
Posting Sequence No. |
|
| SWJOB |
Integer |
Job Related |
List: 2 entries
|
| SWRTG |
Integer |
Has Retainage |
List: 2 entries
|
| SWRTGOUT |
Integer |
Retainage Outstanding |
List: 2 entries
|
| RTGDATEDUE |
Date |
Date Retainage Due |
|
| RTGOAMTHC |
BCD*10.3 |
Func. Curr. Orig. Rtng. Amt. |
|
| RTGAMTHC |
BCD*10.3 |
Func. Curr. Retainage Amount |
|
| RTGOAMTTC |
BCD*10.3 |
Vend. Curr. Orig. Rtng. Amt. |
|
| RTGAMTTC |
BCD*10.3 |
Vend. Curr. Retainage Amount |
|
| RTGTERMS |
String*6 |
Retainage Terms Code |
Mask: %-6N |
| SWRTGRATE |
Integer |
Retainage Exchange Rate |
List: 2 entries
| 0 | = | Use Original Document Exchange Rate | | 1 | = | Use Current Exchange Rate |
|
| RTGAPPLYTO |
String*22 |
Original Doc. No. |
Mask: %-22C |
| VALUES |
Long |
Optional Fields |
|
| SRCEAPPL |
String*2 |
Source Application |
Mask: %-2A |
| SWPYSTTS |
Integer |
Payment Status |
List: 3 entries
| 0 | = | Normal | | 1 | = | On Hold | | 2 | = | Forced |
|
| DATEPYSTTS |
Date |
Date Payment Status Changed |
|
| APVERSION |
String*3 |
A/P Version Created In |
|
| TYPEBTCH |
String*2 |
Batch Type |
Mask: %-2N |
| CNTOBLJ |
Long |
Number of OBLJ Details |
|
| CODECURNRC |
String*3 |
Tax Reporting Currency Code |
|
| RATERC |
BCD*8.7 |
Tax Reporting Exchange Rate |
|
| RATETYPERC |
String*2 |
Tax Reporting Rate Type |
|
| RATEDATERC |
Date |
Tax Reporting Rate Date |
|
| RATEOPRC |
Integer |
Tax Reporting Rate Operator |
|
| SWRATERC |
Integer |
Tax Reporting Rate Override |
List: 2 entries
|
| SWTXRTGRPT |
Integer |
Report Retainage Tax |
|
| CODETAXGRP |
String*12 |
Tax Group |
|
| TAXVERSION |
Long |
Tax State Version |
|
| SWTXBSECTL |
Integer |
Tax Base Calculate Method |
|
| SWTXCTLRC |
Integer |
Tax Reporting Calculate Method |
|
| TAXCLASS1 |
Integer |
Tax Class 1 |
|
| TAXCLASS2 |
Integer |
Tax Class 2 |
|
| TAXCLASS3 |
Integer |
Tax Class 3 |
|
| TAXCLASS4 |
Integer |
Tax Class 4 |
|
| TAXCLASS5 |
Integer |
Tax Class 5 |
|
| SWTAXINCL1 |
Integer |
Tax Included 1 |
List: 2 entries
|
| SWTAXINCL2 |
Integer |
Tax Included 2 |
List: 2 entries
|
| SWTAXINCL3 |
Integer |
Tax Included 3 |
List: 2 entries
|
| SWTAXINCL4 |
Integer |
Tax Included 4 |
List: 2 entries
|
| SWTAXINCL5 |
Integer |
Tax Included 5 |
List: 2 entries
|
| TXBSERT1TC |
BCD*10.3 |
Tax Base 1 |
|
| TXBSERT2TC |
BCD*10.3 |
Tax Base 2 |
|
| TXBSERT3TC |
BCD*10.3 |
Tax Base 3 |
|
| TXBSERT4TC |
BCD*10.3 |
Tax Base 4 |
|
| TXBSERT5TC |
BCD*10.3 |
Tax Base 5 |
|
| TXAMTRT1TC |
BCD*10.3 |
Tax Amount 1 |
|
| TXAMTRT2TC |
BCD*10.3 |
Tax Amount 2 |
|
| TXAMTRT3TC |
BCD*10.3 |
Tax Amount 3 |
|
| TXAMTRT4TC |
BCD*10.3 |
Tax Amount 4 |
|
| TXAMTRT5TC |
BCD*10.3 |
Tax Amount 5 |
|
| DATEFRSTBK |
Date |
Earliest Backdated Activity Date |
|
| DATELSTRVL |
Date |
Last Revaluation Date |
|
| ORATE |
BCD*8.7 |
Orig. Exchange Rate |
|
| ORATETYPE |
String*2 |
Orig. Rate Type |
|
| ORATEDATE |
Date |
Orig. Rate Date |
|
| ORATEOP |
Integer |
Orig. Rate Operator |
|
| OSWRATE |
Integer |
Orig. Rate Override Flag |
List: 2 entries
|
| IDACCTSET |
String*6 |
Account Set |
Mask: %-6N |
| DATEPAID |
Date |
Date Paid |
|
|