Table: Billing Worksheet

Table: PMBWH
View: PM0081
Record length: 242
Flags: A R 

Keys: 2

Title  Flags  Fields

Sequence  SEQ
Worksheet Number  WORKID

Fields: 32

Field  Type  Title  Presentation 

SEQ  Long  Sequence   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
WORKID  String*30  Worksheet Number  Mask: %-16C
RUNDATE  Date  Document Date   
DESC  String*60  Description   
INVTYPE  Integer  Invoice Type  List: 3 entries
1=Item
2=Summary
3=Both
EXRATE  Integer  Exchange Rate   
NEXTCUST  Long  Next Customer Line Number   
NEXTDTL  Long  Next Detail Line Number   
POSTABLE  Boolean  Ready To Post   
POSTINAR  Boolean  Posted To A/R  List: 2 entries
0=No
1=Yes
RETRATE  Integer    List: 2 entries
0=Use Original Document Exchange Rate
1=Use Current Exchange Rate
VALUES  Long  Optional Fields   
CREATEBY  String*8  Created By   
CREATEDT  Date  Created On   
CREATETM  Time  Created At   
APPROVEBY  String*8  Approved By   
APPROVEDT  Date  Approved On   
APPROVETM  Time  Approved At   
POSTEDBY  String*8  Posted By   
POSTEDDT  Date  Posted On   
POSTEDTM  Time  Posted At   
MANAGER  String*16  Manager   
NUMCUST  Long  Number of Customer Lines   
NUMDTL  Long  Number of Detail Lines   
INVYEAR  String*4  Invoice Fiscal Year  Mask: %04D
INVPER  Integer  Invoice Fiscal Period  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  Date  Posting Date   
ENTEREDBY  String*8  Entered By   

This page was generated on 2008-May-01

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