This page provides a guide to Establishing a Connection to PCA Sales in CData Cloud, as well as information on the available resources, and a reference to the available connection properties.

Connecting to PCA Sales

Establishing a Connection shows how to authenticate to PCA Sales and configure any necessary connection properties to create a database in CData Cloud

Accessing Data from CData Cloud Services

Accessing data from PCA Sales through the available standard services and CData Cloud administration is documented in further details in the CData Cloud Documentation.

Connect to PCA Sales by selecting the corresponding icon in the Database tab. Required properties are listed under Settings. The Advanced tab lists connection properties that are not typically required.

Connecting to PCA Sales

PCA Sales supports authentication via either OAuth or password grant.

OAuth Authentication

To enable this authentication, you must create a custom OAuth application, and set AuthScheme to OAuth.

The following subsections describe how to authenticate to PCA Sales from three common OAuth authentication flows.

For information about how to create a custom OAuth application, see Creating a Custom OAuth Application. For a complete list of connection string properties available in PCA Sales, see Connection.

Automatic refresh of the OAuth access token:

To have the Cloud automatically refresh the OAuth access token:

1. Before connecting to data for the first time, set these connection parameters:
   • InitiateOAuth: REFRESH.
   • OAuthClientId: The client Id in your custom OAuth application settings.
   • OAuthClientSecret: The client secret in your custom OAuth application settings.
   • OAuthAccessToken: The access token returned by GetOAuthAccessToken.
   • OAuthSettingsLocation: The path where you want the Cloud to save the OAuth values, which persist across connections.
2. On subsequent data connections, set:
   • InitiateOAuth
   • OAuthSettingsLocation

Manual refresh of the OAuth access token:

The only value needed to manually refresh the OAuth access token is the OAuth refresh token.

1. To manually refresh the OAuthAccessToken after the ExpiresIn period (returned by GetOAuthAccessToken) has elapsed, call the RefreshOAuthAccessToken stored procedure.
2. Set these connection properties:
   • OAuthClientId: The Client Id in your custom OAuth application settings.
   • OAuthClientSecret: The Client Secret in your custom OAuth application settings.

3. Call RefreshOAuthAccessToken with OAuthRefreshToken set to the OAuth refresh token returned by GetOAuthAccessToken.
4. After the new tokens have been retrieved, set the OAuthAccessToken property to the value returned by RefreshOAuthAccessToken. This opens a new connection.

Store the OAuth refresh token so that you can use it to manually refresh the OAuth access token after it has expired.

Password Grant Authentication

When there is a trust relationship between the user and the application, the user can use the Password grant type to authenticate from either a Desktop application or the web. To enable this authscheme, set AuthScheme to OAuthPassword.

Authentication by password grant is similar to OAuth -- in fact, it requires that you have already set up a custom OAuth application, as described in Creating a Custom OAuth Application -- but once it's set up it does not require user interaction.

To connect, set these properties:

• InitiateOAuth: GETANDREFRESH. You can use InitiateOAuth to avoid repeating the OAuth exchange and manually setting the access token in the connection string.
• AuthScheme: The AuthScheme specified in your custom OAuth application.
• User: The Username of the user specified in your custom OAuth application.
• Password: The Password of the user specified in your custom OAuth application.
• ServiceId: The ID of the service account.
• ServicePassword: The Password of the service account.
• DefaultDataArea: The target data area.
• DataCenter: The DataCenter name of the target server.
• OAuthClientId: The Client Id specified in your custom OAuth application.
• OAuthClientSecret: The Client Secret specified in your custom OAuth application.
• CallbackURL: The Redirect URL specified in your custom OAuth application.
• APIVersion: The PCA API Server version to connect.
• ProductCode: The PCA Product code name.

Click Connect. The Cloud opens the PCA Sales OAuth endpoint. When you log in and grant grant permissions to the Cloud, the Cloud completes the OAuth process.

Creating a Custom OAuth Application

The following procedure creates a custom OAuth application and obtains the OAuth values for your application.

1. Log into the PCA Developers Console.
2. Click Create New Application.
3. Fill in all required values.
4. Specify a Redirect URL:
   • If you are making a desktop application, enter http://localhost:33333, the Cloud's default. Or set a different port of your choice, and set CallbackURL to this precise URL.
   • If you are making a Web application, set the Redirect URL to a web location where users should return bearing the access token, after they grant permissions to your application.

Save your changes and record your client Id, client secret, and callback URL for future use.

Customizing the SSL Configuration

By default, the Cloud attempts to negotiate TLS with the server. The server certificate is validated against the default system trusted certificate store. You can override how the certificate gets validated using the SSLServerCert connection property.

To specify another certificate, see the SSLServerCert connection property.

Connecting Through a Firewall or Proxy

HTTP Proxies

To authenticate to an HTTP proxy, set the following:

• ProxyServer: the hostname or IP address of the proxy server that you want to route HTTP traffic through.
• ProxyPort: the TCP port that the proxy server is running on.
• ProxyAuthScheme: the authentication method the Cloud uses when authenticating to the proxy server.
• ProxyUser: the username of a user account registered with the proxy server.
• ProxyPassword: the password associated with the ProxyUser.

Other Proxies

Set the following properties:

• To use a proxy-based firewall, set FirewallType, FirewallServer, and FirewallPort.
• To tunnel the connection, set FirewallType to TUNNEL.
• To authenticate, specify FirewallUser and FirewallPassword.
• To authenticate to a SOCKS proxy, additionally set FirewallType to SOCKS5.

The CData Cloud models PCA Sales objects as relational tables and views. A PCA Sales object has relationships to other objects; in the tables, these relationships are expressed through foreign keys. The following sections show the available API objects and provide more information on executing SQL to PCA Sales APIs.

Schemas for most database objects are defined in simple, text-based configuration files.

