objid | period_amt | objid | Internal record number | 3 (UNIQUE) |
schedule_objid | contr_schedule | objid | Contr_schedule internal record number | |
bill_prd_amt | period_amt | bill_prd_amt | The amount billed | |
prd_start_dt | period_amt | prd_start_dt | The start date of the current billing period | |
prd_end_dt | period_amt | prd_end_dt | The last date of the current billing period | |
rec_type | period_amt | rec_type | Type of detail record: i.e., 1=Invoice, 2=credit memo, 3=debit memo | |
status | period_amt | status | Status of the record: i.e., 0=hold, 1=approved, 2=disapproved | |
pay_due_dt | period_amt | pay_due_dt | Date when payment is due; usually equals either prd_start_dt or prd_end_dt | |
last_gen_dt | period_amt | last_gen_dt | The date time that the object was generated. This corresponds to a run of the aggregator function | |
ref_start_dt | period_amt | ref_start_dt | The start date of the reference billing period | |
ref_end_dt | period_amt | ref_end_dt | The last date of the reference billing period | |
contract_id | period_amt | contract_id | Contract that is referred to by the requester. This is the contract or other type of agreement under requestor claims entitlement | |
schedule_id | period_amt | schedule_id | Contract schedule ID number | |
schedule_title | period_amt | schedule_title | Contract schedule short description | |
bill_group | period_amt | bill_group | Billing group. This is from a user-defined popup list with default name BILLING_GROUP | |
frequency | period_amt | frequency | Frequency of the billing: i.e., 0=annual, 1=semi-annual, 2=quarterly, 3=monthly, 4=one-time, default=0 | |
bill_option | period_amt | bill_option | Billing option; i.e., 1=in advance, 2=in arrears | |
item_start_dt | period_amt | item_start_dt | The starting date for the contract line item | |
item_end_dt | period_amt | item_end_dt | The ending date for the line item | |
due_offset | period_amt | due_offset | The number of days in advance of the expected payment date that determines the invoice date | |
cycle_start_dt | period_amt | cycle_start_dt | The starting date of the billing cycle. Used with schedule frequency to calculate the periodic 'as of' billing dates | |
line_no | period_amt | line_no | Sequential line number of parent lines. For child lines,=parent's p_line_no | |
svc_start_date | period_amt | svc_start_date | The starting date for the line item | |
svc_end_date | period_amt | svc_end_date | The ending date for the line item | |
chg_start_dt | period_amt | chg_start_dt | The date from which charges start to accrue | |
chg_end_dt | period_amt | chg_end_dt | The last date through which charges accrue | |
quantity | period_amt | quantity | Contracted/Quoted quantity of the part | |
pro_prc | period_amt | pro_prc | The prorated price of the item | |
net_prc | period_amt | net_prc | The price after all adjustments (price factors) have been applied | |
cov_site_id | period_amt | cov_site_id | The price after all adjustments (price factors) have been applied | |
part_num | period_amt | part_number | Part number/name | |
unit_measure | period_amt | unit_measure | Unit of measure for part number; e.g., roll, set, etc | |
serial_no | period_amt | serial_no | Installed part serial number | |
currency | period_amt | currency | Name of the currency | |
bill_to_site_id | period_amt | bill_to_site_id | Site ID of bill to site for the contract | |
po_id | period_amt | po_id | The unique purchase order ID | |
org_id | period_amt | org_id | User-specified ID number of the organization | |
create_dt | period_amt | create_dt | Date time the object was created | |
appl_id | period_amt | appl_id | Clarify application identifier | |
last_update | period_amt | last_update | Date time of last update to the corresponding contract item | |
first_bill_dt | period_amt | first_bill_dt | Date time billing started | |
extracted_dt | period_amt | extracted_dt | Date the item was extracted from the contract | |
extract_trk_id | period_amt | extract_trk_id | Identifier used to track the period amount object | |
status_dt | period_amt | status_dt | Date time of last status change of the corresponding contract item | |
arch_ind | period_amt | arch_ind | When set to 1, indicates the object is ready for purge/archive | |
gross_prd_amt | period_amt | gross_prd_amt | Contains the undiscounted value of the line | |
contr_itm_objid | period_amt | contr_itm_objid | Contr_itm internal record number | |