Table Detail Report

VENDOR_PRICE_SCHEDULE



Column Section Top of Page


Table-level Detail

Description: Vendor Price Schedule
Definition: Vendor Price Schedule table
Table Type: REFERENCE





Column Detail - VENDOR_PRICE_SCHEDULE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CREATE_APPLCTX DOUBLE N Application which created this row
CREATE_DT_TM DATETIME N The date/time this entry was created.
CREATE_ID DOUBLE N ID of user who created this row
CREATE_TASK DOUBLE N Task which created this row
DESCRIPTION VARCHAR(100) Y Description of price schedule
PRICE_SCHEDULE_TYPE_CD DOUBLE N Price Schedule type code value
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
VENDOR_CD DOUBLE N Vendor associated with this account
VENDOR_PRICE_SCHEDULE_ID DOUBLE N Primary key


VENDOR_SITE



Column Section Relationship Section Top of Page


Table-level Detail

Description: VENDOR SITE
Definition: Vendor customer account
Table Type: REFERENCE





Column Detail - VENDOR_SITE


Column Name Type Null? Definition
ACCOUNT_NUMBER VARCHAR(40) N Account number
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ASN_IND DOUBLE N Enables the user to identify whethere a vendor site supports ASN or not.
CREATE_APPLCTX DOUBLE N Application which created this row
CREATE_DT_TM DATETIME N The date/time this entry was created.
CREATE_ID DOUBLE N ID of user who created this row
CREATE_TASK DOUBLE N Task which created this row
DESCRIPTION VARCHAR(200) Y Description of account
FREIGHT_TERMS_CD DOUBLE N Freight Terms
PAYMENT_TERMS_CD DOUBLE N Payment terms
PO_PRINT_FORMAT_CD DOUBLE N Purchase Order printing format
PO_TRANSMIT_TYPE_CD DOUBLE N PO Transmission type
RCV_PROFILE_ID DOUBLE Y The receiving profile for the vendor site.
SECONDARY_VENDOR_SITE_ID DOUBLE Y This field has foreign key relation with vendor_site_id from the self table. Alternate vendor site for the same vendor.
SHIP_VIA_CD DOUBLE N Ship Via
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VENDOR_CD DOUBLE N Vendor associated with this account
VENDOR_PRICE_SCHEDULE_ID DOUBLE N Foreign key to price schedule
VENDOR_SITE_ID DOUBLE N Primary Key



Relationship Detail - VENDOR_SITE


Child Column in VENDOR_SITE(FK) Parent Table Name Parent Column Name
Parents: RCV_PROFILE_ID MM_PROFILE PROFILE_ID
SECONDARY_VENDOR_SITE_ID VENDOR_SITE VENDOR_SITE_ID




Parent Column in VENDOR_SITE (PK) Child Table Name Child Column Name
Children: VENDOR_SITE_ID ACQUIREMENT_INFO VENDOR_SITE_ID
INVOICE VENDOR_SITE_ID
PO_BATCH VENDOR_SITE_ID
PURCHASE_ORDER VENDOR_SITE_ID
VENDOR_SITE SECONDARY_VENDOR_SITE_ID
VENDOR_SITE_RESUB_REASON VENDOR_SITE_ID


VENDOR_SITE_RESUB_REASON



Column Section Relationship Section Top of Page


Table-level Detail

Description: Vendor Site Resubmission Reason
Definition: Stores the code values that represent the resubmission reasons for every vendor site.
Table Type: REFERENCE





Column Detail - VENDOR_SITE_RESUB_REASON


Column Name Type Null? Definition
RESUB_REASON_CD DOUBLE Y Reason the purchase order should be resubmitted.
UPDT_APPLCTX DOUBLE Y The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE Y Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE Y The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VENDOR_SITE_ID DOUBLE Y The vendor site that these resubmission reasons are pertinent for.
VENDOR_SITE_RESUB_REASON_ID DOUBLE N Unique generated number that identifies a single row on the VENDOR_SITE_RESUB_REASON table.



Relationship Detail - VENDOR_SITE_RESUB_REASON


Child Column in VENDOR_SITE_RESUB_REASON(FK) Parent Table Name Parent Column Name
Parents: VENDOR_SITE_ID VENDOR_SITE VENDOR_SITE_ID