MAINVMSG FILE
REFERENCED BY
MA264 MA64.4 MA64.2 MA64.3 MA64.1
UPDATED BY
MA66.1 MA66.2 MA66.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAG-COMPANY Numeric 4 MA66.1
Company The company number represents an
established company and is entered on
all function codes.
MAG-AUTH-CODE Alpha 3 MA66.1 MA66.2
Authority Code A user-defined code representing a MA66.3
person or department responsible for
approving a registered invoice.
MAG-VENDOR Alpha 9 (Right Justified) MA66.1
Vendor ID The vendor's identification code.
MAG-INVOICE Alpha 22 MA66.1
Invoice Number Used to identify the invoice.
MAG-SUFFIX Numeric 3 MA66.1
Invoice Suffix This is the suffix for the invoice.
MAG-CANCEL-SEQ Numeric 4 MA66.1
Cancel Sequence The sequence number assigned upon a
cancellation of a distributed invoice.
The first sequence assigned is 9999.
MAG-PO-NUMBER Alpha 14 (Right Justified)
PO Number This field contains the number
representing the purchase order.
MAG-PO-RELEASE Numeric 4
PO Release Number Used to identify a purchase order
release (created from a Blanket or
Standing order).
MAG-PO-CODE Alpha 4
Po Code This is the purchase order code.
MAG-PO-LINE-NBR Numeric 6
PO Line Number The PO line number this record is
associated with.
MAG-MAD-SEQ-NBR Numeric 4 MA66.1
Mad Seq Nbr
MAG-SEQ-NBR Numeric 4 MA66.1 MA66.2
Sequence Number An automatically assigned sequence MA66.3
number.
MAG-API-OBJ-ID Numeric 12
Api Obj Id
MAG-ITEM Alpha 32 MA66.1
Item Number This field contains the item
identifier.
MAG-MATCH-DTL-KEY Alpha 55
Match Dtl Key
MAG-STATUS Numeric 1 MA66.2 MA66.3
Status This field displays the status of the
transaction.
0 = Unreleased
1 = Open
2 = Pending Action
9 = Closed
MAG-ACTION Alpha 1 MA66.2 MA66.3
Action " " = Open
1 = Approved
2 = Chargeback
3 = Disapprove
4 = Forward
MAG-OPERATOR Alpha 10
Operator Code This field is used to store the login
id of the person who entered the record.
MAG-CREATE-DATE Numeric 8 (yyyymmdd) MA66.2
Creation Date The creation date.
MAG-CREATE-TIME Numeric 6 (hhmmss) MA66.2
Creation Time
MAG-PROCURE-GROUP Alpha 4
Procure Group This field contains the identifier for a
group of companies that share a common
procurement effort. They buy items and
services together.
MAG-BUYER-CODE Alpha 3
Buyer Code The user defined buyer identifier.
MAG-AUTH-CODE-MAIL Alpha 30 MA66.2 MA66.3
Auth Code Mail
MAG-FWD-AUTH-OPER Alpha 10 MA66.2 MA66.3
Fwd Auth Oper
MAG-TYPE Alpha 2
Type This identifies whether this record is
created because of a picking
transaction, or because of a return.
Valid values are:
"IS" = Picking transaction.
"RR" = Return.
~$1 VENDOR
The vendor's identification code.
C = Cost
Q = Quantity
I = Item
NR = No Receipt Line
MAG-VAR-TYPE Alpha 1
Var Type The Variance Type field contains the
value that represents the variance type
for fiscal year variances.
Valid values are:
A = Variance Amount
P = Variance Percent
" " = Item Difference
O = Invoice Over Receipt
U = Invoice Under Receipt
MAG-REASON-CODE Alpha 4 MA66.2 MA66.3
Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
MAG-PRIORITY Numeric 1 MA66.1
Priority Number Indicates order of precedence for
contracts to determine costing defaults
for items.
1 = Urgent
2 = Normal
MAG-MATCH-OBJ-ID Numeric 12
Match Obj Id
MAG-RESPOND-DATE Numeric 8 (yyyymmdd) MA66.2 MA66.3
Respond Date
MAG-DISC-DATE Numeric 8 (yyyymmdd)
Discount Date
MAG-LOCATION Alpha 5
Location Code This field contains a valid stocking
location within the company inventory.
MAINVMSG FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MAGSET1 COMPANY MA264 MA64.4
VENDOR MA66.1 MA66.2
INVOICE MA66.3 MA66.8
SUFFIX
CANCEL-SEQ
MAD-SEQ-NBR
SEQ-NBR
MAGSET2 COMPANY KeyChange, Subset MA64.2
AUTH-CODE Where STATUS = 1
PO-NUMBER
PO-RELEASE
PO-CODE
INVOICE
PO-LINE-NBR
MAD-SEQ-NBR
VENDOR
API-OBJ-ID
SEQ-NBR
MAGSET3 COMPANY KeyChange, Subset MA64.3
AUTH-CODE Where STATUS = 1
ITEM
VAR-TYPE
TYPE
API-OBJ-ID
MAD-SEQ-NBR
SEQ-NBR
MAGSET4 COMPANY KeyChange, Subset MA64.3
AUTH-CODE Where STATUS = 1
MATCH-DTL-KEY
VAR-TYPE
TYPE
API-OBJ-ID
MAD-SEQ-NBR
SEQ-NBR
MAGSET5 API-OBJ-ID
MAD-SEQ-NBR
SEQ-NBR
MAGSET6 COMPANY KeyChange, Subset MA64.1
AUTH-CODE Where STATUS = 1
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
MAGSET7 COMPANY KeyChange, Subset
STATUS Where STATUS = 1
OPERATOR
VENDOR
API-OBJ-ID
MAD-SEQ-NBR
SEQ-NBR
MAGSET8 COMPANY KeyChange
STATUS
AUTH-CODE
CREATE-DATE
VENDOR
API-OBJ-ID
MAD-SEQ-NBR
SEQ-NBR
|
