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 |
|
SWNONRCVBL |
Integer |
Misc. Payment Flag |
|
|