The Cloud models the data in PCA Sales as a list of tables in a relational database that can be queried using standard SQL statements.

CData Cloud - PCA Sales Tables

Name	Description
InputFRI	Usage information for the operation InputFRI.rsd.
InputFRID	Usage information for the operation InputFRID.rsd.
InputHAC	Usage information for the operation InputHAC.rsd.
InputHACD	Usage information for the operation InputHACD.rsd.
InputHACZ	Usage information for the operation InputHACZ.rsd.
InputJUC	Usage information for the operation InputJUC.rsd.
InputJUCD	Usage information for the operation InputJUCD.rsd.
InputJUCZ	Usage information for the operation InputJUCZ.rsd.
InputKNS	Usage information for the operation InputKNS.rsd.
InputMIT	Usage information for the operation InputMIT.rsd.
InputMITD	Usage information for the operation InputMITD.rsd.
InputMITZ	Usage information for the operation InputMITZ.rsd.
InputNKN	Usage information for the operation InputNKN.rsd.
InputNYK	Usage information for the operation InputNYK.rsd.
InputNYKD	Usage information for the operation InputNYKD.rsd.
InputNYKZ	Usage information for the operation InputNYKZ.rsd.
InputSKN	Usage information for the operation InputSKN.rsd.
InputSYK	Usage information for the operation InputSYK.rsd.
InputSYKD	Usage information for the operation InputSYKD.rsd.
InputSYKZ	Usage information for the operation InputSYKZ.rsd.
InputTEH	Usage information for the operation InputTEH.rsd.
InputURI	Usage information for the operation InputURI.rsd.
InputURID	Usage information for the operation InputURID.rsd.
MasterBumon	Usage information for the operation MasterBumon.rsd.
MasterDms	Usage information for the operation MasterDms.rsd.
MasterLot	Usage information for the operation MasterLot.rsd.
MasterPard	Usage information for the operation MasterPard.rsd.
MasterPart	Usage information for the operation MasterPart.rsd.
MasterProject	Usage information for the operation MasterProject.rsd.
MasterRms	Usage information for the operation MasterRms.rsd.
MasterSet	Usage information for the operation MasterSet.rsd.
MasterSetd	Usage information for the operation MasterSetd.rsd.
MasterShimebi	Usage information for the operation MasterShimebi.rsd.
MasterShiresakiKubun	Usage information for the operation MasterShiresakiKubun.rsd.
MasterSms	Usage information for the operation MasterSms.rsd.
MasterSmst	Usage information for the operation MasterSmst.rsd.
MasterSoko	Usage information for the operation MasterSoko.rsd.
MasterSyohinKubun	Usage information for the operation MasterSyohinKubun.rsd.
MasterTantosya	Usage information for the operation MasterTantosya.rsd.
MasterTekiyo	Usage information for the operation MasterTekiyo.rsd.
MasterTms	Usage information for the operation MasterTms.rsd.
MasterTokuisakiKubun	Usage information for the operation MasterTokuisakiKubun.rsd.
MasterXms	Usage information for the operation MasterXms.rsd.
MasterYms	Usage information for the operation MasterYms.rsd.

Usage information for the operation InputFRI.rsd.

Columns

Name	Type	ReadOnly	Description
BEVersion	Int	False
State	Int	True
InputFRIH	String	False
InputFRIDList	String	False
UpdateLastDenpyoNo	String	False
InputFRIH_Id [KEY]	Int	False
InputFRIH_Furikaebi	Date	False
InputFRIH_DenpyoNo	Int	False
InputFRIH_SyukaSokoCode	String	False
InputFRIH_SyukaSokoMei	String	True
InputFRIH_NyukaSokoCode	String	False
InputFRIH_NyukaSokoMei	String	True
InputFRIH_TorokuUser	Int	True
InputFRIH_TorokuProgram	String	True
InputFRIH_Torokubi	Datetime	True
InputFRIH_KosinUser	Int	True
InputFRIH_KosinProgram	String	True
InputFRIH_Kosinbi	Datetime	True
InputFRIH_YobiShort1	Int	False
InputFRIH_YobiDecimal1	Decimal	False
InputFRIH_YobiString1	String	False
InputFRIH_YobiString2	String	False
InputFRIH_YobiString3	String	False
InputFRIH_SyoninFlag	Int	True
InputFRIH_SyoninUser	Int	True
InputFRIH_Syoninbi	Date	True

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
IdFrom	Int
IdTo	Int
SyukaSokoCodeFrom	String
SyukaSokoCodeTo	String
NyukaSokoCodeFrom	String
NyukaSokoCodeTo	String
FurikaebiFrom	Date
FurikaebiTo	Date
DenpyoNoFrom	Int
DenpyoNoTo	Int
SyohinCode	String
SyohinCodeFrom	String
SyohinCodeTo	String
SyohinMei	String
SyohinMei2	String
KikakuKataban	String
Color	String
Size	String
Biko	String
KosinbiFrom	Datetime
KosinbiTo	Datetime
OrderType	Int
Direction	Int
Irisu	Int
IrisuFrom	Int
IrisuTo	Int
Hakosu	Int
HakosuFrom	Int
HakosuTo	Int
Suryo	Int
SuryoFrom	Int
SuryoTo	Int
Tanka	Int
TankaFrom	Int
TankaTo	Int
Kingaku	Int
KingakuFrom	Int
KingakuTo	Int
LotNo	String
LotNoFrom	String
LotNoTo	String

Usage information for the operation InputFRID.rsd.

Columns

