WorkCenters

Columns


Name	Type	Description
OrganizationId	Long	Value that uniquely identifies the inventory organization. It is a primary key that the application generates when it creates an inventory organization.
OrganizationCode	String	Abbreviation that identifies the inventory organization.
OrganizationName	String	OrganizationName of WorkCenters
WorkCenterId [KEY]	Long	WorkCenterId of WorkCenters
WorkCenterCode	String	Abbreviation that identifies the work center.
WorkCenterName	String	Name of the work center.
WorkCenterDescription	String	Description of the work center.
InactiveDate	Date	Date when the work area becomes inactive.
WorkAreaId	Long	Value that uniquely identifies the work area. It is a primary key that the application generates when it creates a work area.
WorkAreaCode	String	WorkAreaCode of WorkCenters
WorkAreaName	String	Name of the work area.
WorkAreaDescription	String	WorkAreaDescription of WorkCenters

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。