|
|
BUYER FILE
PO Buyer Master
A file of valid buyers. Contains default and control information.
REFERENCED BY
BL92.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC12.1 IC141 IC142 IC226 IC243 IC530
IC590 IC83.1 IN20.1 MA00.1 MA140 MA190
MA204 MA278 MA300 MA52.1 MA520 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
OE113 OE114 OE129 OE14.4 OE15.1 OE15.2
OE15.3 OE15.4 OE15.5 OE15.7 OE30.1 OE30.2
OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9
OE510 OE810 OE830 OE920 OE950 PO10.1
PO100 PO120 PO121 PO122 PO123 PO130
PO131 PO133 PO135 PO180 PO20.1 PO21.1
PO21.2 PO21.4 PO21.5 PO21.6 PO22.1 PO22.2
PO22.3 PO220 PO223 PO224 PO225 PO230
PO25.1 PO25.2 PO25.3 PO25.4 PO251 PO26.1
PO272 PO275 PO276 PO277 PO28.3 PO28.4
PO28.5 PO28.7 PO28.8 PO280 PO30.1 PO31.1
PO50.1 PO52.1 PO590 PO60.1 PO61.1 PO62.1
PO820 RQ01.1 RQ10.1 RQ10.3 RQ11.1 RQ20.1
RQ20.3 RQ20.4 RQ35.1 RQ44.1 RQ500 RQ810
WH130 WH132 WH190 WH20.2 WH20.7 WH222
WH30.1 WH30.2 WH30.3 WH31.1 WH31.2 WH31.3
WH32.1 WH32.2 WH32.3 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830 WO132 WO140 POA2.1
UPDATED BY
MA04.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BUY-COMPANY Numeric 4 MA04.1
Company The company number.
BUY-BUYER-CODE Alpha 3 MA04.1
Buyer Code The user-defined buyer identifier.
BUY-BUYER-GRP Alpha 5 MA04.1
Buyer Group The buyer's buyer group code.
BUY-NAME Alpha 30 (Lower Case) IC590 MA04.1
Name The buyer's name. RQ01.1 RQ20.1
RQ810
BUY-ADDR1 Alpha 30 (Lower Case) MA04.1
Address 1 The buyer's first line of address
information.
BUY-ADDR2 Alpha 30 (Lower Case) MA04.1
Address 2 The buyer's second line of address
information.
BUY-ADDR3 Alpha 30 (Lower Case) MA04.1
Address 3 The buyer's third line of address
information.
BUY-ADDR4 Alpha 30 (Lower Case) IC590 MA04.1
Address 4 The buyer's fourth line of address
information.
BUY-CITY-ADDR5 Alpha 18 (Lower Case) MA04.1
City or Address 5 This is the buyer's city or the fifth
line of address information.
BUY-STATE-PROV Alpha 2 MA04.1
State or Province This is the buyer's state or province.
BUY-POSTAL-CODE Alpha 10 (Lower Case) MA04.1
Postal Code This is the buyer's mail code.
BUY-COUNTRY Alpha 30 (Lower Case) MA04.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 MA04.1
Telephone Country The buyer's telephone prefix.
Code
BUY-PHONE Alpha 15 MA04.1
Telephone Number The buyer's telephone number.
BUY-PHONE-EXT Alpha 5 MA04.1
Telephone Extension The buyer's telephone extension number.
BUY-PO-LIMIT Signed 15.2 MA04.1
Limit Per PO The buyer's per purchase order amount
limit.
BUY-LOCATION Alpha 5 MA04.1
Ship To The buyer's default receiving location.
Used for purchase order entry.
BUY-LIMIT-CL-FLAG Alpha 1 MA04.1
Purchasing Authority The buyer's purchase class limit flag:
No, the buyer has no purchase class
limitations.
Yes, the buyer has purchase class
limitations.
N = No
Y = Yes
BUY-BEG-MANUAL-PO Numeric 7 MA04.1
Manual PO Range The beginning purchase order number of
Beginning Nbr the buyer's manual purchase order number
range.
BUY-END-MANUAL-PO Numeric 7 MA04.1
Manual PO Range The ending purchase order number of the
Ending Number buyer's manual purchase order number
range.
BUY-COUNTRY-CODE Alpha 2 MA04.1
Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
BUY-REGION Alpha 2 MA04.1
Region Code The region code, if applicable for the
country. Used only by Intrastat. Must be
defined in IN02.1 (Region Maintenance).
BUYER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BUYSET1 COMPANY BL92.1 CX100
BUYER-CODE CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC141
IC142 IC226
IC243 IC530
IC590 IC83.1
IN20.1 MA00.1
MA04.1 MA04.2
MA140 MA190
MA204 MA278
MA300 MA52.1
...
BUYSET2 COMPANY KeyChange MA278 PO120
BUYER-GRP PO121 PO123
BUYER-CODE PO220 PO223
PO224 PO225
PO230 PO251
PO275 PO276
PO277 PO280
POA2.1
BUYER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Buyergrp BUYERGRP Required
When BUY-BUYER-GRP != Spaces
BUY-COMPANY -> BGP-COMPANY
BUY-BUYER-GRP -> BGP-BUYER-GRP
Iclocation ICLOCATION Required
BUY-COMPANY -> ICL-COMPANY
BUY-LOCATION -> ICL-LOCATION
Pocompany POCOMPANY Required
BUY-COMPANY -> PCY-COMPANY
BUYER FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Buyclass BUYCLASS Delete Restricted
BUY-COMPANY -> BCL-COMPANY
BUY-BUYER-CODE -> BCL-BUYER-CODE
BCL-PURCH-MAJCL
BCL-PURCH-MINCL
|