MAINVMSG

REFERENCED BY
MA61.1 PO136


UPDATED BY
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP21.1 AP23.1 AP25.2 AP30.4 AP300 API1.1
MA264 MA41.1 MA41.2 MA41.4 MA41.7 MA42.1
MA42.2 MA43.1 MA43.2 MA43.3 MA44.1 MA44.2
MA60.3 MA64.1 MA64.2 MA64.3 MA64.4 MA64.6
MA64.8 MA64.9 MA66.1 MA66.2 MA66.3 MA66.8
MA67.3 MA68.3 MA70.1 MA731 MA75.1 MA90.2
MA90.3 MA90.5 MA90.6 MAI1.1 PO135 PO139
PO278 POI3.1 POIJ.1 MM280 MM80.1 MM80.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAG-COMPANY
Element: Company		Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.1
MA66.2 MA66.3
MAI1.1 POI3.1
MAG-AUTH-CODE
Element: Auth Code		Alpha 3
A user-defined code representing a person or department responsible for approving a registered invoice.
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.1
MA66.2 MA66.3
MAI1.1 POI3.1
MAG-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code.
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.1
MA66.2 MA66.3
MAI1.1 POI3.1
MAG-INVOICE
Element: Invoice		Alpha 22
Used to identify the invoice.
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.1
MA66.2 MA66.3
MAI1.1 POI3.1
MAG-SUFFIX
Element: Suffix		Numeric 3
This is the suffix for the invoice.
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.1
MA66.2 MA66.3
MAI1.1 POI3.1
MAG-CANCEL-SEQ
Element: Seq Nbr		Numeric 4
An automatically assigned sequence number.
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.1
MA66.2 MA66.3
MAI1.1 POI3.1
MAG-PO-NUMBER
Element: Po Number		Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.2
MA66.3 MAI1.1
POI3.1
MAG-PO-RELEASE
Element: Po Release		Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.2
MA66.3 MAI1.1
POI3.1
MAG-PO-CODE
Element: Po Code		Alpha 4
This is the purchase order code.
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.2
MA66.3 MAI1.1
POI3.1
MAG-PO-LINE-NBR
Element: Line Nbr		Numeric 6
This field contains the line number.
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.2
MA66.3 MAI1.1
POI3.1
MAG-MAD-SEQ-NBR
Element: Seq Nbr		Numeric 4
An automatically assigned sequence number.
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.1
MA66.2 MA66.3
MAI1.1 POI3.1
MAG-SEQ-NBR
Element: Seq Nbr		Numeric 4
An automatically assigned sequence number.
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.1
MA66.2 MA66.3
MAI1.1 POI3.1
MAG-API-OBJ-ID
Element: Obj Id		Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.2
MA66.3 MAI1.1
POI3.1
MAG-MSG-ORIGIN
Element: Msg Origin		Alpha 1

1 = PO Cost
2 = Recon Match
3 = DropShip
4 = Service
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.2
MA66.3 MAI1.1
POI3.1
MAG-ITEM
Element: Item		Alpha 32
This field contains the item identifier.
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.1
MA66.2 MA66.3
MAI1.1 POI3.1
MAG-MATCH-DTL-KEY
Element: Match Dtl Key		Alpha 85
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.2
MA66.3 MAI1.1
POI3.1
MAG-STATUS
Element: Status		Numeric 1
This field displays the status of the transaction.
0 = Unreleased
1 = Open
2 = Pending Action
9 = Closed
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA64.9
MA66.2 MA66.3
MAI1.1 POI3.1
MAG-ACTION
Element: Action		Alpha 1

