 |
Lawson Insight Technical Documentation |
|
BUYER FILE
PO Buyer Master
A file of valid buyers. Contains default and control information.
REFERENCED BY
AP06.1 AP205 AP510 DR100 IC12.1 IC130
IC141 IC142 IC226 IC243 IC330 IC530
IC590 IC83.1 MA278 MA53.1 PO00.1 PO10.1
PO120 PO130 PO133 PO135 PO136 PO15.1
PO15.2 PO190 PO204 PO220 PO223 PO224
PO225 PO230 PO251 PO26.1 PO275 PO276
PO277 PO280 PO60.1 PO61.1 PO62.1 POA2.2
POAB.1 POI7.1 POIJ.1 RQ01.1 RQ11.1 RQ44.1
RQ810
UPDATED BY
PO04.1 PO04.2 PO780
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BUY-PROCURE-GROUP Alpha 4 PO04.1 PO61.1
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
Buyer Code The user-defined buyer identifier.
BUY-OPERATOR-ID Alpha 10 PO04.1
Operator This field contains the terminal signon
Identification Code identifier when this update to the
database was performed.
BUY-BUYER-GRP Alpha 5 PO04.1
Buyer Group The buyer's buyer group code.
BUY-NAME Alpha 30 (Lower Case) IC590 PO04.1
Name The buyer's name. RQ01.1 RQ810
BUY-ADDR1 Alpha 30 (Lower Case) PO04.1
Address 1 The buyer's first line of address
information.
BUY-ADDR2 Alpha 30 (Lower Case) PO04.1
Address 2 The buyer's second line of address
information.
BUY-ADDR3 Alpha 30 (Lower Case) PO04.1
Address 3 The buyer's third line of address
information.
BUY-ADDR4 Alpha 30 (Lower Case) IC590 PO04.1
Address 4 The buyer's fourth line of address
information.
BUY-CITY-ADDR5 Alpha 18 (Lower Case) PO04.1
City or Address 5 This is the buyer's city or the fifth
line of address information.
BUY-STATE-PROV Alpha 2 PO04.1
State or Province This is the buyer's state or province.
BUY-POSTAL-CODE Alpha 10 (Lower Case) PO04.1
Postal Code This is the buyer's mail code.
BUY-COUNTRY Alpha 30 (Lower Case) PO04.1
Country or Other This 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
Telephone Number The buyer's telephone number.
BUY-PHONE-EXT Alpha 5 PO04.1
Telephone Extension The buyer's telephone extension number.
BUY-PO-LIMIT Signed 15.2 PO04.1
Limit Per PO The buyer's per purchase order amount
limit.
BUY-ACTIVE-STATUS Alpha 1 PO04.1
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
Class Only Fl Y = Yes
N = No
BUY-FIL-BUYER-CODE Alpha 1 PO04.1
Fil Buyer Code Y = Yes
" "
BUY-FIL-BUY-PUR-CL Alpha 1 PO04.1
Fil Buy Pur Cl Y = Yes
" "
BUY-FIL-BUY-VEN-FL Alpha 1 PO04.1
Fil Buy Ven Fl Y = Yes
" "
BUY-FIL-BUY-LOC-FL Alpha 1 PO04.1
Fil Buy Loc Fl Y = Yes
" "
BUY-FIL-BUY-RQL-FL Alpha 1 PO04.1
Fil Buy Rql Fl Y = Yes
" "
BUY-FIL-VEN-OPTION Alpha 1 PO04.1
Fil Ven Option Y = Items with no vendor
" "
BUY-FIL-DEL-DAYS Numeric 3 PO04.1
Fil Del Days
BUY-FIL-FRM-PRI Numeric 2 PO04.1
Fil Frm Pri
BUY-FIL-TO-PRI Numeric 2 PO04.1
Fil To Pri
BUY-FIL-NO-COST Alpha 1 PO04.1
Fil No Cost Y = Items with no cost
" "
BUY-FIL-PO-CODE Alpha 4 PO04.1
Fil Po Code
BUY-FIL-MANUF-CODE Alpha 4 PO04.1
Fil Manuf Code
BUY-FIL-MANUF-DIV Alpha 4 PO04.1
Fil Manuf Div
BUY-FIL-AGRMT Alpha 30 PO04.1
Fil Agrmt
BUY-FIL-ITEM-TYPE Alpha 1 PO04.1
Fil Item Type I = Inventory
N = Non Stock
X = Special
S = Service
BUY-MAN-OVER-ALWD Alpha 1
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
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
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-SET-COST-OPT Alpha 1 PO04.1 PO780
Set Cost Opt Enter a Y to indicate the user is
allowed to enter a cost option 2 (no
charge) or 3 (vendor determined).
Y = Yes
N = No
BUYER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BUYSET1 PROCURE-GROUP AP06.1 AP205
BUYER-CODE AP510 DR100
IC12.1 IC130
IC141 IC142
IC226 IC243
IC330 IC530
IC590 IC83.1
MA278 MA53.1
PO00.1 PO04.1
PO04.2 PO04.3
PO04.4 PO10.1
PO120 PO130
PO133 PO135
PO136 PO15.1
PO15.2 PO190
...
BUYSET2 PROCURE-GROUP KeyChange MA278 PO04.1
BUYER-GRP PO120 PO15.1
BUYER-CODE PO15.2 PO204
PO220 PO223
PO224 PO225
PO230 PO251
PO275 PO276
PO277 PO280
POAB.1
BUYSET3 PROCURE-GROUP KeyChange, Subset PO04.1 POIJ.1
OPERATOR-ID Where OPERATOR-ID != Spaces
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
|