Fixed-length Fields in Vendor Records
The following table describes the fixed-length fields found in vendor records. Both the short label and default long label (if one exists) are shown.
Vendor Record Fields | |||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Field Number | Field Label | Description | Code is | Data in Field Entered by | Limits | Examples | |||||||||||||||||
153 | AVG WEEKS
or Average Weeks |
Average delivery time in weeks. | numeric | system | N/A | N/A | |||||||||||||||||
144 | CANCELS
or No. of Cancels |
Total number of orders to this vendor that were cancelled. | numeric | system | N/A | N/A | |||||||||||||||||
138 | CLAIMCYCLE
or Claim Cycle |
Code representing the number of days to wait until system selects order as overdue and ready to be claimed. These codes are defined in Claim Cycle Values table. | lowercase alphabetic | organization | Maximum code length: 1 character |
|
|||||||||||||||||
143 | CLAIMS
or No. of Claims |
Total number of claims sent to this vendor. | numeric | system | N/A | N/A | |||||||||||||||||
148 | CPY RCVD
or Copies Received |
Total number of copies received. | numeric | system | N/A | N/A | |||||||||||||||||
154 | DISCOUNT
or Discount |
Percent discount off list price for all orders to this vendor. | numeric | organization | 0-99 | 10 | |||||||||||||||||
152 | EPRICE CNCL
or Est. Price Canc. |
Total encumbrance for cancelled orders. | numeric | system | N/A | N/A | |||||||||||||||||
151 | EPRICE RCVD
or Est. Price Recv |
Total encumbrance for orders that have been received. | numeric | system | N/A | N/A | |||||||||||||||||
157 | GIR CODE | Used in EDIFACT ordering to determine what information is sent to the vendor in the GIR segment of the electronic order. | numeric | organization | 0-4 |
|
|||||||||||||||||
150 | INV TOT
or Invoice Total |
Total payments (monetary amount) to this vendor. | numeric | system | N/A | N/A | |||||||||||||||||
146 | INVOICES
or No. of Invoices |
Total number of invoices paid to this vendor. | numeric | system | N/A | N/A | |||||||||||||||||
156 | LANGUAGE
or Language |
Language of vendor. | alphabetic | organization | Maximum code: 3 characters | ENG | |||||||||||||||||
147 | ORD CLMD
or Orders Claimed |
Total number of orders with claims against them. | numeric | system | N/A | N/A | |||||||||||||||||
149 | ORD TOT
or Order Total |
Total amount encumbered for all orders. | numeric | system | N/A | N/A | |||||||||||||||||
142 | ORDERS
or No. of Orders |
Total number of orders sent to this vendor. | numeric | system | N/A | N/A | |||||||||||||||||
145 | RECEIPTS
or No. of Receipts |
Total number of orders this vendor filled. | numeric | system | N/A | N/A | |||||||||||||||||
139 | VCODE1
or Vendor Code 1 |
Code can be used to categorize vendors (e.g., foreign/domestic) or identify vendors who receive orders in various electronic formats. | lowercase alphabetic | organization | Maximum code length: 1 character
Maximum number of codes: 32 for each field |
|
|||||||||||||||||
140 | VCODE2
or Vendor Code 2 |
Code can be used to categorize vendors (e.g., foreign/domestic) or identify vendors who receive orders in various electronic formats. | lowercase alphabetic | organization | Maximum code length: 1 character
Maximum number of codes: 32 for each field |
|
|||||||||||||||||
141 | VCODE3
or Vendor Code 3 |
Code can be used to categorize vendors (e.g., foreign/domestic) or identify vendors who receive orders in various electronic formats. | lowercase alphabetic | organization | Maximum code length: 1 character
Maximum number of codes: 32 for each field |
|
|||||||||||||||||
155 | VENDOR MSG
or Vendor Message |
Brief messages associated with the vendor that appear on purchase orders and claims. | alphanumeric | organization | Maximum number of messages: 26 Maximum number of characters: 128 |
Attn: Robert Smith |