Invoice and PO Cost Message
REFERENCED BY
MA67.3 | MA68.3 | POIJ.1 | MA264 | MA90.2 | MA90.3 |
MA90.5 | MA90.6 | PO135 | PO139 | PO278 | 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. |
|
||||||||||||
MAG-AUTH-CODE Element: Auth Code | Alpha 3 A user-defined code representing a person or department responsible for approving a registered invoice. |
|
||||||||||||
MAG-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code. |
|
||||||||||||
MAG-INVOICE Element: Invoice | Alpha 22 Used to identify the invoice. |
|
||||||||||||
MAG-SUFFIX Element: Suffix | Numeric 3 This is the suffix for the invoice. |
|
||||||||||||
MAG-CANCEL-SEQ Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||||||||||||
MAG-PO-NUMBER Element: Po Number | Alpha 14 (Right Justified) This field contains the number representing the purchase order. |
|
||||||||||||
MAG-PO-RELEASE Element: Po Release | Numeric 4 Used to identify a purchase order release (created from a Blanket or Standing order). |
|
||||||||||||
MAG-PO-CODE Element: Po Code | Alpha 4 This is the purchase order code. |
|
||||||||||||
MAG-PO-LINE-NBR Element: Line Nbr | Numeric 6 This field contains the line number. |
|
||||||||||||
MAG-MAD-SEQ-NBR Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||||||||||||
MAG-SEQ-NBR Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||||||||||||
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. |
|
||||||||||||
MAG-MSG-ORIGIN Element: Msg Origin | Alpha 1 1 = PO Cost 2 = Recon Match 3 = DropShip 4 = Service |
|
||||||||||||
MAG-ITEM Element: Item | Alpha 32 This field contains the item identifier. |
|
||||||||||||
MAG-MATCH-DTL-KEY Element: Match Dtl Key | Alpha 85 |
|
||||||||||||
MAG-STATUS Element: Status | Numeric 1 This field displays the status of the transaction. 0 = Unreleased 1 = Open 2 = Pending Action 9 = Closed |
|
||||||||||||
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 |
|
||||||||||||
MAG-OPERATOR Element: Operator | Alpha 10 This field is used to store the login id of the person who entered the record. |
|
||||||||||||
MAG-CREATE-DATE Element: Create Date | Numeric 8 (yyyymmdd) The creation date. |
|
||||||||||||
MAG-CREATE-TIME Element: Sys Time | Numeric 6 (hhmmss) |
|
||||||||||||
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. |
|
||||||||||||
MAG-BUYER-CODE Element: Buyer | Alpha 3 |
|
||||||||||||
MAG-AUTH-CODE-MAIL Element: Auth Code Mail | Alpha 30 |
|
||||||||||||
MAG-FWD-AUTH-OPER Element: Operator | Alpha 10 This field is used to store the login id of the person who entered the record. |
|
||||||||||||
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 |
|
||||||||||||
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 |
|
||||||||||||
MAG-REASON-CODE Element: Reason Code | Alpha 4 This field contains the reason code, which indicates the cause for credit memos. |
|
||||||||||||
MAG-PRIORITY Element: Priority | Numeric 1 Indicates order of precedence for contracts to determine costing defaults for items. 1 = Urgent 2 = Normal |
|
||||||||||||
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. |
|
||||||||||||
MAG-RESPOND-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||||||||||||
MAG-DISC-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||||||||||||
MAG-LOCATION Element: Location | Alpha 5 This field contains a valid stocking location within the company inventory. |
|
||||||||||||
MAG-PO-COST-UPD Element: Intl Cost | Signed 18.5 |
|
||||||||||||
MAG-VEN-ITEM Element: Item | Alpha 32 |
|
||||||||||||
MAG-GTIN Element: Gtin | Numeric 14 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MAGSET1 |
COMPANY VENDOR INVOICE SUFFIX CANCEL-SEQ MAD-SEQ-NBR SEQ-NBR |
|
| ||||||||||||||||||||||||||||
MAGSET10 |
COMPANY AUTH-CODE GTIN VAR-TYPE TYPE API-OBJ-ID MAD-SEQ-NBR SEQ-NBR |
|
|||||||||||||||||||||||||||||
MAGSET2 |
COMPANY AUTH-CODE PO-NUMBER PO-RELEASE PO-CODE INVOICE PO-LINE-NBR MAD-SEQ-NBR VENDOR API-OBJ-ID SEQ-NBR |
|
| ||||||||||||||||||||||||||||
MAGSET3 |
COMPANY AUTH-CODE ITEM VAR-TYPE TYPE API-OBJ-ID MAD-SEQ-NBR SEQ-NBR |
|
| ||||||||||||||||||||||||||||
MAGSET4 |
COMPANY AUTH-CODE MATCH-DTL-KEY VAR-TYPE TYPE API-OBJ-ID MAD-SEQ-NBR SEQ-NBR |
|
| ||||||||||||||||||||||||||||
MAGSET5 |
API-OBJ-ID MAD-SEQ-NBR SEQ-NBR |
|
|||||||||||||||||||||||||||||
MAGSET6 |
COMPANY AUTH-CODE VENDOR INVOICE SUFFIX CANCEL-SEQ SEQ-NBR |
|
| ||||||||||||||||||||||||||||
MAGSET7 |
COMPANY STATUS OPERATOR MSG-ORIGIN CREATE-DATE RESPOND-DATE VENDOR API-OBJ-ID MAD-SEQ-NBR SEQ-NBR |
|
| ||||||||||||||||||||||||||||
MAGSET8 |
COMPANY STATUS AUTH-CODE MSG-ORIGIN CREATE-DATE RESPOND-DATE VENDOR API-OBJ-ID MAD-SEQ-NBR SEQ-NBR |
|
| ||||||||||||||||||||||||||||
MAGSET9 |
COMPANY AUTH-CODE VEN-ITEM VAR-TYPE TYPE API-OBJ-ID MAD-SEQ-NBR SEQ-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Pomatchobj | POMATCHOBJ |
|
All trademarks and registered trademarks are the property of their
respective owners.