Retail Integration Bus Mappings Report Release:13.1.1

(Retail Merchandising System)

 

 

 

 

Application

Retail Merchandising System

Target Name Space

http://www.oracle.com/retail/integration/base/bo/GLCOADesc/v1

Version

1.0

Description

This is root element of this document which contains name space definitions for the document elements.

 

XML-Schema Name:GLCOADesc

Version:13.1.1

Return to Top

 

Tag Name

Type

Min Occurs

Max Occurs

Description

rms Mapping For GLCOADesc

Table Name

Column Name

API Type

Column Length

API Required

API Description

primary_account

varchar225

1

1

This denotes the primary account for a chart of accounts.

fif_gl_acct

primary_account

null

null

Yes

This denotes the primary account for a chart of accounts.

attribute1

varchar225

0

1

Secondary Account information. A value is required if description1 is supplied.

fif_gl_acct

attribute1

null

null

No

Secondary Account information. A value is required if description1 is supplied.

attribute2

varchar225

0

1

Secondary Account information. A value is required if description2 is supplied.

fif_gl_acct

attribute2

null

null

No

Secondary Account information. A value is required if description2 is supplied.

attribute3

varchar225

0

1

Secondary Account information. A value is required if description3 is supplied.

fif_gl_acct

attribute3

null

null

No

Secondary Account information. A value is required if description3 is supplied.

attribute4

varchar225

0

1

Secondary Account information. A value is required if description4 is supplied.

fif_gl_acct

attribute4

null

null

No

Secondary Account information. A value is required if description4 is supplied.

attribute5

varchar225

0

1

Secondary Account information. A value is required if description5 is supplied.

fif_gl_acct

attribute5

null

null

No

Secondary Account information. A value is required if description5 is supplied.

attribute6

varchar225

0

1

Secondary Account information. A value is required if description6 is supplied.

fif_gl_acct

attribute6

null

null

No

Secondary Account information. A value is required if description6 is supplied.

attribute7

varchar225

0

1

Secondary Account information. A value is required if description7 is supplied.

fif_gl_acct

attribute7

null

null

No

Secondary Account information. A value is required if description7 is supplied.

attribute8

varchar225

0

1

Secondary Account information. A value is required if description8 is supplied.

fif_gl_acct

attribute8

null

null

No

Secondary Account information. A value is required if description8 is supplied.

attribute9

varchar225

0

1

Secondary Account information. A value is required if description9 is supplied.

fif_gl_acct

attribute9

null

null

No

Secondary Account information. A value is required if description9 is supplied.

attribute10

varchar225

0

1

Secondary Account information. A value is required if description10 is supplied.

fif_gl_acct

attribute10

null

null

No

Secondary Account information. A value is required if description10 is supplied.

attribute11

varchar225

0

1

Secondary Account information. A value is required if description11 is supplied.

fif_gl_acct

attribute11

null

null

No

Secondary Account information. A value is required if description11 is supplied.

attribute12

varchar225

0

1

Secondary Account information. A value is required if description12 is supplied.

fif_gl_acct

attribute12

null

null

No

Secondary Account information. A value is required if description12 is supplied.

attribute13

varchar225

0

1

Secondary Account information. A value is required if description13 is supplied.

fif_gl_acct

attribute13

null

null

No

Secondary Account information. A value is required if description13 is supplied.

attribute14

varchar225

0

1

Secondary Account information. A value is required if description14 is supplied.

fif_gl_acct

attribute14

null

null

No

Secondary Account information. A value is required if description14 is supplied.

attribute15

varchar225

0

1

Secondary Account information. A value is required if description15 is supplied.

fif_gl_acct

attribute15

null

null

No

Secondary Account information. A value is required if description15 is supplied.

description1

varchar250

0

1

Description of the attribute1 field. Required if attribute1 supplied and you are not using Oracle Financials 11.5.10 or greater.

fif_gl_acct

description1

null

null

No

Description of the attribute1 field. Required if attribute1 supplied and you are not using Oracle Financials 11.5.10 or greater.

description2

varchar250

0

1

Description of the attribute2 field. Required if attribute2 supplied and you are not using Oracle Financials 11.5.10 or greater.

fif_gl_acct

description2

null

null

No

Description of the attribute2 field. Required if attribute2 supplied and you are not using Oracle Financials 11.5.10 or greater.

description3

varchar250

0

1

Description of the attribute3 field. Required if attribute3 supplied and you are not using Oracle Financials 11.5.10 or greater.

