xxap_easy_invoice_header_t

Tables (4)

XXAP_EASY_INVOICE_HEADER_T

  • HEADER_ID — NUMBER — Primary key — NOT NULL
  • ORG_ID — NUMBER — Primary key — NOT NULL
  • SOURCE — VARCHAR2(25)
  • INVOICE_ID — NUMBER
  • INVOICE_TYPE — VARCHAR2(150)
  • INVOICE_NUM — VARCHAR2(30)
  • VENDOR_ID — NUMBER
  • VENDOR_SITE_ID — NUMBER
  • INVOICE_DATE — DATE
  • GL_DATE — DATE
  • CURRENCY_CODE — VARCHAR2(3)
  • ENTERED_AMOUNT — NUMBER
  • ACCOUNTED_AMOUNT — NUMBER
  • DESCRIPTION — VARCHAR2(250)
  • TERM — VARCHAR2(150)
  • DUE_DATE — DATE
  • VENDOR_BANK_ACCOUNT_ID — NUMBER
  • PAYMENT_METHOD — VARCHAR2(150)
  • PAY_GROUP — VARCHAR2(150)
  • REQUESTER_NUM — VARCHAR2(15)
  • CREATER_NUM — VARCHAR2(15)
  • LOCATION — VARCHAR2(30) — 사업장
  • VAT_ISSUE_SITE — VARCHAR2(30)
  • VAT_ISSUE_TYPE — VARCHAR2(30)
  • CORPCARD_NUM — VARCHAR2(30)
  • PO_NUMBER — VARCHAR2(150)
  • PREPAY_SEQ — VARCHAR2(150)
  • EXCHANGE_RATE_TYPE — VARCHAR2(150)
  • EXCHANGE_RATE_DATE — DATE
  • EXCHANGE_RATE — NUMBER
  • CODE_COMBINATION_ID — NUMBER
  • INVOICE_STATUS — VARCHAR2(30)
  • CANCEL_FLAG — VARCHAR2(1)
  • CANCEL_DATE — DATE
  • CREATED_BY — NUMBER
  • CREATION_DATE — DATE
  • LAST_UPDATE_BY — NUMBER
  • LAST_UPDATE_DATE — DATE

XXAP_EASY_INVOICE_LINE_T

  • HEADER_ID — NUMBER — Foreign key → XXAP_EASY_INVOICE_HEADER_T.HEADER_ID — NOT NULL
  • ORG_ID — NUMBER — Foreign key → XXAP_EASY_INVOICE_HEADER_T.ORG_ID — NOT NULL
  • LINE_NUM — NUMBER
  • LINE_TYPE — VARCHAR2(30)
  • PROJECT_ID — NUMBER
  • TASK — VARCHAR2(30)
  • EXPENDITURE_TYPE — VARCHAR2(30)
  • EXPENDITURE_ORG — VARCHAR2(30)
  • WORK_DUTY — VARCHAR2(15)
  • DDA_CCID — NUMBER
  • SUP_AMOUNT — NUMBER
  • TAX_AMOUNT — NUMBER
  • TAX_ADJ_AMOUNT — NUMBER
  • SUP_AMOUNT_KRW — NUMBER
  • TAX_AMOUNT_KRW — NUMBER
  • TAX_ADJ_AMOUNT_KRW — NUMBER
  • TAX_CODE — VARCHAR2(30)
  • CORPCARD_NUM — VARCHAR2(30)
  • CARD_VENDOOR (CARD_VENDOR) — VARCHAR2(150)
  • PREEXPENSE_ACCOUNT — VARCHAR2(30)
  • PREEXPENSE_TASK — VARCHAR2(30)
  • PREEXPENSE_START — DATE
  • PREEXPENSE_END — DATE
  • PREEXPENSE_PJT — NUMBER
  • PREPAY_INVOICE_ID (PREPAY_INOVICE_ID) — NUMBER
  • PREPAY_INVOICE_LINE_NUM — NUMBER
  • CREATED_BY — NUMBER
  • CREATION_DATE — DATE
  • LAST_UPDATE_BY — NUMBER
  • LAST_UPDATE_DATE — DATE
  • PO_NUMBER (po_number) — varchar2(30)
  • po_line_num — number
  • po_header_id — number
  • po_line_id — number
  • po_line_location_id — number
  • rcv_transaction_id — number
  • po_distribution_id — number
  • deliver_transaction_id — number

XXAP_EASY_PREPAY_APPLY_HISTORY_T

  • ORG_ID — NUMBER — Primary key — NOT NULL
  • PREPAY_HIST_ID — NUMBER — Primary key — NOT NULL
  • PREPAY_ID (PREPAY_ID2) — NUMBER — Primary key — NOT NULL
  • TRX_TYPE — VARCHAR2(30) — APPLY : 반제 UNAPPLY : 반제취소
  • TRX_DATE — DATE
  • APPLY_INVOICE_ID — NUMBER
  • CREATED_BY — NUMBER
  • CREATION_DATE — DATE
  • LAST_UPDATE_BY — NUMBER
  • LAST_UPDATE_DATE — DATE

XXAP_EASY_PREPAY_APPLY_T

  • ORG_ID — NUMBER — Primary key — NOT NULL
  • PREPAY_ID — NUMBER — Primary key — NOT NULL
  • PREPAY_INVOICE_ID — NUMBER
  • PREPAY_INVOICE_LINE_NUM — NUMBER
  • PRE_AMOUNT — NUMBER
  • PRE_AMOUNT_KRW — NUMBER
  • APPLY_AMOUNT — NUMBER
  • APPLY_AMOUNT_KRW — NUMBER
  • APPLY_STATUS — VARCHAR2(30)
  • CREATED_BY — NUMBER
  • CREATION_DATE — DATE
  • LAST_UPDATE_BY — NUMBER
  • LAST_UPDATE_DATE — DATE
  • VENDOR_ID — NUMBER
  • APPLY_DATE — DATE
  • VENDOR_SITE_ID — NUMBER