Table: Material Returns Detail

Table: PMMATRD
View: PM0047
Record Length: 994

Flags: A R 

Keys: 3

Title Flags Fields

Sequence/Line Number SEQLINENO
Material Number/Line Number MATERIALNOLINENO
Sequence/Detail Number MATERIALNODETAILNUM

Fields: 85

Field Type Title Presentation

SEQ Long Sequence
LINENO Long Line Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
MATERIALNO String*16 Material Return Number Mask: %-16C
FMTCONTNO String*16 ^1 Mask: %-16C
CONTRACT String*16 ^1 Mask: %-16C
PROJECT String*16 ^2 Mask: %-16N
CATEGORY String*16 ^3 Mask: %-16N
RESOURCE String*24 Item Number Mask: %-24C
DESC String*60 Description
LOCATION String*6 Location Mask: %-6N
QUANTITY BCD*10.5 Quantity
UOM String*10 Item Unit of Measure Mask: %-10c
CONVERSION BCD*10.6 Conversion
UNITCOST BCD*10.6 Unit Cost
ADJUNITCST BCD*10.5
ADJCOST BCD*10.5
COSTSEQNUM Long
COSTDATE Date
ADDCOST BCD*10.3 Additional Cost
STOCKITEM Boolean Stock Item
COSTMETHOD Integer Cost Method
UNFMTITEM String*24 Item Number
CHKBDLZERO Boolean Check Below Zero
COSTCCY String*3 Cost Currency Mask: %-3N
EXTCOSTSR BCD*10.3 Extended Cost
EXTCOSTHM BCD*10.3 Extended Cost
COMMENTS String*250 Comments
ICACCT String*45 I/C Account Mask: %-45C
WIPACCT String*45 WIP/COS Account Mask: %-45C
OHACCT String*45 Overhead Account Mask: %-45C
BILLTYPE Integer Billing Type List:3 entries
2 = Billable
3 = No Charge
1 = Non-billable
FIXEDBILL Integer Bill Amount Based On List:2 entries
1 = Invoice This Amount
2 = Invoice Based on Exchange Rate
ESTBILLCCY Integer Revenue And Cost Currency List:8 entries
1 = Moving Average
2 = FIFO
3 = LIFO
4 = Standard Cost
5 = Most Recent Cost
6 = User-specified
7 = Serial
8 = Lot
BILLRATE BCD*10.6 Billing Rate
EXTBILLSR BCD*10.3 Extended Billing Amount
EXTBILLHM BCD*10.3 Reserved
TOTCOSTSR BCD*10.3 Total Cost
TOTCOSTHM BCD*10.3 Total Cost
OVERHD Integer Overhead Type
OHEADRATE BCD*10.6 Overhead Rate
HEADPER BCD*5.5 Overhead Percentage
OHSR BCD*10.3 Overhead Amount
OHHM BCD*10.3 Overhead Amount
BILLCCY String*3 Billing Currency Mask: %-3N
DETAILNUM Long Detail Number
ARITEM String*16 A/R Item No. Mask: %-16C
ARUOM String*10 A/R Unit of Measure Mask: %-10C
TAUTH1 String*12 Tax Authority 1 Mask: %-12N
TAUTH2 String*12 Tax Authority 2 Mask: %-12N
TAUTH3 String*12 Tax Authority 3 Mask: %-12N
TAUTH4 String*12 Tax Authority 4 Mask: %-12N
TAUTH5 String*12 Tax Authority 5 Mask: %-12N
TCLASS1 Integer Tax Class 1
TCLASS2 Integer Tax Class 2
TCLASS3 Integer Tax Class 3
TCLASS4 Integer Tax Class 4
TCLASS5 Integer Tax Class 5
TINCLUDED1 Boolean Tax Included 1
TINCLUDED2 Boolean Tax Included 2
TINCLUDED3 Boolean Tax Included 3
TINCLUDED4 Boolean Tax Included 4
TINCLUDED5 Boolean Tax Included 5
PROJTYPE Integer ^2 Type List:3 entries
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
CONTSTYLE Integer ^1 Style List:2 entries
1 = Standard
2 = Basic
CUSTOMER String*12 Customer Mask: %-12C
REVREC Integer Accounting Method List:7 entries
1 = Completed Project
2 = Total Cost Percentage Complete
3 = Labor Hours Percentage Complete
4 = Billings and Costs
5 = Project Percentage Complete
6 = Category Percentage Complete
8 = Accrual-Basis
INVTYPE Integer Invoice Type List:2 entries
1 = Item
2 = Summary
VALUES Long Optional Fields
CLOSESN Boolean Close SN
PROID Long SN inter-communication ID
POPUPSN Integer Popup SN
POPUPLT Integer Popup LT
CLOSELT Boolean Close LT
LTSETID Long LT inter-communication ID
FORCEPOPSN Boolean Force popup SN
FORCEPOPLT Boolean Force popup LT
GENICSEQ Boolean Generate IC Seq.
PRICELIST String*6 Price List Mask: %-6N
CUSTCCY String*3 Customer Currency
SERIALQTY Long Number of Serials
LOTQTY BCD*10.4 Number of Lots