| 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 |
|
|
| IDCUST |
String*12 |
Customer No. |
Mask: %-12C |
| IDINVC |
String*22 |
Document No. |
Mask: %-22C |
| CNTPAYM |
BCD*3.0 |
Payment No. |
|
| TRANSTYPE |
Integer |
Document Type |
List:10 entries
| 1 |
= |
Invoice |
| 2 |
= |
Debit Note |
| 3 |
= |
Credit Note |
| 4 |
= |
Interest |
| 5 |
= |
Unapplied Cash |
| 10 |
= |
Prepayment |
| 11 |
= |
Receipt |
| 14 |
= |
Adjustment |
| 16 |
= |
Exchange Gain/Loss |
| 19 |
= |
Refund |
|
| TRXTYPE |
Integer |
Transaction Type |
List:30 entries
| 11 |
= |
Invoice - Item Issued |
| 12 |
= |
Invoice - Summary Entered |
| 13 |
= |
Invoice - Recurring Charge |
| 14 |
= |
Invoice - Summary Issued |
| 15 |
= |
Invoice - Item Entered |
| 21 |
= |
Debit Note - Item Issued |
| 22 |
= |
Debit Note - Summary Entered |
| 24 |
= |
Debit Note - Summary Issued |
| 25 |
= |
Debit Note - Item Entered |
| 31 |
= |
Credit Note - Item Issued |
| 32 |
= |
Credit Note - Summary Entered |
| 34 |
= |
Credit Note - Summary Issued |
| 35 |
= |
Credit Note - Item Entered |
| 40 |
= |
Interest Charge |
| 81 |
= |
Adjustment - Posted |
| 80 |
= |
Write-Off - Posted |
| 2 |
= |
Unapplied Cash - Posted |
| 57 |
= |
Prepayment - Posted |
| 3 |
= |
Unapplied Cash - Applied |
| 58 |
= |
Prepayment - Applied |
| 43 |
= |
Credit Note Applied To |
| 44 |
= |
Applied Credit Note |
| 51 |
= |
Receipt - Posted |
| 52 |
= |
Receipt - Applied |
| 53 |
= |
Receipt - Reversed |
| 69 |
= |
Unrealized Exchange Gain/Loss |
| 73 |
= |
Refund - Posted |
| 75 |
= |
Refund - Reversed |
| 65 |
= |
Exchange Gain/Loss - Posted |
| 85 |
= |
Receipt - 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 |
| IDBILLCYC |
String*6 |
Billing Cycle |
Mask: %-6N |
| IDCUSTSHP |
String*6 |
Ship-To Location Code |
Mask: %-6C |
| 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. Receipt Flag |
|
| 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*24 |
Check/Receipt No. |
Mask: %-24C |
| DATEDEPST |
Date |
Deposit Date |
|
| DEPSTNBR |
BCD*8.0 |
Deposit Number |
|
| 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 |
|
| NAMERMIT |
String*60 |
Name on Check |
|
| AMTTC |
BCD*10.3 |
Customer Amount |
|
| AMTHC |
BCD*10.3 |
Functional Amount |
|
| AMTBC |
BCD*10.3 |
Bank Amount |
|
| DEPSEQ |
??? |
Deposit Serial Number |
|
| DEPLINE |
Long |
Deposit Line Number |
|
| PAYMCODE |
String*12 |
Payment Code |
Mask: %-12N |
| PAYMTYPE |
Integer |
Payment Type |
List:6 entries
| 0 |
= |
(None) |
| 1 |
= |
Cash |
| 2 |
= |
Check |
| 3 |
= |
Credit Card |
| 5 |
= |
SPS Credit Card |
| 4 |
= |
Other |
|
| TEXTREF |
String*60 |
Reference |
|
| DATEBUS |
Date |
Posting Date |
|
| REVINVC |
Integer |
Reverse Invoice |
|
| ENTEREDBY |
String*8 |
Entered By |
|
| EDN |
String*30 |
Export Declaration Number |
|
|