|
|
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
Company The company number represents an
established company and is entered on
all function codes.
OPB-BOOK-NAME Alpha 10 BL243 BL48.1
Book Name Enter the price book identifier.
OPB-BASE-LOC Alpha 5 BL48.1
Base Location 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
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
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
Description Description of price book is entered in
this field.
OPB-PRICE-LIST-1 Alpha 14 BL243 BL48.1
Price List Name - The price list that will print in
Column 1 column 1 of the price book.
OPB-PRICE-LIST-2 Alpha 14 BL243 BL48.1
Price List Name - The price list that will print in
Column 2 column 2 of the price book.
OPB-PRICE-LIST-3 Alpha 14 BL243 BL48.1
Price List Name - The price list that will print in
Column 3 column 3 of the price book.
OPB-COMMENTS Alpha 50 (Lower Case) BL243 BL48.1
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
|