Table: Material Usage

Table: PMMATH
View: PM0050
Record Length: 430

Flags: A R 

Keys: 5

Title Flags Fields

Sequence SEQ
Material Usage Number MATERIALNO
IC Status/Material Number D M  ICSTATSEQ
Transaction Status/Material Numb TRANSTATMATERIALNO
Status/Material Number M  COMPLETEMATERIALNO

Fields: 43

Field Type Title Presentation

SEQ Long Sequence
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
MATERIALNO String*16 Material Usage Number Mask: %-16C
TRANSDATE Date Transaction Date
FISCALYEAR String*4 Fiscal Year Mask: %04D
FISCALPER Integer Fiscal Period List:13 entries
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5
6 = 6
7 = 7
8 = 8
9 = 9
10 = 10
11 = 11
12 = 12
13 = 13
REFERENCE String*60 Reference
DESC String*60 Description
EXTCOSTSR BCD*10.3 Total Cost
EXTCOSTHM BCD*10.3 Total Cost
OHSR BCD*10.3 Overhead Amount
OHHM BCD*10.3 Overhead Amount
TOTCOSTSR BCD*10.3 Total Cost
TOTCOSTHM BCD*10.3 Total Cost
TOTBILLSR BCD*10.3 Total Billable Amount
TOTBILLHM BCD*10.3 Total Billable Amount
TOTQTY BCD*10.5 Total Quantity
COMPLETE Integer Status List:4 entries
0 = New
10 = Entered
30 = Approved
40 = Posted
ADDCSTTYPE Integer Additional Cost Type
ADDCOST BCD*10.3 Additional Cost
PRINTSTAT Boolean Printed List:2 entries
0 = False
1 = True
TRANSTAT Integer Transaction Status List:4 entries
1 = Entered
2 = Imported
3 = Generated
4 = Posted
NEXTDTLNUM Long Next Detail Number
ICSTAT Integer I/C Status List:3 entries
1 = not processed
2 = ready to process
3 = process complete
NUMDTL Long Number of Details
VALUES Long Optional Fields
CREATEBY String*8 Created By
CREATEDT Date Created On
CREATETM Time Created At
APPROVEBY String*8 Approved By
APPROVEDT Date Approved On
APPROVETM Time Approved At
POSTEDBY String*8 Posted By
POSTEDDT Date Posted On
POSTEDTM Time Posted At
EMPLOYEENO String*60 Used By
BINTERNAL Boolean Internal Usage List:2 entries
0 = False
1 = True
ICSEQ Long IC Shipment Sequence Number
ENTEREDBY String*8 Entered By
DATEBUS Date Posting Date