|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ISUIH_ORG_UNIT | _decimal_10_0 | decimal(10) | No | OU where Stock Issue is carried out. | Yes |
| ISUIH_TRANSACTION_NO | _varchar_40 | varchar(40) | No | Stock Issue Number. | Yes |
| ISUIH_ISSUE_FLAG | _varchar_5 | varchar(5) | Yes | Issue Flag will indicate the activity thru which the Issue Document got created. | No |
| ISUIH_AUTOISU_FLAG | _varchar_5 | varchar(5) | Yes | Automatic Issue Creation Flag A - Automatic Issue Creation M - Manual Issue Creation. | No |
| ISUIH_WAREHOUSE_ORG_UNIT | _decimal_10_0 | decimal(10) | Yes | OU to which the warehouse belongs to.. | No |
| ISUIH_WAREHOUSE_ID | _varchar_10 | varchar(10) | Yes | The warehouse from where the parts must be issued. | No |
| ISUIH_ISSUE_TYPE | _varchar_5 | varchar(5) | Yes | Type of the Issue. | No |
| ISUIH_STATUS_CODE | _varchar_15 | varchar(15) | Yes | Status of the Issue Document. Can be either Draft or Fresh or Confirmed or Cancel | No |
| ISUIH_CATEGORY | _varchar_25 | Varchar(25) | Yes | The category to which the issue belongs. | No |
| ISUIH_USER_STATUS | _varchar_25 | Varchar(25) | Yes | The user status of the issue document. | No |
| ISUIH_TRANSACTION_DATE | _datetime_8 | datetime(8) | Yes | The date on which the issue document is created for issuing the parts. | No |
| ISUIH_REMARKS | _varchar_255 | varchar(255) | Yes | Any additional remark or comment pertaining to the issue document. | No |
| ISUIH_REF_DOC_TYPE | _varchar_25 | Varchar(25) | Yes | The type of the reference document. | No |
| ISUIH_RECEIVING_ORGUNIT | _decimal_10_0 | decimal(10) | Yes | OU corresponding to the receiving org. | No |
| ISUIH_REF_DOC_NO | _varchar_40 | varchar(40) | Yes | The number identifying the reference document. | No |
| ISUIH_USER_DEFINE1 | _varchar_25 | Varchar(25) | Yes | Any other additional details pertaining to the modification of spares issue | No |
| ISUIH_USER_DEFINE2 | _varchar_25 | Varchar(25) | Yes | USER DEFINE2 | No |
| ISUIH_FILE_NAME | _varchar_50 | varchar(50) | Yes | The name of the issue document file. | No |
| ISUIH_SHIPDTL_AVAILABLITY | _varchar_5 | varchar(5) | Yes | Shipping Details Availablity for the selected Issue No. NA - Not Applicable AV - Available NAV - Not Available | No |
| ISUIH_ACC_USAGE | _varchar_20 | varchar(20) | Yes | The type of the account used | No |
| ISUIH_CC_USAGE | _varchar_20 | varchar(20) | Yes | The type of the costing used | No |
| ISUIH_WF_DOC_KEY | _varchar_130 | varchar(130) | Yes | Document Key. | No |
| ISUIH_WF_NEW_STATE | _varchar_10 | varchar(10) | Yes | New State. | No |
| ISUIH_APPROVED_BY | _varchar_30 | varchar(30) | Yes | The name of the user who confirmed the issue document. | No |
| ISUIH_APPROVED_DATE | _datetime_8 | datetime(8) | Yes | The date on which the issue document was confirmed. | No |
| ISUIH_CREATED_BY | _varchar_30 | varchar(30) | Yes | The name of the user who created the issue document. | No |
| ISUIH_CREATED_DATE | _datetime_8 | datetime(8) | Yes | The date on which the issue document was created. | No |
| ISUIH_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | The name of the user who last modified the issue document. | No |
| ISUIH_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | The date on which the issue document was last modified. | No |
| ISUIH_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Number of times the Document has got modified.. | No |
| ISU_MMD_REF_DOC_OU | _decimal_10_0 | decimal(10) | Yes | reference doc ou. | No |
| ISU_MMD_REF_DOC_NO | _varchar_40 | varchar(40) | Yes | The number identifying the reference document.. | No |
| ISU_MMD_REF_DOC_LINE_NO | _decimal_10_0 | decimal(10) | Yes | reference doc line no. | No |
| ISU_MMD_REF_DOC_TYPE | _varchar_25 | Varchar(25) | Yes | The type of the reference document. . | No |
| ISUIH_TRADINGPARTNERNO | udd_vendorcode | varchar(45) | Yes | The code identifying the trading partner.. | No |
| ISUIH_TRADINGPARTNERTYPE | udd_flag2 | varchar(25) | Yes | The type of the trading partner, which could be "Supplier" or "Customer"... | No |
| ISUIH_ISSUE_TO | udd_ownership | varchar(40) | Yes | The number identifying the employee. . | No |
| ISUIH_TRADINGPARTNEROU | udd_ctxt_ouinstance | int(4) | Yes | Trading partner ou. | No |
| ISUIH_AirCraftNo | udd_aircraftnumber | varchar(30) | Yes | This field is used to capture AircraftReg No | No |
| ISUIH_WorkCenter | udd_wccode | varchar(30) | Yes | This field is used to capture WorkCenter No | No |
| ISUIH_DispNo | udd_refdocno | varchar(40) | Yes | This field is used to capture discrepency No | No |
| ISUIH_Station | oudescription | varchar(256) | Yes | This field captures station information | No |
| ISUIH_ISSUE_CLASS | udd_designparamcode | varchar(5) | Yes | ISSUE CLASS | No |
| ISUIH_ADL_REF_DOC_NO | udd_documentno | varchar(40) | Yes | REFERENCE DOCUMENT NO | No |
| ISUIH_ADL_REF_DOCTYPE | udd_flag | varchar(25) | Yes | REFERENCE DOCUMENT TYPE | No |
| ISUIH_PICKED_FLAG | udd_designparamcode | varchar(5) | Yes | Picked Flag | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ISUIS_ORG_UNIT | _decimal_10_0 | decimal(10) | No | OU where the Stock Issue is carried out | Yes |
| ISUIS_TRANSACTION_NO | _varchar_40 | varchar(40) | No | The number identifying the issue Lot number | Yes |
| ISUIS_PRT_SYSLINE_NO | _decimal_10_0 | decimal(10) | No | Serial Number of the Part in the Issue Document | Yes |
| ISUIS_SRL_SYSLINE_NO | _decimal_10_0 | decimal(10) | No | Unique Serial Number for Storage details | Yes |
| ISUIS_ZONE_ID | _varchar_10 | varchar(10) | Yes | The number identifying the zone in the warehouse from where the part is issued. | No |
| ISUIS_BIN_ID | _varchar_10 | varchar(10) | Yes | The number identifying the bin in the warehouse from where the part is issued. | No |
| ISUIS_LOT_NO | _varchar_18 | varchar(18) | Yes | The number identifying the lot to which the part belongs | No |
| ISUIS_SERIAL_NO | _varchar_40 | varchar(40) | Yes | The number identifying the serial number of the part that is issued. | No |
| ISUIS_PART_CONDITION | _varchar_25 | Varchar(25) | Yes | The condition of the spare that is being issued. The system displays one of the following options: 1.New -indicates that the part is new. 2.Overhauled - indicates that the part is overhauled. 3.Serviceable - indicates that the part is serviceable. 4. | No |
| ISUIS_ISS_QTY | _decimal_28_8 | decimal(28) | Yes | Quantity being issued in this transaction | No |
| ISUIS_ISS_QTY_INSTKUOM | _decimal_28_8 | decimal(28) | Yes | Quantity being issued in the Stock Uom | No |
| ISUIS_ISS_QTY_INREQUOM | _decimal_28_8 | decimal(28) | Yes | Quantity being issued in the Requested Uom. | No |
| ISUIS_ISS_COST | udd_amount | numeric(13) | Yes | Issue Cost at Zone-Bin level. | No |
| ISUIS_EXPIRY_DATE | _datetime_8 | datetime(8) | Yes | For Component type of parts, expired date will be copied from stock maint and stored here. Since expiry date cannot change for the component when it is in stock, de-normalizing and storing it here will save time in fetching.. | No |
| ISUIS_ISS_COMPUTED_COST | _decimal_28_8 | decimal(28) | Yes | computed cost | No |
| ISUIS_ISS_COMPUTED_DATE | _datetime_8 | datetime(8) | Yes | computed date | No |
| ISUIS_ISUATTACH_FLAG | udd_flag | varchar(25) | Yes | FLAG | No |
| ISUIS_ISUATCH_DOC_NO | udd_documentno | varchar(40) | Yes | DOCUMENT NO | No |
| ISUIS_ISUATCH_DOC_TYPE | udd_doctype | varchar(40) | Yes | DOCUMENT TYPE | No |
| ISUIS_ISUATCH_REFDOC_NO | udd_documentno | varchar(40) | Yes | REFDOCUMENT NO | No |
| ISUIS_ISUATCH_REFDOC_TYPE | udd_doctype | varchar(40) | Yes | REFDOCUMENT TYPE | No |
| ISUIS_CONFIRM_RCPTQTY_STKUOM | udd_quantity | numeric(13) | Yes | Confirmed Received Quantity | No |
| ISUIS_CONFIRM_LOSSQTY_STKUOM | udd_quantity | numeric(13) | Yes | Confirmed Loss Quantity | No |
| ISUIS_FRESH_RCPTQTY_STKUOM | udd_quantity | numeric(13) | Yes | Fresh Received Quantity | No |
| ISUIS_FRESH_LOSSQTY_STKUOM | udd_quantity | numeric(13) | Yes | Fresh Loss Quantity | No |
| ISUIS_SHIPPED_QTY | udd_quantity | numeric(13) | Yes | Shipped Quantity - Updated from shipping Note page for all type issues | No |
| ISUIS_SSC_DOCNO | udd_documentno | varchar(40) | Yes | This column is used to identify the document number. | No |
| ISUIS_ORIGINAL_LOTNO | udd_lotno | varchar(18) | Yes | This column is used to identify the Lot number. | No |
| ISUIS_ISS_TRDPARTNERTYPE | udd_flag2 | varchar(25) | Yes | This column is used to identify the Trading partner type. | No |
| ISUIS_ISS_TRDPARTNERNO | udd_vendorcode | varchar(45) | Yes | This column is used to identify the Trading partner number. | No |
| ISUIS_ISS_ORG_TRDPARTNERNO | udd_vendorcode | varchar(45) | Yes | Trading Partner Number | No |
| ISUIS_ISS_ORG_TRDPARTNERNO_OU | udd_ctxt_ouinstance | int(4) | Yes | Trading Partner ou | No |
| ISUIS_ISS_ORG_TRDPARTNERTYPE | udd_flag | varchar(25) | Yes | Trading Partner Type | No |
| ISUIS_ISS_TRDPARTNERNO_OU | udd_ctxt_ouinstance | int(4) | Yes | Trading Partner Ou | No |
| ISUIS_Currency | udd_currency | varchar(20) | Yes | Currency | No |
| ISUIS_PICKED_FLAG | udd_designparamcode | varchar(5) | Yes | Picked Flag | No |
| ISUIS_PICKED_QTY | udd_quantity | numeric(13) | Yes | Picked Quantity | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| ISU_DOC_OU | _numeric_28_0 | numeric(28) | Yes | DOCUMNET OUINSTANCE | No |
| ISU_DOC_NO | _varchar_40 | varchar(40) | Yes | DOCUMENT NO | No |
| ISU_LINE_NO | _numeric_28_0 | numeric(28) | Yes | LINE NO | No |
| ISU_PART_NO | _varchar_40 | varchar(40) | Yes | PART NO | No |
| ISU_PART_STATUS | _varchar_40 | varchar(40) | Yes | PART STATUS | No |
| RCPT_DOC_OU | _numeric_28_0 | numeric(28) | Yes | RECEIPT DOC_OU | No |
| RCPT_DOC_NO | _varchar_40 | varchar(40) | Yes | RECEIPT DOC_NO | No |
| RCPT_LINE_NO | _numeric_28_0 | numeric(28) | Yes | RECEIPT LINE_NO | No |
| RCPT_TYPE | _varchar_10 | varchar(10) | Yes | RECEIPT TYPE | No |
| RCPT_PART_NO | _varchar_40 | varchar(40) | Yes | RECEIPT PART_NO | No |
| RCPT_PART_STATUS | _varchar_40 | varchar(40) | Yes | RECEIPT PART_STATUS | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | REPLICATION_KEY ., | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| RECSHP_TRANSACTION_OU | _decimal_10_0 | decimal(10) | No | OU where Stock Issue is carried out. | Yes |
| RECSHP_TRANSACTION_NO | _varchar_40 | varchar(40) | No | The number identifying the issue. | Yes |
| RECSHP_RECV_POINT | _varchar_256 | varchar(256) | Yes | The destination organization unit of the transferred goods. | No |
| RECSHP_SHIP_BY | _varchar_25 | Varchar(25) | Yes | Indicates the method by which the part is shipped. | No |
| RECSHP_PACKAGE_CODE | _varchar_25 | Varchar(25) | Yes | The code identifying the package method of the part. | No |
| RECSHP_VEHICLEORFLT_NO | _varchar_20 | varchar(20) | Yes | The number identifying the vehicle that was used to transport the stock to the specific warehouse. | No |
| RECSHP_CARRIER | _varchar_150 | varchar(150) | Yes | The code identifying the carrier through which the stock is shipped. | No |
| RECSHP_FREIGHT_AMT | _decimal_28_8 | decimal(28) | Yes | The sum of freight charges that have been levied for movement of goods. | No |
| RECSHP_FREIGHT_TERM | _varchar_150 | varchar(150) | Yes | The term of the freight. | No |
| RECSHP_INSUR_LIABILITY | _varchar_5 | varchar(5) | Yes | Indicates who should bear the insurance amount, which could be any of the following: 1.Self - Indicates that the person who ships has to bear the insurance amount. 2.Third Party - Indicate that the insurance company or any other party bears the insu | No |
| RECSHP_INSUR_AMOUNT | _decimal_28_8 | decimal(28) | Yes | The sum of the insurance amount. | No |
| RECSHP_SHIP_NOTE_NO | _varchar_40 | varchar(40) | Yes | The number identifying the shipping note created for part shipment. | No |
| RECSHP_WAY_BILL_NO | _varchar_40 | varchar(40) | Yes | The number identifying the document, containing a list of goods with shipping instructions related to a shipment. | No |
| RECSHP_WAY_BILL_DATE | _datetime_8 | datetime(8) | Yes | The date on which the waybill was raised. | No |
| RECSHP_DELIVERY_NOTE_NO | _varchar_40 | varchar(40) | Yes | The number identifying the delivery note. | No |
| RECSHP_DELIVERY_NOTE_DATE | _datetime_8 | datetime(8) | Yes | The date on which the delivery note was raised. | No |
| RECSHP_PAYMENT_MTHD | _varchar_150 | varchar(150) | Yes | The mode in which the payment must be made. | No |
| RECSHP_SHIP_DATETIME | _datetime_8 | datetime(8) | Yes | The date on which the stock was shipped. | No |
| RECSHP_USER_DEF_DTL1 | _varchar_25 | Varchar(25) | Yes | Any other additional details pertaining to the shipping details. | No |
| RESSHP_USER_DEF_DTL2 | _varchar_25 | Varchar(25) | Yes | Any other additional details pertaining to the shipping details . | No |
| RECSHP_REMARKS | _varchar_255 | varchar(255) | Yes | Any other additional comment pertaining to the shipping details. | No |
| RECSHP_FILE_NAME | _varchar_50 | varchar(50) | Yes | The name of the issue document file. | No |
| RECSHP_CREATED_BY | udd_ctxt_user | varchar(30) | Yes | The name of the user who created the issue.. | No |
| RECSHP_CREATED_DATE | _datetime_8 | datetime(8) | Yes | Created Date | No |
| RECSHP_MODIFIED_BY | udd_ctxt_user | varchar(30) | Yes | The name of the user who last modified the issue.. | No |
| RECSHP_MODIFIED_DATE | _datetime_8 | datetime(8) | Yes | The date on which the issue was last modified.. | No |
| RECSHP_TIMESTAMPINT | _decimal_38_0 | decimal(38) | Yes | TimeStamp. | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Isu_Rec_Ship_CDtl_NoteNo | udd_documentno | varchar(40) | No | NoteNo | Yes |
| Isu_Rec_Ship_CDtl_OU | udd_ctxt_ouinstance | int(4) | No | OU | Yes |
| Isu_Rec_Ship_CDtl_ContainterNo | udd_documentno | varchar(40) | No | ContainterNo | Yes |
| Isu_Rec_Ship_CDtl_PackCode | udd_quickcodes | varchar(25) | Yes | PackCode | No |
| Isu_Rec_Ship_CDtl_PackDim | udd_txt20 | varchar(20) | Yes | PackDim | No |
| Isu_Rec_Ship_CDtl_PackUOM | udd_uom | varchar(15) | Yes | PackUOM | No |
| Isu_Rec_Ship_CDtl_GrossWgt | udd_quantity | numeric(13) | Yes | GrossWgt | No |
| Isu_Rec_Ship_CDtl_GrossUOM | udd_uom | varchar(15) | Yes | GrossUOM | No |
| Isu_Rec_Ship_CDtl_NetWgt | udd_quantity | numeric(13) | Yes | NetWgt | No |
| Isu_Rec_Ship_CDtl_NetUOM | udd_uom | varchar(15) | Yes | NetUOM | No |
| Isu_Rec_Ship_CDtl_HandlingTerms | udd_txt2000 | varchar(2000) | Yes | HandlingTerms | No |
| Isu_Rec_Ship_CDtl_PackByEmp | udd_ctxt_user | varchar(30) | Yes | PackByEmp | No |
| Isu_Rec_Ship_CDtl_CreatedDate | udd_datetime1 | datetime(8) | Yes | CreatedDate | No |
| Isu_Rec_Ship_CDtl_CreatedBy | udd_ctxt_user | varchar(30) | Yes | CreatedBy | No |
| Isu_Rec_Ship_CDtl_ModifiedDate | udd_datetime1 | datetime(8) | Yes | ModifiedDate | No |
| Isu_Rec_Ship_CDtl_ModifiedBy | udd_ctxt_user | varchar(30) | Yes | ModifiedBy | No |
| Isu_Rec_Ship_CDtl_TimeStamp | udd_timestamp | int(4) | Yes | TimeStamp | No |
| Isu_Rec_Ship_CDtl_length | udd_txt5 | varchar(5) | Yes | Length | No |
| Isu_Rec_Ship_CDtl_width | udd_txt5 | varchar(5) | Yes | Width | No |
| Isu_Rec_Ship_CDtl_height | udd_txt5 | varchar(5) | Yes | Height | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Isu_Rec_Ship_Dtl_OU | udd_ctxt_ouinstance | int(4) | Yes | shipping note OU Instance | No |
| Isu_Rec_Ship_Dtl_NoteNo | udd_documentno | varchar(40) | Yes | shipping note no | No |
| Isu_Rec_Ship_Dtl_LineNo | udd_seqno | int(4) | Yes | part Line no | No |
| Isu_Rec_Ship_Dtl_PartNo | udd_partno | varchar(40) | Yes | part no | No |
| Isu_Rec_Ship_Dtl_Quantity | udd_quantity | numeric(13) | Yes | Quantity | No |
| Isu_Rec_Ship_Dtl_UOM | udd_uom | varchar(15) | Yes | Unit of messarement | No |
| Isu_Rec_Ship_Dtl_SerialNo | udd_partserialnumber | varchar(40) | Yes | Serial No | No |
| Isu_Rec_Ship_Dtl_LotNo | udd_partserialnumber | varchar(40) | Yes | Lot Number | No |
| Isu_Rec_Ship_Dtl_UnitCost | udd_amount | numeric(13) | Yes | Part Unit cost | No |
| Isu_Rec_Ship_Dtl_Currency | udd_currency | varchar(20) | Yes | part Currency | No |
| Isu_Rec_Ship_Dtl_PackCode | udd_quickcodes | varchar(25) | Yes | package code | No |
| Isu_Rec_Ship_Dtl_PackDet | udd_txt255 | varchar(255) | Yes | Package details | No |
| Isu_Rec_Ship_Dtl_Remarks | udd_remarks | varchar(255) | Yes | Remarks | No |
| Isu_Rec_Ship_Dtl_RMANo | udd_documentno | varchar(40) | Yes | RMA No | No |
| Isu_Rec_Ship_Dtl_RMADate | udd_datetime1 | datetime(8) | Yes | RMA Date | No |
| Isu_Rec_Ship_Dtl_ShipBy | udd_quickcodes | varchar(25) | Yes | ship by code | No |
| Isu_Rec_Ship_Dtl_ShipAdv | udd_txt255 | varchar(255) | Yes | Shipping advice | No |
| Isu_Rec_Ship_Dtl_IssNo | udd_documentno | varchar(40) | Yes | Iss / GRS No | No |
| Isu_Rec_Ship_Dtl_IssDate | udd_datetime1 | datetime(8) | Yes | Iss / GRS date | No |
| Isu_Rec_Ship_Dtl_RefDocType | udd_type | varchar(25) | Yes | reference doucument type | No |
| Isu_Rec_Ship_Dtl_RefDocNo | udd_documentno | varchar(40) | Yes | reference document no | No |
| Isu_Rec_Ship_Dtl_SeqLineNo | udd_seqno | int(4) | Yes | part seq line no | No |
| Isu_Rec_Ship_Dtl_PartDesc | UDD_PartDesc | varchar(100) | Yes | part description | No |
| Isu_Rec_Ship_Reasforejec | udd_txt2000 | varchar(2000) | Yes | Reason for rejection | No |
| Isu_Rec_Ship_CustPONo | udd_documentno | varchar(40) | Yes | Customer PONo | No |
| Isu_Rec_Ship_ReferenceDocType | udd_documentno | varchar(40) | Yes | Reference Document Type | No |
| Isu_Rec_Ship_ContainerNo | udd_documentno | varchar(40) | Yes | Container Number | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | REPLICATION KEY | Yes |
| Isu_Rec_Ship_Dtl_cuspackcode | udd_documentno | varchar(40) | Yes | Customer Package Code | No |
| Isu_Rec_Ship_Dtl_cuspackID | udd_documentno | varchar(40) | Yes | Customer Package ID | No |
| Isu_Rec_Ship_Dtl_cuspackLoc | udd_documentno | varchar(40) | Yes | Customer Package Location | No |
| Isu_Rec_Ship_Dtl_cuspackcond | udd_documentno | varchar(40) | Yes | Customer Package Condition | No |
| Isu_Rec_Ship_Dtl_custpack | udd_designparamcode | varchar(5) | Yes | Customer Package | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| Isu_Rec_Ship_Note_OU | udd_ctxt_ouinstance | int(4) | No | OU Instance value. | Yes |
| Isu_Rec_Ship_Note_No | udd_documentno | varchar(40) | No | Record shipping Note Number | Yes |
| Isu_Rec_Ship_Num_Type | udd_quickcodes | varchar(25) | Yes | Numbering Type | No |
| Isu_Rec_Ship_Type | udd_quickcodes | varchar(25) | Yes | Shipping Note Type (direct, Issue based or GRS based) | No |
| Isu_Rec_Ship_Doc_Status | udd_status | varchar(25) | Yes | Document Level shipping status | No |
| Isu_Rec_Ship_Ship_Category | udd_quickcodes | varchar(25) | Yes | Shippment Category code | No |
| Isu_Rec_Ship_User_Status | udd_quickcodes | varchar(25) | Yes | shippment user status code | No |
| Isu_Rec_Ship_DateTime | udd_datetime1 | datetime(8) | Yes | shipping date | No |
| Isu_Rec_Ship_Time | udd_date | varchar(15) | Yes | shipping time | No |
| Isu_Rec_Ship_ShipContact | udd_contact | varchar(40) | Yes | shipping contact | No |
| Isu_Rec_Ship_ContactTele | udd_communicationid | varchar(70) | Yes | contact tele phone no | No |
| Isu_Rec_Ship_ContactFax | udd_fax | varchar(40) | Yes | contact fax no | No |
| Isu_Rec_Ship_ShipTo | udd_designparamcode | varchar(5) | Yes | Ship To (customer, supplier or warehouse) | No |
| Isu_Rec_Ship_ShipToCode | udd_vendorcode | varchar(45) | Yes | Ship to code (trading partner or warehouse code) | No |
| Isu_Rec_Ship_AddID | udd_address | varchar(40) | Yes | ship to , Address ID | No |
| Isu_Rec_Ship_Recipient | udd_txt150 | varchar(150) | Yes | receipient name | No |
| Isu_Rec_Ship_Address | udd_txt255 | varchar(255) | Yes | ship to address | No |
| Isu_Rec_Ship_City | udd_city | varchar(32) | Yes | ship to city | No |
| Isu_Rec_Ship_State | udd_state | varchar(32) | Yes | ship to state | No |
| Isu_Rec_Ship_Country | udd_country | varchar(40) | Yes | ship to country | No |
| Isu_Rec_Ship_Zipcode | fin_zip | varchar(20) | Yes | Ship To, Zip code | No |
| Isu_Rec_Ship_ShipBy | udd_quickcodes | varchar(25) | Yes | Ship BY code | No |
| Isu_Rec_Ship_CarrierCode | udd_quickcodes | varchar(25) | Yes | Carrier Code | No |
| Isu_Rec_Ship_VehicleNo | udd_documentno | varchar(40) | Yes | vehicle No | No |
| Isu_Rec_Ship_LandingNo | udd_documentno | varchar(40) | Yes | Landing No | No |
| Isu_Rec_Ship_WayBillNo | udd_documentno | varchar(40) | Yes | Way bill Number | No |
| Isu_Rec_Ship_WayBillDate | udd_datetime1 | datetime(8) | Yes | Way bill Date | No |
| Isu_Rec_Ship_PSNo | udd_documentno | varchar(40) | Yes | pack slip number | No |
| Isu_Rec_Ship_PSDate | udd_datetime1 | datetime(8) | Yes | pack slip date | No |
| Isu_Rec_Ship_ShipPay | udd_quickcodes | varchar(25) | Yes | shipping payment | No |
| Isu_Rec_Ship_Fright | udd_amount | numeric(13) | Yes | Fright amount | No |
| Isu_Rec_Ship_FrightCur | udd_currency | varchar(20) | Yes | Fright - currency | No |
| Isu_Rec_Ship_FrightTerms | udd_txt2000 | varchar(2000) | Yes | Fright Terms and conditions | No |
| Isu_Rec_Ship_NoOfPacks | udd_txt20 | varchar(20) | Yes | No of Packs | No |
| Isu_Rec_Ship_PackByEmp | udd_ctxt_user | varchar(30) | Yes | pack By employee | No |
| Isu_Rec_Ship_PackCode | udd_quickcodes | varchar(25) | Yes | package code | No |
| Isu_Rec_Ship_ContainerNo | udd_documentno | varchar(40) | Yes | Container Number | No |
| Isu_Rec_Ship_PackDim | udd_txt20 | varchar(20) | Yes | package dimention | No |
| Isu_Rec_Ship_PackUOM | udd_uom | varchar(15) | Yes | Package UOM | No |
| Isu_Rec_Ship_GrossWgt | udd_quantity | numeric(13) | Yes | Gross weight | No |
| Isu_Rec_Ship_GrossUOM | udd_uom | varchar(15) | Yes | Gross UOM | No |
| Isu_Rec_Ship_HandlingTerms | udd_txt2000 | varchar(2000) | Yes | handling terms and conditions | No |
| Isu_Rec_Ship_ContPer | udd_contactperson | varchar(80) | Yes | Contack person | No |
| Isu_Rec_Ship_ContFax | udd_fax | varchar(40) | Yes | contack fax no | No |
| Isu_Rec_Ship_ContTele | udd_communicationid | varchar(70) | Yes | contact telephone no | No |
| Isu_Rec_Ship_ContExtn | udd_fax | varchar(40) | Yes | cotact extn no | No |
| Isu_Rec_Ship_ContMobile | udd_fax | varchar(40) | Yes | contact mobile no | No |
| Isu_Rec_Ship_ContEmail | udd_email | varchar(60) | Yes | contact email ID | No |
| Isu_Rec_Ship_InsLiab | udd_designparamcode | varchar(5) | Yes | Insurence Liablity | No |
| Isu_Rec_Ship_InsAmount | udd_amount | numeric(13) | Yes | Insurence Amount | No |
| Isu_Rec_Ship_InsCur | udd_currency | varchar(20) | Yes | Insurence Currency | No |
| Isu_Rec_Ship_InsTerms | udd_txt2000 | varchar(2000) | Yes | insurence terms and conditions | No |
| Isu_Rec_Ship_FileName | udd_filename | varchar(50) | Yes | File name | No |
| Isu_Rec_Ship_Remarks | udd_remarks | varchar(255) | Yes | shipping remarks | No |
| Isu_Rec_Ship_CanCmts | udd_txt255 | varchar(255) | Yes | cancelation comments | No |
| Iss_Rec_Ship_TimeStamp | udd_timestamp | int(4) | Yes | time stamp | No |
| Isu_Rec_Ship_CreatedDate | udd_datetime1 | datetime(8) | Yes | created date | No |
| Isu_Rec_Ship_CreatedBy | udd_ctxt_user | varchar(30) | Yes | created by | No |
| Isu_Rec_Ship_ModifiedDate | udd_datetime1 | datetime(8) | Yes | shipping record last modified date | No |
| Isu_Rec_Ship_ModifiedBy | udd_ctxt_user | varchar(30) | Yes | shipping record last modified by | No |
| Isu_Rec_Ship_ConfirmedDate | udd_datetime1 | datetime(8) | Yes | shipping record confirmed date | No |
| Isu_Rec_Ship_ConfimedBy | udd_ctxt_user | varchar(30) | Yes | shipping record confirmed by | No |
| Isu_Rec_Ship_CustOrdNo | udd_documentno | varchar(40) | Yes | Customer Order No | No |
| Isu_Rec_Ship_CustPONo | udd_documentno | varchar(40) | Yes | Customer PONo | No |
| Isu_Rec_Ship_VehFlitdate | udd_date | varchar(15) | Yes | VehFlitdate | No |
| Isu_Rec_Ship_FrightBillable | udd_wfstatename | varchar(10) | Yes | FrightBillable | No |
| Isu_Rec_Ship_Incocode | udd_designparamcode | varchar(5) | Yes | Incocode | No |
| Isu_Rec_Ship_NetWgt | udd_quantity | numeric(13) | Yes | NetWgt | No |
| Isu_Rec_Ship_NetUOM | udd_uom | varchar(15) | Yes | NetUOM | No |
| Isu_Rec_Ship_dryice | udd_txt20 | varchar(20) | Yes | Dry Ice | No |
| Isu_Rec_Ship_alcohol | udd_designparamcode | varchar(5) | Yes | Alcohol | No |
| Isu_Rec_Ship_meterno | udd_desc40 | varchar(40) | Yes | Meter Number | No |
| Isu_Rec_Ship_sndrRcptAcntNO | udd_desc40 | varchar(40) | Yes | Shipping Account Code | No |
| Isu_Rec_Ship_Spclservice | udd_desc40 | varchar(40) | Yes | Special Service | No |
| Isu_Rec_Ship_otheraccount | udd_designparamcode | varchar(5) | Yes | Other Account | No |
| Isu_Rec_Ship_EmailNotftn | udd_seqno | int(4) | Yes | Email Notification | No |
| Isu_Rec_Ship_signReq | udd_seqno | int(4) | Yes | Signature Required | No |
| Isu_Rec_Ship_colctOnDel | udd_seqno | int(4) | Yes | Collecton Delivery | No |
| Isu_Rec_Ship_DropOfTyp | udd_desc40 | varchar(40) | Yes | Drop Of Type | No |
| Isu_Rec_Ship_SenderName | udd_txt20 | varchar(20) | Yes | Sender Name | No |
| Isu_Rec_Ship_ShipFromAddress | udd_txt20 | varchar(20) | Yes | Ship From Address | No |
| Isu_Rec_Ship_SenderCity | udd_city | varchar(32) | Yes | Sender City | No |
| Isu_Rec_Ship_SenderState | udd_state | varchar(32) | Yes | Sender State | No |
| Isu_Rec_Ship_SenderCountry | udd_country | varchar(40) | Yes | Sender Country | No |
| Isu_Rec_Ship_SenderZipCode | udd_zip | varchar(15) | Yes | Sender Zip Code | No |
| Isu_Rec_Ship_MobileNo | udd_communicationid | varchar(70) | Yes | Mobile No | No |
| Isu_Rec_Ship_Breadth | udd_txt5 | varchar(5) | Yes | Breadth | No |
| Isu_Rec_Ship_Height | udd_txt5 | varchar(5) | Yes | Height | No |
| Isu_Rec_Ship_Email | udd_email | varchar(60) | Yes | Email | No |
| Isu_Rec_Ship_warehouse | udd_warehouse | varchar(10) | Yes | Warehouse | No |
| Isu_Rec_Ship_Accountcode | udd_desc40 | varchar(40) | Yes | Account Code | No |
| Isu_Rec_Ship_Servicetype | udd_desc40 | varchar(40) | Yes | Service Type | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| TCDDTL_TRANSACTION_OU | _decimal_10_0 | decimal(10) | No | OU where Issue is carried out. | Yes |
| TCDDTL_TRANSACTION_NO | _varchar_40 | varchar(40) | No | Transaction No. | Yes |
| TCDDTL_PRT_SYSLINE_NO | _decimal_10_0 | decimal(10) | No | Serial Number of the Part in the Issue Document. | Yes |
| TCDDTL_TCDLINE_NO | _decimal_10_0 | decimal(10) | No | LINE NO | Yes |
| TCDDTL_TCD_OU | _decimal_10_0 | decimal(10) | No | TCD No Created Ou. | No |
| TCDDTL_TCD_CODE | _varchar_25 | Varchar(25) | Yes | TCD Code from TCD Component. | No |
| TCDDTL_TCD_VARIANT | _varchar_25 | Varchar(25) | Yes | TCD Variant for the selected TCD Code. | No |
| TCDDTL_TCD_RATE | _decimal_28_8 | decimal(28) | Yes | TCD Rate. | No |
| TCDDTL_TCD_AMOUNT | _decimal_28_8 | decimal(28) | Yes | TCD Amount :- Sum of all the TCD Rate for the document | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| UPIDTL_TRANSACTION_OU | _decimal_10_0 | decimal(10) | No | OU where Stock Issue is carried out. | Yes |
| UPIDTL_TRANSACTION_NO | _varchar_40 | varchar(40) | No | Stock Issue Number. | Yes |
| UPIDTL_SYSLINE_NO | _decimal_10_0 | decimal(10) | No | Line Number. | Yes |
| UPIDTL_DISPLAYLINE_NO | _decimal_10_0 | decimal(10) | No | Display Line Number.. | No |
| UPIDTL_ISS_PART_PLN_OU | _decimal_10_0 | decimal(10) | No | Issue Part Planning OUInstance. | No |
| UPIDTL_ISS_PART_CRT_OU | _decimal_10_0 | decimal(10) | No | Issue Part Created OUInstance. | No |
| UPIDTL_ISS_PART_NO | _varchar_40 | varchar(40) | Yes | The part number to be issued. | No |
| UPIDTL_ISU_QTY | _decimal_28_8 | decimal(28) | Yes | The number of parts to be issued. | No |
| UPIDTL_ISU_UOM | _varchar_10 | varchar(10) | Yes | Issue Transaction UOM. | No |
| UPIDTL_ISU_QTY_INSTKUOM | _decimal_28_8 | decimal(28) | Yes | Issue Quantity inStock Uom. | No |
| UPIDTL_PART_STATUS | _varchar_40 | varchar(40) | Yes | Part Status for issue part. it is udds value defined in the udds component. | No |
| UPIDTL_ISSUE_COST | _decimal_28_8 | decimal(28) | Yes | This column maintains the value for the Part being issued.. | No |
| UPIDTL_ACC_USAGE | _varchar_20 | varchar(20) | Yes | Accounting Usage. | No |
| UPIDTL_FINANCE_BOOK | _varchar_20 | varchar(20) | Yes | Finance Book. | No |
| UPIDTL_ACC_CODE | _varchar_32 | varchar(32) | Yes | The type of the account used. | No |
| UPIDTL_ANLY_CODE | _varchar_5 | varchar(5) | Yes | Analysis Code. | No |
| UPIDTL_SUBANLY_CODE | _varchar_5 | varchar(5) | Yes | Sub Analysis Code. | No |
| UPIDTL_CC_USAGE | _varchar_20 | varchar(20) | Yes | The type of the costing used | No |
| UPIDTL_COSTCENTER_CODE | _varchar_10 | varchar(10) | Yes | Cost Center Code. | No |
| UPIDTL_EXP_RTN_DATE | _datetime_8 | datetime(8) | Yes | The date on which the part must be returned. | No |
| UPIDTL_REMARKS | _varchar_255 | varchar(255) | Yes | Any other additional comment pertaining to the modification of spares issue | No |
| UPIDTL_ADL_DTL_EXISTS_FLAG | _varchar_5 | varchar(5) | Yes | This flag indicates the existence of records in the storage detail table. | No |
| UPIDTL_COMPUTED_COST | _decimal_28_8 | decimal(28) | Yes | ISSUE COST | No |
| UPIDTL_COMPUTED_DATE | _datetime_8 | datetime(8) | Yes | date on which issued part rate calculated | No |
| UPIDTL_SHIPPED_QTY | udd_quantity | numeric(13) | Yes | Shipped Quantity - Updated from shipping Note page for Unplanned Issue | No |
| UPIDTL_ADL_REFDOC_LINENO | udd_seqno | int(4) | Yes | REFerence DOCument LINENO | No |
| UPIDTL_CNTRLTYPE | udd_flag | varchar(25) | Yes | Part Control Type | No |
| UPIDTL_EXPENSETYPE | udd_flag | varchar(25) | Yes | Part Expense Type | No |
| UPIDTL_EXPENSING_POLICY | udd_designparamcode | varchar(5) | Yes | Part Expensing Policy | No |
| UPIDTL_ISSUEBASIS | udd_designparamcode | varchar(5) | Yes | Issue Basis | No |
| UPIDTL_NONSTOCKABLE_FLAG | udd_flag | varchar(25) | Yes | To check Part is Out of Stock | No |
| UPIDTL_ORIGINAL_PART_STATUS | udd_partstatus | varchar(40) | Yes | Original Part Status | No |
| UPIDTL_PARTTYPE | udd_parttype | varchar(25) | Yes | part Type | No |
| UPIDTL_VALUATION_METHOD | udd_designparamcode | varchar(5) | Yes | Part Valuation Method | No |
| UPIDTL_PART_ACC_GRP | udd_customeraccountgroup | varchar(20) | Yes | Part Account Grouping | No |
| created_area_code | _varchar_40 | varchar(40) | Yes | created area code | No |
| UPIDTL_ADJ_ACTUALCOST | udd_flag | varchar(25) | Yes | Actual cost | No |
| UPIDTL_Currency | udd_currency | varchar(20) | Yes | currency | No |
| UPIDTL_PART_LOTNOTYPE | udd_flag | varchar(25) | Yes | part Lot number type | No |
| UPIDTL_PART_SLNOLOGIC | udd_flag | varchar(25) | Yes | part serial logic | No |
| UPIDTL_PART_SLNOTYPE | udd_flag | varchar(25) | Yes | part serial number type | No |
| UPIDTL_PICKED_FLAG | udd_desc40 | varchar(40) | Yes | Picked Flag | No |
| UPIDTL_PICKED_QTY | udd_quantity | numeric(13) | Yes | Picked Quantity | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |