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, output actual data from the second line.
Items and file examples recorded in files are shown as below.
Item
No. | Item name | Mandatory/Optional | Input length | Characters that can be specified | Remarks |
|---|---|---|---|---|---|
1 | Contract No. | Mandatory | 1 to 20 characters | Halfwidth alphanumeric characters and halfwidth symbol (-) | Contract number when signing |
2 | Contract Class | Mandatory | 2 to 4 characters | One of the following is set according to the contract:
| Classified information of contract |
3 | Cost Burden Origin | Optional | Up to 18 fullwidth characters or 36 halfwidth characters | Halfwidth alphanumeric characters Halfwidth spaces Fullwidth characters The following halfwidth symbols: ! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { | } ~ | 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 30 fullwidth characters or 60 halfwidth characters | Halfwidth alphanumeric characters Halfwidth spaces Fullwidth characters The following halfwidth symbols: ! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { | } ~ | Name of contract company. |
5 | Contract Name | Optional | Up to 64 fullwidth characters or 128 halfwidth characters | Halfwidth alphanumeric characters Halfwidth spaces Fullwidth characters The following halfwidth symbols: ! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { | } ~ | Name of contract items. |
6 | Contract Date | Mandatory | 10 characters | The date is set using the following format: yyyy/mm/dd | Date of signing contract |
7 | Contract Start Date | Mandatory | 10 characters | The date is set using the following format: yyyy/mm/dd | Date of contract start |
8 | Contract End Date | Optional | 10 characters | The date is set using the following format: yyyy/mm/dd | Date of contract end |
9 | Contract Value | Optional | 9 characters | Up to 9 halfwidth numbers | Value of signing contract |
10 | Remarks | Optional | Up to 30 fullwidth characters or 60 halfwidth characters | Halfwidth alphanumeric characters Halfwidth spaces Fullwidth characters The following halfwidth symbols: ! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { | } ~ | Remark information related to contract |
11 | Administrator Memo 1~6 | Optional | Up to 64 fullwidth characters or 128 halfwidth characters | Halfwidth alphanumeric characters Halfwidth spaces Fullwidth characters The following halfwidth symbols: ! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { | } ~ | Remark information related to contract |
12 | Original Contract NO. | Optional | Up to 20 characters | Halfwidth alphanumeric characters and halfwidth symbol (-) | Number of original contract for extending contract |
13 | Installation Code | Optional | Up to 10 fullwidth characters or 20 halfwidth characters | Halfwidth alphanumeric characters | Date of installation code |
14 | Payment Type Name | Optional | Up to 5 fullwidth characters or 10 halfwidth characters | Halfwidth alphanumeric characters Halfwidth spaces Fullwidth characters The following halfwidth symbols: ! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { | } ~ | Monthly payment, yearly payment and other payment |
15 | Officer Name | Optional | Up to 64 fullwidth characters or 128 halfwidth characters | Halfwidth alphanumeric characters Halfwidth spaces Fullwidth characters The following halfwidth symbols: ! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { | } ~ | Name of contract principal |
16 | Phone No. of Officer | Optional | Up to 10 fullwidth characters or 20 halfwidth characters | Halfwidth alphanumeric characters Halfwidth spaces Fullwidth characters The following halfwidth symbols: ! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { | } ~ | Phone number of contract principal. |
17 | Fax No. of Officer | Optional | Up to 10 fullwidth characters or 20 halfwidth characters | Halfwidth alphanumeric characters Halfwidth spaces Fullwidth characters The following halfwidth symbols: ! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { | } ~ | 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/2013,06/05/2013,12/05/2015,,,,,,,,,,,,,, Lease0002,lease,,lease company, complete set of Fujitsu printer,09/06/2010,09/06/2010,09/05/2015,,printer for business,,,,,,,,,,,, Rental001,lease,,company lease, complete set of projector for seminar,07/05/2013,07/10/2013,09/09/2015,450000,,,,,,,,,,,,, |
