Field
Name: |
Type: |
Length: |
Index: |
Description: |
| PROPS_SEQ |
Sequence |
|
|
Internal ID |
| PROPS_CLIENT_NUM |
char |
10 |
|
client number |
| PROPS_DATE_ADDED |
Short date |
1980..2079 |
|
date request was added |
| PROPS_REQUESTOR |
char |
100 |
|
name of client contact requesting the job |
| PROPS_TYPE |
char |
15 |
|
job type/spec sheet |
| PROPS_BUDGET |
Number |
2 dp |
|
initial budget |
| PROPS_START_DATE |
Short date |
1980..2079 |
|
requested start date (becomes J_START_DATE) |
| PROPS_DUE_DATE |
Short date |
1980..2079 |
|
request due date (becomes J_DUE_DATE) |
| PROPS_OK_BY |
char |
10 |
|
initial of person ok'ing this job request |
| PROPS_CB1 |
char |
2000 |
|
creative brief 1 |
| PROPS_CB2 |
char |
2000 |
|
creative brief 2 |
| PROPS_CB3 |
char |
2000 |
|
creative brief 3 |
| PROPS_CB4 |
char |
2000 |
|
creative brief 4 |
| PROPS_CB5 |
char |
2000 |
|
creative brief 5 |
| PROPS_CB6 |
char |
2000 |
|
creative brief 6 |
| PROPS_CB7 |
char |
2000 |
|
creative brief 7 |
| PROPS_CB8 |
char |
2000 |
|
creative brief 8 |
| PROPS_CB9 |
char |
2000 |
|
creative brief 9 |
| PROPS_CB10 |
char |
2000 |
|
creative brief 10 |
| PROPS_CB11 |
char |
2000 |
|
creative brief 11 |
| PROPS_CB12 |
char |
2000 |
|
creative brief 12 |
| PROPS_CB13 |
char |
2000 |
|
creative brief 13 |
| PROPS_CB14 |
char |
2000 |
|
creative brief 14 |
| PROPS_CB15 |
char |
2000 |
|
creative brief 15 |
| PROPS_NAME |
char |
60 |
|
job request name/desc (will become J_NAME) |
| PROPS_OK_DATE |
Short date |
1980..2079 |
|
date this request was ok'd |
| PROPS_DESC |
char |
2000 |
|
job description (becomes J_DESC) |
| PROPS_CHARGE_NUM |
char |
20 |
|
charge number/cost center (becomes J_CHARGE_NUM) |
| PROPS_STATUS_DESC |
char |
40 |
|
descriptive status of job request (unapproved/pending/ killed/etc) |
| PROPS_STATUS |
short int |
(0 to 255) |
|
/0=Approved/1=Killed /2=Pending/ |
| PROPS_ADDED_BY |
char |
10 |
|
added by initials |
