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 |