PayablesPaymentTermspayablesPaymentTermsLines
PayablesPaymentTermspayablesPaymentTermsLines
Columns
| Name | Type | Description |
| PayablesPaymentTermstermsId [KEY] | Long | PayablesPaymentTermstermsId of PayablesPaymentTermspayablesPaymentTermsLines |
| DuePercent | Double | DuePercent of PayablesPaymentTermspayablesPaymentTermsLines |
| AmountDue | Double | AmountDue of PayablesPaymentTermspayablesPaymentTermsLines |
| Days | Int | Days of PayablesPaymentTermspayablesPaymentTermsLines |
| DayOfMonth | Int | DayOfMonth of PayablesPaymentTermspayablesPaymentTermsLines |
| MonthsAhead | Int | MonthsAhead of PayablesPaymentTermspayablesPaymentTermsLines |
| FirstDiscountPercent | Double | FirstDiscountPercent of PayablesPaymentTermspayablesPaymentTermsLines |
| FirstDiscountDays | Int | FirstDiscountDays of PayablesPaymentTermspayablesPaymentTermsLines |
| FirstDiscountDayOfMonth | Int | FirstDiscountDayOfMonth of PayablesPaymentTermspayablesPaymentTermsLines |
| FirstDiscountMonthsForward | Int | FirstDiscountMonthsForward of PayablesPaymentTermspayablesPaymentTermsLines |
| SecondDiscountPercent | Double | SecondDiscountPercent of PayablesPaymentTermspayablesPaymentTermsLines |
| SecondDiscountDays | Int | SecondDiscountDays of PayablesPaymentTermspayablesPaymentTermsLines |
| SecondDiscountDayOfMonth | Int | SecondDiscountDayOfMonth of PayablesPaymentTermspayablesPaymentTermsLines |
| SecondDiscountMonthsForward | Int | SecondDiscountMonthsForward of PayablesPaymentTermspayablesPaymentTermsLines |
| ThirdDiscountPercent | Double | ThirdDiscountPercent of PayablesPaymentTermspayablesPaymentTermsLines |
| ThirdDiscountDays | Int | ThirdDiscountDays of PayablesPaymentTermspayablesPaymentTermsLines |
| ThirdDiscountDayOfMonth | Int | ThirdDiscountDayOfMonth of PayablesPaymentTermspayablesPaymentTermsLines |
| ThirdDiscountMonthsForward | Int | ThirdDiscountMonthsForward of PayablesPaymentTermspayablesPaymentTermsLines |
| FixedDate | Date | FixedDate of PayablesPaymentTermspayablesPaymentTermsLines |
| Calendar | String | Calendar of PayablesPaymentTermspayablesPaymentTermsLines |
| SequenceNumber [KEY] | Int | SequenceNumber of PayablesPaymentTermspayablesPaymentTermsLines |
| TermsId [KEY] | Long | TermsId of PayablesPaymentTermspayablesPaymentTermsLines |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |
| FromDate | Date | fromDate |
| ToDate | Date | toDate |