Lawson Insight Technical Documentation |
|
MAINVMSG
MAINVMSG FILE
REFERENCED BY
PO135 PO139 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 API1.1 MA41.2 MA41.7 MA43.1
MA43.2 MA43.3 MA60.3 MA61.1 MA64.6 MA66.1
MA66.2 MA66.3 MA67.1 MA70.1 MA708 MA75.1
MAI1.1 POI3.1 AP300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAG-COMPANY Numeric 4 AP125 AP126
Element: 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 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.1 MA66.2
MA66.3 MA67.1
MAI1.1 POI3.1
MAG-AUTH-CODE Alpha 3 AP125 AP126
Element: Authority CodeA 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 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.1 MA66.2
MA66.3 MA67.1
MAI1.1 POI3.1
MAG-VENDOR Alpha 9 (Right Justified) AP125 AP126
Element: 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 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.1 MA66.2
MA66.3 MA67.1
MAI1.1 POI3.1
MAG-INVOICE Alpha 22 AP125 AP126
Element: Invoice NumberUsed 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 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.1 MA66.2
MA66.3 MA67.1
MAI1.1 POI3.1
MAG-SUFFIX Numeric 3 AP125 AP126
Element: Invoice SuffixThis 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 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.1 MA66.2
MA66.3 MA67.1
MAI1.1 POI3.1
MAG-CANCEL-SEQ Numeric 4 AP125 AP126
Element: Sequence Number AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.1 MA66.2
MA66.3 MA67.1
MAI1.1 POI3.1
MAG-PO-NUMBER Alpha 14 (Right Justified) AP125 AP126
Element: 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 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.2 MA66.3
MA67.1 MAI1.1
POI3.1
MAG-PO-RELEASE Numeric 4 AP125 AP126
Element: PO Release NumUsed 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 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.2 MA66.3
MA67.1 MAI1.1
POI3.1
MAG-PO-CODE Alpha 4 AP125 AP126
Element: 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 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.2 MA66.3
MA67.1 MAI1.1
POI3.1
MAG-PO-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.2 MA66.3
MA67.1 MAI1.1
POI3.1
MAG-MAD-SEQ-NBR Numeric 4 AP125 AP126
Element: Sequence Number AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.1 MA66.2
MA66.3 MA67.1
MAI1.1 POI3.1
MAG-SEQ-NBR Numeric 4 AP125 AP126
Element: Sequence NumbeAn automatically assigned sequence AP20.1 AP20.2
number. AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.1 MA66.2
MA66.3 MA67.1
MAI1.1 POI3.1
MAG-API-OBJ-ID Numeric 12 AP125 AP126
Object AP20.1 AP20.2
Identification AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.2 MA66.3
MA67.1 MAI1.1
POI3.1
MAG-MSG-ORIGIN Alpha 1 AP125 AP126
Element: 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 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.2 MA66.3
MA67.1 MA708
MAI1.1 POI3.1
MAG-ITEM Alpha 32 AP125 AP126
Element: 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 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.1 MA66.2
MA66.3 MA67.1
MAI1.1 POI3.1
MAG-MATCH-DTL-KEY Alpha 85 AP125 AP126
Element: 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 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.2 MA66.3
MA67.1 MAI1.1
POI3.1
MAG-STATUS Numeric 1 AP125 AP126
Element: Status This field displays the status of the AP20.1 AP20.2
transaction. AP20.3 AP20.4
0 = Unreleased AP20.5 AP20.7
1 = Open AP23.1 AP25.1
2 = Pending Action AP25.2 AP26.1
9 = Closed AP27.1 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.2 MA66.3
MA67.1 MAI1.1
POI3.1
MAG-ACTION Alpha 1 AP125 AP126
Element: 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 API1.1
6 = Adjust Cost MA41.2 MA41.7
7 = Chargeback netted to zero MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.2 MA66.3
MA67.1 MAI1.1
POI3.1
MAG-OPERATOR Alpha 10 AP125 AP126
Element: 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 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.2 MA66.3
MA67.1 MAI1.1
POI3.1
MAG-CREATE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.2 MA66.3
MA67.1 MAI1.1
POI3.1
MAG-CREATE-TIME Numeric 6 (hhmmss) AP125 AP126
Element: Sys Time AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.2 MA66.3
MA67.1 MAI1.1
POI3.1
MAG-PROCURE-GROUP Alpha 4 AP125 AP126
Element: 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 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.2 MA66.3
MA67.1 MAI1.1
POI3.1
MAG-BUYER-CODE Alpha 3 AP125 AP126
Element: Buyer AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.2 MA66.3
MA67.1 MAI1.1
POI3.1
MAG-AUTH-CODE-MAIL Alpha 30 AP125 AP126
Element: 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 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.2 MA66.3
MA67.1 MAI1.1
POI3.1
MAG-FWD-AUTH-OPER Alpha 10 AP125 AP126
Element: Operator Code AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.2 MA66.3
MA67.1 MAI1.1
POI3.1
MAG-TYPE Alpha 2 AP125 AP126
Element: 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 API1.1
~$1 VENDOR MA41.2 MA41.7
The vendor's identification code. MA43.1 MA43.2
MA43.3 MA60.3
C = Cost MA61.1 MA64.6
Q = Quantity MA66.2 MA66.3
I = Item MA67.1 MAI1.1
NR = No Receipt Line POI3.1
MAG-VAR-TYPE Alpha 1 AP125 AP126
Element: 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 API1.1
P = Variance Percent MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
" " = Item Difference MA61.1 MA64.6
O = Invoice Over Receipt MA66.2 MA66.3
U = Invoice Under Receipt MA67.1 MAI1.1
POI3.1
MAG-REASON-CODE Alpha 4 AP125 AP126
Accounts Receivable This field contains the reason code, AP20.1 AP20.2
Code 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 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.2 MA66.3
MA67.1 MAI1.1
POI3.1
MAG-PRIORITY Numeric 1 AP125 AP126
Element: Au Flag 1 = Urgent AP20.1 AP20.2
2 = Normal AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.1 MA66.2
MA66.3 MA67.1
MAI1.1 POI3.1
MAG-MATCH-OBJ-ID Numeric 12 AP125 AP126
Object AP20.1 AP20.2
Identification AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.2 MA66.3
MA67.1 MAI1.1
POI3.1
MAG-RESPOND-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.1 MA66.2
MA66.3 MA67.1
MAI1.1 POI3.1
MAG-DISC-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA64.6
MA66.2 MA66.3
MA67.1 MAI1.1
POI3.1
MAG-LOCATION Alpha 5 AP125 AP126
Element: 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 API1.1
MA41.2 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.2 MA66.3
MA67.1 POI3.1
MAG-PO-COST-UPD Signed 13.5 AP125 AP126
Element: Base Cost AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
MA41.2 MA43.1
MA43.2 MA43.3
MA64.6 MA66.2
MA66.3 POI3.1
MAINVMSG FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MAGSET1 COMPANY AP30.4 MA43.1
VENDOR MA64.1 MA64.4
INVOICE MA64.6 MA64.8
SUFFIX MA66.1 MA66.2
CANCEL-SEQ MA66.3 MA66.8
MAD-SEQ-NBR MA708
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
AP300 API1.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA60.3
MA61.1 MA66.2
MA66.3 MA67.1
MA70.1 MA75.1
MAI1.1 PO135
...
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
|