fif_gl_acct

description3

null

null

No

Description of the attribute3 field. Required if attribute3 supplied and you are not using Oracle Financials 11.5.10 or greater.

description4

varchar250

0

1

Description of the attribute4 field. Required if attribute4 supplied and you are not using Oracle Financials 11.5.10 or greater.

fif_gl_acct

description4

null

null

No

Description of the attribute4 field. Required if attribute4 supplied and you are not using Oracle Financials 11.5.10 or greater.

description5

varchar250

0

1

Description of the attribute5 field. Required if attribute5 supplied and you are not using Oracle Financials 11.5.10 or greater.

fif_gl_acct

description5

null

null

No

Description of the attribute5 field. Required if attribute5 supplied and you are not using Oracle Financials 11.5.10 or greater.

description6

varchar250

0

1

Description of the attribute6 field. Required if attribute6 supplied and you are not using Oracle Financials 11.5.10 or greater.

fif_gl_acct

description6

null

null

No

Description of the attribute6 field. Required if attribute6 supplied and you are not using Oracle Financials 11.5.10 or greater.

description7

varchar250

0

1

Description of the attribute7 field. Required if attribute7 supplied and you are not using Oracle Financials 11.5.10 or greater.

fif_gl_acct

description7

null

null

No

Description of the attribute7 field. Required if attribute7 supplied and you are not using Oracle Financials 11.5.10 or greater.

description8

varchar250

0

1

Description of the attribute8 field. Required if attribute8 supplied and you are not using Oracle Financials 11.5.10 or greater.

fif_gl_acct

description8

null

null

No

Description of the attribute8 field. Required if attribute8 supplied and you are not using Oracle Financials 11.5.10 or greater.

description9

varchar250

0

1

Description of the attribute9 field. Required if attribute9 supplied and you are not using Oracle Financials 11.5.10 or greater.

fif_gl_acct

description9

null

null

No

Description of the attribute9 field. Required if attribute9 supplied and you are not using Oracle Financials 11.5.10 or greater.

description10

varchar250

0

1

Description of the attribute10 field. Required if attribute10 supplied and you are not using Oracle Financials 11.5.10 or greater.

fif_gl_acct

description10

null

null

No

Description of the attribute10 field. Required if attribute10 supplied and you are not using Oracle Financials 11.5.10 or greater.

description11

varchar250

0

1

Description of the attribute11 field. Required if attribute11 supplied and you are not using Oracle Financials 11.5.10 or greater.

fif_gl_acct

description11

null

null

No

Description of the attribute11 field. Required if attribute11 supplied and you are not using Oracle Financials 11.5.10 or greater.

description12

varchar250

0

1

Description of the attribute12 field. Required if attribute12 supplied and you are not using Oracle Financials 11.5.10 or greater.

fif_gl_acct

description12

null

null

No

Description of the attribute12 field. Required if attribute12 supplied and you are not using Oracle Financials 11.5.10 or greater.

description13

varchar250

0

1

Description of the attribute13 field. Required if attribute13 supplied and you are not using Oracle Financials 11.5.10 or greater.

fif_gl_acct

description13

null

null

No

Description of the attribute13 field. Required if attribute13 supplied and you are not using Oracle Financials 11.5.10 or greater.

description14

varchar250

0

1

Description of the attribute14 field. Required if attribute14 supplied and you are not using Oracle Financials 11.5.10 or greater

fif_gl_acct

description14

null

null

No

Description of the attribute14 field. Required if attribute14 supplied and you are not using Oracle Financials 11.5.10 or greater

description15

varchar250

0

1

Description of the attribute15 field. Required if attribute15 supplied and you are not using Oracle Financials 11.5.10 or greater.

fif_gl_acct

description15

null

null

No

Description of the attribute15 field. Required if attribute15 supplied and you are not using Oracle Financials 11.5.10 or greater.

set_of_books_id

number15

0

1

Description is not available.

*

*

null

null

No

*

ExtOfGLCOADesc:ExtOfGLCOADesc

*

0

1

Provide an extension hook to customize GLCOADesc.

NA

NA

NA

NA

NA

NA



XML-Schema Name:ExtOfGLCOADesc

Version:13.1.1

Return to Top

 

Tag Name

Type

Min Occurs

Max Occurs

Description

rms Mapping For ExtOfGLCOADesc

Table Name

Column Name

API Type

Column Length

API Required

API Description