|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| pkslph_no | udd_documentno | varchar(40) | No | This field holds unique packslip number for a packslip document | Yes |
| pkslph_ou | udd_ctxt_ouinstance | int(4) | No | This is the ou instance in which Packslip is created | Yes |
| pkslph_num_type | udd_notypeno | varchar(5) | No | Numbering type for the packslip number generation | No |
| pkslph_status | udd_designparamcode | varchar(5) | No | This field holds the status of the packslip. The possible values are 1 Fresh 2 Confimed 3 Allocated 4 Issued 5 Shipped | No |
| pkslph_category | udd_quickcodes | varchar(25) | Yes | This field holds the category of packslip. The possible values are 1 Customer 2 Internal | No |
| pkslph_type | udd_flag2 | varchar(25) | No | This field holds the type of Packlsip.The possible values are 1 Customer Goods 2 customer Order 3 Part Sale | No |
| pkslph_user_status | udd_partstatus | varchar(40) | Yes | This field holds all values of the Quickcodes in Active status of the Type : User Status as defined in the Create Quickcodes activity of the current component.Load Space as a value and default the same in the combo | No |
| pkslph_date | udd_datetime1 | datetime(8) | No | This field holds the date on which packslip is created | No |
| pkslph_inv_appl | udd_designparamcode | varchar(5) | No | This field holds whether invoice applicable is Yes or No | No |
| pkslph_ship_date | udd_datetime1 | datetime(8) | Yes | This field holds the date on which shipment is made. | No |
| pkslph_ship_time | udd_datetime1 | datetime(8) | Yes | This field holds the date in which shipment is made. | No |
| pkslph_cust_no | udd_customer_id | varchar(18) | No | This field holds the customer to which packslip is created | No |
| pkslph_cust_ou | udd_ctxt_ouinstance | int(4) | No | This field holds the OUinstance in which customer is created | No |
| pkslph_ref_doc_type | udd_transactiontype | varchar(40) | Yes | This field holds the ref doc type for the packslip. The possible values are 1 General 2 customer order | No |
| pkslph_order_point | udd_ctxt_ouinstance | int(4) | Yes | This field holds the Ouinstance in which Packslip is created | No |
| pkslph_ref_doc_no | udd_documentno | varchar(40) | Yes | This field holds the reference document number for packslip | No |
| pkslph_ref_doc_amd_no | udd_numrevno | int(4) | Yes | This field holds the reference document amendment number | No |
| pkslph_ref_doc_date | udd_datetime1 | datetime(8) | Yes | This field holds the date on which reference document was created | No |
| pkslph_other_ref | udd_desc40 | varchar(40) | Yes | Other reference values | No |
| pkslph_ship_to_cust_no | udd_customer_id | varchar(18) | Yes | This field holds the customer to which parts are shipped | No |
| pkslph_ship_to_cust_ou | udd_ctxt_ouinstance | int(4) | Yes | This field holds the ouinstance of the customer to which parts are shipped | No |
| pkslph_address_no | udd_address | varchar(40) | Yes | This field holds the address id of the customer | No |
| pkslph_address | udd_txt2000 | varchar(2000) | Yes | This field holds the address of the customer | No |
| pkslph_cnt_person | udd_contactperson | varchar(80) | Yes | This field holds the name of the contact person | No |
| pkslph_phone | udd_communicationid | varchar(70) | Yes | This field holds the phone number of the contact person | No |
| pkslph_email | udd_email | varchar(60) | Yes | This field holds the Email of the contact person | No |
| pkslph_fax | udd_fax | varchar(40) | Yes | This field holds the Fax of the contact person | No |
| pkslph_del_area | udd_deliveryarea | varchar(18) | Yes | This field holds the delivery area | No |
| pkslph_ship_type | udd_categorydesc | varchar(255) | Yes | This field holds the shipment type | No |
| pkslph_carrier | udd_carriercode | varchar(20) | Yes | this field holds the carrier code of packslip | No |
| pkslph_trans_mode | udd_categorydesc | varchar(255) | Yes | This field holds the transportation mode | No |
| pkslph_vehicle_no | udd_transportmode | varchar(20) | Yes | This field holds the vehicle number of packslip | No |
| pkslph_frt_billable | udd_designparamcode | varchar(5) | Yes | This field holds the freight billable applicability. The possible values are 1 Yes 2 NO | No |
| pkslph_frt_amount | udd_amount | numeric(13) | Yes | This field holds the freight billable amount | No |
| pkslph_frt_currency | udd_currency | varchar(20) | Yes | This field holds the freight currency | No |
| pkslph_port_of_dest | udd_city | varchar(32) | Yes | this field holds the port of destination | No |
| pkslph_frt_terms | udd_categorydesc | varchar(255) | Yes | This field holds the freight terms | No |
| pkslph_way_bill_no | udd_refdocno | varchar(40) | Yes | this field holds the waybill number | No |
| pkslph_pro_no | udd_documentno | varchar(40) | Yes | This field holds the Pro No | No |
| pkslph_awb_no | udd_documentno | varchar(40) | Yes | This field holds the AWB No | No |
| pkslph_bol_no | udd_documentno | varchar(40) | Yes | This field holds the Bol No | No |
| pkslph_inco_term | udd_desc40 | varchar(40) | Yes | this field holds the Inco Term | No |
| pkslph_tracking_no | udd_trackingnumber | varchar(20) | Yes | This field holds the tracking number | No |
| pkslph_ins_liability | udd_designparamcode | varchar(5) | Yes | This field holds the insurance liability | No |
| pkslph_ins_terms | udd_txt150 | varchar(150) | Yes | This field holds the insurance terms | No |
| pkslph_pack_cores | udd_quickcodes | varchar(25) | Yes | This field holds the packaging code for the cores | No |
| pkslph_pack_spares | udd_quickcodes | varchar(25) | Yes | This field holds the packaging code for the spares | No |
| pkslph_pack_service | udd_quickcodes | varchar(25) | Yes | This field holds the packaging code for the serviceable components | No |
| pkslph_hazard_product | udd_designparamcode | varchar(5) | Yes | This field holds whether the products specified is hazardous or not. the possible values are 1 yes 2 No | No |
| pkslph_ship_label | udd_desc40 | varchar(40) | Yes | This field holds the shipping label | No |
| pkslph_comments | udd_txt255 | varchar(255) | Yes | This field holds the packslip comments | No |
| pkslph_filename | udd_filename | varchar(50) | Yes | This field holds the filename for packslip | No |
| pkslph_timestamp | udd_timestamp | int(4) | No | This field is to capture the timestamp of the record | No |
| pkslph_created_by | udd_ctxt_user | varchar(30) | No | This field is to capture the user who created the document | No |
| pkslph_created_date | udd_datetime1 | datetime(8) | No | This field is to capture the created date of the document | No |
| pkslph_issue_by | udd_ctxt_user | varchar(30) | Yes | This field is to capture the user who issued the parts | No |
| pkslph_modified_by | udd_ctxt_user | varchar(30) | No | This field is to capture the user who modified the document | No |
| pkslph_modified_date | udd_datetime1 | datetime(8) | No | This field is to capture the modified date of the document | No |
| pkslph_issue_date | udd_datetime1 | datetime(8) | Yes | This field is to capture the issued date of the document | No |
| pkslph_issue_comments | udd_txt255 | varchar(255) | Yes | This field holds the issue comments | No |
| pkslph_ship_by | udd_ctxt_user | varchar(30) | Yes | This field is to capture the user who Shipped the parts | No |
| pkslph_ship_comments | udd_txt255 | varchar(255) | Yes | This field holds the shipping comments | No |
| pkslph_alloc_by | udd_ctxt_user | varchar(30) | Yes | This field is to capture the user who allocated the parts | No |
| pkslph_alloc_date | udd_datetime1 | datetime(8) | Yes | This field is to capture the allocated date of the document. | No |
| pkslph_alloc_comments | udd_txt255 | varchar(255) | Yes | This field holds the allocation comments | No |
| pkslph_shtcls_comments | udd_txt255 | varchar(255) | Yes | This field holds the comments entered while shortclosing packslip | No |
| pkslph_transient_status | udd_designparamcode | varchar(5) | Yes | This field holds the transient status. which should not be Hold | No |
| pkslph_confirmed_by | udd_ctxt_user | varchar(30) | Yes | This field is to capture the user who confirmed the document | No |
| pkslph_confirmed_date | udd_datetime1 | datetime(8) | Yes | This field is to capture the confirmed date of the document | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| pkslprd_ou | udd_ctxt_ouinstance | int(4) | No | This field holds the customer to which packslip is created | Yes |
| pkslprd_no | udd_documentno | varchar(40) | No | This field holds unique packslip number for a packslip document | Yes |
| pkslprd_line_no | udd_seqno | int(4) | No | This field holds the line number for each record of the packslip document | Yes |
| pkslprd_cust_no | udd_customer_id | varchar(18) | Yes | This field holds the customer number against which packslip is created | No |
| pkslprd_Rowno | udd_numrevno | int(4) | No | Tis field holds the rowno of each record | Yes |
| pkslprd_cust_ou | udd_ctxt_ouinstance | int(4) | Yes | This field holds the OUinstance in which customer is created | No |
| pkslprd_ref_doc_type | udd_cmnrefdocs | varchar(10) | No | This field holds the ref doc type for the packslip. The possible values are 1 General 2 customer order | No |
| pkslprd_ref_doc_no | udd_refdocno | varchar(40) | No | This field holds the reference document number for packslip | No |
| pkslprd_file_name | udd_filename | varchar(50) | Yes | This field holds the filename for packslip | No |
| pkslprd_remarks | udd_remarks | varchar(255) | Yes | This field holds the remarks for each packslip | No |
| pkslprd_created_by | udd_ctxt_user | varchar(30) | No | This field is to capture the user who created the record | No |
| pkslprd_created_date | udd_datetime1 | datetime(8) | No | This field is to capture the created date of the record | No |
| pkslprd_modified_by | udd_ctxt_user | varchar(30) | No | This field is to capture the user who modified the record | No |
| pkslprd_modified_date | udd_datetime1 | datetime(8) | No | This field is to capture the modified date of the record . | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| pkslpsh_ou | udd_ctxt_ouinstance | int(4) | No | This is the ou instance in which Packslip is created | No |
| pkslpsh_no | udd_documentno | varchar(40) | No | This field holds unique packslip number for a packslip document | No |
| pkslpsh_status | udd_designparamcode | varchar(5) | Yes | This field holds the status of the packslip | No |
| pkslpsh_action_date | udd_datetime1 | datetime(8) | Yes | This field is to capture the action date of the document. | No |
| pkslpsh_action_by | udd_ctxt_user | varchar(30) | Yes | This field is to capture the action by of the document | No |
| pkslpsh_comments | udd_txt255 | varchar(255) | Yes | This field holds the packslip status history comments | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| pkslps_ou | udd_ctxt_ouinstance | int(4) | No | This is the ou instance in which Packslip is created | Yes |
| pkslps_no | udd_documentno | varchar(40) | No | This field holds unique packslip number for a packslip document | Yes |
| pkslps_line_no | udd_seqno | int(4) | No | This field holds the line number for each record of the packslip document | Yes |
| pkslps_rowno | udd_numrevno | int(4) | No | This field holds the line number for the storage detail records | Yes |
| pkslps_zone | udd_zone | varchar(10) | Yes | This field holds the details of the zone in which the parts are stored in storage area | No |
| pkslps_bin | udd_bin | varchar(10) | Yes | This field holds the details of the bin in which the parts are stored in storage area | No |
| pkslps_serial_no | udd_partserialnumber | varchar(40) | Yes | This field holds a unique serial number that identifies each quantity if the partcontol type is serialcontrolled or seriallot controlled | No |
| pkslps_lot_no | udd_lotno | varchar(18) | Yes | This field holds a unique lot number that identifies a group of quantity if the partcontol type is lot or seriallot controlled | No |
| pkslps_quantity | udd_quantity | numeric(13) | Yes | This field holds the quantity for each line item in the storage details | No |
| pkslps_remarks | udd_txt255 | varchar(255) | Yes | This field holds the remarks for each record in the storage details | No |
| pkslps_created_by | udd_ctxt_user | varchar(30) | No | This field is to capture the user who created the record | No |
| pkslps_created_date | udd_datetime1 | datetime(8) | No | This field is to capture the created date of the record | No |
| pkslps_modified_by | udd_ctxt_user | varchar(30) | No | This field is to capture the user who modified the record | No |
| pkslps_modified_date | udd_datetime1 | datetime(8) | No | This field is to capture the modified date of the record . | No | |
| Table Name : | pack_pkslps_storage_deall |
| Comment : | This table is used to store the storage deallocation details such as zone,bin,serialno,lotno and quanity for each line item |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| pkslps_ou | udd_ctxt_ouinstance | int(4) | No | This is the ou instance in which Packslip is created | No |
| pkslps_no | udd_documentno | varchar(40) | No | This field holds unique packslip number for a packslip document | No |
| pkslps_line_no | udd_seqno | int(4) | No | This field holds the line number for each record of the packslip document | No |
| pkslps_rowno | udd_numrevno | int(4) | No | This field holds the line number for the storage detail records | No |
| pkslps_zone | udd_zone | varchar(10) | Yes | This field holds the details of the zone in which the parts are stored in storage area | No |
| pkslps_bin | udd_bin | varchar(10) | Yes | This field holds the details of the bin in which the parts are stored in storage area | No |
| pkslps_serial_no | udd_partserialnumber | varchar(40) | Yes | This field holds a unique serial number that identifies each quantity if the partcontol type is serialcontrolled or seriallot controlled | No |
| pkslps_lot_no | udd_lotno | varchar(18) | Yes | This field holds a unique lot number that identifies a group of quantity if the partcontol type is lot or seriallot controlled | No |
| pkslps_quantity | udd_quantity | numeric(13) | Yes | This field holds the quantity for each line item in the storage details | No |
| pkslps_remarks | udd_txt255 | varchar(255) | Yes | This field holds the remarks for each record in the storage details | No |
| pkslps_created_by | udd_ctxt_user | varchar(30) | No | This field is to capture the user who created the record | No |
| pkslps_created_date | udd_datetime1 | datetime(8) | No | This field is to capture the created date of the record | No |
| pkslps_modified_by | udd_ctxt_user | varchar(30) | No | This field is to capture the user who modified the record | No |
| pkslps_modified_date | udd_datetime1 | datetime(8) | No | This field is to capture the modified date of the record . | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Unique Number | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| pksop_OUInstance | udd_ctxt_ouinstance | int(4) | No | This is the ou instance in which Packslip is created | Yes |
| pksop_on_confirm | udd_designparamcode | varchar(5) | No | This field holds the Subsequent action on confirmation. the following are the possible values B - Blank AA - Auto Allocation AI - Auto Issue AS - Auto Shipment | No |
| pksop_Auto_invoice | udd_designparamcode | varchar(5) | No | This field holds Auto Invoicing of Part Sale Pack Slip. the possible values NR - Not Required | No |
| pksop_Iss_numtype | udd_notypeno | varchar(5) | Yes | This field holds the numbering types for the issue created | No |
| pksop_Timestamp | udd_timestamp | int(4) | No | This field is to capture the timestamp of the record | No |
| pksop_Created_By | udd_ctxt_user | varchar(30) | No | This field is to capture the user who created the record | No |
| pksop_Created_Date | udd_datetime1 | datetime(8) | No | This field is to capture the created date of the record | No |
| pksop_Modified_By | udd_ctxt_user | varchar(30) | No | This field is to capture the user who modified the record | No |
| pksop_Modified_Date | udd_datetime1 | datetime(8) | No | This field is to capture the modified date of the record | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| PSFP_PS_OU | udd_ctxt_ouinstance | int(4) | No | This field holds the ouinstance of the packslip created | Yes |
| PSFP_PS_NO | udd_documentno | varchar(40) | No | this field holds the packslip number | Yes |
| PSFP_PS_Line_No | udd_seqno | int(4) | No | The field hlds the line number of each record | Yes |
| PSFP_PS_Type | udd_flag2 | varchar(25) | Yes | This field holds the packslip types defined in packslip document The possible values are 1 Customer Goods 2 customer Order 3 Part Sale | No |
| PSFP_PS_Part_Crt_Ou | udd_ctxt_ouinstance | int(4) | Yes | This field holds the part created ouinstance | No |
| PSFP_PS_Part_No | udd_partno | varchar(40) | Yes | this field holds the part number | No |
| PSFP_PS_AccType_Flag | udd_designparamcode | varchar(5) | Yes | This is a flag set for the account type | No |
| PSFP_PS_Acc_Usage | udd_usageid | varchar(20) | Yes | this field holds the account usage for the account types defined | No |
| PSFP_PS_Finance_Book | fin_financebookid | varchar(20) | Yes | This field holds the unique finance book id | No |
| PSFP_PS_Account_Code | fin_accountcode | varchar(32) | Yes | this field holds the account code of the account defined | No |
| PSFP_PS_Analysis_Code | fin_analysiscode | varchar(5) | Yes | This field holds the analysis code. | No |
| PSFP_PS_Sub_Analysis_Code | fin_subanalysiscode | varchar(5) | Yes | This field holds the subanalysis code. | No |
| PSFP_PS_CostCenter | udd_costcentercode | varchar(10) | Yes | This field holds the costcenter defined | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| qucd_qc_ou | udd_ctxt_ouinstance | int(4) | No | This field holds the ouinstance of the quickcode created | Yes |
| qucd_qc_code | udd_quickcodes | varchar(25) | No | This field holds the unique Quickcode | Yes |
| qucd_qc_type | udd_designparamcode | varchar(5) | No | This field holds the Quickcode tye of the quickcode created. the possible values are 1 Packslip category 2 user status | Yes |
| qucd_qc_desc | udd_txt80 | varchar(80) | No | This field holds the description of unique Quickcode | No |
| qucd_qc_status | udd_designparamcode | varchar(5) | No | This field holds the statusof unique Quickcode. the possible values are 1 active 2 inactive | No |
| qucd_timestamp | udd_timestamp | int(4) | No | This field is to capture the timestamp of the record | No |
| qucd_created_by | udd_ctxt_user | varchar(30) | No | This field is to capture the user who created the document | No |
| qucd_created_date | udd_datetime1 | datetime(8) | No | This field is to capture the created date of the document | No |
| qucd_modified_by | udd_ctxt_user | varchar(30) | No | This field is to capture the user who modified the document | No |
| qucd_modified_date | udd_datetime1 | datetime(8) | No | This field is to capture the modified date of the document | No |