OEPBITEM FILE
Price Book Item
This file stores the comments that have been specified to print for an item
that is to print on the price book.
REFERENCED BY
BL243
UPDATED BY
BL48.1 BL48.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PBI-COMPANY Numeric 4 BL48.3
Company Enter the company number for which the
price book will be established.
PBI-BOOK-NAME Alpha 10 BL48.3
Book Name Enter the price book name. This is a
user-defined name.
PBI-ITEM Alpha 32 BL48.3
Item Number Enter the item that will have the price
lists itemized on the price book.
PBI-COMMENTS Alpha 50 (Lower Case) BL243 BL48.3
Comments Occurs 10 Times
This field contains the text you enter
for the comment to be associated with an
asset. You can have multiple lines of
comments for each comment type.
OEPBITEM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PBISET1 COMPANY BL243 BL48.1
BOOK-NAME BL48.3
ITEM
OEPBITEM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
PBI-COMPANY -> ICC-COMPANY
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
PBI-ITEM -> ITE-ITEM
Oecompany OECOMPANY Required
PBI-COMPANY -> OEC-COMPANY
Oeprcbook OEPRCBOOK Required
PBI-COMPANY -> OPB-COMPANY
PBI-BOOK-NAME -> OPB-BOOK-NAME
Oeprclist1 OEPRCLIST Not Required
PBI-COMPANY -> OPL-COMPANY
"000000000" -> OPL-CUSTOMER
OPB-PRICE-LIST-1 -> OPL-LIST-NAME
Spaces -> OPL-PROMOTION
Oeprclist2 OEPRCLIST Not Required
PBI-COMPANY -> OPL-COMPANY
"000000000" -> OPL-CUSTOMER
OPB-PRICE-LIST-2 -> OPL-LIST-NAME
Spaces -> OPL-PROMOTION
Oeprclist3 OEPRCLIST Not Required
PBI-COMPANY -> OPL-COMPANY
"000000000" -> OPL-CUSTOMER
OPB-PRICE-LIST-3 -> OPL-LIST-NAME
Spaces -> OPL-PROMOTION
OEPBITEM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oebase OEBASE
PBI-COMPANY -> OEB-COMPANY
OPB-BASE-LOC -> OEB-LOCATION
OPB-BASE-NAME -> OEB-BASE-NAME
OEB-CURRENCY-CODE
OEB-ITEM
|