|
|
OEPRCBOOK FILE
Price Book
This file stores price books that have been set up online. Price books are
used to print out pricing information in a booklet format. The report that
actually prints the books out is BL243 (Price Book Print).
REFERENCED BY
BL243
UPDATED BY
BL00.1 BL48.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OPB-COMPANY Numeric 4 BL48.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.
OPB-BOOK-NAME Alpha 10 BL243 BL48.1
Element: Base Name Enter the price book identifier.
OPB-BASE-LOC Alpha 5 BL48.1
Element: Location Code Enter the price base location if your
company uses location-based pricing.
Location-based pricing indicates that
base list pricing can differ for the
same item, depending on where it is
shipped from.
OPB-BASE-NAME Alpha 10 BL48.1
Element: Base Name The price base name that will be
referenced by price lists specified in
the fields below.
OPB-CURRENCY-CODE Alpha 5 BL48.1
Element: Currency Code This field contains the company's base
currency code established in the General
Ledger system.
OPB-DESCRIPTION Alpha 30 (Lower Case) BL243 BL48.1
Element: Description Description of price book is entered in
this field.
OPB-PRICE-LIST-1 Alpha 14 BL243 BL48.1
Element: Price Lst The price list that will print in
column 1 of the price book.
OPB-PRICE-LIST-2 Alpha 14 BL243 BL48.1
Element: Price Lst The price list that will print in
column 2 of the price book.
OPB-PRICE-LIST-3 Alpha 14 BL243 BL48.1
Element: Price Lst The price list that will print in
column 3 of the price book.
OPB-COMMENTS Alpha 50 (Lower Case) BL243 BL48.1
Element: Comments Occurs 10 Times
You can enter comments here and they
will print at the beginning of the price
book.
OEPRCBOOK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OPBSET1 COMPANY BL00.1 BL243
BOOK-NAME BL48.1 BL48.2
BL48.3
OPBSET2 COMPANY KeyChange BL243
BASE-NAME
BOOK-NAME
OEPRCBOOK FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cucodes CUCODES Required
OPB-CURRENCY-CODE -> CUC-CURRENCY-CODE
Iccompany ICCOMPANY Not Required
OPB-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
When OPB-BASE-LOC != Spaces
OPB-COMPANY -> ICL-COMPANY
OPB-BASE-LOC -> ICL-LOCATION
Oecompany OECOMPANY Required
OPB-COMPANY -> OEC-COMPANY
Oeprclist1 OEPRCLIST Required
When OPB-PRICE-LIST-1 != Spaces
OPB-COMPANY -> OPL-COMPANY
Spaces -> OPL-CUSTOMER
OPB-PRICE-LIST-1 -> OPL-LIST-NAME
Spaces -> OPL-PROMOTION
Oeprclist2 OEPRCLIST Required
When OPB-PRICE-LIST-2 != Spaces
OPB-COMPANY -> OPL-COMPANY
Spaces -> OPL-CUSTOMER
OPB-PRICE-LIST-2 -> OPL-LIST-NAME
Spaces -> OPL-PROMOTION
Oeprclist3 OEPRCLIST Required
When OPB-PRICE-LIST-3 != Spaces
OPB-COMPANY -> OPL-COMPANY
Spaces -> OPL-CUSTOMER
OPB-PRICE-LIST-3 -> OPL-LIST-NAME
Spaces -> OPL-PROMOTION
OEPRCBOOK FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemmast ITEMMAST
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
ITE-ITEM
Oebase OEBASE Required
OPB-COMPANY -> OEB-COMPANY
OPB-BASE-LOC -> OEB-LOCATION
OPB-BASE-NAME -> OEB-BASE-NAME
OPB-CURRENCY-CODE -> OEB-CURRENCY-CODE
OEB-ITEM
Oepbclass OEPBCLASS Delete Cascades
OPB-COMPANY -> PBC-COMPANY
OPB-BOOK-NAME -> PBC-BOOK-NAME
PBC-MAJOR-SCLASS
PBC-MINOR-SCLASS
Oepbitem OEPBITEM Delete Cascades
OPB-COMPANY -> PBI-COMPANY
OPB-BOOK-NAME -> PBI-BOOK-NAME
PBI-ITEM
|
