Table: Invoicing Options

Table: ARR02
View: AR0002
Record length: 380
Flags: A R 

Keys: 1

Title  Flags  Fields

Invoicing Options Key  IDR02

Fields: 81

Field  Type  Title  Presentation 

IDR02  String*3  Invoicing Options Key  Mask: %-3N
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
DATELASTMN  Date  Date Last Maintained   
INVCBTCH  BCD*5.0  Next Invoice Batch Number   
TEXTIVPF  String*6  Invoice Prefix  Mask: %-6C
CNTIVPFLEN  BCD*2.0  Invoice Number Length   
CNTIVSEQ  BCD*5.0  Next Invoice Number   
TEXTCRPF  String*6  Credit Note Prefix  Mask: %-6C
CNTCRPFLEN  BCD*2.0  Credit Note Number Length   
CNTCRSEQ  BCD*5.0  Next Credit Note Number   
TEXTDRPF  String*6  Debit Note Prefix  Mask: %-6C
CNTDRPFLEN  BCD*2.0  Debit Note Number Length   
CNTDRSEQ  BCD*5.0  Next Debit Note Number   
TEXTITPF  String*6  Interest Invoice Prefix  Mask: %-6C
CNTITPFLEN  BCD*2.0  Interest Invoice Number Length   
CNTITSEQ  BCD*5.0  Next Interest Invoice Number   
TEXTRCPF  String*6  Recurring Charge Prefix  Mask: %-6C
CNTRCPFLEN  BCD*2.0  Recurring Charge Number Length   
CNTRCSEQ  BCD*5.0  Next Recurring Charge Number   
SWPRTINVC  Integer  Invoice Printing  List: 2 entries
0=No
1=Yes
SWALOWDISC  Integer  Reserved   
SWALOWIVED  Integer  Edit After Invoice Printed  List: 2 entries
0=No
1=Yes
SWALOWIVPS  Integer  Reserved   
SWUSEITCMT  Integer  Use Item Comment as Default  List: 2 entries
0=No
1=Yes
SWDPLYITCS  Integer  Show Item Cost  List: 2 entries
0=No
1=Yes
SWOPFL1  Integer  Use Optional Field 1   
TEXTOPFL1  String*10  Optional Field 1 Title   
CODEOPFL1  String*8  Optional Field 1 Table   
SWOPFL2  Integer  Use Optional Field 2   
TEXTOPFL2  String*10  Optional Field 2 Title   
CODEOPFL2  String*8  Optional Field 2 Table   
SWOPFL3  Integer  Use Optional Field 3   
TEXTOPFL3  String*10  Optional Field 3 Title   
CODEOPFL3  String*8  Optional Field 3 Table   
SWOPFL4  Integer  Use Optional Field 4   
TEXTOPFL4  String*10  Optional Field 4 Title   
CODEOPFL4  String*8  Optional Field 4 Table   
SWOPFL5  Integer  Use Optional Field 5   
TEXTOPFL5  String*10  Optional Field 5 Title   
CODEOPFL5  String*8  Optional Field 5 Table   
SWOPFL6  Integer  Use Optional Field 6   
TEXTOPFL6  String*10  Optional Field 6 Title   
CODEOPFL6  String*8  Optional Field 6 Table   
SWOPFLDATE  Integer  Use Optional Date Field   
TEXTOPFLDT  String*10  Optional Date Field Title   
CODEOPFLDT  String*8  Reserved   
SWOPFLAMT  Integer  Use Optional Amount Field   
TEXTOPFLAM  String*10  Optional Amount Field Title   
CODEOPFLAM  String*8  Reserved   
ATRINVCSEQ  BCD*5.0  Next Invoice Posting Seq.Number   
SWMANTAX  Integer  Manual Tax Processing Default  List: 2 entries
0=No
1=Yes
INVCTYPE  Integer  Default Invoice Type  List: 2 entries
1=Item
2=Summary
SWUSESDOCS  Integer  Use Separate Numbers  List: 2 entries
0=No
1=Yes
TEXTRIPF  String*6  Retainage Invoice Prefix  Mask: %-6C
CNTRIPFLEN  BCD*2.0  Retainage Invoice Length   
CNTRISEQ  BCD*5.0  Next Retainage Invoice   
TEXTRXPF  String*6  Retainage Credit Note Prefix  Mask: %-6C
CNTRXPFLEN  BCD*2.0  Retainage Credit Note Length   
CNTRXSEQ  BCD*5.0  Next Retainage Credit Note   
TEXTRDPF  String*6  Retainage Debit Note Prefix  Mask: %-6C
CNTRDPFLEN  BCD*2.0  Retainage Debit Note Length   
CNTRDSEQ  BCD*5.0  Next Retainage Debit Note   
SWRTG  Integer  Use Retainage  List: 2 entries
0=No
1=Yes
SWRTGBASE  Integer  Retainage Base  List: 2 entries
0=Document Total After Taxes
1=Document Total Before Taxes
RTGSCHDKEY  String*12  Retainage Schedule  Mask: %-12N
RTGSCHDLNK  BCD*10.0  Retainage Schedule Link   
RTGLASTRUN  Date  Date Retainage Sched. Last Run   
RTGDAYS  Integer  Days Retained   
RTGPERCENT  BCD*5.5  Percent Retained   
RTGADVDAYS  Integer  Days Before Retainage Due   
SWRTGRATE  Integer  Retainage Exchange Rate  List: 2 entries
0=Use Original Document Exchange Rate
1=Use Current Exchange Rate
SWARPEND  Integer  Include Pending A/R Trans.  List: 2 entries
0=No
1=Yes
SWOEPEND  Integer  Include Pending O/E Trans.  List: 2 entries
0=No
1=Yes
SWXXPEND  Integer  Include Pending Other Trans.  List: 2 entries
0=No
1=Yes
SWTXCTLRC  Integer  Default Tax Reporting Control  List: 2 entries
0=No
1=Yes
SWTXRTGRPT  Integer  Report Retainage Tax  List: 2 entries
0=At Time of Original Document
1=As Per Tax Authority
SWTXDTLCLS  Integer  Default Detail Tax Class  List: 2 entries
0=Default to Customer Tax Class
1=Default to 1
SWDATEBUS  Integer  Default Posting Date  List: 3 entries
0=Document Date
1=Batch Date
2=Session Date

This page was generated on 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.