Name	Type	ReadOnly	Description
HeaderId [KEY]	Int	True
Sequence [KEY]	Int	False
Edaban	Int	True
SyohinCode	String	False
TankaKeta	Decimal	False
SuryoKeta	Decimal	False
SyohinMei	String	False
SyohinMei2	String	False
KikakuKataban	String	False
Color	String	False
Size	String	False
Irisu	Decimal	False
Hakosu	Decimal	False
Suryo	Decimal	False
Tani	String	False
Tanka	Decimal	False
Kingaku	Int	False
Biko	String	False
YobiShort1	Int	False
YobiInt1	Int	False
YobiDecimal1	Decimal	False
YobiString1	String	False
YobiString2	String	False
YobiString3	String	False
IrisuKeta	Decimal	False
HakosuKeta	Decimal	False
SuryoHasu	Int	True
LotId	Int	False
LotNo	String	True
LotYukoKigen	Date	True

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
Id	Int
IdFrom	Int
IdTo	Int
SyukaSokoCode	String
SyukaSokoCodeFrom	String
SyukaSokoCodeTo	String
NyukaSokoCode	String
NyukaSokoCodeFrom	String
NyukaSokoCodeTo	String
Furikaebi	Date
FurikaebiFrom	Date
FurikaebiTo	Date
DenpyoNo	Int
DenpyoNoFrom	Int
DenpyoNoTo	Int
SyohinCodeFrom	String
SyohinCodeTo	String
SyoninFlag	Int
KosinUser	Int
KosinbiFrom	Datetime
KosinbiTo	Datetime
OrderType	Int
Direction	Int
IrisuFrom	Int
IrisuTo	Int
HakosuFrom	Int
HakosuTo	Int
SuryoFrom	Int
SuryoTo	Int
TankaFrom	Int
TankaTo	Int
KingakuFrom	Int
KingakuTo	Int
LotNoFrom	String
LotNoTo	String

Usage information for the operation InputHAC.rsd.

Columns

Name	Type	ReadOnly	Description
BEVersion	Int	False
State	Int	True
BumonLockType	Int	True
InputHACH	String	False
InputHACDList	String	False
InputHACZList	String	False
InputHACT	String	False
InputHACC	String	False
UpdateLastDenpyoNo	String	False
InputHACH_Id [KEY]	Int	False
InputHACH_Hachubi	Date	False
InputHACH_Noki	Date	False
InputHACH_ChumonNo	Int	False
InputHACH_HachusakiCode	String	False
InputHACH_AitesakiId	Int	True
InputHACH_HachusakiMei1	String	False
InputHACH_HachusakiMei2	String	False
InputHACH_Jyusyo1	String	False
InputHACH_Jyusyo2	String	False
InputHACH_YubinBango	String	False
InputHACH_TelNo	String	False
InputHACH_FAXNo	String	False
InputHACH_Keisyo	String	False
InputHACH_MailAddress	String	False
InputHACH_HachusakiHojinBango	String	False
InputHACH_ZeiKansan	Int	True
InputHACH_KingakuHasu	Int	True
InputHACH_SyohizeiHasu	Int	True
InputHACH_SyohizeiTsuchi	Int	True
InputHACH_ShiharaisakiCode	String	True
InputHACH_SpotAitesakiId	Int	False
InputHACH_SenpoTantosyaId	Int	False
InputHACH_SenpoTantosyaMei	String	False
InputHACH_BumonCode	String	False
InputHACH_BumonMei	String	True
InputHACH_BumonSoko	String	True
InputHACH_TantosyaCode	String	False
InputHACH_TantosyaMei	String	True
InputHACH_TekiyoCode	String	False
InputHACH_Tekiyo	String	False
InputHACH_ProCode	String	False
InputHACH_ProMei	String	True
InputHACH_ChokusosakiFlag	Int	False
InputHACH_ChokusosakiCode	String	False
InputHACH_ChokusosakiMei1	String	False
InputHACH_ChokusosakiMei2	String	False
InputHACH_ChokusosakiJyusyo1	String	False
InputHACH_ChokusosakiJyusyo2	String	False
InputHACH_ChokusosakiYubinBango	String	False
InputHACH_ChokusosakiTelNo	String	False
InputHACH_ChokusosakiFAXNo	String	False
InputHACH_ChokusosakiKeisyo	String	False
InputHACH_ChokusosakiMailAddress	String	False
InputHACH_ChokusosakiHojinBango	String	False
InputHACH_SpotChokusoAitesakiId	Int	False
InputHACH_ChokusosakiTantosyaId	Int	False
InputHACH_ChokusosakiTantosyaMei	String	False
InputHACH_ChumonNo2	String	False
InputHACH_HachuHoho	Int	True
InputHACH_TehaiId	Int	True
InputHACH_TehaiNo	Int	True
InputHACH_TehaiEdaban	Int	True
InputHACH_FusenComment	Int	False
InputHACH_TorokuUser	Int	True
InputHACH_TorokuProgram	String	True
InputHACH_Torokubi	Datetime	True
InputHACH_KosinUser	Int	True
InputHACH_KosinProgram	String	True
InputHACH_Kosinbi	Datetime	True
InputHACH_YobiShort2	Int	False
InputHACH_YobiShort3	Int	False
InputHACH_YobiInt2	Int	False
InputHACH_YobiDecimal1	Decimal	False
InputHACH_YobiDecimal2	Decimal	False
InputHACH_YobiDecimal3	Decimal	False
InputHACH_YobiString1	String	False
InputHACH_YobiString2	String	False
InputHACH_YobiString3	String	False
InputHACH_SyoninFlag	Int	True
InputHACH_SyoninUser	Int	True
InputHACH_Syoninbi	Date	True
InputHACT_HeaderId	Int	True
InputHACT_KingakuGokei	Int	False
InputHACT_SotoZeiGokei	Int	False
InputHACT_UchiZeiGokei	Int	False
InputHACC_HeaderId	Int	True
InputHACC_FusenString	String	False
InputFusen_BEVersion	Int	False
InputFusen_Id	Int	False
InputFusen_FusenComment	Int	False
InputFusen_FusenString	String	False
InputFusen_Kosinbi	Datetime	True
InputFusen_Comment	String	True
InputHACH_HachusakiJigyosyaBango	String	False	Ordering Company Business Registration No. The filter will work on BEVersion=500.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
IdFrom	Int
IdTo	Int
HachubiFrom	Date
HachubiTo	Date
ChumonNoFrom	Int
ChumonNoTo	Int
HachusakiCodeFrom	String
HachusakiCodeTo	String
HachusakiMei	String
SyohinCode	String
SyohinCodeFrom	String
SyohinCodeTo	String
SyohinMei	String
SyohinMei2	String
ProCodeFrom	String
ProCodeTo	String
TantosyaCodeFrom	String
TantosyaCodeTo	String
BumonCodeFrom	String
BumonCodeTo	String
TekiyoCodeFrom	String
TekiyoCodeTo	String
KikakuKataban	String
Color	String
Size	String
Biko	String
FusenCommentFlag	Int
KosinbiFrom	Datetime
KosinbiTo	Datetime
OrderType	Int
Direction	Int
NokiFrom	Date
NokiTo	Date
ShiresakiKubun1	String
ShiresakiKubun1From	String
ShiresakiKubun1To	String
ShiresakiKubun2	String
ShiresakiKubun2From	String
ShiresakiKubun2To	String
ShiresakiKubun3	String
ShiresakiKubun3From	String
ShiresakiKubun3To	String
ShiresakiKubun4	String
ShiresakiKubun4From	String
ShiresakiKubun4To	String
ShiresakiKubun5	String
ShiresakiKubun5From	String
ShiresakiKubun5To	String
ChokusosakiCodeFrom	String
ChokusosakiCodeTo	String
ChokusosakiMei	String
ChokusoTokuisakiCode	String
ChokusoTokuisakiCodeFrom	String
ChokusoTokuisakiCodeTo	String
ChokusoTokuisakiMei	String
ChokusoTokuisakiHojinBango	String
SokoCode	String
SokoCodeFrom	String
SokoCodeTo	String
Irisu	Int
IrisuFrom	Int
IrisuTo	Int
Hakosu	Int
HakosuFrom	Int
HakosuTo	Int
Suryo	Int
SuryoFrom	Int
SuryoTo	Int
Tanka	Int
TankaFrom	Int
TankaTo	Int
Kingaku	Int
KingakuFrom	Int
KingakuTo	Int
SyohinKomoku1	Int
SyohinKomoku1From	Int
SyohinKomoku1To	Int
SyohinKomoku2	Int
SyohinKomoku2From	Int
SyohinKomoku2To	Int
SyohinKomoku3	Int
SyohinKomoku3From	Int
SyohinKomoku3To	Int
ShireKomoku1	Int
ShireKomoku1From	Int
ShireKomoku1To	Int
ShireKomoku2	Int
ShireKomoku2From	Int
ShireKomoku2To	Int
ShireKomoku3	Int
ShireKomoku3From	Int
ShireKomoku3To	Int
NyukazumiFlag	Int
ZeiRitsu	Int
TaniKubunFlag	Int
BumonOutputType	Int
BumonGroupCode	String

