TYPEBTCH |
String*2 |
Batch Type |
Mask: %-2N |
POSTSEQNCE |
BCD*5.0 |
Posting Sequence No. |
|
CNTBTCH |
BCD*5.0 |
Batch No. |
|
CNTITEM |
BCD*4.0 |
Entry No. |
|
AUDTDATE |
Date |
|
|
AUDTTIME |
Time |
|
|
AUDTUSER |
String*8 |
|
|
AUDTORG |
String*6 |
|
|
IDVEND |
String*12 |
Vendor No. |
Mask: %-12C |
IDINVC |
String*22 |
Document No. |
Mask: %-22C |
CNTPAYM |
BCD*3.0 |
Payment No. |
|
TRANSTYPE |
Integer |
Document Type |
List: 8 entries
1 | = | Invoice | 2 | = | Debit Note | 3 | = | Credit Note | 4 | = | Interest | 10 | = | Prepayment | 11 | = | Payment | 14 | = | Adjustment | 16 | = | Exchange Gain/Loss |
|
TRXTYPE |
Integer |
Transaction Type |
List: 16 entries
12 | = | Invoice - Summary Entered | 13 | = | Invoice - Recurring Charge | 22 | = | Debit Note - Summary Entered | 32 | = | Credit Note - Summary Entered | 40 | = | Interest Charge | 81 | = | Adjustment - Posted | 57 | = | Prepayment - Posted | 58 | = | Prepayment - Applied | 43 | = | Credit Note Applied To | 44 | = | Applied Credit Note | 51 | = | Payment - Posted | 52 | = | Payment - Applied | 53 | = | Payment - Reversed | 69 | = | Unrealized Exchange Gain/Loss | 65 | = | Exchange Gain/Loss - Posted | 94 | = | Payment - Invoice Reversed |
|
IDGRP |
String*6 |
Group Code |
Mask: %-6N |
IDACCTSET |
String*6 |
Account Set |
Mask: %-6N |
CODETAXGRP |
String*12 |
Tax Group |
Mask: %-12N |
CODETERM |
String*6 |
Terms Code |
Mask: %-6N |
IDRMITTO |
String*6 |
Remit-To Location Code |
Mask: %-6N |
DATEINVC |
Date |
Document Date |
|
DATEDISC |
Date |
Discount Date |
|
DATEDUE |
Date |
Due Date |
|
DATEBTCH |
Date |
Batch Date |
|
PCTDISC |
BCD*5.5 |
Discount Percentage |
|
SWNONRCVBL |
Integer |
Misc. Payment Flag |
|
SWSTATUS |
Integer |
Payment Edited Flag |
List: 2 entries
|
GLBATCH |
String*6 |
G/L Batch No. |
|
GLENTRY |
String*5 |
G/L Entry No. |
|
CNTADJNBR |
BCD*5.0 |
Adjustment Number |
|
FISCYR |
String*4 |
Fiscal Year |
Mask: %04D |
FISCPER |
String*2 |
Fiscal Period |
Mask: %02D |
IDINVCAPPL |
String*22 |
Apply-To Doc. No. |
Mask: %-22C |
DESC |
String*60 |
Description |
|
IDBANK |
String*8 |
Bank Code |
Mask: %-8N |
IDRMIT |
String*12 |
Check/Receipt No. |
Mask: %-12D |
LONGSERIAL |
Long |
Serial Number |
|
MISCRMITTO |
String*60 |
Misc. Payment Remit-To |
|
CODECURNTC |
String*3 |
Currency Code (Source) |
Mask: %-3N |
RATETYPETC |
String*2 |
Rate Type (Source->Functional) |
Mask: %-2N |
RATEDATETC |
Date |
Rate Date (Source->Functional) |
|
RATEEXCHTC |
BCD*8.7 |
Exchange Rate (Source->Functional) |
|
RATEOPTC |
Integer |
Rate Operator (Source->Functional) |
|
SWRATETC |
Integer |
Rate Override (Source) |
|
CODECURNBC |
String*3 |
Currency Code (Bank) |
Mask: %-3N |
RATETYPEBC |
String*2 |
Rate Type (Bank->Functional) |
Mask: %-2N |
RATEDATEBC |
Date |
Rate Date (Bank->Functional) |
|
RATEEXCHBC |
BCD*8.7 |
Exchange Rate (Bank->Functional) |
|
RATEOPBC |
Integer |
Rate Operator (Bank->Functional) |
|
SWRATEBC |
Integer |
Rate Override (Bank) |
|
AMTINVCTC |
BCD*10.3 |
Document Total Less Retainage (Source) |
|
SWJOB |
Integer |
Job Related |
|
SWRTG |
Integer |
Retainage Invoice Flag |
List: 2 entries
|
RTGTERMS |
String*6 |
Retainage Terms Code |
Mask: %-6N |
RTGDATEDUE |
Date |
Date Retainage Due |
|
SWRTGRATE |
Integer |
Retainage Exchange Rate |
|
RTGAPPLYTO |
String*22 |
Original Doc. No. |
Mask: %-22C |
RTGAMTTC |
BCD*10.3 |
Retainage Amount (Source) |
|
RTGAMTHC |
BCD*10.3 |
Retainage Amount (Functional) |
|
VALUES |
Long |
Optional Fields |
|
ORIGCOMP |
String*6 |
Originator |
Mask: %-6N |
IDDISTSET |
String*6 |
Distribution Set |
Mask: %-6N |
AMTTC |
BCD*10.3 |
Check Amount Vend. Curr. |
|
AMTHC |
BCD*10.3 |
Check Amount Func. Curr. |
|
AMTBC |
BCD*10.3 |
Payment Amount |
|
PAYMCODE |
String*12 |
Payment Code |
Mask: %-12N |
PAYMTYPE |
Integer |
Payment Type |
List: 5 entries
0 | = | | 1 | = | Cash | 2 | = | Check | 3 | = | Credit Card | 4 | = | Other |
|
CCTYPE |
String*12 |
C.C. Type |
Mask: %-12N |
TEXTREF |
String*60 |
Reference |
|
DATEBUS |
Date |
Posting Date |
|
REVINVC |
Integer |
Reverse Invoice |
|
|