OESTDORDER FILE
Standard Order
The Standard Order file stores standard orders.
REFERENCED BY
OE10.6 OE14.4 OE254
UPDATED BY
OE54.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OSO-COMPANY Numeric 4 OE54.1
Element: Company This field contains the company number.
OSO-CUSTOMER Alpha 9 (Right Justified) OE54.1
Element: Customer NumbeThis field contains the number that
represents a customer.
OSO-STD-ORDER-NBR Alpha 22 OE54.1
Standard Order This field contains the code that
Number represents a standard order. Lines
associated with the standard order
number default onto new orders when the
standard order number is referenced
during order entry.
OSO-DESCRIPTION Alpha 30 (Lower Case) OE54.1
Element: Description This field contains the description of
the standard order.
OSO-BEG-DATE Numeric 8 (yyyymmdd) OE54.1
Element: Beginning DateThis field contains the date when the
order becomes active.
OSO-END-DATE Numeric 8 (yyyymmdd) OE54.1
Element: Ending Date This field contains the date when the
order is no longer active.
OSO-LAST-LINE-NBR Numeric 6 OE54.1
Element: Line Number This field contains the number of the
last line item added to the standard
order. It is used to determine the next
number to assign to the next order.
OSO-TOP-COMM Alpha 4 Occurs 3 Times OE54.1
Element: Standard CommeThis field contains the standard
comment code that prints at the top of
documents created by the Lawson Order
Entry system. Standard comments are set
up on BL03.1 (Standard Comments).
OSO-BOTTOM-COMM Alpha 4 Occurs 3 Times OE54.1
Element: Standard CommeThis field contains the standard
comment code that prints below documents
created by the Lawson Order Entry
system. Standard Comments are set up on
BL03.1 (Standard Comments).
OESTDORDER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OSOSET1 COMPANY OE10.6 OE14.4
CUSTOMER OE254 OE54.1
STD-ORDER-NBR
OESTDORDER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
OSO-COMPANY -> ACO-COMPANY
Arcustgrp ARCUSTGRP Required
ACO-CUST-GROUP -> ACG-CUST-GROUP
Arcustomer ARCUSTOMER Required
OSO-COMPANY -> ACM-COMPANY
OSO-CUSTOMER -> ACM-CUSTOMER
Custdesc CUSTDESC Required
When OSO-CUSTOMER != Spaces
ACO-CUST-GROUP -> CUD-CUST-GROUP
OSO-CUSTOMER -> CUD-CUSTOMER
Oecompany OECOMPANY Required
OSO-COMPANY -> OEC-COMPANY
OESTDORDER FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bottomm Comm OESTDCOMM Required
When OSO-BOTTOM-COMM != Spaces
OSO-COMPANY -> OSC-COMPANY
OSO-BOTTOM-COMM -> OSC-STD-COMM
OSC-LANGUAGE-CODE
OSC-SEQ
Hdr Comments OEORDCMNT
OSO-COMPANY -> OOC-COMPANY
OSO-CUSTOMER -> OOC-CUSTOMER
OSO-STD-ORDER-NBR -> OOC-STD-ORDER-NBR
Zeroes -> OOC-ORDER-NBR
Zeroes -> OOC-LINE-NBR
OOC-SEQ
Oestdline OESTDLINE
OSO-COMPANY -> OSL-COMPANY
OSO-CUSTOMER -> OSL-CUSTOMER
OSO-STD-ORDER-NBR -> OSL-STD-ORDER-NBR
OSL-LINE-NBR
Top Comments OESTDCOMM Required
When OSO-TOP-COMM != Spaces
OSO-COMPANY -> OSC-COMPANY
OSO-TOP-COMM -> OSC-STD-COMM
OSC-LANGUAGE-CODE
OSC-SEQ
Trl Comments OEORDCMNT
OSO-COMPANY -> OOC-COMPANY
OSO-CUSTOMER -> OOC-CUSTOMER
OSO-STD-ORDER-NBR -> OOC-STD-ORDER-NBR
Zeroes -> OOC-ORDER-NBR
9999 -> OOC-LINE-NBR
OOC-SEQ
|
