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