Data Dictionary - BasSupplier |
|
|
|
| |||||
|
|
|||||||||
|
Table Name SP_LOCDT_SUPP_LOC |
|
||||||||
|
|
|||||||||
|
Table Comment This is the Location Detail table for the Location master containing information about the location addresses etc. |
|
||||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|||
|
LOCDT_OUINSTANCE |
numeric(10) |
NOT NULL |
This field is to define location code unique at Organization unit level |
Yes |
Yes |
|
|||
|
LOCDT_SUPPLIER_ID |
varchar(45) |
NOT NULL |
To define supplier code unique at Company level or Organization unit level |
Yes |
Yes |
|
|||
|
LOCDT_CREATED_OUINSTANCE |
numeric(10) |
NOT NULL |
To specify the OU instance at which the Supplier was created. |
Yes |
Yes |
|
|||
|
LOCDT_ADDRESSID |
numeric(10) |
NOT NULL |
This field is to capture the Address Id of the supplier - corresponding to this Location |
Yes |
No |
|
|||
|
LOCDT_ADDR_CATEGORY |
varchar(40) |
NOT NULL |
This field is to capture the Address category of user defined quick code type Address category. |
No |
No |
|
|||
|
LOCDT_PREF_SEQ |
numeric(10) |
NULL |
This field holds the Preferred Seq. of addresses of the supplier at location level |
No |
No |
|
|||
|
LOCDT_CREATED_BY |
varchar(30) |
NULL |
This field holds the User who has created the record. |
No |
No |
|
|||
|
LOCDT_CREATED_DATE |
datetime |
NULL |
This field is to capture the created date of the record |
No |
No |
|
|||
|
LOCDT_MODIFIED_BY |
varchar(30) |
NULL |
This field holds the User who has modified the record. |
No |
No |
|
|||
|
LOCDT_MODIFIED_DATE |
datetime |
NULL |
This field holds the modified date of the record |
No |
No |
|
|||
|
|
|||||||||
|
Table Name SP_LOCMS_SUPP_LOC |
|
||||||||
|
|
|||||||||
|
Table Comment Loc table is OU specific.  Each supplier can have zero or more locations |
|
||||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|||
|
LOCMS_OUINSTANCE |
decimal(10) |
NOT NULL |
This field is to define location code unique at Organization unit level |
Yes |
No |
|
|||
|
LOCMS_SUPPLIER_ID |
varchar(45) |
NOT NULL |
To define supplier code unique at Company level or Organization unit level |
Yes |
Yes |
|
|||
|
LOCMS_CREATED_OUINSTANCE |
numeric(10) |
NOT NULL |
To specify the OU instance at which the Supplier was created. |
Yes |
Yes |
|
|||
|
LOCMS_SUPP_NAME |
varchar(150) |
NULL |
This field holds the Supplier Name for other components easy access to this field . |
No |
No |
|
|||
|
LOCMS_SUPP_NAME_UP |
varchar(150) |
NULL |
This field holds the Supplier Name in upper case |
No |
No |
|
|||
|
LOCMS_SUPP_STATUS |
varchar(25) |
NULL |
This field holds the Supplier status - various across locations. values 1.’A’ - "Active", 2.’I’ - ’InActive’, 3.’HP’ Hold Pay 4. ’HB’ Hold Buy 3.’B’ - ’ ’ |
No |
No |
|
|||
|
LOCMS_PAYMODE |
varchar(25) |
NULL |
This field holds the Agreed Pay mode between the supplier and purchaser will be defined for the Supplier at the OU level. Allowed Values are - 1. ’CS’ - "Cash", 2.’CQ’ - "Check", 3.’O’ - "Others" and 4.’DD’ - "Demand Draft" 5. ’E’, EFT 6.’CC’ , Credit Card 7. ’P’, Pay Order |
No |
No |
|
|||
|
LOCMS_PAY_PRIORITY |
varchar(25) |
NULL |
This field holds the values ’H’ - "High", ’N’ - "Normal" and ’L’ - "Low" |
No |
No |
|
|||
|
LOCMS_PAYTERM_OU |
numeric(10) |
NULL |
This field holds the OU Instance of the Pay Term Component |
No |
No |
|
|||
|
LOCMS_PAYTERM_CODE |
varchar(25) |
NULL |
This field holds the Agreed pay terms between the Supplier and Purchaser which will be defined for the Supplier at the ordering OU level. The code that identifies the payment term - Quick codes |
No |
No |
|
|||
|
LOCMS_CURRENCY |
varchar(20) |
NULL |
This field holds the Currency for this location |
No |
No |
|
|||
|
LOCMS_INV_OU_ID |
numeric(10) |
NULL |
This field Corresponds to OU Instance ID in the invoicing component. |
No |
No |
|
|||
|
LOCMS_IN_SHIP_BY |
varchar(25) |
NULL |
This field holds the Inbound shipping method of supplier registered in the location |
No |
No |
|
|||
|
LOCMS_IN_SHIP_COST |
varchar(25) |
NULL |
this field holds the inbound shipping cost of the supplier registered in the location |
No |
No |
|
|||
|
LOCMS_IN_PKG_CODE |
varchar(25) |
NULL |
This field holds the inbound packaging code of the supplier registered in the location |
No |
No |
|
|||
|
LOCMS_IN_INS_LTY |
varchar(5) |
NULL |
This field holds Inbound shipping info insurance liability of the supplier registered in the location with the values 1. ’N’ - None, 2. ’S’ - Self, 3. ’SP’ -  Supplier’s. |
No |
No |
|
|||
|
LOCMS_OUT_SHIP_BY |
varchar(25) |
NULL |
This field holds the Outbound shipping method of supplier registered in the location |
No |
No |
|
|||
|
LOCMS_OUT_SHIP_COST |
varchar(25) |
NULL |
this field holds the outbound shipping cost of the supplier registered in the location |
No |
No |
|
|||
|
LOCMS_OUT_PKG_CODE |
varchar(25) |
NULL |
This field holds the outbound packaging code of the supplier registered in the location |
No |
No |
|
|||
|
LOCMS_OUT_INS_LTY |
varchar(5) |
NULL |
This field holds the outbound insurance liability of the supplier registered in the location |
No |
No |
|
|||
|
LOCMS_CREATED_BY |
varchar(30) |
NULL |
This field holds the User who has created the record. |
No |
No |
|
|||
|
LOCMS_CREATED_DATE |
datetime |
NULL |
This field holds the created date of the record |
No |
No |
|
|||
|
LOCMS_MODIFIED_BY |
varchar(30) |
NULL |
This field holds the User who modified the record. |
No |
No |
|
|||
|
LOCMS_MODIFIED_DATE |
datetime |
NULL |
This field holds the modified date of the user record |
No |
No |
|
|||
|
LOCMS_TIMESTAMP |
numeric(10) |
NULL |
This field holds the Timestamp of a record. |
No |
No |
|
|||
|
LOCMS_USER_ID |
varchar(30) |
NULL |
This field holds stores the User name captured |
No |
No |
|
|||
|
LOCMS_HOLDBUY |
varchar(1) |
NULL |
To save the value of 'Hold Buy' |
No |
No |
|
|||
|
LOCMS_HOLDPAY |
varchar(1) |
NULL |
To save the value of 'Hold Pay' |
No |
No |
|
|||
|
LOCMS_HOLDREPAIR |
varchar(1) |
NULL |
To save the value of 'Hold Repair' |
No |
No |
|
|||
|
|
|||||||||
|
Table Name SP_LOCPT_PART_LEVEL_TCD |
|
||||||||
|
|
|||||||||
|
Table Comment This contains TC & D attached to Parts at location level |
|
||||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|||
|
LOCPT_TCD_VAR_NO |
varchar(25) |
NULL |
This field holds the TCD Variant Number associated to part of supplier |
No |
No |
|
|||
|
LOCPT_TCD_NO |
varchar(25) |
NULL |
This field holds the TCD Number associated to part of supplier |
No |
No |
|
|||
|
LOCPT_PRT_OUINSTANCE |
numeric(10) |
NULL |
This field is to capture OU instance of Part admin component |
No |
No |
|
|||
|
LOCPT_MODIFIED_BY |
varchar(30) |
NULL |
This field holds the user who Modified the record |
No |
No |
|
|||
|
LOCPT_CREATED_BY |
varchar(30) |
NULL |
This field holds the user who created the record |
No |
No |
|
|||
|
LOCPT_CREATED_DATE |
datetime |
NULL |
This field holds the Created Date of the record |
No |
No |
|
|||
|
LOCPT_MODIFIED_DATE |
datetime |
NULL |
This field holds the Modified Date of the record |
No |
No |
|
|||
|
LOCPT_SUPPLIER_ID |
varchar(45) |
NOT NULL |
To define supplier code unique at Company level or Organization unit level |
Yes |
Yes |
|
|||
|
LOCPT_OUINSTANCE |
numeric(10) |
NOT NULL |
This field is to define location code unique at Organization unit level |
Yes |
Yes |
|
|||
|
LOCPT_TCD_OUINSTANCE |
numeric(10) |
NULL |
This field is to capture OU instance of TCD component |
No |
No |
|
|||
|
LOCPT_LINE_NO |
numeric(10) |
NOT NULL |
This field holds the line no of the record |
Yes |
No |
|
|||
|
LOCPT_CREATED_OUINSTANCE |
numeric(10) |
NOT NULL |
To specify the OU instance at which the Supplier was created. |
Yes |
Yes |
|
|||
|
LOCPT_PART_NO |
varchar(40) |
NOT NULL |
This field holds the part no mapped to supplier |
Yes |
No |
|
|||
|
|
|||||||||
|
Table Name SP_LOCPY_PAY_SUPP_INFO |
|
||||||||
|
|
|||||||||
|
Table Comment Contains information about which Supplier has to be Paid for a particular location. This is at the Location level |
| ||||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|||
|
LOCPY_OUINSTANCE |
numeric(10) |
NOT NULL |
This field is to define location code unique at Organization unit level |
Yes |
Yes |
|
|||
|
LOCPY_SUPPLIER_ID |
varchar(45) |
NOT NULL |
To define supplier code unique at Company level or Organization unit level |
Yes |
Yes |
|
|||
|
LOCPY_CREATED_OUINSTANCE |
numeric(10) |
NOT NULL |
To specify the OU instance at which the Supplier was created. |
Yes |
Yes |
|
|||
|
LOCPY_LINE_NO |
numeric(10) |
NOT NULL |
This field holds the Line Number of pay-to-supplier id |
Yes |
No |
|
|||
|
LOCPY_PAY_SUPP_ID |
varchar(45) |
NULL |
This field holds the Supplier ID to whom the payment is going to be made |
No |
No |
|
|||
|
LOCPY_DEFAULT_SUPP |
varchar(25) |
NULL |
This field is to state Whether the pay to Supplier is the Default one or not |
No |
No |
|
|||
|
LOCPY_CREATED_BY |
varchar(30) |
NULL |
This field holds the user who created the record |
No |
No |
|
|||
|
LOCPY_CREATED_DATE |
datetime |
NULL |
This field holds the created date of the record |
No |
No |
|
|||
|
LOCPY_MODIFIED_BY |
varchar(30) |
NULL |
This field holds the user who modified the record |
No |
No |
|
|||
|
LOCPY_MODIFIED_DATE |
datetime |
NULL |
This field holds the Modified Date of the record |
No |
No |
|
|||
|
LOCPY_TIMESTAMP |
numeric(10) |
NULL |
This field holds the timestamp so that more than one user cant modified same record in the same time |
No |
No |
|
|||
|
|
|||||||||
|
Table Name SP_MPPRT_PRTS_SERV |
|
||||||||
|
|
|||||||||
|
Table Comment THis table contains Mapping Parts to Services with Ceritifcations |
|
||||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|||
|
MPPRT_CERTI_NO |
varchar(20) |
NOT NULL |
This field holds the Certificate Number |
Yes |
Yes |
|
|||
|
MPPRT_SUPPLIER_ID |
varchar(10) |
NOT NULL |
To define supplier code unique at Company level or Organization unit level |
Yes |
Yes |
|
|||
|
MPPRT_CREATED_OUINSTANCE |
numeric(10) |
NOT NULL |
To specify the OU instance at which the Supplier was created. |
Yes |
Yes |
|
|||
|
MPPRT_PART_ID |
numeric(10) |
NOT NULL |
This field holds the uniquely generated part id |
Yes |
No |
|
|||
|
MPPRT_RPR_PRCS_NO |
varchar(25) |
NOT NULL |
This field holds Repair Process Code of the part for the supplier |
Yes |
Yes |
|
|||
|
MPPRT_PART_NO |
varchar(40) |
NULL |
This field holds the Part No |
No |
No |
|
|||
|
MPPRT_STD_COST |
numeric(28,8) |
NULL |
This field holds the Standard Cost |
No |
No |
|
|||
|
MPPRT_AVG_LDTIME |
numeric(28,8) |
NULL |
This field holds the Average Lead Time |
No |
No |
|
|||
|
MPPRT_LDTIME_UOM |
varchar(10) |
NULL |
This field holds the Lead Time Unit of measure with the values 1.’D’ - Days, 2 ’W’ - Weeks, 3.’M’ - Months and 4.’B’ - ’ ’ |
No |
No |
|
|||
|
MPPRT_CREATED_BY |
varchar(30) |
NULL |
This field holds the user who created the record |
No |
No |
|
|||
|
MPPRT_CREATED_DATE |
datetime |
NULL |
This field holds the created date of the record |
No |
No |
|
|||
|
MPPRT_MODIFIED_BY |
varchar(30) |
NULL |
This field holds the user who modified the record |
No |
No |
|
|||
|
MPPRT_MODIFIED_DATE |
datetime |
NULL |
This field holds the modified date of the record |
No |
No |
|
|||
|
MPPRT_Under_CONTRACT |
char(5) |
NULL |
|
No |
No |
|
|||
|
MPPRT_ContractNo |
varchar(40) |
NULL |
This field holds the Contract No of the part for the supplier. |
No |
No |
|
|||
|
MPPRT_ContractDate |
datetime |
NULL |
This field holds the Contract Date of the part for the supplier. |
No |
No |
|
|||
|
MPPRT_CERTI_TYPE |
varchar(25) |
NULL |
This field holds the Certificate type of the part for the supplier. |
No |
No |
|
|||
|
MPPRT_EFFECT_TODATE |
datetime |
NOT NULL |
This field holds the Effective To date of the part for the supplier. |
No |
No |
|
|||
|
MPPRT_EFFECT_FRMDATE |
datetime |
NULL |
|
No |
No |
|
|||
|
MPPRT_CONTRACT_INFO |
varchar(255) |
NULL |
This field holds the Contract info of the part for the supplier. |
No |
No |
|
|||
|
MPPRT_REMARKS |
varchar(255) |
NULL |
|
No |
No |
|
|||
|
MPPRT_FILE_NAME |
varchar(50) |
NULL |
This field holds the File name of the part for the supplier. |
No |
No |
|
|||
|
MPPRT_SHIP_LEAD_TIME |
numeric(13) |
NULL |
This field holds the Ship lead time of the part for the supplier. |
No |
No |
|
|||
|
|
|||||||||
|
Table Name SP_Parameter_Details |
|
||||||||
|
|
|||||||||
|
Table Comment This field holds the supplier parameter details |
|
||||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|||
|
SP_ComponentName |
varchar(20) |
NOT NULL |
This field holds the Name of the component. |
Yes |
No |
|
|||
|
SP_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. |
Yes |
No |
|
|||
|
SP_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. |
Yes |
No |
|
|||
|
SP_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. |
Yes |
No |
|
|||
|
SP_LangId |
numeric(10) |
NOT NULL |
Language id. This is the language id of the record. |
Yes |
No |
|
|||
|
SP_ParamDesc |
varchar(80) |
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 |
No |
No |
|
|||
|
SP_Sortby |
numeric(10) |
NULL |
This field holds the default sort by code |
No |
No |
|
|||
|
SP_CreationDate |
datetime |
NULL |
This field holds the record created date for auditing purpose. |
No |
No |
|
|||
|
|
|||||||||
|
Table Name SP_RPRSP_SP_RSP_MAP |
|
||||||||
|
|
|||||||||
|
Table Comment Repair Shop Mapping Services - Certification Details |
|
||||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|||
|
RPRSP_CREATED_DATE |
datetime |
NULL |
This field holds the Created date of the record |
No |
No |
|
|||
|
RPRSP_CREATED_BY |
varchar(30) |
|
This field holds the user who created the record |
|
|
|
|||
|
RPRSP_MODIFIED_BY |
|
|
This field is to store the user who modified the record |
|
|
|
|||
|
RPRSP_MODIFIED_DATE |
datetime |
|
This field is to store the Modified date |
|
|
|
|||
|
SP_SORTBY |
numeric(10) |
|
This field holds the default sort by code |
|
|
|
|||
|
RPRSP_SUPPLIER_ID |
varchar(45) |
NOT NULL |
To define supplier code unique at Company level or Organization unit level |
Yes |
Yes |
|
|||
|
RPRSP_CERTIFIED |
varchar(25) |
NULL |
This field is set to yes if certified else no |
No |
No |
|
|||
|
RPRSP_CREATED_OUINSTANCE |
numeric(10) |
NOT NULL |
To specify the OU instance at which the Supplier was created. |
Yes |
Yes |
|
|||
|
RPRSP_RPR_PRCS_NO |
varchar(25) |
|
This field holds Repair Process Code of the part for the supplier |
|
No |
|
|||
|
|
|||||||||
|
Table Name SP_SBank_Sup_Bank_Info |
|
||||||||
|
|
|||||||||
|
Table Comment This contains supplier bank information |
|
||||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|||
|
SBank_OUINSTANCE |
decimal(10) |
NOT NULL |
This field is to define location code unique at Organization unit level |
No |
Yes |
|
|||
|
SBank_SUPPLIER_ID |
varchar |
|
To define supplier code unique at Company level or Organization unit level |
|
|
|
|||
|
SBank_CREATED_OUINSTANCE |
numeric(10) |
|
To specify the OU instance at which the Supplier was created. |
|
|
|
|||
|
SBank_Line_No |
int |
|
This field holds Line Number of the Bank information attached to supplier |
|
No |
|
|||
|
SBank_Pay_Ref_id |
varchar() |
NULL |
This field holds Preference id of the bank information |
|
|
|
|||
|
SBank_Pay_Mode |
char(5) |
|
This field holds Pay mode of the Bank |
|
|
|
|||
|
SBank_Bank_Type |
varchar() |
|
This field holds Type of the Bank |
|
|
|
|||
|
SBank_Currency |
|
|
This field holds Currency which used for the bank transaction |
|
|
|
|||
|
SBank_Bank_AC_No |
|
|
This field holds Payee a/c no |
|
|
|
|||
|
SBank_IBAN_No |
|
|
This field holds IBAN No |
|
|
|
|||
|
SBank_Swift_No |
|
|
This field holds swift No |
|
|
|
|||
|
SBank_Nat_Clear_Code |
|
|
This field holds national clearance code. |
|
|
|
|||
|
SBank_Bank_Name |
|
|
This field holds the bank name |
|
|
|
|||
|
SBank_Bank_Address1 |
|
|
This field holds the bank address1 |
|
|
|
|||
|
SBank_Bank_Address2 |
|
|
This field holds the bank address2 |
|
|
|
|||
|
SBank_Bank_Address3 |
|
|
This field holds the bank address3 |
|
|
|
|||
|
SBank_Eff_Date_From |
datetime |
|
This field holds the effective from date of the bank information |
|
|
|
|||
|
SBank_Eff_Date_To |
|
|
This field holds the effective to date of the bank information |
|
|
|
|||
|
SBank_Comments |
varchar |
|
This field holds the additional information/ comments regarding the bank information |
|
|
|
|||
|
SBank_Timestamp |
int |
|
This field holds Timestamp of a record. |
|
|
|
|||
|
|
|||||||||
|
Table Name SP_SPAGR_PBHAGREE_DTLS |
|
||||||||
|
|
|||||||||
|
Table Comment This Supplier table contains the information about the Agreement Details of the Supplier. |
|
||||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|||
|
SPAGR_SUPPLIER_ID |
varchar(45) |
NOT NULL |
To define supplier code unique at Company level or Organization unit level |
Yes |
Yes |
|
|||
|
SPAGR_CREATED_OUINSTANCE |
numeric(10) |
|
To specify the OU instance at which the Supplier was created. |
|
|
|
|||
|
SPAGR_AGREEMENT_NO |
varchar(18) |
|
To hold the Agreement number for a particular supplier. |
|
No |
|
|||
|
SPAGR_AGREE_SEQ_NO |
decimal(38) |
|
This field holds the Sequence number of the agreements mapped to the supplier. |
|
|
|
|||
|
SPAGR_AGREEMENT_DATE |
datetime |
NULL |
The field holds the agreement date of the agreement number for a particular supplier. |
No |
|
|
|||
|
SPAGR_EFFROM_DATE |
|
|
The field holds the date from which the Agreement is applicable for a Supplier. |
|
|
|
|||
|
SPAGR_EFTO_DATE |
|
|
This field holds the To date of the agreement number for a particular supplier. |
|
|
|
|||
|
SPAGR_PBH_ON |
varchar(25) |
|
The field holds if the agreement is power by hour on the supplier. |
|
|
|
|||
|
SPAGR_CONTRT_DEDUCTIBLE |
numeric(28) |
NOT NULL |
This field holds the contract amount of the agreement for a particular supplier |
|
|
|
|||
|
SPAGR_CURRENCY |
varchar(18) |
NULL |
This field holds specifies the contract amount currency for an agreement. |
|
|
|
|||
|
SPAGR_REV_NO |
varchar(20) |
|
This field holds specifies the Revision number of the Agreement for a particular supplier. |
|
|
|
|||
|
SPAGR_REV_DATE |
datetime |
|
This fields holds the Revision date of the Agreement for a particular supplier. |
|
|
|
|||
|
SPAGR_CREATED_BY |
varchar(15) |
|
This field holds the user who created the record |
|
|
|
|||
|
SPAGR_CREATED_DATE |
datetime |
|
This field holds the created date of the record |
|
|
|
|||
|
SPAGR_MODIFIED_BY |
varchar(15) |
|
This field holds the user who modified  the record |
|
|
|
|||
|
SPAGR_MODIFIED_DATE |
datetime |
|
This field holds the modified date of the record |
|
|
|
|||
|
|
|||||||||
|
Table Name SP_SPPBH_PBH_ACMAP |
|
||||||||
|
|
|||||||||
|
Table Comment This Table Contains the PBH Mapping for an Agreement of a particular Supplier. |
|
||||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|||
|
SPACPBH_AC_UNDER_PBH |
varchar(5) |
NULL |
This field holds the value ’Y’ --’Yes’ and ’N’-- ’No’ which indicates whether the Aircraft is under PBH or not |
No |
No |
|
|||
|
SPACPBH_MANU_SRL_NO |
varchar(30) |
|
This field holds the Manufacturer Serial no of the Aircraft. |
|
|
|
|||
|
SPACPBH_LINE_ID |
decimal(38) |
|
This field holds the unique line id for the various Aircraft information. |
|
|
|
|||
|
SPACPBH_MODIFIED_BY |
varchar(15) |
|
This field holds the modified user information. |
|
|
|
|||
|
SPACPBH_CREATED_BY |
|
|
This field holds the created user information of the Aircraft PBH. |
|
|
|
|||
|
SPACPBH_CREATED_DT |
datetime |
|
This field holds created Date information of the Aircraft PBH. |
|
|
|
|||
|
SPACPBH_MODIFIED_DT |
|
|
This field holds the modified date information of the Aircraft PBH. |
|
|
|
|||
|
SPACPBH_CREATED_OUINSTANCE |
numeric(10) |
NOT NULL |
To specify the OU instance at which the Supplier was created. |
Yes |
Yes |
|
|||
|
SPACPBH_AGREEMENT_NO |
varchar(18) |
|
To hold the Agreement number for a particular supplier. |
|
|
|
|||
|
SPACPBH_SUPPLIER_ID |
varchar(45) |
|
To define supplier code unique at Company level or Organization unit level |
|
|
|
|||
|
SPACPBH_PBH_ON |
varchar(25) |
NULL |
This field holds the Power by hour as Aircraft. |
No |
No |
|
|||
|
SPACPBH_AC_REG_NO |
varchar(20) |
NOT NULL |
This holds the Aircraft Registration number. |
Yes |
|
|
|||
|
SPAGR_AGREE_SEQ_NO |
int |
|
This field holds the Sequence number of the agreements mapped to the supplier. |
|
Yes |
|
|||
|
SPACPBH_MODEL_NO |
varchar(20) |
|
This field holds the model number of the Aircraft. |
|
No |
|
|||
|
|
|||||||||
|
Table Name SP_SPPBH_PBH_PRTMAP |
|
||||||||
|
|
|||||||||
|
Table Comment To Store the Supplier Part and Agreement Details. |
|
||||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|||
|
SPPRTPBH_PRT_AC_NO |
varchar(20) |
NULL |
This has the Part, Aircraft Registration Number |
No |
No |
|
|||
|
SPPRTPBH_PRT_WAREHOUSE |
|
|
This has the Warehouse of the Part. |
|
|
|
|||
|
SPPRTPBH_STCK_STATUS |
varchar(60) |
|
This has the Stock Status of the Part. |
|
|
|
|||
|
SPPRTPBH_PRT_CONDT |
varchar(20) |
|
This has the Part condition on which the PBH is enforced. |
|
|
|
|||
|
SPPRTPBH_COMP_ID |
varchar(90) |
|
This field holds the Component ID of the Component mapped to the supplier |
|
|
|
|||
|
SPPRTPBH_MODIFIED_BY |
varchar(30) |
|
This field has the modified User information. |
|
|
|
|||
|
SPPRTPBH_PRT_UNDER_PBH |
varchar(5) |
|
This has the Under PBH value as ’Y’--’Yes’ and ’N’ --’No’ for enforcing the PBH on Part. |
|
|
|
|||
|
SPPRTPBH_CREATED_DT |
datetime |
|
This has the created date information. |
|
|
|
|||
|
SPPRTPBH_CREATED_BY |
varchar(30) |
|
This has the created user information. |
|
|
|
|||
|
SPPRTPBH_MODIFIED_DT |
datetime |
|
This field has the modified date information. |
|
|
|
|||
|
SPPRTPBH_SUPPLIER_ID |
varchar(45) |
NOT NULL |
To define supplier code unique at Company level or Organization unit level |
Yes |
Yes |
|
|||
|
SPPRTPBH_CREATED_OUINSTANCE |
numeric(10) |
|
To specify the OU instance at which the Supplier was created. |
|
|
|
|||
|
SPPRTPBH_PRT_SRL_NO |
varchar(30) |
|
This hold the Part Serial Number information. |
|
No |
|
|||
|
SPPRTPBH_PRT_NO |
varchar(32) |
|
This holds the Part no on which the PbH is enforced. |
|
|
|
|||
|
SPPRTPBH_COMP_OU |
numeric(10) |
NULL |
This field holds the Component OU of the Component mapped to the supplier |
No |
|
|
|||
|
SPPRTPBH_PRT_OU |
|
|
This field holds the Part OU of the Part mapped to the supplier |
|
|
|
|||
|
SPPRTPBH_PRT_LINE_ID |
|
|
This holds the sequence of the Part Numbers |
|
|
|
|||
|
SPAGR_AGREE_SEQ_NO |
int |
NOT NULL |
This field holds the Sequence number of the agreements mapped to the supplier. |
Yes |
Yes |
|
|||
|
SPPRTPBH_PBH_ON |
varchar(5) |
NULL |
This hold the Pbh value as ’E’--Engine or ’A’ -- Aircraft or ’O’--Others to show whether the Power by hour is for an engine or for others. |
No |
No |
|
|||
|
SPPRTPBH_AGREEMENT_NO |
varchar(18) |
NOT NULL |
To hold the Agreement number for a particular supplier. |
Yes |
Yes |
|
|||
|
|
|||||||||
|
Table Name SP_SPROd_Ref_Obj_dtl |
|
||||||||
|
|
|||||||||
|
Table Comment This table holds the supplier reference object details |
|
||||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|||
|
SPROd_Created_Date |
datetime |
NULL |
This field holds the created date of the record |
No |
No |
|
|||
|
SPROd_Ref_Doc_File_Name |
varchar(50) |
|
This field holds the reference document file name |
|
|
|
|||
|
SPROd_Created_By |
varchar(30) |
|
This field holds the user who created the record |
|
|
|
|||
|
SPROd_Modified_Date |
datetime |
|
This field holds the modified date of the record |
|
|
|
|||
|
SPROd_Modified_By |
varchar(30) |
|
This field holds the user who modified the record |
|
|
|
|||
|
SPROd_CREATED_OUINSTANCE |
numeric(10) |
NOT NULL |
To specify the OU instance at which the Supplier was created. |
Yes |
Yes |
|
|||
|
SPROd_SUPPLIER_ID |
varchar(45) |
|
To define supplier code unique at Company level or Organization unit level |
|
|
|
|||
|
SPROd_Ref_Doc_Id |
varchar(20) |
NULL |
The field holds the reference document id of the supplier |
No |
No |
|
|||
|
SPROd_Doc_Line_Id |
numeric(10) |
NOT NULL |
This is uniquely generated document line id |
Yes |
|
|
|||
|
SPROd_Ref_Doc_Type |
varchar(25) |
NULL |
This field holds the reference document type of the supplier |
No |
|
|
|||
|
|
|||||||||
|
Table Name SP_SPRTM_PARTS_MAP |
|
||||||||
|
|
|||||||||
|
Table Comment This contains the Supplier - Part Mapping infos |
|
||||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|||
|
SPRTM_SUPPLIER_ID |
varchar(45) |
NOT NULL |
To define supplier code unique at Company level or Organization unit level |
Yes |
Yes |
|
|||
|
SPRTM_PRT_NO |
varchar(40) |
|
This field holds the Part No mapped to the supplier |
|
No |
|
|||
|
SPRTM_CREATED_OUINSTANCE |
numeric(10) |
|
To specify the OU instance at which the Supplier was created. |
|
Yes |
|
|||
|
SPRTM_PRT_OUINSTANCE |
|
|
This field is to specify the OU Instance of Part mapped to the supplier |
No |
No |
|
|||
|
SPRTM_PRT_SEQNO |
|
|
This field holds the Sequence Number of the parts mapped to the supplier |
|
|
|
|||
|
SPRTM_PRT_PURC_UOM |
varchar(10) |
|
This field holds the purchase UOM of the part mapped to the supplier |
|
|
|
|||
|
SPRTM_PRT_COST |
numeric(28,8) |
NULL |
This field is to capture the Cost of part mapped to the supplier |
|
|
|
|||
|
SPRTM_PRT_COSTPER |
|
|
This field is to capture the cost per of the part mapped to the supplier |
|
|
|
|||
|
SPRTM_PRT_INSPEC_TYPE |
varchar(25) |
NOT NULL |
This field holds the Inspection type of the part mapped to the supplier Values stored will be Blank None Self By Inspector |
|
|
|
|||
|
SPRTM_PRT_MATCH_TYPE |
|
NULL |
This field holds the matching type of the part mapped to the supplier Values stored will be Blank Four Way at GR Four Way at PO Three Way at GR Three Way at PO Two Way |
|
|
|
|||
|
SPRTM_PRT_TOLREN_TYPE |
|
NOT NULL |
This field holds the tolerance type of the part mapped to the supplier Values stored will be None Quantity Value Both |
|
|
|
|||
|
SPRTM_TOLREN_PERC |
numeric(28,8) |
NULL |
This field holds the tolerance percentage of the part mapped to the supplier |
|
|
|
|||
|
SPRTM_PRT_SUPP_REF |
varchar(40) |
|
This field holds the preference of the part mapped to the supplier |
|
|
|
|||
|
SPRTM_PRT_SUPP_DESC |
varchar(150) |
|
This field holds the preference of the part description mapped to the supplier |
|
|
|
|||
|
SPRTM_DIS_PUR_LEAD_TIME |
numeric(28,8) |
|
This field holds the Purchase lead time - for display only |
|
|
|
|||
|
SPRTM_PUR_LEAD_TIME |
|
|
This field holds the Purchase lead time |
|
|
|
|||
|
SPRTM_PRT_LEAD_UOM |
varchar(10) |
|
This field holds the Purchase lead UOM |
|
|
|
|||
|
SPRTM_CREATED_BY |
varchar(30) |
NOT NULL |
This field holds the user who created the record |
|
|
|
|||
|
SPRTM_CREATED_DATE |
datetime |
NULL |
This field holds the created date of the record |
|
|
|
|||
|
SPRTM_MODIFIED_DATE |
|
|
This field holds the modified date of the record |
|
|
|
|||
|
SPRTM_MODIFIED_BY |
varchar(30) |
NOT NULL |
This field holds the user who modified the record |
|
|
|
|||
|
SPRTM_UNDER_PBH |
varchar(25) |
NULL |
This field holds the flag for Supplier-part PBH ’Y’ - ’Yes’ ’N’ - ’No’ |
|
|
|
|||
|
SPRTM_MIN_ORD_Qty |
numeric(13) |
|
This field is to capture the Minimum order qty of part in the supplier. |
|
|
|
|||
|
SPRTM_MIN_ORD_VALUE |
|
|
This field is to capture the Minimum order value of the part in the supplier. |
|
|
|
|||
|
SPRTM_EXCHG_CONTRACT |
varchar(5) |
|
This field is to capture the Exchange contract information for a part for a supplier. |
|
|
|
|||
|
SPRTM_PBOREP_MODE |
|
|
This field is to capture the mode of replenishment desired for a PBH part for a supplier. This combo is loaded with 1.blank 2.PBH PO 3.PBH Exchange PO |
|
|
|
|||
|
SPRTM_PBOREP_ACTION |
|
|
This field is to capture the replenishment action desired for a PBH part for a supplier. This combo is loaded with 1.Manual |
|
|
|
|||
|
SPRTM_COST_BASIS |
varchar(40) |
|
This field is to capture the cost basis for a supplier part. This combo is loaded with 1.Blank 2.User defined Quick Code. |
|
|
|
|||
|
SPRTM_EFFECT_FRMDATE |
datetime |
|
This field is to capture the Effective from date of a part for a supplier. |
|
|
|
|||
|
SPRTM_EFFECT_TODATE |
|
|
This field is to capture the Effective to date of a part for a supplier. |
|
|
|
|||
|
SPRTM_REMARKS |
varchar(255) |
|
This field is to capture the remarks of a part information for a supplier. |
|
|
|
|||
|
|
|||||||||
|
Table Name SP_STCD_TaxReg_dtl |
|
||||||||
|
|
|||||||||
|
Table Comment This table contains contact information for supplier Locations |
|
||||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|||
|
LOCCP_MOBILE_NO |
varchar(70) |
NULL |
This field is to capture Contact Person’s Mobile No. |
No |
No |
|
|||
|
LOCCP_PHONE_NO |
|
|
This field is to capture Contact Person’s Phone NO. |
|
|
|
|||
|
LOCCP_FAX |
|
|
This field holds the Contact Person’s Fax No. |
|
|
|
|||
|
LOCCP_EMAIL_ID |
|
|
This field holds the Contact Person’s email id |
|
|
|
|||
|
LOCCP_MODIFIED_BY |
varchar(30) |
|
This field is to capture the user who modified the record |
|
|
|
|||
|
LOCCP_CREATED_BY |
|
|
This field is to capture the user who created the record |
|
|
|
|||
|
LOCCP_CREATED_DATE |
datetime |
|
This field holds the created date of the record |
|
|
|
|||
|
LOCCP_MODIFIED_DATE |
|
|
This field is to capture the modified date of the record |
|
|
|
|||
|
LOCCP_SUPPLIER_ID |
varchar(45) |
NOT NULL |
To define supplier code unique at Company level or Organization unit level |
Yes |
Yes |
|
|||
|
LOCCP_CREATED_OUINSTANCE |
numeric(10) |
|
To specify the OU instance at which the Supplier was created. |
|
|
|
|||
|
LOCCP_OUINSTANCE |
|
|
This field is to define location code unique at Organization unit level |
|
|
|
|||
|
LOCCP_CONTACT_PERSON_UP |
varchar(80) |
NULL |
This field holds the contact person in upper case as specified in the Supplier Master Table |
No |
No |
|
|||
|
LOCCP_CONTACT_PERSON |
|
|
This field holds the contact person as specified in the Supplier Master Table |
|
|
|
|||
|
LOCCP_LINE_NO |
numeric(10) |
NOT NULL |
This field holds the line no of the supplier |
Yes |
|
|
|||
|
LOCCP_ADDRESSID |
|
NULL |
This field holds the Address Id as specified in the Supplier Master Table |
No |
|
|
|||
|
|
|||||||||
|
Table Name SP_STCDM_TCD_MAP |
|
||||||||
|
|
|||||||||
|
Table Comment This contains information about TC&Ds attached to Suppliers |
|
||||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|||
|
STCDM_MODIFIED_BY |
varchar(30) |
NOT NULL |
This field holds the user who modified the record |
No |
No |
|
|||
|
STCDM_CREATED_BY |
|
|
This field holds the User’s Name who created this record |
|
|
|
|||
|
STCDM_TCD_VAR |
varchar(25) |
|
This field holds the TCD Variant Number of the supplier |
|
|
|
|||
|
STCDM_TIMESTAMP |
numeric(10) |
|
This field holds the timestamp so that more than one user cant modified same record in the same time |
|
|
|
|||
|
STCDM_CREATED_DATE |
datetime |
NULL |
This field holds the created date of the record |
|
|
|
|||
|
STCDM_MODIFIED_DATE |
|
|
This field holds the modified Date of the record |
|
|
|
|||
|
STCDM_CREATED_OUINSTANCE |
numeric(10) |
NOT NULL |
To specify the OU instance at which the Supplier was created. |
Yes |
Yes |
|
|||
|
STCDM_SUPPLIER_ID |
varchar(45) |
|
To define supplier code unique at Company level or Organization unit level |
|
|
|
|||
|
STCDM_TCD_DESC |
varchar(80) |
|
This field holds the description of the TCD mapped to the supplier |
No |
No |
|
|||
|
STCDM_TCD_OUINSTANCE |
numeric(10) |
|
This field holds the TCD ou instance of the supplier |
|
|
|
|||
|
STCDM_LINE_NO |
|
|
This field holds Line Number of the TCDs attached to supplier |
Yes |
|
|
|||
|
STCDM_TCD_CODE |
varchar(25) |
|
This field holds the TCD Code of the supplier |
No |
|
|
|||
|
|
|||||||||
|
Table Name SP_STDD_Tax_Default_Dtl |
|
||||||||
|
|
|||||||||
|
Table Comment Default Tax # / Tax Variant # will be used for Invoicing. This has been maintained as a separate table for future enhancements. |
|||||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|||
|
STDD_OUInstance |
decimal |
NOT NULL |
This field is to define location code unique at Organization unit level |
Yes |
No |
|
|||
|
STDD_Supplier_ID |
varchar(20) |
|
To define supplier code unique at Company level or Organization unit level |
|
|
|
|||
|
STDD_Tax_Code |
varchar() |
|
This field holds the default Tax # which can be used for Invoicing |
No |
|
|
|||
|
STDD_TaxVariant_No |
|
|
This field holds the Tax Variant # which will be used for Invoicing |
|
|
|
|||
|
STDD_Created_By |
|
NULL |
This field holds the name of the user who created the record |
|
|
|
|||
|
STDD_Created_Date |
datetime |
|
This field holds the created date of the record |
|
|
|
|||
|
STDD_Modified_By |
varchar() |
|
This field holds the last modified user of the record |
|
|
|
|||
|
STDD_Modified_Date |
char(18) |
|
This field holds the last modified date of the record |
|
|
|
|||
|
|
|||||||||
|
Table Name SP_STRD_Tax_Registration_Dtl |
|
||||||||
|
|
|||||||||
|
Table Comment To store the address id, Tax Type and Registration # details for Invoicing reports |
|
||||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|||
|
STRD_OUInstance |
int |
NOT NULL |
This field is to define location code unique at Organization unit level |
Yes |
No |
|
|||
|
STRD_Supplier_ID |
varchar(20) |
|
This is used to store the Supplier No |
|
|
|
|||
|
STRD_Line_No |
decimal |
|
This column is used to save the Line ID of the multiline from which the Address ID,Tax Type and Registration No is stored |
No |
|
|
|||
|
STRD_Address_ID |
int |
|
This is used to store the Address Id of the Supplier No |
|
|
|
|||
|
STRD_Tax_Type |
varchar() |
|
This is used to store the Tax Type of the Supplier No. |
|
|
|
|||
|
STRD_Reg_No |
|
|
This is used to store the Registration No for the Supplier No |
|
|
|
|||
|
|
|||||||||
|
Table Name SP_SUPCT_CERTIFICATE |
|
||||||||
|
|
|||||||||
|
Table Comment This contains the certification issued for a supplier |
|
||||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|||
|
SUPCT_CERTI_TO_DATE |
datetime |
NULL |
This field holds the Certificate Valid To Date |
No |
No |
|
|||
|
SUPCT_TIMESTAMP |
numeric(10) |
NOT NULL |
This field holds the timestamp so that more than one user cant modified same record in the same time |
|
|
|
|||
|
SUPCT_MODIFIED_BY |
varchar(30) |
NULL |
This field holds the user who modified the record |
|
|
|
|||
|
SUPCT_MODIFIED_DATE |
datetime |
|
This field holds the modified date of the record |
|
|
|
|||
|
SUPCT_CERTI_FROM_DATE |
|
|
This field holds the Certificate Valid From Date |
|
|
|
|||
|
SUPCT_CREATED_DATE |
|
|
This field holds the created date of the record |
|
|
|
|||
|
SUPCT_CERT_ISSUE_DATE |
|
|
holds the certificate issue date for the supplier |
|
|
|
|||
|
SUPCT_CERTI_NO |
varchar(40) |
NOT NULL |
This field holds the Certificate Number |
Yes |
|
|
|||
|
SUPCT_CREATED_OUINSTANCE |
numeric(10) |
|
To specify the OU instance at which the Supplier was created. |
|
Yes |
|
|||
|
SUPCT_SUPPLIER_ID |
varchar(45) |
|
To define supplier code unique at Company level or Organization unit level |
|
|
|
|||
|
SUPCT_CREATED_BY |
varchar(30) |
|
This field holds the user who created the record |
No |
No |
|
|||
|
SUPCT_CERTI_TYPE |
varchar(25) |
|
This field holds the Type of Certificate |
|
|
|
|||
|
SUPCT_CERTI_OUINSTANCE |
numeric(10) |
|
This field is to specify the OU Instance of Certificate |
|
|
|
|||
|
SUPCT_CERTI_AUCODE |
varchar(25) |
|
This field is to specify the Certificate authentication code |
|
|
|
|||
|
|
|||||||||
|
Table Name SP_SUPDT_CTRL_REF |
|
||||||||
|
|
|||||||||
|
Table Comment This is the Supplier Detail table for the Supplier master containing information about the Supplier addresses etc. |
|
||||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|||
|
SUPDT_COUNTRY_UP |
varchar(40) |
NOT NULL |
This field holds the country of the supplier in upper case |
No |
No |
|
|||
|
SUPDT_SPEC2KCODE |
varchar(5) |
NULL |
This field holds the spec2kcode of the supplier |
|
|
|
|||
|
SUPDT_SITA_ARINCCODE |
varchar(45) |
|
This field holds the SITA/ARINC code of the supplier |
|
|
|
|||
|
SUPDT_COUNTRY |
varchar(40) |
NOT NULL |
This field holds the country of the supplier |
|
|
|
|||
|
SUPDT_STATE_UP |
varchar(32) |
|
This field holds the state of the supplier in upper case |
|
|
|
|||
|
SUPDT_STATE |
|
|
This field holds the state of the supplier |
|
|
|
|||
|
SUPDT_MODIFIED_BY |
varchar(30) |
NULL |
This field holds the User who has modified the record. |
|
|
|
|||
|
SUPDT_CREATED_DATE |
datetime |
|
This field holds the created date of the record |
|
|
|
|||
|
SUPDT_ZIPCODE |
varchar(15) |
NOT NULL |
This field holds the zip code of the supplier |
|
|
|
|||
|
SUPDT_CREATED_BY |
varchar(30) |
|
This field holds the User who has created the record. |
|
|
|
|||
|
SUPDT_ZIPCODE_UP |
varchar(15) |
|
This field holds the zip code of the supplier in upper case |
|
|
|
|||
|
SUPDT_MODIFIED_DATE |
datetime |
NULL |
This field is to store the modified date of the supplier |
|
|
|
|||
|
SUPDT_ADDRESSID |
numeric(10) |
NOT NULL |
This field holds the address id of the each address |
Yes |
|
|
|||
|
SUPDT_PHONE_NO |
varchar(70) |
NULL |
This field holds the Phone no of the supplier |
No |
|
|
|||
|
SUPDT_FAX |
|
|
This field holds the fax of the supplier |
|
|
|
|||
|
SUPDT_CREATED_OUINSTANCE |
numeric(10) |
NOT NULL |
To specify the OU instance at which the Supplier was created. |
Yes |
Yes |
|
|||
|
SUPDT_SUPPLIER_ID |
varchar(45) |
|
To define supplier code unique at Company level or Organization unit level |
|
|
|
|||
|
SUPDT_CITY_UP |
varchar(32) |
|
This field holds the city of the supplier in upper case |
No |
No |
|
|||
|
SUPDT_ADDRESS3 |
varchar(255) |
NULL |
This field holds the address 3 of the supplier |
|
|
|
|||
|
SUPDT_CITY |
varchar(32) |
NOT NULL |
This field holds the city of the supplier |
|
|
|
|||
|
SUPDT_EMAILID |
varchar(70) |
NULL |
This field holds the email id of the supplier |
|
|
|
|||
|
SUPDT_ADDRESS1 |
varchar(255) |
NOT NULL |
This field holds the address 1 of the supplier |
|
|
|
|||
|
SUPDT_ADDRESS2 |
|
NULL |
This field holds the address 2 of the supplier |
|
|
|
|||
|
SUPDT_ADDRESS1_UP |
|
NOT NULL |
This field holds the address 1 of the supplier in upper case |
|
|
|
|||
|
|
|||||||||
|
Table Name SP_SUPMS_CTRL_REF_MSTR |
|
||||||||
|
|
|||||||||
|
Table Comment This is the Supplier Main table. It is control reference.  It holds all the information about the Supplier |
|
||||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|||
|
SUPMS_SUPPLIER_ID |
varchar() |
NOT NULL |
To define supplier code unique at Company level or Organization unit level |
Yes |
No |
|
|||
|
SUPMS_CREATED_OUINSTANCE |
int |
|
To specify the OU instance at which the Supplier was created. |
|
|
|
|||
|
SUPMS_SUPP_NAME |
varchar(150) |
|
This column is used for storing the Description of a supplier |
No |
|
|
|||
|
SUPMS_SUPP_TYPE |
varchar(25) |
|
The type of the Supplier. Either Purchase Vendor or Misc Vendor. ’N’ - ’Normal’ ’M’ - ’Miscellaneous’ ’B’ - ’ ’ |
|
|
|
|||
|
SUPMS_CATEGORY |
|
NULL |
This field holds quick codes of the type category SC - Supplier Category |
|
|
|
|||
|
SUPMS_PAYMODE |
|
NOT NULL |
Agreed Pay mode between the supplier and purchaser will be defined for the Supplier at the company level. The mode of payment.Values - ’C’ - "Cash", ’CQ’ - "Check", ’O’ - "Others", ’DD’ - "Demand Draft" and ’P’ - ’Pay Order’ ’E’ - EFT ’C’ -- Credit Card |
|
|
|
|||
|
SUPMS_PAY_PRIORITY |
|
|
This field holds the pay priority values 1.’H’ - "High", 2. ’N’ - "Normal" and 3. ’L’ - "Low" |
|
|
|
|||
|
SUPMS_PAYTERM_CODE |
|
|
Agreed pay terms between the Supplier and Purchaser will be defined for the Supplier at the company level. The code that identifies the payment term - Quick codes |
|
|
|
|||
|
SUPMS_PAYTERM_OU |
numeric(10) |
NULL |
This field holds the OU of the payterm Component |
|
|
|
|||
|
SUPMS_CURRENCY |
varchar(20) |
NOT NULL |
This field holds the Currency of the supplier |
|
|
|
|||
|
SUPMS_SPEC2KCODE |
varchar(5) |
NULL |
This field holds the SPEC 2000 code |
|
|
|
|||
|
SUPMS_SITAARIN |
varchar(45) |
|
This field holds the SITA/ARINC code |
|
|
|
|||
|
SUPMS_MANUFACT |
varchar(25) |
|
This field is set when the supplier id is of Manufacturer type |
|
|
|
|||
|
SUPMS_REPAIR_AGCY |
|
|
This field is set when the supplier id is of Repair agency type |
|
|
|
|||
|
SUPMS_DISTRIBUTOR |
|
|
This field is set when the supplier id is of distributor type |
|
|
|
|||
|
SUPMS_CREAT_BY |
varchar(30) |
NOT NULL |
This field holds user who has created the record. |
|
|
|
|||
|
SUPMS_MOD_BY |
|
NULL |
This field holds the user who has modified the record. |
|
|
|
|||
|
SUPMS_TIMESTAMP |
numeric(10) |
NOT NULL |
This field holds the timestamp of a record. |
|
|
|
|||
|
SUPMS_CREAT_DATE |
datetime |
NULL |
This field holds user created date the record |
|
|
|
|||
|
SUPMS_MOD_DATE |
|
|
This field holds the user modified date of the record |
|
|
|
|||
|
SUPMS_SUPP_NAME_UP |
varchar(150) |
|
This column is used for storing the description of a supplier in upper case |
|
|
|
|||
|
SUPMS_CURRENCY_UP |
varchar(20) |
|
This field holds the Currency of the supplier in upper case |
|
|
|
|||
|
SUPMS_SPEC2KCODE_UP |
varchar(5) |
|
This field holds the SPEC 2000 code upper case |
|
|
|
|||
|
SUPMS_SITAARIN_UP |
varchar(45) |
|
This field holds the SITA/ARICC code upper case |
|
|
|
|||
|
SUPMS_IN_SHIP_BY |
varchar(25) |
|
This field holds the Inbound shipping method |
|
|
|
|||
|
SUPMS_IN_SHIP_COST |
|
|
this field holds the inbound shipping cost |
|
|
|
|||
|
SUPMS_IN_PKG_CODE |
|
|
This field holds the inbound packaging code |
|
|
|
|||
|
SUPMS_IN_INS_LTY |
varchar(5) |
|
This field holds inbound insurance liability with the following values 1.’N’ - None, 2.’S’ - Self, 3.’SP’ - Supplier’s. |
|
|
|
|||
|
SUPMS_OUT_SHIP_BY |
varchar(25) |
|
This field holds the Outbound shipping method |
|
|
|
|||
|
SUPMS_OUT_SHIP_COST |
|
|
This field holds the outbound shipping cost |
|
|
|
|||
|
SUPMS_OUT_PKG_CODE |
|
|
this field holds the outbound packaging code |
|
|
|
|||
|
SUPMS_OUT_INS_LTY |
varchar(5) |
|
This field holds outbound insurance liability with the following values 1.’N’ - None, 2.’S’ - Self, 3.’SP’ - Supplier’s. |
|
|
|
|||
|
SUPMS_OPERATOR |
varchar(25) |
|
This field holds the value whether the supplier is an operator or not Y - yes N - no |
|
|
|
|||
|
SUPMS_OTHERS |
|
|
This field holds the value whether the supplier is of type others or not Y - yes N - no |
|
|
|
|||
|
SUPMS_PID_ATA_CAGE |
varchar(5) |
|
This field holds the primary identification details of the supplier like ata/cage # |
|
|
|
|||
|
SUPMS_PID_DUNS# |
varchar(25) |
|
This field holds the primary identification details of the supplier like duns # |
|
|
|
|||
|
SUPMS_PID_FSCM# |
varchar(5) |
|
This field holds the primary identification details of the supplier like fscm # |
|
|
|
|||
|
SUPMS_PID_NSCM# |
|
|
This field holds the primary identification details of the supplier like nscm # |
|
|
|
|||
|
SUPMS_PID_COL_ID_AGCY |
varchar |
|
|
|
|
|
|||
|
SUPMS_PID_IDNO |
varchar() |
|
|
|
|
|
|||
|
SUPMS_CUSTOMER# |
sql_variant |
|
This is field holds the customer code for a supplier |
|
|
|
|||
|
SUPMS_SERV_PROV |
|
|
This field holds the flag whether the supplier is service provider or not |
|
|
|
|||
|
SUPMS_SRVC_PROVIDER |
varchar(25) |
|
This field holds the value whether the supplier is an service provider or not Y - yes N - no |
|
|
|
|||
|
SUPMS_SUPPLIER_ACC_GRP |
|
|
This field stores the account group mapped to a supplier |
|
|
|
|||
|
SUPMS_CUSTOMERNO |
|
|
This field stores the customer no |
|
|
|
|||
|
SUPMS_PBH |
|
|
This field holds the value whether the supplier is PBH or not Y - yes N - no |
|
|
|
|||
|
SUPMS_Remarks |
varchar() |
|
This field holds the additional information of the supplier |
|
|
|
|||
|
|
|||||||||
|
Table Name SP_SupQc_Quick_Code |
|
||||||||
|
|
|||||||||
|
Table Comment This table holds the quick code of the supplier |
|
||||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|||
|
SupQc_OUInstance |
varchar(30) |
NOT NULL |
This is the ou instance in which quick code is defined |
Yes |
No |
|
|||
|
SupQc_Quick_Code |
varchar(25) |
|
This field captures the supplier quick code |
|
|
|
|||
|
SupQc_Type |
|
|
This field captures the quick code type of the supplier ’SC’ - ’Supplier Category’ |
|
|
|
|||
|
SupQc_Desc |
varchar(80) |
|
This field holds the description of the supplier |
No |
|
|
|||
|
SupQc_DocStatus |
varchar(15) |
|
This field holds the Status of the supplier 1.Active 2. Inactive |
|
|
|
|||
|
SupQc_CreatedDate |
datetime |
NULL |
This field holds the Created Date of the record |
|
|
|
|||
|
SupQc_Created_By |
varchar(30) |
|
This field holds the user who created the record |
|
|
|
|||
|
SupQc_ModifiedDate |
datetime |
|
This field holds the modified Date of the record |
|
|
|
|||
|
SupQc_Modified_By |
varchar(30) |
|
This field holds the user who modified the record |
|
|
|
|||
|
SupQc_Timestamp |
numeric(10) |
|
This field holds the timestamp so that more than one user cant modified same record in the same time |
|
|
|
|||
|
|
|
|
|
|
|
|
|
|
|