|
|
BUYER FILE
PO Buyer Master
A file of valid buyers. Contains default and control information.
REFERENCED BY
AP06.1 AP125 AP126 AP131 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP205 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP30.4 AP510
API1.1 DR100 IC10.1 IC10.2 IC12.1 IC130
IC141 IC142 IC226 IC243 IC28.1 IC330
IC530 IC590 IC83.1 MA180 MA236 MA264
MA278 MA41.2 MA41.7 MA43.1 MA43.2 MA43.3
MA43.9 MA53.1 MA530 MA531 MA60.1 MA60.2
MA60.3 MA60.5 MA61.1 MA64.1 MA64.2 MA64.3
MA64.5 MA64.6 MA66.1 MA66.2 MA66.3 MA67.1
MA67.2 MA70.1 MA75.1 MA80.1 MAI1.1 PO00.1
PO10.1 PO100 PO101 PO115 PO120 PO122
PO130 PO131 PO133 PO135 PO136 PO139
PO15.1 PO15.2 PO150 PO190 PO20.1 PO204
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO220 PO223 PO224 PO225 PO229 PO23.1
PO23.5 PO230 PO25.1 PO25.5 PO25.6 PO25.7
PO251 PO254 PO258 PO26.1 PO27.2 PO275
PO276 PO277 PO280 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
PO54.1 PO54.2 PO54.3 PO54.4 PO58.1 PO58.2
PO64.1 POA2.2 POAB.1 POI3.1 POI7.1 POII.1
POIJ.1 RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1
RQ35.1 RQ44.1 RQ500 RQ810 RQIA.1 RQIB.1
RQIC.1 RQID.1 RQIE.1 RQIF.1 RQIG.1 RQII.1
RQIJ.1 WH20.2 WH20.7
UPDATED BY
PO04.1 PO04.2 PO780
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BUY-PROCURE-GROUP Alpha 4 PO04.1
Element: Procure Group This field contains the identifier for a
group of companies that share a common
procurement effort. They buy items and
services together.
BUY-BUYER-CODE Alpha 3 PO04.1
Element: Buyer The user-defined buyer identifier.
BUY-OPERATOR-ID Alpha 10 PO04.1
Element: Operator Code
BUY-BUYER-GRP Alpha 5 MA180 PO04.1
Element: Buyer Group The buyer's buyer group code.
BUY-NAME Alpha 30 (Lower Case) IC590 PO04.1
Element: Name The buyer's name. RQ01.1 RQ810
BUY-ADDR1 Alpha 30 (Lower Case) PO04.1
Element: Address 1 The buyer's first line of address
information.
BUY-ADDR2 Alpha 30 (Lower Case) PO04.1
Element: Address 1 The buyer's second line of address
information.
BUY-ADDR3 Alpha 30 (Lower Case) PO04.1
Element: Address 1 The buyer's third line of address
information.
BUY-ADDR4 Alpha 30 (Lower Case) IC590 PO04.1
Element: Address 1 The buyer's fourth line of address
information.
BUY-CITY-ADDR5 Alpha 18 (Lower Case) PO04.1
Element: City This is the buyer's city or the fifth
line of address information.
BUY-STATE-PROV Alpha 2 PO04.1
Element: State or ProviThis is the buyer's state or province.
BUY-POSTAL-CODE Alpha 10 (Lower Case) PO04.1
Element: Postal Code This is the buyer's mail code.
BUY-COUNTRY Alpha 30 (Lower Case) PO04.1
Element: Country or OthThis field contains the country of the
address, or it can be used for
additional information such as an
attention name.
BUY-PHONE-PREFIX Alpha 6 PO04.1
Telephone Country The buyer's telephone prefix.
Code
BUY-PHONE Alpha 15 PO04.1
Element: Telephone NumbThe buyer's telephone number.
BUY-PHONE-EXT Alpha 5 PO04.1
Element: Telephone ExteThe buyer's telephone extension number.
BUY-PO-LIMIT Signed 15.2 PO04.1
Element: Limit Per PO The buyer's per purchase order amount
limit.
BUY-ACTIVE-STATUS Alpha 1 PO04.1
Element: Status The status of the account. If Inactive,
no posting can be done to the account.
A = Active
I = Inactive
BUY-CLASS-ONLY-FL Alpha 1 PO04.1 PO04.2
Element: Class Only Fl Y = Yes
N = No
BUY-FIL-BUYER-CODE Alpha 1 PO04.1
Element: Fil Buyer CodeY = Yes
" "
BUY-FIL-BUY-PUR-CL Alpha 1 PO04.1
Element: Fil Buy Pur ClY = Yes
" "
BUY-FIL-BUY-VEN-FL Alpha 1 PO04.1
Element: Fil Buy Ven FlY = Yes
" "
BUY-FIL-BUY-LOC-FL Alpha 1 PO04.1
Element: Fil Buy Loc FlY = Yes
" "
BUY-FIL-BUY-RQL-FL Alpha 1 PO04.1
Element: Fil Buy Rql FlY = Yes
" "
BUY-FIL-VEN-OPTION Alpha 1 PO04.1
Element: Fil Ven OptionY = Items with no vendor
" "
BUY-FIL-DEL-DAYS Numeric 3 PO04.1
Element: Fil Del Days
BUY-FIL-FRM-PRI Numeric 2 PO04.1
Element: Fil Frm Pri
BUY-FIL-TO-PRI Numeric 2 PO04.1
Element: Fil To Pri
BUY-FIL-NO-COST Alpha 1 PO04.1
Element: Fil No Cost Y = Items with no cost
" "
BUY-FIL-PO-CODE Alpha 4 PO04.1
Element: Fil Po Code
BUY-FIL-MANUF-CODE Alpha 4 PO04.1
Element: Fil Manuf Code
BUY-FIL-MANUF-DIV Alpha 4 PO04.1
Element: Fil Manuf Div
BUY-FIL-AGRMT Alpha 30 PO04.1
Element: Fil Agrmt
BUY-FIL-ITEM-TYPE Alpha 1 PO04.1
Element: Fil Item Type I = Inventory
N = Non Stock
X = Special
S = Service
BUY-MAN-OVER-ALWD Alpha 1
Element: Man Over Alwd If set to "Y", this field indicates that
unit costs manually entered for a
Purchase will be "held" and not
overridden by the cost default routine.
Y = Yes
N = No
BUY-OVER-AGRMT Alpha 1 PO04.1 PO780
Element: Over Agrmt Enter a Y to indicate the user can
manually enter a cost which will not be
overridden by an existing price
agreement.
Y = Yes
N = No
BUY-OVER-LC-LP Alpha 1 PO04.1 PO780
Element: Over Lc Lp Enter a Y to indicate the user can
manually enter a cost which will not be
overridden by a last cost or last PO
created cost default.
Y = Yes
N = No
BUY-EMAIL-ADDRESS Alpha 60 (Lower Case) PO04.1
Element: Email Address
BUYER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BUYSET1 PROCURE-GROUP AP06.1 AP125
BUYER-CODE AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP205 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP510
API1.1 DR100
IC10.1 IC10.2
IC12.1 IC130
IC141 IC142
IC226 IC243
IC28.1 IC330
...
BUYSET2 PROCURE-GROUP KeyChange MA278 PO04.1
BUYER-GRP PO115 PO120
BUYER-CODE PO15.1 PO15.2
PO204 PO220
PO223 PO224
PO225 PO229
PO230 PO251
PO254 PO275
PO276 PO277
PO280 PO54.1
PO54.2 PO54.3
PO54.4 POAB.1
BUYSET3 PROCURE-GROUP KeyChange, Subset PO04.1 PO23.1
OPERATOR-ID Where OPERATOR-ID != Spaces POII.1 POIJ.1
BUYER FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Buyclass BUYCLASS
BUY-PROCURE-GROUP -> BCL-PROCURE-GROUP
BUY-BUYER-CODE -> BCL-BUYER-CODE
BCL-PURCH-MAJCL
BCL-PURCH-MINCL
Buycmploc BUYCMPLOC
BUY-PROCURE-GROUP -> BYC-PROCURE-GROUP
BUY-BUYER-CODE -> BYC-BUYER-CODE
BYC-COMPANY
BYC-LOCATION
BYC-REQ-LOCATION
Buyvenpf BUYVENPF
BUY-PROCURE-GROUP -> BVP-PROCURE-GROUP
BUY-BUYER-CODE -> BVP-BUYER-CODE
BVP-VENDOR
BVP-PURCH-FR-LOC
|
