Staging table sample

Hai use this script for staging table for supplier interface

CREATE TABLE XXST_AP_SUPP_INT_STG

(

  RECORD_ID                       NUMBER,                                  --Mandatory

  BATCH_NO                        VARCHAR2(50 BYTE),                            --Mandatory

  OPERATING_UNIT                  VARCHAR2(25 BYTE),                      --Mandatory

  ORG_ID                          NUMBER,                                      --Mandatory

  SET_OF_BOOKS_ID                 NUMBER,                                           --Mandatory

  SUPPLIER_ID                     NUMBER,                                 --Mandatory

  SUPPLIER_NAME                   VARCHAR2(240 BYTE),                     --Mandatory

  ADDRESS1                        VARCHAR2(240 BYTE),                           --Optional

  ADDRESS2                        VARCHAR2(240 BYTE),                           --Optional

  ADDRESS3                        VARCHAR2(240 BYTE),                           --Optional

  ADDRESS4                        VARCHAR2(240 BYTE),                           --Optional

  CITY                            VARCHAR2(25 BYTE),                   --Mandatory

  STATE                           VARCHAR2(150 BYTE),                               --Optional

  PIN_CODE                        VARCHAR2(20 BYTE),                              --Mandatory

  COUNTRY                         VARCHAR2(150 BYTE),                           --Optional

  SITE_NAME                       VARCHAR2(15 BYTE),                            --Mandatory

  ALTERNATE_SUPPLIER_SITE_IF_ANY  VARCHAR2(320 BYTE),                  --Optional

  ALTERNATE_SUPP_ADDRESS_IFANY    VARCHAR2(560 BYTE),                 --Optional

  FIRST_NAME                      VARCHAR2(15 BYTE),                           --Optional

  LAST_NAME                       VARCHAR2(20 BYTE),                           --Mandatory

  STD_ISD_TEL_CODE                VARCHAR2(10 BYTE),                    --Optional

  TELEPHONE_NO                    VARCHAR2(15 BYTE),                       --Optional

  STD_ISD_FAX_CODE                VARCHAR2(10 BYTE),                    --Optional

  FAX_NO                          VARCHAR2(15 BYTE),                               --Optional

  MOBILE_NO                       VARCHAR2(15 BYTE),                           --Optional

  EMAIL_ID                        VARCHAR2(200 BYTE),                            --Mandatory

  URL                             VARCHAR2(2000 BYTE),                                --Optional

  CENTRAL_SALES_TAX_NO            VARCHAR2(50 BYTE),                             --Mandatory

  VALUE_ADDED_TAX_NO              VARCHAR2(50 BYTE),                             --Mandatory

  SERVICE_TAX_NO                  VARCHAR2(50 BYTE),                      --Optional

  EXCISE_REGISTRATION_NO          VARCHAR2(50 BYTE),                             --Optional

  PAN_NO                          VARCHAR2(30 BYTE),                               --Mandatory

  EDIBLE_OIL_LICENCE_NO           VARCHAR2(150 BYTE),                            --Optional

  TRADE_LICENCE_NO                VARCHAR2(150 BYTE),                 --Optional

  TYPE_OF_ASSESSEE                VARCHAR2(150 BYTE),                  --Mandatory

  SMALL_SCALE_INDUSTRY_YN         VARCHAR2(1 BYTE),                           --Optional

  TYPE_OF_SUPPLIER                VARCHAR2(30 BYTE),                     --Mandatory

  PAYMENT_TERMS_NO_OF_DAYS        VARCHAR2(50 BYTE),                      --Mandatory

  ONE_TIME_SUPPLIER_YN            VARCHAR2(1 BYTE),                 --optional

  CURRENCY_CODE                   VARCHAR2(10 BYTE),                     --Mandatory

  SUPPLIER_BANK_NAME              VARCHAR2(60 BYTE),                                --Mandatory

  SUPPLIER_BANK_BRANCH_NAME       VARCHAR2(60 BYTE),                      --Mandatory

  BANK_BRANCH_ADDRESS1            VARCHAR2(35 BYTE),                            --Optional

  BANK_BRANCH_ADDRESS2            VARCHAR2(35 BYTE),                            --Optional

  BANK_BRANCH_ADDRESS3            VARCHAR2(35 BYTE),                            --Optional

  BANK_BRANCH_ADDRESS4            VARCHAR2(35 BYTE),                            --Optional

  BANK_CITY                       VARCHAR2(25 BYTE),                            --Optional

  BANK_STATE                      VARCHAR2(25 BYTE),                          --Optional

  BANK_COUNTRY                    VARCHAR2(25 BYTE),                      --Optional

  BANK_PIN_CODE                   VARCHAR2(20 BYTE),                       --Optional

  IFSC_NO                         VARCHAR2(30 BYTE),                                --Mandatory

  SUPPLIER_BANK_ACCTOUNT_NO       VARCHAR2(80 BYTE),                      --Mandatory

  LIABILITY_ACCOUNT               VARCHAR2(25 BYTE),                   --Optional

  PREPAYMENT_ACCOUNT              VARCHAR2(25 BYTE),                              --Optional

  INVOICE_INITIATOR_EMAIL         VARCHAR2(150 BYTE),                           --Mandatory

  PAYMENT_TEAM_EMAIL              VARCHAR2(150 BYTE),                           --Mandatory

  CREATION_DATE                   DATE,                                                 --Optional

  STATUS                          VARCHAR2(1 BYTE),                  --Optional

  INPUT_FILE_NAME                 VARCHAR2(250 BYTE),                   --Optional

  ERROR_MESSAGE                   VARCHAR2(2000 BYTE),                  --optional

  ISUPPLIER_FLAG                  VARCHAR2(5 BYTE),                          --Mandatory

  VENDOR_SITE_ID                  NUMBER,                                            --Optional

  BANK_ID                         NUMBER,                                    --Optional

  BANK_ACCOUNT_ID                 NUMBER,                                        --Optional

  LOCATION_ID                     NUMBER,                                               --Optional

  BANK_SITE_ID                    NUMBER,                                               --Optional

  BRANCH_ID                       NUMBER                                  --Optional

)