Pack Slip

Table Name pack_parameter_details

Table Comment To store the parameter details of packslip

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

ComponentName

varchar(20)

NOT NULL

This field holds the Name of the component.

ParamCategory

varchar(10)

NOT NULL

This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc.

ParamType

varchar(25)

NOT NULL

Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows.

ParamCode

varchar(5)

NOT NULL

This is the code that may be used for data storage. This is valid only incase of combo boxes. Here the short code that will be stored as data in the transaction could be maintained.

Langid

int

NOT NULL

Language id. This is the language id of the record.

ParamDesc

varchar(254)

NOT NULL

Param description is the values to be filled in the combo box or guidance text. This is actually the meta data of this component

Sortby

int

NOT NULL

This field holds the default sort by code

CreationDate

datetime

NOT NULL

This field holds the record created date for auditing purpose.

Table Name pack_pkslpa_address

Table Comment To store the address details of packslip

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

pkslpa_ou

int

NOT NULL

This is the ouinstance of the packslip

pkslpa_no

varchar(40)

NOT NULL

This field holds the packslip number

pkslpa_cust_no

varchar(18)

NULL

This field holds the customer number

pkslpa_cust_ou

int

NULL

This field holds the ouinstance of the customer

pkslpa_bill_to_cust_no

varchar(18)

NULL

This field holds the Bill to customer number

pkslpa_bill_to_cust_ou

int

NULL

This field holds the Bill to customer number ouintance

pkslpa_address_no

varchar(40)

NULL

This field holds the address id

pkslpa_address

varchar(2000)

NULL

This field holds the address of the customer

pkslpa_cnt_person

varchar(80)

NULL

This field holds the contact person name

pkslpa_phone

varchar(70)

NULL

This field holds the contact person Phone number

pkslpa_email

varchar(70)

NULL

This field holds the contact person Email Id

pkslpa_fax

varchar(70)

NULL

This field holds the contact person Fax number

pkslpa_created_by

varchar(30)

NOT NULL

This field is to capture the user who created the document

pkslpa_created_date

datetime

NOT NULL

This field is to capture the created date of the document

pkslpa_modified_by

varchar(30)

NOT NULL

This field is to capture the user who modified the document

pkslpa_modified_date

datetime

NOT NULL

This field is to capture the modified date of the document.

Table Name pack_pkslpc_cert

Table Comment To store the certificate details of packslip

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

pkslpc_ou

int

NOT NULL

This is the ou instance in which Packslip is created

pkslpc_no

varchar(40)

NOT NULL

This field holds unique packslip number for a packslip document

pkslpc_line_no

int

NOT NULL

This field holds the line number for each record of the packslip document

pkslpc_cert_no

varchar(40)

NOT NULL

This field holds the packslip certificate number

pkslpc_cust_no

varchar(18)

NULL

This field holds the customer number for which certificate details are created

pkslpc_cust_ou

int

NULL

This field holds the customer ouinstance for which certificate details are created

pkslpc_cert_type

varchar(25)

NULL

This field holds the packslip certificate type

pkslpc_issued_by

varchar(20)

NULL

This field is to capture issued by

pkslpc_issuer_name

varchar(77)

NULL

This field holds the name of the person who issued the document

pkslpc_comments

varchar(255)

NULL

this field holds the comments added

pkslpc_file_name

varchar(50)

NULL

This field holds the filename for the document

pkslpc_created_by

varchar(30)

NOT NULL

This field is to capture the user who created the document

pkslpc_created_date

datetime

NOT NULL

This field is to capture the created date of the document

pkslpc_modified_by

varchar(30)

NOT NULL

This field is to capture the user who modified the document

pkslpc_modified_date

datetime

NOT NULL

This field is to capture the modified date of the document

Table Name pack_pkslpd_det

Table Comment To store the packslip details

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

pkslpd_ou

int

NOT NULL

This is the ou instance in which Packslip is created

pkslpd_no

varchar(40)

NOT NULL

This field holds unique packslip number for a packslip document

pkslpd_line_no

int

NOT NULL

This field holds the line number for each record of the packslip document

pkslpd_part_no

varchar(40)

NULL

This field holds the part numbers for which packslip is created

pkslpd_cust_part

varchar(40)

NULL

This field holds the customer part numbers for which packslip is created

pkslpd_condn

varchar(5)

NULL