Usage information for the operation InputHACD.rsd.

Columns

Name	Type	ReadOnly	Description
HeaderId [KEY]	Int	True
Sequence [KEY]	Int	False
Edaban	Int	True
SyohinCode	String	False
MasterKubun	Int	False
TaniKubun	Int	False
ZeiKubun	Int	False
ZeikomiKubun	Int	False
TankaKeta	Decimal	False
SuryoKeta	Decimal	False
SyohinMei	String	False
SyohinMei2	String	False
KikakuKataban	String	False
Color	String	False
Size	String	False
SokoCode	String	False
Irisu	Decimal	False
Hakosu	Decimal	False
Suryo	Decimal	False
Tani	String	False
Tanka	Decimal	False
Kingaku	Int	False
Biko	String	False
HyojunShireTanka	Int	False
ZeiRitsu	Int	False
SotoZeigaku	Int	False
UchiZeigaku	Int	False
SyokanKeisan	Int	False
SyohinKomoku1	Decimal	False
SyohinKomoku2	Decimal	False
SyohinKomoku3	Decimal	False
ShireKomoku1	Decimal	False
ShireKomoku2	Decimal	False
ShireKomoku3	Decimal	False
NyukazumiFlag	Int	True
NyukaRuikei	Decimal	True
HikiateJuchuNo	Int	True
KoseiSuryo	Decimal	True
Hitsuyosu	Decimal	True
YobiShort1	Int	False
YobiShort2	Int	False
YobiShort3	Int	False
YobiInt1	Int	False
YobiInt2	Int	False
YobiInt3	Int	False
YobiDecimal1	Decimal	False
YobiDecimal2	Decimal	False
YobiDecimal3	Decimal	False
YobiString1	String	False
YobiString2	String	False
YobiString3	String	False
IrisuKeta	Decimal	False
HakosuKeta	Decimal	False
SuryoHasu	Int	True
Noki	Date	False
BaraSuryo	Decimal	True
BaraNyukaRuikei	Decimal	True
ShireZeiSyubetsu	Int	True

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
BEVersion	Int
Id	Int
IdFrom	Int
IdTo	Int
Hachubi	Date
HachubiFrom	Date
HachubiTo	Date
ChumonNo	Int
ChumonNoFrom	Int
ChumonNoTo	Int
HachusakiCode	String
HachusakiCodeFrom	String
HachusakiCodeTo	String
HachusakiMei	String
HachusakiHojinBango	String
SyohinCodeFrom	String
SyohinCodeTo	String
ChumonNo2	String
ProCode	String
ProCodeFrom	String
ProCodeTo	String
ProMei	String
SenpoTantosyaMei	String
TantosyaCode	String
TantosyaCodeFrom	String
TantosyaCodeTo	String
BumonCode	String
BumonCodeFrom	String
BumonCodeTo	String
TekiyoCode	String
TekiyoCodeFrom	String
TekiyoCodeTo	String
Tekiyo	String
FusenCommentFlag	Int
SyoninFlag	Int
KosinUser	Int
KosinbiFrom	Datetime
KosinbiTo	Datetime
OrderType	Int
Direction	Int
NokiFrom	Date
NokiTo	Date
ShiresakiKubun1	String
ShiresakiKubun1From	String
ShiresakiKubun1To	String
ShiresakiKubun2	String
ShiresakiKubun2From	String
ShiresakiKubun2To	String
ShiresakiKubun3	String
ShiresakiKubun3From	String
ShiresakiKubun3To	String
ShiresakiKubun4	String
ShiresakiKubun4From	String
ShiresakiKubun4To	String
ShiresakiKubun5	String
ShiresakiKubun5From	String
ShiresakiKubun5To	String
ChokusosakiCode	String
ChokusosakiCodeFrom	String
ChokusosakiCodeTo	String
ChokusosakiMei	String
ChokusosakiHojinBango	String
ChokusoTokuisakiCode	String
ChokusoTokuisakiCodeFrom	String
ChokusoTokuisakiCodeTo	String
ChokusoTokuisakiMei	String
ChokusoTokuisakiHojinBango	String
SokoCodeFrom	String
SokoCodeTo	String
IrisuFrom	Int
IrisuTo	Int
HakosuFrom	Int
HakosuTo	Int
SuryoFrom	Int
SuryoTo	Int
TankaFrom	Int
TankaTo	Int
KingakuFrom	Int
KingakuTo	Int
SyohinKomoku1From	Int
SyohinKomoku1To	Int
SyohinKomoku2From	Int
SyohinKomoku2To	Int
SyohinKomoku3From	Int
SyohinKomoku3To	Int
ShireKomoku1From	Int
ShireKomoku1To	Int
ShireKomoku2From	Int
ShireKomoku2To	Int
ShireKomoku3From	Int
ShireKomoku3To	Int
TaniKubunFlag	Int
BumonOutputType	Int
BumonGroupCode	String

