|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| STRECDT_OUINSTANCE_ID | _decimal_10_0 | decimal(10) | No | OU Instance ID where the Stock Transfer Receipt is received | Yes |
| STRECDT_RECEIPT_NO | _varchar_40 | varchar(40) | No | System generated Receipt No for receiving the parts which are part of the Stock Transfer Document | Yes |
| STRECDT_PRT_SYSLINE_NO | _decimal_10_0 | decimal(10) | No | Receipt Line Number for the parts listed in the Stock Transfer Doc. This will be same as the Stock Tranfer Issue Doc line No as for one stock tranfer issue, there could be only one stock tranfer receipt document | Yes |
| STRECDT_PRT_DISPLAYLINE_NO | _decimal_10_0 | decimal(10) | Yes | Part Display Line Number | No |
| STRECDT_PART_CRT_OU | _decimal_10_0 | decimal(10) | Yes | Created OU Id of the stock tranferred Part | No |
| STRECDT_PART_PLN_OU | _decimal_10_0 | decimal(10) | Yes | Planning OU Id of the stock tranferred Part | No |
| STRECDT_PART_NO | _varchar_40 | varchar(40) | Yes | Received Part No | No |
| STRECDT_PART_STATUS | _varchar_40 | varchar(40) | Yes | Status in which the part is received | No |
| STRECDT_RCPT_QTY_INSTKUOM | _decimal_28_8 | decimal(28) | Yes | Receipt Quantity In Stock UOM | No |
| STRECDT_REMARKS | _varchar_255 | varchar(255) | Yes | Stock Transfer Receipt remarks (if any) for the part | No |
| STRECDT_ISS_LINE_NO | _decimal_10_0 | decimal(10) | Yes | Issue Line number | No |
| STRECDT_RECEIPT_COST | _decimal_28_8 | decimal(28) | Yes | Receipt Cost | No |
| STRECDT_ACC_USAGE | _varchar_20 | varchar(20) | Yes | Accounting Usage | No |
| STRECDT_FIN_BOOK | _varchar_20 | varchar(20) | Yes | Finance Book | No |
| STRECDT_ACC_CODE | _varchar_32 | varchar(32) | Yes | Accounting Code | No |
| STRECDT_ANLY_CODE | _varchar_5 | varchar(5) | Yes | Analysis Code | No |
| STRECDT_SUBANLY_CODE | _varchar_5 | varchar(5) | Yes | Sub Analysis Code | No |
| STRECDT_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Integer Timestamp which is maintained for concurrency | No |
| STRECDT_ZNBN_LNKFLAG | _varchar_5 | varchar(5) | Yes | This can take the following values. Y , N If the storage details are completely entered for the Line, this will be Y If the storage details are pending to be entered for the Line, this will be N | No |
| STRECDT_SRLLOT_LNKFLAG | _varchar_5 | varchar(5) | Yes | This can take the following values. Y , N , NA If the serial Or Lot details are completely entered for the Line, this will be Y If the serial Or Lot details are pending to be entered for the Line, this will be N If the serial Or Lot detail | No |
| STRECDT_ADL_EXISTFLAG | _varchar_5 | varchar(5) | Yes | It hold value Y if it is visited and N if not required | No |
| STRECDT_COMPUTED_COST | _decimal_28_8 | decimal(28) | Yes | computed cost of receipt | No |
| STRECDT_COMPUTED_DATE | _datetime_8 | datetime(8) | Yes | computed date | No |
| STRECDT_LOSSTRAN_COST | udd_amount | numeric(13) | Yes | Used to store cost of part lost in transit | No |
| STRECDT_TRAN_COST | udd_amount | numeric(13) | Yes | Transaction Cost | No |
| STRECDT_STOCK_UOM | udd_unitofmeasurement | varchar(10) | Yes | Stock UOM | No |
| STRECDT_CNTRLTYPE | udd_flag | varchar(25) | Yes | Control Type of the part | No |
| STRECDT_EXPENSETYPE | udd_flag | varchar(25) | Yes | Expense type of the Part | No |
| STRECDT_EXPENSING_POLICY | udd_designparamcode | varchar(5) | Yes | Expensing policy of the part | No |
| STRECDT_ISSUEBASIS | udd_designparamcode | varchar(5) | Yes | Issue basis of the part | No |
| STRECDT_NONSTOCKABLE_FLAG | udd_flag | varchar(25) | Yes | Non stockable attribute of the part | No |
| STRECDT_PARTTYPE | udd_parttype | varchar(25) | Yes | Part Type of the part | No |
| STRECDT_VALUATION_METHOD | udd_designparamcode | varchar(5) | Yes | Valuation method of the part | No |
| STRECDT_PART_LOTNOTYPE | udd_flag | varchar(25) | Yes | lot number type | No |
| STRECDT_PART_SLNOTYPE | udd_flag | varchar(25) | Yes | serail number type | No |
| STRECDT_PART_SLNOLOGIC | udd_flag | varchar(25) | Yes | serial number logic | No |
| STRECDT_PART_ACC_GRP | udd_flag | varchar(25) | Yes | part account group | No |
| STRECDT_ISU_PARTTYPE | udd_parttype | varchar(25) | Yes | isu part type | No |
| STRECDT_ISU_CNTRLTYPE | udd_flag | varchar(25) | Yes | isu control type | No |
| STRECDT_ISU_EXPENSETYPE | udd_flag | varchar(25) | Yes | isu expense type | No |
| STRECDT_ISU_VALUATION_METHOD | udd_designparamcode | varchar(5) | Yes | isu valuation method | No |
| STRECDT_ISU_NONSTOCKABLE_FLAG | udd_designparamcode | varchar(5) | Yes | isu non stockable flag | No |
| STRECDT_ISU_EXPENSING_POLICY | udd_designparamcode | varchar(5) | Yes | isu expensing policy | No |
| STRECDT_ISU_PART_LOTNOTYPE | udd_designparamcode | varchar(5) | Yes | isu part lot no type | No |
| STRECDT_ISU_PART_SLNOTYPE | udd_designparamcode | varchar(5) | Yes | isu serial no type | No |
| STRECDT_ISU_PART_SLNOLOGIC | udd_flag | varchar(25) | Yes | isu serial no logic | No |
| STRECDT_ISU_PART_ACC_GRP | udd_flag | varchar(25) | Yes | isu part account group | No |
| STRECDT_ISU_CURRENCY | udd_designparamcode | varchar(5) | Yes | currency | No | |
| Table Name : | REC_STRECMN_STKTRN_HDR |
| Comment : | This table is used to store the document level information of stock transfer receipt |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| STRECMN_OUINSTANCE_ID | _decimal_10_1 | decimal(10) | No | OU Instance ID where the Stock Transfer Receipt is received | Yes |
| STRECMN_RECEIPT_NO | _varchar_40 | varchar(40) | No | System generated Receipt No for receiving the parts which are part of the Stock Transfer Document | Yes |
| STRECMN_STATUS | _varchar_5 | varchar(5) | Yes | Stock Transfer Receipt Status Following are the codes and description for Stock Status DR - Draft FR - Fresh, CF - Confirmed CN - Cancelled | No |
| STRECMN_DATE | _datetime_8 | datetime(8) | Yes | Date on which Parts listed in Stock Transfer got received to Inventory | No |
| STRECMN_CATEGORY | _varchar_25 | Varchar(25) | Yes | Stock Transfer Receipt Category. This is a user defined code as specified in Quick Code activity under the Quick Code Type Receipt Category | No |
| STRECMN_USER_STATUS | _varchar_25 | Varchar(25) | Yes | User defined Statuses as defined in Quick Code activity under the quick code type Receipt User Status . | No |
| STRECMN_STKTRANSFER_OU | _decimal_10_1 | decimal(10) | Yes | OU Instance ID where the Stock Transfer Document is created | No |
| STRECMN_STKTRANSFER_NO | _varchar_40 | varchar(40) | Yes | Stock Transfer Document No against which the receipt is made | No |
| STRECMN_ISSUE_OU | _decimal_10_1 | decimal(10) | Yes | OU ID where the Stock Transfer Issue document was created | No |
| STRECMN_ISSUE_NO | _varchar_40 | varchar(40) | Yes | Issue document reference for the Stock transfer document | No |
| STRECMN_GATE_PASS_NO | _varchar_40 | varchar(40) | Yes | Gate Pass # | No |
| STRECMN_UNLOADING_DOC | _varchar_40 | varchar(40) | Yes | Unloading Document No | No |
| STRECMN_RCVD_DATETIME | _datetime_8 | datetime(8) | Yes | Date and time at which the stocks specified in the stock transfer doc got received | No |
| STRECMN_PCKG_CONDITION | _varchar_25 | Varchar(25) | Yes | Packaging condition of the bulk stocks that got received as part of the Stock Transfer document | No |
| STRECMN_RECEIVED_BY | _varchar_30 | varchar(30) | Yes | Employee Code/Name who is receiving the stocks part of the stock transfer document | No |
| STRECMN_REFERENCE_DOC | _varchar_40 | varchar(40) | Yes | Reference doc if any | No |
| STRECMN_USER_DEF_1 | _varchar_25 | Varchar(25) | Yes | User defined additional information - 1 | No |
| STRECMN_USER_DEF_2 | _varchar_25 | Varchar(25) | Yes | User defined additional information - 2 | No |
| STRECMN_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks (if any) | No |
| STRECMN_FILENAME | _varchar_50 | varchar(50) | Yes | FileName | No |
| STRECMN_WF_DOC_KEY | _varchar_20 | varchar(20) | Yes | Document Number | No |
| STRECMN_WF_NEW_STATE | _varchar_128 | varchar(128) | Yes | New State | No |
| STRECMN_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created Login User Name | No |
| STRECMN_CREATED_DATETIME | _datetime_8 | datetime(8) | Yes | Created date and time | No |
| STRECMN_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Last modified login user name | No |
| STRECMN_MODIFIED_DATETIME | _datetime_8 | datetime(8) | Yes | Last Modified date and time | No |
| STRECMN_APPROVED_BY | _varchar_30 | varchar(30) | Yes | Approved login user name | No |
| STRECMN_APPROVED_DATETIME | _datetime_8 | datetime(8) | Yes | Approved date and time | No |
| STRECMN_TIMESTAMP | _decimal_10_1 | decimal(10) | Yes | Integer Timestamp which is maintained for concurrency | No |
| STRECMN_CC_USAGE | _varchar_20 | varchar(20) | Yes | Costing Usage | No | |
| Table Name : | REC_STRECSG_STKTRN_STORAGE |
| Comment : | This table is used to store the storage information of the stock transfer receipt |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| STRECSG_OUINSTANCE_ID | _decimal_10_0 | decimal(10) | No | OU Instance ID where the Stock Transfer Receipt is received | Yes |
| STRECSG_RECEIPT_NO | _varchar_40 | varchar(40) | No | System generated Receipt No for receiving the parts which are part of the Stock Transfer Document | Yes |
| STRECSG_PRT_SYSLINE_NO | _decimal_10_0 | decimal(10) | No | Receipt Line Number for the parts listed in the Stock Transfer Doc. This will be same as the Stock Tranfer Issue Doc line No as for one stock tranfer issue, there could be only one stock tranfer receipt document | Yes |
| STRECSG_STG_SYSLINE_NO | _decimal_10_0 | decimal(10) | No | System generated Unique sequence no to identify a storage allocation detail. | Yes |
| STRECSG_STG_DISPLAYLINE_NO | _decimal_10_0 | decimal(10) | Yes | Display Line Number | No |
| STRECSG_WAREHOUSE_OU | _decimal_10_0 | decimal(10) | Yes | OU ID of the Warehouse where the stock is received | No |
| STRECSG_WAREHOUSE_NO | _varchar_10 | varchar(10) | Yes | Warehouse where the part is getting received | No |
| STRECSG_ZONE_ID | _varchar_10 | varchar(10) | Yes | Zone where the part is getting received. | No |
| STRECSG_BIN_ID | _varchar_10 | varchar(10) | Yes | Bin Id where the part is getting received | No |
| STRECSG_RECEIPT_COST | _decimal_28_8 | decimal(28) | Yes | Warehouse level Receipt Cost: Receipt cost includes Tax and charges apart from Issue cost, i.e. Receipt cost = Issue Cost + TC. This will be proportionated based on the line level receipt cost | No |
| STRECSG_RCPT_QTY_INSTKUOM | _decimal_28_8 | decimal(28) | Yes | Part Quantity received in stock Uom into | No |
| STRECSG_CC_USAGE | _varchar_20 | varchar(20) | Yes | Holds the cost center for that transaction | No |
| STRECSG_COSTCENTER_CODE | _varchar_40 | varchar(40) | Yes | Cost Center Code | No |
| STRECSG_LOSSTRAN_COST | udd_amount | numeric(13) | Yes | Used to store the cost of parts lost in transit | No |
| STRECSG_TRAN_COST | udd_amount | numeric(13) | Yes | Transaction Cost | No | |
| Table Name : | REC_STRECSHP_STKTRN_SHIP |
| Comment : | this table is used to stored the shipment details of the stock transfer receipt |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| STRECSHP_OUINSTANCE_ID | _decimal_10_0 | decimal(10) | No | OU Instance ID where the Stock Transfer Receipt is received | Yes |
| STRECSHP_RECEIPT_NO | _varchar_40 | varchar(40) | No | System generated Receipt No for receiving the parts which are part of the Stock Transfer Document | Yes |
| STRECSHP_SHIP_BY | _varchar_25 | Varchar(25) | Yes | Ship by | No |
| STRECSHP_PACKAGE_CODE | _varchar_25 | Varchar(25) | Yes | Package Code | No |
| STRECSHP_VEHICLEORFLT_NO | _varchar_150 | varchar(150) | Yes | Vehicle or Flight Number | No |
| STRECSHP_CARRIER | _varchar_150 | varchar(150) | Yes | Carrier | No |
| STRECSHP_FREIGHT_BILL_NO | _varchar_40 | varchar(40) | Yes | Freight Bil Number | No |
| STRECSHP_FREIGHT_AMT | _decimal_28_8 | decimal(28) | Yes | Freight Amount | No |
| STRECSHP_FREIGHT_TERM | _varchar_150 | varchar(150) | Yes | Freight Term | No |
| STRECSHP_LANDING_BILL_NO | _varchar_40 | varchar(40) | Yes | Landing Bill Number | No |
| STRECSHP_INSURANCE_LIABILITY | _varchar_5 | varchar(5) | Yes | Insurance Liability | No |
| STRECSHP_INSURANCE_AMT | _decimal_28_8 | decimal(28) | Yes | Insurance Amount | No |
| STRECSHP_WAY_BILL_NO | _varchar_40 | varchar(40) | Yes | Way Bill Number | No |
| STRECSHP_SHIPPING_PAY_MTHD | _varchar_150 | varchar(150) | Yes | Shipping Pay Method | No |
| STRECSHP_SHIPMENT_DATETIME | _datetime_8 | datetime(8) | Yes | Shipment Date and Time | No |
| STRECSHP_USER_DEF_1 | _varchar_25 | Varchar(25) | Yes | User Definition 1 | No |
| STRECSHP_USER_DEF_2 | _varchar_25 | Varchar(25) | Yes | User Definition 2 | No |
| STRECSHP_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks (if any) | No |
| STRECSHP_CREATED_BY | _varchar_30 | varchar(30) | Yes | Created Login User Name | No |
| STRECSHP_CREATED_DATETIME | _datetime_8 | datetime(8) | Yes | Created Date and time | No |
| STRECSHP_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | Last Modified Login User Name | No |
| STRECSHP_MODIFIED_DATETIME | _datetime_8 | datetime(8) | Yes | Last Modified Date and Time | No |
| STRECSHP_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | TimeStamp | No | |
| Table Name : | REC_STRECSRL_STKSRLLOT_DTL |
| Comment : | this table is used to stored the serial lot details details of the stock transfer receipt |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| STRECSRL_OUINSTANCE_ID | _decimal_10_0 | decimal(10) | No | OU Instance ID where the Stock Transfer Receipt is received | Yes |
| STRECSRL_RECEIPT_NO | _varchar_40 | varchar(40) | No | System generated Receipt No for receiving the parts which are part of the Stock Transfer Document | Yes |
| STRECSRL_PRT_SYSLINE_NO | _decimal_10_0 | decimal(10) | No | Receipt Line Number for the parts listed in the Stock Transfer Doc. This will be same as the Stock Tranfer Issue Doc line No as for one stock tranfer issue, there could be only one stock tranfer receipt document | Yes |
| STRECSRL_STG_SYSLINE_NO | _decimal_10_0 | decimal(10) | No | System generated Unique sequence no to identify a storage allocation detail. | Yes |
| STRECSRL_SERIAL_NO | _varchar_40 | varchar(40) | No | Receipt Serial Number for the parts. | Yes |
| STRECSRL_LOT_NO | _varchar_18 | varchar(18) | No | Receipt Lot Number for the parts. | Yes |
| STRECSRL_QTY | _decimal_28_8 | decimal(28) | Yes | Receipt Quantity | No |
| STRECSRL_QTY_INSTKUOM | _decimal_28_8 | decimal(28) | Yes | Receipt Quantity of the parts in Stock UOM. | No |
| STRECSRL_NEW_LOT_NO | _varchar_18 | varchar(18) | Yes | This will the new lot number generated for the destination ou-warehouse | No |
| STRECSRL_RECEIPT_COST | udd_amount | numeric(13) | Yes | Receipt Cost | No |
| STRECSRL_TRAN_COST | udd_amount | numeric(13) | Yes | Transaction Cost | No | |
| Table Name : | REC_STRECTCD_STKTRN_TCD |
| Comment : | this table is used to stored the TCD details details of the stock transfer receipt |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| STRECTCD_OUINSTANCE_ID | _decimal_10_0 | decimal(10) | No | OU Instance ID where the Stock Transfer Receipt is received | Yes |
| STRECTCD_RECEIPT_NO | _varchar_40 | varchar(40) | No | System generated Receipt No for receiving the parts which are part of the Stock Transfer Document | Yes |
| STRECTCD_PRT_SYSLINE_NO | _decimal_10_0 | decimal(10) | No | Receipt Line Number for the parts listed in the Stock Transfer Doc. This will be same as the Stock Tranfer Issue Doc line No as for one stock tranfer issue, there could be only one stock tranfer receipt document This will be 0 if the TCD info is at | Yes |
| STRECTCD_TCD_LINE_ID | _decimal_10_0 | decimal(10) | No | TCD Line Id | Yes |
| STRECTCD_TCD_OU | _decimal_10_0 | decimal(10) | Yes | Tcd Ouinstance | No |
| STRECTCD_TCD_VARIANT | _varchar_25 | Varchar(25) | Yes | Tcd Variant | No |
| STRECTCD_TCD_NO | _varchar_25 | Varchar(25) | Yes | Tcd Number | No |
| STRECTCD_TCD_RATE | _decimal_28_8 | decimal(28) | Yes | Tcd Rate | No |
| STRECTCD_TCD_AMOUNT | _decimal_28_8 | decimal(28) | Yes | Tcd Amount | No |
| STRECTCD_TCD_ACCCODE | _varchar_32 | varchar(32) | Yes | Accounting Code | No |
| STRECTCD_TCD_SUPACCCODE | _varchar_32 | varchar(32) | Yes | Supplier Accounting Code | No |
| STRECTCD_TCD_PAYTOSUP | _varchar_45 | varchar(45) | Yes | Pay t Supplier | No |
| STRECTCD_TCD_ACCRULE | _varchar_25 | Varchar(25) | Yes | Accounting Rule | No |
| STRECTCD_COSTCENTER_CODE | _varchar_10 | varchar(10) | Yes | Cost Center Code | No | |
| Table Name : | REC_UPRADL_UNPLNRCPT_ADL_INFO |
| Comment : | This table is used to store the serial and lot details for the line items which are lot / Serial controlled. |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| UPRADL_DOCUMENT_OU | _decimal_10_0 | decimal(10) | No | UnPlanned Receipt Document OU | Yes |
| UPRADL_DOCUMENT_NO | udd_documentno | varchar(40) | No | UnPlanned Receipt Document No | Yes |
| UPRADL_PRT_SYSLINE_NO | _decimal_10_0 | decimal(10) | No | The Line no to identify the records uniquely | Yes |
| UPRADL_SRL_SYSLINE_NO | _decimal_10_0 | decimal(10) | No | Sequence Number | Yes |
| UPRADL_SRL_DISPLAYLINE_NO | _decimal_10_0 | decimal(10) | Yes | Display Line Number | No |
| UPRADL_REF_LOT_NO | _varchar_18 | varchar(18) | Yes | Referencial Lot Number. The manufacturer s lot number of the parts being received(valid for lot controlled parts) | No |
| UPRADL_REF_SERIAL_NO | _varchar_40 | varchar(40) | Yes | Referencial Serial Number. The manufacturer s serial number (valid for serial controlled parts) | No |
| UPRADL_PART_CONDITION | _varchar_5 | varchar(5) | Yes | The condition of the line item take values like O - Overhauled S - Serviceable U - UnServeceable and | No |
| UPRADL_RCPT_QTY | _decimal_28_8 | decimal(28) | Yes | The quantity of the specified part (line item) being received | No |
| UPRADL_RCPT_QTY_IN_STKUOM | _decimal_28_8 | decimal(28) | Yes | Receipt Quantity in Stock UOM. | No |
| UPRADL_CERTIFICATE_TYPE | _varchar_25 | Varchar(25) | Yes | Certificate Type. It is defined in Logistics Common master component. | No |
| UPRADL_CERTIFICATE_NO | _varchar_40 | varchar(40) | Yes | Certificate Number | No |
| UPRADL_CERTIFICATE_DATE | _datetime_8 | datetime(8) | Yes | Certificate Date | No |
| UPRADL_AUTH_NO | _varchar_40 | varchar(40) | Yes | Authorization Number | No |
| UPRADL_SYS_TRACKING_REF | _varchar_40 | varchar(40) | Yes | System Tracking reference Number | No |
| UPRADL_REMARKS | _varchar_255 | varchar(255) | Yes | Textual field for entering any remarks/comments regarding the transaction | No |
| UPRADL_SERIAL_NO | _varchar_40 | varchar(40) | Yes | Internal serial number identifying the individual unit (valid for serial controlled parts). If not provided by the user it will be generated by the system | No |
| UPRADL_SERIAL_NO_PFX | _varchar_6 | varchar(6) | Yes | Serial Number Prefix | No |
| UPRADL_SERIAL_NO_SFX | _varchar_6 | varchar(6) | Yes | Serial Number Suffix | No |
| UPRADL_SERIAL_RUNNING_NO | _decimal_10_0 | decimal(10) | Yes | Serial runnung Number | No |
| UPRADL_LOT_NO | _varchar_18 | varchar(18) | Yes | Internal lot # of the part (valid for lot controlled parts). If not provided by the user it will be generated/created by the system | No |
| UPRADL_WARRANTY_LAPSE_DATE | _datetime_8 | datetime(8) | Yes | Warranty Lapse Date | No |
| UPRADL_FILENAME | _varchar_50 | varchar(50) | Yes | FileName | No |
| UPRADL_EXPIRY_DATE | _datetime_8 | datetime(8) | Yes | Expiry date of the component | No |
| UprAdl_TradingPartnerType | udd_typecode | varchar(10) | Yes | holds the value CUS - Customer and SUP - Supplier | No |
| UprAdl_TradingPartnerNo | udd_vendorcode | varchar(45) | Yes | cus\sup number | No |
| UprAdl_TradingPartnerOU | ctxt_ouinstance | numeric(9) | Yes | Trading partner location instance | No |
| UPRADL_PART_COST | udd_amount | numeric(13) | Yes | Part cost | No |
| UPRADL_TRAN_COST | udd_amount | numeric(13) | Yes | Transaction Cost | No |
| UPRADL_Currency | udd_currency | varchar(20) | Yes | Currency | No | |
| Table Name : | REC_UPRATT_SRL_ATTRIB_INFO |
| Comment : | For a part-serial, the quantitative and qualitative attributes captured at the time of receipt are available in this table |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| UPRATT_DOCUMENT_OU | _decimal_10_0 | decimal(10) | No | Document OU | Yes |
| UPRATT_DOCUMENT_NO | _varchar_40 | varchar(40) | No | Document Number | Yes |
| UPRATT_PRT_SYSLINE_NO | _decimal_10_0 | decimal(10) | No | The Line no to identify the records uniquely | Yes |
| UPRATT_SRL_SYSLINE_NO | _decimal_10_0 | decimal(10) | No | Sequence Number | Yes |
| UPRATT_ATTRIBUTE_NO | _varchar_10 | varchar(10) | No | Attribute Code for the Part Serial Number | Yes |
| UPRATT_QUAL_VALUE | _varchar_80 | varchar(80) | Yes | Qualitative value | No |
| UPRATT_QUAN_VALUE | _decimal_28_8 | decimal(28) | Yes | Quantitative value | No |
| UPRATT_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks (if any) | No | |
| Table Name : | REC_UPRDTL_UNPLANNEDINFO_DTL |
| Comment : | This table contains the parts (and their details) that are received as part of the Unplanned Receipt Document |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| UPRDTL_DOCUMENT_OU | _decimal_10_0 | decimal(10) | No | UnPlanned Receipt Document OU | Yes |
| UPRDTL_DOCUMENT_NO | _varchar_18 | varchar(18) | No | UnPlanned Receipt Document No | Yes |
| UPRDTL_PRT_SYSLINE_NO | _decimal_10_0 | decimal(10) | No | System Line no to identify the records uniquely | Yes |
| UPRDTL_PRT_DISPLAYLINE_NO | _decimal_10_0 | decimal(10) | Yes | Line Number displayed to the user | No |
| UPRDTL_PART_STATUS | _varchar_40 | varchar(40) | No | Part Status of the received Part | Yes |
| UPRDTL_PART_CRT_OU | _decimal_10_0 | decimal(10) | No | Central Reference List OUinstance | No |
| UPRDTL_PART_PLN_OU | _decimal_10_0 | decimal(10) | No | Planning OUInstance | No |
| UPRDTL_PART_NO | _varchar_40 | varchar(40) | Yes | Code based on which the item is identified.. It is a unique code for the company. The Code of the Items which belongs to the particular bin or zone or warehouse accordingly | No |
| UPRDTL_RCPT_QTY | _decimal_28_8 | decimal(28) | Yes | The quantity of the items it can hold the fraction value with respect to the UOM | No |
| UPRDTL_RCPT_UOM | _varchar_10 | varchar(10) | Yes | The Transaction UOM ( Unit of measure ) in which the quantity has been supplied | No |
| UPRDTL_RCPT_QTY_IN_STKUOM | _decimal_28_8 | decimal(28) | Yes | Receipt Quantity in Stock UOM. | No |
| UPRDTL_ZONE_ID | _varchar_10 | varchar(10) | Yes | The Zone where the Items had been stored . the value must be present if the warehouse type is "Normal" The zone should be "##" if the warehouse type is "Free" | No |
| UPRDTL_BIN_ID | _varchar_10 | varchar(10) | Yes | The Bin where the Items had been stored . the value must be present if the Zone type is "Normal" The Bin should be "##" if the Zone type is "Free" | No |
| UPRDTL_PART_COST | _decimal_28_8 | decimal(28) | Yes | Part Cost entered by for the part at the time of receipt. For Std Part alone, whatever entered by the user is ignored and Std Part Cost for the part defined in Inventory is taken. | No |
| UPRDTL_ADL_DTL_EXISTS_FLAG | _varchar_25 | Varchar(25) | Yes | If additional information exists for this line item, then this flag will be Y else N | No |
| UPRDTL_ACC_USAGE | _varchar_20 | varchar(20) | Yes | Accounting Usgage | No |
| UPRDTL_FIN_BOOK | _varchar_20 | varchar(20) | Yes | Finance Book | No |
| UPRDTL_ACC_CODE | _varchar_32 | varchar(32) | Yes | Accounting Code | No |
| UPRDTL_ANLY_CODE | _varchar_5 | varchar(5) | Yes | Analysis Code | No |
| UPRDTL_SUBANLY_CODE | _varchar_5 | varchar(5) | Yes | Sub Analysis Code | No |
| UPRDTL_CREATED_BY | _varchar_30 | varchar(30) | No | The LoginId of the created user | No |
| UPRDTL_CREATED_DATE | _datetime_8 | datetime(8) | No | The date on which the receipt had been prepared | No |
| UPRDTL_MODIFIED_BY | _varchar_30 | varchar(30) | No | The loginid of the Lastmodified user | No |
| UPRDTL_MODIFIED_DATE | _datetime_8 | datetime(8) | No | The Last modified date of the transaction | No |
| UPRDTL_TIMESTAMP | _decimal_10_0 | decimal(10) | No | Timestamp for the record | No |
| UPRDTL_CC_USAGE | _varchar_20 | varchar(20) | Yes | Costing Usage | No |
| UPRDTL_COSTCENTER_CODE | _varchar_40 | varchar(40) | Yes | Cost Center Code | No |
| UPRDTL_PRICE_VAR | _decimal_28_8 | decimal(28) | Yes | Price | No |
| UPRDTL_PRICE_VAR_ACC | _varchar_32 | varchar(32) | Yes | PRICE VAR ACCOUNT | No |
| UPRDTL_COMPUTED_DATE | _datetime_8 | datetime(8) | Yes | Computed date | No |
| UPRDTL_COMPUTED_COST | _decimal_28_8 | decimal(28) | Yes | Computed cost | No |
| UPRDTL_TRAN_COST | udd_amount | numeric(13) | Yes | Transaction Cost | No |
| UPRDTL_CNTRL_TYPE | udd_flag | varchar(25) | Yes | Control Type of the part | No |
| UPRDTL_EXPENSE_TYPE | udd_flag | varchar(25) | Yes | Expense type of the Part | No |
| UPRDTL_EXPENSING_POLICY | udd_designparamcode | varchar(5) | Yes | Expensing policy of the part | No |
| UPRDTL_ISSUE_BASIS | udd_designparamcode | varchar(5) | Yes | Issue basis of the part | No |
| UPRDTL_NONSTOCKABLE_FLAG | udd_flag | varchar(25) | Yes | Non stockable attribute of the part | No |
| UPRDTL_PART_TYPE | udd_parttype | varchar(25) | Yes | Part Type of the part | No |
| UPRDTL_VALUATION_METHOD | udd_designparamcode | varchar(5) | Yes | Valuation method of the part | No |
| UprDtl_Currency | udd_currency | varchar(20) | Yes | currency | No | |
| Table Name : | REC_UPRHDR_UNPLANNEDINFO_HDR |
| Comment : | The table is used to store Unplanned receipt main information like receipt date, receipt doc status, category, Warehouse, etc |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| UPRHDR_DOCUMENT_OU | _decimal_10_0 | decimal(10) | No | OUInstance | Yes |
| UPRHDR_DOCUMENT_NO | _varchar_18 | varchar(18) | No | UnPlanned Receipt Document Number. Textual field for recording the requesting document on the basis of which the transaction is to be performed. | Yes |
| UPRHDR_DOCUMENT_DATE | _datetime_8 | datetime(8) | No | UnPlanned Receipt Document Date. Specifies the date at which the receipt takes place | No |
| UPRHDR_DOCUMENT_STATUS | _varchar_5 | varchar(5) | No | UnPlanned Receipt Document Status which take values DR- Draft FR- Fresh, CF- Confirmed CN-Cancelled | No |
| UPRHDR_CATEGORY | _varchar_25 | Varchar(25) | Yes | Reference Category. Quick code to categorize receipt transaction as per the users need | No |
| UPRHDR_USER_STATUS | _varchar_25 | Varchar(25) | Yes | User Status. Quick code to specify the user status. | No |
| UPRHDR_PART_OWNERSHIP | _varchar_5 | varchar(5) | No | Will have values like OW - Owned SU - Supplier CU - Customer | No |
| UPRHDR_OWNERSHIP_OU | _decimal_10_0 | decimal(10) | Yes | Ownership Ouinstance If Part Ownership is "Supplier then it will have Supplier Ouinstance If Part Ownership is "Customer then it will have Customer Ouinstance | No |
| UPRHDR_OWNERSHIP_DOC_NO | _varchar_150 | varchar(150) | Yes | Part Owner ship Document No. Textual field to capture loan agreement number etc | No |
| UPRHDR_WAREHOUSE_OU | _decimal_10_0 | decimal(10) | No | Warehouse OUInstance | No |
| UPRHDR_WAREHOUSE_NO | _varchar_10 | varchar(10) | No | Warehouse Number | No |
| UPRHDR_REFERENCE_DOC | _varchar_40 | varchar(40) | Yes | Reference Document Number | No |
| UPRHDR_REMARKS | _varchar_255 | varchar(255) | Yes | Textual field for entering any remarks/comments regarding the transaction | No |
| UPRHDR_APPROVED_BY | _varchar_30 | varchar(30) | Yes | Approved User | No |
| UPRHDR_APPROVED_DATE | _datetime_8 | datetime(8) | Yes | Approvd Date | No |
| UPRHDR_CREATED_BY | _varchar_30 | varchar(30) | No | Created User | No |
| UPRHDR_CREATED_DATE | _datetime_8 | datetime(8) | No | Created Date | No |
| UPRHDR_MODIFIED_BY | _varchar_30 | varchar(30) | No | Modified User | No |
| UPRHDR_MODIFIED_DATE | _datetime_8 | datetime(8) | No | Modified Date | No |
| UPRHDR_TIMESTAMP | _decimal_10_0 | decimal(10) | No | Time Stamp for the record | No |
| UPRHDR_SUPPLIERNO | _varchar_45 | varchar(45) | Yes | Supplier Number | No |
| UPRHDR_FILENAME | _varchar_50 | varchar(50) | Yes | FileName | No |
| UPRHDR_ACC_USAGE | _varchar_20 | varchar(20) | Yes | Account Usage | No |
| UPRHDR_WF_DOC_KEY | _varchar_20 | varchar(20) | Yes | Document Key | No |
| UPRHDR_WF_NEW_STATE | _varchar_128 | varchar(128) | Yes | New State | No |
| UPRHDR_CC_USAGE | _varchar_20 | varchar(20) | Yes | Costing Usage | No |
| UPRHDR_CUSTOMERNO | _varchar_45 | varchar(45) | Yes | Customer Number | No | |
| Table Name : | REC_UPROPSET_OPT_SETTINGS |
| Comment : | This table is used to store the options that are set by the user. The two options are: 1. Allow Input of Stock Value for Standard Cost Parts. It takes values Y and N . If it is set as Y , then the value entered by the user is taken as the |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| UPROPSET_OUINSTANCE | _decimal_10_0 | decimal(10) | No | OUinstance | Yes |
| UPROPSET_STKVAL_STDPRT_FLAG | _varchar_5 | varchar(5) | No | To Allow Input of Stock Value for Standard Cost Parts. It takes values Y and N . | No |
| UPROPSET_FRAC_CONV_MTHD_FLAG | _varchar_5 | varchar(5) | No | The option to do the Conversion of Fractional Receipt Qty. It takes values: Rounded Up - RUP Rounded Down - RDWN Rounded Off - ROFF | No |
| UPROPSET_CREATED_BY | _varchar_30 | varchar(30) | No | Created user | No |
| UPROPSET_CREATEDDATE | _datetime_8 | datetime(8) | No | Record Created Date | No |
| UPROPSET_MODIFIED_BY | _varchar_30 | varchar(30) | No | Modified User | No |
| UPROPSET_MODIFIEDDATE | _datetime_8 | datetime(8) | No | Record Modified Date | No |
| UPROPSET_TIMESTAMP | _decimal_10_0 | decimal(10) | No | Timestamp for the record | No |
| UPROPSET_AUTO_TRN_RCPT | _varchar_5 | varchar(5) | Yes | The option to default numbering type value for Automatic Transfer receipt | No | |
| Table Name : | REC_UPRPRM_SRL_PARAM_VAL |
| Comment : | For component type of parts, their initial parameter values during the first time of their receipt are stored here. |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| UPRPRM_DOCUMENT_OU | _decimal_10_0 | decimal(10) | No | UnPlanned Receipt Document OU | Yes |
| UPRPRM_DOCUMENT_NO | _varchar_40 | varchar(40) | No | UnPlanned Receipt Document No | Yes |
| UPRPRM_PRT_SYSLINE_NO | _decimal_10_0 | decimal(10) | No | The Line no to identify the records uniquely | Yes |
| UPRPRM_SRL_SYSLINE_NO | _decimal_10_0 | decimal(10) | No | Sequence Number | Yes |
| UPRPRM_PARAM_CODE | _varchar_40 | varchar(40) | No | Parameter Code | Yes |
| UPRPRM_SINCE_NEW | _decimal_28_8 | decimal(28) | Yes | Param value Since New | No |
| UPRPRM_SINCE_OVERHAUL | _decimal_28_8 | decimal(28) | Yes | Param value Since Overhaul | No |
| UPRPRM_SINCE_REPAIR | _decimal_28_8 | decimal(28) | Yes | Param value Since Repair | No |
| UPRPRM_SINCE_INSP | _decimal_28_8 | decimal(28) | Yes | Param value Since Inspection | No |
| UPRPRM_SINCE_LSV | _decimal_28_8 | decimal(28) | Yes | Param value since Last Shop Visit | No |
| UPRPRM_WARRANTY_VALUE | _decimal_28_8 | decimal(28) | Yes | Warranty value | No | |
| Table Name : | REC_UPRQC_QUICK_CODE |
| Comment : | Unplanned Receipt Quick Code master table which stores the quick codes defined by the user. |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| UPRQC_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Quick Created Ouinstance | Yes |
| UPRQC_QUICK_CODE | _varchar_25 | Varchar(25) | No | Quick Code Value | Yes |
| UPRQC_TYPE | _varchar_5 | varchar(5) | No | Quick Code Type RC - Receipt Category RU - Receipt User Status | Yes |
| UPRQC_DESC | _varchar_80 | varchar(80) | Yes | Quick Code Description | No |
| UPRQC_STATUS | _varchar_5 | varchar(5) | Yes | Quick Code Status A - Active I- Inacitve B - Blank | No |
| UPRQC_CREATEDDATE | _datetime_8 | datetime(8) | Yes | The Created date of the transaction | No |
| UPRQC_CREATED_BY | _varchar_30 | varchar(30) | Yes | The Created User of the transaction | No |
| UPRQC_MODIFIEDDATE | _datetime_8 | datetime(8) | Yes | The Last modified date of the transaction | No |
| UPRQC_MODIFIED_BY | _varchar_30 | varchar(30) | Yes | The Last modified user of the transaction | No |
| UPRQC_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Timestamp for the record | No | |
| Table Name : | UPR_PARAMETER_DETAILS |
| Comment : | This table holds the meta data for the component. This table will exist in all the component as part of the component. This table will hold the static values like combos, combo defaults, guidance text etc. Values are stored against the screen control. |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| UPR_COMPONENTNAME | _varchar_80 | varchar(80) | No | Component Name | Yes |
| UPR_PARAMCATEGORY | _varchar_10 | varchar(10) | No | 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. | Yes |
| UPR_PARAMTYPE | _varchar_25 | Varchar(25) | No | 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. | Yes |
| UPR_PARAMCODE | _varchar_5 | varchar(5) | No | Param code is the value to be filled in the combo box or guidance text. This is actually the meta data of this component | Yes |
| UPR_LANGID | _decimal_10_1 | decimal(10) | No | Language id. This is the language id of the record. | Yes |
| UPR_PARAMDESC | _varchar_80 | varchar(80) | Yes | Description of the combo value | No |
| UPR_SORT_BY | _decimal_10_1 | decimal(10) | Yes | The order in which it has to be stored. | No |