Understanding the Bill Data Structure
To understand the bill data structure, you must understand PeopleSoft Billing transactional data models and how the data is stored in the main PeopleSoft Billing tables. This table lists bill data structure details:
Table |
Keys |
Relationship |
---|---|---|
Bill Header table (BI_HDR) |
BUSINESS_UNIT INVOICE |
Parent table. |
Bill Header AR Accounting Distribution (bill header accounts receivable accounting distribution) table (BI_HDR_AR) |
BUSINESS_UNIT INVOICE SEQ_NUM |
Bill header has one AR accounting distribution entry. SEQ_NUM always equals one. |
Bill Header (bill header value-added tax) table (BI_HDR) |
BUSINESS_UNIT INVOICE |
Bill header has zero or one header entry. |
Bill Header Credit Card table (BI_HDR_CRCARD) |
BUSINESS_UNIT INVOICE SEQ_NUM |
Bill header has zero or one Credit Card header entry. |
Bill Header Note table (BI_HDR_NOTE) |
BUSINESS_UNIT INVOICE NOTES_SEQ_NUM |
Bill header has zero or more header notes. |
Invoice Carbon (or Courtesy) Copy Address (BI_HDR_CC) |
BUSINESS_UNIT INVOICE SEQ_NUM |
Invoice has zero or more carbon copy address entries. The Billing interface does not support carbon copy functionality. |
Bill Line table (BI_LINE) |
BUSINESS_UNIT INVOICE LINE_SEQ_NUM |
Bill header has one or more bill lines. |
Bill Line Tax table (BI_LINE_TAX) |
BUSINESS_UNIT INVOICE LINE_SEQ_NUM |
Bill line has zero or one bill line tax entry. |
Bill Line Tax Detail table (BI_LINE_TAX_DTL) |
BUSINESS_UNIT INVOICE LINE_SEQ_NUM TAX_AUTHORITY_CD SEQ_NBR_5 |
Bill line has zero or more tax detail entries. (These entries are not created by the Billing interface for full bill credit and bill line adjustments). |
Bill Line Excise, Sales Tax, or VAT Detail table BI_LINE_EXS_DTL |
BUSINESS_UNIT INVOICE LINE_SEQ_NUM EXS_TAX_TYPE EXS_TAX_RATE_SEQ |
Bill line has zero or more tax detail entries. |
Bill Line Note table (BI_LINE_NOTE) |
BUSINESS_UNIT INVOICE LINE_SEQ_NUM NOTES_SEQ_NUM |
Bill line has zero or more bill line notes. |
Bill Line Accounting Entries table (BI_LINE_DST) |
BUSINESS_UNIT INVOICE LINE_SEQ_NUM LINE_DST_SEQ_NUM |
Bill line has zero or more accounting entries for regular revenue. |
Bill Line Unbilled-AR Accounting Entries (bill line unbilled-accounts-receivable accounting entries) table (BI_LINE_DST_) |
BUSINESS_UNIT INVOICE LINE_SEQ_NUM LINE_DST_SEQ_NUM |
Bill line has zero or one accounts-unbilled-receivable entries. |
Bill Line AR Accounting Entries (bill line accounts receivable accounting entries) table (BI_LINE_DST_AR) |
BUSINESS_UNIT INVOICE LINE_SEQ_NUM LINE_DST_SEQ_NUM |
Bill line has zero or one accounts receivable offset entries. |
Bill Line Deferred Accounting Entries table (BI_LINE_DST_DFR) |
BUSINESS_UNIT INVOICE LINE_SEQ_NUM LINE_DST_SEQ_NUM |
Bill line has zero or more accounting entries for contract liability. |
Bill Line Deferred Accounting Entries table (BI_LINE_DST_STA) |
BUSINESS_UNIT INVOICE LINE_SEQ_NUM LINE_DST_SEQ_NUM |
Bill line has zero or more statistical accounting entries. |
Bill Line InterUnit Payables table (BI_LINE_IU_PAY) |
BUSINESS_UNIT INVOICE LINE_SEQ_NUM LINE_DST_SEQ_NUM |
Bill line has zero or one InterUnit payables entries. |
Bill Line InterUnit Expenses table (BI_LINE_IU_EXP) |
BUSINESS_UNIT INVOICE LINE_SEQ_NUM LINE_DST_SEQ_NUM |
Bill line has zero or one InterUnit expense entries. |
Bill Line Discount/Surcharge Level table (BI_LINE_DS_LVL) |
BUSINESS_UNIT INVOICE LINE_SEQ_NUM DISC_SUR_LVL |
Bill line has zero or more discount or surcharge levels. |
Bill Line Discount/Surcharge Detail table (BI_LINE_DS_DTL) |
BUSINESS_UNIT INVOICE LINE_SEQ_NUM DISC_SUR_LVL DISC_SUR_ID |
Bill line discount or surcharge level has one or more discount or surcharge details, each related to one discount or surcharge level. |
Bill Line Deferred Discount/Surcharge Detail table (BI_LINE_DS_DFR) |
BUSINESS_UNIT INVOICE LINE_SEQ_NUM DISC_SUR_LVL DISC_SUR_ID |
Bill line discount or surcharge level has one or more deferred discount or surcharge details, each related to one discount or surcharge detail. |