CREATE TABLE fla_payment_templates_all_ (
    PAYMENT_TEMPLATE_ID              NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)  ,
    NAME                             VARCHAR2(1200),
    ORG_ID                           NUMBER(18, 0) ,
    PAYMENT_TYPE_CODE                VARCHAR2(120) ,
    PAYMENT_PURPOSE_CODE             VARCHAR2(120) ,
    ROU_ASSET_FLAG                   VARCHAR2(4)   ,
    LIABILITY_FLAG                   VARCHAR2(4)   ,
    ACTIVE_FLAG                      VARCHAR2(4)   ,
    PAYMENT_FREQUENCY_CODE           VARCHAR2(120) ,
    DESCRIPTION                      VARCHAR2(4000),
    PAYMENT_TERM_ID                  NUMBER(18, 0) ,
    VENDOR_ID                        NUMBER(18, 0) ,
    VENDOR_SITE_ID                   NUMBER(18, 0) ,
    DISTRIBUTION_SET_ID              NUMBER(18, 0) ,
    TAX_INCLUDED_FLAG                VARCHAR2(4)   ,
    TAX_CLASSIFICATION_CODE          VARCHAR2(120) ,
    REPORT_FROM_INCEPTION_FLAG       VARCHAR2(4)   ,
    INTERCOMPANY_FLAG                VARCHAR2(4)   ,
    PRIMARY_INTENDED_USE_CODE        VARCHAR2(120) ,
    PRODUCT_CATEGORY                 VARCHAR2(960) ,
    PRODUCT_FISCAL_CLASSIFICATION    VARCHAR2(960) ,
    PRODUCT_TYPE                     VARCHAR2(960) ,
    TRX_BUSINESS_CATEGORY            VARCHAR2(960) ,
    USER_DEFINED_FISCAL_CLASS        VARCHAR2(960) ,
    WITHHOLDING_TAX_GROUP_ID         NUMBER(18, 0) ,
    OPTION_FLAG                      VARCHAR2(4)   ,
    OPTION_TYPE_CODE                 VARCHAR2(120) ,
    REVENUE_METHOD_CODE              VARCHAR2(120) ,
    SCHEDULE_TYPE_CODE               VARCHAR2(120) ,
    BILL_TO_CUSTOMER_ID              NUMBER(18, 0) ,
    BILL_TO_SITE_USE_ID              NUMBER(18, 0) ,
    SHIP_TO_SITE_USE_ID              NUMBER(18, 0) ,
    CUSTOMER_TRX_TYPE_ID             NUMBER(18, 0) ,
    AR_PAYMENT_TERM_ID               NUMBER(18, 0) ,
    DOCUMENT_SUB_TYPE                VARCHAR2(960) ,
    FIRST_PTY_REG_ID                 NUMBER(18, 0) ,
    THIRD_PTY_REG_ID                 NUMBER(18, 0) ,
    AMORTIZE_EXEMPT_PAYMENT_FLAG     VARCHAR2(4)   ,
    GENERATE_INVOICE_FLAG            VARCHAR2(4)   ,
    TAX_DETERMINANTS_SOURCE_CODE     VARCHAR2(120) ,
    APPLY_UPFRONT_TAX_FLAG           VARCHAR2(4)   ,
    PAYMENT_CATEGORY_CODE            VARCHAR2(120) ,
    PAYMENT_PHASE_CODE               VARCHAR2(120) ,
    PRIMARY_ACCRUAL_METHOD_CODE      VARCHAR2(120) ,
    SECONDARY_ACCRUAL_METHOD_CODE    VARCHAR2(120) ,
    LEASE_TYPE_CODE                  VARCHAR2(120) ,
    ASSET_TYPE_CODE                  VARCHAR2(120) ,
    LAST_UPDATE_DATE                 TIMESTAMP(6)  ,
    LAST_UPDATED_BY                  VARCHAR2(256) ,
    CREATION_DATE                    TIMESTAMP(6)  ,
    CREATED_BY                       VARCHAR2(256) ,
    LAST_UPDATE_LOGIN                VARCHAR2(128) ,
    ATTRIBUTE_CATEGORY               VARCHAR2(120) ,
    ATTRIBUTE_CHAR1                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR2                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR3                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR4                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR5                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR6                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR7                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR8                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR9                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR10                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR11                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR12                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR13                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR14                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR15                 VARCHAR2(600) ,
    ATTRIBUTE_NUMBER1                NUMBER        ,
    ATTRIBUTE_NUMBER2                NUMBER        ,
    ATTRIBUTE_NUMBER3                NUMBER        ,
    ATTRIBUTE_NUMBER4                NUMBER        ,
    ATTRIBUTE_NUMBER5                NUMBER        ,
    ATTRIBUTE_DATE1                  DATE          ,
    ATTRIBUTE_DATE2                  DATE          ,
    ATTRIBUTE_DATE3                  DATE          ,
    ATTRIBUTE_DATE4                  DATE          ,
    ATTRIBUTE_DATE5                  DATE          ,
    AUDIT_ACTION_TYPE_               VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_            VARCHAR2(4000),
    AUDIT_IMPERSONATOR_              VARCHAR2(256) ,
    PAYMENT_TEMPLATE_ID              NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)  ,
    NAME                             VARCHAR2(1200),
    ORG_ID                           NUMBER(18, 0) ,
    PAYMENT_TYPE_CODE                VARCHAR2(120) ,
    PAYMENT_PURPOSE_CODE             VARCHAR2(120) ,
    ROU_ASSET_FLAG                   VARCHAR2(4)   ,
    LIABILITY_FLAG                   VARCHAR2(4)   ,
    ACTIVE_FLAG                      VARCHAR2(4)   ,
    PAYMENT_FREQUENCY_CODE           VARCHAR2(120) ,
    DESCRIPTION                      VARCHAR2(4000),
    PAYMENT_TERM_ID                  NUMBER(18, 0) ,
    VENDOR_ID                        NUMBER(18, 0) ,
    VENDOR_SITE_ID                   NUMBER(18, 0) ,
    DISTRIBUTION_SET_ID              NUMBER(18, 0) ,
    TAX_INCLUDED_FLAG                VARCHAR2(4)   ,
    TAX_CLASSIFICATION_CODE          VARCHAR2(120) ,
    REPORT_FROM_INCEPTION_FLAG       VARCHAR2(4)   ,
    INTERCOMPANY_FLAG                VARCHAR2(4)   ,
    PRIMARY_INTENDED_USE_CODE        VARCHAR2(120) ,
    PRODUCT_CATEGORY                 VARCHAR2(960) ,
    PRODUCT_FISCAL_CLASSIFICATION    VARCHAR2(960) ,
    PRODUCT_TYPE                     VARCHAR2(960) ,
    TRX_BUSINESS_CATEGORY            VARCHAR2(960) ,
    USER_DEFINED_FISCAL_CLASS        VARCHAR2(960) ,
    WITHHOLDING_TAX_GROUP_ID         NUMBER(18, 0) ,
    OPTION_FLAG                      VARCHAR2(4)   ,
    OPTION_TYPE_CODE                 VARCHAR2(120) ,
    LAST_UPDATE_DATE                 TIMESTAMP(6)  ,
    LAST_UPDATED_BY                  VARCHAR2(256) ,
    CREATION_DATE                    TIMESTAMP(6)  ,
    CREATED_BY                       VARCHAR2(256) ,
    LAST_UPDATE_LOGIN                VARCHAR2(128) ,
    ATTRIBUTE_CATEGORY               VARCHAR2(120) ,
    ATTRIBUTE_CHAR1                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR2                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR3                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR4                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR5                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR6                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR7                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR8                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR9                  VARCHAR2(600) ,
    ATTRIBUTE_CHAR10                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR11                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR12                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR13                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR14                 VARCHAR2(600) ,
    ATTRIBUTE_CHAR15                 VARCHAR2(600) ,
    ATTRIBUTE_NUMBER1                NUMBER        ,
    ATTRIBUTE_NUMBER2                NUMBER        ,
    ATTRIBUTE_NUMBER3                NUMBER        ,
    ATTRIBUTE_NUMBER4                NUMBER        ,
    ATTRIBUTE_NUMBER5                NUMBER        ,
    ATTRIBUTE_DATE1                  DATE          ,
    ATTRIBUTE_DATE2                  DATE          ,
    ATTRIBUTE_DATE3                  DATE          ,
    ATTRIBUTE_DATE4                  DATE          ,
    ATTRIBUTE_DATE5                  DATE          ,
    AUDIT_ACTION_TYPE_               VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_            VARCHAR2(4000),
    AUDIT_IMPERSONATOR_              VARCHAR2(256) ,
    REVENUE_METHOD_CODE              VARCHAR2(120) ,
    SCHEDULE_TYPE_CODE               VARCHAR2(120) ,
    BILL_TO_CUSTOMER_ID              NUMBER(18, 0) ,
    BILL_TO_SITE_USE_ID              NUMBER(18, 0) ,
    SHIP_TO_SITE_USE_ID              NUMBER(18, 0) ,
    CUSTOMER_TRX_TYPE_ID             NUMBER(18, 0) ,
    AR_PAYMENT_TERM_ID               NUMBER(18, 0) ,
    DOCUMENT_SUB_TYPE                VARCHAR2(960) ,
    FIRST_PTY_REG_ID                 NUMBER(18, 0) ,
    THIRD_PTY_REG_ID                 NUMBER(18, 0) ,
    AMORTIZE_EXEMPT_PAYMENT_FLAG     VARCHAR2(4)   ,
    GENERATE_INVOICE_FLAG            VARCHAR2(4)   ,
    TAX_DETERMINANTS_SOURCE_CODE     VARCHAR2(120) ,
    APPLY_UPFRONT_TAX_FLAG           VARCHAR2(4)   ,
    PAYMENT_CATEGORY_CODE            VARCHAR2(120) ,
    PAYMENT_PHASE_CODE               VARCHAR2(120) ,
    PRIMARY_ACCRUAL_METHOD_CODE      VARCHAR2(120) ,
    SECONDARY_ACCRUAL_METHOD_CODE    VARCHAR2(120) ,
    LEASE_TYPE_CODE                  VARCHAR2(120) ,
    ASSET_TYPE_CODE                  VARCHAR2(120) ,
    CONSTRAINT pk_fla_payment_templates_all_ PRIMARY KEY (PAYMENT_TEMPLATE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, PAYMENT_TEMPLATE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY)
);
