Contract information files are created in CSV format in which items are separated by a comma. In addition, since the first line is used as item name, please output actual data from the second line.
Items and file examples recorded in files are shown as below.
Item
No. | Item name | Mandatory/Optional | Specified character | Remarks |
|---|---|---|---|---|
1 | Contract No. | Mandatory | Up to 20 characters can be set including DBC case alphanumeric characters and DBC case symbol (“-”). | Contract number when signing |
2 | Contract Class | Mandatory | Set any of the following items according to contract.
| Classified information of cantract |
3 | Cost Burden Origin | Optional | Up to 36 characters can be set including DBC case alphanumeric characters, DBC case symbols and SBC case multi-byte characters. In case of omission, system administrator sets “Management Target”, section administrator takes the section to which it belongs as omission value for setting. | Section code of contract section. Error will occur when setting value that is not registered to Systemwalker Desktop Patrol. |
4 | Contracted Company | Optional | Up to 60 characters can be set including DBC case alphanumeric characters, DBC case symbols and SBC case multi-byte characters. | Name of contract company. |
5 | Contract Name | Optional | Up to 128 characters can be set including DBC case alphanumeric characters, DBC case symbols and SBC case multi-byte characters. | Name of contract items. |
6 | Contract Date | Mandatory | Set date in following format. mm/dd/yyyy | Date of signing contract |
7 | Contract Start Date | Mandatory | Set date in following format. mm/dd/yyyy | Date of contract start |
8 | Contract End Date | Optional | Set date in following format. mm/dd/yyyy | Date of contract end |
9 | Contract Value | Optional | Set number that is up to 9 digits in DBC case. | Value of signing contract |
10 | Remarks | Optional | Up to 60 characters can be set including DBC case alphanumeric characters, DBC case symbols and SBC case multi-byte characters. | Remark information related to contract |
11 | Administrator Memo 1~6 | Optional | Up to 128 characters can be set including DBC case alphanumeric characters, DBC case symbols and SBC case multi-byte characters. | Remark information related to contract |
12 | Original Contract NO. | Optional | Up to 20 characters can be set including DBC case alphanumeric characters and DBC case symbol (“-”). | Number of original contract for extending contract |
13 | Installation Code | Optional | Up to 20 characters can be set including DBC case alphanumeric characters, DBC case symbols and SBC case multi-byte characters. | Number of contract that is managed by contract company |
14 | Paymennt Type Name | Optional | Up to 10 characters can be set including DBC case alphanumeric characters, DBC case symbols and SBC case double-byte characters. | Monthly payment, yearly payment and other payment |
15 | Officer Name | Optional | Up to 128 characters can be set including DBC case alphanumeric characters, DBC case symbols and SBC case multi-byte characters. | Name of contract principal |
16 | Phone No. of Officer | Optional | Up to 20 characters can be set including DBC case alphanumeric characters, DBC case symbols and SBC case multi-byte characters. | Phone number of contract principal. |
17 | Fax No. of Officer | Optional | Up to 20 characters can be set including DBC case alphanumeric characters, DBC case symbols and SBC case multi-byte characters. | Fax number of contract principal |
Example
Contract No.,Contract Class,Cost Burden Origin Section Code,Contract Company,Contract Name,Contract Date,Contract Start Date,Contract End Date,Contract Value,Remarks,Administrator Memo1,Administrator Memo2,Administrator Memo3,Administrator Memo4,Administrator Memo5,Administrator Memo6,Original Contract No.,Installation Code,Payment Type Name,Officer Name,Phone No. of Officer,FAX No. of Officer Lease0001,lease,, lease company, entire PC ,06/05/2006,06/05/2006,12/05/2008,,,,,,,,,,,,,, Lease0002,lease,,lease company, complete set of Fujitsu printer,09/06/2003,09/06/2003,09/05/2008,,printer for business,,,,,,,,,,,, Rental001,lease,,company lease, complete set of projector for seminar,07/05/2006,07/10/2006,09/09/2008,450000,,,,,,,,,,,,, |
