| CNTBTCH |
BCD*5.0 |
Batch Number |
|
| CNTITEM |
BCD*4.0 |
Entry Number |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| IDCUST |
String*12 |
Customer Number |
Mask: %-12C |
| IDINVC |
String*22 |
Document Number |
Mask: %-22C |
| IDSHPT |
String*6 |
Ship-To Location Code |
Mask: %-6C |
| SHIPVIA |
String*15 |
Reserved |
|
| SPECINST |
String*60 |
Special Instructions |
|
| TEXTTRX |
Integer |
Document Type |
List: 3 entries
| 1 | = | Invoice | | 2 | = | Debit Note | | 3 | = | Credit Note |
|
| IDTRX |
Integer |
Transaction Type |
List: 14 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 |
|
| INVCSTTS |
Integer |
Reserved |
|
| ORDRNBR |
String*22 |
Order Number |
Mask: %-22C |
| CUSTPO |
String*22 |
PO Number |
Mask: %-22C |
| JOBNBR |
String*15 |
Reserved |
|
| INVCDESC |
String*60 |
Invoice Description |
|
| SWPRTINVC |
Integer |
Invoice Printed |
List: 2 entries
|
| INVCAPPLTO |
String*22 |
Apply-to Document |
Mask: %-22C |
| IDACCTSET |
String*6 |
Account Set |
Mask: %-6N |
| DATEINVC |
Date |
Document Date |
|
| DATEASOF |
Date |
As of Date |
|
| FISCYR |
String*4 |
Fiscal Year |
Mask: %04D |
| FISCPER |
String*2 |
Fiscal Period |
Mask: %02D |
| CODECURN |
String*3 |
Currency Code |
Mask: %-3N |
| RATETYPE |
String*2 |
Rate Type |
Mask: %-2N |
| SWMANRTE |
Integer |
Rate Overridden |
List: 2 entries
|
| EXCHRATEHC |
BCD*8.7 |
Exchange Rate |
|
| ORIGRATEHC |
BCD*8.7 |
Apply-to Exchange Rate |
|
| TERMCODE |
String*6 |
Terms |
Mask: %-6N |
| SWTERMOVRD |
Integer |
Terms Code Overridden |
List: 2 entries
|
| DATEDUE |
Date |
Due Date |
|
| DATEDISC |
Date |
Discount Date |
|
| PCTDISC |
BCD*5.5 |
Discount Percentage |
|
| AMTDISCAVL |
BCD*10.3 |
Discount Amount Available |
|
| LASTLINE |
BCD*3.0 |
Number of Details |
|
| 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 |
|
| SWTAXBL |
Integer |
Taxable |
List: 2 entries
|
| SWMANTX |
Integer |
Do Not Calc. Tax |
List: 2 entries
|
| CODETAXGRP |
String*12 |
Tax Group |
Mask: %-12N |
| 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 |
| TAXSTTS1 |
Integer |
Tax Class 1 |
|
| TAXSTTS2 |
Integer |
Tax Class 2 |
|
| TAXSTTS3 |
Integer |
Tax Class 3 |
|
| TAXSTTS4 |
Integer |
Tax Class 4 |
|
| TAXSTTS5 |
Integer |
Tax Class 5 |
|
| BASETAX1 |
BCD*10.3 |
Tax Base 1 |
|
| BASETAX2 |
BCD*10.3 |
Tax Base 2 |
|
| BASETAX3 |
BCD*10.3 |
Tax Base 3 |
|
| BASETAX4 |
BCD*10.3 |
Tax Base 4 |
|
| BASETAX5 |
BCD*10.3 |
Tax Base 5 |
|
| AMTTAX1 |
BCD*10.3 |
Tax Amount 1 |
|
| AMTTAX2 |
BCD*10.3 |
Tax Amount 2 |
|
| AMTTAX3 |
BCD*10.3 |
Tax Amount 3 |
|
| AMTTAX4 |
BCD*10.3 |
Tax Amount 4 |
|
| AMTTAX5 |
BCD*10.3 |
Tax Amount 5 |
|
| AMTTXBL |
BCD*10.3 |
Taxable Amount |
|
| AMTNOTTXBL |
BCD*10.3 |
Non-Taxable Amount |
|
| AMTTAXTOT |
BCD*10.3 |
Tax Total |
|
| AMTINVCTOT |
BCD*10.3 |
Document Total Before Tax |
|
| AMTPPD |
BCD*10.3 |
Prepayment Amount |
|
| AMTPAYMTOT |
BCD*3.0 |
Number of Scheduled Payments |
|
| AMTPYMSCHD |
BCD*10.3 |
Total Payment Amount Scheduled |
|
| AMTNETTOT |
BCD*10.3 |
Document Total Including Tax |
|
| IDSTDINVC |
String*16 |
Recurring Charge Code |
|
| DATEPRCS |
Date |
Date Generated |
|
| IDPPD |
String*22 |
Prepayment Number |
Mask: %-22C |
| IDBILL |
String*6 |
Recurring Billing Cycle |
|
| SHPTOLOC |
String*60 |
Ship-To Location Name |
|
| SHPTOSTE1 |
String*60 |
Ship-To Address Line 1 |
|
| SHPTOSTE2 |
String*60 |
Ship-To Address Line 2 |
|
| SHPTOSTE3 |
String*60 |
Ship-To Address Line 3 |
|
| SHPTOSTE4 |
String*60 |
Ship-To Address Line 4 |
|
| SHPTOCITY |
String*30 |
Ship-To City |
|
| SHPTOSTTE |
String*30 |
Ship-To State/Prov. |
|
| SHPTOPOST |
String*20 |
Ship-To Zip/Postal Code |
|
| SHPTOCTRY |
String*30 |
Ship-To Country |
|
| SHPTOCTAC |
String*60 |
Ship-To Contact Name |
|
| SHPTOPHON |
String*30 |
Ship-To Phone Number |
Mask: %-30c |
| SHPTOFAX |
String*30 |
Ship-To Fax Number |
Mask: %-30c |
| DATERATE |
Date |
Rate Date |
|
| SWPROCPPD |
Integer |
Cust/Natl Over Credit Flag |
List: 4 entries
| 0 | = | Neither over credit limit | | 1 | = | Customer over credit limit | | 2 | = | National over credit limit | | 3 | = | Both over credit limit |
|
| CUROPER |
Integer |
Rate Operator |
List: 2 entries
|
| DRILLAPP |
String*2 |
Drill Down Application Source |
Mask: %-2A |
| DRILLTYPE |
Integer |
Drill Down Type |
|
| DRILLDWNLK |
BCD*10.0 |
Drill Down Link Number |
|
| SHPVIACODE |
String*6 |
Ship Via Code |
Mask: %-6N |
| SHPVIADESC |
String*60 |
Ship Via Description |
|
| SWJOB |
Integer |
Job Related |
List: 2 entries
|
| ERRBATCH |
Long |
Error Batch |
|
| ERRENTRY |
Long |
Error Entry |
|
| EMAIL |
String*50 |
Ship-To E-mail |
|
| CTACPHONE |
String*30 |
Ship-To Contact's Phone |
Mask: %-30c |
| CTACFAX |
String*30 |
Ship-To Contact's Fax |
Mask: %-30c |
| CTACEMAIL |
String*50 |
Ship-To Contact's E-mail |
|
| AMTDSBWTAX |
BCD*10.3 |
Discount Base With Tax |
|
| AMTDSBNTAX |
BCD*10.3 |
Discount Base Without Tax |
|
| AMTDSCBASE |
BCD*10.3 |
Discount Base |
|
| INVCTYPE |
Integer |
Invoice Type |
List: 2 entries
|
| SWRTGINVC |
Integer |
Retainage Invoice |
List: 2 entries
|
| RTGAPPLYTO |
String*22 |
Original Doc. No. |
Mask: %-22C |
| SWRTG |
Integer |
Has Retainage |
List: 2 entries
|
| RTGAMT |
BCD*10.3 |
Retainage Amount |
|
| RTGPERCENT |
BCD*5.5 |
Percent Retained |
|
| RTGDAYS |
Integer |
Days Retained |
|
| RTGDATEDUE |
Date |
Retainage Due Date |
|
| RTGTERMS |
String*6 |
Retainage Terms Code |
Mask: %-6N |
| SWRTGDDTOV |
Integer |
Retainage Due Date Override |
List: 2 entries
|
| SWRTGAMTOV |
Integer |
Retainage Amount Override |
List: 2 entries
|
| SWRTGRATE |
Integer |
Retainage Exchange Rate |
List: 2 entries
| 0 | = | Use Original Document Exchange Rate | | 1 | = | Use Current Exchange Rate |
|
| VALUES |
Long |
Optional Fields |
|
| SRCEAPPL |
String*2 |
Source Application |
Mask: %-2A |
| ARVERSION |
String*3 |
A/R Version Created In |
|
| TAXVERSION |
Long |
Tax State Version |
|
| SWTXRTGRPT |
Integer |
Report Retainage Tax |
|
| CODECURNRC |
String*3 |
Tax Reporting Currency Code |
Mask: %-3N |
| SWTXCTLRC |
Integer |
Tax Reporting Calculate Method |
List: 2 entries
|
| RATERC |
BCD*8.7 |
Tax Reporting Exchange Rate |
|
| RATETYPERC |
String*2 |
Tax Reporting Rate Type |
Mask: %-2N |
| RATEDATERC |
Date |
Tax Reporting Rate Date |
|
| RATEOPRC |
Integer |
Tax Reporting Rate Operator |
List: 2 entries
|
| SWRATERC |
Integer |
Tax Reporting Rate Override |
List: 2 entries
|
| TXAMT1RC |
BCD*10.3 |
Tax Reporting Amount 1 |
|
| TXAMT2RC |
BCD*10.3 |
Tax Reporting Amount 2 |
|
| TXAMT3RC |
BCD*10.3 |
Tax Reporting Amount 3 |
|
| TXAMT4RC |
BCD*10.3 |
Tax Reporting Amount 4 |
|
| TXAMT5RC |
BCD*10.3 |
Tax Reporting Amount 5 |
|
| TXTOTRC |
BCD*10.3 |
Tax Reporting Total |
|
| TXBSERT1TC |
BCD*10.3 |
Retainage Tax Base 1 |
|
| TXBSERT2TC |
BCD*10.3 |
Retainage Tax Base 2 |
|
| TXBSERT3TC |
BCD*10.3 |
Retainage Tax Base 3 |
|
| TXBSERT4TC |
BCD*10.3 |
Retainage Tax Base 4 |
|
| TXBSERT5TC |
BCD*10.3 |
Retainage Tax Base 5 |
|
| TXAMTRT1TC |
BCD*10.3 |
Retainage Tax Amount 1 |
|
| TXAMTRT2TC |
BCD*10.3 |
Retainage Tax Amount 2 |
|
| TXAMTRT3TC |
BCD*10.3 |
Retainage Tax Amount 3 |
|
| TXAMTRT4TC |
BCD*10.3 |
Retainage Tax Amount 4 |
|
| TXAMTRT5TC |
BCD*10.3 |
Retainage Tax Amount 5 |
|
| TXBSE1HC |
BCD*10.3 |
Func. Tax Base 1 |
|
| TXBSE2HC |
BCD*10.3 |
Func. Tax Base 2 |
|
| TXBSE3HC |
BCD*10.3 |
Func. Tax Base 3 |
|
| TXBSE4HC |
BCD*10.3 |
Func. Tax Base 4 |
|
| TXBSE5HC |
BCD*10.3 |
Func. Tax Base 5 |
|
| TXAMT1HC |
BCD*10.3 |
Func. Tax Amount 1 |
|
| TXAMT2HC |
BCD*10.3 |
Func. Tax Amount 2 |
|
| TXAMT3HC |
BCD*10.3 |
Func. Tax Amount 3 |
|
| TXAMT4HC |
BCD*10.3 |
Func. Tax Amount 4 |
|
| TXAMT5HC |
BCD*10.3 |
Func. Tax Amount 5 |
|
| AMTGROSHC |
BCD*10.3 |
Func. Distribution w/ Tax Total |
|
| RTGAMTHC |
BCD*10.3 |
Func. Retainage Amount |
|
| AMTDISCHC |
BCD*10.3 |
Func. Discount Amount |
|
| DISTNETHC |
BCD*10.3 |
Func. Distribution w/o Tax Total |
|
| AMTPPDHC |
BCD*10.3 |
Func. Prepayment Amount |
|
| AMTDUEHC |
BCD*10.3 |
Func. Amount Due |
|
| SWPRTLBL |
Integer |
Label Printed |
List: 2 entries
|
| IDSHIPNBR |
String*22 |
Shipment Number |
Mask: %-22C |
| SWOECOST |
Integer |
Do O/E Costing and Consolidation |
List: 2 entries
|
| ENTEREDBY |
String*8 |
Entered By |
|
| DATEBUS |
Date |
Posting Date |
|
|