# 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 | Contract | Mask: %-16C
FMTCONTNO | String*16 | Contract | Mask: %-16C
PROJECT | String*16 | Project | 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 2009-Nov-19

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