TransferOrderstransferOrderLinestransferOrderDistributions
TransferOrderstransferOrderLinestransferOrderDistributions
Columns
| Name | Type | Description |
| TransferOrdersHeaderId [KEY] | Long | TransferOrdersHeaderId of TransferOrderstransferOrderLinestransferOrderDistributions |
| TransferorderlinesLineId [KEY] | Long | TransferorderlinesLineId of TransferOrderstransferOrderLinestransferOrderDistributions |
| DistributionId [KEY] | Long | DistributionId of TransferOrderstransferOrderLinestransferOrderDistributions |
| DistributionNumber | Double | DistributionNumber of TransferOrderstransferOrderLinestransferOrderDistributions |
| LineId | Long | LineId of TransferOrderstransferOrderLinestransferOrderDistributions |
| PrimaryLedgerId | Long | PrimaryLedgerId of TransferOrderstransferOrderLinestransferOrderDistributions |
| CodeCombinationId | Long | CodeCombinationId of TransferOrderstransferOrderLinestransferOrderDistributions |
| DistributionQuantity | Double | DistributionQuantity of TransferOrderstransferOrderLinestransferOrderDistributions |
| DeliveredQuantity | Double | DeliveredQuantity of TransferOrderstransferOrderLinestransferOrderDistributions |
| Percent | Double | Percent of TransferOrderstransferOrderLinestransferOrderDistributions |
| DistributionAmount | Double | DistributionAmount of TransferOrderstransferOrderLinestransferOrderDistributions |
| RecoverableTax | Double | RecoverableTax of TransferOrderstransferOrderLinestransferOrderDistributions |
| NonrecoverableTax | Double | NonrecoverableTax of TransferOrderstransferOrderLinestransferOrderDistributions |
| FundsStatus | String | FundsStatus of TransferOrderstransferOrderLinestransferOrderDistributions |
| BudgetDate | Date | BudgetDate of TransferOrderstransferOrderLinestransferOrderDistributions |
| RequisitionDistributionId | Long | RequisitionDistributionId of TransferOrderstransferOrderLinestransferOrderDistributions |
| ChargeAccount | String | ChargeAccount of TransferOrderstransferOrderLinestransferOrderDistributions |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| HeaderId | Long | HeaderId |
| Finder | String | finder |
| PBatch | String | pBatch |
| PDestinationOrganization | String | pDestinationOrganization |
| PItemNumber | String | pItemNumber |
| PLineNumber | String | pLineNumber |
| PLineStatus | String | pLineStatus |
| PScheduledShipDate | Datetime | pScheduledShipDate |
| PSourceOrganization | String | pSourceOrganization |
| PTransactionOrigin | String | pTransactionOrigin |
| PTransferOrder | String | pTransferOrder |