Usage information for the operation InputHACZ.rsd.

Columns

Name	Type	ReadOnly	Description
HeaderId [KEY]	Int	True
ZeiRitsu [KEY]	Int	False
KingakuGokei	Int	False
SotoZeiGokei	Int	False
UchiZeiGokei	Int	False

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
BEVersion	Int
Id	Int
IdFrom	Int
IdTo	Int
Hachubi	Date
HachubiFrom	Date
HachubiTo	Date
ChumonNo	Int
ChumonNoFrom	Int
ChumonNoTo	Int
HachusakiCode	String
HachusakiCodeFrom	String
HachusakiCodeTo	String
HachusakiMei	String
HachusakiHojinBango	String
SyohinCode	String
SyohinCodeFrom	String
SyohinCodeTo	String
SyohinMei	String
SyohinMei2	String
ChumonNo2	String
ProCode	String
ProCodeFrom	String
ProCodeTo	String
ProMei	String
SenpoTantosyaMei	String
TantosyaCode	String
TantosyaCodeFrom	String
TantosyaCodeTo	String
BumonCode	String
BumonCodeFrom	String
BumonCodeTo	String
TekiyoCode	String
TekiyoCodeFrom	String
TekiyoCodeTo	String
Tekiyo	String
KikakuKataban	String
Color	String
Size	String
Biko	String
FusenCommentFlag	Int
SyoninFlag	Int
KosinUser	Int
KosinbiFrom	Datetime
KosinbiTo	Datetime
OrderType	Int
Direction	Int
Noki	Date
NokiFrom	Date
NokiTo	Date
ShiresakiKubun1	String
ShiresakiKubun1From	String
ShiresakiKubun1To	String
ShiresakiKubun2	String
ShiresakiKubun2From	String
ShiresakiKubun2To	String
ShiresakiKubun3	String
ShiresakiKubun3From	String
ShiresakiKubun3To	String
ShiresakiKubun4	String
ShiresakiKubun4From	String
ShiresakiKubun4To	String
ShiresakiKubun5	String
ShiresakiKubun5From	String
ShiresakiKubun5To	String
ChokusosakiCode	String
ChokusosakiCodeFrom	String
ChokusosakiCodeTo	String
ChokusosakiMei	String
ChokusosakiHojinBango	String
ChokusoTokuisakiCode	String
ChokusoTokuisakiCodeFrom	String
ChokusoTokuisakiCodeTo	String
ChokusoTokuisakiMei	String
ChokusoTokuisakiHojinBango	String
SokoCode	String
SokoCodeFrom	String
SokoCodeTo	String
Irisu	Int
IrisuFrom	Int
IrisuTo	Int
Hakosu	Int
HakosuFrom	Int
HakosuTo	Int
Suryo	Int
SuryoFrom	Int
SuryoTo	Int
Tanka	Int
TankaFrom	Int
TankaTo	Int
Kingaku	Int
KingakuFrom	Int
KingakuTo	Int
SyohinKomoku1	Int
SyohinKomoku1From	Int
SyohinKomoku1To	Int
SyohinKomoku2	Int
SyohinKomoku2From	Int
SyohinKomoku2To	Int
SyohinKomoku3	Int
SyohinKomoku3From	Int
SyohinKomoku3To	Int
ShireKomoku1	Int
ShireKomoku1From	Int
ShireKomoku1To	Int
ShireKomoku2	Int
ShireKomoku2From	Int
ShireKomoku2To	Int
ShireKomoku3	Int
ShireKomoku3From	Int
ShireKomoku3To	Int
NyukazumiFlag	Int
TaniKubunFlag	Int
BumonOutputType	Int
BumonGroupCode	String