This field holds the condition of the part. The possible values are ’N’ - NEW ’O’ - OverHauled ’S’ - Serviceable ’U’ - Unserviceable ’PO’ - PhaseOut

pkslpd_stk_status

varchar(40)

NULL

This field holds the stock status for the part. The possible values are Customer Civil Customer Military Internal Civil Internal Military

pkslpd_warehouse

varchar(10)

NOT NULL

This field holds the warehouse in which the parts are stored for which the packslip is created

pkslpd_uom

varchar(10)

NULL

This field hold the Unit of Measurement for calculating the quantity

pkslpd_qty

numeric(28,8)

NOT NULL

This field holds the quantity for each part for which packslip is created

pkslpd_alloc_qty

numeric(28,8)

NOT NULL

This field holds the quantity allocated

pkslpd_issue_qty

numeric(28,8)

NOT NULL

This field holds the quantity issued

pkslpd_ship_qty

numeric(28,8)

NOT NULL

This field holds the quantity shipped

pkslpd_pick_strgy

varchar(5)

NULL

This field holds the picking strategy for the parts. The possible values are ’MNL’- Manual ’AM’ - Automatic

pkslpd_pkslip_for

varchar(5)

NULL

This field holds the type of parts for which packslip is created If Customer Goods Packslip and Customer Order base packslip. The possible values are 1) Main component 2) Core Returns 3) Excess Returns If Part Sale packslip.The possible value is 1) Part sale

pkslpd_Finance_Book

varchar(20)

NULL

This field holds the finance book id

pkslpd_COGS_No

varchar(32)

NULL

This field holds the cogs number for which packslip is created

pkslpd_created_by

varchar(30)

NOT NULL

This field is to capture the user who created the record

pkslpd_created_date

datetime

NOT NULL

This field is to capture the created date of the record

pkslpd_modified_by

varchar(30)

NOT NULL

This field is to capture the user who modified the record

pkslpd_modified_date

datetime

NOT NULL

This field is to capture the modified date of the record

pkslpd_invoice_qty

numeric(28,8)

NULL

This field holds the quantity for which invoice is created

pkslpd_invoice_no

varchar(40)

NULL

This field holds the invoice number

pkslpd_invoice_ou

int

NULL

This is the ouinstance in which invoice is created

Table Name pack_pkslph_hdr

Table Comment To store the main information of packslip

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

pkslph_no

varchar(40)

NOT NULL

This field holds unique packslip number for a packslip document

pkslph_ou

int

NOT NULL

This is the ou instance in which Packslip is created

pkslph_num_type

varchar(5)

NOT NULL

Numbering type for the packslip number generation

pkslph_status

varchar(5)

NOT NULL

This field holds the status of the packslip. The possible values are 1) Fresh 2) Confirmed 3) Allocated 4) Issued 5) Shipped

pkslph_category

varchar(25)

NULL

This field holds the category of packslip. The possible values are 1) Customer 2) Internal

pkslph_type

varchar(25)

NOT NULL

This field holds the type of Packlsip. The possible values are 1) Customer Goods 2) customer Order 3) Part Sale

pkslph_user_status

varchar(40)

NULL

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

pkslph_date

datetime

NOT NULL

This field holds the date on which packslip is created

pkslph_inv_appl

varchar(5)

NOT NULL

This field holds whether invoice applicable is Yes or No

pkslph_ship_date

datetime

NULL

This field holds the date on which shipment is made.

pkslph_ship_time

datetime

NULL

This field holds the date in which shipment is made.

pkslph_cust_no

varchar(18)

NOT NULL

This field holds the customer to which packslip is created

pkslph_cust_ou

int

NOT NULL

This field holds the OUinstance in which customer is created

pkslph_ref_doc_type

varchar(40)

NULL

This field holds the ref doc type for the packslip. The possible values are 1)General 2) customer order

pkslph_order_point

int

NULL

This field holds the Ouinstance in which Packslip is created

pkslph_ref_doc_no

varchar(40)

NULL

This field holds the reference document number for packslip

pkslph_ref_doc_amd_no

int

NULL

This field holds the reference document amendment number

pkslph_ref_doc_date

datetime

NULL

This field holds the date on which reference document was created

pkslph_other_ref

varchar(40)

NULL

Other reference values

pkslph_ship_to_cust_no

varchar(18)

NULL

