View: Create Billing Worksheet Superview

RotoID: PM0080
Tables:
DLL: PMBWS

Compositions: 0

Keys: 0

Fields: 43

Field  Index  Type  Title  Attributes  Presentation

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

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.