Table: Billing Worksheet Customer

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

Keys: 3

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

Fields: 52

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     
RETRATE  Integer    List: 2 entries
1=Use Original Document Exchange Rate
2=Use Current Exchange Rate
CONTRACT  String*16  ^1  Mask: %-16C
FMTCONTNO  String*16  ^1  Mask: %-16C
PROJECT  String*16  ^2  Mask: %-16N
NUMDTL  Long     
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   
ARACCTSET  String*6  A/R Account Set  Mask: %-6N

This page was generated on 2008-May-01

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