Usage information for the operation InputJUC.rsd.

Columns

Name	Type	ReadOnly	Description
BEVersion	Int	False
State	Int	True
BumonLockType	Int	True
InputJUCH	String	False
InputJUCDList	String	False
InputJUCZList	String	False
InputJUCT	String	False
InputJUCC	String	False
UpdateLastDenpyoNo	String	False
InputJUCH_Id [KEY]	Int	False
InputJUCH_Juchubi	Date	False
InputJUCH_Noki	Date	False
InputJUCH_JuchuNo	Int	False
InputJUCH_TokuisakiCode	String	False
InputJUCH_AitesakiId	Int	True
InputJUCH_TokuisakiMei1	String	False
InputJUCH_TokuisakiMei2	String	False
InputJUCH_Jyusyo1	String	False
InputJUCH_Jyusyo2	String	False
InputJUCH_YubinBango	String	False
InputJUCH_TelNo	String	False
InputJUCH_FAXNo	String	False
InputJUCH_Keisyo	String	False
InputJUCH_MailAddress	String	False
InputJUCH_TokuisakiHojinBango	String	False
InputJUCH_TekiyoBaikaNo	Int	True
InputJUCH_Kakeritsu	Decimal	True
InputJUCH_ZeiKansan	Int	True
InputJUCH_KingakuHasu	Int	True
InputJUCH_SyohizeiHasu	Int	True
InputJUCH_SyohizeiTsuchi	Int	True
InputJUCH_BaiTankaKansan	Int	True
InputJUCH_StoreTorihikisakiCode	String	True
InputJUCH_SeikyusakiCode	String	True
InputJUCH_MitsumoriNo	Int	False
InputJUCH_SpotAitesakiId	Int	False
InputJUCH_SenpoTantosyaId	Int	False
InputJUCH_SenpoTantosyaMei	String	False
InputJUCH_BumonCode	String	False
InputJUCH_BumonMei	String	True
InputJUCH_BumonSoko	String	True
InputJUCH_TantosyaCode	String	False
InputJUCH_TantosyaMei	String	True
InputJUCH_TekiyoCode	String	False
InputJUCH_Tekiyo	String	False
InputJUCH_ProCode	String	False
InputJUCH_ProMei	String	True
InputJUCH_ChokusosakiCode	String	False
InputJUCH_ChokusosakiMei1	String	False
InputJUCH_ChokusosakiMei2	String	False
InputJUCH_ChokusosakiJyusyo1	String	False
InputJUCH_ChokusosakiJyusyo2	String	False
InputJUCH_ChokusosakiYubinBango	String	False
InputJUCH_ChokusosakiTelNo	String	False
InputJUCH_ChokusosakiFAXNo	String	False
InputJUCH_ChokusosakiKeisyo	String	False
InputJUCH_ChokusosakiMailAddress	String	False
InputJUCH_ChokusosakiHojinBango	String	False
InputJUCH_ChokusosakiTantosyaMei	String	False
InputJUCH_SpotChokusoAitesakiId	Int	False
InputJUCH_JuchuNo2	String	False
InputJUCH_FusenComment	Int	False
InputJUCH_TorokuUser	Int	True
InputJUCH_TorokuProgram	String	True
InputJUCH_Torokubi	Datetime	True
InputJUCH_KosinUser	Int	True
InputJUCH_KosinProgram	String	True
InputJUCH_Kosinbi	Datetime	True
InputJUCH_YobiShort1	Int	False
InputJUCH_YobiShort2	Int	False
InputJUCH_YobiShort3	Int	False
InputJUCH_YobiInt1	Int	False
InputJUCH_YobiInt2	Int	False
InputJUCH_YobiDecimal1	Decimal	False
InputJUCH_YobiDecimal2	Decimal	False
InputJUCH_YobiDecimal3	Decimal	False
InputJUCH_YobiString1	String	False
InputJUCH_YobiString2	String	False
InputJUCH_YobiString3	String	False
InputJUCH_SyoninFlag	Int	True
InputJUCH_SyoninUser	Int	True
InputJUCH_Syoninbi	Date	True
InputJUCT_HeaderId	Int	True
InputJUCT_KingakuGokei	Int	False
InputJUCT_SotoZeiGokei	Int	False
InputJUCT_UchiZeiGokei	Int	False
InputJUCC_HeaderId	Int	True
InputJUCC_FusenString	String	False
InputFusen_BEVersion	Int	False
InputFusen_Id	Int	False
InputFusen_FusenComment	Int	False
InputFusen_FusenString	String	False
InputFusen_Kosinbi	Datetime	True
InputFusen_Comment	String	True
InputJUCH_TokuisakiJigyosyaBango	String	False	Customer Business Registration No. The filter will work on BEVersion=500.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
IdFrom	Int
IdTo	Int
JuchubiFrom	Date
JuchubiTo	Date
JuchuNoFrom	Int
JuchuNoTo	Int
TokuisakiCodeFrom	String
TokuisakiCodeTo	String
TokuisakiMei	String
SyohinCode	String
SyohinCodeFrom	String
SyohinCodeTo	String
SyohinMei	String
SyohinMei2	String
ProCodeFrom	String
ProCodeTo	String
TantosyaCodeFrom	String
TantosyaCodeTo	String
BumonCodeFrom	String
BumonCodeTo	String
TekiyoCodeFrom	String
TekiyoCodeTo	String
KikakuKataban	String
Color	String
Size	String
Biko	String
FusenCommentFlag	Int
KosinbiFrom	Datetime
KosinbiTo	Datetime
OrderType	Int
Direction	Int
NokiFrom	Date
NokiTo	Date
TokuisakiKubun1	String
TokuisakiKubun1From	String
TokuisakiKubun1To	String
TokuisakiKubun2	String
TokuisakiKubun2From	String
TokuisakiKubun2To	String
TokuisakiKubun3	String
TokuisakiKubun3From	String
TokuisakiKubun3To	String
TokuisakiKubun4	String
TokuisakiKubun4From	String
TokuisakiKubun4To	String
TokuisakiKubun5	String
TokuisakiKubun5From	String
TokuisakiKubun5To	String
MitsumoriNoFrom	Int
MitsumoriNoTo	Int
ChokusosakiCodeFrom	String
ChokusosakiCodeTo	String
ChokusosakiMei	String
SokoCode	String
SokoCodeFrom	String
SokoCodeTo	String
Irisu	Int
IrisuFrom	Int
IrisuTo	Int
Hakosu	Int
HakosuFrom	Int
HakosuTo	Int
Suryo	Int
SuryoFrom	Int
SuryoTo	Int
Tanka	Int
TankaFrom	Int
TankaTo	Int
GenTanka	Int
GenTankaFrom	Int
GenTankaTo	Int
BaiTanka	Int
BaiTankaFrom	Int
BaiTankaTo	Int
Kingaku	Int
KingakuFrom	Int
KingakuTo	Int
Genka	Int
GenkaFrom	Int
GenkaTo	Int
BaikaKingaku	Int
BaikaKingakuFrom	Int
BaikaKingakuTo	Int
SyohinKomoku1	Int
SyohinKomoku1From	Int
SyohinKomoku1To	Int
SyohinKomoku2	Int
SyohinKomoku2From	Int
SyohinKomoku2To	Int
SyohinKomoku3	Int
SyohinKomoku3From	Int
SyohinKomoku3To	Int
UriageKomoku1	Int
UriageKomoku1From	Int
UriageKomoku1To	Int
UriageKomoku2	Int
UriageKomoku2From	Int
UriageKomoku2To	Int
UriageKomoku3	Int
UriageKomoku3From	Int
UriageKomoku3To	Int
SyukazumiFlag	Int
ZeiRitsu	Int
TaniKubunFlag	Int
LotNo	String
LotNoFrom	String
LotNoTo	String
BumonOutputType	Int
BumonGroupCode	String

