Table: Statement Profiles

Table: XQSTPROF
View: XQ0432
Record length: 725
Flags: A R 

Keys: 2

Title  Flags  Fields

Profile  PROFILEID
Schedule  D M  SCHEDKEY, SCHEDLINK

Fields: 39

Field  Type  Title  Presentation 

PROFILEID  String*12  Profile ID  Mask: %-12N
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
CREATEDON  Date  Created On   
CREATEDBY  String*8  Created By  Mask: %-8N
MODIFIEDON  Date  Modified On   
MODIFIEDBY  String*8  Modified By  Mask: %-8N
INACTIVE  Boolean  Inactive  List: 2 entries
0=No
1=Yes
INACTIVEON  Date  Inactive On   
DESCRIPT  String*60  Description   
NOTES  String*250  Notes   
SCHEDKEY  String*12  Schedule Code  Mask: %-12N
SCHEDLINK  BCD*10.0  Schedule Link   
DATEEFF  Date  Effective Date   
LASTCUTOFF  Date  Last Cutoff Date   
NEXTCUTOFF  Date  Next Cutoff Date   
RPTNAME  String*255  Report Name   
DETAILSORT  Integer  Sort Documents By  List: 2 entries
0=Document Number
1=Document Date
SWCREDIT  Boolean  Include Credit Balances   
SWDEBIT  Boolean  Include Debit Balances   
SWZEROBAL  Boolean  Include Zero Balances   
STMTTYPE  Integer  Open Item Statement Type  List: 5 entries
0=Version 5.1, 5.2, and 5.3 Format
1=Balance Forward
2=Transaction Current Outstanding Balances
3=Transaction Opening Balances Showing Applied Details
4=Transaction Opening Balances and New Transactions
SWINCLPAID  Boolean  Include Fully Paid Documents   
SWDETAIL  Boolean  Include Applied Details   
AGEBY  Integer  Age Documents By  List: 2 entries
0=Due Date
1=Document Date
AGEPERIOD1  Integer  Current   
AGEPERIOD2  Integer  First Period   
AGEPERIOD3  Integer  Second Period   
AGEPERIOD4  Integer  Third Period   
IDDUNNING  String*8  Dunning Message Code  Mask: %-8N
SWOVERDUE  Boolean  Select Customers Based on Overdue Days   
OVERDUEDAY  Long  Number of Overdue Days and Later   
WAITRUNDAY  Integer  Days To Wait Before Processing   
LASTRUN  Date  Last Run Date   
NEXTRUN  Date  Earliest Processing Date   
RUNDATESW  Integer  Set Run Date To  List: 2 entries
0=Cutoff Date
1=Processing Date
RUNTYPESW  Integer  Run Type  List: 2 entries
0=Customer Statements
1=National Account Statements

This page was generated on 2025-Dec-16

© 2025 TaiRox Software Inc.