Field
Name: |
Type: |
Length: |
Index: |
Description: |
PO_SEQ |
sequence |
|
x |
sequence number |
PO_NUM |
char |
12 |
x |
PO number |
PO_JOB_NUM |
char |
15 |
x |
job number (for one-line POs) |
PO_TASK |
char |
4 |
x |
job task (for one-line POs) |
PO_DESC_LABEL |
char |
15 |
|
'description' label |
PO_DESC |
char |
2000 |
|
description of what's being purchased |
PO_VENDOR_NUM |
char |
10 |
x |
vendor number |
PO_COST |
number |
2dp |
|
net cost |
PO_MARKUP |
number |
2dp |
|
markup % |
PO_COMM |
number |
2dp |
|
commission amount |
PO_TAX |
number |
2dp |
|
sales tax amount |
PO_GROSS |
number |
2dp |
|
billable amount |
PO_AMT_PAID |
number |
2dp |
|
amount posted from A/P |
PO_TYPE |
number |
0dp |
x |
/0=Purchase Order/1=Insertion Order/2=Work Order/3=Change
Order/4=Broadcast Order |
PO_CLIENT_NUM |
char |
10 |
x |
client number |
PO_SHIP_NOTE |
char |
2000 |
|
shipping note |
PO_SHIP1 |
char |
40 |
|
shipping address 1 |
PO_SHIP2 |
char |
40 |
|
shipping address 2 |
PO_SHIP3 |
char |
40 |
|
shipping address 3 |
PO_SHIP4 |
char |
40 |
|
shipping address 4 |
PO_QTY_LABEL |
char |
15 |
|
'quantity' label |
PO_QTY |
char |
20 |
|
quantity |
PO_APPROVAL1 |
char |
30 |
|
approval 1 |
PO_APPROVAL2 |
char |
30 |
|
approval 2 |
PO_APPROVAL3 |
char |
30 |
|
approval 3 |
PO_ORDERED_BY |
char |
4 |
|
who ordered this? |
PO_STATUS |
char |
40 |
|
status description |
PO_DUE_DATE |
short date |
1980..2079 |
x |
shipment or delivery date (blank=ASAP) |
PO_TERMS1 |
number |
2dp |
|
payment terms (%) |
PO_TERMS2 |
number |
0dp |
|
payment terms (discount days) |
PO_TERMS3 |
number |
0dp |
|
payment terms (net days) |
PO_DATE |
short date |
1980..2079 |
x |
date added |
PO_PC |
short num |
0dp |
|
profit center |
PO_TO1 |
char |
10 |
|
print copy 1 to |
PO_TO2 |
char |
10 |
|
print copy 2 to |
PO_TO3 |
char |
10 |
|
print copy 3 to |
PO_TO4 |
char |
10 |
|
print copy 4 to |
PO_TO5 |
char |
10 |
|
print copy 5 to |
PO_VENDOR1 |
char |
40 |
|
vendor address 1 |
PO_VENDOR2 |
char |
40 |
|
vendor address 2 |
PO_VENDOR3 |
char |
40 |
|
vendor address 3 |
PO_VENDOR4 |
char |
40 |
|
vendor address 4 |
PO_VENDOR5 |
char |
40 |
|
vendor address 5 |
PO_FIELD_LABEL1 |
char |
20 |
|
user-defined label |
PO_FIELD_LABEL2 |
char |
20 |
|
user-defined label |
PO_FIELD_LABEL3 |
char |
20 |
|
user-defined label |
PO_FIELD_LABEL4 |
char |
20 |
|
user-defined label |
PO_FIELD_LABEL5 |
char |
20 |
|
user-defined label |
PO_FIELD1 |
char |
30 |
|
user-defined field |
PO_FIELD2 |
char |
30 |
|
user-defined field |
PO_FIELD3 |
char |
30 |
|
user-defined field |
PO_FIELD4 |
char |
30 |
|
user-defined field |
PO_FIELD5 |
char |
30 |
|
user-defined field |
PO_HOLD |
Short int |
(0 to 255) |
|
on hold? |
PO_APPROVED |
Short int |
(0 to 255) |
x |
approved? |
PO_APPROVED_DAT |
Short date |
1980..2079 |
|
date approved |
PO_APPROVED_BY |
char |
4 |
|
approved by initials |
PO_AP_ALERT |
char |
40 |
|
warning when adding the A/P |
PO_TAX_EXEMPT |
Short int |
(0 to 255) |
|
sales tax exempt |
PO_PERIOD |
Short int |
(0 to 255) |
x |
accounting period |
PO_AR_BILLED |
Number |
2 dp |
|
billed in A/R |
PO_TO_BE_BILLED |
Number |
2 dp |
|
to be billed amount |
PO_AR_NUM |
char |
10 |
|
A/R # on which this PO was billed |
PO_LINES |
Number |
0 dp |
|
number of line items (used for POX_LINE_NUMBER) |
PO_DISCLAIMER |
char |
2000 |
|
disclaimer |
PO_CLOSED |
Short num |
0 dp |
x |
closed checkbox |
PO_FORM |
Short num |
0 dp |
|
report form style |
PO_TOTAL_TITLE |
char |
20 |
|
default: Total not to exceed |
PO_MAT_DUE_LABEL |
char |
20 |
|
abel for "materials due |
PO_IMPORT_FROM |
char |
15 |
|
Tapscan/Strata/Smart Plus/CoreSpot/ |
PO_TRAFFIC_INSTR |
char |
2000 |
|
broadcast traffic instructions |
PO_REP_INSTR |
char |
2000 |
|
instructions/terms for the media rep |
PO_ADDED_BY |
char |
3 |
|
who added it? |
PO_REV |
Short num |
0 dp |
|
revision number |
PO_FIELD6 |
char |
15 |
|
media contract number |
PO_FIELD_LABEL6 |
char |
20 |
|
|
PO_REP_NAME |
char |
40 |
|
|
PO_REP_PHONE |
char |
20 |
|
|
PO_REP_FAX |
char |
20 |
|
|
PO_CAMPAIGN |
char |
20 |
|
campaign code for IOs, BOs |
PO_BRAND |
char |
20 |
|
brand for IOs, BOs |
PO_BLANKET |
Short int |
(0 to 255) |
|
Is this a blanket PO? If so, don't auto-close it |