MAWORKQ

UPDATED BY
MA167 MA67.1 MA67.2 MA67.3

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WRQ-ID
Element: Web User Id		Alpha 15 (Lower Case)
MA167 MA67.1
WRQ-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.
MA167 MA67.1
WRQ-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code.
MA167 MA67.1
WRQ-VENDOR-SNAME
Element: Vendor Name		Alpha 30
The requester can enter the recommended vendor's name for the requested items.
MA167 MA67.1
WRQ-INVOICE
Element: Invoice		Alpha 22
Used to identify the invoice.
MA167 MA67.1
WRQ-SUFFIX
Element: Suffix		Numeric 3
This is the suffix for the invoice.
MA167 MA67.1
WRQ-CANCEL-SEQ
Element: Seq Nbr		Numeric 4
An automatically assigned sequence number.
MA167 MA67.1
WRQ-PO-NUMBER
Element: Po Number		Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
MA167 MA67.1
WRQ-PO-RELEASE
Element: Po Release		Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
MA167 MA67.1
WRQ-PO-CODE
Element: Po Code		Alpha 4
This is the purchase order code.
MA167 MA67.1
WRQ-DUE-DATE
Element: Due Date		Numeric 8 (yyyymmdd)
The transaction due date.
MA167 MA67.1
WRQ-INVOICE-AMT
Element: Inv Amt		Numeric 16
MA167 MA67.1
WRQ-INV-COMMENTS
Element: Comment Fl		Alpha 1
MA167 MA67.1
WRQ-PO-COMMENTS
Element: Comment Fl		Alpha 1
MA167 MA67.1
WRQ-SERVICE-LINES
Element: Service Fl		Alpha 1
This field indicates a transaction is a Service only transaction.
MA167 MA67.1
WRQ-BUYER
Element: Buyer		Alpha 3
WRQ-LOCATION
Element: Location		Alpha 5
This field contains a valid stocking location within the company inventory.
WRQ-OPERATOR
Element: Operator		Alpha 10
This field is used to store the login id of the person who entered the record.
WRQ-EXT-UNIT-WAOC
Element: Intl Cost		Signed 18.5
WRQ-CB-TYPE
Element: Cb Type		Alpha 1


MAWORKQ FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WRQSET1 ID
VENDOR-SNAME
VENDOR
COMPANY
INVOICE
SUFFIX
CANCEL-SEQ
MA167 MA67.1
MA67.2 MA67.3
WRQSET2 ID
DUE-DATE
COMPANY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
WRQSET3 ID
INVOICE-AMT
COMPANY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
MA167 MA67.1
WRQSET4 ID
COMPANY
VENDOR-SNAME
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
MA67.1
WRQSET5 ID
INVOICE
COMPANY
VENDOR
SUFFIX
CANCEL-SEQ


MAWORKQ FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
WRQ-COMPANY->CPY-COMPANY (CPYSET1)
Apinvoice APINVOICE Required
WRQ-COMPANY->API-COMPANY
WRQ-VENDOR->API-VENDOR
WRQ-INVOICE->API-INVOICE
WRQ-SUFFIX->API-SUFFIX
WRQ-CANCEL-SEQ->API-CANCEL-SEQ


MAWORKQ FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Mainvdtl MAINVDTL
WRQ-COMPANY->MAD-COMPANY
WRQ-VENDOR->MAD-VENDOR
WRQ-INVOICE->MAD-INVOICE
WRQ-SUFFIX->MAD-SUFFIX
WRQ-PO-NUMBER->MAD-PO-NUMBER
WRQ-PO-RELEASE->MAD-PO-RELEASE
WRQ-PO-CODE->MAD-PO-CODE
  MAD-LINE-NBR
  MAD-SEQ-NBR
Mapoinv MAPOINV
WRQ-COMPANY->AOI-COMPANY
WRQ-VENDOR->AOI-VENDOR
WRQ-INVOICE->AOI-INVOICE
WRQ-SUFFIX->AOI-SUFFIX
  AOI-PO-NUMBER
  AOI-PO-RELEASE
  AOI-PO-CODE
Porset9 PORECEIVE
WRQ-COMPANY->POR-COMPANY
WRQ-VENDOR->POR-VENDOR
WRQ-PO-CODE->POR-PO-CODE
WRQ-PO-NUMBER->POR-PO-NUMBER
WRQ-PO-RELEASE->POR-PO-RELEASE
  POR-LOCATION
  POR-REC-NUMBER

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

Home
Contact Us



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