| id |
int(11)
|
|
|
|
| tpin |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| bhfId |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| refInvcNo |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| orgInvcNo |
int(11)
|
|
|
|
| orgSdcId |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| cisInvcNo |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| custTpin |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| custNm |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| salesTyCd |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| rcptTyCd |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| pmtTyCd |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| salesSttsCd |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| cfmDt |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| salesDt |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| stockRlsDt |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| cnclReqDt |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| cnclDt |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| rfdDt |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| rfdRsnCd |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| taxblAmtA |
decimal(15,4)
|
|
|
|
| taxblAmtB |
decimal(15,4)
|
|
|
|
| taxblAmtC1 |
decimal(15,4)
|
|
|
|
| taxblAmtC2 |
decimal(15,4)
|
|
|
|
| taxblAmtC3 |
decimal(15,4)
|
|
|
|
| taxblAmtD |
decimal(15,4)
|
|
|
|
| taxblAmtRvat |
decimal(15,4)
|
|
|
|
| taxblAmtE |
decimal(15,4)
|
|
|
|
| taxblAmtF |
decimal(15,4)
|
|
|
|
| taxblAmtIpl1 |
decimal(15,4)
|
|
|
|
| taxblAmtIpl2 |
decimal(15,4)
|
|
|
|
| taxblAmtTl |
decimal(15,4)
|
|
|
|
| taxblAmtEcm |
decimal(15,4)
|
|
|
|
| taxblAmtExeeg |
decimal(15,4)
|
|
|
|
| taxblAmtTot |
decimal(15,4)
|
|
|
|
| taxAmtA |
decimal(15,4)
|
|
|
|
| taxAmtB |
decimal(15,4)
|
|
|
|
| taxAmtC1 |
decimal(15,4)
|
|
|
|
| taxAmtC2 |
decimal(15,4)
|
|
|
|
| taxAmtC3 |
decimal(15,4)
|
|
|
|
| taxAmtD |
decimal(15,4)
|
|
|
|
| taxAmtRvat |
decimal(15,4)
|
|
|
|
| taxAmtE |
decimal(15,4)
|
|
|
|
| taxAmtF |
decimal(15,4)
|
|
|
|
| taxAmtIpl1 |
decimal(15,4)
|
|
|
|
| taxAmtIpl2 |
decimal(15,4)
|
|
|
|
| taxAmtTl |
decimal(15,4)
|
|
|
|
| taxAmtEcm |
decimal(15,4)
|
|
|
|
| taxAmtExeeg |
decimal(15,4)
|
|
|
|
| taxAmtTot |
decimal(15,4)
|
|
|
|
| taxRtA |
decimal(5,2)
|
|
|
|
| taxRtB |
decimal(5,2)
|
|
|
|
| taxRtC1 |
decimal(5,2)
|
|
|
|
| taxRtC2 |
decimal(5,2)
|
|
|
|
| taxRtC3 |
decimal(5,2)
|
|
|
|
| taxRtD |
decimal(5,2)
|
|
|
|
| tlAmt |
decimal(5,2)
|
|
|
|
| taxRtRvat |
decimal(5,2)
|
|
|
|
| taxRtE |
decimal(5,2)
|
|
|
|
| taxRtF |
decimal(5,2)
|
|
|
|
| taxRtIpl1 |
decimal(5,2)
|
|
|
|
| taxRtIpl2 |
decimal(5,2)
|
|
|
|
| taxRtTl |
decimal(5,2)
|
|
|
|
| taxRtEcm |
decimal(5,2)
|
|
|
|
| taxRtExeeg |
decimal(5,2)
|
|
|
|
| taxRtTot |
decimal(5,2)
|
|
|
|
| totItemCnt |
int(11)
|
|
|
|
| totTaxblAmt |
decimal(15,4)
|
|
|
|
| totTaxAmt |
decimal(15,4)
|
|
|
|
| totAmt |
decimal(15,4)
|
|
|
|
| cashDcRt |
decimal(10,4)
|
|
|
|
| cashDcAmt |
decimal(15,4)
|
|
|
|
| remark |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| regrId |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| regrNm |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| modrId |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| modrNm |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| prchrAcptcYn |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| saleCtyCd |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| lpoNumber |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| invcAdjustReason |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| dbtRsnCd |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| currencyTyCd |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| exchangeRt |
decimal(10,4)
|
|
|
|
| destnCountryCd |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| prcd |
tinyint(1)
|
|
|
|
| prnt |
tinyint(1)
|
|
|
|
| rcptNo |
int(11)
|
|
|
|
| intrlData |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| rcptSign |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| vsdcRcptPbctDate |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| sdcId |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| mrcNo |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| qrCodeUrl |
varchar(255)
|
utf8mb4_general_ci
|
|
|