This field holds the customer to which parts are shipped

pkslph_ship_to_cust_ou

int

NULL

This field holds the ouinstance of the customer to which parts are shipped

pkslph_address_no

varchar(40)

NULL

This field holds the address id of the customer

pkslph_address

varchar(2000)

NULL

This field holds the address of the customer

pkslph_cnt_person

varchar(80)

NULL

This field holds the name of the contact person

pkslph_phone

varchar(70)

NULL

This field holds the phone number of the contact person

pkslph_email

varchar(60)

NULL

This field holds the Email of the contact person

pkslph_fax

varchar(40)

NULL

This field holds the Fax of the contact person

pkslph_del_area

varchar(18)

NULL

This field holds the delivery area

pkslph_ship_type

varchar(255)

NULL

This field holds the shipment type

pkslph_carrier

varchar(20)

NULL

this field holds the carrier code of packslip

pkslph_trans_mode

varchar(255)

NULL

This field holds the transportation mode

pkslph_vehicle_no

varchar(20)

NULL

This field holds the vehicle number of packslip

pkslph_frt_billable

varchar(5)

NULL

This field holds the freight billable applicability. The possible values are 1) Yes 2) NO

pkslph_frt_amount

numeric(28,8)

NULL

This field holds the freight billable amount

pkslph_frt_currency

varchar(20)

NULL

This field holds the freight currency

pkslph_port_of_dest

varchar(32)

NULL

this field holds the port of destination

pkslph_frt_terms

varchar(255)

NULL

This field holds the freight terms

pkslph_way_bill_no

varchar(40)

NULL

this field holds the waybill number

pkslph_pro_no

varchar(40)

NULL

This field holds the Pro No

pkslph_awb_no

varchar(40)

NULL

This field holds the AWB No

pkslph_bol_no

varchar(40)

NULL

This field holds the Bol No

pkslph_inco_term

varchar(40)

NULL

this field holds the Inco Term

pkslph_tracking_no

varchar(20)

NULL

This field holds the tracking number

pkslph_ins_liability

varchar(5)

NULL

This field holds the insurance liability

pkslph_ins_terms

varchar(150)

NULL

This field holds the insurance terms

pkslph_pack_cores

varchar(25)

NULL

This field holds the packaging code for the cores

pkslph_pack_spares

varchar(25)

NULL

This field holds the packaging code for the spares

pkslph_pack_service

varchar(25)

NULL

This field holds the packaging code for the serviceable components

pkslph_hazard_product

varchar(5)

NULL

This field holds whether the products specified is hazardous or not. the possible values are 1) yes 2) No

pkslph_ship_label

varchar(40)

NULL

This field holds the shipping label

pkslph_comments

varchar(255)

NULL

This field holds the packslip comments

pkslph_filename

varchar(50)

NULL

This field holds the filename for packslip

pkslph_timestamp

int

NOT NULL

This field is to capture the timestamp of the record

pkslph_created_by

varchar(30)

NOT NULL

This field is to capture the user who created the document

pkslph_created_date

datetime

NOT NULL

This field is to capture the created date of the document

pkslph_issue_by

varchar(30)

NULL

This field is to capture the user who issued the parts

pkslph_modified_by

varchar(30)

NOT NULL

This field is to capture the user who modified the document

pkslph_modified_date

datetime

NOT NULL

This field is to capture the modified date of the document

pkslph_issue_date

datetime

NULL

This field is to capture the issued date of the document

pkslph_issue_comments

varchar(255)

NULL

This field holds the issue comments

pkslph_ship_by

varchar(30)

NULL

This field is to capture the user who Shipped the parts

pkslph_ship_comments

varchar(255)

NULL

This field holds the shipping comments

pkslph_alloc_by

varchar(30)

NULL

This field is to capture the user who allocated the parts

pkslph_alloc_date

datetime

NULL

This field is to capture the allocated date of the document.

pkslph_alloc_comments

varchar(255)

NULL

This field holds the allocation comments

pkslph_shtcls_comments

varchar(255)

NULL

This field holds the comments entered while shortclosing packslip

pkslph_transient_status

varchar(5)

NULL

This field holds the transient status. which should not be ’Hold’

pkslph_confirmed_by

varchar(30)

NULL

This field is to capture the user who confirmed the document

pkslph_confirmed_date

datetime

NULL

This field is to capture the confirmed date of the document

