Clients & Profits Worldwide :: Data Dictionary

Free help: USER GUIDE } BLOG } SYSTEM MANAGER NEWS

Home > Support > Data Dictionary > PURCHASE_ORDER

C&P Data Dictionary: PURCHASE_ORDER

Other files:

ACC_PERIODS
ACCESS_PRIVS
ACCOUNTS
ADDRESSES
AP
AR
AR_ITEMS
ARCHIVED_JOBS
ASSET_TYPES
ASSET_FILES
ASSET_PREFS
AVAIL
BILLING_INFO
CAL
CALENDAR
CHANGE_ITEMS
CHANGE_ORDER
CHECKS
CHECK_ITEMS
CLIENTS
CONTACTS
COSTS
CREDIT_CARD_PREFS
DATE_COUNT
DEPTS
EST_REVS
F_PREFERENCE
FINANCE
GLOBAL_VARS
GROUPS
HISTORY
HISTORY_CLIENT
HISTORY_VENDOR
HOME
INT_ITEMS
JE
JOBS
JOB_ORDER
JOB_TASK
JOB_TYPES
MEDIA_BRIEFS
MEDIA_EST
MEDIA_EST_ITEMS
MEDIA_ITEMS
MEDIA_PLANS
MEDIA_PREFS
MEETINGS
MLINK
MLINK_PREFS
ODBCUSERS
OUTBOX
PALM_CATS
PALM_JOBS
PALM_TASKS
PAYMENTS
PAYMENT_ITEMS
PC
PICTURES
PO_ITEMS
PO_TEMPLATE
PREFS
PRINT_SPECS
PROGRAMS
PROJECTS
PROPOSALS
PURCHASE_ORDER
RATES
RECUR_AP
RETAINERS
SALES_ACTIONS
SALES_CAMPAIGNS
SALES_LETTERS
SCHEDULE_CHART
SCHEDULE_HEADER
STAFF
STATEMENTS
STATIONS
STATUS_CODES
SUB_CLASSES
TASK_TABLE
TEMP_TASKS
THOUGHT
TIME_IMPORT
TIMECARD
TIMELINE
USER_INFO
VENDORS
VERSION
WEB_HTML
WEB_IP_LOG
WEB_LOG
WEB_PREFS
WEB_USERS_LOG
WORKING
WORKSHEETS
Y1099

PURCHASE_ORDER is the data file that stores the Purchase Orders, Insertion Orders, and Broadcast Orders. Each PURCHASE_ORDER record contains a single PO or IO. It is a data file used primarly on PO/IO reports (e.g., PO Analysis, Summaries, and Lists etc.). Each PURCHASE_ORDER record has fields for PO Detail (i.e., PO_JOB_NUM, PO_DESC, PO_COST etc.), Vendor information (i.e., PO_VENDOR_NUM, PO_SHIP1 thru PO_SHIP4, and PO_VENDOR1 thru PO_VENDOR4 etc.) and PO Terms (i.e., PO_DUE_DATE, PO_TERMS1 thru PO_TERMS3 etc.) for each PO or IO. The Ammount field is updated as PO Line Itesm are added to the PO.

See related data files: VENDOR MEDIA_ITEMS PO_ITEMS PO_TEMPLATE

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

LEGEND:

Type indicates whether a field contains characters (i.e., "char") which contains any combination of letters or numbers, numbers (which has a set number of decimal places), or integers (i.e., numbers that range from 0 to 255 only).

Length shows the size of a field. Character fields have lengths that are fixed, depending on their purpose. Description and note fields have a length of 32000, which make them variable-length; their actual size depends on how much data is entered into them.

Index indicates fields that are indexed in the database, which makes them key fields for finding and sorting data. For best performances on reporting and exporting, searches should made on index fields first.

Need help exporting? See the Exporting Data from Clients & Profits tech note.

For subscribers: VIDEOS } FAQs/TECH NOTES } COMMUNITY } LEARN } BUGS/WISH LIST } TIPS