|
|
BUYER FILE
PO Buyer Master
A file of valid buyers. Contains default and control information.
REFERENCED BY
AP06.1 AP125 AP126 AP131 AP205 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 AP510 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 DR100
IC10.1 IC10.2 IC12.1 IC130 IC141 IC142
IC226 IC243 IC28.1 IC330 IC530 IC590
IC83.1 MA180 MA236 MA264 MA278 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 OE10.1 OE10.2 OE10.3
OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1
OE11.4 OE11.8 OE11.9 OE110 OE111 OE113
OE114 OE116 OE129 OE13.2 OE13.3 OE13.5
OE13.6 OE14.4 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE530
OE81.1 OE810 OE830 OE90.1 OE90.2 PO00.1
PO10.1 PO100 PO101 PO115 PO120 PO122
PO130 PO131 PO133 PO135 PO136 PO15.1
PO15.2 PO150 PO190 PO20.1 PO204 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO220 PO223
PO224 PO225 PO229 PO23.1 PO23.5 PO230
PO25.1 PO25.6 PO25.7 PO251 PO254 PO258
PO26.1 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 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
POA2.2 POAB.1 POI3.1 POI7.1 POIE.1 POII.1
POIJ.1 RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1
RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810 RQIA.1
RQIB.1 RQIC.1 RQID.1 RQIF.1 RQIG.1 RQII.1
RQIJ.1 WH20.2 WH20.7
UPDATED BY
PO04.1 PO04.2
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 This field contains the terminal signon
identifier when this update to the
database was performed.
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 30 (Lower Case) PO04.1
Element: Address 1 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 18.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
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
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 e-mail address.
BUYER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BUYSET1 PROCURE-GROUP AP06.1 AP125
BUYER-CODE AP126 AP131
AP205 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 DR100
IC10.1 IC10.2
IC12.1 IC130
IC141 IC142
...
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
|
