|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PSO_Fulfillment_SeqNo | udd_seqno | int(4) | No | Fullfillment Lineno | Yes |
| PSO_Fulfillment_PSOOU | udd_ctxt_ouinstance | int(4) | No | Fullfillment PSO Ouinstance | No |
| PSO_Fulfillment_PSONo | udd_documentno | varchar(40) | No | Fullfillment Part Sale Order No | No |
| PSO_Fulfillment_PSOLineNo | udd_seqno | int(4) | No | Fullfillment PSO Lineno | No |
| PSO_Fulfillment_RefDocType | udd_designparamcode | varchar(5) | No | Fullfillment PSO Reference Doc.Type | No |
| PSO_Fulfillment_RefDocNo | udd_documentno | varchar(40) | No | Fullfillment PSO Reference Doc.No | No |
| PSO_Fulfillment_RefDocLineNo | udd_seqno | int(4) | No | Fullfillment PSO ReferenceLineno | No |
| PSO_Fulfillment_RecdDate | udd_time | Datetime(8) | No | Fullfillment PSO Received Date | No |
| PSO_Fullfilled_Quantity | udd_quantity | numeric(13) | No | PSO Fullfilled Quantity | No |
| PSO_Fullfilled_UOM | udd_uom | varchar(15) | No | PSO Fullfilled UOM | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| pso_no | _fin_documentno_40 | fin_documentno(40) | No | Part Sale Order No | No |
| pso_ou | _fin_ctxt_ouinstance_4 | fin_ctxt_ouinstance(4) | No | PSO Ouinstance | No |
| pso_revno | _fin_int_4 | fin_int(4) | No | PSO Revision No | No |
| pso_revdate | _fin_date_8 | fin_date(8) | Yes | PSO RevisionDate | No |
| pso_type | _fin_source_15 | fin_source(15) | Yes | PSO Type (Direct/Quote based) | No |
| pso_reftype | _fin_source_15 | fin_source(15) | Yes | PSO Pricing Ref. Date | No |
| pso_revres | _fin_notes_2000 | fin_notes(2000) | Yes | pso_revres | No |
| pso_refdocno | _fin_documentno_40 | fin_documentno(40) | Yes | pso_reference document number | No |
| pso_docsts | _fin_status_25 | fin_status(25) | Yes | pso_document status | No |
| pso_prsts | _fin_status_25 | fin_status(25) | Yes | pso Process Status | No |
| pso_orddt | _fin_date_8 | fin_date(8) | Yes | pso Order Date | No |
| pso_priority | _fin_quickcodes_25 | fin_quickcodes(25) | Yes | pso_priority | No |
| pso_category | _fin_categorydesc_255 | fin_categorydesc(255) | Yes | pso category | No |
| pso_curr | _fin_currencycode_5 | fin_currencycode(5) | Yes | pso Currency | No |
| pso_priterm | _fin_documentno_40 | fin_documentno(40) | Yes | pso pricing terms (NA) | No |
| pso_pridate | _fin_documentno_40 | fin_documentno(40) | Yes | pso pricing date(NA) | No |
| pso_date | _fin_date_8 | fin_date(8) | Yes | pso date | No |
| pso_userstatus | _fin_status_25 | fin_status(25) | Yes | pso userstatus | No |
| pso_custpo | _fin_documentno_40 | fin_documentno(40) | Yes | pso customer po number | No |
| pso_custpodt | _fin_date_8 | fin_date(8) | Yes | pso customer po date | No |
| pso_custserrep | _fin_contactperson_80 | fin_contactperson(80) | Yes | pso Customer Service Rep | No |
| pso_saleordtyp | _fin_type_25 | fin_type(25) | Yes | pso sale order type | No |
| pso_warrref | _fin_Log_1000 | fin_Log(1000) | Yes | pso warranty reference | No |
| pso_rem | _fin_notes_2000 | fin_notes(2000) | Yes | pso Sale Order remarks | No |
| pso_custno | _fin_customer_id_18 | fin_customer_id(18) | Yes | pso customer no | No |
| pso_ctype | _fin_quickcodes_25 | fin_quickcodes(25) | Yes | pso customer type | No |
| pso_caddid | _fin_quickcodes_25 | fin_quickcodes(25) | Yes | pso customer address id | No |
| pso_shipid | _fin_addressid_12 | fin_addressid(12) | Yes | pso customer | No |
| pso_pribas | _fin_designparamcode_5 | fin_designparamcode(5) | Yes | pso pricing basis | No |
| pso_pplno | _fin_documentno_40 | fin_documentno(40) | Yes | pso Part Pricelist no | No |
| pso_splno | _fin_documentno_40 | fin_documentno(40) | Yes | pso Service pricelist no | No |
| pso_conno | _fin_documentno_40 | fin_documentno(40) | Yes | pso contract no | No |
| pso_cat | _fin_category_15 | fin_category(15) | Yes | Category | No |
| pso_basicval | _fin_amount_13 | fin_amount(13) | Yes | pso Basic value | No |
| pso_tax | _fin_amount_13 | fin_amount(13) | Yes | pso Tax | No |
| pso_chr | _fin_amount_13 | fin_amount(13) | Yes | pso charge | No |
| pso_dis | _fin_amount_13 | fin_amount(13) | Yes | pso discount | No |
| pso_net | _fin_amount_13 | fin_amount(13) | Yes | pso net value | No |
| pso_bas_curr | _fin_currency_5 | fin_currency(5) | Yes | pso Basic currency | No |
| pso_bas_erate | _fin_amount_13 | fin_amount(13) | Yes | pso Basic excnange rate | No |
| pso_bas_amt | _fin_amount_13 | fin_amount(13) | Yes | pso Basic amount | No |
| pso_remark | _fin_notes_2000 | fin_notes(2000) | Yes | pso Remark | No |
| pso_amend | _fin_documentno_40 | fin_documentno(40) | Yes | NA | No |
| pso_cancomm | _fin_notes_2000 | fin_notes(2000) | Yes | pso Cancellation comment | No |
| pso_timestamp | _fin_int_4 | fin_int(4) | Yes | Timestamp | No |
| pso_createdby | _fin_ctxt_user_30 | fin_ctxt_user(30) | Yes | Created By | No |
| pso_createddt | _fin_date_8 | fin_date(8) | Yes | Created Date | No |
| pso_modifyby | _fin_ctxt_user_30 | fin_ctxt_user(30) | Yes | Modified by | No |
| pso_modifydt | _fin_date_8 | fin_date(8) | Yes | Modified Date | No |
| pso_confby | _fin_ctxt_user_30 | fin_ctxt_user(30) | Yes | Confirmed by | No |
| pso_confdt | _fin_date_8 | fin_date(8) | Yes | Confirmed Date | No |
| pso_appby | _fin_ctxt_user_30 | fin_ctxt_user(30) | Yes | Approved By | No |
| pso_appdt | _fin_date_8 | fin_date(8) | Yes | Approved Date | No |
| pso_mode | _fin_flag_25 | fin_flag(25) | Yes | Creation Mode (Automatic\Manual) | No |
| pso_employee_id | _fin_employee_code_60 | fin_employee_code(60) | Yes | pso_Employee Id | No |
| pso_billable | _fin_flag_25 | fin_flag(25) | Yes | Billable | No |
| pso_invsts | _fin_status_25 | fin_status(25) | Yes | Invoice status | No |
| pso_shpsts | _fin_status_25 | fin_status(25) | Yes | shipment status | No |
| pso_doc_key | _fin_wfdockey_128 | fin_wfdockey(128) | Yes | Work flow Generation Unique Key | No |
| pso_auth_status | _fin_status_25 | fin_status(25) | Yes | Work Flow status | No |
| pso_qt_revno | _fin_revno_3 | fin_revno(3) | Yes | quote revision no | No |
| pso_consFlg | fin_designparamcode | varchar(5) | Yes | Consignment PSO Flag | No |
| pso_CtContPer | fin_custname | varchar(40) | Yes | Customer Contact Person | No |
| pso_shptocust | fin_customer_id | varchar(18) | Yes | Ship To Customer | No |
| pso_ShContPer | fin_custname | varchar(40) | Yes | Ship to Contact Person | No |
| user_def1 | fin_txt255 | Varchar(255) | Yes | user define value 1 | No |
| user_def2 | fin_txt255 | Varchar(255) | Yes | user define value 2 | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| pso_component_name | _fin_ctxt_component_20 | fin_ctxt_component(20) | No | Component Name | Yes |
| pso_parameter_type | _fin_paramtype_25 | fin_paramtype(25) | No | Parameter Type | Yes |
| pso_parameter_category | _fin_category_15 | fin_category(15) | No | parameter category | Yes |
| pso_parameter_code | _fin_designparamcode_5 | fin_designparamcode(5) | No | parameter code | Yes |
| pso_parameter_desc | _fin_remarks_100 | fin_remarks(100) | Yes | parameter Description | No |
| pso_lang_id | _fin_ctxt_language_4 | fin_ctxt_language(4) | Yes | Language | No |
| pso_sort_by | _fin_count_4 | fin_count(4) | Yes | Order By value | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| pso_ou | _fin_ctxt_ouinstance_4 | fin_ctxt_ouinstance(4) | No | pso_Ouinstance | Yes |
| pso_no | _fin_documentno_40 | fin_documentno(40) | No | Part sale order no | Yes |
| pso_revno | _fin_int_4 | fin_int(4) | No | Part sale order revision no | Yes |
| pso_lineno | _fin_lineno_4 | fin_lineno(4) | No | Lineno | Yes |
| pso_ref_no | _fin_documentno_40 | fin_documentno(40) | Yes | Reference document no | No |
| pso_ref_lineno | _fin_seqno_4 | fin_seqno(4) | Yes | Reference document line no | No |
| pso_partno | _fin_partno_40 | fin_partno(40) | Yes | part number | No |
| pso_lnstatus | _fin_status_25 | fin_status(25) | Yes | pso Line status | No |
| pso_prstatus | _fin_status_25 | fin_status(25) | Yes | pso process status | No |
| pso_refqty | _fin_quantity_17 | fin_quantity(17) | Yes | pso_Reference quantity | No |
| pso_ordqty | _fin_quantity_17 | fin_quantity(17) | Yes | ordered quantity | No |
| pso_shipqty | _fin_quantity_17 | fin_quantity(17) | Yes | shipping quantity | No |
| pso_issqty | _fin_quantity_17 | fin_quantity(17) | Yes | Issued quantity | No |
| pso_invqty | _fin_quantity_17 | fin_quantity(17) | Yes | Invoiced quantity | No |
| pso_mrqty | _fin_quantity_17 | fin_quantity(17) | Yes | Material Request quantity | No |
| pso_partdesc | _fin_partdesc_150 | fin_partdesc(150) | Yes | part description | No |
| pso_mfr_part_no | _fin_partno_40 | fin_partno(40) | Yes | mfr.part no | No |
| pso_mfr_no | _fin_vendorcode_45 | fin_vendorcode(45) | Yes | mfr.no | No |
| pso_prtuom | _fin_uom_15 | fin_uom(15) | Yes | Uom | No |
| pso_cond | _fin_quickcodes_25 | fin_quickcodes(25) | Yes | part condition | No |
| pso_issuom | _fin_uom_15 | fin_uom(15) | Yes | Issued uom | No |
| pso_expdeldt | _fin_date_8 | fin_date(8) | Yes | Expected delivery date | No |
| pso_prtavail | _fin_flag_25 | fin_flag(25) | Yes | Part availability | No |
| pso_rel | _fin_quickcodes_25 | fin_quickcodes(25) | Yes | pso_rel | No |
| pso_source | _fin_quickcodes_25 | fin_quickcodes(25) | Yes | source | No |
| pso_alloctype | _fin_quickcodes_25 | fin_quickcodes(25) | Yes | Allocation type | No |
| pso_mrno | _fin_documentno_40 | fin_documentno(40) | Yes | Material Request no | No |
| pso_whno | _fin_documentno_40 | fin_documentno(40) | Yes | Warehouse No | No |
| pso_stockstatus | _fin_stockstatus_40 | fin_stockstatus(40) | Yes | Stock status | No |
| pso_tradtype | _fin_quickcodes_25 | fin_quickcodes(25) | Yes | Trade type | No |
| pso_tradno | _fin_vendorcode_45 | fin_vendorcode(45) | Yes | Trade no | No |
| pso_pono | _fin_documentno_40 | fin_documentno(40) | Yes | Purchase order no | No |
| pso_suppno | _fin_vendorcode_45 | fin_vendorcode(45) | Yes | Supplier no | No |
| pso_intnotes | _fin_notes_2000 | fin_notes(2000) | Yes | Internal Notes | No |
| pso_modnotes | _fin_notes_2000 | fin_notes(2000) | Yes | modified Notes | No |
| pso_specinst | _fin_notes_2000 | fin_notes(2000) | Yes | Specs /Restrictions | No |
| pso_delinst | _fin_notes_2000 | fin_notes(2000) | Yes | Del. Instructions | No |
| pso_warr | _fin_flag_25 | fin_flag(25) | Yes | Warranty | No |
| pso_rem | _fin_notes_2000 | fin_notes(2000) | Yes | Remarks | No |
| pso_pricdesc | _fin_notes_2000 | fin_notes(2000) | Yes | Pricing Description | No |
| pso_certytype | _fin_type_25 | fin_type(25) | Yes | Certificate Type | No |
| pso_addid | _fin_addressid_12 | fin_addressid(12) | Yes | Address Id | No |
| pso_pplno | _fin_documentno_40 | fin_documentno(40) | Yes | Part Pricelist # | No |
| pso_splno | _fin_documentno_40 | fin_documentno(40) | Yes | Service Pricelist # | No |
| pso_pplrevno | _fin_revno_3 | fin_revno(3) | Yes | Part Pricelist Revision no | No |
| pso_splrevno | _fin_revno_3 | fin_revno(3) | Yes | Service Pricelist Revision no | No |
| pso_pplcur | _fin_currencycode_5 | fin_currencycode(5) | Yes | Part Pricelist Currency | No |
| pso_brate_ppl | _fin_amount_13 | fin_amount(13) | Yes | Base rate in ppl | No |
| pso_ppl_exrt | _fin_rate_13 | fin_rate(13) | Yes | PPL Extd. Price | No |
| pso_sys_brate | _fin_rate_13 | fin_rate(13) | Yes | sys.Base rate | No |
| pso_act_brate | _fin_rate_13 | fin_rate(13) | Yes | Actual Base rate | No |
| pso_badjfac | _fin_rate_13 | fin_rate(13) | Yes | Base adjustment factor | No |
| pso_facbasrate | _fin_rate_13 | fin_rate(13) | Yes | Factored base rate | No |
| pso_pricfac | _fin_factor_13 | fin_factor(13) | Yes | price factor | No |
| pso_pricfacon | _fin_designparamcode_5 | fin_designparamcode(5) | Yes | price factor on | No |
| pso_sys_umarkup | _fin_amount_13 | fin_amount(13) | Yes | sys.Unit markup | No |
| pso_act_umarkup | _fin_amount_13 | fin_amount(13) | Yes | Act.Unit markup | No |
| pso_sys_uprice | _fin_amount_13 | fin_amount(13) | Yes | sys.Unit price | No |
| pso_act_uprice | _fin_amount_13 | fin_amount(13) | Yes | Act.Unit price | No |
| pso_exprice | _fin_amount_13 | fin_amount(13) | Yes | Extd.price | No |
| pso_exmrkup | _fin_amount_13 | fin_amount(13) | Yes | Extd. Markup | No |
| pso_exnetprice | _fin_amount_13 | fin_amount(13) | Yes | Extd.Netprice | No |
| pso_tcdamt | _fin_amount_13 | fin_amount(13) | Yes | TCD amount | No |
| pso_exnetvalue | _fin_amount_13 | fin_amount(13) | Yes | Extd.Netvalue | No |
| pso_bas_curr | _fin_currency_5 | fin_currency(5) | Yes | Base currency | No |
| pso_bas_erate | _fin_amount_13 | fin_amount(13) | Yes | Base Exchange rate | No |
| pso_bas_amt | _fin_amount_13 | fin_amount(13) | Yes | Base Amount | No |
| pso_pricnarr | _fin_notes_2000 | fin_notes(2000) | Yes | Pricing narration | No |
| pso_estcost | _fin_amount_13 | fin_amount(13) | Yes | Estimated cost | No |
| pso_estmarkup | _fin_amount_13 | fin_amount(13) | Yes | Estimated Markup | No |
| pso_estmarkupper | _fin_amount_13 | fin_amount(13) | Yes | Estimated Markup Per | No |
| pso_price_source | _fin_source_15 | fin_source(15) | Yes | Pricing source | No |
| pso_final_price | _fin_amount_13 | fin_amount(13) | Yes | Final price | No |
| pso_total_price | _fin_amount_13 | fin_amount(13) | Yes | Total price | No |
| pso_shipno | _fin_documentno_40 | fin_documentno(40) | Yes | Shipping no | No |
| pso_issueno | _fin_documentno_40 | fin_documentno(40) | Yes | Issue no | No |
| pso_reftyp | _fin_types_30 | fin_types(30) | Yes | Reference type | No |
| pso_org_prt | fin_partno | varchar(40) | Yes | Original part | No |
| pso_estdur_unit | fin_remarks | varchar(100) | Yes | Estimate duration unit | No |
| user_def1 | fin_txt255 | Varchar(255) | Yes | User defined value 1 | No |
| pso_req_partdesc | fin_partdesc | Char(150) | Yes | Requested part Description | No |
| pso_est_dur | fin_int | int(4) | Yes | Estimate duration | No |
| pso_fulfillqty | fin_quantity | numeric(17) | Yes | pso_fulfillqty | No |
| pso_req_partno | fin_partno | varchar(40) | Yes | Requested partno | No |
| user_def2 | fin_txt255 | Varchar(255) | Yes | User defined value 2 | No |
| pso_old_needdt | fin_date | datetime(8) | Yes | Old need date | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| pso_ou | _fin_int_4 | fin_int(4) | Yes | ouinstance | No |
| pso_context | _fin_description_100 | fin_description(100) | Yes | pso_context | No |
| pso_order_no | _fin_documentno_40 | fin_documentno(40) | Yes | part sale order no | No |
| pso_revno | _fin_int_4 | fin_int(4) | Yes | part sale order revision no | No |
| pso_actiontype | _fin_type_25 | fin_type(25) | Yes | Action type | No |
| pso_status | _fin_status_25 | fin_status(25) | Yes | PSO status | No |
| pso_source | _fin_quickcodes_25 | fin_quickcodes(25) | Yes | Source(Automatic\manual) | No |
| pso_errormsg | _fin_notes_2000 | fin_notes(2000) | Yes | Error message | No |
| replication_key | _uniqueidentifier_16 | uniqueidentifier(16) | No | Unique Key id | Yes |
| pso_batchid | fin_guid | varchar(40) | No | Unique batch id | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| pso_ou | _fin_int_4 | fin_int(4) | Yes | pso_ou | No |
| pso_context | _fin_description_100 | fin_description(100) | Yes | pso_context | No |
| pso_order_no | _fin_documentno_40 | fin_documentno(40) | Yes | pso_order_no | No |
| pso_revno | _fin_int_4 | fin_int(4) | Yes | pso_revno | No |
| pso_actiontype | _fin_type_25 | fin_type(25) | Yes | pso_actiontype | No |
| pso_status | _fin_status_25 | fin_status(25) | Yes | pso_status | No |
| pso_source | _fin_quickcodes_25 | fin_quickcodes(25) | Yes | pso_source | No |
| pso_datetime | _fin_datetime_8 | fin_datetime(8) | Yes | pso_datetime | No |
| pso_error_desc | _fin_notes_2000 | fin_notes(2000) | Yes | pso_error_desc | No |
| replication_key | _uniqueidentifier_16 | uniqueidentifier(16) | No | replication_key | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| pso_langid | _fin_ctxt_language_4 | fin_ctxt_language(4) | Yes | language | No |
| pso_component | _fin_component_16 | fin_component(16) | Yes | Component | No |
| pso_basis | _fin_basis_8 | fin_basis(8) | Yes | Basis | No |
| pso_tab | _fin_name_60 | fin_name(60) | Yes | Tab information | No |
| pso_type | _fin_type_25 | fin_type(25) | Yes | pso Type | No |
| pso_pricbasis | _fin_basis_8 | fin_basis(8) | Yes | Pricing Basis | No |
| pso_prs_flag | _fin_flag_25 | fin_flag(25) | Yes | Processing flag | No |
| pso_status | _fin_status_25 | fin_status(25) | Yes | PSO status | No |
| pso_stateid | _fin_txt255_255 | fin_txt255(255) | Yes | state id | No |
| replication_key | _bigint_8 | Bigint(8) | No | Unique Key id | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| pso_ou | _fin_ctxt_ouinstance_4 | fin_ctxt_ouinstance(4) | No | ouinstance | Yes |
| pso_no | _fin_documentno_40 | fin_documentno(40) | No | part sale order no | Yes |
| pso_revno | _fin_int_4 | fin_int(4) | No | part sale order revision no | Yes |
| pso_reftype | _fin_type_25 | fin_type(25) | No | Reference type | Yes |
| pso_partlineno | _fin_seqno_4 | fin_seqno(4) | No | Part Reference lineno | Yes |
| pso_tcdlineno | _fin_seqno_4 | fin_seqno(4) | No | TCD lineno | Yes |
| pso_appon | _fin_flag_25 | fin_flag(25) | Yes | TCD Applied On | No |
| pso_tcdcode | _fin_itemcode_40 | fin_itemcode(40) | Yes | TCD code | No |
| pso_tcdvar | _fin_itemcode_40 | fin_itemcode(40) | Yes | TCD Variant | No |
| pso_rate | _fin_amount_13 | fin_amount(13) | Yes | Rate | No |
| pso_taxableamt | _fin_amount_13 | fin_amount(13) | Yes | Taxable Amount | No |
| pso_tcd_amt | _fin_amount_13 | fin_amount(13) | Yes | TCD Amount | No |
| pso_tcd_curr | _fin_currency_5 | fin_currency(5) | Yes | TCD currency | No |
| pso_tcd_type | _fin_types_30 | fin_types(30) | Yes | TCD type | No |
| pso_tcd_basis | _fin_types_30 | fin_types(30) | Yes | TCD Basis | No |
| pso_costcenter | _fin_costcentercode_10 | fin_costcentercode(10) | Yes | Costcenter | No |
| pso_billable | _fin_flag_25 | fin_flag(25) | Yes | Billable Flag | No |
| pso_erate | _fin_amount_13 | fin_amount(13) | Yes | Exchange rate | No |
| pso_qcur_amt | _fin_amount_13 | fin_amount(13) | Yes | Quote Currency amount | No |
| pso_timestamp | _fin_int_4 | fin_int(4) | Yes | Timestamp | No |
| pso_efffrom | _fin_date_8 | fin_date(8) | Yes | Effective from | No |
| pso_effto | _fin_date_8 | fin_date(8) | Yes | Effective to | No |
| pso_createdby | _fin_ctxt_user_30 | fin_ctxt_user(30) | Yes | Created by | No |
| pso_createddt | _fin_date_8 | fin_date(8) | Yes | Created date | No |
| pso_modifyby | _fin_ctxt_user_30 | fin_ctxt_user(30) | Yes | modified by | No |
| pso_modifydt | _fin_date_8 | fin_date(8) | Yes | modified date | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| pso_ou | _fin_ctxt_ouinstance_4 | fin_ctxt_ouinstance(4) | No | ouinstance | Yes |
| pso_docno | _fin_documentno_40 | fin_documentno(40) | No | part sale order no | Yes |
| pso_docrevno | _fin_int_4 | fin_int(4) | No | part sale order revision no | Yes |
| pso_carrieragen | _fin_carriercode_20 | fin_carriercode(20) | Yes | Carrier / Agency # | No |
| pso_shipmet | _fin_quickcodes_25 | fin_quickcodes(25) | Yes | Shipping Method | No |
| pso_packcode | _fin_quickcodes_25 | fin_quickcodes(25) | Yes | Packaging Code | No |
| pso_shippay | _fin_quickcodes_25 | fin_quickcodes(25) | Yes | Shipping Payment | No |
| pso_accno | _fin_accountcode_32 | fin_accountcode(32) | Yes | Account # | No |
| pso_othaccno | _fin_accountcode_32 | fin_accountcode(32) | Yes | Other Account # | No |
| pso_inco | _fin_txt150_150 | fin_txt150(150) | Yes | INCO Terms | No |
| pso_frtbill | _fin_flag_25 | fin_flag(25) | Yes | Freight Billable ? | No |
| pso_frtterm | _fin_categorydesc_255 | fin_categorydesc(255) | Yes | Freight Terms | No |
| pso_tranship | _fin_flag_25 | fin_flag(25) | Yes | Transshipment | No |
| pso_dropshreq | _fin_flag_25 | fin_flag(25) | Yes | Dropship Required | No |
| pso_packnote | _fin_notes_2000 | fin_notes(2000) | Yes | Packaging Notes | No |
| pso_advrec | _fin_flag_25 | fin_flag(25) | Yes | Advance Receivable | No |
| pso_advrecby | _fin_date_8 | fin_date(8) | Yes | Advance Receivable by | No |
| pso_advperon | _fin_quickcodes_25 | fin_quickcodes(25) | Yes | Advance % on | No |
| pso_advper | _fin_rate_13 | fin_rate(13) | Yes | Advance % / Value | No |
| pso_advval | _fin_amount_13 | fin_amount(13) | Yes | Advance Value | No |
| pso_paymode | _fin_paymode_25 | fin_paymode(25) | Yes | Payment Mode | No |
| pso_payterm | _fin_payterm_30 | fin_payterm(30) | Yes | Pay Term | No |
| pso_billtocust | _fin_customer_id_18 | fin_customer_id(18) | Yes | Bill to Customer | No |
| pso_billtoid | _fin_addressid_12 | fin_addressid(12) | Yes | Bill to Address ID | No |
| pso_insliab | _fin_quickcodes_25 | fin_quickcodes(25) | Yes | Insurance Liability | No |
| pso_insamt | _fin_amount_13 | fin_amount(13) | Yes | Insurance Amount | No |
| pso_gtaref | _fin_documentno_40 | fin_documentno(40) | Yes | GTA Reference # | No |
| pso_gtrem | _fin_notes_2000 | fin_notes(2000) | Yes | GTA Remarks | No |
| pso_refdocdt | _fin_date_8 | fin_date(8) | Yes | Ref. Doc. Date | No |
| pso_warrbasis | _fin_quickcodes_25 | fin_quickcodes(25) | Yes | Warranty Basis | No |
| pso_refagree | _fin_comments_256 | fin_comments(256) | Yes | Warranty Agreement | No |
| pso_termref | _fin_comments_256 | fin_comments(256) | Yes | Term reference | No |
| pso_warron | _fin_date_8 | fin_date(8) | Yes | Warranty on | No |
| pso_valid | _fin_amount_13 | fin_amount(13) | Yes | valid fro value | No |
| pso_validfor | _fin_quickcodes_25 | fin_quickcodes(25) | Yes | validfor | No |
| pso_fhfc | _fin_comments_256 | fin_comments(256) | Yes | pso_fhfc | No |
| pso_doctype | _fin_type_25 | fin_type(25) | Yes | Document type | No |
| pso_aggrementno | fin_documentno | Varchar(40) | Yes | Aggrement no | No |
| pso_paramcode | fin_quickcodes | varchar(25) | Yes | paramete code | No |
| pso_warr_startref | fin_designparamcode | varchar(5) | Yes | Warranty Start Ref. Date | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| pso_ou | fin_ctxt_ouinstance | int(4) | Yes | ouinstance | No |
| pso_no | fin_documentno | Varchar(40) | Yes | number | No |
| pso_renno | fin_rev_no | Int(4) | Yes | rennumber | No |
| pso_seqno | fin_seqno | int(4) | No | sequencenumber | Yes |
| pso_agreemtno | fin_documentno | Varchar(40) | Yes | aggrementnumber | No |
| pso_agreemrevno | fin_rev_no | Int(4) | Yes | aggrementrevnumber | No |
| pso_agreemttype | fin_type | varchar(25) | Yes | aggrementtype | No |
| pso_agreemtlineno | fin_lineno | Int(4) | Yes | aggrementlinenumber | No |
| pso_stdtref | fin_type | varchar(25) | Yes | standard reference | No |
| pso_stdt | fin_date | datetime(8) | Yes | standard | No |
| pso_param_uom | fin_uom | varchar(15) | Yes | parameter unit of measurement | No |
| pso_param_val | fin_amount | numeric(13) | Yes | parameter value | No |
| pso_periodval | fin_amount | numeric(13) | Yes | period value | No |
| pso_perioduom | fin_uom | varchar(15) | Yes | period unit of measurement | No |
| pso_crby | fin_ctxt_user | varchar(30) | Yes | createdby | No |
| pso_crdt | fin_date | datetime(8) | Yes | created date | No |
| pso_instno | fin_documentno | Varchar(40) | Yes | instant number | No |
| pso_appflag | fin_flag | varchar(25) | Yes | appflag | No |
| pso_lineno | fin_lineno | Int(4) | Yes | linenumber | No |
| pso_upd_docno | fin_documentno | Varchar(40) | Yes | update document number | No |
| pso_upd_doctyp | fin_type | varchar(25) | Yes | update document type | No |
| pso_instgen_flag | fin_flag | varchar(25) | Yes | instant generated flag | No |
| pso_aggrestatus | fin_status | varchar(25) | Yes | aggrement status | No |
| pso_warremarks | fin_remarks | varchar(100) | Yes | warrenty marks | No |
| pso_modby | fin_ctxt_user | varchar(30) | Yes | modified by | No |
| pso_moddt | fin_date | datetime(8) | Yes | modified date | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| pso_ou | fin_ctxt_ouinstance | int(4) | No | Ouinstance | Yes |
| pso_no | fin_documentno | Varchar(40) | No | Part sale order no | Yes |
| pso_revno | fin_rev_no | Int(4) | No | Part sale order revision no | Yes |
| pso_seqno | fin_seqno | int(4) | No | Sequence NO | Yes |
| pso_agreemtno | fin_documentno | Varchar(40) | Yes | Agreement No | No |
| pso_agreemrevno | fin_rev_no | Int(4) | Yes | Agreement Revision no | No |
| pso_agreemttype | fin_type | varchar(25) | Yes | Agreement Type | No |
| pso_agreemtlineno | fin_lineno | Int(4) | Yes | Agrement Lineno | No |
| pso_stdtref | fin_type | varchar(25) | Yes | Start date reference | No |
| pso_stdt | fin_date | datetime(8) | Yes | start date | No |
| pso_param_uom | fin_uom | varchar(15) | Yes | UOM | No |
| pso_param_val | fin_amount | numeric(13) | Yes | Value | No |
| pso_periodval | fin_amount | numeric(13) | Yes | Period value | No |
| pso_perioduom | fin_uom | varchar(15) | Yes | Period UOM | No |
| pso_crby | fin_ctxt_user | varchar(30) | Yes | created by | No |
| pso_crdt | fin_date | datetime(8) | Yes | created date | No |
| pso_instno | fin_documentno | Varchar(40) | Yes | Warranty Instance no | No |
| pso_lineno | fin_lineno | Int(4) | Yes | Warranty Instance line no | No |
| pso_upd_docno | fin_documentno | Varchar(40) | Yes | Warranty Instance no updating document no | No |
| pso_upd_doctyp | fin_type | varchar(25) | Yes | Warranty Instance no updating document type | No |
| pso_instgen_flag | fin_flag | varchar(25) | Yes | Instance generation flag | No |
| pso_aggrestatus | fin_status | varchar(25) | Yes | Agreement Satus | No |
| pso_warremarks | fin_remarks | varchar(100) | Yes | warranty remarks | No |
| pso_modby | fin_ctxt_user | varchar(30) | Yes | Modified by | No |
| pso_moddt | fin_date | datetime(8) | Yes | Modified Date | No |
| pso_partno | fin_partno | varchar(40) | Yes | Partno | No |
| pso_mfrsrl_no | fin_partno | varchar(40) | Yes | Manufacture Serial no | No |
| pso_intsrl_no | fin_partno | varchar(40) | Yes | Internal Serial no | No |
| pso_mfrlot_no | fin_lotno | varchar(18) | Yes | Manufacture Lot no | No |
| pso_intlot_no | fin_lotno | varchar(18) | Yes | Internal lot no | No |