Table: Billing Worksheet Customer

Table: PMBWC
View: PM0083
Record length: 451
Flags: A R 

Keys: 3

Title  Flags  Fields
Worksheet Number   SEQ, LINENUM
Detail Number   WORKID, CUSTLINE
Customer Number   D M  WORKID, CUSTOMER

Fields: 51

Field  Type  Title  Presentation 
SEQ  Long  Sequence   
LINENUM  Long  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
WORKID  String*30  Worksheet Number  Mask: %-16C
CUSTLINE  Long  Customer Line Number   
CUSTOMER  String*12  Customer  Mask: %-12C
NAMECUST  String*60  Customer Name   
BILSTATUS  Integer  Status  List: 2 entries
1=Invoice
2=Hold
BILAMTSR  BCD*10.3  Document Amount   
BILAMTHM  BCD*10.3  Document Amount   
RATE  BCD*8.7  Exchange Rate   
RATETYPE  String*2  Rate Type  Mask: %-2N
RATEDATE  Date  Rate Date   
RATEOP  Integer  Rate Operator  List: 2 entries
1=Multiply
2=Divide
PONUMBER  String*22  P/O Number  Mask: %-22C
CURRENCY  String*3  Currency  Mask: %-3N
TEXTOPFL1  String*2  Reserved   
TEXTOPFL2  String*3  Reserved   
TEXTOPFL3  String*4  Reserved   
TEXTOPFL4  String*12  Reserved   
TEXTOPFL5  String*15  Reserved   
TEXTOPFL6  String*30  Reserved   
OPFLDATE  Date  Reserved   
OPFLAMT  BCD*10.3  Reserved   
RATESPREAD  BCD*8.7  RATESPREAD   
RETRATE  Integer  RETRATE  List: 2 entries
1=Use Original Document Exchange Rate
2=Use Current Exchange Rate
CONTRACT  String*16  Contract  Mask: %-16C
FMTCONTNO  String*16  Contract  Mask: %-16C
PROJECT  String*16  Project  Mask: %-16N
NUMDTL  Long  NUMDTL   
CODETAXGRP  String*12  Tax Group   
TCLASS1  Integer  Customer Tax Class 1   
TCLASS2  Integer  Customer Tax Class 2   
TCLASS3  Integer  Customer Tax Class 3   
TCLASS4  Integer  Customer Tax Class 4   
TCLASS5  Integer  Customer Tax Class 5   
TAUTH1  String*12  Customer Tax Authority 1   
TAUTH2  String*12  Customer Tax Authority 2   
TAUTH3  String*12  Customer Tax Authority 3   
TAUTH4  String*12  Customer Tax Authority 4   
TAUTH5  String*12  Customer Tax Authority 5   
RCURRENCY  String*3  Tax Reporting Currency  Mask: %-3N
RATETYPERC  String*2  Tax Reporting Rate Type  Mask: %-2N
RATEDATERC  Date  Tax Reporting Rate Date   
RATERC  BCD*8.7  Tax Reporting Exchange Rate   
RATEOPRC  Integer  Tax Reporting Rate Operator   
RATEOVERRC  Boolean  Tax Reporting Override   
RATEOVER  Boolean  Rate Override   

This page was generated on 2008-Apr-11

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