BUSINESS_UNITORDER_NOORD_HDR_PRINT(SQL Table) |
Index Back |
|---|---|
Order Print AcknowledgementRecords the time an order ack was printed, and how many times order acks have been printed |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ORDER_NO |
Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 3 | ORIG_ACK_PRINT_DT | DateTime(26) | TIMESTAMP | Original Acknowledgement Date |
| 4 | LAST_ACK_PRINT_DT | DateTime(26) | TIMESTAMP | Order Ack Print Date |
| 5 | ACK_PRINT_COUNT | Number(3,0) | SMALLINT NOT NULL | Order Ack Print Counter |