Lawson Insight Technical Documentation |
|
MAINVMSG
MAINVMSG FILE
REFERENCED BY
PO135 MA264
UPDATED BY
AP125 AP126 AP25.1 AP25.2 AP26.1 AP27.1
AP30.4 MA60.3 MA61.1 MA64.6 MA66.1 MA66.2
MA66.3 MA67.1 MA70.1 MA75.1 MAI1.1 POI3.1
AP300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAG-COMPANY Numeric 4 AP125 AP126
Element: Company Identifies the AP company if the AP25.1 AP25.2
resource type = V. Identifies the HR AP26.1 AP27.1
company if the resource type = E. It is MA60.3 MA61.1
blank for type A, P or Q resources. 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 AP25.1 AP25.2
person or department responsible for AP26.1 AP27.1
approving a registered invoice. 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. AP25.1 AP25.2
AP26.1 AP27.1
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. AP25.1 AP25.2
AP26.1 AP27.1
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. AP25.1 AP25.2
AP26.1 AP27.1
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 NumbeThe sequence number assigned upon a AP25.1 AP25.2
cancellation of a distributed invoice. AP26.1 AP27.1
The first sequence assigned is 9999. 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 AP25.1 AP25.2
representing the purchase order. AP26.1 AP27.1
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 AP25.1 AP25.2
release (created from a Blanket or AP26.1 AP27.1
Standing order). 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. AP25.1 AP25.2
AP26.1 AP27.1
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 The PO line number this record is AP25.1 AP25.2
associated with. AP26.1 AP27.1
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 AP25.1 AP25.2
AP26.1 AP27.1
MA60.3 MA61.1
MA64.6 MA66.1
MA66.2 MA66.3
MA67.1 MAI1.1
POI3.1
MAG-SEQ-NBR Numeric 4 AP25.1 AP25.2
Element: Sequence NumbeAn automatically assigned sequence MA60.3 MA61.1
number. MA64.6 MA66.1
MA66.2 MA66.3
MA67.1 MAI1.1
POI3.1
MAG-API-OBJ-ID Numeric 12 AP125 AP126
Object AP25.1 AP25.2
Identification AP26.1 AP27.1
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 AP25.1 AP25.2
2 = Recon Match AP26.1 AP27.1
3 = DropShip MA60.3 MA61.1
4 = Service MA64.6 MA66.2
MA66.3 MA67.1
MAI1.1 POI3.1
MAG-ITEM Alpha 32 AP125 AP126
Element: Item Number This field contains the item AP25.1 AP25.2
identifier. AP26.1 AP27.1
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 AP25.1 AP25.2
AP26.1 AP27.1
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 AP25.1 AP25.2
transaction. AP26.1 AP27.1
0 = Unreleased MA60.3 MA61.1
1 = Open MA64.6 MA66.2
2 = Pending Action MA66.3 MA67.1
9 = Closed MAI1.1 POI3.1
MAG-ACTION Alpha 1 AP125 AP126
Element: Action " " = Open AP25.1 AP25.2
1 = Approved AP26.1 AP27.1
2 = Chargeback MA60.3 MA61.1
3 = Disapprove MA64.6 MA66.2
4 = Forward MA66.3 MA67.1
5 = Accept Cost MAI1.1 POI3.1
6 = Adjust Cost
7 = Chargeback netted to zero
MAG-OPERATOR Alpha 10 AP125 AP126
Element: Operator Code This field is used to store the login AP25.1 AP25.2
id of the person who entered the record. AP26.1 AP27.1
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: Creation Date The creation date. AP25.1 AP25.2
AP26.1 AP27.1
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 AP25.1 AP25.2
AP26.1 AP27.1
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 AP25.1 AP25.2
group of companies that share a common AP26.1 AP27.1
procurement effort. They buy items and MA60.3 MA61.1
services together. MA64.6 MA66.2
MA66.3 MA67.1
MAI1.1 POI3.1
MAG-BUYER-CODE Alpha 3 AP125 AP126
Element: Buyer The user defined buyer identifier. AP25.1 AP25.2
AP26.1 AP27.1
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 AP25.1 AP25.2
AP26.1 AP27.1
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 AP25.1 AP25.2
AP26.1 AP27.1
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 AP25.1 AP25.2
created because of a picking AP26.1 AP27.1
transaction, or because of a return. MA60.3 MA61.1
Valid values are: MA64.6 MA66.2
"IS" = Picking transaction. MA66.3 MA67.1
"RR" = Return. MAI1.1 POI3.1
~$1 VENDOR
The vendor's identification code.
C = Cost
Q = Quantity
I = Item
NR = No Receipt Line
MAG-VAR-TYPE Alpha 1 AP125 AP126
Element: Var Type The Variance Type field contains the AP25.1 AP25.2
value that represents the variance type AP26.1 AP27.1
for fiscal year variances. MA60.3 MA61.1
MA64.6 MA66.2
Valid values are: MA66.3 MA67.1
A = Variance Amount MAI1.1 POI3.1
P = Variance Percent
" " = Item Difference
O = Invoice Over Receipt
U = Invoice Under Receipt
MAG-REASON-CODE Alpha 4 AP125 AP126
Element: Reason Code This field contains the reason code, AP25.1 AP25.2
which indicates the cause for credit AP26.1 AP27.1
memos. MA60.3 MA61.1
MA64.6 MA66.2
MA66.3 MA67.1
MAI1.1 POI3.1
MAG-PRIORITY Numeric 1 AP125 AP126
Element: Priority NumbeIndicates order of precedence for AP25.1 AP25.2
contracts to determine costing defaults AP26.1 AP27.1
for items. MA60.3 MA61.1
1 = Urgent MA64.6 MA66.1
2 = Normal MA66.2 MA66.3
MA67.1 MAI1.1
POI3.1
MAG-MATCH-OBJ-ID Numeric 12 AP125 AP126
Object AP25.1 AP25.2
Identification AP26.1 AP27.1
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 AP25.1 AP25.2
AP26.1 AP27.1
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 AP25.1 AP25.2
AP26.1 AP27.1
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 AP25.1 AP25.2
location within the company inventory. AP26.1 AP27.1
MA60.3 MA64.6
MA66.2 MA66.3
MA67.1 POI3.1
MAG-PO-COST-UPD Signed 18.5 AP125 AP126
Element: Intl Cost AP25.1 AP25.2
AP26.1 AP27.1
MA64.6 MA66.2
MA66.3 POI3.1
MAINVMSG FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MAGSET1 COMPANY MA64.1 MA64.4
VENDOR MA64.6 MA64.8
INVOICE MA66.1 MA66.2
SUFFIX MA66.3 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 AP25.1 AP25.2
SEQ-NBR AP26.1 AP27.1
AP30.4 AP300
MA60.3 MA61.1
MA66.1 MA66.2
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
|