View: Create Billing Worksheet Superview

RotoID: PM0080

Protocol: Superview
DLL:PMBWS

Keys: 0

Title Fields

Fields: 48

Field Index Type Title Attributes Presentation
WORKID 1 String*30 Worksheet Number E A  Mask: %-16C
LASTRUN 2 Date Last Run Date A 
RUNDATE 3 Date Document Date E A 
DESC 4 String*60 Description E A 
INVTYPE 5 Integer Invoice Type E A  List:3 entries
1 = Item
2 = Summary
3 = Both
INCAPCST 6 Boolean Include A/P Costs E A 
INCHOLD 7 Boolean Customers on Hold E A 
INCCNTHOLD 8 Boolean ^4 on Hold E A 
INCPRHOLD 9 Boolean ^5 on Hold E A 
INCINACT 10 Boolean Inactive Customers E A 
INCNBLBL 11 Boolean Non-billable Transactions E A X 
INCZBLFP 12 Boolean Zero-billed Fixed Price Projects E A X 
INCTRHOLD 13 Boolean Transactions on Hold E A X 
SEL1 14 Integer Select By E A P  List:6 entries
0 = None
2 = Customer Number
4 = Contract, Project, Category
5 = Project Type
6 = Account Set
8 = Contract Manager
SEL2 15 Integer Then By E A P  List:6 entries
0 = None
2 = Customer Number
4 = Contract, Project, Category
5 = Project Type
6 = Account Set
8 = Contract Manager
SEL3 16 Integer Then By E A P  List:6 entries
0 = None
2 = Customer Number
4 = Contract, Project, Category
5 = Project Type
6 = Account Set
8 = Contract Manager
SEL4 17 Integer Then By E A P  List:6 entries
0 = None
2 = Customer Number
4 = Contract, Project, Category
5 = Project Type
6 = Account Set
8 = Contract Manager
SCHFROM 18 String*12 From Schedule Code A X  Mask: %-12N
SCHTO 19 String*12 To Schedule Code A X  Mask: %-12N
CUSTFROM 20 String*12 From Customer A X  Mask: %-12C
CUSTTO 21 String*12 To Customer A X  Mask: %-12C
TRANFROM 22 Date From Transaction Date A X 
TRANTO 23 Date To Transaction Date A X 
CONTFROM 24 String*16 From ^1 A X  Mask: %-16C
CONTTO 25 String*16 To ^1 A X  Mask: %-16C
PROJFROM 26 String*16 From ^2 A X  Mask: %-16N
PROJTO 27 String*16 To ^2 A X  Mask: %-16N
CATFROM 28 String*16 From ^3 A X  Mask: %-16N
CATTO 29 String*16 To ^3 A X  Mask: %-16N
PROJTYPE 30 Integer ^2 Type A P X  List:3 entries
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
ACCTFROM 31 String*6 From Account Set A X  Mask: %-6N
ACCTTO 32 String*6 To Account Set A X  Mask: %-6N
BAMTFROM 33 BCD*10.3 From Billing Amount E A X 
BAMTTO 34 BCD*10.3 To Billing Amount E A X 
EXRATE 35 Integer Exchange Rate E A 
CUTOFFBY 36 Integer Cutoff By E A  List:2 entries
1 = Transaction Date
2 = Year/Period
CUTOFFDATE 37 Date Transaction Date E A 
CUTOFFYEAR 38 String*4 Cutoff Year E A  Mask: %04D
CUTOFFPER 39 Integer Cutoff Period E A  List:13 entries
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5
6 = 6
7 = 7
8 = 8
9 = 9
10 = 10
11 = 11
12 = 12
13 = 13
RETRATE 40 Integer Retainage Exchange Rate E A  List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
CWORKID 41 String*30 Created Worksheet Number E A  Mask: %-16C
BILLMETHOD 42 Integer Create Invoices By E A  List:3 entries
1 = Customer
2 = Contract
3 = Project
BMETER 43 Integer E A  List:3 entries
0 = No meter
1 = Meter
2 = Meter but no cancel button
MANFROM 44 String*16 From ^1 Manager E A  Mask: %-16N
MANTO 45 String*16 To ^1 Manager E A  Mask: %-16N
INVYEAR 46 String*4 Invoice Fiscal Year A  Mask: %04D
INVPER 47 Integer Invoice Fiscal Period A  List:13 entries
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5
6 = 6
7 = 7
8 = 8
9 = 9
10 = 10
11 = 11
12 = 12
13 = 13
DATEBUS 48 Date Posting Date E A 

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).