Component Replacement |
|||||
|
Table Name BAS_CR_CRD_COMP_REPL_DTL |
|
||||
|
Table Comment Component Replacement Transaction Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
CRD_ROTABLEREPLCMTNO |
varchar(40) |
NOT NULL |
Component Replacement No |
Yes |
No |
|
CRD_OUINSTANCE |
decimal(10) |
NOT NULL |
Comp Replacement OU Instance |
Yes |
No |
|
CRD_POSITIONCODE |
varchar(25) |
NULL |
Position Code in the Configuration F - "Free Positions" A - "All" |
No |
No |
|
CRD_SORCDOCTYPE |
varchar(5) |
NULL |
Source Doc Type LMW - " LINE WORK ORDER" TCHLG - "TECHNICAL LOG" CWO - "COMPONENT WORK ORDER" HWO - "HANGAR WORK ORDER" O - "OTHERS" |
No |
No |
|
CRD_SOURCEDOCUMENTNO |
varchar(40) |
NULL |
Source Document No |
No |
No |
|
CRD_STATIONCODE |
varchar(32) |
NULL |
Station Code where CR has been recorded. |
No |
No |
|
CRD_AIRCRAFTCODE |
varchar(30) |
NULL |
Aircraft Registration Number. |
No |
No |
|
CRD_NHACOMPONENTID |
varchar(90) |
NULL |
NHA (Next Higher Assembly) Component ID |
No |
No |
|
CRD_REMOVEDCOMPONENTID |
varchar(90) |
NULL |
Removed Component Id |
No |
No |
|
CRD_ITEMTAGNO |
varchar(90) |
NULL |
Tag No |
No |
No |
|
CRD_PROCESSACTION |
varchar(5) |
NULL |
Process Action taken. |
No |
No |
|
CRD_ROTABLEREMBY |
varchar(15) |
NULL |
Replacement Created by. |
No |
No |
|
CRD_REMOVALDATE |
datetime |
NULL |
Removal Date. |
No |
No |
|
CRD_REMOVALTIME |
datetime |
NULL |
Removal Time. |
No |
No |
|
CRD_REMTYPE |
varchar(5) |
NULL |
Removal Type. |
No |
No |
|
CRD_BASREMOVAL |
varchar(5) |
NULL |
Basic Removal (Yes/No) |
No |
No |
|
CRD_REASONFORREPL |
varchar(25) |
NULL |
Reason for Removal. |
No |
No |
|
CRD_REMARKS |
varchar(255) |
NULL |
Remarks. |
No |
No |
|
CRD_SOURCEOFPART |
varchar(5) |
NULL |
Source of Installed Part |
No |
No |
|
CRD_INCOMINGCOMPONENTID |
varchar(90) |
NULL |
Incoming Component Id. |
No |
No |
|
CRD_INSTALLATIONDATE |
datetime |
NULL |
Installation Date. |
No |
No |
|
CRD_INSTALLATIONTIME |
datetime |
NULL |
Installation Time. |
No |
No |
|
CRD_INSTALLEDBY |
varchar(30) |
NULL |
Installed by. |
No |
No |
|
CRD_STATUS |
varchar(5) |
NULL |
Status of Replacement. |
No |
No |
|
CRD_CREATED_BY |
varchar(30) |
NULL |
Created by. |
No |
No |
|
CRD_CREATION_DATE |
datetime |
NULL |
Creation Date. |
No |
No |
|
CRD_MODIFIED_BY |
varchar(30) |
NULL |
Modified by. |
No |
No |
|
CRD_MODIFICATION_DATE |
datetime |
NULL |
Modification Date. |
No |
No |
|
CRD_REMCONFIRMEDBY |
varchar(30) |
NULL |
Removal Confirmed by. |
No |
No |
|
CRD_REMCONFIRMEDDATE |
datetime |
NULL |
Removal Confirmation Date. |
No |
No |
|
CRD_REPLCONFIRMEDBY |
varchar(30) |
NULL |
Replacement Confirmed by. |
No |
No |
|
CRD_REPLCONFIRMEDDATE |
datetime |
NULL |
Replacement Confirmed date. |
No |
No |
|
CRD_REVERSEBY |
varchar(30) |
NULL |
Replacement Reversed by. |
No |
No |
|
CRD_REVERSEDATE |
datetime |
NULL |
Replacement Reversal Date. |
No |
No |
|
CRD_TIMESTAMP |
decimal(10) |
NULL |
TimeStamp of the Record. |
No |
No |
|
CRD_REMCOMPCREATEDOU |
decimal(10) |
NULL |
OUInstance. |
No |
No |
|
CRD_INSTALLCOMPCREATEDOU |
decimal(10) |
NULL |
OUInstance. |
No |
No |
|
CRD_OUTPARTNO |
varchar(40) |
NULL |
Outgoing Part Number. |
No |
No |
|
CRD_OUTPARTSERIALNO |
varchar(40) |
NULL |
Outgoing Serial Number. |
No |
No |
|
CRD_ATANUMBER |
varchar(16) |
NULL |
Ata Number. |
No |
No |
|
CRD_REMOVALDATEUTC |
datetime |
NULL |
UTC Removal Date. |
No |
No |
|
CRD_REMOVALTIMEUTC |
datetime |
NULL |
UTC Removal Time. |
No |
No |
|
CRD_INSTALLATIONDATEUTC |
datetime |
NULL |
UTC Installation Date. |
No |
No |
|
CRD_INSTALLATIONTIMEUTC |
datetime |
NULL |
UTC Installation Time. |
No |
No |
|
CRD_NOTYPENO |
varchar(5) |
NULL |
Numbering type of the CR. |
No |
No |
|
CRD_WF_NEW_STATE |
varchar(15) |
NULL |
Work Flow Status. |
No |
No |
|
CRD_WF_DOC_KEY |
varchar(128) |
NULL |
Work Document Kay. |
No |
No |
|
CRD_ATTACHSTATUS_REM |
varchar(25) |
NULL |
Attachment Status. |
No |
No |
|
CRD_ATTACHSTATUS_INST |
varchar(25) |
NULL |
Attachment Status. |
No |
No |
|
CRD_RECORDMODE |
varchar(25) |
NULL |
Replacement Record Mode. |
No |
No |
|
CRD_COMMENTS |
varchar(255) |
NULL |
CR Comments. |
No |
No |
|
crd_wrnty_procsd |
char(5) |
NULL |
This flag indicates whether the record is picked up by the warranty engine or not |
No |
No |
|
CRD_RETURN_FLAG |
char(5) |
NULL |
This flag will be updated as ’Y’ when the part is returned to the warehouse |
No |
No |
|
CRD_SOSDISP |
char(5) |
NULL |
Sos Display |
No |
No |
|
CRD_SOS_INITIATED_DATETIME |
datetime |
NULL |
SOS Initiated Datetime |
No |
No |
|
CRD_SOS_INITIATED_BY |
char(30) |
NULL |
SOS Initiated by |
No |
No |
|
CRD_SOS_DURATION |
numeric(13) |
NULL |
SOS Duration |
No |
No |
|
CRD_SOS_DURATION_UOM |
char(5) |
NULL |
SOS Duration UOM |
No |
No |
|
CRD_SOS_DUEDATETIME |
datetime |
NULL |
SOS Due datetime |
No |
No |
|
CRD_SOS_REF_DTL |
char(255) |
NULL |
SOS Reference information |
No |
No |
|
CRD_SOS_REMARKS |
char(255) |
NULL |
SOS Remarks |
No |
No |
|
CRD_INCOMINGPARTNO |
varchar(20) |
NULL |
Incoming Part No |
No |
No |
|
CRD_INCOMINGPARTSERIALNO |
varchar(20) |
NULL |
Incoming Serial No |
No |
No |
|
CRD_SOS_CF_NFF_UPDATE_DATE |
datetime |
NULL |
SOS update datetime |
No |
No |
|
CRD_SOS_CF_NFF_UPDATE_BY |
char(30) |
NULL |
SOS updated by |
No |
No |
|
CRD_ACCEPTANCEREF |
char(18) |
NULL |
Acceptance Ref |
No |
No |
|
Table Name bas_Cr_Crd_Comp_replacement_Dt |
|
||||
|
Table Comment Component Replacement Transaction Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
Crd_ouinstance |
numeric(10) |
NOT NULL |
Comp Replacement OU Instance |
Yes |
No |
|
Crd_RotableReplcmtNo |
varchar(40) |
NOT NULL |
Component Replacement No |
Yes |
No |
|
ModRefDocs |
char(15) |
NULL |
Source Doc Type LMW - " LINE WORK ORDER" TCHLG - "TECHNICAL LOG" CWO - "COMPONENT WORK ORDER" HWO - "HANGAR WORK ORDER" O - "OTHERS" |
No |
No |
|
SourceDocumentNo |
char(18) |
NULL |
Source Document No |
No |
No |
|
StationCode |
char(32) |
NULL |
Station Code |
No |
No |
|
AircraftCode |
char(30) |
NULL |
Aircraft Reg no |
No |
No |
|
PositionCode |
char(25) |
NULL |
Position Code in the Configuration F - "Free Positions" A - "All" |
No |
No |
|
NHAComponentID |
char(90) |
NULL |
NHA (Next Higher Assembly) Component ID |
No |
No |
|
RemovedComponentID |
char(90) |
NULL |
Removed Component Id |
No |
No |
|
ItemTagNo |
char(18) |
NULL |
Tag No |
No |
No |
|
PartCondition |
char(25) |
NULL |
Component Condition OVH - "OVERHAUL" INS - "INSPECTION" REP - "REPAIR" DIS - "DISCARD" REW - "REWORK" BTOW - "BACK TO OWNER" ALL - "ALL" ASS - "ASSOCIATED " |
No |
No |
|
RotableRemBy |
char(15) |
NULL |
Rotable Removed By User name |
No |
No |
|
RemovalDate |
char(15) |
NULL |
Rotable Removal Date |
No |
No |
|
RemovalTime |
char(15) |
NULL |
Rotable Removal Time |
No |
No |
|
RemType |
char(25) |
NULL |
Rotable Removal Type S - "SCHEDULED" US -" UNSCHEDULED" O - "OTHERS" |
No |
No |
|
BasRemoval |
char(25) |
NULL |
Bas Removal Category |
No |
No |
|
ReasonForRepl |
char(255) |
NULL |
Reason For Replacement |
No |
No |
|
Remarks |
char(255) |
NULL |
Removal Reason |
No |
No |
|
sourceofpart |
char(40) |
NULL |
Source of Installed Part |
No |
No |
|
IncomingComponentID |
char(90) |
NULL |
Incoming Component ID |
No |
No |
|
InstallationDate |
char(15) |
NULL |
Installation Date |
No |
No |
|
InstallationTime |
char(15) |
NULL |
Installation Time |
No |
No |
|
InstalledBy |
char(30) |
NULL |
Installed By User Name |
No |
No |
|
status |
char(15) |
NULL |
Component Replacement Status Fresh, Confirm Removal, Confirm Replacement, Cancel |
No |
No |
|
Crd_RemConfirmedBy |
char(30) |
NULL |
Component Removal Confirmed Done By |
No |
No |
|
Crd_RemConfirmedDate |
datetime |
NULL |
Component Removal Confirmed Date |
No |
No |
|
Crd_ReplConfirmedBy |
char(30) |
NULL |
Component Replacement Confirmed Done By |
No |
No |
|
Crd_ReplConfirmedDate |
datetime |
NULL |
Component Replacement Confirmed Date |
No |
No |
|
Crd_RemCompCreatedOU |
int |
NULL |
Removed Component Created OU Instance |
No |
No |
|
Crd_InstallCompCreatedOU |
int |
NULL |
Installed Component Created OU instance |
No |
No |
|
Crd_OutPartNo |
varchar(40) |
NULL |
removed part No |
No |
No |
|
Crd_OutPartSerialNo |
varchar(40) |
NULL |
Removed Serial No |
No |
No |
|
Crd_AtaNumber |
char(16) |
NULL |
Removed Part ATA number |
No |
No |
|
TimeFormat |
char(15) |
NULL |
Transaction Created By |
No |
No |
|
Crd_Creation_date |
datetime |
NULL |
Creation Date |
No |
No |
|
Crd_modified_by |
char(30) |
NULL |
Last Modified By |
No |
No |
|
Crd_modification_date |
datetime |
NULL |
Last Modification Date |
No |
No |
|
Crd_timestamp |
int |
NULL |
Timestamp |
No |
No |
|
Crd_RemovalDateUTC |
datetime |
NULL |
UTC Removal Date |
No |
No |
|
Crd_RemovalTimeUTC |
datetime |
NULL |
UTC Removal Time |
No |
No |
|
CRD_INSTALLATIONDATEUTC |
datetime |
NULL |
UTC Installation Date |
No |
No |
|
CRD_INSTALLATIONTIMEUTC |
datetime |
NULL |
UTC Installation Time. |
No |
No |
|
Table Name BAS_CR_NRD_NONCOMP_REPL_DTL |
|
||||
|
Table Comment Component Replacement Transaction Details for Non Components |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
NRD_OUINSTANCE |
char(18) |
NOT NULL |
Ouinstance |
Yes |
No |
|
NRD_CR_NO |
char(18) |
NOT NULL |
CRNO |
|
No |
|
NRD_POSITIONCODE |
char(25) |
NULL |
Position code |
No |
No |
|
NRD_SORCDOCTYPE |
char(30) |
NULL |
Source doc type |
No |
No |
|
NRD_SOURCEDOCUMENTNO |
char(18) |
NULL |
Source Document no |
No |
No |
|
NRD_AIRCRAFTCODE |
char(30) |
NULL |
Aircraft code |
No |
No |
|
NRD_NHACOMPONENTID |
char(90) |
NULL |
NHA component ID |
No |
No |
|
NRD_REMPARTCREATEDOU |
char(18) |
NULL |
Removal Part Created OU |
No |
No |
|
NRD_OUTPARTNO |
varchar(20) |
NULL |
OUT Part NO |
No |
No |
|
NRD_OUTPARTSERIALNO |
varchar(20) |
NULL |
OUT Part Serial No |
No |
No |
|
NRD_OUTPARTLOTNO |
char(30) |
NULL |
OUT Part Lotno |
No |
No |
|
NRD_ATANUMBER |
char(16) |
NULL |
Ata NUMBER |
No |
No |
|
NRD_ITEMTAGNO |
char(18) |
NULL |
ITEM Tagno |
No |
No |
|
NRD_PROCESSACTION |
char(25) |
NULL |
Process Action |
No |
No |
|
NRD_REMOVED_BY |
char(30) |
NULL |
Removed by |
No |
No |
|
NRD_REMOVED_DATE |
datetime |
NULL |
Removed Date |
No |
No |
|
NRD_REMOVALDATEUTC |
datetime |
NULL |
Removal Date UTC |
No |
No |
|
NRD_REMTYPE |
char(25) |
NULL |
Removal Type |
No |
No |
|
NRD_BASREMOVAL |
char(25) |
NULL |
Base Removal |
No |
No |
|
NRD_REASONFORREPL |
char(30) |
NULL |
Reason of Replacement |
No |
No |
|
NRD_REMARKS |
char(255) |
NULL |
Remarks |
No |
No |
|
NRD_SOURCEOFPART |
char(30) |
NULL |
Source of part |
No |
No |
|
NRD_INSTALLCOMPCREATEDOU |
char(18) |
NULL |
Install component Created OU |
No |
No |
|
NRD_INCOMINGCOMPONENTID |
char(90) |
NULL |
Incoming component ID |
No |
No |
|
NRD_INSTALLATIONDATE |
datetime |
NULL |
Installation Date |
No |
No |
|
NRD_INSTALLATIONDATEUTC |
datetime |
NULL |
Installation DateUTC |
No |
No |
|
NRD_INSTALLEDBY |
char(30) |
NULL |
Installed by |
No |
No |
|
NRD_STATUS |
char(30) |
NULL |
Status |
No |
No |
|
NRD_PART_CONDITION |
char(25) |
NULL |
Part Condition |
No |
No |
|
NRD_CREATED_BY |
char(30) |
NULL |
Created By |
No |
No |
|
NRD_CREATION_DATE |
datetime |
NULL |
Created Date |
No |
No |
|
NRD_MODIFIED_BY |
char(30) |
NULL |
Modified by |
No |
No |
|
NRD_MODIFICATION_DATE |
datetime |
NULL |
Modification Date |
No |
No |
|
NRD_REMCONFIRMEDBY |
char(30) |
NULL |
Removal Confirmed by |
No |
No |
|
NRD_REMCONFIRMEDDATE |
datetime |
NULL |
Removal Confirmed Date |
No |
No |
|
NRD_REPLCONFIRMEDBY |
char(30) |
NULL |
Replacement Confirmed by |
No |
No |
|
NRD_REPLCONFIRMEDDATE |
datetime |
NULL |
Replacement Confirmed date |
No |
No |
|
NRD_REVERSEBY |
char(30) |
NULL |
Reverse by |
No |
No |
|
NRD_REVERSEDATE |
datetime |
NULL |
Reversed Date |
No |
No |
|
NRD_RECORDMODE |
char(25) |
NULL |
Record mode |
No |
No |
|
NRD_COMMENTS |
char(255) |
NULL |
Comments |
No |
No |
|
NRD_WRNTY_PROCSD |
char(5) |
NULL |
Warranty Processed |
No |
No |
|
NRD_SOS_DISPOS |
char(5) |
NULL |
SOS Disp os |
No |
No |
|
NRD_SOS_DURATION |
char(30) |
NULL |
SOS Duration |
No |
No |
|
NRD_SOS_DURATION_UOM |
char(5) |
NULL |
SOS Duration UOM |
No |
No |
|
NRD_SOS_DUEDATETIME |
datetime |
NULL |
SOS Duedatetime |
No |
No |
|
NRD_SOS_REF_DTL |
char(255) |
NULL |
Reference detail |
No |
No |
|
NRD_SOS_REMARKS |
char(255) |
NULL |
SOS Remarks |
No |
No |
|
NRD_SOS_INITIATED_DATETIME |
datetime |
NULL |
SOS Initiated Datetime |
No |
No |
|
NRD_SOS_INITIATED_BY |
char(30) |
NULL |
Initiated BY |
No |
No |
|
NRD_SOS_CF_NFF_UPDATE_DATE |
datetime |
NULL |
SOF UPDATE date |
No |
No |
|
NRD_SOS_CF_NFF_UPDATE_BY |
char(30) |
NULL |
SOS update by |
No |
No |
|
Table Name BAS_ERRCR_ERROR_LOG |
|
||||
|
Table Comment Error Details of the Component Replacement if the CR is Error CR. |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
ERRCR_SERVICE |
varchar(32) |
NULL |
Error Created Service. |
No |
No |
|
ERRCR_CRNO |
varchar(40) |
NULL |
Error Created CR Number. |
No |
No |
|
ERRCR_ERRORID |
varchar(10) |
NULL |
Error ID of the Error Occurred. |
No |
No |
|
ERRCR_ERRORDESC |
varchar(255) |
NULL |
Error Description of the Error Occurred. |
No |
No |
|
ERRCR_STATUS |
varchar(25) |
NULL |
Error Status of the Error Occurred. (Pending/Resolved) |
No |
No |
|
ERRCR_LOGDATETIME |
datetime |
NULL |
Error Created Date and Time. |
No |
No |
|
ERRCR_PROCDATETIME |
datetime |
NULL |
Error Processed Date and Time. |
No |
No |
|
SRC_COMP_OU |
int |
NULL |
Component OUInstance. |
No |
No |
|
SRC_DOC_NO |
varchar(40) |
NULL |
Error Created Document Number. |
No |
No |
|
SRC_DOC_TYPE |
varchar(25) |
NULL |
Error Created Document Type. |
No |
No |
|
SRC_CR_LINENO |
int |
NULL |
Error CR Line Number. |
No |
No |
|
Table Name CR_ADT_ASSOCIATE_DIS_DTL |
|
||||
|
Table Comment Discrepancy Association Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
ADT_OUINSTANCE |
numeric(10) |
NOT NULL |
OU Instance |
Yes |
No |
|
ADT_ROTABLEREPLCMTNO |
varchar(40) |
NOT NULL |
Component Replacement No |
Yes |
No |
|
ADT_DISCREPANCYNO |
varchar(40) |
NOT NULL |
Discrepancy no |
Yes |
No |
|
ADT_SOURCEDOCTYPE |
varchar(15) |
NOT NULL |
Source Doc Type - CWO, TECH Log, Line Work order |
Yes |
No |
|
ADT_SOURCEDOCNO |
varchar(40) |
NOT NULL |
Source Document No |
Yes |
No |
|
ADT_DISCREPANCYDESC |
varchar(255) |
NULL |
Discrepancy Description |
No |
No |
|
ADT_COMMENTS |
varchar(255) |
NULL |
Comments |
No |
No |
|
ADT_REMARKS |
varchar(255) |
NULL |
Remarks |
No |
No |
|
ADT_STATUS |
varchar(40) |
NULL |
Discrepancy Status When the CR created the Discrepancy status would be in Open status , on allocation to the Component Work order the Status Gets Changed to Processed. O - Open P - Processed |
No |
No |
|
ADT_CREATED_DATE |
datetime |
NULL |
Record Created Date |
No |
No |
|
ADT_CREATED_BY |
varchar(30) |
NULL |
Record Created By |
No |
No |
|
ADT_MODIFIED_DATE |
datetime |
NULL |
Record last Modified Date |
No |
No |
|
ADT_MODIFIED_BY |
varchar(30) |
NULL |
Record last Modified By |
No |
No |
|
Table Name cr_osd_option_setting_det |
|
||||
|
Table Comment CR Option Settings |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
osd_ouinstance |
numeric(10) |
NOT NULL |
CR Ou Instance |
Yes |
No |
|
OSD_AUTOWARRANTYCLIAM |
varchar(5) |
NOT NULL |
Auto Warranty Claim Flag. |
Yes |
No |
|
osd_AutoWarranyClaim |
varchar(5) |
NOT NULL |
Automatic Generation of Warranty Claim Indicator Y - Yes N - No |
Yes |
No |
|
OSD_DEFAULTWARRANTCLIAMDESC |
varchar(20) |
NULL |
Default Warranty Claim Description. |
No |
No |
|
osd_DefaultWarrantyClaimDesc |
varchar(20) |
NULL |
Default Description of Warranty Claim from CR |
No |
No |
|
osd_repldt_flag |
varchar(5) |
NULL |
Default Replacement Date Based on Source Document ( Yes/No ) |
No |
No |
|
osd_assstat_flag |
varchar(5) |
NULL |
Check Whether Assembly Status is Complete ( Yes/No ) |
No |
No |
|
OSD_TIMESTAMP |
numeric(28) |
NULL |
TimeStamp Record. |
No |
No |
|
osd_created_by |
varchar(30) |
NULL |
Record Created By |
No |
No |
|
osd_created_date |
datetime |
NULL |
Record Created Date |
No |
No |
|
osd_modified_by |
varchar(30) |
NULL |
Record last Modified By user name |
No |
No |
|
osd_modified_date |
datetime |
NULL |
Record last Modified Date |
No |
No |
|
OSD_PERMIT_ERRLOG |
varchar(5) |
NULL |
Permit Error Logging of Component Replacement? ( Yes/No ) |
No |
No |
|
Table Name cr_pad_proposed_action_det |
|
||||
|
Table Comment Proposed Action Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
pad_ouinstance |
numeric(10) |
NOT NULL |
Comp Replacement OU Instance |
Yes |
Yes |
|
pad_RotableReplacmtNo |
varchar(40) |
NOT NULL |
Component Replacement No |
Yes |
Yes |
|
pad_ProcessAction |
varchar(25) |
NULL |
Process Action O - "Overhaul" I - "Inspection" R - "Repair" D - "Discard" R - "Rework" B- "Back to Owner" |
No |
No |
|
pad_Priority |
numeric(10) |
NULL |
Priority with values defined in "active" status in the common master |
No |
No |
|
pad_AOG |
varchar(25) |
NULL |
AOG Indicator Y - Yes N - No |
No |
No |
|
pad_MoveToWorkCenter |
varchar(30) |
NULL |
Move To Work Center No |
No |
No |
|
pad_expRetDate |
datetime |
NULL |
Expected Date of Return |
No |
No |
|
pad_ShipDate |
datetime |
NULL |
Date of Shipment |
No |
No |
|
pad_remarks |
varchar(255) |
NULL |
Proposed Action Remarks |
No |
No |
|
pad_CwoComments |
varchar(255) |
NULL |
Component Work Order Comments |
No |
No |
|
pad_created_by |
varchar(30) |
NULL |
Record Created by Login user Name |
No |
No |
|
pad_create_Date |
datetime |
NULL |
Record Created Date |
No |
No |
|
pad_modified_by |
varchar(30) |
NULL |
Record last Modified By Login User name |
No |
No |
|
pad_modified_date |
datetime |
NULL |
Record last Modified Date |
No |
No |
|
PAD_EXPRETDATEUTC |
datetime |
NULL |
UTC Expected Receipt Date. |
No |
No |
|
Table Name cr_parameter_details |
|
||||
|
Table Comment Component Replacement Parameter Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
crp_ComponentName |
varchar(20) |
NOT NULL |
Component Name |
Yes |
No |
|
Crp_ParamCategory |
varchar(10) |
NOT NULL |
Param Category |
Yes |
No |
|
Crp_ParamType |
varchar(25) |
NOT NULL |
Parameter Type |
Yes |
No |
|
Crp_ParamCode |
varchar(5) |
NOT NULL |
Parameter Code |
Yes |
No |
|
Crp_LangId |
numeric(10) |
NOT NULL |
Language ID |
Yes |
No |
|
Crp_DisplayOrder |
numeric(10) |
NULL |
Display Order |
No |
No |
|
Crp_ParamDesc |
varchar(25) |
NOT NULL |
Parameter Desc |
No |
No |
|
Crp_CreationDate |
datetime |
NULL |
Creation Date |
No |
No |
|
Table Name cr_rrd_replace_reversal_det |
|
||||
|
Table Comment Component Replacement Reversal Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
rrd_Created_By |
varchar(30) |
NULL |
Record Created By |
No |
No |
|
rrd_Remarks |
varchar(255) |
NULL |
Reversal Remarks |
No |
No |
|
rrd_Created_date |
datetime |
NULL |
Record Created Date |
No |
No |
|
rrd_modified_by |
varchar(30) |
NULL |
Record Modified By |
No |
No |
|
rrd_modified_date |
datetime |
NULL |
Record Modification Date |
No |
No |
|
rrd_RotableReplacmdNo |
varchar(40) |
NOT NULL |
Component Replacement No |
Yes |
Yes |
|
rrd_ouinstance |
numeric(10) |
NOT NULL |
Comp Replacement OU Instance |
Yes |
Yes |
|
rrd_UserDefined3 |
varchar(25) |
NULL |
User Defined Filed 3 |
No |
No |
|
rrd_UserDefined1 |
varchar(25) |
NULL |
User Defined Filed 1 |
No |
No |
|
rrd_UserDefined2 |
varchar(25) |
NULL |
User Defined Filed 2 |
No |
No |
|
|
|
|
|
|
|