# Table: Billing Worksheet Customer

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

## Keys: 3

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

## Fields: 33

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 |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.