Chapter 79: Sending Vendor Information to a Warehouse Management System
Purpose: CWDirect sends vendor information to a warehouse management system, such as PkMS, whenever a vendor is created or maintained in CWDirect.
In this chapter:
• PkMS Vendor Master File (VMVNDRIN)
• PkMS Notes Master File (CCCASEIN)
• PkMS Vendor Master File (IJINPT00)
• PkMS Case Comments File (CCCASE00)
• PkMS Vendor XML Message (VendorMaster_1_0, VendorContact_1_0)
• PkMS Vendor Message: Sample XML
• Generic WMS Vendor XML Message (CWVendor)
• Generic WMS Vendor Message: Sample XML
• Generic WMS Vendor Notes XML Message (CWVendorNotes)
• Generic WMS Vendor Notes Message: Sample XML
• Generic WMS Vendor Contacts XML Message (CWVendorContacts)
• Generic WMS Vendor Contacts Message: Sample XML
Note: This chapter discusses CWDirect functionality only. See the PkMS documentation for more information on the PkMS Warehouse Management System.
To send vendor information to a warehouse management system:
• Enter Y in the Use PkMS Interface Values (F31) system control value.
• Enter a program name in the PkMS Vendor Interface Program (F30) system control value.
• Enter a program name in the PkMS Vendor Contact Program Name (F48) system control value.
• Enter a transport type in the PkMS Transport Type (G80) system control value.
Vendor information is sent to a warehouse management system when:
• You create, change or delete a vendor or vendor contact in Working with Vendors (WVEN).
• You create or change a vendor note in Work with Vendors.
• You create or change a vendor note for a purchase order in Entering Purchase Orders (MPOE).
• PkMS Vendor Master File (VMVNDRIN)
• PkMS Notes Master File (CCCASEIN)
PkMS Vendor Master File (VMVNDRIN)
This table shows the fields CWDirect updates in the PkMS Vendor Master file (VMVNDRIN) when you create, change, or delete a vendor in CWDirect and you are using version 18 of PkMS.
Field Name |
Field Length |
Description |
Vendor number |
10 |
The CWDirect vendor number that you created, changed or deleted. Example: 0000100 |
Vendor name |
35 |
The CWDirect vendor name. Example: Paws and Claws Pet Supplies |
Address-1 |
35 |
Vendor address line 1. Example: 11 Example Street |
Address-2 |
35 |
Vendor address line 2. Example: Route 9 |
Address-3 |
35 |
Vendor address line 3. Example: First floor |
City |
35 |
The city defined for the Vendor address. Example: Medway |
State code |
2 |
The state defined for the vendor address. Example: MA |
Zip |
11 |
The postal code defined for the vendor address. Example: 02053 |
Country |
4 |
The country defined for the vendor address. Example: USA |
Contact name |
30 |
The contact name defined for the vendor. Example: Mandy T Bernard |
Telephone number |
15 |
The telephone number defined for the vendor contact. Example: 508 533 8038 |
DCR |
9 |
The date the vendor was created or maintained in YYYYMMDD format. Example: 20001020 |
TCR |
7 |
The time the vendor was created or maintained in HHMMSS format. Example: 113600 |
User ID |
10 |
The program name defined in the PkMS Vendor Interface Program (F30) system control value. Example: IFR0041 |
PkMS Notes Master File (CCCASEIN)
This table shows the fields in the PkMS Notes Master file (CCCASEIN) CWDirect updates when you create, change, or delete a vendor note in CWDirect and you are using version 18 of PkMS.
Field Name |
Field Length |
Description |
Record type |
2 |
VN indicates this is a vendor message. |
Reference# |
20 |
The CWDirect vendor number from the Vendor Notes file. Example: 0006776 |
Sequence number |
5 |
The CWDirect sequence number from the Vendor Notes file. |
Code type |
3 |
The print flag from the Vendor Notes file. B = Print the message on the purchase order and PO receiving worksheet. P = Print the message on the purchase order. W = Print the message on the PO receiving worksheet. Blank = Do not print the message on the purchase order or receiving worksheet; the message is informational only. |
Specl instr desc |
100 |
The vendor note from the Vendor Notes file. Example: Package carefully |
DCR |
9 |
The date the vendor note was created in YYYYMMDD format. Example: 20001020 |
TCR |
7 |
The time the vendor note was created in HHMMSS format. Example: 111715 |
User ID |
10 |
The program name defined in the PkMS Vendor Interface Program (F30) system control value. Example: IFR0027 |
Transport type: You can enter PKMSLOCAL or FTP in the PkMS Transport Type (G80) system control value to indicate the method CWDirect uses to send vendor information to a warehouse management system. PKMSLOCAL indicates CWDirect sends the vendor files using flat files; FTP indicates CWDirect sends the vendor files using FTP processing.
FTP Processing: You can send vendor information to PkMS using FTP processing if you are using version 19 of PkMs; see Sending and Receiving WMS Information using FTP Processing.
PkMS Vendor Master File (IJINPT00)
This table shows the fields in the PkMS Vendor Master file (IJINPT00) CWDirect updates when you create, change, or delete a vendor or vendor contact in CWDirect and you are using version 19 of PkMS.
Field Name |
Field Length |
Description |
Batch control number |
10 |
The system assigns the next available number defined in the PkMS Vendor Control Number number assignment value. Example: 0000000011 |
Date created |
9 |
The date the vendor in CWDirect was created, changed, or deleted in YYYYMMDD format. Example: 20001020 |
Time created |
7 |
The time the vendor in CWDirect was created, changed, or deleted in HHMMSS format. Example: 104818 |
User ID |
10 |
The program name defined in the PkMS Vendor Interface Program (F30) system control value. Example: IFR0048 |
Vendor number |
10 |
The CWDirect vendor number that you created, changed or deleted. Example: 0000101 |
Vendor name |
35 |
The name of the vendor. Example: US Vendor |
Address-1 |
35 |
Vendor address line 1. Example: 24 Prime Park Way |
Address-2 |
35 |
Vendor address line 2. Example: Cochituate Place |
Address-3 |
35 |
Vendor address line 3. Example: First floor |
City |
35 |
The city defined for the Vendor address. Example: Natick |
State code |
2 |
The state defined for the vendor address. Example: MA |
Zip |
11 |
The postal code defined for the vendor address. Example: 01760 |
Country |
4 |
The country defined for the vendor address. Example: USA |
Contact name |
30 |
The contact name defined for the vendor. Example: Gene Grella |
Telephone number |
15 |
The telephone number defined for the vendor. Example: 508 652-9489 |
PkMS Case Comments File (CCCASE00)
This table shows the fields in the PkMS Case Comments file (CCASE00) CWDirect updates when you create or change a vendor note.
Field Name |
Field Length |
Description |
Record type |
2 |
CWDirect note type: SK = SKU Comments CS = Customer service comments PC = Product comments PD = Purchase order detail comments PH = Purchase order header comments PO = Purchase order item comments QC = Quality control comments RP = Report control comments VN = Vendor comments |
Reference# |
20 |
The first 6 positions of the item number and 14 positions of the SKU. Example: CT5 |
Sequence number |
5 |
Vendor note sequence number. |
DCR |
9 |
The date this record was created in YYYYMMDD format. |
TCR |
7 |
The time this record was created in HHMMSS format. |
Code type |
3 |
CWDirect print flag. This field displays blank if the note is defined at the item level. B = Print on both I = Print on invoices only. N (or blank) = Do not print. P = Print on pick only. R = Print on reports only. W = Print on receiving worksheet |
Spcl instr desc |
100 |
The vendor note. Example: Package carefully. |
User ID |
10 |
The program name defined in the PkMS Vendor Interface Program (F30) system control value. |
PkMS or generic XML messages? The Vendor XML Message Format (H41) system control value defines the XML message format the system generates when it sends vendor information to a warehouse management system:
• PKMS generates the PkMS Vendor XML Message (VendorMaster_1_0, VendorContact_1_0) and PkMS Vendor Contact XML message.
• GENERIC generates the Generic WMS Vendor XML Message (CWVendor), Generic WMS Vendor Notes XML Message (CWVendorNotes), and Generic WMS Vendor Contacts XML Message (CWVendorContacts).
Transport type: You must enter MQ in the PkMS Transport Type (G80) system control value to indicate the XML message is sent to the warehouse management system using MQ Series. The MQ job used to send vendor information to a warehouse management system is VENDOR EXPORT. The MQ job used to send vendor contacts to a warehouse management system is VENDOR CONTACTS EXPORT. See Chapter 92: Working with WMS MQ Job Control (WMJC).
Decimals: Decimal points display for a numeric attribute depending on if the number is a whole number or real number. If the number is a whole number, for example 1, decimals do not display (1 instead of 1.00); if the number is a real number, for example 1.55, decimals display (1.55 instead of 155).
PkMS Vendor XML Message (VendorMaster_1_0, VendorContact_1_0)
This message is transmitted to PkMS when you create, change, or delete a vendor or vendor contact in CWDirect and the Vendor XML Message Format (H41) system control value is set to PKMS.
For more information: See:
• PkMS Vendor Message: Sample XML for a sample message.
• XML Messages for a table that provides links to the DTD, schema, and a sample XML layout for each XML message.
Attribute Name |
Type |
Length |
Req |
Comments |
|
||||
version |
alpha |
30 |
Y |
The hard-coded value 1.0 defaults. |
timestamp |
alpha |
19 |
Y |
The date and time the XML message was created in YYYY-MM-DDTHH:MM:SS format. |
id |
alpha |
60 |
Y |
PKMS_VendorMaster (or PKMS_VendorContact) + the date and time the message was created + the next number available from the Vendor File Transfer # number assignment value. |
|
||||
VendorNumber |
alpha |
10 |
Y |
The CWDirect vendor number that you created, changed, or deleted. |
VendorName |
alpha |
35 |
N |
The name of the vendor. |
BatchCtrlNbr |
alpha |
10 |
N |
Vendor The next number available from the PkMS Vendor Control Number number assignment value. Vendor contact The next number available from the Vendor File Transfer # number assignment value. |
|
||||
DateCreated |
numeric |
9.0 |
N |
The date and time the vendor in CWDirect was created, changed, or deleted in YYYY-MM-DDTHH:MM:SS format. |
Address1 |
alpha |
35 |
N |
Vendor address line 1. |
Address2 |
alpha |
35 |
N |
Vendor address line 2. |
Address3 |
alpha |
35 |
N |
Vendor address line 3. |
City |
alpha |
35 |
N |
The city defined for the vendor address. |
StateCode |
alpha |
20 |
N |
The state defined for the vendor address. |
Zip |
alpha |
11 |
N |
The postal code defined for the vendor address. |
Country |
alpha |
4 |
N |
The country defined for the vendor address. |
ContactName |
alpha |
30 |
N |
The contact name defined for the vendor. |
TelephoneNumber |
alpha |
30 |
N |
The telephone number defined for the vendor. |
CustRecExpField |
alpha |
30 |
N |
The value defined in the PkMS Company Designator (G61) system control value. |
Function |
alpha |
2 |
N |
Valid values: 1 = Add 2 = Change 4 = Delete |
PkMS Vendor Message: Sample XML
A sample of the PkMS Vendor XML Message (VendorMaster_1_0, VendorContact_1_0) is presented below.
- <VendorMaster_1_0 version="1.0" timestamp="2004-08-13T11:00:09" id="PKMS_VendorMaster_2004-08-13T11:00:09.000000032">
- <VendorMaster>
<VendorNumber>9782723</VendorNumber>
<VendorName>BOTTGER COLLABORATE INDUSTRIES</VendorName>
<BatchCtrlNbr>100</BatchCtrlNbr>
- <VendorMasterFields>
<DateCreated>2004-08-13T11:00:09</DateCreated>
<Address1>109 PATRIOTS ROAD</Address1>
<Address2>BUILDING 3</Address2>
<City>TEMPLETON</City>
<StateCode>MA</StateCode>
<Zip>01468</Zip>
<Country>USA</Country>
<ContactName>DARCY BOTTGER</ContactName>
<TelephoneNumber>978 632-2723</TelephoneNumber>
<CustRecExpField>555</CustRecExpField>
<Function>2</Function>
</VendorMasterFields>
</VendorMaster>
</VendorMaster_1_0>
Generic WMS Vendor XML Message (CWVendor)
This message is transmitted to a warehouse management system when you create, change, or delete a vendor in CWDirect and the Vendor XML Message Format (H41) system control value is set to GENERIC.
For more information: See:
• Generic WMS Vendor Message: Sample XML for a sample message.
• XML Messages for a table that provides links to the DTD, schema, and a sample XML layout for each XML message.
Attribute Name |
Type |
Length |
Comments |
|
|||
source |
alpha |
25 |
Identifies the source of the XML message. CWI indicates the XML message is from MICROS. |
target |
alpha |
25 |
Identifies the target for the XML message. WMS indicates the XML message is sent to a warehouse management system. |
type |
alpha |
25 |
Identifies the type of information in the XML message. CWVendor indicates the message contains vendor updates. |
|
|||
type |
alpha |
4 |
Identifies the interface type for the XML message. WMS indicates the XML message is for a warehouse management system. |
message_type |
alpha |
2 |
Identifies the type of information in the XML message. VE indicates the message contains vendor updates. |
company |
numeric |
3.0 |
Value defined in the Company field (BSCOMP) in the CWDirect Vendor file. |
file_trans_nbr |
numeric |
9.0 |
The next number available from the Vendor File Transfer # number assignment value. |
vendor |
numeric |
7.0 |
Value defined in the Vendor field (BSFYNB) in the CWDirect Vendor file. |
address_line1 |
alpha |
32 |
Value defined in the Address line 1 field (BSCRTX) in the CWDirect Vendor file. |
address_line2 |
alpha |
32 |
Value defined in the Address line 2 field (BSCSTX) in the CWDirect Vendor file. |
city |
alpha |
25 |
Value defined in the City field (BSCTTX) in the CWDirect Vendor file. |
drop_ship |
alpha |
1 |
Value defined in the Drop ship field (BSDMST) in the CWDirect Vendor file. |
edi_file |
alpha |
10 |
Value defined in the EDI file field (BSAMVN) in the CWDirect Vendor file. |
fax_number |
numeric |
11.0 |
Value defined in the Fax field (BSFZNB) in the CWDirect Vendor file. |
name |
alpha |
30 |
Value defined in the Name field (BSCUTX) in the CWDirect Vendor file. |
print_po |
alpha |
1 |
Value defined in the Print PO field (BSDNST) in the CWDirect Vendor file. |
rating |
numeric |
5.2 |
Value defined in the Rating field (BSAOPC) in the CWDirect Vendor file. |
remit_address1 |
alpha |
32 |
Value defined in the Remit address 1 field (BSCVTX) in the CWDirect Vendor file. |
remit_address2 |
alpha |
32 |
Value defined in the Remit address 2 field (BSCWTX) in the CWDirect Vendor file. |
remit_city |
alpha |
25 |
Value defined in the Remit city field (BSCXTX) in the CWDirect Vendor file. |
remit_name |
alpha |
30 |
Value defined in the Remit name field (BSCYTX) in the CWDirect Vendor file. |
remit_zip |
alpha |
10 |
Value defined in the Remit zip field (BSIHCD) in the CWDirect Vendor file. |
zip |
alpha |
10 |
Value defined in the Zip field (BSIJCD) in the CWDirect Vendor file. |
telephone_nbr |
numeric |
11.0 |
Value defined in the Telephone# field (BSHONB) in the CWDirect Vendor file. |
extension |
alpha |
4 |
Value defined in the Ext field (BSDOTX) in the CWDirect Vendor file. |
address_line3 |
alpha |
32 |
Value defined in the Address line 3 field (BSDPTX) in the CWDirect Vendor file. |
remit_address3 |
alpha |
32 |
Value defined in the Remit address 3 field (BSDQTX) in the CWDirect Vendor file. |
print_checks |
alpha |
1 |
Value defined in the Print checks field (BSEEST) in the CWDirect Vendor file. |
factor |
alpha |
1 |
Value defined in the Factor field (BSEFST) in the CWDirect Vendor file. |
contact_name |
alpha |
30 |
Value defined in the Contact name field (BSP5TX) in the CWDirect Vendor file. |
user_field1 |
alpha |
10 |
Value defined in the User field 1 field (BSRXTX) in the CWDirect Vendor file. |
user_field2 |
alpha |
10 |
Value defined in the User field 2 field (BSRYTX) in the CWDirect Vendor file. |
user_field3 |
alpha |
10 |
Value defined in the User field 3 field (BSRZTX) in the CWDirect Vendor file. |
surcharge_pct |
numeric |
5.2 |
Value defined in the Surcharge % field (BSFHPC) in the CWDirect Vendor file. |
discount_pct |
numeric |
5.2 |
Value defined in the Disc % field (BSFKPC) in the CWDirect Vendor file. |
vendor_fax_flag |
alpha |
1 |
Value defined in the Fax field (BSYWST) in the CWDirect Vendor file. |
vendor_edi_flag |
alpha |
1 |
Value defined in the EDI field (BSYXST) in the CWDirect Vendor file. |
dollars_cancelled |
numeric |
11.2 |
Value defined in the $ cancelled field (BSK2VA) in the CWDirect Vendor file. |
dollars_held |
numeric |
11.2 |
Value defined in the $ held field (BSK3VA) in the CWDirect Vendor file. |
dollars_open |
numeric |
11.2 |
Value defined in the $ open field (BSK4VA) in the CWDirect Vendor file. |
dollars_pos_ltd |
numeric |
11.2 |
Value defined in the $ POs LTD field (BSLIVA) in the CWDirect Vendor file. |
nbr_open_pos |
numeric |
7.0 |
Value defined in the # open POs field (BSXNQT) in the CWDirect Vendor file. |
nbr_pos_ltd |
numeric |
7.0 |
Value defined in the # POs LTD field (BSYOQT) in the CWDirect Vendor file. |
interface_vend_code |
alpha |
10 |
Value defined in the Interface vendor code field (BSY7TX) in the CWDirect Vendor file. |
price_currency_type |
alpha |
1 |
Value defined in the Price currency type field (BSPSSS) in the CWDirect Vendor file. |
vat_number |
alpha |
20 |
Value defined in the Vat number field (BSM5TV) in the CWDirect Vendor file. |
telephone |
alpha |
14 |
Value defined in the Telephone number field (BSF2CG) in the CWDirect Vendor file. |
fax |
alpha |
14 |
Value defined in the Fax number field (BSF3CG) in the CWDirect Vendor file. |
vendor_type |
alpha |
1 |
Value defined in the Type field (BSK3SW) in the CWDirect Vendor file. |
eft_acct |
alpha |
20 |
Value defined in the EFT account # field (BSNATV) in the CWDirect Vendor file. |
address_line4 |
alpha |
32 |
Value defined in the Address line 4 field (BSTVGM) in the CWDirect Vendor file. |
remit_address4 |
alpha |
32 |
Value defined in the Remit address line 4 field (BSTWGM) in the CWDirect Vendor file. |
alpha |
50 |
Value defined in the Email address field (BSTXGM) in the CWDirect Vendor file. |
|
remit_email |
alpha |
50 |
Value defined in the Remit email address field (BSTYGM) in the CWDirect Vendor file. |
apt_code |
numeric |
2.0 |
Value defined in the Code field (BSHPNB) in the CWDirect Vendor file. |
country |
alpha |
3 |
Value defined in the Country field (BSCNCD) in the CWDirect Vendor file. |
state |
alpha |
2 |
Value defined in the State field (BSIICD) in the CWDirect Vendor file. |
remit_country |
alpha |
3 |
Value defined in the Remit to country field (BSKYCD) in the CWDirect Vendor file. |
remit_state |
alpha |
2 |
Value defined in the Remit state field (BSIGCD) in the CWDirect Vendor file. |
currency_code |
alpha |
3 |
Value defined in the Currency code field (BSO4CD) in the CWDirect Vendor file. |
ship_via_code |
numeric |
2.0 |
Value defined in the Ship via code field (BSY8NR) in the CWDirect Vendor file. |
priority |
numeric |
1.0 |
Value defined in the Priority field (NSM3QY) in the CWDirect Vendor Extended file. |
aging_bucket1 |
numeric |
11.2 |
Value defined in the Aging bucket 1 field (NSYCVA) in the CWDirect Vendor Extended file. |
aging_bucket2 |
numeric |
11.2 |
Value defined in the Aging bucket 2 field (NSYDVA) in the CWDirect Vendor Extended file. |
aging_bucket3 |
numeric |
11.2 |
Value defined in the Aging bucket 3 field (NSYEVA) in the CWDirect Vendor Extended file. |
aging_bucket4 |
numeric |
11.2 |
Value defined in the Aging bucket 4 field (NSYFVA) in the CWDirect Vendor Extended file. |
aging_bucket5 |
numeric |
11.2 |
Value defined in the Aging bucket 5 field (NSYGVA) in the CWDirect Vendor Extended file. |
aging_bucket6 |
numeric |
11.2 |
Value defined in the Aging bucket 6 field (NSYHVA) in the CWDirect Vendor Extended file. |
disburse_week1 |
numeric |
11.2 |
Value defined in the Week 1 disbursement field (NSYIVA) in the CWDirect Vendor Extended file. |
disburse_week2 |
numeric |
11.2 |
Value defined in the Week 2 disbursement field (NSYJVA) in the CWDirect Vendor Extended file. |
disburse_week3 |
numeric |
11.2 |
Value defined in the Week 3 disbursement field (NSYKVA) in the CWDirect Vendor Extended file. |
disburse_week4 |
numeric |
11.2 |
Value defined in the Week 4 disbursement field (NSYLVA) in the CWDirect Vendor Extended file. |
open_ap |
numeric |
13.2 |
Value defined in the Open AP field (NSYMVA) in the CWDirect Vendor Extended file. |
on_order |
numeric |
13.2 |
Value defined in the $ on order field (NSYNVA) in the CWDirect Vendor Extended file. |
disburse_wk1 |
alpha |
1 |
Value defined in the Disburse week 1 field (NSXWSS) in the CWDirect Vendor Extended file. |
disburse_wk2 |
alpha |
1 |
Value defined in the Disburse week 2 field (NSXXSS) in the CWDirect Vendor Extended file. |
disburse_wk3 |
alpha |
1 |
Value defined in the Disburse week 3 field (NSXYSS) in the CWDirect Vendor Extended file. |
disburse_wk4 |
alpha |
1 |
Value defined in the Disburse week 4 field (NSXZSS) in the CWDirect Vendor Extended file. |
hold_checks |
alpha |
1 |
Value defined in the Hold checks field (NSFZSV) in the CWDirect Vendor Extended file. |
disc_calc_method |
alpha |
1 |
Value defined in the Discount calc method field (NSBYCF) in the CWDirect Vendor Extended file. |
unit_disc_amt1 |
numeric |
9.4 |
Value defined in the Unit discount amt 1 field (NSD8NQ) in the CWDirect Vendor Extended file. |
unit_disc_amt2 |
numeric |
9.4 |
Value defined in the Unit discount amt 2 field (NSD9NQ) in the CWDirect Vendor Extended file. |
unit_disc_amt3 |
numeric |
9.4 |
Value defined in the Unit discount amt 3 field (NSEANQ) in the CWDirect Vendor Extended file. |
unit_disc_pct1 |
numeric |
5.2 |
Value defined in the Unit discount pct 1 field (NSM1PC) in the CWDirect Vendor Extended file. |
unit_disc_pct2 |
numeric |
5.2 |
Value defined in the Unit discount pct 2 field (NSM2PC) in the CWDirect Vendor Extended file. |
unit_disc_pct3 |
numeric |
5.2 |
Value defined in the Unit discount pct 3 field (NSM3PC) in the CWDirect Vendor Extended file. |
parent_vendor |
numeric |
7.0 |
Value defined in the Parent vendor number field (NSE0NR) in the CWDirect Vendor Extended file. |
ds_batch_size |
numeric |
7.0 |
Value defined in the Drop ship batch size field (NSMQNR) in the CWDirect Vendor Extended file. |
nbr_avail_picks |
numeric |
9.0 |
Value defined in the # of available picks field (NSMRNR) in the CWDirect Vendor Extended file. |
nbr_picks_release |
numeric |
9.0 |
Value defined in the # of picks to release field (NSMSNR) in the CWDirect Vendor Extended file. |
last_update_date |
numeric |
7.0 |
Value defined in the Last updated date field (NSHHDY) in the CWDirect Vendor Extended file. |
ds_batch_work |
numeric |
7.0 |
Value defined in the Drop ship batch work field (NSNBNR) in the CWDirect Vendor Extended file. |
future_use_sts1 |
alpha |
1 |
Value defined in the Future use sts 1 field (NSY8SY) in the CWDirect Vendor Extended file. |
future_use_sts2 |
alpha |
1 |
Value defined in the Future use sts 2 field (NSY9SY) in the CWDirect Vendor Extended file. |
future_use_cde1 |
alpha |
10 |
Value defined in the Future use code 1 field (NSJNCF) in the CWDirect Vendor Extended file. |
future_use_cde2 |
alpha |
10 |
Value defined in the Future use code 2 field (NSJOCF) in the CWDirect Vendor Extended file. |
future_use_val1 |
numeric |
11.2 |
Value defined in the Future use value 1 field (NSBEVE) in the CWDirect Vendor Extended file. |
future_use_val2 |
numeric |
11.2 |
Value defined in the Future use value 2 field (NSBFVE) in the CWDirect Vendor Extended file. |
future_use_qty1 |
numeric |
9.0 |
Value defined in the Future use qty 1 field (NSE2QZ) in the CWDirect Vendor Extended file. |
future_use_qty2 |
numeric |
9.0 |
Value defined in the Future use qty 2 field (NSE4QZ) in the CWDirect Vendor Extended file. |
activity_code |
alpha |
1 |
A = add C = change D = delete |
wms_control |
numeric |
9.0 |
The next number available from the PkMS Vendor Control Number number assignment value. |
company_designator |
alpha |
10 |
The value defined in the PkMS Company Designator (G61) system control value. |
program_id |
alpha |
10 |
The name of the program that created this XML message. |
date_created |
numeric |
8.0 |
YYYYMMDD format |
time_created |
numeric |
7.0 |
HHMMSS format |
Generic WMS Vendor Message: Sample XML
A sample of the Generic WMS Vendor XML Message (CWVendor) is presented below.
- <Message source="CWI" target="WMS" type="CWVendor">
- <Vendors>
<Vendor type="WMS" message_type="VE" company="555" file_trans_nbr="000000033" vendor="9782723" address_line1="109 PATRIOTS ROAD" address_line2="BUILDING 3" city="TEMPLETON" drop_ship="O" edi_file="NN" name="BOTTGER COLLABORATE INDUSTRIES" print_po="Y" remit_address1="109 PATRIOTS ROAD" remit_address2="BUILDING 3" remit_city="TEMPLETON" remit_name="Darcy Bottger" remit_zip="01468" zip="01468" remit_address3="address line 3" print_checks="Y" factor="Y" contact_name="DARCY BOTTGER" vendor_fax_flag="N" vendor_edi_flag="N" dollars_cancelled="425" dollars_open="14381.50" dollars_pos_ltd="70159" nbr_open_pos="201" nbr_pos_ltd="264" price_currency_type="S" telephone="978 632-2723" fax="978 652-9489" vendor_type="V" remit_address4="address line 4" remit_email="karenbottger@yahoo.com" apt_code="30" country="USA" state="MA" remit_country="USA" remit_state="MA" currency_code="USD" ship_via_code="1" disburse_wk1="N" disburse_wk2="N" disburse_wk3="N" disburse_wk4="N" hold_checks="N" parent_vendor="9782723" ds_batch_size="10" future_use_sts1="N" activity_code="C" wms_control="101" company_designator="555" program_id="IFR0069" date_created="20040813" time_created="0111228" />
</Vendors>
</Message>
Generic WMS Vendor Notes XML Message (CWVendorNotes)
This message is transmitted to a warehouse management system when you create, change, or delete a vendor note in CWDirect and the Vendor XML Message Format (H41) system control value is set to GENERIC.
For more information: See:
• Generic WMS Vendor Notes Message: Sample XML for a sample message.
• XML Messages for a table that provides links to the DTD, schema, and a sample XML layout for each XML message.
Attribute Name |
Type |
Length |
Comments |
|
|||
source |
alpha |
25 |
Identifies the source of the XML message. CWI indicates the XML message is from MICROS. |
target |
alpha |
25 |
Identifies the target of the XML message. WMS indicates the XML message is sent to a warehouse management system. |
type |
alpha |
25 |
Identifies the type of information in the XML message. CWVendorNotes indicates the message contains vendor contacts. |
|
|||
type |
alpha |
4 |
Identifies the interface type for the XML message. WMS indicates the XML message is for a warehouse management system. |
message_type |
alpha |
2 |
Identifies the type of information in the XML message. VN indicates the message contains vendor contacts. |
company |
numeric |
3.0 |
Value defined in the Company field (CXCOMP) in the CWDirect Vendor Notes file. |
file_trans_nbr |
numeric |
9.0 |
The next number available from the Vendor File Transfer # number assignment value. |
vendor |
numeric |
7.0 |
Value defined in the Vendor # field (CXFYNB) in the CWDirect Vendor Notes file. |
|
|||
seq |
numeric |
3.0 |
Value defined in the Seq # field (CXHVNB) in the CWDirect Vendor Notes file. |
note |
alpha |
60 |
Value from the Note field (CXE1TX) in the CWDirect Vendor Notes file. |
alpha |
1 |
Value from the Print field (CXEZST) in the CWDirect Vendor Notes file. |
|
entry_date |
numeric |
7.0 |
Value from the Entry date field (CXJSDT) in the CWDirect Vendor Notes file. |
user |
alpha |
10 |
Value from the User field (CXBXVN) in the CWDirect Vendor Notes file. |
wms_control |
numeric |
9.0 |
Next number available from the PkMS Vendor Control Number number assignment value. |
company_designator |
alpha |
10 |
Value defined in the PkMS Company Designator (G61) system control value. |
program_id |
alpha |
10 |
The name of the program that created this XML message. |
date_created |
numeric |
8.0 |
The date the XML message was created, in YYYYMMDD format. |
time_created |
numeric |
7.0 |
The time the XML message was created, in HHMMSS format. |
Generic WMS Vendor Notes Message: Sample XML
A sample of the Generic WMS Vendor Notes Message: Sample XML is presented below.
- <Message source="CWI" target="WMS" type="CWVendorNotes">
- <VendorNotes>
- <Note type="WMS" message_type="VN" company="555" file_trans_nbr="000000034" vendor="9782723">
<Notes seq="1" note="Package items carefully." print="B" entry_date="20040813" user="KBOTTGER" wms_control="102" company_designator="555" program_id="IFR0070" date_created="20040813" time_created="0111255" />
</Note>
</VendorNotes>
</Message>
Generic WMS Vendor Contacts XML Message (CWVendorContacts)
This message is transmitted to a warehouse management system when you create, change, or delete a vendor contact in CWDirect and the Vendor Contacts XML Message Format (H42) system control value is set to GENERIC.
For more information: See:
• Generic WMS Vendor Contacts Message: Sample XML for a sample message.
• XML Messages for a table that provides links to the DTD, schema, and a sample XML layout for each XML message.
Attribute Name |
Type |
Length |
Comments |
Message |
|
||
source |
alpha |
25 |
Identifies the source of the XML message. CWI indicates the XML message is from MICROS. |
target |
alpha |
25 |
Identifies the target of the XML message. WMS indicates the XML message is sent to a warehouse management system. |
type |
alpha |
25 |
Identifies the type of information in the XML message. CWVendorContacts indicates the message contains vendor contacts. |
|
|||
type |
alpha |
4 |
Identifies the interface type for the XML message. WMS indicates the XML message is for a warehouse management system. |
message_type |
alpha |
2 |
Identifies the type of information in the XML message. VC indicates the message contains vendor contacts. |
company |
numeric |
3.0 |
Value defined in the Company field (LDCOMP) in the CWDirect Vendor Contact file. |
file_trans_nbr |
numeric |
9.0 |
The next number available from the Vendor File Transfer # number assignment value. |
vendor |
numeric |
7.0 |
Value defined in the Vendor # field (LDFYNB) in the CWDirect Vendor Contact file. |
vendor_name |
alpha |
30 |
Value defined in the Name field (BSCUTX) in the CWDirect Vendor file. |
contact_type |
alpha |
2 |
Value defined in the Contact type field (LDBYSY) in the CWDirect Vendor Contact file. |
seq_nbr |
numeric |
3.0 |
Value defined in the Sequence # field (LDPONQ) in the CWDirect Vendor Contact file. |
name |
alpha |
30 |
Value defined in the Contact name field (LDWXTV) in the CWDirect Vendor Contact file. |
title |
alpha |
30 |
Value defined in the Contact title field (LDWYTV) in the CWDirect Vendor Contact file. |
address_line1 |
alpha |
32 |
Value defined in the Address line 1 field (LDWZTV) in the CWDirect Vendor Contact file. |
address_line2 |
alpha |
32 |
Value defined in the Address line 2 field (LDW0TV) in the CWDirect Vendor Contact file. |
address_line3 |
alpha |
32 |
Value defined in the Address line 3 field (LDW1TV) in the CWDirect Vendor Contact file. |
city |
alpha |
25 |
Value defined in the City field (LDNRTX) in the CWDirect Vendor Contact file. |
zip |
alpha |
10 |
Value defined in the Zip field (LDLWCG) in the CWDirect Vendor Contact file. |
telephone |
alpha |
14 |
Value defined in the Telephone number field (LDLXCG) in the CWDirect Vendor Contact file. |
tel_ext |
alpha |
4 |
Value defined in the Telephone extension field (LDN3TX) in the CWDirect Vendor Contact file. |
fax |
alpha |
14 |
Value defined in the Fax number field (LDLYCG) in the CWDirect Vendor Contact file. |
fax_ext |
alpha |
4 |
Value defined in the Fax extension field (LDN4TX) in the CWDirect Vendor Contact file. |
internet |
alpha |
50 |
Value defined in the Internet address field (LDW2TV) in the CWDirect Vendor Contact file. |
address_type |
alpha |
1 |
Value defined in the Address type field (LDLZCG) in the CWDirect Vendor Contact file. |
sort_seq |
numeric |
3.0 |
Value defined in the Sort sequence field (LDPPNQ) in the CWDirect Vendor Contact file. |
fob_frt_terms |
alpha |
10 |
Value defined in the FOB freight terms field (LDSZCG) in the CWDirect Vendor Contact file. |
fob_type |
alpha |
1 |
Value defined in the FOB type field (LDJ3SY) in the CWDirect Vendor Contact file. |
country |
alpha |
3 |
Value defined in the Country field (LDL0CG) in the CWDirect Vendor Contact file. |
state |
alpha |
2 |
Value defined in the State field (LDL1CG) in the CWDirect Vendor Contact file. |
activity_code |
alpha |
1 |
A = add C = change D = delete |
wms_control |
numeric |
9.0 |
Next number available from the PkMS Vendor Control Number number assignment value. |
company_designator |
alpha |
10 |
Value defined in the PkMS Company Designator (G61) system control value. |
program_id |
alpha |
10 |
The name of the program that created this XML message. |
date_created |
numeric |
8.0 |
The date the XML message was created, in YYYYMMDD format. |
time_created |
numeric |
7.0 |
The time the XML message was created, in HHMMSS format. |
Generic WMS Vendor Contacts Message: Sample XML
A sample of the Generic WMS Vendor Contacts XML Message (CWVendorContacts) is presented below.
- <Message source="CWI" target="WMS" type="CWVendorContacts">
- <VendorContacts>
<Contact type="WMS" message_type="VC" company="555" file_trans_nbr="000000035" vendor="9782723" vendor_name="BOTTGER COLLABORATE INDUSTRIES" contact_type="A" seq_nbr="999" name="BOTTGER INDUSTRIES" address_line1="109 PATRIOTS ROAD" city="TEMPLETON" zip="01468" internet="karenbottger@yahoo.com" address_type="A" sort_seq="3" country="USA" state="MA" activity_code="C" wms_control="103" company_designator="555" program_id="IFR0073" date_created="20040813" time_created="0113523" />
</VendorContacts>
</Message>
