RO_BULK_SUM_HST(SQL Table) |
Index Back |
|---|---|
Bulk Order SummaryRecord containing the bulk order summary information. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | CAPTURE_ID |
Character(20) | VARCHAR2(20) NOT NULL | Field use to store the capture ID in order capture. |
| 4 | UID20 |
Character(20) | VARCHAR2(20) NOT NULL | This field is for UID of 20 characters long. |
| 5 | BO_ID_SOLD | Number(31,0) | DECIMAL(31) NOT NULL | Sole To Business Object ID |
| 6 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 7 | CAPTURE_ID_REL | Character(20) | VARCHAR2(20) NOT NULL | This field stores relative capture IDs. |
| 8 | RBTACCTTYPE | Character(4) | VARCHAR2(4) NOT NULL |
Determines the type of Billing Account.
IND=Individual Account NSUB=Parent Account PRE=Prepaid Account SPNR=Sponsored Account SPON=Sponsoring Account SUB=Subordinate Account |
| 9 | RBTACCTID | Character(15) | VARCHAR2(15) NOT NULL |
Unique service account indentifier
Prompt Table: RBT_CUSREPAC_VW |
| 10 | BO_REL_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Relationship ID of a Business Object |
| 11 | STATUS_CODE | Number(5,0) | INTEGER NOT NULL |
Status Code
Default Value: 300 Prompt Table: RO_DEFN_HDSTAT |