CREATE TABLE gtg_ts_purreceivingoptions (
    ETL_SEQUENCE_ID                   NUMBER(19, 0),
    ETL_VERSION_NUMBER                NUMBER(18, 0),
    DELETE_VERSION_NUMBER             NUMBER(18, 0),
    LAST_UPDATED_BY                   VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE                  TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN                 VARCHAR2(128),
    CREATED_BY                        VARCHAR2(256)    NOT NULL,
    CREATION_DATE                     TIMESTAMP(6)     NOT NULL,
    ADVANCED_PRICING                  VARCHAR2(4)  ,
    ALLOW_CASCADE_TRANSACTIONS        VARCHAR2(4)  ,
    ALLOW_EXPRESS_DELIVERY_FLAG       VARCHAR2(4)  ,
    ALLOW_ROUTING_OVERRIDE            VARCHAR2(4)  ,
    ALLOW_SUBSTITUTE_RECEIPTS_FLAG    VARCHAR2(4)  ,
    ALLOW_UNORDERED_RECEIPTS_FLAG     VARCHAR2(4)  ,
    BLIND_RECEIVING_FLAG              VARCHAR2(4)  ,
    DAYS_EARLY_RECEIPT_ALLOWED        NUMBER       ,
    DAYS_LATE_RECEIPT_ALLOWED         NUMBER       ,
    ENFORCE_RMA_LOT_NUM               VARCHAR2(4)  ,
    ENFORCE_RMA_SERIAL_NUM            VARCHAR2(4)  ,
    ENFORCE_SHIP_TO_LOCATION_CODE     VARCHAR2(100),
    INCLUDE_CLOSED_PO_RECEIPT         VARCHAR2(4)  ,
    INTF_RETURNS_TO_SHIPPING          VARCHAR2(4)  ,
    MANUAL_RECEIPT_NUM_TYPE           VARCHAR2(100),
    NEXT_RECEIPT_NUM                  NUMBER(18, 0),
    ORGANIZATION_ID                   NUMBER(18, 0),
    PRINT_RECEIPT_TRAVELER            VARCHAR2(4)  ,
    PROCESS_ASN_LINES_TOGETHER        VARCHAR2(4)  ,
    QTY_RCV_EXCEPTION_CODE            VARCHAR2(100),
    QTY_RCV_TOLERANCE                 NUMBER       ,
    RCVPARAMETERS_CB                  VARCHAR2(256),
    RCVPARAMETERS_CD                  TIMESTAMP(6) ,
    RCVPARAMETERS_LUB                 VARCHAR2(256),
    RCVPARAMETERS_LUD                 TIMESTAMP(6) ,
    RECEIPT_ASN_EXISTS_CODE           VARCHAR2(120),
    RECEIPT_DAYS_EXCEPTION_CODE       VARCHAR2(100),
    RECEIVING_ROUTING_ID              NUMBER(18, 0),
    RMA_RECEIPT_ROUTING_ID            NUMBER(18, 0),
    TRANSPORTATION_EXECUTION          VARCHAR2(4)  ,
    USER_DEFINED_RECEIPT_NUM_CODE     VARCHAR2(100),
    ETL_SEQUENCE_ID                   NUMBER(19, 0),
    ETL_VERSION_NUMBER                NUMBER(18, 0),
    DELETE_VERSION_NUMBER             NUMBER(18, 0),
    LAST_UPDATED_BY                   VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE                  TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN                 VARCHAR2(128),
    CREATED_BY                        VARCHAR2(256)    NOT NULL,
    CREATION_DATE                     TIMESTAMP(6)     NOT NULL,
    ADVANCED_PRICING                  VARCHAR2(4)  ,
    ALLOW_CASCADE_TRANSACTIONS        VARCHAR2(4)  ,
    ALLOW_EXPRESS_DELIVERY_FLAG       VARCHAR2(4)  ,
    ALLOW_ROUTING_OVERRIDE            VARCHAR2(4)  ,
    ALLOW_SUBSTITUTE_RECEIPTS_FLAG    VARCHAR2(4)  ,
    ALLOW_UNORDERED_RECEIPTS_FLAG     VARCHAR2(4)  ,
    BLIND_RECEIVING_FLAG              VARCHAR2(4)  ,
    DAYS_EARLY_RECEIPT_ALLOWED        NUMBER       ,
    DAYS_LATE_RECEIPT_ALLOWED         NUMBER       ,
    ENFORCE_RMA_LOT_NUM               VARCHAR2(4)  ,
    ENFORCE_RMA_SERIAL_NUM            VARCHAR2(4)  ,
    ENFORCE_SHIP_TO_LOCATION_CODE     VARCHAR2(100),
    INCLUDE_CLOSED_PO_RECEIPT         VARCHAR2(4)  ,
    INTF_RETURNS_TO_SHIPPING          VARCHAR2(4)  ,
    MANUAL_RECEIPT_NUM_TYPE           VARCHAR2(100),
    NEXT_RECEIPT_NUM                  NUMBER(18, 0),
    ORGANIZATION_ID                   NUMBER(18, 0),
    PRINT_RECEIPT_TRAVELER            VARCHAR2(4)  ,
    PROCESS_ASN_LINES_TOGETHER        VARCHAR2(4)  ,
    QTY_RCV_EXCEPTION_CODE            VARCHAR2(100),
    QTY_RCV_TOLERANCE                 NUMBER       ,
    RCVPARAMETERS_CB                  VARCHAR2(256),
    RCVPARAMETERS_CD                  TIMESTAMP(6) ,
    RCVPARAMETERS_LUB                 VARCHAR2(256),
    RCVPARAMETERS_LUD                 TIMESTAMP(6) ,
    RECEIPT_ASN_EXISTS_CODE           VARCHAR2(120),
    RECEIPT_DAYS_EXCEPTION_CODE       VARCHAR2(100),
    RECEIVING_ROUTING_ID              NUMBER(18, 0),
    RMA_RECEIPT_ROUTING_ID            NUMBER(18, 0),
    TRANSPORTATION_EXECUTION          VARCHAR2(4)  ,
    USER_DEFINED_RECEIPT_NUM_CODE     VARCHAR2(100),
    CONSTRAINT pk_gtg_ts_purreceivingoptions PRIMARY KEY (ETL_SEQUENCE_ID, ETL_VERSION_NUMBER, ETL_SEQUENCE_ID, ETL_VERSION_NUMBER)
);
