C&P Data Dictionary: PURCHASE_ORDER

Other files: ACCOUNTS AP AR AR_ITEMS BILLING_INFO CHANGE_ORDER CHECKS CHECK_ITEMS CLIENTS COSTS DEPTS GROUPS HISTORY HISTORY_CLIENT INT_ITEMS JE JOBS JOB_ORDER JOB_TASK JOB_TYPES MEDIA_EST MEDIA_EST_ITEMS MEDIA_ITEMS MEDIA_PLANS PAYMENTS PAYMENT_ITEMS PC PICTURES PO_ITEMS PO_TEMPLATE PRINT_SPECS PROGRAMS PROJECTS PURCHASE_ORDER RATES RECUR_AP RETAINERS STAFF STATIONS STATUS_CODES SUB_CLASSES TASK_TABLE VENDORS WEB_IP_LOG WEB_USERS WORKSHEETS

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 32000   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 32000   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 date 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 date x date added PO_PC number 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 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.