DW_NS_InvoiceGroup_D
This table contains the details about the invoice groups created for consolidated invoice processing.
Details
Module:
Key Columns
id
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | Internal ID | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. This is source record id column. | ||||
| account | NUMBER | 38 | 0 | Account | DW_NS_account_D | id | |
| billaddress | NUMBER | 38 | 0 | Bill To Select | DW_NS_entityAddressbook_D | internalid | |
| customer | NUMBER | 38 | 0 | Customer | DW_NS_customer_D | id | |
| duedate | TIMESTAMP | Due Date | |||||
| groupedbypo | VARCHAR2 | 16 | Grouped By PO # | ||||
| invoicegroupnumber | VARCHAR2 | 32 | Invoice Group Number | ||||
| lastmodifiedby | NUMBER | 38 | 0 | Modified By | DW_NS_entity_D | id | |
| lastmodifieddate | TIMESTAMP | Last Modified | |||||
| memo | VARCHAR2 | 999 | Memo | ||||
| ponumber | VARCHAR2 | 128 | PO # | ||||
| status | VARCHAR2 | 64 | Status | DW_NS_invoiceGroupStatus_D | id | ||
| subsidiary | NUMBER | 38 | 0 | Subsidiary | DW_NS_subsidiary_D | id | |
| terms | NUMBER | 38 | 0 | Terms | DW_NS_term_D | id | |
| trandate | TIMESTAMP | Date |