Table Name pack_pkslprd_ref_det

Table Comment To store the reference details of packslip

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

pkslprd_remarks

varchar(255)

NULL

This field holds the remarks for each packslip

pkslprd_file_name

varchar(50)

This field holds the filename for packslip

pkslprd_ref_doc_no

varchar(40)

NOT NULL

This field holds the reference document number for packslip

pkslprd_modified_by

varchar(30)

NOT NULL

This field is to capture the user who modified the record

pkslprd_created_by

varchar(30)

NOT NULL

This field is to capture the user who created the record

pkslprd_created_date

datetime

NOT NULL

This field is to capture the created date of the record

pkslprd_modified_date

datetime

NOT NULL

This field is to capture the modified date of the record .

pkslprd_no

varchar(40)

NOT NULL

This field holds unique packslip number for a packslip document

pkslprd_line_no

int

NOT NULL

This field holds the line number for each record of the packslip document

pkslprd_ou

int

NOT NULL

This field holds the customer to which packslip is created

pkslprd_ref_doc_type

varchar(10)

NOT NULL

This field holds the ref doc type for the packslip. The possible values are 1)General 2) customer order

pkslprd_cust_ou

int

NULL

This field holds the OUinstance in which customer is created

pkslprd_Rowno

int

NOT NULL

Tis field holds the rowno of each record

pkslprd_cust_no

varchar(18)

NULL

This field holds the customer number against which packslip is created

Table Name pack_pkslps_storage

Table Comment To store the storage details of packslip

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

pkslps_remarks

varchar(255)

NULL

This field holds the remarks for each record in the storage details

pkslps_quantity

decimal(28,8)

NULL

This field holds the quantity for each line item in the storage details

pkslps_lot_no

varchar(18)

NULL

This field holds a unique lot number that identifies a group of quantity if the partcontrol type is lot or serial lot controlled

pkslps_modified_by

varchar(30)

NOT NULL

This field is to capture the user who modified the record

pkslps_created_by

varchar(30)

NOT NULL

This field is to capture the user who created the record

pkslps_created_date

datetime

NOT NULL

This field is to capture the created date of the record

pkslps_modified_date

datetime

NOT NULL

This field is to capture the modified date of the record .

pkslps_no

varchar(40)

NOT NULL

This field holds unique packslip number for a packslip document

pkslps_line_no

int

NOT NULL

This field holds the line number for each record of the packslip document

pkslps_ou

int

NOT NULL

This is the ou instance in which Packslip is created

pkslps_serial_no

varchar(40)

NULL

This field holds a unique serial number that identifies each quantity if the partcontrol type is serial controlled or serial lot controlled

pkslps_bin

varchar(10)

NULL

This field holds the details of the bin in which the parts are stored in storage area

pkslps_rowno

int

NOT NULL

This field holds the line number for the storage detail records

pkslps_zone

varchar(10)

NULL

This field holds the details of the zone in which the parts are stored in storage area

Table Name pack_pkslps_storage_deall

Table Comment This table is used to store the storage deallocation details such as zone,bin,serialno,lotno and quantity for each line item

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

pkslps_ou

int

NOT NULL

This is the ou instance in which Packslip is created

pkslps_no

varchar(40)

NOT NULL

This field holds unique packslip number for a packslip document

pkslps_line_no

int

NOT NULL

This field holds the line number for each record of the packslip document

pkslps_rowno

int

NOT NULL

This field holds the line number for the storage detail records

pkslps_zone

varchar(10)

NULL

This field holds the details of the zone in which the parts are stored in storage area

pkslps_bin

varchar(10)

NULL

This field holds the details of the bin in which the parts are stored in storage area

pkslps_serial_no

varchar(40)

NULL

This field holds a unique serial number that identifies each quantity if the partcontrol type is serial controlled or serial lot controlled

pkslps_lot_no

varchar(18)

NULL

This field holds a unique lot number that identifies a group of quantity if the partcontrol type is lot or serial lot controlled

pkslps_quantity

numeric(28,8)

NULL

This field holds the quantity for each line item in the storage details

pkslps_remarks

varchar(255)

NULL

This field holds the remarks for each record in the storage details

pkslps_created_by

varchar(30)

NOT NULL

This field is to capture the user who created the record

pkslps_created_date

datetime

NOT NULL

This field is to capture the created date of the record

