Lawson Insight Technical Documentation |
|
MAINVMSG
MAINVMSG FILE
REFERENCED BY
MA264 MA67.3 MA90.2 MA90.3 MA90.5 PO135
PO136 PO139 PO278
UPDATED BY
AP125 AP126 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA60.3
MA64.6 MA66.1 MA66.2 MA66.3 MA68.3 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 AP20.1 AP20.2
resource type = V. Identifies the HR AP20.3 AP20.4
company if the resource type = E. It is AP20.5 AP20.7
blank for type A, P or Q resources. AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.1 MA66.2
MA66.3 MA68.3
MAI1.1 POI3.1
MAG-AUTH-CODE Alpha 3 AP125 AP126
Element: Auth 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.1 MA66.2
MA66.3 MA68.3
MAI1.1 POI3.1
MAG-VENDOR Alpha 9 (Right Justified) AP125 AP126
Element: Vendor The vendor's identification code. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.1 MA66.2
MA66.3 MA68.3
MAI1.1 POI3.1
MAG-INVOICE Alpha 22 AP125 AP126
Element: Invoice Used to identify the invoice. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.1 MA66.2
MA66.3 MA68.3
MAI1.1 POI3.1
MAG-SUFFIX Numeric 3 AP125 AP126
Element: Suffix This is the suffix for the invoice. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.1 MA66.2
MA66.3 MA68.3
MAI1.1 POI3.1
MAG-CANCEL-SEQ Numeric 4 AP125 AP126
Element: Seq Nbr An automatically assigned sequence AP20.1 AP20.2
number. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.1 MA66.2
MA66.3 MA68.3
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.2 MA66.3
MA68.3 MAI1.1
POI3.1
MAG-PO-RELEASE Numeric 4 AP125 AP126
Element: Po Release 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.2 MA66.3
MA68.3 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.2 MA66.3
MA68.3 MAI1.1
POI3.1
MAG-PO-LINE-NBR Numeric 6 AP125 AP126
Element: Line Nbr This field contains the line number. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.2 MA66.3
MA68.3 MAI1.1
POI3.1
MAG-MAD-SEQ-NBR Numeric 4 AP125 AP126
Element: Seq Nbr An automatically assigned sequence AP20.1 AP20.2
number. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.1 MA66.2
MA66.3 MA68.3
MAI1.1 POI3.1
MAG-SEQ-NBR Numeric 4 AP20.1 AP20.2
Element: Seq Nbr An automatically assigned sequence AP20.3 AP20.4
number. AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.1 MA66.2
MA66.3 MA68.3
MAI1.1 POI3.1
MAG-API-OBJ-ID Numeric 12 AP125 AP126
Element: Obj Id This is the object identifier. It is AP20.1 AP20.2
used to relate commitments or posted AP20.3 AP20.4
transactions back to the originating AP20.5 AP20.7
subsystems. Each subsystem record that AP21.1 AP23.1
is updated as a commitment or posted AP25.1 AP25.2
transaction is assigned an object AP26.1 AP27.1
identifier. The object identifier is API1.1 MA41.1
maintained in the subsystem files and in MA41.2 MA41.4
the Activity Commitments Detail and MA41.7 MA43.1
Activity Transaction files. The object MA43.2 MA43.3
identifier is a unique key used to drill MA60.3 MA64.6
back from Activity Management to the MA66.2 MA66.3
subsystems. MA68.3 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 AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.2 MA66.3
MA68.3 MAI1.1
POI3.1
MAG-ITEM Alpha 32 AP125 AP126
Element: Item This field contains the item AP20.1 AP20.2
identifier. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.1 MA66.2
MA66.3 MA68.3
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.2 MA66.3
MA68.3 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 AP21.1 AP23.1
2 = Pending Action AP25.1 AP25.2
9 = Closed AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.2 MA66.3
MA68.3 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 AP21.1 AP23.1
4 = Forward AP25.1 AP25.2
5 = Accept Cost AP26.1 AP27.1
6 = Adjust Cost API1.1 MA41.1
7 = Chargeback netted to zero MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.2 MA66.3
MA68.3 MAI1.1
POI3.1
MAG-OPERATOR Alpha 10 AP125 AP126
Element: Operator 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.2 MA66.3
MA68.3 MAI1.1
POI3.1
MAG-CREATE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Create Date The creation date. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.2 MA66.3
MA68.3 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.2 MA66.3
MA68.3 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. AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.2 MA66.3
MA68.3 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.2 MA66.3
MA68.3 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.2 MA66.3
MA68.3 MAI1.1
POI3.1
MAG-FWD-AUTH-OPER Alpha 10 AP125 AP126
Element: Operator 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.2 MA66.3
MA68.3 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: AP21.1 AP23.1
"IS" = Picking transaction. AP25.1 AP25.2
"RR" = Return. AP26.1 AP27.1
~$1 VENDOR API1.1 MA41.1
The vendor's identification code. MA41.2 MA41.4
MA41.7 MA43.1
C = Cost MA43.2 MA43.3
Q = Quantity MA60.3 MA64.6
I = Item MA66.2 MA66.3
NR = No Receipt Line MA68.3 MAI1.1
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
AP21.1 AP23.1
Valid values are: AP25.1 AP25.2
A = Variance Amount AP26.1 AP27.1
P = Variance Percent API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
" " = Item Difference MA43.2 MA43.3
O = Invoice Over Receipt MA60.3 MA64.6
U = Invoice Under Receipt MA66.2 MA66.3
MA68.3 MAI1.1
POI3.1
MAG-REASON-CODE Alpha 4 AP125 AP126
Element: 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.2 MA66.3
MA68.3 MAI1.1
POI3.1
MAG-PRIORITY Numeric 1 AP125 AP126
Element: Priority 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 AP21.1 AP23.1
2 = Normal AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.1 MA66.2
MA66.3 MA68.3
MAI1.1 POI3.1
MAG-MATCH-OBJ-ID Numeric 12 AP125 AP126
Element: Obj Id This is the object identifier. It is AP20.1 AP20.2
used to relate commitments or posted AP20.3 AP20.4
transactions back to the originating AP20.5 AP20.7
subsystems. Each subsystem record that AP21.1 AP23.1
is updated as a commitment or posted AP25.1 AP25.2
transaction is assigned an object AP26.1 AP27.1
identifier. The object identifier is API1.1 MA41.1
maintained in the subsystem files and in MA41.2 MA41.4
the Activity Commitments Detail and MA41.7 MA43.1
Activity Transaction files. The object MA43.2 MA43.3
identifier is a unique key used to drill MA60.3 MA64.6
back from Activity Management to the MA66.2 MA66.3
subsystems. MA68.3 MAI1.1
POI3.1
MAG-RESPOND-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This field displays the system date AP20.1 AP20.2
when this was created. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.1 MA66.2
MA66.3 MA68.3
MAI1.1 POI3.1
MAG-DISC-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This field displays the system date AP20.1 AP20.2
when this was created. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.2 MA66.3
MA68.3 MAI1.1
POI3.1
MAG-LOCATION Alpha 5 AP125 AP126
Element: Location This field contains a valid stocking AP20.1 AP20.2
location within the company inventory. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA64.6
MA66.2 MA66.3
MA68.3 MAI1.1
POI3.1
MAG-PO-COST-UPD Signed 18.5 AP125 AP126
Element: Intl Cost AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 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 AP125 AP126
VENDOR AP25.1 AP25.2
INVOICE AP26.1 AP27.1
SUFFIX AP30.4 MA43.1
CANCEL-SEQ MA43.3 MA64.1
MAD-SEQ-NBR MA64.4 MA64.6
SEQ-NBR MA64.8 MA66.1
MA66.2 MA66.3
MA66.8
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP300
MA264 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA60.3 MA66.1
MA66.2 MA66.3
MA67.3 MA68.3
...
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
|