Table: Billing Worksheet Customer

Table: PMBWC
View: PM0083
Record Length: 457

Flags: A R 

Keys: 3

Title Flags Fields

Worksheet Number SEQLINENUM
Detail Number WORKIDCUSTLINE
Customer Number D M  WORKIDCUSTOMER

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