pkslps_modified_by

varchar(30)

NOT NULL

This field is to capture the user who modified the record

pkslps_modified_date

datetime

NOT NULL

This field is to capture the modified date of the record .

Table Name pack_pkslpsh_status_history

Table Comment To store the status history details of packslip

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

pkslpsh_ou

int

NOT NULL

This is the ou instance in which Packslip is created

pkslpsh_no

varchar(40)

NOT NULL

This field holds unique packslip number for a packslip document

pkslpsh_status

varchar(5)

NULL

This field holds the status of the packslip

pkslpsh_action_date

datetime

NULL

This field is to capture the action date of the document.

pkslpsh_action_by

varchar(30)

NULL

This field is to capture the action by of the document

pkslpsh_comments

varchar(255)

NULL

This field holds the packslip status history comments

Table Name pack_pksop_options

Table Comment To store the set options of packslip

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

pksop_OUInstance

int

NOT NULL

This is the ou instance in which Packslip is created

pksop_on_confirm

varchar(5)

NOT NULL

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

pksop_Auto_invoice

varchar(5)

NOT NULL

This field holds Auto Invoicing of Part Sale Pack Slip. the possible values ’NR’ - Not Required

pksop_Timestamp

int

NOT NULL

This field is to capture the timestamp of the record

pksop_Created_By

varchar(30)

NOT NULL

This field is to capture the user who created the record

pksop_Created_Date

datetime

NOT NULL

This field is to capture the created date of the record

pksop_Modified_By

varchar(30)

NOT NULL

This field is to capture the user who modified the record

pksop_Modified_Date

datetime

NOT NULL

This field is to capture the modified date of the record

pksop_Iss_numtype

varchar(5)

NULL

This field holds the numbering types for the issue created

Table Name pack_psfp_Finance_Post_Dtl

Table Comment To store the finance details of packslip

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

PSFP_PS_Finance_Book

varchar

NULL

This field holds the unique finance book id

PSFP_PS_Acc_Usage

varchar()

NULL

this field holds the account usage for the account types defined

PSFP_PS_AccType_Flag

varchar()

NULL

This is a flag set for the account type

PSFP_PS_Sub_Analysis_Code

varchar(5)

NULL

This field holds the subanalysis code.

PSFP_PS_Account_Code

varchar(32)

NULL

this field holds the account code of the account defined

PSFP_PS_Analysis_Code

varchar(5)

NULL

This field holds the analysis code.

PSFP_PS_CostCenter

varchar(10)

NULL

This field holds the costcenter defined

PSFP_PS_NO

varchar(40)

NOT NULL

this field holds the packslip number

PSFP_PS_Line_No

int

NOT NULL

The field hlds the line number of each record

PSFP_PS_OU

int

NOT NULL

This field holds the ouinstance of the packslip created

PSFP_PS_Part_No

varchar(40)

NULL

this field holds the part number

PSFP_PS_Part_Crt_Ou

int

NULL

This field holds the part created ouinstance

pkslpc_cert_no

varchar(40)

NOT NULL

This field holds the certificate number of the packslip

PSFP_PS_Type

varchar()

NULL

This field holds the packslip types defined in packslip document The possible values are 1) Customer Goods 2) customer Order 3) Part Sale

Table Name pack_qucd_quick_codes

Table Comment To store the quick codes of packslip

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

qucd_qc_ou

int

NOT NULL

This field holds the ouinstance of the quickcode created

qucd_qc_type

varchar(5)

NOT NULL

This field holds the Quickcode tye of the quickcode created. the possible values are 1) Packslip category 2) user status

qucd_qc_code

varchar(25)

NOT NULL

This field holds the unique Quickcode

qucd_qc_desc

varchar(80)

NOT NULL

This field holds the description of unique Quickcode

qucd_qc_status

varchar(5)

NOT NULL

This field holds the status of unique Quickcode. the possible values are 1) active 2) inactive

qucd_timestamp

int

NOT NULL

This field is to capture the timestamp of the record

qucd_created_by

varchar(30)

NOT NULL

This field is to capture the user who created the document

qucd_created_date

datetime

NOT NULL

This field is to capture the created date of the document

qucd_modified_by

varchar(30)

NOT NULL

This field is to capture the user who modified the document

qucd_modified_date

datetime

NOT NULL

This field is to capture the modified date of the document