# View: Billing Worksheet Customer

RotoID: PM0083
Table: PMBWC
Protocol: Detail, Sequenced revisions, Key auto generate
DLL: PMBWC

## Compositions: 2

RotoID | Tables | Title | DLL
--- | --- | --- | ---
PM0081 | PMBWH | Billing Worksheet | PMBWH
PM0082 | PMBWD | Billing Worksheet Detail | PMBWD

## Keys: 3

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

## Fields: 49

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
SEQ | 1 | Long | Sequence | E A K R |
LINENUM | 2 | Long | Line Number | E A K R |
WORKID | 3 | String*30 | Worksheet Number | E A | Mask: %-16C
CUSTLINE | 4 | Long | Customer Line Number | E A |
CUSTOMER | 5 | String*12 | Customer | E A | Mask: %-12C
NAMECUST | 6 | String*60 | Customer Name | E A |
BILSTATUS | 7 | Integer | Status | E A | List: 2 entries
1 | = | Invoice
2 | = | Hold
BILAMTSR | 8 | BCD*10.3 | Document Amount | E A |
BILAMTHM | 9 | BCD*10.3 | Document Amount | E A |
RATE | 10 | BCD*8.7 | Exchange Rate | A X |
RATETYPE | 11 | String*2 | Rate Type | A X | Mask: %-2N
RATEDATE | 12 | Date | Rate Date | A X |
RATEOP | 13 | Integer | Rate Operator | E A | List: 2 entries
1 | = | Multiply
2 | = | Divide
PONUMBER | 14 | String*22 | P/O Number | E A | Mask: %-22C
CURRENCY | 15 | String*3 | Currency | E A | Mask: %-3N
TEXTOPFL1 | 16 | String*2 | Reserved | A |
TEXTOPFL2 | 17 | String*3 | Reserved | A |
TEXTOPFL3 | 18 | String*4 | Reserved | A |
TEXTOPFL4 | 19 | String*12 | Reserved | A |
TEXTOPFL5 | 20 | String*15 | Reserved | A |
TEXTOPFL6 | 21 | String*30 | Reserved | A |
OPFLDATE | 22 | Date | Reserved | A |
OPFLAMT | 23 | BCD*10.3 | Reserved | A |
RATESPREAD | 24 | BCD*8.7 |  | E A |
RETRATE | 25 | Integer |  | E A | List: 2 entries
1 | = | Use Original Document Exchange Rate
2 | = | Use Current Exchange Rate
CONTRACT | 26 | String*16 | Contract | E A | Mask: %-16C
FMTCONTNO | 27 | String*16 | Contract | E A | Mask: %-16C
PROJECT | 28 | String*16 | Project | E A | Mask: %-16N
NUMDTL | 29 | Long |  | E A C |
CODETAXGRP | 30 | String*12 | Tax Group | E A |
TCLASS1 | 31 | Integer | Customer Tax Class 1 | E A |
TCLASS2 | 32 | Integer | Customer Tax Class 2 | E A |
TCLASS3 | 33 | Integer | Customer Tax Class 3 | E A |
TCLASS4 | 34 | Integer | Customer Tax Class 4 | E A |
TCLASS5 | 35 | Integer | Customer Tax Class 5 | E A |
TAUTH1 | 36 | String*12 | Customer Tax Authority 1 | E A |
TAUTH2 | 37 | String*12 | Customer Tax Authority 2 | E A |
TAUTH3 | 38 | String*12 | Customer Tax Authority 3 | E A |
TAUTH4 | 39 | String*12 | Customer Tax Authority 4 | E A |
TAUTH5 | 40 | String*12 | Customer Tax Authority 5 | E A |
RCURRENCY | 41 | String*3 | Tax Reporting Currency | A X | Mask: %-3N
RATETYPERC | 42 | String*2 | Tax Reporting Rate Type | A X | Mask: %-2N
RATEDATERC | 43 | Date | Tax Reporting Rate Date | A X |
RATERC | 44 | BCD*8.7 | Tax Reporting Exchange Rate | A X |
RATEOPRC | 45 | Integer | Tax Reporting Rate Operator | E A |
RATEOVERRC | 46 | Boolean | Tax Reporting Override | E A |
RATEOVER | 47 | Boolean | Rate Override | E A |
ARACCTSET | 48 | String*6 | A/R Account Set | E A | Mask: %-6N
RATEERR | 1000 | Integer | Rate Error Code | E A C | List: 5 entries
0 | = | No rate error
1 | = | Rate type is invalid
2 | = | Rate is zero
3 | = | Rate is outside spread
4 | = | No rate information exists

This page was generated on 2009-Nov-19

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