" " = Open
1 = Approved
2 = Chargeback
3 = Disapprove
4 = Forward
5 = Accept Cost
6 = Adjust Cost
7 = Chargeback netted to zero
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA64.9
MA66.2 MA66.3
MAI1.1 POI3.1
MAG-OPERATOR
Element: Operator		Alpha 10
This field is used to store the login id of the person who entered the record.
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.2
MA66.3 MAI1.1
POI3.1
MAG-CREATE-DATE
Element: Create Date		Numeric 8 (yyyymmdd)
The creation date.
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.2
MA66.3 MAI1.1
POI3.1
MAG-CREATE-TIME
Element: Sys Time		Numeric 6 (hhmmss)
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.2
MA66.3 MAI1.1
POI3.1
MAG-PROCURE-GROUP
Element: Procure Group		Alpha 4
This field contains the identifier for a group of companies that share a common procurement effort. They buy items and services together.
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.2
MA66.3 MAI1.1
POI3.1
MAG-BUYER-CODE
Element: Buyer		Alpha 3
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.2
MA66.3 MAI1.1
POI3.1
MAG-AUTH-CODE-MAIL
Element: Auth Code Mail		Alpha 30
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.2
MA66.3 MAI1.1
POI3.1
MAG-FWD-AUTH-OPER
Element: Operator		Alpha 10
This field is used to store the login id of the person who entered the record.
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA64.9
MA66.2 MA66.3
MAI1.1 POI3.1
MAG-TYPE
Element: Type		Alpha 2
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
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.2
MA66.3 MAI1.1
POI3.1
MAG-VAR-TYPE
Element: Var Type		Alpha 1
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
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.2
MA66.3 MAI1.1
POI3.1
MAG-REASON-CODE
Element: Reason Code		Alpha 4
This field contains the reason code, which indicates the cause for credit memos.
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA64.9
MA66.2 MA66.3
MAI1.1 POI3.1
MAG-PRIORITY
Element: Priority		Numeric 1
Indicates order of precedence for contracts to determine costing defaults for items.
1 = Urgent
2 = Normal
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.1
MA66.2 MA66.3
MAI1.1 POI3.1
MAG-MATCH-OBJ-ID
Element: Obj Id		Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.2
MA66.3 MAI1.1
POI3.1
MAG-RESPOND-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA64.9
MA66.1 MA66.2
MA66.3 MAI1.1
POI3.1
MAG-DISC-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.2
MA66.3 MAI1.1
POI3.1
MAG-LOCATION
Element: Location		Alpha 5
This field contains a valid stocking location within the company inventory.
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA66.2
MA66.3 MAI1.1
POI3.1
MAG-PO-COST-UPD
Element: Intl Cost		Signed 18.5
API1.1 MA43.1
MA43.3 MA44.1
MA64.6 MA64.9
MA66.2 MA66.3
MAI1.1 POI3.1
MAG-VEN-ITEM
Element: Item		Alpha 32
API1.1 MA43.1
MA43.3 MA44.1
MA66.2 MA66.3
MAI1.1 POI3.1
MAG-GTIN
Element: Gtin		Numeric 14
MA43.1 MA43.3
MA44.1 MA66.2
MA66.3 MAI1.1


MAINVMSG FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MAGSET1 COMPANY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
MAD-SEQ-NBR
SEQ-NBR
AP30.4 MA42.1
MA43.1 MA43.3
MA44.1 MA60.3
MA64.1 MA64.4
MA64.6 MA64.8
MA64.9 MA66.1
MA66.2 MA66.3
MA66.8 MA67.3
MA68.3 MA70.1
MA731 MA75.1
MAI1.1 POIJ.1
MAGSET10 COMPANY
AUTH-CODE
GTIN
VAR-TYPE
TYPE
API-OBJ-ID
MAD-SEQ-NBR
SEQ-NBR
Subset
WhereSTATUS =1
MAGSET2 COMPANY
AUTH-CODE
PO-NUMBER
PO-RELEASE
PO-CODE
INVOICE
PO-LINE-NBR
MAD-SEQ-NBR
VENDOR
API-OBJ-ID
SEQ-NBR
KeyChange, Subset
WhereSTATUS =1
MA64.2
MAGSET3 COMPANY
AUTH-CODE
ITEM
VAR-TYPE
TYPE
API-OBJ-ID
MAD-SEQ-NBR
SEQ-NBR
KeyChange, Subset
WhereSTATUS =1
MA64.3
MAGSET4 COMPANY
AUTH-CODE
MATCH-DTL-KEY
VAR-TYPE
TYPE
API-OBJ-ID
MAD-SEQ-NBR
SEQ-NBR
KeyChange, Subset
WhereSTATUS =1
MA64.3
MAGSET5 API-OBJ-ID
MAD-SEQ-NBR
SEQ-NBR
...
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.2 AP30.4
AP300 MA264
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.1
MA43.2 MA43.3
MA44.1 MA44.2
MA60.3 MA61.1
MA66.1 MA66.2
MA66.3 MA66.8
MA67.3 MA70.1
MAGSET6 COMPANY
AUTH-CODE
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
KeyChange, Subset
WhereSTATUS =1
MA64.1
MAGSET7 COMPANY
STATUS
OPERATOR
MSG-ORIGIN
CREATE-DATE
RESPOND-DATE
VENDOR
API-OBJ-ID
MAD-SEQ-NBR
SEQ-NBR
KeyChange
MA264
MAGSET8 COMPANY
STATUS
AUTH-CODE
MSG-ORIGIN
CREATE-DATE
RESPOND-DATE
VENDOR
API-OBJ-ID
MAD-SEQ-NBR
SEQ-NBR
KeyChange
MA264
MAGSET9 COMPANY
AUTH-CODE
VEN-ITEM
VAR-TYPE
TYPE
API-OBJ-ID
MAD-SEQ-NBR
SEQ-NBR
Subset
WhereSTATUS =1
MA64.3


MAINVMSG FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Pomatchobj POMATCHOBJ
MAG-COMPANY->PMJ-COMPANY
MAG-PO-NUMBER->PMJ-PO-NUMBER
MAG-PO-RELEASE->PMJ-PO-RELEASE
MAG-PO-CODE->PMJ-PO-CODE
MAG-PO-LINE-NBR->PMJ-LINE-NBR
  PMJ-TRAN-DATE
  PMJ-TRAN-TIME
  PMJ-MATCH-OBJ-ID
  PMJ-MATCH-SEQ-NBR
  PMJ-TYPE

File created: Thu Jun 09 11:20:25 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.