Usage information for the operation InputJUCD.rsd.

Columns

Name	Type	ReadOnly	Description
HeaderId [KEY]	Int	True
Sequence [KEY]	Int	False
Edaban	Int	True
SyohinCode	String	False
MasterKubun	Int	False
TaniKubun	Int	False
ZeiKubun	Int	False
ZeikomiKubun	Int	False
TankaKeta	Decimal	False
SuryoKeta	Decimal	False
SyohinMei	String	False
SyohinMei2	String	False
KikakuKataban	String	False
Color	String	False
Size	String	False
SokoCode	String	False
Irisu	Decimal	False
Hakosu	Decimal	False
Suryo	Decimal	False
Tani	String	False
Tanka	Decimal	False
GenTanka	Int	False
BaiTanka	Decimal	False
Kingaku	Int	False
Genka	Int	False
BaikaKingaku	Int	False
Ararieki	Int	False
RiekiRitsu	Decimal	True
Biko	String	False
HachuMark	Int	False
HyojunKakaku	Int	False
HyojunKakaku2	Int	False
ZeiRitsu	Int	False
SotoZeigaku	Int	False
UchiZeigaku	Int	False
SyokonKeisan	Int	False
SyohinKomoku1	Decimal	False
SyohinKomoku2	Decimal	False
SyohinKomoku3	Decimal	False
UriageKomoku1	Decimal	False
UriageKomoku2	Decimal	False
UriageKomoku3	Decimal	False
SyukazumiFlag	Int	True
SyukaRuikei	Decimal	True
YobiShort1	Int	False
YobiShort2	Int	False
YobiShort3	Int	False
YobiInt1	Int	False
YobiInt2	Int	False
YobiInt3	Int	False
YobiDecimal1	Decimal	False
YobiDecimal2	Decimal	False
YobiDecimal3	Decimal	False
YobiString1	String	False
YobiString2	String	False
YobiString3	String	False
IrisuKeta	Decimal	False
HakosuKeta	Decimal	False
SuryoHasu	Int	True
Noki	Date	False
BaraSuryo	Decimal	True
BaraSyukaRuikei	Decimal	True
LotId	Int	False
LotNo	String	True
LotYukoKigen	Date	True
HachuzumiFlag	Int	True

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
BEVersion	Int
Id	Int
IdFrom	Int
IdTo	Int
Juchubi	Date
JuchubiFrom	Date
JuchubiTo	Date
JuchuNo	Int
JuchuNoFrom	Int
JuchuNoTo	Int
TokuisakiCode	String
TokuisakiCodeFrom	String
TokuisakiCodeTo	String
TokuisakiMei	String
TokuisakiHojinBango	String
SyohinCodeFrom	String
SyohinCodeTo	String
JuchuNo2	String
ProCode	String
ProCodeFrom	String
ProCodeTo	String
ProMei	String
SenpoTantosyaMei	String
TantosyaCode	String
TantosyaCodeFrom	String
TantosyaCodeTo	String
BumonCode	String
BumonCodeFrom	String
BumonCodeTo	String
TekiyoCode	String
TekiyoCodeFrom	String
TekiyoCodeTo	String
Tekiyo	String
FusenCommentFlag	Int
SyoninFlag	Int
KosinUser	Int
KosinbiFrom	Datetime
KosinbiTo	Datetime
OrderType	Int
Direction	Int
NokiFrom	Date
NokiTo	Date
TokuisakiKubun1	String
TokuisakiKubun1From	String
TokuisakiKubun1To	String
TokuisakiKubun2	String
TokuisakiKubun2From	String
TokuisakiKubun2To	String
TokuisakiKubun3	String
TokuisakiKubun3From	String
TokuisakiKubun3To	String
TokuisakiKubun4	String
TokuisakiKubun4From	String
TokuisakiKubun4To	String
TokuisakiKubun5	String
TokuisakiKubun5From	String
TokuisakiKubun5To	String
MitsumoriNo	Int
MitsumoriNoFrom	Int
MitsumoriNoTo	Int
ChokusosakiCode	String
ChokusosakiCodeFrom	String
ChokusosakiCodeTo	String
ChokusosakiMei	String
ChokusosakiHojinBango	String
SokoCodeFrom	String
SokoCodeTo	String
IrisuFrom	Int
IrisuTo	Int
HakosuFrom	Int
HakosuTo	Int
SuryoFrom	Int
SuryoTo	Int
TankaFrom	Int
TankaTo	Int
GenTankaFrom	Int
GenTankaTo	Int
BaiTankaFrom	Int
BaiTankaTo	Int
KingakuFrom	Int
KingakuTo	Int
GenkaFrom	Int
GenkaTo	Int
BaikaKingakuFrom	Int
BaikaKingakuTo	Int
SyohinKomoku1From	Int
SyohinKomoku1To	Int
SyohinKomoku2From	Int
SyohinKomoku2To	Int
SyohinKomoku3From	Int
SyohinKomoku3To	Int
UriageKomoku1From	Int
UriageKomoku1To	Int
UriageKomoku2From	Int
UriageKomoku2To	Int
UriageKomoku3From	Int
UriageKomoku3To	Int
TaniKubunFlag	Int
LotNoFrom	String
LotNoTo	String
BumonOutputType	Int
BumonGroupCode	String

