| IDCUST |
String*12 |
Customer Number |
Mask: %-12C |
| IDINVC |
String*22 |
Document Number |
Mask: %-22C |
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| IDRMIT |
String*24 |
Check/Receipt No. |
Mask: %-24C |
| IDORDERNBR |
String*22 |
Order Number |
Mask: %-22C |
| IDCUSTPO |
String*22 |
PO Number |
Mask: %-22C |
| DATEDUE |
Date |
Due Date |
|
| IDNATACCT |
String*12 |
National Account Number |
Mask: %-12C |
| IDCUSTSHPT |
String*6 |
Ship-To Location |
Mask: %-6C |
| TRXTYPEID |
Integer |
Transaction Type |
List: 19 entries
| 1 | = | Unapplied Cash - Posted | | 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 | | 26 | = | Debit Note - Advance Credit Claim | | 31 | = | Credit Note - Item Issued | | 32 | = | Credit Note - Summary Entered | | 34 | = | Credit Note - Summary Issued | | 35 | = | Credit Note - Item Entered | | 40 | = | Interest Charge | | 50 | = | Prepayment - Posted | | 51 | = | Receipt - Posted | | 73 | = | Refund - Posted |
|
| TRXTYPETXT |
Integer |
Document Type |
List: 8 entries
| 1 | = | Invoice | | 2 | = | Debit Note | | 3 | = | Credit Note | | 4 | = | Interest | | 5 | = | Unapplied Cash | | 10 | = | Prepayment | | 11 | = | Receipt | | 19 | = | Refund |
|
| DATEBTCH |
Date |
Batch Date |
|
| CNTBTCH |
BCD*5.0 |
Batch Number |
|
| CNTITEM |
BCD*4.0 |
Entry Number |
|
| IDGRP |
String*6 |
Group Code |
Mask: %-6N |
| DESCINVC |
String*60 |
Document Description |
|
| DATEINVC |
Date |
Document Date |
|
| DATEASOF |
Date |
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 |
Cust. Currency Invoice Amount |
|
| AMTDUETC |
BCD*10.3 |
Cust. Currency Amount Due |
|
| AMTTXBLTC |
BCD*10.3 |
Cust. Currency Taxable Amount |
|
| AMTNONTXTC |
BCD*10.3 |
Cust. Currency Non-Taxable Amt. |
|
| AMTTAXTC |
BCD*10.3 |
Cust. Currency Tax Amount |
|
| AMTDISCTC |
BCD*10.3 |
Cust. Currency Discount Amount |
|
| SWPAID |
Integer |
Fully Paid |
List: 2 entries
|
| DATELSTACT |
Date |
Last Activity Date |
|
| DATELSTSTM |
Date |
Last Statement Date |
|
| DATELSTDLQ |
Date |
Reserved |
|
| CODEDLQSTS |
Integer |
Reserved |
|
| CNTTOTPAYM |
BCD*3.0 |
Number of Scheduled Payments |
|
| CNTLSTPAID |
BCD*3.0 |
Reserved - Last Payment Number Paid |
|
| CNTLSTPYST |
BCD*3.0 |
Payment Number on Last Statement |
|
| AMTREMIT |
BCD*10.3 |
Reserved - Receipt Amount |
|
| CNTLASTSEQ |
BCD*3.0 |
Last Applied Payment Seq. No. |
|
| SWTAXINPUT |
Integer |
Tax Override Switch |
List: 2 entries
|
| CODETAX1 |
String*12 |
Tax Authority 1 |
Mask: %-12N |
| CODETAX2 |
String*12 |
Tax Authority 2 |
Mask: %-12N |
| CODETAX3 |
String*12 |
Tax Authority 3 |
Mask: %-12N |
| CODETAX4 |
String*12 |
Tax Authority 4 |
Mask: %-12N |
| CODETAX5 |
String*12 |
Tax Authority 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 |
Cust. Base Amount 1 |
|
| AMTBASE2TC |
BCD*10.3 |
Cust. Base Amount 2 |
|
| AMTBASE3TC |
BCD*10.3 |
Cust. Base Amount 3 |
|
| AMTBASE4TC |
BCD*10.3 |
Cust. Base Amount 4 |
|
| AMTBASE5TC |
BCD*10.3 |
Cust. Base Amount 5 |
|
| AMTTAX1TC |
BCD*10.3 |
Cust. Tax Amount 1 |
|
| AMTTAX2TC |
BCD*10.3 |
Cust. Tax Amount 2 |
|
| AMTTAX3TC |
BCD*10.3 |
Cust. Tax Amount 3 |
|
| AMTTAX4TC |
BCD*10.3 |
Cust. Tax Amount 4 |
|
| AMTTAX5TC |
BCD*10.3 |
Cust. Tax Amount 5 |
|
| CODESLSP1 |
String*8 |
Salesperson 1 |
Mask: %-8N |
| CODESLSP2 |
String*8 |
Salesperson 2 |
Mask: %-8N |
| CODESLSP3 |
String*8 |
Salesperson 3 |
Mask: %-8N |
| CODESLSP4 |
String*8 |
Salesperson 4 |
Mask: %-8N |
| CODESLSP5 |
String*8 |
Salesperson 5 |
Mask: %-8N |
| PCTSASPLT1 |
BCD*5.5 |
Sales-Split Percentage 1 |
|
| PCTSASPLT2 |
BCD*5.5 |
Sales-Split Percentage 2 |
|
| PCTSASPLT3 |
BCD*5.5 |
Sales-Split Percentage 3 |
|
| PCTSASPLT4 |
BCD*5.5 |
Sales-Split Percentage 4 |
|
| PCTSASPLT5 |
BCD*5.5 |
Sales-Split Percentage 5 |
|
| FISCYR |
String*4 |
Fiscal Year |
Mask: %04D |
| FISCPER |
String*2 |
Fiscal Period |
Mask: %02D |
| IDPREPAID |
String*22 |
Prepay. Apply-to Doc. No. |
Mask: %-22C |
| DATEBUS |
Date |
Posting Date |
|
| RATEDATE |
Date |
Rate Date |
|
| RATEOP |
Integer |
Rate Operator |
|
| YPLASTACT |
String*6 |
Last Activity Year/Period |
|
| IDBANK |
String*8 |
Bank Code |
Mask: %-8N |
| DEPSTNBR |
BCD*5.0 |
Deposit 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 |
Cust. Curr. Orig. Rtng. Amt. |
|
| RTGAMTTC |
BCD*10.3 |
Cust. 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 |
| ARVERSION |
String*3 |
A/R Version Created In |
|
| INVCTYPE |
Integer |
Invoice Type |
List: 3 entries
| 0 | = | Not Applicable | | 1 | = | Item | | 2 | = | Summary |
|
| DEPSEQ |
Long |
Deposit Serial Number |
|
| DEPLINE |
Long |
Deposit Line Number |
|
| 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 |
|
| SWTXCTLRC |
Integer |
Tax Reporting Calculate Method |
List: 2 entries
|
| 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 |
|
| 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 |
|
| IDSHIPNBR |
String*22 |
Shipment Number |
Mask: %-22C |
| 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 |
|
|