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