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 ^1 E A  Mask: %-16C
FMTCONTNO 27 String*16 ^1 E A  Mask: %-16C
PROJECT 28 String*16 ^2 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 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).