![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
||
Previous | Next | Contents | Index | Library |
Region ID | ICX_PO_REQ_HEAD_SUM_R |
Object Name | ICX_PO_REQ_HEADERS_O |
Database Object | ICX_PO_REQ_HEADERS_V |
Attribute Name | View Column |
---|---|
ICX_CANCELLED_DSP | CANCEL_DSP |
ICX_CLOSED_CODE | CLOSED_CODE_DSP |
ICX_CREATION_DATE | CREATION_DATE |
ICX_CURRENCY | CURRENCY_CODE |
ICX_DESC | DESCRIPTION |
ICX_PREPARER_NAME | PREPARER_NAME |
ICX_REQ_NUM | REQUISITION_NUM |
ICX_STATUS | AUTHORIZATION_STATUS_DSP |
ICX_TOTAL | REQ_HEADER_AMOUNT |
ICX_TYPE | TYPE_LOOKUP_CODE |
ICX_PREPARER_ID | PREPARER_ID |
ICX_REQ_HEADER_ID | REQUISITION_HEADER_ID |
ATTRIBUTE1 | ATTRIBUTE1 |
ATTRIBUTE2 | ATTRIBUTE2 |
ATTRIBUTE3 | ATTRIBUTE3 |
ATTRIBUTE4 | ATTRIBUTE4 |
ATTRIBUTE5 | ATTRIBUTE5 |
ATTRIBUTE6 | ATTRIBUTE6 |
ATTRIBUTE7 | ATTRIBUTE7 |
ATTRIBUTE8 | ATTRIBUTE8 |
ATTRIBUTE9 | ATTRIBUTE9 |
ATTRIBUTE10 | ATTRIBUTE10 |
ATTRIBUTE11 | ATTRIBUTE11 |
ATTRIBUTE12 | ATTRIBUTE12 |
ATTRIBUTE13 | ATTRIBUTE13 |
ATTRIBUTE14 | ATTRIBUTE14 |
ATTRIBUTE15 | ATTRIBUTE15 |
ICX_CLOSED_CODE | CLOSED_CODE_DSP |
Table 1 - 8. (Page 2 of 2) |
Attribute | Long Label | Display Sequence | Type | Item Style | Display | Update | Required | Queryable |
---|---|---|---|---|---|---|---|---|
ICX_REQ_HEADER_ID | Req Header ID | 1 | O | Hidden | No | No | No | No |
ICX_COPY | Copy Req | 5 | A | Image | Yes | No | No | No |
ICX_REQ_NUM | Number | 10 | O | Text | Yes | No | No | Yes |
ICX_CREATION_DATE | Creation Date | 15 | O | Text | Yes | No | No | Yes |
ICX_CURRENCY | Currency | 20 | O | Text | Yes | No | No | No |
ICX_TOTAL | Total | 25 | O | Text | Yes | No | No | No |
ICX_CLOSED_CODE | Closed | 35 | O | Text | Yes | No | No | No |
ICX_STATUS | Status | 40 | O | Text | Yes | No | No | No |
ICX_PREPARER_NAME | Preparer | 45 | O | Text | Yes | No | No | Yes |
ICX_PREPARER_ID | Preparer ID | 50 | O | Text | No | No | No | No |
Table 1 - 9. (Page 2 of 2) |
Region ID | ICX_PO_REQ_HEAD_DTL_R |
Object Name | ICX_PO_REQ_HEADERS_O |
Database Object Name | ICX_PO_REQ_HEADERS_V |
Attribute | Long Label | Display Sequence | Type | Item Style | Display | Update | Required | Queryable |
---|---|---|---|---|---|---|---|---|
ICX_REQ_NUM | Number | 10 | O | Text | Yes | No | No | No |
ICX_CREATION_DATE | Creation Date | 15 | O | Text | Yes | No | No | No |
ICX_CURRENCY | Currency | 20 | O | Text | Yes | No | No | No |
ICX_TOTAL | Total | 25 | O | Text | Yes | No | No | No |
ICX_CLOSED_CODE | Closed | 35 | O | Text | Yes | No | No | No |
ICX_CANCELLED_DSP | Cancelled | 40 | O | Text | Yes | No | No | No |
ICX_DESC | Description | 45 | O | Text | Yes | No | No | No |
ICX_STATUS | Status | 50 | O | Text | Yes | No | No | No |
ICX_PREPARER_NAME | Preparer | 55 | O | Text | Yes | No | No | No |
ICX_TYPE | Type | 60 | O | Text | No | No | No | No |
Table 1 - 10. (Page 2 of 2) |
Region ID | ICX_PO_REQ_LINES_R |
Object Name | ICX_PO_REQ_LINES_O |
Database Object | ICX_PO_REQ_LINES_V |
Attribute | Long Label | Display Sequence | Type | Item Style | Display | Update | Required | Queryable |
---|---|---|---|---|---|---|---|---|
ICX_LINE | Line | 10 | O | Text | Yes | No | No | No |
ICX_ITEM | Item Number | 15 | O | Text | Yes | No | No | No |
ICX_DESC | Description | 25 | O | Text | Yes | No | No | No |
ICX_PRICE | Price | 30 | O | Text | Yes | No | No | No |
ICX_UOM | Unit of Measure | 35 | O | Text | Yes | No | No | No |
ICX_QTY | Quantity | 40 | O | Text | Yes | No | No | No |
ICX_QTY_DELIVERED | Qty Delivered | 45 | O | Text | Yes | No | No | No |
ICX_REQ_DATE | Requested Date | 50 | O | Text | Yes | No | No | No |
ICX_CANCEL_FLAG | Cancelled | 55 | O | Text | Yes | No | No | No |
ICX_CANCEL_REASON | Cancel Reason | 60 | O | Text | Yes | No | No | No |
ICX_REQUESTOR | Requestor | 65 | O | Text | Yes | No | No | No |
ICX_DELIVER_TO_LOCATION | Deliver-To Location | 70 | O | Text | Yes | No | No | No |
ICX_BUYER | Buyer | 75 | O | Text | Yes | No | No | No |
ICX_ORDER_NUM | Order Number | 80 | O | Text | Yes | No | No | No |
ICX_SUPPLIER | Supplier | 85 | O | Text | Yes | No | No | No |
ICX_ITEM_URL | Item URL | 90 | O | Text | Yes | No | No | No |
ICX_SUPPLIER_URL | Supplier URL | 95 | O | Text | Yes | No | No | No |
Table 1 - 11. (Page 2 of 2) |
ICX_CART_LINE_ACCOUNT_HEADER_R | |
ICX_CART_LINE_ACCOUNT_HEADER_O | |
ICX_CART_LINE_ACCOUNT_HEADER_V |
Attibute Code | Column Name | Node Display | Update Flag | Item Style | Oracle Default | Oracla Validate | List of Values |
---|---|---|---|---|---|---|---|
ICX_REQ_NUM | REQUISITION_NUMBER | Yes | No | Text | NA | NA | NA |
ICX_CART_LINE_NUM | CART_LINE_NUMBER | Yes | No | Text | NA | NA | NA |
ICX_ITEM_DESCRIPTION | ITEM_DESCRIPTION | Yes | No | Text | NA | NA | NA |
ICX_QTY | QUANTITY | Yes | No | Text | NA | NA | NA |
ICX_UNIT_PRICE | UNIT_PRICE | Yes | No | Text | NA | NA | NA |
ICX_EXT_PRICE | EXT_PRICE | Yes | No | Text | NA | NA | NA |
Table 1 - 12. (Page 1 of 1) |
Region ID | ICX_CART_LINE_DISTRIBUTIONS_R |
Object Name | ICX_CART_LINE_DISTRIBUTIONS_O |
Database Object | ICX_CART_LINE_DISTRIBUTIONS_V |
Attibute Code | Column Name | Node Display | Update Flag | Item Style | Oracle Default | Oracla Validate | List of Values |
---|---|---|---|---|---|---|---|
ICX_DISTRIBUTION_ID | DISTRIBUTION_ID | No | No | Hidden | NA | NA | NA |
ICX_DISTRIBUTION_NUM | DISTRIBUTION_NUM | Yes | No | Text | NA | NA | NA |
ICX_CHARGE_ACCOUNT_NUM | CHARGE_ACCOUNT_NUM | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG1 | CHARGE_ACCOUNT_SEGMENT1 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG2 | CHARGE_ACCOUNT_SEGMENT2 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG3 | CHARGE_ACCOUNT_SEGMENT3 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG4 | CHARGE_ACCOUNT_SEGMENT4 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG5 | CHARGE_ACCOUNT_SEGMENT5 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG6 | CHARGE_ACCOUNT_SEGMENT6 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG7 | CHARGE_ACCOUNT_SEGMENT7 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG8 | CHARGE_ACCOUNT_SEGMENT8 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG9 | CHARGE_ACCOUNT_SEGMENT9 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG10 | CHARGE_ACCOUNT_SEGMENT10 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG11 | CHARGE_ACCOUNT_SEGMENT11 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG12 | CHARGE_ACCOUNT_SEGMENT12 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG13 | CHARGE_ACCOUNT_SEGMENT13 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG14 | CHARGE_ACCOUNT_SEGMENT14 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG15 | CHARGE_ACCOUNT_SEGMENT15 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG16 | CHARGE_ACCOUNT_SEGMENT16 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG17 | CHARGE_ACCOUNT_SEGMENT17 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG18 | CHARGE_ACCOUNT_SEGMENT18 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG19 | CHARGE_ACCOUNT_SEGMENT19 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG20 | CHARGE_ACCOUNT_SEGMENT20 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG21 | CHARGE_ACCOUNT_SEGMENT21 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG22 | CHARGE_ACCOUNT_SEGMENT22 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG23 | CHARGE_ACCOUNT_SEGMENT23 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG24 | CHARGE_ACCOUNT_SEGMENT24 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG25 | CHARGE_ACCOUNT_SEGMENT25 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG26 | CHARGE_ACCOUNT_SEGMENT26 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG27 | CHARGE_ACCOUNT_SEGMENT27 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG28 | CHARGE_ACCOUNT_SEGMENT28 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG29 | CHARGE_ACCOUNT_SEGMENT29 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG30 | CHARGE_ACCOUNT_SEGMENT30 | No | No | Text | NA | NA | NA |
ICX_PERCENTAGE | ALLOCATION_VALUE | No | No | Text | NA | NA | NA |
ICX_AMOUNT | ALLOCATION_QUANTITY | No | No | Text | NA | NA | NA |
Table 1 - 13. (Page 3 of 3) |
Region ID | ICX_REQ_DIST_HEADER_R |
Object Name | ICX_REQ_DIST_HEADER_O |
Database Object | ICX_REQ_HEADER_V |
Attibute Code | Column Name | Node Display | Update Flag | Item Style | Oracle Default | Oracla Validate | List of Values |
---|---|---|---|---|---|---|---|
ICX_REQ_NUM | REQUISITION_NUMBER | Yes | No | Text | NA | NA | NA |
ICX_CART_LINE_NUM | CART_LINE_NUMBER | Yes | No | Text | NA | NA | NA |
ICX_ITEM_DESCRIPTION | ITEM_DESCRIPTION | Yes | No | Text | NA | NA | NA |
ICX_QTY | QUANTITY | Yes | No | Text | NA | NA | NA |
ICX_UNIT_PRICE | UNIT_PRICE | Yes | No | Text | NA | NA | NA |
ICX_EXT_PRICE | EXT_PRICE | Yes | No | Text | NA | NA | NA |
Table 1 - 14. (Page 2 of 2) |
Region ID | ICX_REQ_DIST_UPDATE_R |
Object Name | ICX_REQ_DIST_UPDATE_O |
Database Object | ICX_REQ_DIST_UPDATE_V |
Attibute Code | Column Name | Node Display | Update Flag | Item Style | Oracle Default | Oracla Validate | List of Values |
---|---|---|---|---|---|---|---|
ICX_DISTRIBUTION_ID | DISTRIBUTION_ID | No | No | Hidden | NA | NA | NA |
ICX_DISTRIBUTION_NUM | DISTRIBUTION_NUM | Yes | No | Text | NA | NA | NA |
ICX_CHARGE_ACCOUNT_NUM | CHARGE_ACCOUNT_NUM | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG1 | CHARGE_ACCOUNT_SEGMENT1 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG2 | CHARGE_ACCOUNT_SEGMENT2 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG3 | CHARGE_ACCOUNT_SEGMENT3 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG4 | CHARGE_ACCOUNT_SEGMENT4 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG5 | CHARGE_ACCOUNT_SEGMENT5 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG6 | CHARGE_ACCOUNT_SEGMENT6 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG7 | CHARGE_ACCOUNT_SEGMENT7 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG8 | CHARGE_ACCOUNT_SEGMENT8 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG9 | CHARGE_ACCOUNT_SEGMENT9 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG10 | CHARGE_ACCOUNT_SEGMENT10 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG11 | CHARGE_ACCOUNT_SEGMENT11 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG12 | CHARGE_ACCOUNT_SEGMENT12 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG13 | CHARGE_ACCOUNT_SEGMENT13 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG14 | CHARGE_ACCOUNT_SEGMENT14 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG15 | CHARGE_ACCOUNT_SEGMENT15 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG16 | CHARGE_ACCOUNT_SEGMENT16 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG17 | CHARGE_ACCOUNT_SEGMENT17 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG18 | CHARGE_ACCOUNT_SEGMENT18 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG19 | CHARGE_ACCOUNT_SEGMENT19 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG20 | CHARGE_ACCOUNT_SEGMENT20 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG21 | CHARGE_ACCOUNT_SEGMENT21 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG22 | CHARGE_ACCOUNT_SEGMENT22 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG23 | CHARGE_ACCOUNT_SEGMENT23 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG24 | CHARGE_ACCOUNT_SEGMENT24 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG25 | CHARGE_ACCOUNT_SEGMENT25 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG26 | CHARGE_ACCOUNT_SEGMENT26 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG27 | CHARGE_ACCOUNT_SEGMENT27 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG28 | CHARGE_ACCOUNT_SEGMENT28 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG29 | CHARGE_ACCOUNT_SEGMENT29 | No | No | Text | NA | NA | NA |
ICX_CHARGE_ACCT_SEG30 | CHARGE_ACCOUNT_SEGMENT30 | No | No | Text | NA | NA | NA |
ICX_PERCENTAGE | ALLOCATION_VALUE | No | No | Text | NA | NA | NA |
ICX_AMOUNT | ALLOCATION_QUANTITY | No | No | Text | NA | NA | NA |
Table 1 - 15. (Page 3 of 3) |
Note: The enabling accounting at the line level and at the account distribution level are mutually exclusive. That is, only one can be enabled at any point of time.
Note: Changing the configurations from concatenated segments to individual segments, or vice versa, will create corrupt data, especially for saved requisitions. Oracle recommends you not change the configuration once it is set. However, making any number of segments as the default is still supported as long the system is originally configured for individual segments.
Previous | Next | Contents | Index | Library |