# Table: Material Allocation

Table: PMMTAH
View: PM0460
Record length: 260
Flags: A R

## Keys: 4

Title | Flags | Fields
--- | --- | ---
Sequence |  | SEQ
Material Allocation Number |  | MALLOCNO
Status/Material Allocation Numbe | M | COMPLETE, MALLOCNO
Transaction Status/Material Allo |  | TRANSTAT, MALLOCNO

## Fields: 28

Field | Type | Title | Presentation
--- | --- | --- | ---
SEQ | Long | Sequence |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
MALLOCNO | String*16 | Material Allocation 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 |
NUMDTL | Long | Number of Details |
NEXTDTLNUM | Long | Next Detail Number |
TRANSTAT | Integer | Transaction Status |
PRINTSTAT | Boolean | Print Status | List: 2 entries
0 | = | False
1 | = | True
COMPLETE | Integer | Status | List: 4 entries
0 | = | New
10 | = | Entered
30 | = | Approved
40 | = | Posted
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 |
DATEBUS | Date | Posting Date |
ENTEREDBY | String*8 | Entered By |

This page was generated on 2008-May-01

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