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