Usage information for the operation InputJUCZ.rsd.

Columns

Name	Type	ReadOnly	Description
HeaderId [KEY]	Int	True
ZeiRitsu [KEY]	Int	False
KingakuGokei	Int	False
SotoZeiGokei	Int	False
UchiZeiGokei	Int	False

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
BEVersion	Int
Id	Int
IdFrom	Int
IdTo	Int
Juchubi	Date
JuchubiFrom	Date
JuchubiTo	Date
JuchuNo	Int
JuchuNoFrom	Int
JuchuNoTo	Int
TokuisakiCode	String
TokuisakiCodeFrom	String
TokuisakiCodeTo	String
TokuisakiMei	String
TokuisakiHojinBango	String
SyohinCode	String
SyohinCodeFrom	String
SyohinCodeTo	String
SyohinMei	String
SyohinMei2	String
JuchuNo2	String
ProCode	String
ProCodeFrom	String
ProCodeTo	String
ProMei	String
SenpoTantosyaMei	String
TantosyaCode	String
TantosyaCodeFrom	String
TantosyaCodeTo	String
BumonCode	String
BumonCodeFrom	String
BumonCodeTo	String
TekiyoCode	String
TekiyoCodeFrom	String
TekiyoCodeTo	String
Tekiyo	String
KikakuKataban	String
Color	String
Size	String
Biko	String
FusenCommentFlag	Int
SyoninFlag	Int
KosinUser	Int
KosinbiFrom	Datetime
KosinbiTo	Datetime
OrderType	Int
Direction	Int
Noki	Date
NokiFrom	Date
NokiTo	Date
TokuisakiKubun1	String
TokuisakiKubun1From	String
TokuisakiKubun1To	String
TokuisakiKubun2	String
TokuisakiKubun2From	String
TokuisakiKubun2To	String
TokuisakiKubun3	String
TokuisakiKubun3From	String
TokuisakiKubun3To	String
TokuisakiKubun4	String
TokuisakiKubun4From	String
TokuisakiKubun4To	String
TokuisakiKubun5	String
TokuisakiKubun5From	String
TokuisakiKubun5To	String
MitsumoriNo	Int
MitsumoriNoFrom	Int
MitsumoriNoTo	Int
ChokusosakiCode	String
ChokusosakiCodeFrom	String
ChokusosakiCodeTo	String
ChokusosakiMei	String
ChokusosakiHojinBango	String
SokoCode	String
SokoCodeFrom	String
SokoCodeTo	String
Irisu	Int
IrisuFrom	Int
IrisuTo	Int
Hakosu	Int
HakosuFrom	Int
HakosuTo	Int
Suryo	Int
SuryoFrom	Int
SuryoTo	Int
Tanka	Int
TankaFrom	Int
TankaTo	Int
GenTanka	Int
GenTankaFrom	Int
GenTankaTo	Int
BaiTanka	Int
BaiTankaFrom	Int
BaiTankaTo	Int
Kingaku	Int
KingakuFrom	Int
KingakuTo	Int
Genka	Int
GenkaFrom	Int
GenkaTo	Int
BaikaKingaku	Int
BaikaKingakuFrom	Int
BaikaKingakuTo	Int
SyohinKomoku1	Int
SyohinKomoku1From	Int
SyohinKomoku1To	Int
SyohinKomoku2	Int
SyohinKomoku2From	Int
SyohinKomoku2To	Int
SyohinKomoku3	Int
SyohinKomoku3From	Int
SyohinKomoku3To	Int
UriageKomoku1	Int
UriageKomoku1From	Int
UriageKomoku1To	Int
UriageKomoku2	Int
UriageKomoku2From	Int
UriageKomoku2To	Int
UriageKomoku3	Int
UriageKomoku3From	Int
UriageKomoku3To	Int
SyukazumiFlag	Int
TaniKubunFlag	Int
LotNo	String
LotNoFrom	String
LotNoTo	String
BumonOutputType	Int
BumonGroupCode	String